Back to Developers
Pranay Agrawal

Pranay Agrawal

Data Analyst

Nagpur, Maharashtra, India 2+ yrs exp 85 ยท Excellent

About

Data Analyst with experience in reporting, dashboard development, data validation, and operational analytics at Amazon. Skilled in Excel, SQL, Power BI, and data visualization, with a proven track record of improving reporting accuracy and business performance through data-driven insights. Experienced in data cleaning, KPI tracking, workflow automation, and transforming complex datasets into actionable business recommendations.

Skills & Expertise (16)

Excel Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
3
Years Exp
Data Analysis Advanced
8.0/10
3
Years Exp
Data Cleaning Advanced
8.0/10
3
Years Exp
Dashboard Development Advanced
8.0/10
3
Years Exp
Data Visualization Advanced
8.0/10
3
Years Exp
KPI Tracking Advanced
8.0/10
3
Years Exp
Reporting Advanced
8.0/10
3
Years Exp
Pivot Tables Advanced
7.5/10
3
Years Exp
Power Query Advanced
7.5/10
3
Years Exp
Data Validation Advanced
7.5/10
3
Years Exp
VBA Macros Advanced
7.0/10
3
Years Exp
SQL Intermediate
6.5/10
3
Years Exp
Python Intermediate
6.0/10
3
Years Exp
Root Cause Analysis RCA

Work Experience

Data Analyst Intern

Graphura

Feb 2026 - May 2026

Built and maintained Power BI dashboards to monitor engagement, conversions, ad performance, and campaign ROI. Analyzed social media and paid advertising datasets to identify audience trends and high-performing content. Developed performance scoring models using engagement metrics such as CTR, CPC, likes, shares, and view rates. Automated recurring KPI reports using Excel and Power Query, improving reporting efficiency. Delivered data-driven recommendations to optimize campaign performance and resource allocation.

L3 Associate

Amazon

Nov 2023 - Nov 2025

Developed Excel and Power BI dashboards for KPI monitoring and operational reporting. Analyzed operational datasets to identify trends, performance gaps, and improvement opportunities. Automated Excel-based workflows using VBA macros, increasing productivity from 50 to 62 tasks per day. Performed data validation, cleansing, and quality checks to improve reporting accuracy and consistency. Collaborated with cross-functional teams to standardize reporting processes and support business decision-making.

Education

Master of Business Administration - DMS, Savitribai Phule Pune University

2021 - 2023 ยท Afghanistan

Bachelor of Engineering - RCERT, Chandrapur, Gondwana University

2014 - 2018 ยท 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 10/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 85/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation