Back to Case Studies
Big DataEnergyPortfolio ManagementEnterprise
Enterprise Portfolio System
Central portfolio management for electricity, gas, and green certificates
Role:System Architect & Lead Developer
Duration:18 months
12x
Faster calculation (48h → 4h)
3.5x
Shorter process duration (7 → 2 days)
✓
Multi-user capability established
✓
Audit capability implemented
The Context
An energy provider needed a central system for portfolio management of electricity, gas, and green certificates. The system was required to handle procurement control, hedging activities, and provide all relevant data for pricing, acquisition, business management, and planning.
The Challenge
- 1Processing approximately 30 billion records monthly with existing infrastructure
- 2Calculation runs took 48 hours, blocking critical decision-making processes
- 3Single-user system prevented parallel work by multiple analysts
- 4Missing traceability for audits and regulatory requirements
The Approach
- 1Functional and technical design of a scalable system architecture
- 2Optimization of calculation logic through parallelization and intelligent caching
- 3Implementation of a multi-user capable frontend with role and rights management
- 4Development of a complete audit trail for all data changes and calculations
Technologies Used
PythonSQLSnowflakeAngularAzurePower BI
Have a Similar Challenge?
Let's discuss how I can help you achieve similar results for your organization.