Case study · Oil & Energy
Automated Pipeline Imbalance & Energy Trade Settlement Reconciliation
A multi-state natural gas midstream pipeline and wholesale energy trading enterprise managing 2.4 Bcf/day throughput across 80 delivery interconnects.
Engagement record
- Client
- Gas pipeline & energy trading company
- Industry
- Oil & Energy
- System
- Pipeline Telemetry & ETRM Trade Reconciliation
- Timeline
- 6 Weeks
About this write-up
This case study describes the engagement as recorded. The client is not named; figures and outcomes are as reported by the client and have not been independently audited.
The challenge
Pipeline dispatchers and trading back-office analysts spent up to 14 business days at month-end manually reconciling SCADA meter flow tickets, electronic nomination schedules, and PDF custody transfer statements against OpenLink Endur deal sheets. Unidentified volume variances resulted in shipper billing disputes, tariff penalty write-offs, and delayed cash collections.
Objectives
- Reconcile hourly SCADA meter telemetry against electronic shipper nominations automatically.
- Identify line pack pressure imbalances and meter calibration drift in real time.
- Match third-party pipeline custody transfer tickets against ETRM trade confirmations in under 60 seconds.
- Compress monthly commercial trade settlement cycles from 14 days to under 24 hours.
Discovery
Operational audit showed that over 85% of monthly billing discrepancies stemmed from minor meter timestamp discrepancies and uncoordinated mid-cycle nomination revisions that spreadsheets failed to flag until final invoice generation.
What was built
- SCADA & ETRM Ingestion Engine. Automated connectors pulling flow computer volumes, gas chromatograph Btu assays, and trade contracts from ETRM ledgers.
- Dynamic Imbalance Reconciliation Agent. Semantic reconciliation engine matching scheduled vs delivered volumes across all interconnect zones.
- Layout-Aware Ticket OCR. Vision-language pipeline parsing PDF custody transfer statements, bills of lading, and interconnect statements.
- Settlement Exception Workbench. Prioritized dashboard surfacing volume discrepancies with highlighted source meter tags for one-click resolution.
Outcomes as reported
Reported summary: 12d → 24h Settlement & $740K Dispute Liabilities Avoided.
| Figure | What it refers to |
|---|---|
| 14d → 24h | Month-end trade settlement and shipper invoicing turnaround |
| $740,000 Saved | In avoided shipper dispute settlements and tariff penalty write-offs |
| 100% Reconciled | Across 80 interconnect points and 1,200 monthly shipper contracts |
| 0 Audit Flags | Under FERC regulatory tariff compliance examination |
Figures as reported in the engagement record; not independently audited.
Lessons
- Automated mid-month nomination variance alerts prevent small hourly drift from compounding into major month-end billing disputes.
- Side-by-side visual reconciliation of PDF meter tickets against ETRM ledgers accelerates back-office approvals by 80%.
Next steps
Integrating power grid real-time nodal pricing feeds to coordinate natural gas pipeline delivery with intraday electricity dispatch peaks.
Implementation questions
The system ingests real-time gas chromatograph gas quality data to compute exact Btu heating values for each custody transfer volume measurement.
We support OpenLink Endur, Triple Point, Allegro, Quorum Pipeline Management, and custom SQL trading databases.
Yes. All processing occurs in dedicated single-tenant environments compliant with sector security requirements and NIST cybersecurity frameworks.
Tariff rules, cash-out pricing bands, and tolerance zones are modeled per pipeline interconnect point to automate accurate penalty ledgering.
