Work Experience

Business Intelligence Data Analyst

Midnight Customs | Bolton ON

September 2024 – April 2025

Business AnalysisData Analysis
Business Intelligence Data Analyst

About the Work:

As the BI Data Analyst, I built a scalable relational database in MySQL to streamline customer, vendor, and technician operations. I integrated department workflows and used advanced SQL queries to analyze technician productivity and optimize service distribution. Using Power BI, I developed dashboards that revealed revenue trends by service type, helping identify high-profit areas and reduce inefficiencies. These insights enabled smarter business planning and boosted operational efficiency by approximately 25% in just a few months.

Projects

Project Screenshot

Clinic Database

MySQL

Built a normalized relational database for clinic operations using MySQL and SQL Server. Designed an ERD, created schema, inserted data, and wrote optimized SQL queries to manage patients, staff, and appointments.

Project Screenshot

Sales Dashboard

MS Excel

Analyzed customer purchasing patterns using Excel. Performed data cleaning, used Pivot Tables and advanced formulas, and built an interactive dashboard to visualize trends and insights./

Project Screenshot

Survey Breakdown

Power BI

Analyzed global survey data on compensation, satisfaction, and tool usage among data professionals. Cleaned data using Power Bl Query Editor and built interactive dashboards with bar charts, pie charts, and gauge visuals.

Project Screenshot

Data Cleaning

Python

Cleaned and transformed datasets with Pandas, scraped web data using BeautifulSoup. and visualized insights with Matplotlib and Seaborn. Projects include EDA, automation scripts, and a customer behavior analysis.

Project Screenshot

Sales Analysis

Tableau

Designed an interactive Tableau dashboard to visualize global video game sales by region, genre, platform, and publisher. Focused on clean Ul, interactivity, and storytelling through visuals rather than deep statistical modeling.

Project Screenshot

Microsoft Azure project

Azure

Will create a full cloud-based data solution using Azure Data Factory (data ingestion & cleaning), Azure SQL (storage), Azure ML Studio (optional modeling), and Azure Web App (dashboard hosting). Focused on cloud workflows, automation, and real-time insights.}

Comming Soon...

About Garv

Data Analyst | Developer

I'm Garv, a Data Analyst with over 4+ years of knowledge and 1.5+ years of hands-on experience in the field. I've worked extensively with data tools to turn raw data into clear, actionable insights. My specialty lies in engineering data structures, cleaning messy datasets, building dashboards, performing statistical analysis, and uncovering business trends that drive informed decision-making. I've led team meetings for 10+ members, using my presentation skills to clearly explain project goals and assign tasks based on structured data strategies. This approach has consistently ensured smooth teamwork, high-quality output, and a strong on-time project delivery rate.
Profile (Desktop)
Currently, I am studying Computer Programming at George Brown College, where I'm learning SQL, Data Analysis, Application Development, Linux, and Full-Stack Development. I've completed aData Analytics course through Skill Course E-Learning, a Website Development program from The Johns Hopkins University, and aMarketing & Analyzing program from Aptech Learning. I also hold ahigh school diploma in Mathematics and Computer Science, with a strong focus on Programming and Data Structures.

Recently, I worked as a Business Intelligence Data Analyst atMidnight Custom Automotive, where I built a relational database from scratch, optimized records, and created dashboards that improved decision-making and service quality. Alongside this, I've completed multiple academic and personal projects includinghealthcare analytics, e-commerce price optimization, survey data insights, resume screening automation, and web scraping. These projects were built using MySQL, Power BI, Excel, and Python libraries such as Pandas, NumPy, and Matplotlib. I'm also experienced with Agile/Scrum methodologies, ETL processes, A/B testing, and cross-functional collaboration. I always approach my work with focus, discipline, and the goal of delivering accurate, data-driven solutions that add real value.
Address

Greater Toronto Area

Social