Yuvraj Chauhan

Insight Architect | Strategy-Driven Innovator

Transforming data into actionable insights that drive business success.

About Me

I'm a data-driven problem solver with a passion for turning raw numbers into actionable insights. With experience across manufacturing, retail, and tech, I specialize in building dashboards, forecasting models, and automating workflows that drive real business impact.

Whether it's SQL, Python, Power BI, or Tableau — I love crafting solutions that make data speak. Currently, I’m wrapping up a successful stint at Honda Canada where I built real-time analytics tools that saved time, reduced defects, and improved supply chain efficiency.

"I don’t just analyze data — I make it work for the business."

Technical Skills

Languages & DB

  • SQL
  • Python (Pandas, NumPy)
  • R (basic)
  • PostgreSQL, MongoDB

Analytics & BI

  • Power BI
  • Tableau
  • Excel (Pivot Tables, Dashboards)
  • VBA

Cloud & ETL

  • Azure Data Factory
  • AWS (basic)
  • Salesforce

Business Analysis

  • Agile / Waterfall
  • GAP & SWOT
  • Jira
  • Process Mapping

Certifications

  • Google Data Analytics
  • IBM Data Science
  • Stanford ML

Projects

📊 Dashboards & BI

Revenue Insights in Hospitality

Analyzed RevPAR trends and built Power BI dashboards with custom DAX metrics.

Stack: Python, Power BI, DAX, SQL Server, Excel, Git

Sales & Operations Dashboard

Automated reporting with Excel Macros, PowerQuery, and SQL joins. Reduced manual effort by 90%.

Stack: Power BI, SQL, DAX, Excel

Uber Customer EDA

Analyzed ride patterns and geo-traffic zones. Delivered dashboards for peak-hour ops tuning.

Stack: Python, SQL, Power BI

📈 Analytics & Machine Learning

Customer Churn Prediction

Built classification model with 85% accuracy. Integrated into dashboards for retention strategies.

Stack: Python, scikit-learn, Power BI

App Store Profitability Analysis

Segmented 7K+ apps and found high-profit categories using clustering and visualizations.

Stack: Python, SQL, Power BI

Used Car Price Predictor

Built regression models to predict resale value. Benchmarked with RMSE and deployed to Power BI.

Stack: Python, scikit-learn, Power BI

🎓 Exploratory & Skill-Building Projects

Hand Gesture Scroll Control

Touchless scroll controller using webcam gestures. Designed for accessibility and multitasking.

Stack: OpenCV, MediaPipe, PyAutoGUI

Alien Invasion Game

2D arcade-style game with scoring, levels, and enemy swarm logic. Built with custom sprite animations.

Stack: Python, Pygame

Automated Data Fetcher API

Built REST API client to automate data extraction with error handling and rate limit management.

Stack: Python, Requests, Pandas

Experience

Data Analyst — Honda Canada Inc.

Apr 2022 – Apr 2025 · Alliston, ON

  • Built real-time dashboards in SQL and Tableau for 20+ production lines; reduced bottlenecks by 30%
  • Automated Azure SQL ETL workflows, cutting manual reporting time by 40%
  • Partnered with Engineering teams to detect defects via statistical modeling, reducing downtime by 15%
  • Developed CR-V demand forecast model driving weekly supply chain tuning; cut inventory mismatch by 18%
  • Saved $100K annually using Python (Pandas, NumPy) for defect severity analysis

Sales & Operations Analyst — Union Lighting

Mar 2021 – Apr 2022 · Toronto, ON

  • Analyzed Salesforce CRM and trends to sharpen customer targeting; improved conversion by 20%
  • Led root cause investigations across Logistics, reducing delivery escalations by 30%
  • Delivered seasonal inventory planning insights via Excel dashboards and Power BI reports
  • Translated customer feedback into metrics-based process improvement strategies

Business Analyst Intern — A2IT Soft

Nov 2019 – Dec 2020 · Chandigarh, India

  • Identified lead conversion bottlenecks using funnel and cohort analysis
  • Used GAP/SWOT techniques to prioritize target segments and improve campaign ROI
  • Created process maps with stakeholders and unified marketing-sales reporting metrics
  • Supported Agile sprints using Jira; managed dashboard redesign and story tracking

Contact Me

Interested in working together or have a question? Let’s connect!

📧 Email

chauhan.yuvraj@hotmail.com

🔗 LinkedIn

linkedin.com/in/YuvrajChauhan

💻 GitHub

github.com/YuvrajChauhan

© 2025 Yuvraj Chauhan. All rights reserved.