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