Back to Developers
Ajay Chavan

Ajay Chavan

Data Analyst

Pune, India $25/hr
85
Profile Score

About

Data Analyst with 3.6+ years of experience in SQL, Python, Power BI, Tableau, and Advanced Excel across Telecom, IT Services, and Insurance domains. Strong expertise in ETL development, Data Modeling (Star Schema), Dashboard Development, KPI Tracking, and Business Analytics. Proven ability to convert complex datasets into actionable insights, improve reporting efficiency by 60%, and drive data-driven strategic decisions.

Skills & Expertise (45)

SQL Advanced
8.3/10
3.6
Years Exp
Python Advanced
8.1/10
3.6
Years Exp
Tableau Advanced
7.9/10
3.6
Years Exp
Pandas Advanced
7.8/10
3.6
Years Exp
Power BI Advanced
7.5/10
3.6
Years Exp
Performance Optimization Data Analysis & Visualisation LOD Expressions Dashboard Development KPI Design Executive Reporting Data Storytelling Dimensional Modeling Trend Analysis Data Interpretation Business Metrics Analysis Advanced Excel Pivot Tables Power Pivot XLOOKUP Dynamic Arrays VBA Macros MIS Automation Joins NumPy Matplotlib Seaborn scikit-learn Exploratory data analysis Statistical Analysis Data Visualization Hypothesis Testing Window Functions CTEs Data Modeling Subqueries Query Optimization Indexing Aggregations Stored Procedures MySql SQL Server DAX Power Query

Work Experience

Data Analyst

Codereach Software Private Limited

Jun 2022 - Jul 2025

Developed a real-time Pricing & Risk Intelligence System integrating competitive financial data and transactional datasets. Applied predictive analytics models and built dynamic Tableau executive dashboards to optimize pricing strategies and profitability. Strengthened revenue growth and reduced marketing spend through data-driven pricing and performance optimization frameworks.

Data Analyst

BAJAJ ALLIANCE

Aug 2025 - Dec 2025

Architected a centralized Banking Sales & Customer Intelligence Platform integrating multi-source transactional and customer datasets. Engineered optimized Star Schema data models, automated scalable ETL pipelines, and delivered real-time executive dashboards. Empowered leadership with data-driven KPI tracking, revenue analytics, and performance intelligence to enhance strategic decision-making and customer profitability.

Education

B.Sc (Bachelor of Science) - K.T.H.M. College

- 2022 · Afghanistan

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 5/15
💰 Rate 5/5
🏆 Certs 0/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMar 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (45)

SQL Python Tableau Pandas Power BI Performance Optimization Data Analysis & Visualisation LOD Expressions Dashboard Development KPI Design +35 more