Issue The client is a fully integrated electric utility in the Midwest, not currently participating in a major organized transmission system. They and other utilities were contemplating entering into an organized system, most likely the Southwest Power Pool. As part of its due diligence for entering into this market, the client requested assistance in understanding […]
Issue Our client, a large refined products blending company, implemented an ETRM system a number of years ago. The original software that was implemented failed to meet the needs around inventory valuation and reporting. This has resulted in manual work arounds for an extended period of time. The issue around blending and inventory management was […]
Issue The client is an energy company and the first adopter of a vendor's new invoicing module. The newly adopted invoicing module could not apply cash payments: The gap blocked receivables and payables tracking, aging, and credit reporting. As the first adopter, the client had no vendor-supplied workaround. The missing function held the entire back-office […]
Issue The client is a power-market participant whose system admins monitor the ISO's day-ahead processes. System admins needed real-time visibility into the ISO's day-ahead processes and studies: Readings had to be surfaced on an internal website so admins could act proactively. Missing a timely offer to the power market carried direct financial penalties. Manual monitoring […]
Issue The client is an energy company whose retail business was expanding faster than its manual processes could support. Rapid retail growth outpaced the client's largely manual processes: To stay competitive, the business needed to automate ordering, data processing, pricing, quoting, and contracting. The client had deep retail knowledge but lacked the internal analysis capacity […]
Issue The client is a marketer & trader managing pricing data across multiple databases, ETRM systems, and spreadsheets. Pricing data was scattered across too many sources to support: Price data was being overwritten across systems, corrupting the daily P&L. There were too many independent sources of pricing to maintain reliably. The client needed one trustworthy […]
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 […]
Issue The client is an IPP on a major ETRM overhaul with need to convert complex price data between old and new schemas. A price-data conversion program had been built but never tested: Differences between the old and new schemas had been spotted, but their full extent was unknown. Unvalidated conversions put the integrity of […]
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 […]
Issue As part of an initiative to improve the corporate reporting process, the client requested a KPI based dashboard providing O&M, capital, and HR information on a monthly basis. Due to the project’s high visibility among executives, the project incurred multiple requirement changes. Solution Our consultant, along with the project team, was able to creatively […]
