Case Studies

Allegro Horizon ETRM System Implementation

Issue Our client, an unregulated utility company owning gas and coal powered generating units and contracts serving municipal and cooperative customers, had recently acquired its assets from another market participant. The client decided to implement an ETRM system to support management of its merchant activities of its new portfolio of assets including deal capture, inventory […]
View Details >>

Retail Centric Strategy Evaluation

Issue Our client, a large North America power company that has a presence in over twenty states, desired to pursue a more retail-centric strategy, and consolidate its Wholesale and Retail System Landscape into one platform to gain efficiencies and better align its system architecture to meet the business needs of its future portfolio. The current […]
View Details >>

Allegro ETRM System Physical Gas Implementation

Issue Following the re-implementation of the Allegro ETRM system for trading refined petroleum products, our client, the physical energy trading subsidiary of a large, multi-national financial trading and investment firm, was then tasked with a second phase of the project to capture physical natural gas trading activity including trade entry, scheduling, actualizing, and invoicing. Solution […]
View Details >>

ETRM for Power Retail

Issue Our client, a retail provider of power and gas to commercial, industrial and residential energy customers required an improved solution to manage their retail power operations. Their legacy processes relied heavily on structured database tables and spreadsheets for position monitoring and other key reporting needs. The legacy setup, however, offered little in the way […]
View Details >>

Endur Support

Issue MidDel Consulting was approached by a large Midwestern natural gas and power company to assist in reducing their ongoing Openlink Endur support costs. This client recently completed an Endur implementation. They then faced the challenges of creating required reports not completed during the initial implementation, as well as on-boarding a new business unit, while […]
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 >>

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

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

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

Multiple Time Zone Data Integration Issues

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