Pavan Patil

Data Analyst

Pune, Maharashtra 0+ yrs exp 81 · Excellent

About

B.Tech (CSE – AI) graduate and Data Analyst with hands-on internship experience in KPI reporting, data validation, and dashboarding. Skilled in Power BI, SQL, Python, and Excel, with a track record of turning raw, messy datasets into clean, decision-ready analysis and dashboards. Comfortable owning end-to-end analysis: data cleaning, EDA, SQL querying, and stakeholder-ready reporting.

Skills & Expertise (36)

Power Query Intermediate

6.5/10

0.5

Years Exp

Data Cleaning Intermediate

6.5/10

0.5

Years Exp

EDA Intermediate

6.5/10

0.5

Years Exp

Preprocessing Intermediate

6.5/10

0.5

Years Exp

Pandas Intermediate

6.5/10

0.5

Years Exp

Python Intermediate

6.5/10

0.5

Years Exp

SQL Intermediate

6.5/10

0.5

Years Exp

Data Visualization Intermediate

6.5/10

0.5

Years Exp

KPI Reporting Intermediate

6.5/10

0.5

Years Exp

Dashboard Development Intermediate

6.5/10

0.5

Years Exp

Power BI Intermediate

6.5/10

0.5

Years Exp

Data Modeling Intermediate

6.5/10

0.5

Years Exp

MySql Intermediate

6.0/10

0.5

Years Exp

Google Colab Intermediate

6.0/10

0.5

Years Exp

VS Code Intermediate

6.0/10

0.5

Years Exp

Jupyter Notebook Intermediate

6.0/10

0.5

Years Exp

Transformation Intermediate

6.0/10

0.5

Years Exp

Advanced Excel Intermediate

6.0/10

0.5

Years Exp

NumPy Intermediate

6.0/10

0.5

Years Exp

validation Intermediate

6.0/10

0.5

Years Exp

Anaconda Intermediate

5.5/10

0.5

Years Exp

Statistical Analysis Intermediate

5.5/10

0.5

Years Exp

Regression Intermediate

5.5/10

0.5

Years Exp

Hypothesis Testing Intermediate

5.5/10

0.5

Years Exp

Git Intermediate

5.5/10

0.5

Years Exp

GitHub Intermediate

5.5/10

0.5

Years Exp

Outlier Detection Intermediate

5.5/10

0.5

Years Exp

Seaborn Intermediate

5.5/10

0.5

Years Exp

Matplotlib Intermediate

5.5/10

0.5

Years Exp

DAX Intermediate

5.5/10

0.5

Years Exp

Data Manipulation Window Functions CTEs Subqueries Aggregations Joins

Work Experience

Data Science Consultant Intern

Rubixe

Dec 2025 - May 2026

Cleaned, preprocessed, and validated real-world datasets using Python (Pandas), SQL, and Excel for accurate reporting outputs. Conducted EDA to identify trends, patterns, and customer behavior, translating business questions into structured analysis. Built Power BI dashboards and KPI reports using Power Query and data modeling to track revenue, transactions, and customer metrics. Supported end-to-end analysis projects — data prep, SQL analysis, Python EDA, dashboarding, and presenting findings to stakeholders.