Led the modernization and migration of legacy on-premise databases to Azure Fabric, establishing a secure, scalable, and high-performance cloud data environment. The project involved full-cycle data pipeline redesign, schema restructuring, and report re-engineering to align with the company’s digital transformation goals.

Key Deliverables:

Conducted source-to-target mapping (STTM) and schema normalization during migration from on-prem SQL Server (SSMS) to Azure Fabric.

Developed Python and Power Automate pipelines for automated data refresh and reconciliation.

Rebuilt and optimized Power BI reports and dashboards for enhanced performance and cloud compatibility.

Integrated Power Apps for business users to access and update key datasets.

Delivered robust ETL workflows to ensure accuracy, integrity, and consistency across migrated data sources.

Impact:
Enabled real-time analytics, reduced system maintenance costs, and improved data accessibility across departments—transforming the company’s reporting architecture into a modern, cloud-based analytics ecosystem.