Punam Dhavale

Aspiring Data Analyst with hands-on experience in SQL, Python, Advanced Excel, Power BI, Tableau, and DAX. Proficient in Data Cleaning, ETL, Data Modeling, SQL Queries, Exploratory Data Analysis (EDA), Dashboard Development, KPI Reporting, Business Intelligence, Statistical Analysis, and Data Visualization. Built end-to-end analytics solutions across Sales, HR, and E-Commerce datasets using SQL, Python, and Power BI to deliver actionable business insights.

Strong analytical, problem-solving, and communication skills with a a proven academic record as a First Rank Holder (CGPA: 9.7/10).

Data Analyst Intern - Dataview Analytics - Pune, Maharashtra, India (Remote)

(2025-04 - 2025-06)

• Extracted, cleaned, and processed 100,000+ records from multiple data sources using SQL and Excel to support weekly business reporting and KPI tracking.
• Engineered robust automated reporting workflows using Power Query, Pivot Tables, VLOOKUP, and INDEX-MATCH, reducing report preparation time by 40%.
• Architected interactive Power BI dashboards with DAX measures to translate complex revenue trends and customer segmentation into executive insights.
• Performed data cleaning, validation, and exploratory data analysis (EDA) to ensure high data integrity and support data-driven decision-making.

Data & Backend Engineering Intern - TechConnect Technologies - Pune, Maharashtra, India (Remote)

(2025-01 - 2025-02)

• Developed and integrated 12+ REST APIs using Node.js and MongoDB while optimizing database queries to improve application performance by 60%.
• Collaborated within a cross-functional team using Git, GitHub, and Agile methodologies to deliver production-ready backend features.

B.E. - Artificial Intelligence and Data Science - Parvatibai Genba Moze College of Engineering, Pune, Maharashtra, India (2022 - 2026)