Yash Bhosale

Data Analyst

Pune, Maharashtra, India 0+ yrs exp 81 · Excellent

About

Detail-oriented Data Analyst with hands-on experience in SQL, Advanced Excel, Power BI (DAX, Power Query) and Python (Pandas, NumPy). Skilled in collecting, consolidating, cleaning and validating data from multiple sources, building interactive dashboards and recurring reports, defining and tracking KPIs, identifying trends and patterns, and turning business data into actionable, data-driven recommendations. B.Tech in Artificial Intelligence & Data Science.

Skills & Expertise (37)

Report Automation Intermediate

8.0/10

0.25

Years Exp

Advanced Excel Intermediate

8.0/10

0.25

Years Exp

Excel Charts Intermediate

8.0/10

0.25

Years Exp

Business Intelligence Intermediate

8.0/10

0.25

Years Exp

KPI Reporting Intermediate

8.0/10

0.25

Years Exp

Pivot Tables Intermediate

8.0/10

0.25

Years Exp

VLOOKUP Intermediate

8.0/10

0.25

Years Exp

Interactive Dashboards Intermediate

8.0/10

0.25

Years Exp

Power BI Intermediate

8.0/10

0.25

Years Exp

Exploratory data analysis Intermediate

8.0/10

0.25

Years Exp

Data Preprocessing Intermediate

8.0/10

0.25

Years Exp

Data Cleaning Intermediate

8.0/10

0.25

Years Exp

LOOKUP functions Intermediate

8.0/10

0.25

Years Exp

Trend Analysis Intermediate

8.0/10

0.25

Years Exp

Pandas Intermediate

8.0/10

0.25

Years Exp

Python Intermediate

8.0/10

0.25

Years Exp

Pattern Analysis Intermediate

8.0/10

0.25

Years Exp

Data Validation Intermediate

8.0/10

0.25

Years Exp

Data Extraction Intermediate

8.0/10

0.25

Years Exp

KPI Tracking Intermediate

8.0/10

0.25

Years Exp

Data Quality Checks Intermediate

8.0/10

0.25

Years Exp

Data-Driven Recommendations Intermediate

8.0/10

0.25

Years Exp

SQL Intermediate

8.0/10

0.25

Years Exp

Data Storytelling Intermediate

7.5/10

0.25

Years Exp

Statistical Analysis Intermediate

7.5/10

0.25

Years Exp

NumPy Intermediate

7.5/10

0.25

Years Exp

Aggregations Intermediate

7.5/10

0.25

Years Exp

Joins Intermediate

7.5/10

0.25

Years Exp

Power Query Intermediate

7.0/10

0.25

Years Exp

DAX Intermediate

7.0/10

0.25

Years Exp

Matplotlib Intermediate

7.0/10

0.25

Years Exp

Postgresql Intermediate

7.0/10

0.25

Years Exp

Data Integration Intermediate

7.0/10

0.25

Years Exp

Business Analysis Intermediate

7.0/10

0.25

Years Exp

Sub-queries Intermediate

7.0/10

0.25

Years Exp

Seaborn Intermediate

6.5/10

0.25

Years Exp

CTEs Intermediate

6.5/10

0.25

Years Exp

Work Experience

Data Analyst Intern

Incorporate Code x Cypher

Mar 2026 - Jun 2026

Collected, consolidated, cleaned and analyzed 50,000+ records from multiple sources using SQL, Excel and Pandas, resolving data inconsistencies and performing data validation and quality checks to build accurate datasets for 5–6 KPIs. Automated and standardized 10 recurring reports using Excel formulas, Pivot Tables, lookup functions and charts, reducing manual reporting effort by ~25% and streamlining repetitive reporting and data preparation. Developed 5+ interactive Power BI dashboards and wrote 30+ SQL queries (filtering, joins, aggregations) to identify business trends, performance patterns and anomalies, and delivered actionable, data-driven insights.