This repository curates the projects I lean on as a Senior BI & Data Engineer, spanning Azure integration, Microsoft Fabric lakehouses, and operational SQL automation. Start with PORTFOLIO.md for narrative case studies; use the sections below when you want to dive straight into code.
- Real-Time Alerting Platform (Azure Logic Apps + SQL) → Automated email and Teams notifications with managed identities, audit trails, and parameterized deployment templates. See
PORTFOLIO.md#1-real-time-alerting-platform-azure-logic-apps--sql. - Sales Consolidation for Fabric Lakehouse (PySpark) → PySpark notebook that harmonises NAV current/archive tables and writes partitioned Delta tables for Fabric. See
PORTFOLIO.md#2-sales-consolidation-for-fabric-lakehouse-pyspark. - Operational SQL Platform Automation → Stored procedures that govern index health, alert queues, and telemetry for a busy NAV estate. See
PORTFOLIO.md#3-operational-sql-platform-automation.
- Azure Integration → Logic Apps, Azure SQL, Data Factory, and Fabric Lakehouse.
- Business Intelligence → Power BI semantic models, dashboards, and automation of alerting.
- Engineering Depth → SQL optimization, PySpark ETL, schema design.
- Deployment Automation → ARM templates and reusable scripts for consistent Logic App provisioning.
Released under the MIT License. Attribution appreciated when reusing examples.