Rohit Hajare

Data Analyst

Pune 0+ yrs exp 81 · Excellent

About

Data Analyst with hands-on experience across SQL, Python, Excel, Power BI, and Tableau, gained through an analytics internship and independent projects involving 12M+ record datasets. Skilled in data cleaning, exploratory data analysis, dashboard development, and statistical analysis to convert raw data into business insights. Experienced in building KPI-driven Power BI dashboards and writing optimized SQL queries with joins and CTEs to support data-driven decision-making. Strong communicator with a track record of translating technical findings into actionable business recommendations. Ready to contribute analytical rigor and business impact from day one.

Skills & Expertise (25)

Dashboard Development Intermediate

5.5/10

0.25

Years Exp

Data Validation Intermediate

5.5/10

0.25

Years Exp

Data Cleaning Intermediate

5.5/10

0.25

Years Exp

Advanced MS Excel Intermediate

5.5/10

0.25

Years Exp

Power BI Intermediate

5.5/10

0.25

Years Exp

MySql Intermediate

5.5/10

0.25

Years Exp

SQL Intermediate

5.5/10

0.25

Years Exp

Joins Intermediate

5.0/10

0.25

Years Exp

GROUP BY Intermediate

5.0/10

0.25

Years Exp

KPI Reporting Intermediate

5.0/10

0.25

Years Exp

DAX Intermediate

5.0/10

0.25

Years Exp

Exploratory data analysis Intermediate

5.0/10

0.25

Years Exp

Business Intelligence Intermediate

5.0/10

0.25

Years Exp

Power Query Intermediate

5.0/10

0.25

Years Exp

Trend Analysis Intermediate

5.0/10

0.25

Years Exp

Stakeholder Reporting Intermediate

5.0/10

0.25

Years Exp

Pandas Beginner

4.5/10

0.25

Years Exp

NumPy Beginner

4.5/10

0.25

Years Exp

Python Beginner

4.5/10

0.25

Years Exp

Tableau Beginner

4.0/10

0.25

Years Exp

Feature Engineering Beginner

4.0/10

0.25

Years Exp

Statistical Analysis Beginner

4.0/10

0.25

Years Exp

CTEs Beginner

4.0/10

0.25

Years Exp

Seaborn Beginner

4.0/10

0.25

Years Exp

Matplotlib Beginner

4.0/10

0.25

Years Exp

Work Experience

Data Analyst Intern

AI Variant

Dec 2025 - Mar 2026

Analyzed 134K+ hotel booking records across 25 properties in 4 cities using SQL, Excel, and Power BI, delivering insights into revenue trends, occupancy performance, and booking behavior. Built relational data models and optimized SQL queries using joins, GROUP BY, and foreign key relationships to integrate booking, room, and revenue data for accurate business reporting. Developed interactive Power BI dashboards with DAX measures, KPI cards, slicers, and drill-through analysis, monitoring 170.9 Cr revenue, 57.87% occupancy, and 24.8% cancellation rate over a 3-month period. Performed data cleaning, validation, and transformation using SQL and Excel, improving data quality across 134K+ transactional records and enabling reliable analytical reporting.

Education

Bachelor of Engineering (B.E.) - TSSM’S Bhivarabai Sawant College of Engineering and Research, Pune – Savitribai Phule Pune University (SPPU)

2022 - 2026 · Afghanistan

Certifications

No certifications added yet

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 6/15

💰 Rate 0/5

🏆 Certs 0/5

✅ Verified 5/5

Total Score 81/100

Profile Overview

Member sinceAug 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (25)

Click a skill to find developers with the same skill

Dashboard Development Data Validation Data Cleaning Advanced MS Excel Power BI MySql SQL Joins GROUP BY KPI Reporting +15 more

Similar Profiles

Abhineet Verma

Data

Rahul Agarwal

Data Analyst

Saijyothi A

Data Analyst

Amruta Shelke

Data Analyst

View All Developers →