Issue
The client is a retail provider of power and gas to commercial, industrial, and residential customers.
Retail operations ran on legacy database tables and spreadsheets that could not keep up:
- The setup offered little functional control, data control, or auditability.
- There were significant gaps in P&L and mark-to-market reporting.
- The client needed a controlled platform to see and manage its retail exposure.
Solution
MidDel configured the core ETRM against aggressive timelines and supported the interface build:
- Gathered requirements and completed core system configuration in sixteen weeks.
- Advised while the client's developers built retail forecast, trade, and price-curve interfaces from scratch.
- Built interface validation and business reports and trained business and technical staff.
Result
The platform gave the client the data controls, auditability, and mark-to-market transparency its spreadsheet-based legacy setup lacked - and separated retail and wholesale performance so trading and sales could supply customers more profitably.
“It is unbelievable how much those guys know about the business and the system.”
IT Support Manager
Gas and Power Trading Company
Key Takeaways
- Spreadsheets do not just slow retail operations - they quietly strip out control and auditability. A configured ETRM delivered in sixteen weeks restored the data controls, audit trail, and mark-to-market transparency the legacy setup never had.
- Separating retail from wholesale performance changes the conversation, not just the numbers. Clean position segmentation gave trading and sales a shared, defensible view of who is actually making money - something a spreadsheet-based setup structurally cannot provide.
Ready to do the same?
Running retail energy operations on spreadsheets with limited controls? MidDel can stand up a controlled ETRM platform in weeks, not quarters. Let's talk.
