Dhruv Sai

Aspiring Data Analyst

Bangalore, India 0+ yrs exp 85 · Excellent

About

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.

Skills & Expertise (31)

Microsoft Excel Advanced

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Exploratory data analysis Intermediate

6.5/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

XLOOKUP Intermediate

6.5/10

Years Exp

SQL Intermediate

6.5/10

Years Exp

Pivot Tables Intermediate

6.5/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Jupyter Notebook Intermediate

6.0/10

Years Exp

NumPy Intermediate

6.0/10

Years Exp

Power BI Intermediate

5.5/10

Years Exp

Power Query Intermediate

5.5/10

Years Exp

Tableau Intermediate

5.5/10

Years Exp

Joins Intermediate

5.5/10

Years Exp

Seaborn Intermediate

5.5/10

Years Exp

Matplotlib Intermediate

5.5/10

Years Exp

Statistical Analysis Intermediate

5.5/10

Years Exp

Data Storytelling Intermediate

5.0/10

Years Exp

Subqueries Intermediate

5.0/10

Years Exp

Dashboard Design Intermediate

5.0/10

Years Exp

Decision Support Intermediate

5.0/10

Years Exp

Reporting Intermediate

5.0/10

Years Exp

Customer Segmentation Intermediate

5.0/10

Years Exp

Business Analytics Intermediate

5.0/10

Years Exp

Trend Analysis Intermediate

5.0/10

Years Exp

Data Validation Intermediate

5.0/10

Years Exp

Model Evaluation Intermediate

5.0/10

Years Exp

Linear Regression Intermediate

5.0/10

Years Exp

CTEs Intermediate

5.0/10

Years Exp

Window Functions Intermediate

5.0/10

Years Exp

HTML Beginner

4.5/10

Years Exp

Work Experience

Data & Operations Intern

Kennametal India Ltd

Jul 2025 - Sep 2025

Engineered an Excel lookup tool (XLOOKUP, INDEX-MATCH) to aggregate 3 manufacturing datasets across 1,000+ parts, replacing manual cross-referencing with one unified view of inventory requirements. Analysed inventory data to flag under-stocked categories, highlighting critical gaps to guide production scheduling for the planning team. Audited physical stock against digital records, resolving discrepancies and restructuring warehouse stock to enhance traceability and retrieval speed.