Supriya Jagdale

Data Aspirant

[email protected] +91 9545840357

Resume

Hello, I am

Supriya Jagdale.

1

Excel
Project

2

PowerBI
Projects

2

Python
Projects

1

SQL
Project

About Me

Hi there! I'm a biotechnologist turned data analyst with a knack for turning complex data into actionable insights. After four years in a top pharmaceutical company, I've mastered the art of data analysis and interpreting datasets and conducting scientific research. Now, I'm diving into the world of data science, armed with IBM and Google and Codebasics courses and skills in Power BI, SQL, and Microsoft Excel and Python. When I'm not crunching numbers, you might find me trying to train my dog to fetch or baking cookies that my friends swear could double as paperweights. I believe in making data fun and accessible, and I'm excited to blend my scientific background with my passion for analytics to drive impactful business decisions. Let's decode some data magic together!

Key Skills

SQL

Python

Power BI

Microsoft Excel

My Projects

Sales and Finance Analytics

Domain/Function: Sales and Finance Analytics

Business Insights 360

Domain/Function: Business Analytics

Hospitality Domain Data Analytics

Domain/Function: Business Analytics

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods-Executive Management

PwC Churn Analysis

Domain/Function: HR analytics

Analysis of Historical Data of Stock Revenue

Domain/Function: Financial Analytics

My Experience

Data Analyst Trainee, Atliq Technologies, Remote (Aug 2024-Present)

Conducted weekly data cleaning for datasets up to 50K rows using Excel and Power Query.
Leveraged SQL and Power BI to create impactful dashboards for data visualization and business insights.

Data Analyst Trainee, MedTourEasy, Remote (Apr 2024-May 2024)

Handled 3 years of patient and resource data and created dashboards in Power BI.
Created financial reports and KPIs, for real time tracking of performance metrics and enabling data-driven decision-making.

Research Associate, Lupin Limited, Pune (Apr 2019-Mar 2024)

Led analytical testing within a Formulation Development team, ensuring drug product quality and compliance with industry standards.
Performed data generation and validation of method and report migration to Power BI, which increased the effectiveness by 20%.

Research Intern, Thermofisher Scientific, Bengaluru (Oct 2018-Mar 2019)

Part of Screening and validation team involved in screening mAbs by various techniques.

Awards & Certificate

Data Analytics Bootcamp 5.0: Job Placement Support + AI Automation & Data Engineering Basics

IBM Data Science Professional Certificate

Google Data Analytics Professional Certificate

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/supriya-jagdale/

Call Me

+91 9545840357

GitHub

https://github.com/suppijags

Excel Project

Sales and Finance Analytics

Domain/Function: Sales and Finance Analytics

The Sales and Finance Analytics report for AtliQ Hardwares details 2019-2021 trends, highlighting key metrics and insights essential for strategic planning.

View Project
Engagement

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 developed a comprehensive sales report using Excel pivot tables, which helps businesses identify optimal customer discounts, support consumer negotiations, and pinpoint potential growth markets in promising countries. The resulting reports deliver actionable insights and strategic recommendations to enhance sales strategies, improve customer satisfaction, and boost revenue.

Skills gained include:

Pivot Tables
Power Query
Basic DAX
Conditional Formatting
Report Enhancement
Sales Domain Metrics

This project aims to equip businesses with vital tools and insights to monitor, assess, and improve their sales processes. By analyzing sales data, businesses can uncover new opportunities, foster growth, and maintain a competitive edge in the ever-evolving market landscape.

PowerBI Project

Business Insights 360

Domain/Function: Business Analytics

This Power BI project focuses on unlocking critical business insights by visualizing key performance metrics such as sales trends, financial health, customer behavior, and market dynamics. It empowers stakeholders to make informed decisions, optimize strategies through data-driven analysis.

View Project
Engagement

View Project
on GitHUB

This shows KPIs like Net Sales, Gross Margin %, a Profit and Loss Statement, and trends in sales, highlighting top/bottom customers and products.

The dashboard highlights forecast accuracy, net error, and absolute error metrics, with detailed customer and segment analysis for risk management.

Project Details

The "Business Insights 360" project highlights data analysis and visualization using SQL, DAX, and tools like Power BI Desktop, Excel, and DAX Studio. We transformed raw data into meaningful insights, developing interactive dashboards that showcase detailed business metrics. The expertise in DAX is demonstrated through calculated columns, measures, and dynamic titles.
Project Features:
• Interactive Dashboard for detailed business metrics.
• DAX Skills for calculated columns, measures, and dynamic titles.
• User-Friendly Navigation with bookmarks, buttons, and KPI indicators.
• Power BI Services Exploration for cloud capabilities and auto-refreshing reports.
• Understanding of Key Financial, Marketing, Supply Chain, and Sales Terms like Gross Margin, Net Sales, YoY change, COGS, net error, and forecast accuracy for strategic decisions.
• Executive View providing a quick overview of all company divisions enhancing the ability to make informed business decisions.

