Experience / Case Studies

Case Study: PG&E - Optimizing Billing and Meter Management with Oracle Utility Analytics

About Pacific Gas and Electric Company

PG&E is one of the largest utility providers in the US with over 20,000 employees and covering over 5.2 million households providing both electricity and natural gas to its customers. pg&e-logo

Business Needs

PG&E needed to retire its legacy data warehouse and reporting tools (including mainframe applications) and move to a modern BI architecture leveraging pre-built solutions to lower their cost of ownership. PG&E also needed to convert 215,000 legacy Brio reports to Oracle BI.

PG&E Case Study - Download PDF

Selection Criteria

PG&E evaluated many software solutions but selected Oracle Utility Analytics as it was a pre-built data warehouse for Oracle’s Customer Care and Billing (CC&B) solution to reduce cost, timeline and risk.

PG&E selected KPI Partners because of KPI’s deep expertise in Oracle BI and Oracle Utility Analytics and application maintenance with large volumes of data. Also, KPI’s BI Report Conversion Utilities could automate the conversion of 215,000 Brio reports.

What KPI Delivered

KPI delivered an Oracle Utility Analytics based solution that was extended to case management and six other data sources. The solution leveraged GoldenGate to ensure minimal performance impact on CC&B. KPI converted 215,000 Brio reports to Oracle BI using KPI’s Report Conversion Utilities.

Business Benefits

The new Oracle Utility Analytics data warehouse refreshed 3 times faster than the previous data warehouse. Users get their data the next day instead of waiting 2 days as in the past. This helps streamline the month end close process.

Retiring the mainframe reporting application lowered TCO and increased business agility.

Tags: Case Study, Oracle BI, Oracle Utility Analytics, Utilities, PG&E



Subscribe to the Case Studies