Interactive Live Dashboard - Click to use
End-to-End Microsoft Fabric solution with Git Documentation
Tech Stack & Architecture: Microsoft Fabric (OneLake, PySpark, SQL Endpoint), Power BI (Direct Lake & Import Mode Production, DirectQuery Prototype), Medallion Architecture (Star Schema).
Architectural Rationale: The platform was initially prototyped in DirectQuery to evaluate real-time telemetry potential. For the production suite, I transitioned to a high-performance Direct Lake / Import hybrid. This strategic move leverages the VertiPaq in-memory engine to ensure sub-second interactivity for complex ESG and financial DAX measures, effectively bypassing the traditional trade-off between data freshness and analytical performance.
Strategic Impact:
Business Value: Identified 81,744 MWh in recorded efficiency risk, translating technical grid waste into €4,904,640 of avoidable costs.
Operational Excellence: Engineered a "Single Source of Truth" maintaining 102.59% heat self-sufficiency while tracking ESG targets across a diverse energy fleet.
Core Skills: PySpark, SQL, DAX, Fabric ETL, Medallion Architecture, CI/CD with Git Documentation.
Interactive Live Dashboard - Click to use
Skills: dbt, SQL, Databricks, Power BI, Medallion Architecture.
Architecture: Engineered a Medallion Pipeline (Bronze → Silver → Gold) in Databricks to refactor nested shipment telemetry into an optimized Star Schema.
Engineering: Leveraged dbt-databricks to implement MD5 surrogate keys and "Inferred Dimensions," ensuring 100% referential integrity for complex Fact-to-Dimension joins.
Analytics Layer: Developed an integrated Power BI Dashboard utilizing the Star Schema to enable sub-second "Drill Down" from executive logistics KPIs to granular order-item details.
Quality & CI/CD: Hardened the pipeline with dbt 2.0 relationship tests and automated schema validation to eliminate "Blank" slicer values and row-inflation in downstream reports.
BIP HMI Dashboard - Anomally detection
BIP HMI Dashboard - AI Activated
In biomanufacturing, discovering a deviation post-batch is a million-dollar risk. I developed BIP: a containerized, AI-augmented architecture that transforms static telemetry into a proactive, closed-loop system.
AI Pilot (Autonomous SCADA): A high-frequency FastAPI engine that monitors batch health and auto-triggers RPM adjustments to stabilize Dissolved Oxygen via physics-based coupling.
GxP Governance: A .NET 8 microservice enforcing 21 CFR Part 11 compliance with role-based e-signatures and immutable audit trails.
Predictive HMI: A React/TypeScript dashboard using moving-window linear regression to forecast temperature trends 60 seconds into the future.
Backends & Logic Python 3.12 • FastAPI • .NET 8 • C# • ASP.NET Core • Pandas
Industrial Frontend React 18 • TypeScript • Node 22 • Recharts • Lucide-React • Tailwind
Data & Infrastructure Docker • Docker Compose • SQLite • EF Core • GitHub Actions • Render