Manas Dubey

Data Aspirant

[email protected] +91 07275263069

Resume

Hello, I am

Manas Dubey.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

I am a data analyst with a background in mechanical engineering and a passion for turning raw data into meaningful insights. With expertise in SQL, Python, and Power BI, I specialize in extracting, transforming, and analyzing data to help businesses make informed decisions. My experience spans various industries, where I have worked on optimizing production processes and improving operational efficiency. I’m currently focused on building skills in advanced data analytics, including visualization and reporting, to drive business growth and efficiency.

Key Skills

SAP

Tableau

Power BI

SQL

Advanced Excel

My Projects

Diwali Sales Analysis Using Python

Domain/Function: Sales Analysis, Data Analytics

Pizza Sales Data Analysis Using SQL

Domain/Function: Retail/Food Services (Pizza Sales Analysis)

Astral Adhesive Sales Performance Dashboard

Domain/Function: Sales Analysis / Supply Chain

Business Insights 360

Domain/Function: Enter Sales Analysis.

Astral Adhesive Sales Performance Overview

Domain/Function: Sales Performance Analysis, Market Data

My Experience

Maintenance Analyst
Astral Adhesive, Kanpur, Uttar Pradesh
July 2024 - Present
• Analyzed maintenance data using SAP and Power BI, reducing equipment downtime by 20%.
• Created real-time dashboards for key metrics, driving data-driven decisions.
• Automated data extraction and reporting processes, cutting manual tasks by 30%.

Planning Engineer
Kanpur Plastipack Ltd, Kanpur, Uttar Pradesh
August 2023 - July 2024
• Optimized production schedules for 200+ looms using data analysis, achieving 10% cost savings.
• Developed Power BI dashboards to track production performance and improve efficiency.
• Delivered actionable insights through data reporting, reducing waste and downtime.

Awards & Certificate

Python: Beginner to Advanced For Data Professionals

SQL Beginner to Advanced For Data Professionals

Excel: Mother of Business Intelligence

Tableau Mini

● IBM Introduction to Data Analytics

● Data Analytics and Databases on AWS

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

Call Me

+91 07275263069

GitHub

https://github.com/manas74

Python Project

Diwali Sales Analysis Using Python

Domain/Function: Sales Analysis, Data Analytics

This project analyzes Diwali sales data using Python for exploratory data analysis (EDA). It involves data cleaning, handling missing values, and visualizing trends across demographics, product categories, and regions. Key insights help businesses target sales strategies effectively during Diwali.

View Project
Engagement

View Project
on GitHUB

Other Tools

Pandas

NumPy

Seaborn

Matplotlib

Visualization of Diwali sales data showing trends across age groups, product categories, and states.

Bar charts visualizing sales across different states, highlighting Uttar Pradesh and Haryana as top contributors.

Project Details

The Diwali Sales Analysis project uses Python to process and analyze a dataset of over 11,000 records, focusing on customer demographics, purchasing patterns, and product categories. The analysis includes data cleaning, filling missing values, and visualizing trends using Matplotlib and Seaborn. The insights gathered include top-selling age groups, product preferences, and state-wise purchasing behavior. The results guide marketing efforts for maximizing sales during Diwali.

SQL Project

Pizza Sales Data Analysis Using SQL

Domain/Function: Retail/Food Services (Pizza Sales Analysis)

Analyzed over 21,000 pizza orders using SQL to uncover key sales trends, peak ordering times, and the top revenue-generating pizzas. The insights are used for strategic marketing and operational decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

MySQL

SQL Server

Orders peak at noon with 2,520, closely followed by 1 PM with 2,455 and 6 PM with 2,336.

Chicken pizzas carve out 19.1%, Classics lead with 26.9%, Supremes slice up 26.6%, and Veggies sprout to 27.4% of total revenue.

Project Details

This project involves analyzing pizza sales data using SQL. It highlights trends such as peak order hours, the most ordered pizza sizes, top-performing pizza types, and revenue analysis. The dataset includes 21,350 orders, leading to a total revenue of $817,860. Recommendations focus on improving sales based on customer preferences and high-demand periods.

PowerBI Project

Astral Adhesive Sales Performance Dashboard

Domain/Function: Sales Analysis / Supply Chain

A comprehensive Power BI dashboard analyzing over $997K in sales, showcasing distribution by outlet, sales trends over time, and performance metrics across various adhesive categories and outlet types.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power BI

Microsoft Excel

SQL Server

Light-use adhesives contribute 65% of sales ($645K), heavy-duty 35% ($353K).

Retail outlets lead with $787.5K in sales, followed by distribution centers ($131.5K).

Project Details

Developed an intricate Power BI dashboard to visualize sales data for Astral Adhesive, integrating diverse data sets to offer insights on sales trends, outlet performance, and customer ratings. The dashboard facilitates strategic decision-making by displaying key metrics such as total sales ($997.2K), average sales ($141.2), and average rating (3.9) with detailed breakdowns by product type and sales outlet.

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Enter Sales Analysis.

The Atliq Hardware project uses a Power BI dashboard to track sales, profits, and forecasts across regions and product categories. It analyzes key metrics like net sales, gross margins, and forecast accuracy, offering insights into performance, risks, and yearly trends. Data is refreshed monthly.

View Project
Engagement

View Project
on GitHUB

Other Tools

PowerBI

SQL

Detailed profit and loss statement including gross sales, net sales, deductions, and cost of goods sold, with percentage changes.

Performance analysis by region, showing P&L values and percentage changes across APAC, EU, LATAM, and NA regions.

Project Details

Atliq Hardware, a company involved in the sales of various technology products, seeks to improve business decision-making by analyzing key financial, operational, and sales metrics through the use of Power BI dashboards. The goal is to enhance visibility into key performance indicators such as gross sales, net sales, gross margins, forecast accuracy, and customer performance across different regions and product segments. The company faces challenges in several areas, including rising operational expenses and decreasing profitability, despite maintaining strong gross margins.

Live Interactive Dashboard

Excel Project

Astral Adhesive Sales Performance Overview

Domain/Function: Sales Performance Analysis, Market Data

This project analyzes the sales performance data of various customers for the Astral Adhesive brand, covering the years 2019 to 2021. The data includes sales across different stores, regions, and sub-zones, highlighting year-over-year growth percentages.

View Project
Engagement

View Project
on GitHUB

Other Tools

PowerQuery

A detailed table showing net sales growth from 2019 to 2021 for key customers such as Amazon and Flipkart, with percentage increases highlighted.

A comparison chart visualizing year-over-year sales performance for major retailers, showcase the top performers in terms of sales growth percentage.

Project Details

The project provides an in-depth analysis of sales performance for Astral Adhesive, highlighting significant growth across various retail channels from 2019 to 2021. The Excel data includes customer names, net sales for the three years, and percentage changes, allowing for a clear comparison of sales performance and trends.