Back to Developers
RM

Rohit Mahalle

Data Analyst

Pune, India
66
Profile Score

About

Analytical and detail-oriented Data Analyst with hands-on experience in data cleaning, exploratory data analysis, statistical analysis, and dashboard development. Proficient in Excel, SQL, Python, Power BI, and Tableau for transforming complex datasets into actionable business insights. Strong ability to support data-driven decision-making, pricing analysis, operational optimization, and performance reporting.

Skills & Expertise (11)

Data Analysis & Interpretation Advanced
8.1/10
1
Years Exp
Data Cleaning & Preprocessing Advanced
8.0/10
1
Years Exp
Exploratory Data Analysis (EDA) Advanced
7.9/10
1
Years Exp
Statistical Analysis & Regression Advanced
7.8/10
1
Years Exp
Business Intelligence & Reporting Advanced
7.7/10
1
Years Exp
Data Visualization & Dashboards Advanced
7.6/10
1
Years Exp
Excel (Advanced formulas, Pivot Tables) Advanced
7.5/10
1
Years Exp
SQL (Joins, Subqueries) Advanced
7.4/10
1
Years Exp
Python Advanced
7.3/10
1
Years Exp
Power BI Advanced
7.2/10
1
Years Exp
Tableau Advanced
7.1/10
1
Years Exp

Work Experience

Data Analyst

Impact of Car Features on Pricing

Jan 2025 - Apr 2025

Analyzed 11,159 car models to evaluate the impact of features on MSRP and market positioning. Performed data cleaning, preprocessing, and validation to improve data accuracy and reliability. Conducted regression analysis to identify key variables influencing vehicle prices. Built interactive Excel dashboards using pivot tables and slicers to visualize pricing trends. Generated insights on fuel efficiency, horsepower, transmission type, and market category.

Data Analyst

ABC Call Volume Trends Analysis

Jan 2025 - Apr 2025

Analyzed inbound call volume data to optimize manpower allocation and improve customer experience. Cleaned and processed raw datasets to ensure accurate trend and peak-hour analysis. Designed Excel dashboards for call volume monitoring and workforce planning. Proposed staffing optimization solutions based on call patterns and agent availability.

Data Analyst

Bank Loan Case Study

Apr 2025 - Apr 2025

Cleaned loan datasets, handled missing values, and detected outliers using statistical methods. Performed univariate and bivariate analysis to assess loan approval patterns. Identified key risk factors influencing loan defaults and approvals. Created visualizations using histograms, box plots, and scatter plots.

Education

Bachelor of Computer Applications (Mobile Application & Web Development) - Dr. V. Patil International University

- 2022 · Afghanistan

Interested in this developer?

Profile Score Breakdown

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

Profile Overview

Member sinceFeb 2026

Skills (11)

Data Analysis & Interpretation Data Cleaning & Preprocessing Exploratory Data Analysis (EDA) Statistical Analysis & Regression Business Intelligence & Reporting Data Visualization & Dashboards Excel (Advanced formulas, Pivot Tables) SQL (Joins, Subqueries) Python Power BI +1 more