Dutch National Grid
This huge project for the Dutch National Grid and Engie Nederlands, required Perfutil to improve their internal systems for Forecasting, Costing, Pricing and a new Position Management Platform.
THE PROJECT
Perfutil introduced an incredibly flexible platform for Engie Nederlands, allowing members of the business team to dynamically design their own Energy Products without the need for support from IT. The flexible framework we created supported multiple options for each of the steps in the process of creating an individualised offer for Industrial and Commercial customers, or Rate Cards for Small to Medium Enterprises (SMEs). Each “Product” is comprised of:
- A source of historical data
- Forecasting component to predict future usage
- Costing components to calculate what the company will need to spend on raw materials or pay third parties
- Pricing components to account for the item we’d like to add to the costs
- Pricing Methods to decide how all of this should be presented to the customer
- Contract Components to generate all appropriate contractual documentation
- Position Management Components to determine how margin should be tracked, managed, and maximised
OUR WORK
Meter Data Management
- Processing and storing of historical meter data and individual meter data points, accessing the entire Dutch National Grid for Electricity and Gas
- Processing, storing or generation of Synthetic Load Profiles for common business types (SMEs) or usage types (e.g. for disaggregation of energy usage by street-side lighting)
Forecasting
- Simple roll-forward forecasting
- Like-day mapping
- Synthethic Load Profiles (SLPs)
- Disaggregation
- Multi-site offers (up to 15,000 meter points)
Costing
- Cost of sourcing energy
- Grid imbalance charges
- National Grid charges (multiple)
- Distribution Grid charges (multiple)
Position Management
- Internally managed Sourcing and Trading
- Customer managed Trading
- Trading instruction management
- Post-trade margin analysis
Contracting
- Generation of core contracts with terms dynamically adapted based on the inputs provided to the product components
- Generation of supporting documentation to provide customer insight on the pricing process
- Generation of in-depth documents for other internal teams
- Generation of output data for other supporting system
- Generation of Management Summary documentation
- Point of contracting Margin analysis
Pricing
- Margin
- Sales Commission
- Broker Commission
- Risk Premia
As well as introducing this flexible framework, we also increased processing speed but to 40 times the original processing speed, without an increase in hardware costs. All servers were from update from windows server 2003 to 2012 and all Oracle databases from Oracle 9i to Oracle 12g also.
The project was delivered using Oracle Utilities (Rules Language, QM, Adapter, Web Services), ASP.NET, JavaScript, HTML 5, PL/SQL and Java.
LET’S WORK TOGETHER
