Skip to content
Clarity Partners
  • Our Capabilities
    • Application Development
    • Cloud Services
    • Content Services
    • Enterprise Performance Management
    • Management Consulting
    • Web Design & Development
  • Our Work
    • Case Studies
    • Clients
    • Technologies
    • Business Partners
  • Who We Are
    • Firm Overview
    • Leadership
    • Our Consultants
    • Awards
    • Community Engagement
    • Certifications & Contracts
    • 20 Years of Clarity
  • Firm Updates
    • Insights
    • News
    • Projects
  • Join Our Team
    • Benefits & Perks
    • Open Positions
    • Internships
  • Contact
Contact Us

Browse:

  • Home
  • Case Studies
  • Cook County Oracle Budgeting Implementation

Cook County Oracle Budgeting Implementation

Introduction

Cook County in Illinois is the second-most populous county in the United States. The county’s Enterprise Resource Planning (ERP) Office is tasked with implementing and supporting financial system projects to improve business operations county-wide. The ERP office contracted with IBM to implement the Strategic & Tactical Enterprise Processes (STEP) project, of which Clarity led Wave 2 of 4, “Budget Preparation & CAFR Reporting”. For more information on the county’s ERP office and the STEP project, visit the ERP web page.

Challenges

Cook County recognized that it’s financial practices and systems were outdated and inefficient, costing unnecessary time and resources across departments. The previous system:

  • Was homegrown and required updates to support budgeting and reporting needs
  • Required several weeks of preparation time to load & validate source system data
  • Made last-minute, on-the-fly system modifications extremely difficult
  • Required a major overhaul to integrate with new ERP system being implemented

The county produces several public books and reports annually, including two budget books composed of three volumes and over 1300 pages. All public books require text, pictures, graphs, reports, table of contents, appendix, and custom covers. The manual creation of these books was extremely time-consuming and labor-intensive.

Why Oracle Budgeting?

To meet the needs of the DBMS office, end-users and constituents, the county needed a world-class and dynamic financial planning, budgeting and reporting environment. The county requested the implementation of Oracle’s budgeting software, as part of the larger STEP project and integration with Oracle E-Business ERP Suite.

Implementation & Deployment

The Clarity and IBM team worked in tandem with DBMS to define best practices, modernize antiquated financial practices and standardize financial planning and analysis activities across Cook County. For the project’s first phase, Clarity installed and configured three environments (Development, QA and Production) of:

  • Oracle Public Sector Planning & Budgeting (PSPB)
  • Oracle Essbase
  • Oracle Hyperion Financial Management (HFM)
  • Oracle Financial Data Quality Management Enterprise Edition (FDMEE)
  • Oracle Data Integrator (ODI)

Clarity designed and developed a budgeting and reporting solution to include the following functionality:

  • Operational budget and forecasting (personnel and non-personnel)
  • Capital expense budgeting
  • Grant budgeting
  • Creation of annual public budget books
  • Creation of a Comprehensive Annual Financial Report (CAFR)
  • Revenue and expense modeling
  • Monthly financial reporting solution for the Cook County Health and Hospital System

Clarity also designed and developed all necessary data integrations between Oracle’s Hyperion EPM Suite and Oracle E-Business Suite utilizing ODI and FDMEE. Additionally, Clarity developed three Essbase Aggregate Storage applications for reporting and designed and developed approximately 180 reports for the county.

Benefits

  • Modern web-based system
  • Integration with the county-wide ERP system being implemented
  • Automated data integration between Oracle budgeting modules
  • Security driven access
  • Real-time end user reporting
  • Fully automated public budget books and CAFR

What’s Next

At the completion of the county’s four-phased STEP project, the Hyperion EPM Suite will integrate with the ERP system and continue to enhance efficiency and productivity of the county-wide budgeting and reporting process for years to come.

In the future, Cook County may consider implementing their strategic planning model into Oracle budgeting as well.

Download Full Case Study

  • Pages

    • Our Work
      • Case Studies
      • Clients
      • Technologies
      • Business Partners
    • Who We Are
      • Firm Overview
      • Leadership
        • David Namkung
        • Rod Zech
        • Scott Hilkert
        • Kelly Tetterton
        • Andrew Davis
        • Gemará Williams
        • Joshua Medina
      • Awards
      • Our Consultants
      • Community Engagement
      • Certifications & Contracts
        • State of Texas, DIR
      • 20 Years of Clarity Partners
    • A Chicago-based Management and Technology Consulting Firm
    • About Clarity
    • Our Capabilities
      • Application Development
      • Cloud Services
      • Content Services
      • Enterprise Performance Management
        • Clarity & Anaplan
        • Oracle & Clarity
      • Management Consulting
      • Web Design & Development
        • Web Design and Development Portfolio
    • Join Our Team
      • Benefits & Perks
      • Open Positions
      • Internships
    • Firm Updates
    • Contact
  • Archives

    • June 2025
    • April 2025
    • March 2025
    • January 2025
    • December 2024
    • November 2024
    • September 2024
    • May 2024
    • April 2024
    • March 2024
    • February 2024
    • December 2023
    • November 2023
    • October 2023
    • September 2023
    • August 2023
    • July 2023
    • June 2023
    • May 2023
    • April 2023
    • March 2023
    • February 2023
    • January 2023
    • December 2022
    • November 2022
    • October 2022
    • September 2022
    • July 2022
    • June 2022
    • May 2022
    • April 2022
    • January 2022
    • December 2021
    • November 2021
    • September 2021
    • June 2021
    • May 2021
    • April 2021
    • March 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • December 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • February 2016
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • December 2014
    • August 2014
    • June 2014
    • May 2014
    • April 2014
    • February 2014
    • January 2014
    • December 2013
    • September 2013
    • June 2013
    • February 2013
    • January 2013
  • Categories

    • Insights (19)
    • News (193)
    • Projects (42)

Site Footer

We would love to work with you!
Let's Work Together

Our Capabilities

  • Application Development
  • Cloud Services
  • Content Services
  • Enterprise Performance Management
  • Management Consulting
  • Web Design & Development

Our Work

  • Case Studies
  • Clients
  • Technologies
  • Business Partners

Who We Are

  • Firm Overview
  • Leadership
  • Our Consultants
  • Awards
  • Community Engagement
  • Certifications & Contracts
  • 20 Years of Clarity

Firm Updates

  • Insights
  • News
  • Projects

Join Our Team

Clarity Partners
20 North Clark Street, Suite 3600
Chicago, IL 60602
Phone (312) 920.0550
Fax (312) 920.0554

Follow Us

  • LinkedIn
  • Facebook
© 2025 Clarity Partners. All Rights Reserved.