Mohit Gandhi

Data Analyst

[email protected] +91 7772974582

Resume

Hello, I am

Mohit Gandhi.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

I'm an aspiring Data Analyst with a B.Tech in Computer Science and a passion for turning data into insights. Skilled in Excel, Power BI, SQL, and Python, I specialize in analyzing datasets to uncover trends and support smart business decisions.

Though I started my career as a Software Engineer, I found my true strength in data analysis. I've applied my skills to real-world business projects, many of which are showcased in my portfolio below. These projects highlight my ability to solve problems, find patterns, and deliver data-driven solutions.

I’m now focused on growing in the analytics field and excited to bring value to organizations through clear insights and thoughtful analysis.

Key Skills

Excel

Sql

Python

Data Cleaning & Preprocessing

ETL Processes

Databases

Power BI

Statistics

My Projects

Sales and Finance Analytics

Domain/Function: IT Hardware Sales Analysis

Comprehensive Business Insights 360 Dashboard: Finance, Sales, Marketing, and Supply Chain

Domain/Function: IT Hardware

AtliQ Sales Analysis SQL Project

Domain/Function: Consumer Goods

My Experience

Associate Software Engineer

Supersourcing (India's Top 20 Startup - LinkedIn 2024), Indore | July 2024 – August 2025

Developed FastAPI-based backend processing 500+ resumes daily, automating resume parsing and reducing manual screening time by 50%.
Optimized MongoDB queries handling 10,000+ records, improving API response time by 30% and system throughput by 25%
Integrated 8+ RESTful APIs with frontend systems, accelerating development cycles by 25% and reducing deployment time from 3 days to 2 days
Collaborated with 5-member analytics team to deliver real-time job application tracking modules, processing 1,200+ applications weekly

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/mohit-gandhi358/

Call Me

+91 7772974582

GitHub

https://github.com/MohittGandhi

Excel Project

Sales and Finance Analytics

Domain/Function: IT Hardware Sales Analysis

Created detailed reports for the sales team, enabling them to assess customer performance metrics, understand progress towards sales objectives, and strategize effectively for future growth opportunities.

View Project
Engagement

View Project
on GitHUB

Yearly Report on Market vs. Target: Helps see how well a country did and if it met its targets.

Customer Sales Report: Shows how much each customer bought over the years.

Project Details

I made a sales report in Excel to help businesses offer better discounts, negotiate with customers, and find new markets to grow in. The report gives clear advice on how to boost sales and make customers happier.

I learned:

Using pivot tables
Power Query
Basic DAX
Formatting data
Making reports look good
Important sales metrics
This project helps businesses track sales better and find ways to grow. Analyzing sales data can help companies find new chances to succeed and keep up in the changing market.

PowerBI Project

Comprehensive Business Insights 360 Dashboard: Finance, Sales, Marketing, and Supply Chain

Domain/Function: IT Hardware

AtliQ Hardwares, a growing electronics company, struggles with Excel-based reporting. This project introduces a Power BI solution to deliver key insights and support smarter, data-driven decisions across the organization.

View Project
Engagement

View Project
on GitHUB

Landing Page Designed with User Empathy as an Integral Element of the Dashboard

Comprehensive Data Modeling Across Over 10 Tables

Project Details

The aim of this project was to create a unified Power BI report accessible to teams in Sales, Marketing, Finance, and Executive Leadership. The report focused on strong data modeling, intuitive design, and interactive, drill-down insights.

Key Learnings & Achievements:

- Worked extensively with Power Query, applying both basic and advanced operations.
- Developed a range of DAX formulas, from simple measures to complex calculations.
- Built a comprehensive data model involving more than 10 related tables.
- Strategically selected and formatted visuals for clear, impactful reporting.
- Followed dashboard design best practices for usability and readability.
- Implemented bookmarks to enable dynamic and interactive report views.
- Deployed the report using Power BI Service for easy stakeholder access.
- Incorporated feedback from stakeholders to improve functionality and clarity.
- Integrated key performance metrics from Sales, Marketing, Finance, and Supply Chain.

SQL Project

AtliQ Sales Analysis SQL Project

Domain/Function: Consumer Goods

AtliQ Hardwares, a top computer hardware company, struggled with data-backed decision-making. Through SQL analysis of critical business data and a well-structured PowerPoint presentation, we delivered actionable insights that supported smarter, growth-focused strategies.

View Project
on GitHUB

1. use fact_sales_monthly, dim_product tables 2. concepts like CTEs, filtering, Group by, Aggregate function(sum), Rank, Partition By

1. use fact_sales_monthly table 2. To get the unique product count, use the product_code column.

Project Details

AtliQ Hardwares launched a SQL-based challenge to grow its analytics team by replicating real-world business scenarios. I solved 10 business problems by writing optimized SQL queries, extracting insights, and presenting them in an executive-level report. This required strong skills in data modeling, performance tuning, and business analysis to uncover trends and support data-driven decisions.

Key Takeaways:

Advanced SQL: Used joins, CTEs, subqueries, and window functions.

Data Analysis: Identified key trends, outliers, and business drivers.

Insightful Reporting: Structured findings for strategic use by leadership.

Business Impact: Showcased how data can guide operational improvements.

This project helped me strengthen my ability to analyze complex data, write efficient queries, and translate insights into clear, actionable recommendations.