Hemant Mandge

Data Analyst | Business Analyst

[email protected] +91 8308631578

Resume

Hello, I am

Hemant Mandge.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Data Analyst/Business Analyst with a strong foundation in SQL and Python, eager to leverage analytical expertise to drive data driven insights and inform strategic decision making

Key Skills

Advance Excel

power BI

Python

Communication Skills

tableau

Azure

Promp Engineering

SQL

My Projects

AtliQ Hardware business insights

Domain/Function: Consumer Goods

India EV sales market Analytics

Domain/Function: Automotive

Business Insights for a Strategic Merger in the OTT Domain

Domain/Function: Telecom & Streaming Services

Pixar Animation studios Legacy Analytics

Domain/Function: Movies

Bitcoin Price Tracker

Domain/Function: Automation & Web Scrapping

My Experience

Key Skills:

1) Technical Tools: Advance Excel | MySQL | Power BI | Python | Tableau

2) Analytical Skills: EDA | Data Cleaning | Statistical Analysis(Z-Score, Outliers) | Dashboard Design

3) Domain Knowledge: Business Intelligence | Data Storytelling | Automation

Work Experience:

Mechanical Engineer(Full-Time) | Aug-2015 - Nov 2024

Domain: Automotive (ThyssenKrupp, Tata Motors , OLCI, RNTBCI & COMAU)

• Optimized CAD workflow via Excel-Driven analysis.

• Tracked supplier KPIs(Excel), resolved 50+ manufacturing issues, cutting delays 20%.

• Refurbished 70% legacy tooling via excel cost models, boosting profit-margins by 25%.

• Streamlined supplier data workflows, resolved 100+ conflicts during COVID lockdowns.

• Supported 10+ international projects, standardizing CAD design workflows to enhance cross-functional data Accuracy

Skills Used: MS Excel, Power Point, Cross-functional Team work, Project Management, ERP, Project design budget planning

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

Google Data Analytics Professional Certificate

Google Prompting Essentials

Microsoft Certified Azure Data Fundamentals

Microsoft Power BI Data Analyst Associate

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/hemantmandge/

Call Me

+91 8308631578

GitHub

https://github.com/Hemant22121991

SQL Project

AtliQ Hardware business insights

Domain/Function: Consumer Goods

A SQL-powered analytics solution for Atliq Hardwares - an imaginary leading computer hardware producer in India. Focuses on extracting actionable insights around market operations, product trends, manufacturing costs, and sales performance using SQL queries and stored procedures.

View Project
Engagement

View Project
on GitHUB

output for asked question

Project Details

• Situation: Executives lacked real-time insights for strategic decisions in a competitive market.
• Task: Analyze business data (sales, costs, discounts) to identify growth opportunities.
• Action:
1. Cleaned and normalized data using SQL and Excel.
2. Created stored procedures for dynamic market/customer insights.
• Result: Enabled leadership to prioritize high-margin products and optimize discounts, improving revenue by 15%.

Excel Project

India EV sales market Analytics

Domain/Function: Automotive

Overview This project is a data-driven case study designed to evaluate the electric vehicle (EV) market in India in preparation for AtliQ Motors’ expansion into the region. By simulating the role of a data analyst at AtliQ Motors, I analyzed the Indian EV and hybrid market over the fiscal years 2022

View Project
Engagement

View Project
on GitHUB

Result-1

Result-2

Project Details

• Situation: AtliQ Motors needed data-driven strategies to enter India’s EV market (<2% penetration).
• Task: Analyse FY22–24 trends to identify top markets and growth drivers.
• Action:
1. Cleaned 10k+ rows of sales data in Excel (removed duplicates, normalized prices).
2. Created interactive Power BI dashboards for state-wise revenue and penetration analysis.
• Result: Identified Maharashtra (₹79B revenue) and Goa (7.8% penetration) as priority markets, driving a 56% YoY growth strategy.

PowerBI Project

Business Insights for a Strategic Merger in the OTT Domain

Domain/Function: Telecom & Streaming Services

• Analyzed user demographics, content performance, and pricing models for JotStar & Lio Cinema merger using Excel, SQL, Power BI. • Created interactive dashboards to visualize growth opportunities and presented findings via PowerPoint.

View Project
Engagement

View Project
on GitHUB

This Screenshot is showing overview page, which covers major KPI such as Revenue, total customer, growth % etc by each platform

This Screenshot is showing finance page, which covers all financial KPIs such as Revenue, MoM growth%, revenue by plan, age group etc.

Project Details

A Complete extensive study comparing the performance of two leading OTT platforms, JotStar and LioCinema, as part of a strategic merger analysis. Using Power BI, I developed interactive dashboards that explore:

• Content Library Analysis: Detailed insights into content types, genres, and language distribution.

• User & Subscription Trends: Analysis of user growth, engagement levels, and subscription behavior across different demographics.

• Revenue Insights: Month-over-month revenue growth, plan performance, and strategic recommendations for subscription pricing.

• Strategic Insights: Actionable recommendations to boost user engagement, optimize content strategies, and leverage telecom partnerships.

Project video

Live Interactive Dashboard

PowerBI Project

Pixar Animation studios Legacy Analytics

Domain/Function: Movies

The project is about showing Pixar Animation studios 30 years of Legacy by creating an infographic or interactive visual that showcases the legacy of Pixar films

View Project
Engagement

View Project
on GitHUB

This is the overview page showing important KPIs such as Total Box office collection, Revenue, budget, Average ROI% and total number of movies

This is movie detail page, which includes crucial details such as movie rating, reviews, box office collection, release year and plot

Project Details

This Power BI Desktop project, delivers a comprehensive analytical insight into Pixar Studios’ filmography from 1995 to 2024. The report is structured into multiple sections, each offering a detailed perspective on different facets of the studio’s performance:
1) Overview: Presents a summary of key metrics including the total number of movies, overall box office collections amounting to $17.0bn, and an impressive 278.3% average ROI.
2) Financials: Provides year-over-year revenue figures, production budgets, and a comparative analysis of revenue and ROI by movie.
3) Ratings & Awards: Highlights average movie ratings sourced from IMDB, Rotten Tomatoes, and Metacritic, along with an in-depth look at Academy Award statuses (nominations, wins, and special recognitions).
4) Movie Details: Offers granular information on each Pixar film, such as release dates, runtime, genres, cast and crew details, and box office performance figures.

Live Interactive Dashboard

Python Project

Bitcoin Price Tracker

Domain/Function: Automation & Web Scrapping

A Python-based web scraper that automatically fetches Bitcoin’s price from CoinMarketCap at regular intervals and logs the data into a CSV file. This project is ideal for monitoring Bitcoin trends over time and showcases skills in web scraping, automation, and data handling.

View Project
on GitHUB

result-1

result-2

Project Details

• Situation: Manual price tracking was time-consuming and error-prone.
• Task: Automate Bitcoin price collection and storage.
• Action:
1. Developed a Python scraper using BeautifulSoup to fetch hourly prices from CoinMarketCap.
2. Automated data logging with Pandas and scheduled updates via time.sleep.
• Result: Reduced manual effort by 90% and ensured accurate, timestamped price records.

Skills | Python-Pandas, Web Scrapping, Crypto currency market analysis