Data Analyst Power Bi

MySQL (Joins, Window Functions, Views,

Subqueries, Stored Procedures)

Python (Pandas, NumPy, Matplotlib, Seaborn)

Power BI, Tableau, Matplotlib, Seaborn

Google Sheets, MS Excel (Pivot Tables, VLOOKUP,

Macros, Advanced Formulas)

Data Cleaning, Data Transformation, EDA,

Dashboarding

SAURABH CHOUDHARI

Data Analyst

+91-777******* *******************@*****.*** www.linkedin.com/in/saurabh-choudhari Pune, Maharashtra PROFESSIONAL SUMMARY

Data Analyst with hands-on experience in analyzing and managing ticketing and route data, skilled in transforming large datasets into actionable insights using Excel to support operational decisions at Sangitam Travels. Completed a comprehensive Data Analytics certification with expertise in MySQL, Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, and Excel. Proficient in data cleaning, transformation, visualization, and reporting, with a strong focus on driving performance improvements through data- driven insights.

PROFESSIONAL EXPERIENCE

Data Analyst

Sangitam Travels Pvt. Ltd. 04/2025 - Present Pune, Maharashtra Handled and analyzed 40,000+ monthly ticket bookings across 40+ travel routes to identify passenger trends and improve route planning. Created dashboards and reports using Google Sheets,Excel and Power BI to assist in daily operations and executive decision-making. Cleaned and managed data from the Bitla ticketing and scheduling system, ensuring consistency and accuracy for analysis.

Conducted competitor analysis using Red Bus to monitor pricing and route strategies and support data-driven planning.

Collaborated with cross-functional teams to streamline reporting workflows and reduce manual data handling.

Data Analyst Intern

IT Education Centre 01/2024 - 07/2024 Pune, Maharashtra Wrote and optimized SQL queries to extract, filter, and analyze data from relational databases for insights and reporting.

Used Excel tools such as pivot tables, VLOOKUP, and conditional formatting to analyze datasets and summarize key findings.

Applied Python (Pandas, NumPy, Matplotlib, Seaborn) for data cleaning, transformation, and basic visualization to support data analysis tasks. Designed interactive dashboards and visual reports using Power BI and Tableau to present key metrics and trends for decision-making. Contributed to capstone projects by solving business cases through end-to-end data analysis workflows.

Account Executive

Piyush Infratech Pvt. Ltd. 09/2021 - 09/2023 Aurangabad, Maharashtra Entered and managed accounting and transaction data with high accuracy, supporting smooth and error-free financial processes. Performed monthly bank reconciliations, ensuring data consistency and identifying discrepancies for resolution.

Prepared and analyzed monthly sales and purchase reports, offering data-driven insights to support business decisions and improve revenue tracking. Processed monthly payroll data, ensuring accurate and timely salary distribution, while maintaining data integrity and compliance.

PROJECTS

Credit Card Customer Analysis

Tools: Python (Pandas, NumPy, Matplotlib, Seaborn) Analyzed customer behavior using Python libraries: Pandas, NumPy, Matplotlib, and Seaborn.

Identified key factors influencing credit card usage to improve customer retention and increase revenue.

HR Analysis Dashboard

Tools: Power BI

Built an interactive Power BI dashboard to track employee retention and attrition metrics.

Revealed insights into key drivers of attrition and suggested targeted improvement strategies.

Road Accident Dashboard

Tools: Tableau

Designed a Tableau dashboard to visualize road accident data across regions and time periods.

Provided actionable insights to enhance road safety and support data-driven resource planning.

SKILLS

Database & SQL:

Programming:

Data Visualization:

Excel & Spreadsheet:

Data Analysis Techniques:

EDUCATION

Master Of Commerce

Dr. Babasaheb Ambedkar Marathwada University

Aurangabad, Maharashtra

Bachelor Of Commerce

Dr. Babasaheb Ambedkar Marathwada University

Aurangabad, Maharashtra

COURSES AND CERTIFICATIONS

Data Analyst Certification-IT Education Centre

Completed hands-on training in SQL, Excel, and Power BI for real-time data analytics

Data Analyst Online Internship -PSYLIQ

Gained practical experience in data cleaning, analysis, and visualization using live datasets.

Power BI Certification-Simplilearn

Learned to create interactive dashboards, apply DAX functions, and perform data modeling in Power BI

Advanced Excel -Simplilearn

Covered pivot tables, VLOOKUP, charts, macros, and data analysis techniques.

SOFT SKILLS

Hardworking and growth-oriented, with a

positive attitude toward challenges.

Strong team collaborator with excellent

active listening skills.

Flexible and adaptive in fast-changing

environments.

Enjoy solving problems using data and

creative thinking.

LANGUAGES

English Proficient

Hindi Native

Marathi Native

E q

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

•

1

1

1

1

Contact this candidate