Shelly Nagar

Data Aspirant

[email protected]

Resume

Hello, I am

Shelly Nagar.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About Me

Hi, I’m Shelly Nagar, a Data Analyst deeply passionate about the entire process of transforming raw data into actionable insights. I am driven by the excitement of unraveling data’s hidden stories and using them to inform smarter business decisions. My proficiency lies in analyzing, cleaning, and visualizing data using tools like Power BI, Tableau, Excel, SQL, and Python. I’ve created dynamic, interactive dashboards that simplify complex data into meaningful narratives across sectors like e-commerce, supply chain, and retail. With a background in Mechanical Engineering and experience as a Management Trainee, I consistently use data to identify inefficiencies, streamline processes, and boost productivity. Data analysis is not just my expertise but my passion, and I thrive on turning challenges into opportunities for improvement. Let’s connect and collaborate to turn data into impactful solutions for business success!

Key Skills

SQL

Tableau

Python

Project Management

Problem Solver

Stakeholder Management

Business Communication

Power BI

Advanced Excel

Statistical Analysis

MySQL

My Projects

Sales & Finance Analytics Report

Domain/Function: Consumer Goods

Business Insights 360

Domain/Function: Retail & Consumer Goods

Supply Chain Performance Report

Domain/Function: FMCG/Strategy

Ad Hoc Business Insights for AtliQ Hardware

Domain/Function: Consumer Goods/Executive Management

Personal Expense Tracker with Analytics

Domain/Function: Personal Finance

Customer Behavior Analysis Project

Domain/Function: Banking/Strategy

My Experience

Aarti Industries Limited, Gujarat, India—Management Trainee
Jul 2022 – Jun 2023

Enhanced data quality by 20% and boosted team productivity by 20% through strategic data analysis, dashboard creation, root cause analysis, and resolving performance bottlenecks.
Reduced project timelines by 25% and minimized delays by 15% by utilizing tools like Google Sheets, Primavera, and SAP, while also increasing reporting accuracy by 15%.
Delivered data-driven insights via clear presentations to stakeholders, further reducing project timelines by an additional 10%.
Collaborated effectively with stakeholders to gather requirements, assess risks, and ensure outcomes aligned with business objectives.
Maintained comprehensive documentation, focusing on key metrics and usability, while resolving issues efficiently.

Excelerate, Remote - Data Visualization Associate
Feb 2025–Mar 2025

Cleaned and structured datasets (~47K records), improving data integrity by 95% using statistical methods like outlier detection and missing data imputation.
Optimized data workflows and reporting processes with Python, Excel, and Power Query, reducing refresh lag by ~50%.
Created interactive dashboards in Power BI and Looker Studio, enhancing stakeholder engagement by 30%.
Collaborated with a global team, improving coordination by 35% through task documentation and team charter creation.

Excelerate, Remote - AI Data Analyst Intern
Feb 2025–Mar 2025

Conducted in-depth exploratory analysis on 8.5K+ engagement records, applying statistical techniques like correlation analysis and hypothesis testing to identify 15–20% churn drivers.
Built 4 predictive models (Random Forest, SVM, etc.), achieving 90% churn prediction accuracy.
Provided actionable insights to improve student retention, leading to a 10% increase in participation rates.
Collaborated with a global team to document data processing workflows and recommendations for process improvement.

Awards & Certificate

Excel: Mother of Business Intelligence

Tableau Mini

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Data Analysis with Python

Data Visualization with Python

Data Analyst Associate Internship

AI Powered Data Analysis Virtual Internship

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

GitHub

https://github.com/shellynagar27

Excel Project

Sales & Finance Analytics Report

Domain/Function: Consumer Goods

Analyzed AtilQ Hardware's sales and financial performance from 2019 to 2021, uncovering key trends in customer behavior, gross margin, and product performance to support decision-making, financial forecasting, and strategic planning for business expansion and stakeholder communication.

View Project
Engagement

View Project
on GitHUB

2021 Country-wise table comparing Net Sales, Gross Margin, COGS, and Gross Margin % to analyze performance across various regions.

2021 analysis of Top 10 products by net sales, Top 5 countries, Bottom 5 products by quantity, and new products for clear insights on performance.

Project Details

What I Have Done:
Used Power Query to extract, transform, and optimize large sales and finance datasets. Built data models with Power Pivot and created DAX measures for key metrics (net sales, gross margin, COGS). Developed Pivot Tables to analyze data (country, division, customer levels) for 2019-2021. Designed financial & Sales reports (P&L, performance) with conditional formatting to highlight trends.

Key Learnings:
Gained proficiency in ETL processes, Pivot Tables, and DAX for financial modeling. Acquired expertise in financial forecasting, product performance, and customer segmentation.

How It Can Be Used:
Analyzing sales patterns optimizes marketing and resource allocation. Understanding customer behavior refines discount strategies and strengthens supplier negotiations. Financial benchmarking enhances performance reviews and budgeting. Clear KPI communication builds trust and aligns teams with company goals.

PowerBI Project

Business Insights 360

Domain/Function: Retail & Consumer Goods

Developed a comprehensive Power BI dashboard for AtliQ Hardware to monitor sales, finance, and supply chain metrics. The solution enhances decision-making and optimizes operational efficiency.

