Case Studies

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