MAHIMA YERGUDE

Entry-level Data Analyst and Business Analyst

Chandrapur, Maharashtra 80 · Excellent

About

Entry-level Data Analyst and Business Analyst with hands-on experience in Microsoft Excel, SQL (SSMS), Python, and Power BI. Built an interactive Excel dashboard analyzing 190K+ orders and ₹95.06M in retail sales. Designed a 7-table relational database in SQL Server for a hospital management system using JOINs, stored procedures, and subqueries. Skilled in data cleaning, exploratory data analysis (EDA), and dashboard development to deliver actionable business insights to both technical and non-technical stakeholders.

Skills & Expertise (27)

SQL Advanced

8.5/10

Years Exp

Joins Advanced

8.5/10

Years Exp

Subqueries Advanced

8.5/10

Years Exp

Stored Procedures Advanced

8.5/10

Years Exp

Aggregate Functions Advanced

8.5/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

Slicers Advanced

8.0/10

Years Exp

Microsoft Excel Advanced

8.0/10

Years Exp

Python Intermediate

6.5/10

Matplotlib Intermediate

6.5/10

Seaborn Intermediate

6.5/10

NumPy Intermediate

6.5/10

Pandas Intermediate

6.5/10

MS PowerPoint Intermediate

6.0/10

Years Exp

Stakeholder Management Intermediate

6.0/10

Years Exp

Data Storytelling Intermediate

6.0/10

Years Exp

Cross-Functional Collaboration Intermediate

6.0/10

Years Exp

Problem Solving Intermediate

6.0/10

Years Exp

SQL Server Intermediate

5.5/10

SSMS Intermediate

5.5/10

Tableau Intermediate

5.5/10

Power BI Intermediate

5.5/10

Visual Studio Code Intermediate

5.0/10

Jupyter Notebook Intermediate

5.0/10

PyCharm Intermediate

5.0/10

GitHub Intermediate

5.0/10

Pivot Charts

Work Experience

Data Analysis & Business Intelligence Project

Zomato Sales Analysis Dashboard

Jan 2025 - Jan 2025

Analyzed 190,000+ food delivery orders with total revenue of ₹95.06M to evaluate sales performance and business trends across states, cities, and food categories. Designed and built an interactive Excel dashboard using Pivot Tables, Pivot Charts, and Slicers to visualize monthly and quarterly sales trends, Veg vs. Non-Veg performance, and customer rating patterns. Identified top 5 cities by revenue and uncovered peak sales periods — enabling data-driven decisions for regional marketing and menu optimization.

Relational Database Design & SQL Analysis Project

Hospital Management System

Jan 2025 - Jan 2025

Designed and developed a fully normalized relational database with 7+ tables covering patients, doctors, appointments, treatments, and billing to simulate a real hospital management workflow. Created primary keys, foreign keys, constraints, and relationships to maintain data integrity across all tables; managed 500+ sample records for testing and reporting. Wrote 15+ SQL queries using JOINs (INNER, LEFT, RIGHT), aggregate functions (COUNT, SUM, AVG), subqueries, and stored procedures to extract insights such as monthly revenue by department and doctor-wise patient load.