Prajwal Kharate

Data Analyst

Pune, Maharashtra 1+ yrs exp 84 · Excellent

About

Data Analyst with 1.5+ years turning raw, multi-platform business data into decisions for e-commerce and pharma teams. Built and maintain 6+ Power BI dashboards and automated MIS reports that cut manual reporting effort by 40% and turnaround time by 30%. Proficient in SQL (joins, CTEs, aggregations), Advanced Excel, Power Query, and DAX. Delivered a daily revenue-tracking report used by 6+ senior leaders to monitor MTD targets, GMV, and ROAS. Known for clean data pipelines, fast turnaround, and dashboards stakeholders actually use.

Skills & Expertise (32)

Pivot Tables Intermediate

7.0/10

1.5

Years Exp

Advanced Excel Intermediate

7.0/10

1.5

Years Exp

Power BI Intermediate

7.0/10

1.5

Years Exp

Data Cleaning Intermediate

7.0/10

1.5

Years Exp

Dashboard Development Intermediate

7.0/10

1.5

Years Exp

SQL Intermediate

6.5/10

1.5

Years Exp

Index-match Intermediate

6.5/10

1.5

Years Exp

SUMIFS Intermediate

6.5/10

1.5

Years Exp

VLOOKUP Intermediate

6.5/10

1.5

Years Exp

XLOOKUP Intermediate

6.5/10

1.5

Years Exp

MIS Reporting Intermediate

6.0/10

1.5

Years Exp

Reporting Automation Intermediate

6.0/10

1.5

Years Exp

Data Validation Intermediate

6.0/10

1.5

Years Exp

Trend Analysis Intermediate

6.0/10

1.5

Years Exp

KPI Tracking Intermediate

6.0/10

1.5

Years Exp

Data Storytelling Intermediate

6.0/10

1.5

Years Exp

Analytical Thinking Intermediate

6.0/10

1.5

Years Exp

Problem Solving Intermediate

6.0/10

1.5

Years Exp

Google Sheets Intermediate

6.0/10

1.5

Years Exp

Data Modeling Intermediate

6.0/10

1.5

Years Exp

Power Query Intermediate

6.0/10

1.5

Years Exp

DAX Intermediate

6.0/10

1.5

Years Exp

Pandas Intermediate

6.0/10

1.5

Years Exp

Python Intermediate

6.0/10

1.5

Years Exp

MySql Intermediate

6.0/10

1.5

Years Exp

NumPy Intermediate

5.5/10

1.5

Years Exp

Stakeholder Management Intermediate

5.5/10

1.5

Years Exp

Business insight generation Intermediate

5.5/10

1.5

Years Exp

Seaborn Intermediate

5.0/10

1.5

Years Exp

AI-assisted Analytics Intermediate

5.0/10

1.5

Years Exp

Postgresql Intermediate

5.0/10

1.5

Years Exp

EDA

Work Experience

Junior Data Analyst

Amplicomm Solutions Pvt. Ltd.

May 2025 - Present

Automated recurring business reports in Advanced Excel, cutting manual reporting effort by 40% across weekly and monthly leadership reviews. Built the Amplicomm SMT report — a daily revenue-tracking report used by 6+ senior leaders to monitor MTD revenue vs. target, GMV, and ROAS. Developed and maintain 2 Power BI dashboards tracking inventory performance, category-level sales trends, and core business KPIs. Cleaned and validated datasets across 3-4 e-commerce platforms, improving reporting accuracy and decision-making reliability. Analyzed sales and inventory trends across 10+ SKUs to identify stock gaps, demand patterns, and category-level growth opportunities. Partnered directly with operations and category leads to translate KPI reports into weekly action items for business reviews.

Data Analyst Intern

Zoobion Pharmaceuticals

Aug 2024 - Feb 2025

Standardized sales, product, CRM, and attendance datasets using Advanced Excel (Pivot Tables, XLOOKUP, VLOOKUP, SUMIFS, INDEX-MATCH) to support accurate business reporting. Built 4 Power BI dashboards using DAX, Power Query, and data modeling to support performance analysis for management. Standardized 4 dataset types across 30+ sales records, reducing reporting errors and cutting turnaround time by 30%. Created and maintained a centralized Excel database consolidating 2 years of sales and credit note records, improving data accessibility for historical trend analysis and audit reporting.