Case Studies

ETRM Price Conversion

Issue A client had a program equipped to calculate complex price data conversions between schemas, but it had not been tested. A number of differences had been noted, but the full extent was not known. Our objective was to determine the scope of differences and provide an accurate solution. Solution Our consultant combined extensive understanding […]
View Details >>

Global Risk Reporting

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

Trading Book Valuation

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

ETRM Deal Modeling and Valuation

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

FTR VaR (Value at Risk) Reimplementation

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