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 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 whether they […]
Issue The client is an IPP on a major ETRM overhaul with need to convert complex price data between old and new schemas. A price-data conversion program had been built but never tested: Differences between the old and new schemas had been spotted, but their full extent was unknown. Unvalidated conversions put the integrity of […]
Issue The merchant energy company’s Risk and Trading groups disagreed on the valuation of certain option instruments: Proper valuation was required for mark-to-market disclosure. The two groups could not agree on the client's true exposure. The source of the discrepancy had to be found and resolved to produce trustworthy numbers. Solution Our consultant combined option-pricing […]
Issue The client operated its business in two different time zones and experienced difficulty integrating the data to maintain the accuracy of the daily P&L, value at risk (VaR), and invoicing reports. In attempting to standardize the trading position, the client entered the transactions as one time zone. This created a problem when the trades […]
Issue Emissions trades listed on the Chicago Climate Futures Exchange (CCFE) were originally modeled as physicals creating problems with present value mark-to-market (MTM) valuation and settlement resulting in double discounting of MTM. Solution Our consultant identified the problems and applied business knowledge to design a solution that eliminated the valuation problem. The consultant performed extensive […]
Issue Our client, one of North America’s largest power producers, was in the midst of a corporate merger with another large power producer. Our client needed to integrate the acquired company’s ETRM system (Endur®) into our client’s ETRM system (Zainet®/Aligne™). In addition, all risk management reporting needed to be re-engineered to accommodate the acquired company’s […]
Issue For system changes, the client needed to agree or reconcile key reports (mark-to-market, VaR and invoicing) before and after the change. Visual comparison of each report’s outputs took too long and wasn’t always reliable. Solution MidDel’s consultant automated the process so that the underlying report output tables were compared directly in the database. Result […]
Issue Our client’s user security model within the Aligne trading application was not adequately addressing the SOX controls now required by the business. Solution Our consultant used their knowledge of the application combined with the client’s requirements to produce detailed documentation and a test plan for the security configuration. This implementation enabled the client to […]
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 […]
