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 […]
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 requirements. […]
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 exposures or […]
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 an FTP […]
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 project team, was able to creatively […]
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. Solution Our consultant […]
Issue The client is a Fortune 500 commodity trading firm running over 3,000 financial reports out of its ETRM. The sheer number of ETRM reports had become unmanageable: Many reports were redundant or inaccurate, producing 'multiple versions of the truth.' The excess volume dragged out month-end close. Finance needed a more efficient, accurate, and simplified […]
Issue The client is an electric services company running its business reporting on an aging data model. Hundreds if not thousands of reports had accumulated under an outdated data model that no longer met the business's needs: Many reports were outright duplicates or no longer used, with little to no documentation. Report users were too […]
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 prevent failures. Result MidDel’s consultant devised […]
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 existing information was utilized and how […]
