Case Studies

Analytical System Pilot Study

Issue Our client was considering the deployment of a portfolio risk analytics system throughout its global organization, but first wanted to prove the software’s applicability to the client’s unique set of challenges. The software needed to do the following: organize and store information obtained from multiple sources and in various formats; calculate and report exposures […]
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 >>

Natural Gas Liquid Modeling

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

Front Office ISO Communication Application Replacement

Issue A large Northeast generation company required a replacement for its front office load forecasting, bidding, scheduling and dispatch platform as the technology of the current application was coming to the end of its useful life. The client wanted to implement a vendor package for the bid submission and dispatch component, however, due to the […]
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 >>

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 >>

Report Consolidation (Over 3,000)

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

Meter to Mailbox Dashboard Project

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