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 >>

OSIsoft PI Solutions - PI Audio Alarm

Issue   Our client needed to receive audio alerts based on readings from the OSIsoft PI real-time data. OSIsoft has a product that delivers notifications but not in audio format. The client wanted an alert as soon as a limit was exceeded in real-time delivered through audio so it would not be missed.     […]
View Details >>

Retail Power Systems Assessment

Issue A retail electric provider in Texas engaged MidDel Consulting to assess their current systems and processes landscape. MidDel was engaged to provide a recommended course of action to improve their systems capabilities, streamline current operations, and lay the foundation for future profitable growth. MidDel conducted top-down and bottom-up analyses by meeting with management and […]
View Details >>

Endur Support

Issue MidDel Consulting was approached by a large Midwestern natural gas and power company to assist in reducing their ongoing Openlink Endur support costs. This client recently completed an Endur implementation. They then faced the challenges of creating required reports not completed during the initial implementation, as well as on-boarding a new business […]
View Details >>

Analytical System Pilot Study

Issue Our client was considering the deployment of a portfolio risk analytics system throughout its global organization, but first wanted to prove the software’s applicability to the client’s unique set of challenges. The software needed to do the following: organize and store information obtained from multiple sources and in various formats; calculate and […]
View Details >>

BOBJ Deployment

Issue Our client did not have an operational user-friendly Business Intelligence tool. Two years earlier they had attempted to install SAP Business Objects incorporating Active Directory with Single Sign On. Without a viable tool, users were only given the option to work with BEx queries in a limited portal and without flexibility. Access […]
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 >>

Reduced Credit Exposure Risk By Re-Engineering And Automating Credit Reporting

Issue Our client traded commodity physical instruments and financial derivatives that made up a complex portfolio and position. The credit department found their current credit reporting to be inaccurate and not always very useful when assessing their credit exposure. Because of inaccurate reporting, the client may have been exceeding credit limits without knowing. […]
View Details >>

Trading Book Valuation

Issue A mid-size Northeast retail power and gas company had the opportunity, as part of their organizational strategic portfolio growth plan, to bid on two books of business that were up for auction. Books included power and gas, residential and commercial contracts, and fixed and variable price volumes. The client wanted to determine […]
View Details >>

Human Capital Dashboard

Issue This client’s corporate executives did not have visibility into a broad range of human capital measurements. Although a Human Capital module operated within the company’s ERP framework, the reports were cumbersome and inefficient. Reporting required gathering information from 18 sources for 60 business units and each unit required 21 pivot tables consolidated […]
View Details >>