Portfolio - Shubham Mani Tripathi

Hello, I am

Shubham Mani Tripathi

Data Analyst

About Me.

I am a Data Analyst with three years of experience, skilled in transforming data into actionable insights that drive business growth. At M3M India Pvt Ltd, I generate and maintain sales reports, track key performance indicators (KPIs), and analyze sales data to identify trends. My work has contributed to a 10% increase in quarterly sales by improving data accuracy and enhancing sales forecasting through advanced Excel techniques.

In my previous role as an MIS Analyst at Odicea Distribution Technologies (1K Kirana), I developed automated dashboards and maintained sales tracking reports, which led to a 15% improvement in reporting accuracy and a 30% reduction in manual tracking time. These enhancements streamlined operations and improved decision-making efficiency by 20%.

My background also includes software development at Satin Credit Care, where I built web applications using HTML, CSS, JavaScript, Java, and Spring Boot. This experience strengthened my technical skills and problem-so

1

Excel Project

1

PowerBI Project

Skills.

Power BI

Excel

SQL

salesforce

python

Projects.

My Experience.

Data Analyst -M3M India Pvt Ltd

04/2023 - 03/2025

Generated and maintained comprehensive sales reports by integrating data from Salesforce into Power BI, SQL, and Excel, tracking key performance indicators (KPIs) for senior management review.
Analyzed sales data using Power BI and SQL to identify trends, opportunities, and areas for improvement, contributing to a 10% increase in quarterly sales.
Utilized advanced Excel functions like pivot tables and VLOOKUP to manage and analyze sales data, ensuring accuracy and efficiency.
Developed Python scripts to automate data analysis, identify sales patterns, and enhance forecasting, improving decision-making processes.

MIS Analyst- Odecia Distribution Technologies (1k Kirana)

11/2021-03/2023

Built automated dashboards using Power BI and Excel, increasing report accuracy by 15% and reducing manual effort built by 30%.
Enhanced system efficiency by 25% through the implementation of database management solutions in SQL and GoogleSheets.

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

Contact.

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.

Download CV

[email protected]

Call Me

+91 9956681703

https://www.linkedin.com/in/shubhammanitripathi/

GitHub

https://github.com/mani9k9

Excel Project

Sales and Finance Analytics

Domain/Function: Sales & Finance

Sales Report: Track customer performance and compare market results against sales targets to assess patterns and KPIs. Reports guide discounts, consumer negotiations, and identify growth areas. Finance Report: P&L by fiscal year/months and markets to inform financial strategy.

View Project
on GitHUB

Customer Performance report

P&L Statement

Project Details

Sales Report:
The objective is to create a customer performance report and compare market performance with sales targets. Sales analytics empower businesses to monitor and evaluate sales activities. Analyzing sales data helps identify sales patterns and track KPIs, providing insights for strategic decision-making. The reports play a crucial role in determining customer discounts, aiding in negotiations, and identifying potential expansion opportunities.

Finance Report:
The objective is to generate P&L reports by fiscal year, months, and markets. Financial analytics evaluate performance, support decision-making, and aid in communication with stakeholders. Analyzing financial data helps in benchmarking against peers and previous periods, forming the basis for budgeting and forecasting. Reports align financial planning with strategic goals and build confidence in the organization's financial outlook.

PowerBI Project

Business Insight

Domain/Function: Business

This Power BI project involved importing data from SQL and analyzing key metrics like Net Sales, Gross Margin, and P&L. It included creating detailed reports that provided actionable insights into business performance.

View Project
Engagement

Other Tools

SQL

Finance View

Sales View

Project Details

This Power BI project focused on importing and transforming data from SQL to analyze key business metrics, including Net Sales, Gross Margin, and Profit & Loss (P&L). The analysis provided insights into performance across various regions, customer segments, and product categories. Using Power BI, I developed dynamic dashboards and visually compelling reports that allowed stakeholders to track sales trends, compare targets with actual performance, and identify areas for improvement.

Advanced DAX functions were employed to perform complex calculations, enabling a deeper understanding of business operations. I also integrated supplementary data to create a comprehensive view of performance and utilized Excel for data preparation, ensuring accurate results before importing into Power BI.