Shubham Kathuria

• Designed scalable ETL pipelines integrating multi-source data (structured and semi-structured) into centralized warehouses, improving enterprise data accessibility by 40%
• Developed analytics-ready data models and automated SQL/Python workflows, enabling faster, more reliable executive decision-making while reducing processing time by 30%.
• Led the design and deployment of 10+ enterprise Power BI dashboards, defining KPIs and presenting insights to cross-functional and client stakeholders, reducing manual reporting effort by 50%.
• Architected AWS-based cloud data infrastructure (Glue, Redshift, Athena, S3) enabling scalable analytics processing across 10M+ daily records and supporting enterprise reporting 10M+ daily records.
• Owned end-to-end KPI definition, metric validation, and reporting governance, ensuring alignment between analytics outputs and business decision-making.
• Reviewed SQL, ETL, and dashboard logic to ensure data accuracy and performance optimization.
  

Projects: -

Defection Correlation and Prediction for Maruti Suzuki: -

• Designed ETL architecture consolidating multi-source datasets into centralized analytics warehouse.
• Delivered real-time defect trend dashboards supporting proactive quality improvement decisions and reducing reactive issue resolution cycles.
  

True Value Dealership Performance Simulation for True Value: -

• Developed backend data pipelines for Dealer Profitability app, processing 1M+ rows daily.
• Enabled real-time dealership performance insights using AWS cloud services.
  

Quality Dashboards for Suzuki Motorcycle: -

• Automated reporting workflows and deployed Power BI dashboards for quality monitoring.
• Improved reporting accuracy and reduced manual data handling.