Back to Developers
12A-28- Yash Tanwar

12A-28- Yash Tanwar

Data Analyst

Gurugram, India 1+ yrs exp 87 · Excellent

About

Data Analyst with hands on experience in SQL, Python, Power BI, and Excel, specializing in MIS reporting, dashboard development, and operational analytics. Currently analyzing production, scrap, power consumption, and dispatch data in a manufacturing environment, with a strong foundation in statistical analysis, Data Visualization, and Machine Learning.

Skills & Expertise (24)

SQL Intermediate
7.0/10
1
Years Exp
Power BI Intermediate
7.0/10
1
Years Exp
Excel Intermediate
6.5/10
1
Years Exp
Python Intermediate
6.5/10
1
Years Exp
Pivot Charts Intermediate
6.0/10
1
Years Exp
Pivot Tables Intermediate
6.0/10
1
Years Exp
XLOOKUP Intermediate
6.0/10
1
Years Exp
VLOOKUP Intermediate
6.0/10
1
Years Exp
Pandas Intermediate
6.0/10
1
Years Exp
NumPy Intermediate
5.5/10
1
Years Exp
Seaborn Intermediate
5.0/10
1
Years Exp
KPI Reporting Beginner
5.0/10
1
Years Exp
Power Query Beginner
5.0/10
1
Years Exp
DAX Beginner
5.0/10
1
Years Exp
Azure Beginner
5.0/10
1
Years Exp
AWS Beginner
5.0/10
1
Years Exp
Matplotlib Intermediate
5.0/10
1
Years Exp
Chi-square Beginner
4.5/10
1
Years Exp
ANOVA Beginner
4.5/10
1
Years Exp
A/B testing Beginner
4.5/10
1
Years Exp
Hypothesis Testing Beginner
4.5/10
1
Years Exp
K-Means Clustering Beginner
4.5/10
1
Years Exp
Classification Beginner
4.5/10
1
Years Exp
Feature Engineering Beginner
4.5/10
1
Years Exp

Work Experience

Data Analyst

SHH Haryana Wires Private Limited

Dec 2025 - Present

Built and maintained MIS reports for daily Plan VS Actual production and scrap across 24 machines and 5 production zones for Aluminium and Copper wire. Tracked production against daily targets, supporting a 500-ton a month dispatch goal while keeping scrap within the 3% annual target. Developed weekly Power BI reports (Bar charts, Histograms, Line charts) to identify machines, processes driving the most scrap, and shared daily variance reports with the Production Manager and CEO.

Data Analyst Intern

Lagozon Technologies

Jun 2025 - Nov 2025

Built SQL based data pipelines across 5+ sources, reducing manual data preparation by 40%. Wrote 15+ SQL queries using joins, window functions, and aggregations, improving reporting accuracy by 25%. Built 12+ Power BI dashboards covering sales and regional performance for 3 business teams.

Education

B.Tech, CSE (Data Science) - The NorthCap University

2022 - 2026 · Afghanistan

CBSE Class XII - Army Public School

2021 - 2022 · Afghanistan

Certifications

AWS Academy Graduate, Data Engineering

· 2025

Microsoft Azure AI Fundamentals (AI-900)

· 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 7/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 87/100

Profile Overview

Member sinceSep 2026

Skills (24)

Click a skill to find developers with the same skill