GridForge

Deploy-ready Databricks Asset Bundle that runs Model Predictive Control over building/district-heating substations to cut heating energy 5-15% while holding comfort. Per-site thermal models, a real unit-tested NumPy MPC solver (no scipy/cvxpy), verified energy/cost/CO2 savings, and comfort-compliance monitoring. Fully generic and parameterized.

ML-based hourly demand forecasting with automated MAE/RMSE/MAPE accuracy monitoring, horizon-bucketed analysis, and weekly retraining. Databricks Asset Bundle.

Trading analytics for batteries and demand-response assets in reserve markets (FCR-N/D, aFRR, mFRR): asset registry, availability, offers/results, and strategy comparison via modular SQL TVFs.

Internal balance settlement for Balance Responsible Parties at 15-minute resolution: imbalance volumes/costs, volume fees, and production-unit attribution with hierarchical drill-down.

Real-time power-system monitoring from TSO open APIs: grid frequency, reserve markets, generation mix, and staleness alerting. Configurable series IDs for any European TSO.

Generic balancing-energy / market-data ingestion pipeline for open market APIs, environment-agnostic and configurable by endpoint and series.

Intraday electricity-market orderbook analytics: depth, spreads, and trade-flow KPIs over a configurable source.

Multi-workspace Databricks cost visibility from system tables: SKU/job/user attribution, monthly compute-type trends, and optimization signals. Works on any workspace.

Universal time-series forecast monitoring: one TVF + dashboards for MAE/RMSE/MAPE, bias, horizon buckets, and fair multi-system comparison. Deploy in 30 minutes for any forecast.

Cross-cutting DQ layer for any pipeline: freshness, completeness, schema drift, null rates, and row-count anomalies with a standardized summary per schema.

Job/pipeline observability from system tables: run history, failures, durations, and SLA tracking with alerting.

End-to-end ingestion latency measurement and alerting across source-to-gold hops.

Reusable star-schema template for energy retailers/DSOs connecting customers, contracts, metering points, and products — the foundation layer for CLV, settlement, and trading.

CLV pipeline for subscription/energy retail: acquisition cost, payment behavior, forward profitability, NPV-based CLV, and renewal recommendations by value tier.

Session-level chatbot analytics from a silver layer: resolution rate, satisfaction, and topic classification into gold tables with a monitoring dashboard.