Portfolio - Simran Pathak

Hello, I am

Simran Pathak

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Hey there! I'm Simran, diving into the world of data analysis with a whole bunch of excitement! Armed with a Master's degree in Information Management from Syracuse University, New York, I'm all about cracking the data code using cool tools like Excel, PowerBI, SQL, and Python.

Now, I might not have punched the clock in a big office yet, but I've been busy cooking up some awesome projects. Seriously, you can check them out in my portfolio below. I'm all about turning raw data into useful info.

Sure, I'm a bit of a newbie, but I'm a fast learner and super passionate about turning numbers into stories. I want to bring my love for crunching data to your team and show you what I can do.

So, buckle up! Let's make data fun and use it to do some awesome stuff together. Ready for a data adventure? Let's go! 🚀

Key

Skills

Python

SQL

Tableau

Problem Solving

Stakeholder Management

Data Modeling

My

Projects

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

Business Insight 360

In the Power BI Business Insights 360 Project, I transformed Atliq Hardwares global sales data into real-time insights, offering P&L snapshots, YoY sales analysis, and executive summaries. This strategic tool empowers businesses with decisive decision-making capabilities in a dynamic market

Contact Me

Email

[email protected]

Github

https://github.com/simipat

https://www.linkedin.com/in/simran-pathak

Call

+1 7818562588

Simran Pathak

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics(FMCG)

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I crafted an advanced Sales and Finance analytics system in Excel, utilizing pivot tables, ETL, Power Query, and grasping DAX basics. The goal was to empower businesses with actionable insights for effective customer negotiations, strategic expansion, and revenue optimization.

Key Learnings:

Pivot Table Mastery: Distilled complex sales data for strategic decision-making.
ETL Expertise: Streamlined data flow for accuracy and relevance.
Power Query Prowess: Automated data cleansing and transformation for efficiency.
DAX Fundamentals: Laid the foundation for sophisticated data modeling.
Visual Appeal: Implemented conditional formatting for clear, engaging reports.

This project equips businesses with the tools to make informed decisions, enhance customer satisfaction, and maximize revenue in a competitive market landscape.

PowerBI Project

Business Insight 360

View Project
on GitHUB

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

🌐 Managed global hardware sales for Atliq Hardwares via diverse channels (Retailers, Direct, Distributors).
📊 Executed the Business Insights 360 Project on Power BI for real-time views: Finance, Sales, Marketing, and Supply Chain.
💹 Finance: Conducted P&L analysis, monitored YoY sales changes, and highlighted key metrics.
📈 Sales: Analyzed net sales, gross margin %, and COGS by customer, emphasizing PC division dominance at 61.33%.
📣 Marketing: Assessed net profit % and gross margin % by segment, noting challenges in APAC with a net profit of -14.62%.
🔄 Supply Chain: Evaluated forecast accuracy, net error, and absolute error by customer, identifying areas for improvement.
📊 Executive: Presented yearly trends in revenue, GM%, NP%, and market share %, providing insights into segment revenue and channel performance.
🚀 Facilitated data-driven decisions by delivering comprehensive insights into financials, sales, marketing, and supply chain dynamics.

Hello, I am

Simran Pathak

1

1

About

Key

My

Sales Analytics(FMCG)

Business Insight 360

Contact Me

Email

Github

Linkedin

Call

Simran Pathak

Download Resume