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

Browse:

  • Home
  • Case Studies
  • City of Chicago Oracle Budgeting Implementation

City of Chicago Oracle Budgeting Implementation

Introduction

The City of Chicago has over 35,000 employees and 45 major departments, with an annual budget exceeding $8.5 billion. The Office of Budget and Management (OBM) is responsible for preparing and implementing a balanced annual budget for the City. In addition, OBM evaluates the efficiency of all the City’s operations and drives management reforms when needed. For more information, visit the OBM website.

Challenges

The City previously employed a legacy budgeting system that had been developed in-house. This system was nearly 20 years old and built on a platform no longer supported by Oracle (Oracle Forms 6), and routine system upgrades increasingly threatened system performance. Furthermore, several new tools had been developed that could enhance the City’s budgeting processes (i.e. data validation and improved ad hoc analysis). As a result, the City requested an Oracle-supported solution that could more easily integrate with current and add-on technologies in the marketplace.

Project challenges included:

  • Dated budgeting tool and siloed budgeting processes
  • Decentralized data across departments
  • Inconsistent data management practices across departments
  • Time-consuming, labor intensive and manual processes
  • Users with limited exposure to multidimensional database

Why Hyperion?

The City requested an Oracle budgeting solution that could integrate with the following city systems:

  • Oracle E-Business Suite Financial Application modules
  • Oracle E-Business Suite Human Resources module
  • Oracle E-Business Suite Grants Accounting module
  • Oracle E-Business Suite Advanced Procurement modules

Implementation & Deployment

Clarity Partners leveraged our proven, flexible implementation methodology. We established the parameters for how the project would be conducted and managed. From requirements gathering to design, we identified and prioritized business and technical requirements for packaging into deliverables. Clarity developed a prototype that users could test and incorporated feedback into issue resolution.

The deployed solution includes:

  • Oracle’s Hyperion Public Sector Planning & Budgeting (PSPB)
  • Integration of information from legacy Finance and HR systems to centralize metadata and budget data
  • Customized analysis forms that improve data accuracy and completeness at both granular and summary levels

In addition to implementation, Clarity provided both admin and end user training.

Benefits

  • Developed grant budget to enable the City to more accurately measure time and attendance entries, yielding efficient grant spending
  • Provided more transparency into publicly consumed reporting
  • Created automated process for personnel cost allocation to multiple funding sources
  • Laid foundation to provide transparency on carryover balances
  • Modernized technology platform to enable ad hoc analysis, data integration and enhanced end user experience
  • Designed standardized hierarchical framework to improve reporting and analysis
  • Substantially reduced data cleansing by automating data and metadata integration

What’s Next

Clarity will provide the City of Chicago with continued application support.

Download Full Case Study

  • Pages

    • Our People
      • Leadership
        • David Namkung
        • Rod Zech
        • Scott Hilkert
        • Kelly Tetterton
        • Michael Cusick
        • Andrew Davis
        • Soo Choi
      • Our Consultants
    • Our Work
      • Case Studies
      • Clients
      • Technologies
      • Business Partners
    • Test Page
    • Web Design and Development Portfolio
    • Webinar: Transforming Planning for the Public Sector with Anaplan
    • A Chicago-based Management and Technology Consulting Firm
    • About Clarity
      • Firm Overview
      • Awards
      • Community Engagement
      • Certifications & Contracts
        • State of Texas, DIR
    • Capabilities
      • Application Development
      • Cloud Services
      • Content Services
      • Enterprise Performance Management
        • Anaplan & Clarity
        • Oracle & Clarity
      • Management Consulting
      • Web Design & Development
    • Join Our Team
      • Benefits & Perks
      • Open Positions
      • Internships
    • Firm Updates
    • Contact
  • Archives

    • 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

    • Events (19)
    • Insights (16)
    • News (81)
    • Projects (25)
    • Technology Consulting (4)
    • Workplace (60)

Site Footer

Contact Us Today

Capabilities

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

Our Work

  • Case Studies
  • Clients
  • Technologies
  • Business Partners

Our People

  • Leadership
  • Our Consultants

Firm Updates

  • Events
  • Insights
  • News
  • Projects
  • Workplace

About Clarity

  • Firm Overview
  • Awards
  • Community Engagement
  • Certifications & Contracts

Join Our Team

  • Benefits & Perks
  • Open Positions
  • Internships
20 North Clark Street, Suite 3600
Chicago, IL 60602
Phone (312) 920.0550
Fax (312) 920.0554
420 Throckmorton Street, Suite 200
Fort Worth, TX 76102

Follow Us

  • LinkedIn
  • Twitter
  • Facebook
© 2023 Clarity Partners. All Rights Reserved.