Issue A client’s Risk and Trading groups were in disagreement about the valuation of certain option instruments. Proper valuation was needed for mark-to-market disclosure. Our objective was to determine the source of the discrepancy and gain agreement between Risk and Trading. Solution Our consultant combined his knowledge of the mathematical models supporting option valuation and […]
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 a more […]
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 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 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 into spreadsheets […]
Issue Our client was using a large Excel spreadsheet with multiple linked tabs to calculate value at risk (VaR). The client was not measuring VaR for any of its FTR positions. The volatility and correlation calculations were not properly weighted. In addition, the delta between the published price and the non-published price was not updated […]
Issue Our client lacked expertise with the Aligne application to quickly prepare needed reports while maintaining controls set by the company. Solution Our consultant captured requirements, documented specifications, then built, tested, and deployed a solution while maintaining SOX compliance. They learned the company’s change management process, prepared documentation, and tested the output as required by […]
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 […]
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 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 and knowledge of the data model […]
