Industry: Energy Business

HECTOR 1.0

Energy utility pricing and contract management application, focusing on Price Adjustment (PA) scenario simulation.

HECTOR Project Image

Energy Utility Group

The partner is a large-scale energy utility provider in need of a digital solution to manage millions of contracts and forecast market price fluctuations.

Headquarters
International / Europe
Address
Energy Supply Segment (Electricity/Gas)
Website
https://schwarm.com/
Industries
  • Energy Supply
  • Utility Contract Management
  • Price Analysis
E-Invoicing Standards
  • Energy Pricing Models
  • Basic Energy Supply Regulations
  • Utility Billing Standards

Context & Goals

Executed from October 2020 to March 2023, HECTOR is the core system helping energy analysts create, calculate, and manage Price Adjustment (PA) scenarios.

Needs

  • Automation of price creation and calculation for energy contracts
  • Management of diverse contract portfolios (electricity, gas, basic supply)
  • Simulation of financial impacts before applying actual price changes
  • Consolidation of price approval workflows across analytical departments

Collaboration Goals

  • Develop an intuitive and accurate Price Adjustment (PA) simulation tool
  • Centralize large-scale energy contract management
  • Integrate complex Python calculation logic into the user interface
  • Ensure systematic review and approval of price changes

Technology

Frontend

  • React
  • React Context API
  • Data Visualization (Charts)
  • Advanced Table Filtering
  • Multilingual Support (i18n)

Backend / Integration

  • Python
  • FastAPI / Flask
  • Pricing Calculation Engine
  • Business Logic Layer

Infrastructure / DevOps

  • MSSQL Server
  • Stored Procedures
  • On-premise or Cloud Deployment

Runtime

  • Python 3.x
  • Node.js

Architecture

  • Client-Server Architecture
  • Centralized Database
  • Scenario-based Data Modeling
  • Approval Workflow Engine

Solutions

Price Adjustment (PA) Scenarios

  • Create and manage price adjustment scenarios for energy contracts
  • Utilize Python for complex financial calculations
  • Simulate profit and customer impact for each scenario

Energy Contract Management

  • Detailed management of electricity and gas supply contracts
  • Support for multiple supply types: utility, basic, default
  • Search and filtering features for massive contract portfolios

Review & Approval Workflow

  • Provide tools for analysts to review price scenarios
  • Multi-level approval system before changes take effect
  • Audit trails for history tracking and compliance

Data Integration & Storage

  • Use MSSQL Server for data security and consistency
  • Process complex portfolio analysis report queries
  • Synchronize new pricing data into customer management systems

HECTOR 1.0

Scenario Simulation Dashboard
Energy Supply Analytics

Start your project today!

Leave your information, our expert team will contact you for a free consultation within 24 working hours.

info@mttjsc.com
(+84) 024 625 326 01