Case Studies

Retail Operational Reporting

Issue Our client, a retail electric provider, engaged MidDel Consulting to determine best course of action to improve reporting efficiency and operational business intelligence. MidDel was tasked to identify and build improved data integrations and reporting processes for use by key business areas. After review of current reporting and multiple process reviews, MidDel proposed a […]
View Details >>

Global Risk Reporting

Issue Our client desired a replacement for an aging and inflexible global risk reporting system, impacting offices in three countries, which would improve the daily reporting cycle and reduce the constant maintenance required by IT staff.   Solution Our consultant’s broad business acumen and technical skills lead to a strong design based on the client's […]
View Details >>

Natural Gas Liquid Modeling

Issue Our client had a growing NGL trading book that was modeled by the front office in spreadsheets, outside of its ETRM system. Since NGL deals were not captured in the client’s ETRM system, nor was it supported in the software “out of the box,” the mid office had no visibility into risk […]
View Details >>

OSIsoft PI Solutions - WECC Reporting

Issue Our client’s method of reporting planned and projected power generation data consisted of five spreadsheets with VBA code to extract data from various sources. Reporting was run on a daily basis and required a user to open each spreadsheet, enter data and run the report. A separate process sent the files to […]
View Details >>

Financial Performance & Planning Executive Dashboard

Issue As part of an initiative to improve the corporate reporting process, the client requested a KPI based dashboard providing O&M, capital, and HR information on a monthly basis. Due to the project’s high visibility among executives, the project incurred multiple requirement changes. Solution Our consultant, along with the […]
View Details >>

Meter to Mailbox Dashboard Project

Issue A large investor-owned utility, with multiple geographic and business unit operations, was utilizing Excel spreadsheet reports from over 30 separate data sources and measuring various business drivers from their customer facing operations. This client requested an automated and simplified visual display of trends and alerts for key customer facing business drivers. […]
View Details >>

Report Consolidation (Over 3,000)

Issue A Fortune 500 commodity trading client maintained over 3,000 various financial reports from its ETRM system. Many of the reports were redundant and some were inaccurate resulting in “multiple versions of the truth.” Due to the excessive number of reports, month-end close was taking longer than desired. The client requested to develop […]
View Details >>

Redundant and Incomplete Reports

Issue Our client had hundreds of reports under an old data model which was not meeting its business requirements. Many reports were either duplicates or unnecessary and without extensive report documentation. Report users were busy and needed assistance to revise the reporting framework. Solution Our consultant combined technical expertise […]
View Details >>

Improved Overnight Invoice Process

Issue This client’s primary invoicing report failed overnight several times per month. In addition, users could not perform basic invoicing operations in the invoice system GUI. Solution Our consultant had a thorough understanding of the client’s invoicing process and was able to modify the reports and application configurations to […]
View Details >>

Improved Nightly Batch Process

Issue Our client’s primary nightly batch process ran over two hours and occasionally did not finish due to the amount of data being processed. The client expected a solution to be implemented within a short time frame. Solution The consultant met with various functional groups to determine how the […]
View Details >>