Name: Prafull Wahatule

Job Role: Data Analyst

Experience: 6 Months

Experience: 6+ Months (Data Analyst Intern)

Address: Pune, Maharashtra

Skills

SQL & Databases: Joins, Subqueries, CTEs, Window Functions, Performance Tuning 95%
Power BI & DAX: Data Modeling, Advanced DAX, KPI Dashboards, Power Query 92%
Python: Pandas, NumPy, Matplotlib, Seaborn, Data Analysis & Automation 90%
Data Visualization: Dashboard Design, Storytelling, Interactive Reports 95%
Excel: Pivot Tables, Power Query, Advanced Formulas, Charts 88%
Data Analytics Skills: ETL, Data Cleaning, EDA, Validation, Reporting 90%
Tools & Platforms: GitHub, MySQL, VS Code, Jupyter Notebook 85%

About

About Me

Detail-oriented Data Analyst with hands-on experience in Excel, SQL, Python and Power BI, specializing in data cleaning, transformation, analysis and dashboard development. Experienced in building end-to-end analytics solutions, performing ETL processes, reconciling multi-source data, automating recurring reports and delivering actionable business insights. Strong focus on data accuracy, validation, consistency and process efficiency to support data-driven decision making.

Projects Impact: 4.4L+ records analyzed • 5+ dashboards • 15+ KPIs built

  • Profile: Data Analyst
  • Experience: Data Analyst Intern – Tega IT Software Solution
  • Education: Master of Computer Application (MCA)
  • Languages: English, Hindi, Marathi
  • Programming: SQL, Python, DAX
  • Libraries: Pandas, NumPy, Seaborn, Matplotlib
  • BI Tools: Power BI, Microsoft Excel, Tableau
  • Core Skills: ETL, ELT, Data Cleaning, Validation, EDA, Dashboarding
  • Tools: MySQL, MongoDB, GitHub, VS Code, Jupyter Notebook

Resume

Resume

Detail-oriented junior Data Analyst with 6+ months of internship experience delivering data-driven insights, interactive dashboards, and analytical solutions. Proven expertise in SQL, Python, Power BI, Excel, and exploratory data analysis with a strong focus on business impact, data accuracy, and automation.

Experience


Jan 2025 – Jun 2025

Data Analyst Intern

Tega IT Software Solution, Nashik

Nashik-based IT firm providing software development and data analytics solutions.

  • Executed complete ETL workflows including data extraction, cleaning, transformation, and validation using Python, Pandas and NumPy.
  • Designed and developed interactive Power BI and Excel dashboards to track KPIs, trends, and business performance.
  • Performed data quality checks, reconciliation and validation across multiple data sources.
  • Collaborated with senior analysts on report reviews, stakeholder discussions, and insight generation for business decision-making.
  • Automated recurring reports, improving reporting efficiency and accuracy.



Education


2023 – 2025

Master of Computer Application (MCA)

Savitribai Phule Pune University
2019 – 2022

Bachelor of Science (BSc)

Dr. Babasaheb Ambedkar Marathwada University
2018 – 2019

Higher Secondary Certificate (HSC)

MSBSHSE
2016 – 2017

Secondary School Certificate (SSC)

MSBSHSE

Projects

Projects

End-to-end Data Analytics & Business Intelligence projects built using SQL, Python, Power BI and Excel, focusing on real-world business problems, data-driven insights, and executive-level dashboards.

Amazon Sales Performance Dashboard (Power BI)

Built an interactive Power BI dashboard using DAX and Power Query to analyze sales trends, customer behavior, revenue growth, and product performance.

Seoul Bike Rental Demand Analysis

Developed a data-driven Power BI dashboard to uncover seasonal demand patterns, peak hours, and weather impact to support urban mobility planning.

Fecom Inc Sales & Customer Analytics Dashboard

Designed a 7-page executive Power BI dashboard analyzing sales performance, customer reviews, geographic insights, vendor metrics, and profitability trends.


Hotel Booking Analytics Dashboard

Built a multi-page Power BI dashboard covering booking trends, cancellation patterns, customer segmentation, room utilization, and distribution channels.

Employee Performance & HR Analytics (Excel)

Created an interactive Excel HR dashboard using Pivot Tables, Charts, Lookups and Slicers to analyze attrition, salary distribution, and performance metrics.

Hotel Management System – SQL Analytics

Designed a complete relational database schema in MySQL with optimized SQL queries to analyze bookings, revenue, occupancy, and operational performance.

0 Projects Completed
0 Work Hours
0 Dashboards Created

Explore More Projects on GitHub

I enjoy solving business problems and uncovering hidden stories in data through analytics, dashboards, and automation.

Visit My GitHub

Contact

Get In Touch

Feel free to reach out for collaborations, project opportunities, or general inquiries!

Location

Pune, Maharashtra, India

Resume

Download CV

Connect with me on professional networks: