Hi, I'm Mihir πŸ‘‹
Data enthusiast skilled in statistical analysis, data visualization, and machine learning.
MD

About

πŸ‘‹ Hello! I'm a 🎯 Data Enthusiast with a passion for transforming raw data into actionable insights. I specialize in using analytics to drive meaningful solutions, with experience in diverse projects like predictive modeling, dashboard creation, and data migration. Let’s connect to explore how data-driven strategies can elevate your business!

Work Experience

L

Loblaw Companies Limited

January 2025 - April 2025
Market Analyst Co-op
  • Leveraged Python and Large Language Models (LLMs) to automate web scraping and data cleaning for competitor price matching, significantly improving accuracy and operational efficiency.
  • Conducted SQL analysis to uncover trends for category teams, enabling a strategic $3M+ beverage partnership.
  • Analyzed customer purchasing behavior and generated product recommendations using SQL, enabling pricing strategies that boosted sales and enhanced engagement.
  • Optimized complex Excel-based tools by refactoring VBA scripts, reducing computation time from 20+ minutes to under 1 minute and accelerating decision-making for the merchandising team.
  • Skills: Python, LLMs, SQL, Excel, VBA, Macros, Git, Data Analysis, Retail Analytics, Automation.
R

Royal Canadian Insitute for Science

April 2024 - June 2024
Student Data Analyst
  • Directed a cross-functional initiative to migrate analytics infrastructure from Universal Analytics to Google Analytics 4, improving tracking accuracy by 25%.
  • Evaluated web traffic and social engagement data, deriving insights that informed content strategy and drove a 30% increase in website traffic.
  • Produced actionable dashboards and visual reports in Tableau through robust EDA, aligning recommendations with strategic business objectives.
  • Skills: Google Analytics 4, Tableau, EDA, Python, SQL, Data Visualization, Social Media Analytics.
I

Indus University

June 2022 - August 2022
Data Analyst Intern
  • Spearheaded the development of a performance tracking platform for social media creators across YouTube, Twitter, and Instagram, enabling enhanced content strategies.
  • Applied machine learning models for Twitter sentiment analysis using Python, automating insight generation and improving creator engagement by 10%.
  • Designed interactive Power BI dashboards that empowered users to self-monitor performance, resulting in an 8% increase in online visibility.
  • Skills: Python, Power BI, Machine Learning, Sentiment Analysis, Social Media Analytics, SQL.
C

Coding Ninjas

September 2021 - January 2022
Teaching Assistant
  • Mentored over 500 students in resolving complex inquiries related to Data Structures and Algorithms in Java, showcasing strong domain expertise and communication skills.
  • Managed challenging debugging and optimization scenarios, improving code efficiency and problem-solving approaches, while fostering a learning-focused environment.
  • Earned a 4.7/5 rating for consistently delivering high-quality assistance, demonstrating active listening, problem resolution, and clear communication skills.

Skills

Python
SQL
R Programming
Tableau
Power BI
Machine Learning
Data Exploration
Data Visualization
Micrsoft Excel
Macros
VBA
Java
HTML
CSS
JavaScript
React
React Native
Go
My Projects

Check out my latest work

I've worked on a variety of projects, from simple websites to complex web applications. Here are a few of my favorites.

SyncScribe AI

SyncScribe AI

Transform your meetings into actionable insights with AI-powered transcription summaries and intelligent analysis.

Python
Large Language Model(LLMs)
Cohere API
Google Speech-to-Text API
Vertex AI
Gemini
Next.js
Flask
Valorant Statistics

Valorant Statistics

Built a Power BI dashboard that reduced player scouting time by 8%, providing real-time insights on player statistics across agents and maps based on past tournament data. Analyzed a dataset of over 80,000 entries with diverse variables, offering comprehensive insights into player performance and strategic decisions.

Microsoft Power BI
Microsoft Excel
TTC Subway Delay Prediction

TTC Subway Delay Prediction

Designed a platform using supervised machine learning techniques to predict subway delays, improving the commuter experience in Toronto by 15%. Executed ETL processes and conducted Exploratory Data Analysis (EDA) using Python and SQL, uncovering critical patterns that enhanced insights into delay factors.

Python
SQL
Microsoft Excel
GitFlux

GitFlux

Optimized GitHub account switching with a command-line app with seamless integration into npm, reducing manual switch time by 50% through an intuitive menu and safeguards for default accounts.

Go Lang
Creator-IT

Creator-IT

Creator-IT is SEO optimisation and recommendation website for Youtubers, Instagram creators and other platforms creators. Helps content creators in generating video titles, hashtags and much more.

Python
HTML
CSS
JavaScript
Customer Churn Analysis

Customer Churn Analysis

This project aims to delve into customer churn within a company primarily operating in California. By analyzing different factors influencing customer attrition, we seek insights to guide strategic decision-making and improve efforts in retaining customers.

Microsoft Excel
Tableau
Airbnb Real Estate Listings Analysis

Airbnb Real Estate Listings Analysis

This project is focused on the analysis of the the Airbnb's Real Estate Listings dataset which is avaiable on kaggle.

R Programming
Indus Uni App

Indus Uni App

The project is dedicated to addressing students inquiries and enhancing transparency between faculty members and students. There has been an 80% reduction in resolution time. The applications involved are IndusAchiever, IndusFaculty, and AdminPortal.

HTML
CSS
JavaScript
React
ReactNative
Mobile Price Prediction

Mobile Price Prediction

Developed a Python-based Mobile Phone Price Prediction model for accurate forecasting of mobile phone prices, enhancing decision-making in the tech market.

Python
Hackathons

I like building things

During my time in university, I attended 3+ hackathons. People from around the country would come together and build incredible things in 2-3 days. It was eye-opening to see the endless possibilities brought to life by a group of motivated and passionate individuals.

  • G

    GenAI Genesis 2025

    Toronto, Ontario

    Built a tool that transforms meetings into actionable insights using AI-powered transcription, smart summaries, and intelligent analysis.
  • T

    Telus Data for Good

    Toronto, Ontario

    Developed a machine learning model to predict traffic congestion during the Taylor Swift Eras Tour in downtown areas. The model identified high-risk zones for congestion and provided actionable recommendations for traffic management, enhancing the flow and minimizing delays during the event
  • W

    Walmart Hackathon

    Toronto, Ontario

    We proposed a model to prioritize store space allocation based on department sales efficiency and availability, addressing Walmart's challenge of reducing store size while maximizing product display to enhance product visibility in compact layouts.
Contact

Get in Touch

Want to chat? Just shoot me a dm with a direct question on twitter and I'll respond whenever I can. I will ignore all soliciting.