Learn Data Skills
Beta
Shubham Bhavsar

Shubham Bhavsar

Data Analyst

Loyalist College | Canada

Technologies

My Portfolio Highlights

My New Track

Data Analyst

My New Course

Intermediate Data Modeling in Power BI

My New Course

Intermediate DAX in Power BI

My New Track

Data Analyst

Analytical storyteller, weaving captivating narratives with the threads of data.

My Work

Take a look at my latest work.

course

Case Study: Analyzing Customer Churn in Power BI

SQLPower BI
course

Case Study: HR Analytics in Power BI

SQLPower BI
course

Case Study: Analyzing Customer Churn in Power BI

SQLPower BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Power BI
Intermediate SQL
Intermediate Python
Understanding Cloud Computing

My Work Experience

Where I've interned and worked during my career.

Illuminarium Experiences | May 2024 - Present

Operations Supervisor

• Led end-to-end operational workflows including staffing coordination, training program development, and shift planning, demonstrating people leadership and team-building capabilities essential for scaling high-performing technical teams. • Drove process optimization and workflow design initiatives, developing SOPs and implementing efficiency improvements that reduced operational costs, showcasing systematic approach to operationalizing complex pipelines. • Managed stakeholder communications and expectation setting across clients and leadership, demonstrating exceptional ability to communicate technical and operational strategy to diverse audiences including executives and partners.
Show More

De Soto Technologies | Jan 2021 - Sep 2023

Senior Business Intelligence Developer

In this role, I led the company’s enterprise analytics transformation, consolidating 50+ legacy Excel reports into eight interactive dashboards across Power BI and Tableau. These tools unified operational data, saving 120+ hours weekly and improving reporting accuracy to 99%. I architected predictive demand models that leveraged seasonality and promotional data, boosting forecast precision by 34% and reducing safety stock by $420K. My analytics supported end-to-end visibility across supply chain, manufacturing, and sales operations from optimizing Walmart store performance to tracking production utilization across three facilities. I also introduced a tiered discount strategy based on six-month purchase trends, contributing $3.7M in incremental revenue and elevating customer retention by 84% year-over-year. Accomplishments: • Replaced 50+ Excel reports with 8 dynamic dashboards, cutting 120+ weekly reporting hours. • Enhanced forecast accuracy 34% through predictive modeling and reduced excess inventory by $420K. • Designed Walmart supply chain analytics improving on-time delivery to 96% and reducing stockouts 41%. • Created real-time sales dashboards increasing productivity 19% and quota attainment 24%. • Delivered $3.7M incremental revenue via customer segmentation and tiered pricing analysis. • Reduced inquiry resolution time 42% by integrating orders, invoices, and shipments into one customer portal. Top Skills: Power BI | Tableau | SQL | Data Architecture | Predictive Modeling | Supply Chain Analytics | Data Integration | Business Forecasting | Data Visualization | Stakeholder Enablement

Crest Data Systems | Nov 2019 - Jan 2020

Junior Data Analyst

At Crest, I strengthened the data backbone of HR and finance functions by creating automated reporting systems and refining query performance. My dashboards integrated HRIS, payroll, and attendance data for over 700 employees, improving accuracy by 62% and cutting rework by 41%. I also developed documentation standards to ensure analytical processes remained transparent and repeatable. Accomplishments: • Consolidated HR data streams to produce real-time workforce insights. • Reduced manual reporting by 15 hours weekly through automation. • Enhanced data reliability 62% via validation scripts and reconciliation checks. • Created analytical documentation, improving onboarding efficiency for new analysts. Top Skills: SQL | Power BI | Data Cleansing | Process Automation | HR Analytics | Documentation | Data Governance | Query Optimization | Excel Modeling | Analytical Communication

Crest Data Systems | Jul 2019 - Oct 2019

Data Analyst Intern

During my internship, I supported the analytics team in cleaning and structuring large datasets, while assisting with interactive dashboard builds. This early exposure to business analytics deepened my technical foundation and introduced me to the importance of presenting complex data in a way decision-makers could act upon quickly. Accomplishments: • Prepared and transformed 1M+ financial records ensuring reporting consistency. • Improved data turnaround time by 25% through query optimization. • Supported development of dashboards visualizing sales and expense patterns. Top Skills: SQL | Tableau | Data Transformation | Data Visualization | Business Intelligence | Reporting Automation | Data Cleaning | Problem Solving | Analytical Rigor | Continuous Learning

My Education

Take a look at my formal education

Ontario Graduate Certificate, Artificial Intelligence and Data Science  · (September in Data ScienceLoyalist College | 2025
Bachelor of Engineering in Electrical EngineeringGujarat Technological University | 2019

About Me

Shubham Bhavsar

Hello! I'm a Data Analyst and Business Intelligence Professional who turns complex data into strategic business decisions. With 5+ years of experience, I specialize in building analytics solutions that deliver measurable results.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free