Back to Developers
Pratham patil

Pratham patil

Data Analyst

Pune, Maharashtra 1+ yrs exp 84 · Excellent

About

Data Analyst with hands-on experience in the travel and transport industry, specializing in competitor pricing research, market price analysis, seat occupancy monitoring, route profitability tracking, and daily operational reporting. Skilled in SQL, Python, Power BI, and Advanced Excel to support real-time pricing decisions and business performance monitoring. Seeking roles as Data Analyst, Pricing Analyst, Market Research Analyst, MIS Analyst, or Reporting Analyst — preferably in Pune, Remote, or travel / mobility / logistics domains.

Skills & Expertise (25)

Python Intermediate
7.6/10
1
Years Exp
SQL Intermediate
7.3/10
1
Years Exp
Power BI Intermediate
7.2/10
1
Years Exp
Tableau Intermediate
7.2/10
1
Years Exp
Advanced Excel Intermediate
7.0/10
1
Years Exp
MS Office Suite Anaconda Jupyter Notebook MIS Reporting Demand Forecasting Time-Series Forecasting SARIMA ARIMA Recommendation Systems Regression Excel Dashboards Seaborn Matplotlib NumPy Pandas Data Cleaning XLOOKUP VLOOKUP Pivot Tables MySql

Work Experience

Data Analyst

Sangitam Travels

Apr 2025 - Present

Conduct daily competitor pricing research across all active travel routes — benchmarking market rates and adjusting ticket prices to stay competitive while protecting margins. Monitor seat occupancy levels in real time and set dynamic market-aligned ticket prices based on current booking pace, remaining capacity, and demand signals. Track route-wise profitability on a daily basis — identifying which routes are generating returns and flagging underperforming routes for pricing correction. Collect and consolidate daily operational data (bookings, revenue, occupancy, pricing) into structured reports for management decision-making. Analyze booking datasets to identify demand patterns and seasonal trends, supporting forward pricing and capacity planning strategies. Generate daily and weekly MIS reports using Excel and SQL, providing management with a clear view of business performance across all routes.

Data Analyst / Data Science Intern

AI Variant

Dec 2023 - Aug 2024

Analyzed HR datasets (5,000+ employee records) to surface attrition patterns, department-level KPIs, and workforce trends presented to stakeholders. Developed interactive Power BI and Tableau dashboards for HR and Banking analytics projects, enabling faster decision-making for business teams. Performed exploratory data analysis on banking loan datasets to evaluate NPA risk, loan performance, and repayment KPIs using Python and Excel. Built a Book Recommendation System using collaborative filtering (Python, Pandas, NumPy) — deployed as a working ML demo. Developed a Gold Price Prediction model using ARIMA and SARIMA, achieving improved forecast accuracy over a baseline moving-average model.

Education

Master of Computer Applications (MCA) - Suryadatta Institute

2022 - 2024 · Afghanistan

Bachelor of Computer Applications (BCA) - Dr. D. Y. Patil ACS College

2019 - 2022 · 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 9/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 84/100

Profile Overview

Member sinceMay 2026