MS Fabric Projects
** All are Scenario-based portfolio projects. Business context and data are simulated
Transforming Data Ingestion for TransLogix Global: A Real-Time Logistics Solution using MS Fabric
Built an automated, incremental data pipeline in Microsoft Fabric using Spark SQL to ingest daily shipment logs without duplication. Enabled real-time insights by loading data into Delta Lake, boosting efficiency and decision-making for Translogix Global
Streamlining Departmental Data Flows for Metropolis: A Smart Lakehouse Pipeline in Microsoft Fabric
A dynamic, event-driven data pipeline in Microsoft Fabric that intelligently classifies and routes incoming files to respective Lakehouse tables, with built-in archive and quarantine logic for complete data governance automation.
Streamlining Customer Data Processing for TeleNova Systems: A Scalable Dataflow Gen2 Solution in Microsoft Fabric
Showcased how Microsoft Fabric Dataflow Gen2 streamlines customer data cleansing and transformation across multiple sources, delivering a scalable, analytics-ready Customer 360 foundation integrated with Fabric Lakehouse to enable smarter, data-driven decisions.
SmartHR: Employee Analytics Framework at Skyline Tech
This PySpark-based analytics framework transforms HR and finance data into workforce intelligence. It delivers insights on salaries, tenure, and departmental performance, revealing trends in pay equity and retention. SmartHR empowers Skyline Tech with scalable, data-driven analytics for smarter HR decisions.
From Siloed Stats to Unified Player Value: The Indian Cricket League (ICL) Transformation
Conceptualized and implemented an end-to-end unified analytics platform using Microsoft Fabric to integrate data from diverse sources (JSON, CSV, Excel) across all 8 teams. Automated ingestion with Dataflow Gen2 and Fabric Pipelines, data transformation with Apache Spark, and a Lakehouse on Delta Lake ensure reliable, auditable data for scalable, real-time analytics, with future Power BI integration
From Manual Downloads to Intelligent Pipelines: The Currency Rate Automation Using T- SQL in MS Fabric Warehouse
Built an automated FX ingestion pipeline in Microsoft Fabric using T-SQL to fetch daily exchange rates without duplication. Delivered clean, audit-ready currency data to the Warehouse, enabling accurate and timely financial reporting.
From Dirty Data to Defensible History: Compliance Analytics Using T-SQL and SCD Type 2 in Microsoft Fabric Warehouse
Built a compliance analytics solution using Microsoft Fabric and advanced T-SQL, implementing data cleansing, window functions, hierarchy modelling, and SCD Type 2 for historical accountability and audit-ready reporting.