1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About

Hey Everyone,

I’m Mayur M, a data enthusiast with 5+ years of experience in Finance Operations, Billing analytics, Accounts Receivables, and Supply chain operations. I am Skilled in Excel, SQL, Python, and Power BI. I’m passionate about turning data into actionable insights that drive results.

I’m here to connect, collaborate, and grow alongside like-minded professionals. Let’s exchange ideas, explore opportunities, and unlock the true power of data together!

Feel free to connect with me on LinkedIn:https://www.linkedin.com/in/mayur3470/

I am looking forward to being part of this amazing community!
Let’s grow, learn, and unlock the power of data as part of this incredible community!

Key

Skills

Python

MYSQL

PowerBI

Tableau

MS Excel

pandas

numphy

My

Projects

Sales - finance Analytics of AtliQ hardware

Domain/Function: Finance Analytics

Project objective:

Purpose of sales analytics: Empower businesses to monitor and evaluate their sales activities and performance.
Importance of analyzing sales data: Identify sales patterns and track key performance indicators (KPIs).

Business Insights 360 - Atliq hardware

Domain/Function: Sales / Business Domain

AtliHardware is a company that supplies complex hardware and peripherals to many of its clients. So the sales director of this company is facing many challenges:

The market is growing dynamically, and he is facing issues in terms of tracking sales.

Code - X german drink insights

Domain/Function: Busines Insigts

CodeX, a German beverage company, recently launched its energy drink in India. The marketing team aims to increase brand awareness, market share, and product development. To gather insights, a survey was conducted in 10 cities, generating responses from 10,000 respondents.

Finding the financial statement

Domain/Function: Finance & Sales

In need of data-driven decisions.
Learnings: Through this project, I gained valuable skills in several areas, including
working with the AIMS grid
performing ETL operations
cleaning and normalizing data
using DAX language to create custom visualizations

Blink IT store inisghts

Domain/Function: Blinkit store insights

Data Domain: What type of data does the file contain (e.g., sales, inventory, customer orders)? Objective: What are you trying to achieve with the data? For example: Identify trends? Resolve operational inefficiencies? Generate specific insights or dashboards? Challenges: Are there specific issues y

Supply chain insights

Domain/Function: Supply chain analytics

Domain: FMCG (Fast Moving Consumer Goods) | Function: Supply Chain

Problem Statement:

✦ AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India.
✦ Currently operational in three cities Surat, Ahmedabad and Vadodra.

My

Experience

Experience/Projects

· Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).

· Built data models and visualizations in Power BI, and optimized the report with DAX Studio, which improved the report's performance by 5%.

· The dashboard enabled AtliQ hardware to analyze department sales trends, identify trend patterns, and make data-driven decisions, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.

Sales and Finance Analytics - October 2024
[Excel | Pivot Table | Power Query] - GitHub Repository

· Generated a comprehensive P&L report for AtliQ Hardware FY 2022, utilizing advanced features in Excel such as Pivot Tables and DAX to provide granular insights into revenue streams and expense categories.

· Automated data cleaning and processing using Power Query, which can save around 4 hours of repeated manual work, As it used M language for calculations, it provided a better user experience and flexibility.

Consumer Goods Analytics - Ad-Hoc-Insights - December - 2024
[MySQL | Power BI] - GitHub Repository | Google Slides | Dashboards

· Delivered detailed insights on 10 ad-hoc business requests to executive management, using SQL to query a million-row database, resulting in a 15% increase in decision-making speed for executive management.

· Insights and findings from the presentation reduced overall operational costs by approximately 10%.

Blink IT Analytics - Ad-Hoc-Insights - January - 2025
[Power Query, Power BI] - GitHub Repository | Live Dashboard

· Blink IT Dashboards empower businesses to transform raw data into actionable insights by providing real-time, interactive visualizations tailored to specific industry needs. Our dashboards are designed to streamline decision-making, enhance operational efficiency, and drive data-driven strategies, ensuring businesses remain agile and competitive in today's dynamic market environment.

Code X Analytics - Insights December - 2024
[Power BI, SQL] - GitHub Repository | Live Dashboard | SQL Queries

· To extract key insights from survey results to drive marketing strategies.

· I created a report presenting my analysis of the market survey results. From the most preferred energy drink ingredients to effective marketing channels, the survey provided valuable data.

VMware by Broadcom - (Finance Operations)
SaaS Billing - Collection, Accounts Receivable Specialist Nov 2021 - Aug 2024

· Accurately review and release proforma invoices for SaaS products Ensure timely release of all proforma invoice billing.

· Every month and quarter extract the data from the SAP-Fiori and clean the data using Excel/Power Query, create a report/Dashboards using Power BI, and update it to management for a quick insight into the data.

· Work with the Automation and IT teams to Automate the process on the billing engine and reduce the work by 25% significantly and Efficiently.

· Contact customers via email, to follow up on overdue invoices and escalate unresolved issues to legal or senior management as necessary.