Case Studies

ENERGY TRADING (ETRM)

• Implemented Price Curve System

Issue
The Client's legacy, organic price curve database no longer serves the needs of the company. To replace the legacy price curve database, all dependency reporting tools must be identified, all price curves, and associated rules, that will be loaded into the new system must be identified, and set up in the new ZE Zema Suite system. New reporting and lookup tools must be developed and legacy files to be re-deployed on the new system must be re-mapped. 

Solution 
› Set up 5,000 Power and Nat Gas Actual and Forward Price Curves in Zema. 
› Designed and developed Excel reconciliation tools for Zema to legacy price system and Zema to ZaiNet. 
› Identied price discrepancies in the reconciliations and investigate and reported cause. 
› Developed customized curve definitions, rules and properties within Zema on thousands of price curves. 
› Developed Excel Templates to Auto-Build Price Curves for consumption by Zema. 
› Wrote user manuals and documented new Zema Suite pricing system. 

Benefits 
› Ability to gather precise data from internal and external sources from multiple locations and in various formats. 
› Reception of near real-time data on a scheduled basis. 
› Comparison of disparate data sources through robust metadata 
› Integration to trade capture system and reporting tools 

Return To Case Studies