00 — AVAILABLE FOR FULL-TIME

DIAGNOSING ROOT CAUSES THROUGH DATA.

Dhruv Sai Gedda — Data Analyst with a Mechanical Engineering foundation. I analyse operational data with Python, SQL and Power BI to answer practical questions: 'who is at risk of leaving', 'how pricing varies, where stock runs short', and 'what drives viewership'.

[ PROFILE / VITALS ]
ANALYTICS PROJECTS
7
RECORDS MODELLED
10K
BI DASHBOARDS SHIPPED
3
LOCATION
BANGALORE, INDIA
01 — THE JOURNEY

MECHANICAL
TO
ANALYTICS.

Data analyst with a mechanical engineering foundation. Hands-on experience in manufacturing operations at Kennametal India. Engineering training fostered a systems-level problem-solving approach — diagnosing root causes over reporting symptoms. Built analytics projects EDA, Power BI dashboards, and regression modeling.

I treat a dataset the way an engineer treats a failing system: isolate the variables, check what depends on what, and separate what the data shows from what it only suggests. Whether the question is "which tenured employees are at risk of leaving?" or "what drives first-day viewership?", the workflow stays the same: clean, explore, segment, model, explain.

CURRENTLY
PGP IN DATA SCIENCE & GENERATIVE AI
FOCUS
DATA ANALYTICS · GEN AI · BUSINESS INTELLIGENCE
STACK
PYTHON · SQL · POWER BI
WORKING AT
GRINDWELL NORTON LTD
BASED IN
BANGALORE, IN
OPEN TO
FULL-TIME ROLES
02 — EXPERIENCE

IN THE
FIELD.

02 ENGAGEMENTS
SEP 2026 – PRESENT
BANGALORE, INDIA
SOURCING & PACKAGING OPTIMIZATION INTERN / GRINDWELL NORTON LTD
  • 01 Vetting raw-material suppliers and building a structured comparison framework to support ongoing packaging optimization trials.
JUL – SEP 2025
BANGALORE, INDIA
DATA & OPERATIONS INTERN / KENNAMETAL INDIA LTD
  • 01 Engineered an Excel lookup tool (XLOOKUP, INDEX-MATCH) aggregating 3 manufacturing datasets across 1,000+ parts, replacing manual cross-referencing with a unified inventory view.
  • 02 Analysed inventory data to pinpoint under-stocked categories, surfacing critical gaps that guided production scheduling for the planning team.
  • 03 Audited physical stock against digital records, resolving discrepancies and restructuring warehouse stock to improve traceability and retrieval speed.
03 — SELECTED WORK

CASE
FILES.

