Case Studies

Emissions Transactions and Settlement Discrepancies

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 […]
View Details >>

MidDel Performs the “Impossible”

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 […]
View Details >>

MTM, Value at Risk (VaR), and Invoice Reports Validation

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 […]
View Details >>

Inadequate Trade Application Security

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 […]
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 prevent failures. Result MidDel’s consultant devised […]
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 and knowledge of the data model […]
View Details >>