👋 Welcome to my portfolio

Shubham Bhavsar

I'm a Data Analyst

Transforming complex data into strategic insights that drive business growth

5+

Years Experience

50+

Projects Completed

200+

Professionals Trained

About Me

Turning Complex Data into Strategic Decisions

Hello! I'm a Data Analyst and AI Engineer with 5+ years of experience building analytics solutions that deliver measurable results.

At De Soto Technologies, I led analytics initiatives that transformed how the organization uses data, consolidating 50+ manual Excel reports into 8 automated Power BI and Tableau dashboards, saving 120+ hours weekly and achieving 99% reporting accuracy.

Built predictive models increasing forecast precision by 34%
Reduced safety stock costs by $420K through analytics
Won 2024 TBC FinTech Hackathon for AI accessibility tool
Trained 200+ professionals on data visualization and BI
Toronto, Ontario, Canada
contact@shubhambhavsar.info
AI & Data Science, Loyalist College
Shubham Bhavsar
Data Analytics
Machine Learning
Business Intelligence
Professional Journey

Work Experience

April 2025 - Present

Research Analyst

Self-employed

Conducting independent AI/ML research analyzing mathematical reasoning capabilities of language models using Python, SQL, and statistical analysis.

Python ML Research Statistical Analysis
May 2024 - Present

Operations Analyst

Illuminarium Experiences

Coordinated daily operations for immersive entertainment experiences serving 300-1,000 guests daily, managing shift scheduling, staff training, and customer service workflows across regular shows and special events.

  • Managed inventory tracking and pricing strategy for retail FMCG products, analyzing sales patterns and stock levels to optimize product mix and maximize revenue per transaction
  • Analyzed operational performance data to identify trends, developing standardized reporting processes for guest satisfaction, staff productivity, and retail sales performance
  • Designed performance tracking frameworks monitoring KPIs across 2-3 weekly events and daily shows, translating insights into resource allocation and inventory purchasing decisions
Data Analysis Inventory Management Performance Tracking Pricing Strategy
September 2020 - July 2023

Senior Data Analyst (Business Intelligence)

De Soto Technologies

Led enterprise analytics transformation, consolidating 50+ legacy Excel reports into 8 interactive dashboards. Achieved 34% forecast precision improvement and $420K cost reduction.

  • Saved 120+ weekly reporting hours through automation
  • Delivered $3.7M incremental revenue via customer segmentation
  • Improved on-time delivery to 96% with supply chain analytics
Power BI Tableau SQL Predictive Modeling
February 2020 - August 2020

Junior Data Analyst (Business Intelligence)

De Soto Technologies

Supported enterprise data migration and reporting automation, establishing standardized templates and optimizing dashboard performance.

SQL ETL Data Validation
November 2019 - January 2020

Junior Data Analyst

Crest Data Systems

Created automated reporting systems integrating HRIS, payroll, and attendance data for 700+ employees, improving accuracy by 62%.

SQL Power BI HR Analytics
July 2019 - October 2019

Data Analyst Intern

Crest Data Systems

Supported the analytics team in cleaning and structuring large datasets, while assisting with interactive dashboard builds for business insights.

  • 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
SQL Tableau Data Transformation Data Visualization
Portfolio

Featured Projects

FinQA Platform

FinQA - Financial Intelligence Platform

Domain-specific LLM with RAG architecture for financial data analysis. Built with LangChain workflows, MongoDB Vector Search, and fine-tuned Groq Mistral-24B achieving 92% SQL generation accuracy and 95%+ intent classification.

RAG LangChain LLM Flask React
Mathematical Reasoning Research

Mathematical Reasoning Enhancement for LLMs

Independent research improving small language model performance on mathematical reasoning using Chain-of-Thought, Plan-and-Solve, and DUP methodologies with GSM8K datasets. Evaluated models like DeepSeek-R1 and Falcon.

PyTorch Hugging Face Chain-of-Thought AI Research
Mortgage Trading Analysis

Mortgage Trading Analysis Platform

Power BI trading desk simulation analyzing $336M mortgage portfolio across 1,146 loans. Identified 72 basis point pricing premium for high-credit borrowers and achieved 207 basis points profit target exceeded (7.07% vs 5.00%).

Power BI DAX Financial Analytics Risk Assessment
Multi-Modal Deep Learning

Multi-Modal Deep Learning: CV & NLP

End-to-end deep learning project combining computer vision and NLP. Processed 200,000 images and 8M+ text samples using PyTorch, TensorFlow, and scikit-learn for multi-modal data analysis.

PyTorch TensorFlow Computer Vision NLP
Third Eye Vision

Navigation Aid for Visually Impaired

Computer vision system enhancing navigation and safety for visually impaired users. Features alert system for approaching vehicles/objects, street name detection, and pedestrian signal recognition.

Computer Vision OpenCV Accessibility AI
Customer Churn Analysis

Customer Churn Analysis Dashboard

Power BI analytics platform with advanced DAX measures for customer churn analysis. Features behavioral analytics and KPI tracking, showing 84% YoY retention improvement and 16% churn reduction.

Power BI DAX Predictive Modeling
Instacart Recommender

Instacart Aisle Recommender System

Collaborative filtering model for aisle-level personalization on GCP using PySpark. Implemented rolling cross-validation for robust model evaluation and scalable recommendations.

PySpark GCP Collaborative Filtering
Market Basket Analysis

Market Basket Analysis Dashboard

Tableau-based retail analytics solution for market basket analysis and performance optimization. Features statistical modeling and scheduled reporting for identifying product correlations and purchasing patterns.

Tableau SQL Market Basket Analysis
Global Petrol Prices Dashboard
AI-Generated

Global Petrol Prices — 2026 US-Iran War Impact

Interactive dashboard built end-to-end using Claude Cowork's Data plugin in 4 prompts. Covers Brent crude trajectory, country-level pump price rankings, risk exposure tiers, and a 2026 vs 2022 Ukraine shock comparison — all from a raw Kaggle CSV. Data is illustrative and intended to showcase an AI-assisted analytics workflow.

Claude Cowork AI Analytics Chart.js Data Plugin HTML Dashboard
Technical Expertise

Skills & Technologies

Data Analytics & BI

Power BI Tableau SQL DAX Excel JasperSoft

Programming & Data Engineering

Python PySpark ETL Pipelines Snowflake Databricks Redshift PostgreSQL Airflow Dbt

Machine Learning & AI

Predictive Modeling Deep Learning NLP Computer Vision Statistical Forecasting TensorFlow PyTorch

Cloud & DevOps

AWS GCP Azure CI/CD Docker API Integration
Resume

Download My Resume

View my complete professional background, skills, and experience

Shubham Bhavsar - Resume

Data Analyst & AI Engineer

View Resume Download PDF
Get In Touch

Let's Connect

I'm always interested in connecting with people passionate about data, analytics, and intelligent decision-making.

Email

contact@shubhambhavsar.info

Location

Toronto, Ontario, Canada

Website

www.shubhambhavsar.info