05 PROJECTS
CASE / 01
↗
5x
FEMALE CUSTOMERS WERE 5x LIKELY TO PREFER SUVs THAN MALE CUSTOMERS
CUSTOMER SEGMENTATION & PURCHASE BEHAVIOR ANALYSIS
Studied vehicle preference (Sedan, SUV, Hatchback) across gender, profession, and income using univariate, bivariate and multivariate analysis.
PYTHON PANDAS SEABORN MATPLOTLIB
CASE / 02
↗
0.75
CORRELATION, TRAILER VIEWS VS FIRST-DAY VIEWS · 76.6% TEST R²
OTT VIEWERSHIP DRIVERS: LINEAR REGRESSION
Analysed 1,000 OTT titles to find what drives first-day views. Built an OLS model with 76.6% test R² and ~41K-view MAE. Major sports events were associated with ~60K fewer views and Saturday releases with ~58K more than Fridays, controlling for other factors.
PYTHON PANDAS STATSMODELS SEABORN
CASE / 03
↗
1,223
EMPLOYEES FLAGGED AS FLIGHT-RISK (49.8% OF ACTIVE WORKFORCE of 2,458)
EMPLOYEE PERFORMANCE & WORKFORCE ANALYSIS
Identified a 5+ year tenure cohort with 'Fully Meets/Exceeds' ratings but no promotions. Attrition occurred across all performance bands (PIP: 27%; Exceeds: 17%), revealing a systemic retention issue, not a performance management failure.
PYTHON PANDAS SEABORN POWER BI
CASE / 04
↗
0
OVERLAP BETWEEN TOP-10 DISCOUNTED AND TOP-10 RATED CATEGORIES
AMAZON SALES DATA ANALYSIS
Across 1,400+ items, found that deep discounts drive volume not satisfaction. Budget-tier items outperformed premium items, illustrating an expectation calibration effect. Implemented weighted ratings (rating × review volume) for ranking.
PYTHON PANDAS SQL MATPLOTLIB
CASE / 05
↗
25%
GAP BETWEEN WORK-LIFE BALANCE (5.74) AND PAY SATISFACTION (4.27)
DATA PROFESSIONAL SURVEY DASHBOARD
Analysed 630 survey responses across 7 roles in 5 countries. Segmented 42.7% of respondents as neutral on career entry difficulty — likely a cohort leveraging transferable domain skills.
POWER BI POWER QUERY
CASE / 06
↗
+45%
PREMIUM ZIPS OVER CITY AVERAGE · 40-45% SEASONAL VOLATILITY
AIRBNB PRICING ANALYSIS DASHBOARD
Discovered a U-curve in per-bedroom pricing across 2,580+ Seattle listings — mid-size properties yield 18% less per bedroom than the extremes. Compound effects of location and seasonality surfaced via moving averages.
TABLEAU MOVING AVERAGES
CASE / 07
↗
3
TABLE NORMALISED SCHEMA WITH REFERENTIAL INTEGRITY
WORKDOCK — RELATIONAL DATABASE DESIGN
Architected a normalised schema using parameterized queries. Separated recruiter and job-seeker data flows to streamline downstream querying and reporting.
PYTHON SQL SQLITE
[ MORE ON GITHUB ]
FULL
ARCHIVE
→ VISIT GITHUB ↗
04 — TOOLKIT

INSTRUMENTS.

PYTHON+ SQL+ POWER BI+ TABLEAU+ PANDAS+ EXCEL+ POWER QUERY+ MYSQL+ SQLITE+ PYTHON+ SQL+ POWER BI+ TABLEAU+ PANDAS+ EXCEL+ POWER QUERY+ MYSQL+ SQLITE+
LANGUAGES & TOOLS
Python
Pandas
NumPy
Matplotlib
Seaborn
SQL
Jupyter Notebook
HTML
VISUALISATION & BI
Power BI
Power Query
Tableau
Excel
ANALYTICS
EDA
Statistical Analysis
Linear Regression
Model Evaluation
Root Cause Analysis
Trend Analysis
Time Series
ETL
Data Wrangling
Data Storytelling
DOMAIN
KPI Reporting
Dashboard Dev
Business Intelligence
Pricing Analysis
Inventory Analysis
Process Improvement
Customer Segmentation
05 — EDUCATION

FOUNDATIONS.

2026 – Present
PGP IN DATA SCIENCE & GENERATIVE AI
Great Learning / Deakin University
FOCUS AREAS Python · Inferential Statistics · Machine Learning · Generative AI · SQL · Data Visualization · Analytics
2022 – 2026
B.E. IN MECHANICAL ENGINEERING
M S Ramaiah Institute of Technology
GPA
7.64 / 10
RELEVANT COURSEWORK Python Programming · DBMS · Data Analytics & Modelling
06 — CERTIFICATIONS

RECEIPTS.

INTRODUCTION TO POWER BI ANALYST
GREAT LEARNING (MICROSOFT)
APR 2026
DATA VISUALIZATION WITH POWER BI
GREAT LEARNING (MICROSOFT)
MAR 2026
DATA ANALYTICS JOB SIMULATION
TATA GROUP · FORAGE
DEC 2025
DATA ANALYTICS JOB SIMULATION
DELOITTE AUSTRALIA · FORAGE
OCT 2025
07 — CONTACT

LET'S
BUILD
SOMETHING
ACCURATE.

✉ dhruv.sai17404@outlook.com
✆ +91 8431067625
◎ Bangalore, India