View Project
Engagement

View Project
on GitHUB

Showcasing a complex data model with millions of rows, connecting multiple dimension and fact tables, optimized for real-time business insights.

Shows top 5 customers/products by revenue, zone-wise performance, PC market share trends (2018-2022), and key KPIs like net sales and gross margin%.

Project Details

What I have done:
Developed a comprehensive Power BI dashboard for AtliQ Hardware, integrating data from MySQL, Excel, and other sources. Designed dashboards for sales, finance, and supply chain, showcasing KPIs like net sales, gross margin, and forecast accuracy.
Key learnings:
Enhanced skills in DAX functions, query optimization, and Power BI features such as bookmarks, tooltips, and conditional formatting. Gained experience in data modeling (star schema) and automated data refreshes using SharePoint and Teams.
How it can be used:
The dashboard can be used for monitoring financial performance, identifying underperforming customers, and supporting data-driven decisions. It might be suitable for sales and operations planning (S&OP) teams, finance, and marketing departments.

Project video

Live Interactive Dashboard

PowerBI Project

Supply Chain Performance Report

Domain/Function: FMCG/Strategy

Developed a Power BI dashboard to track OTIF (On Time In Full) metrics for AtliQ Mart’s supply chain. Analyzed 50k+ rows of data to identify performance gaps, delivery delays, and inefficiencies, providing actionable insights for improvement.

View Project
Engagement

View Project
on GitHUB

Breakdown of customers by OT% and IF%, crucial for priority service focus.

Customer analysis with heatmap of key metrics and LIFR% chart, highlighting delivery and fulfillment performance by customer.

Project Details

What I have done: Built a Power BI dashboard to track and analyze OTIF metrics and other key performance indicators (KPI) for AtliQ Mart, utilizing Power Query for ETL and DAX for metric calculation.
Key Learnings: Gained expertise in ETL, data modeling, and building complex measures like OT%, IF%, and OTIF%. Improved skills in performance analysis and creating actionable insights from raw data.
How it can be used: This dashboard can be used for daily tracking of supply chain performance, identifying delivery bottlenecks, and making data-driven decisions to optimize logistics and inventory management.

Project video

Live Interactive Dashboard

SQL Project

Ad Hoc Business Insights for AtliQ Hardware

Domain/Function: Consumer Goods/Executive Management

Analyzed business data using SQL to generate actionable insights for AtliQ Hardware's management. Queries addressed diverse business needs, such as sales trends, product performance, and customer discounts, presented via charts and presentations to drive strategic decisions.

View Project
Engagement

View Project
on GitHUB

A bar chart showing top-selling products per division, aiding strategic inventory planning.

Table and line chart depicting sold quantities by quarter, highlighting peak performance for strategic insights.

Project Details

What I have done:
Designed and executed SQL queries for 10 ad-hoc requests.
Created visualizations for insights and video presentation for the executive team.
Key Learnings:
Advanced SQL techniques such as CTEs, JOINs, and stored procedures.
Translating raw data into impactful visualizations for decision-makers.
How it can be used:
This project can help businesses generate quick insights for strategic decisions, identify trends, optimize inventory, evaluate product performance, and understand customer behavior, making it ideal for roles in analytics, BI, or operations.

Project video

Python Project

Personal Expense Tracker with Analytics

Domain/Function: Personal Finance

A full-stack expense management system using Streamlit and FastAPI for daily expense tracking, updating, and detailed analysis by category and month, helping users understand their spending habits better.

View Project
Engagement

View Project
on GitHUB

Visualization of expenses by category between two specified dates for better understanding of spending habits.

Displays expenses recorded on a specific date.

Project Details

What I have done: Developed a full-stack personal expense management system with a Streamlit frontend and a FastAPI backend. Users can add, update, and analyze expenses by category or month, while the backend handles the data storage and retrieval using MySQL.
Key Learnings: Gained insights into building scalable full-stack applications, MySQL integration with FastAPI, efficient data handling with pydantic, and using Streamlit for creating interactive visualizations.
How it can be used: This system can be used for personal finance management, expense tracking, and analytics, and might be suitable for individuals or small businesses looking to get insights into their spending patterns.

Customer Behavior Analysis Project

Domain/Function: Banking/Strategy

Conducted a data-driven analysis for Mitron Bank using Tableau to design a customer insights dashboard, examining demographics, spending patterns, and income utilization. The project provided strategic recommendations to tailor credit card features for high-value segments.

View Project
Engagement

View Project
on GitHUB

Demographic insights dashboard displaying customer segmentation by age, gender, and income class.

Spend analysis showing category trends with interactive filters for month and payment mode insights.

Project Details

What I Did: Analyzed customer demographics, spending habits, and income data for Mitron Bank using Tableau, creating a multi-layered dashboard to reveal insights for credit card strategy. Established parameters, calculated fields, and button-switching for dynamic visualization.
Key Learnings: Enhanced skills in Tableau's advanced visualization techniques, Excel Direct Method for sheet swapping, data modeling, and parameter-driven interactivity.
How It Can Be Used: This approach might be suitable for companies in finance looking to tailor products based on customer segments or other industries needing data-driven strategy insights.