Live Interactive Dashboard

Python Project

Hospitality Domain Data Analytics

Domain/Function: Business Analytics

Analysis of Atliq Grand's business data to address declining market share and revenue due to competition. Conducted EDA, data cleaning, transformation, and insights generation. Key insights include occupancy rates, revenue trends, and platform performance for informed decisions.

View Project
on GitHUB

The bar chart shows June 2022's average occupancy rates by city, with Delhi leading, followed by Hyderabad, Mumbai, and Bangalore.

The pie chart shows the distribution of revenue across booking platforms, with "Others" contributing the most,followed by "MakeYourTrip" and "LogTrip"

Project Details

In this project, I worked on Hospitality Domain Data Analytics, focusing on Atliq Grand Hotel, a prominent chain across India for the past 20 years. Recently, due to strategic moves by competitors, the hotel has been losing market share and experiencing revenue declines. To address this, Atliq’s management hired a data analyst to provide data-driven insights. The project involved analyzing various datasets, including Hotel, Rooms, and Bookings, to uncover valuable insights.

I learned and applied the following key concepts:

Understanding and interpreting datasets
Conducting thorough data exploration
Cleaning and preparing data
Transforming data for analysis
Visualizing data to communicate findings
Identifying and handling outliers
Generating actionable insights
Utilizing tools like Pandas and Matplotlib for effective analysis

SQL Project

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods-Executive Management

AtliQ Hardwares, a leading computer hardware producer in India with global reach, lacks sufficient insights for quick, data-informed decisions. The management identified critical ad-hoc requests needing insights. SQL queries were executed to address these requests and visualize the findings.

View Project
on GitHUB

Notebooks and Accessories lead in product variety with 129 and 116 items, respectively; Networking lags behind.

Retailer channel drives 73.2% of sales, while Direct (15.5%) and Distributors (11.3%) contribute less significantly.

Project Details

Atliq Hardwares, a leading computer hardware producer in India with a global presence, seeks to enhance its data analytics capabilities to enable quick, data-informed decision-making. The management has identified a gap in actionable insights. The task was to review the business inquiries, execute SQL queries to derive insights, and create a presentation to communicate these findings to top-level management.

PowerBI Project

PwC Churn Analysis

Domain/Function: HR analytics

Churn analysis using Power BI to identify patterns and predict customer attrition. Leveraged visualizations and data modeling to highlight key factors driving churn, enabling strategic interventions to improve customer retention and reduce churn rates.

View Project
on GitHUB

This represents the demographics and service usage of the customer which shows more % of TV service users & balanced gender distribution.

Highest revenue generating customers are using fibre optics and who have two-year subscription plans

Project Details

This project focused on churn analysis of PwC ,multinational professional services brand of firms, using Power BI to identify key factors driving customer attrition and enhance retention strategies. We analyzed customer behavior, transaction history, and engagement metrics to predict churn patterns. Leveraging Power BI's advanced visualization and data modeling tools, we provided actionable insights to help businesses reduce churn and improve customer loyalty.

Key Features:

Interactive Dashboards: Explore churn trends and segment analysis.
DAX Skills for calculated columns, measures, and dynamic titles.
KPI Tracking: Monitored key retention metrics.
Scenario Analysis: Evaluated potential retention strategies.

Live Interactive Dashboard

Python Project

Analysis of Historical Data of Stock Revenue

Domain/Function: Financial Analytics

As part of the IBM Data Science Professional Certificate, I completed a project where I extracted financial data such as historical stock prices and quarterly revenue reports for Tesla and GameStop using Python libraries and web scraping. I then visualized the data to uncover patterns and trends.

View Project
on GitHUB

In this screenshot, yfinance is used to extract Tesla stock data by creating a ticker object and pulling historical data into a DataFrame.

This screenshot shows web scraping of Tesla revenue data using Python's requests and BeautifulSoup libraries, storing it in a DataFrame.

Project Details

This is one of the assignments completed in IBM Data Science Professional Certificate course. In this project, my job is to extract financial data like historical share price reporting from various sources using Python Libraries and Web scraping on popular stocks. After collecting this data, I will visualize it to identify patterns or trends. The stocks I will work with are Tesla and GameStop.
For this project I have used Jupyter environment for learning and completing labs in courses. Following are the questions addressed:
Question 1 - Extracting Tesla Stock Data Using yfinance.
Question 2 - Extracting Tesla Revenue Data Using Webscraping.
Question 3 - Extracting GameStop Stock Data Using yfinance.
Question 4 - Extracting GameStop Revenue Data Using Webscraping.
Question 5 - Tesla Stock and Revenue Dashboard.
Question 6 - GameStop Stock and Revenue Dashboard.