Data Warehouse Automation Using dbt
Replaced manually written SQL transformations with a fully modular, tested, and documented dbt project on Snowflake. Implemented CI/CD for dbt models reducing deployment errors by 80% and cutting data refresh time by 70%.
HR Analytics Dashboard
Interactive workforce analytics delivering real-time insights on attrition, headcount, and performance KPIs. Used Power Query for data transformation and DAX for advanced metrics.
Bank Data Warehouse Design
Designed a star-schema data warehouse for a banking client using Pentaho ETL, enabling regulatory reporting, fraud analytics, and customer 360 views.
ML Feature Engineering Pipeline
Built an end-to-end feature engineering pipeline on Databricks, automating data prep for ML models. Integrated MLflow for experiment tracking and model registry.
Real-Time Streaming Pipeline
Designed a real-time event streaming architecture using Apache Kafka and Python, ingesting 50M+ events/day into a Databricks Delta Lake with sub-second latency.
E-Commerce Data Lakehouse
Migrated a fragmented e-commerce data setup to a modern Snowflake lakehouse using Fivetran for ingestion and dbt for transformations, enabling self-serve analytics.
Business Forecasting Platform
Built a time-series forecasting platform using Prophet and ARIMA models, integrated with Power BI dashboards for interactive demand planning and revenue forecasting.
PSD Global BI Platform
Multi-module BI platform consolidating purchasing and e-commerce data across 30 countries and 3,300 POS locations for a France-based international tyre dealer network.
Innoviti BI Platform
Real-time BI pipeline processing 50M+ payment transactions from 6,000+ merchant terminals for India's leading FinTech payments company — live dashboards and automated reporting.
Customer Experience BI
Unified CX analytics platform combining NPS survey data, conversion funnel metrics, and cohort analysis — eliminating a 3-day weekly manual reporting process with live Tableau dashboards.