Payal Gapat

Data and Business Analyst

Pune, India 0+ yrs exp 81 · Excellent

About

Detail-oriented and analytical Data Analyst with 6 months of internship experience. Proficient in collecting, cleaning, analyzing, and visualizing large datasets. Skilled in SQL, Power BI, Excel, Tableau, and Python (Pandas, NumPy). Experienced in building automated dashboards, KPIs, and deriving actionable insights to support data-driven decision-making. Strong communicator, capable of translating complex technical information for nontechnical stakeholders. Passionate about data storytelling and solving business problems using statistical techniques.

Skills & Expertise (41)

Excel Intermediate

6.0/10

0.5

Years Exp

SQL Intermediate

5.5/10

0.5

Years Exp

Power BI Intermediate

5.5/10

0.5

Years Exp

Power Query Intermediate

5.5/10

0.5

Years Exp

Tableau Intermediate

5.5/10

0.5

Years Exp

A/B testing Intermediate

5.0/10

0.5

Years Exp

Data Cleansing Intermediate

5.0/10

0.5

Years Exp

Hypothesis Testing Intermediate

5.0/10

0.5

Years Exp

Regression Analysis Intermediate

5.0/10

0.5

Years Exp

Time Series Analysis Intermediate

5.0/10

0.5

Years Exp

Data Analytics Intermediate

5.0/10

0.5

Years Exp

Data Exploration Intermediate

5.0/10

0.5

Years Exp

Exploratory data analysis Intermediate

5.0/10

0.5

Years Exp

Data Visualization Intermediate

5.0/10

0.5

Years Exp

Dashboards Intermediate

5.0/10

0.5

Years Exp

KPI Dashboards Intermediate

5.0/10

0.5

Years Exp

Data Presentation Intermediate

5.0/10

0.5

Years Exp

Data Storytelling Intermediate

5.0/10

0.5

Years Exp

Business Acumen Intermediate

5.0/10

0.5

Years Exp

Problem-solving Intermediate

5.0/10

0.5

Years Exp

Critical thinking Intermediate

5.0/10

0.5

Years Exp

Presentation Skills Intermediate

5.0/10

0.5

Years Exp

Data Manipulation Intermediate

5.0/10

0.5

Years Exp

Data Preparation Intermediate

5.0/10

0.5

Years Exp

Data Extraction Intermediate

5.0/10

0.5

Years Exp

Python Intermediate

5.0/10

0.5

Years Exp

Pandas Intermediate

5.0/10

0.5

Years Exp

Statistics Intermediate

5.0/10

0.5

Years Exp

DAX Beginner

4.5/10

0.5

Years Exp

LOD Beginner

4.0/10

0.5

Years Exp

Power Pivot Beginner

4.0/10

0.5

Years Exp

Seaborn Beginner

4.0/10

0.5

Years Exp

Matplotlib Beginner

4.0/10

0.5

Years Exp

NumPy Beginner

4.0/10

0.5

Years Exp

Git Beginner

4.0/10

0.5

Years Exp

GitHub Beginner

4.0/10

0.5

Years Exp

Google BigQuery Beginner

4.0/10

0.5

Years Exp

RLS Beginner

3.5/10

0.5

Years Exp

Oracle Beginner

3.5/10

0.5

Years Exp

SSIS Beginner

3.0/10

0.5

Years Exp

Alteryx Beginner

3.0/10

0.5

Years Exp

Work Experience

Data Analyst Trainee

ProAzure Software Solutions Pvt Ltd

Oct 2024 - Mar 2025

Developed a real-time pricing index system for SKU comparison across e-commerce platforms. Implemented predictive models and mathematical logic to optimize pricing strategy. Achieved a 15% reduction in marketing spend while maintaining sales volume. Monitored competitor pricing trends through automated dashboards. Utilized Excel and Power Query for cleaning and transforming raw order and customer data (ETL). Imported data into SQL Server calculated key performance indicators such as order frequency, restaurant count, and region-wise sales. Designed interactive dashboards in Tableau and Power BI using DAX and Power Query. Applied statistical techniques to identify user behavior and growth opportunities.

Education

Master of Computer Application - Dr. Babasaheb Ambedkar Marathwada University Sub Campus

2022 - 2024 · Afghanistan

B.Sc. in Mathematics - Punyashlok Ahilyadevi Holkar Solapur University

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 6/15

💰 Rate 0/5

🏆 Certs 0/5

✅ Verified 5/5

Total Score 81/100

Profile Overview

Member sinceAug 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation

Skills (41)

Click a skill to find developers with the same skill

Excel SQL Power BI Power Query Tableau A/B testing Data Cleansing Hypothesis Testing Regression Analysis Time Series Analysis +31 more

Similar Profiles

Abhineet Verma

Data

Rahul Agarwal

Data Analyst

Saijyothi A

Data Analyst

Amruta Shelke

Data Analyst

View All Developers →