Pratik Prakash Pawar

About

B.Tech Graduate with strong expertise in Advanced Excel, SQL, and Power BI. Skilled in preparing daily, weekly, and monthly MIS reports, data cleaning validation, interactive dashboards, and managing large datasets with high accuracy. Excellent attention to detail, analytical problem-solving skills, and team coordination ability — eager to support operational reporting and accurate record maintenance.

Skills

Experience

• Data Analyst

  MND Infotech

  Jul 2025 – Jan 2026

Education

• ANNASAHEB DANGE COLLEGE OF ENGINEERING AND TECHNOLOGY, ASHTA

  Under Graduation, B. Tech / BE

  2021 – 2026

Projects

• Fashion Store Sales Analysis (MS Excel)

  MS Excel

• Fashion Store Sales Analysis (MS Excel)

  Collected, cleaned, and consolidated multi-source sales data using advanced Excel functions and techniques Created dynamic Pivot Tables, charts, slicers, and calculated fields to analyze trends, top products, and KPIs De

  MS Excel

• Shopify Product Sales Analysis

  Wrote SQL queries (SELECT, JOIN) to extract and prepare Shopify sales data; imported into Power Query for cleaning and validation Use Power BI to develop dashboards and analyze revenue trends, and key metrics with strong

  MS Excel · MySQL

Certifications

• Data Science with Python — Data Camp (Jul 2023)