Aman Srivastava

Data Analyst

Delhi, India 0+ yrs exp 81 · Excellent

About

Data Analyst with internship experience processing 600K–793K+ retail transactions using SQL, Power BI, and Python. Built automated dashboards reducing reporting time by 60–70%. Skilled in KPI monitoring, RFM segmentation, ETL pipelines, and translating data into business decisions. Pursuing MCA (AI & ML) at Amity University Online; NIELIT AI & ML Diploma — Govt. of India certified. Seeking a full-time Data Analyst role.

Skills & Expertise (32)

Report Automation Advanced

8.5/10

0.25

Years Exp

Power BI Service Advanced

8.5/10

0.25

Years Exp

Window Functions Advanced

8.0/10

0.25

Years Exp

ETL Advanced

8.0/10

0.25

Years Exp

Query Optimisation Advanced

8.0/10

0.25

Years Exp

DAX Advanced

8.0/10

0.25

Years Exp

Business Intelligence Advanced

8.0/10

0.25

Years Exp

Data Visualization Advanced

8.0/10

0.25

Years Exp

RFM Segmentation Advanced

8.0/10

0.25

Years Exp

KPI Analysis Intermediate

7.5/10

0.25

Years Exp

Pivot Tables Intermediate

7.5/10

0.25

Years Exp

Power Query Intermediate

7.5/10

0.25

Years Exp

Stakeholder Reporting Intermediate

7.5/10

0.25

Years Exp

Root Cause Analysis Intermediate

7.5/10

0.25

Years Exp

Ad-Hoc Reporting Intermediate

7.5/10

0.25

Years Exp

Trend Analysis Intermediate

7.5/10

0.25

Years Exp

Data Cleaning Intermediate

7.5/10

0.25

Years Exp

Exploratory data analysis Intermediate

7.5/10

0.25

Years Exp

Data Modelling Intermediate

7.5/10

0.25

Years Exp

MySql Intermediate

7.5/10

0.25

Years Exp

Postgresql Intermediate

7.5/10

0.25

Years Exp

Joins Advanced

7.5/10

0.25

Years Exp

Matplotlib Intermediate

7.0/10

0.25

Years Exp

NumPy Intermediate

7.0/10

0.25

Years Exp

Pandas Intermediate

7.0/10

0.25

Years Exp

VLOOKUP Intermediate

7.0/10

0.25

Years Exp

XLOOKUP Intermediate

7.0/10

0.25

Years Exp

Jupyter Notebook Intermediate

7.0/10

0.25

Years Exp

GitHub Intermediate

7.0/10

0.25

Years Exp

Star Schema Intermediate

7.0/10

0.25

Years Exp

CTEs Drill-through

Work Experience

Data Analyst Intern

UpDate Pvt Ltd

Sep 2025 - Dec 2025

Reduced weekly reporting time by 60% by building 3 automated Power BI dashboards (20+ DAX measures: YoY growth, rolling averages, cohort retention) for a 4-person business team. Optimised 30+ SQL queries with CTEs and window functions across 600K+ transactions, cutting average query runtime by ~40%. Segmented 5,800+ customers into 4 RFM tiers (VIP, Loyal, At-Risk, Churned); delivered actionable retention insights to stakeholders. Built 5-source ETL pipelines improving data refresh efficiency by 60–70% and eliminating manual data entry errors.

Education

Master of Computer Applications (MCA) - Amity University Online

2026 - · Afghanistan

A-Level Diploma — Artificial Intelligence & Machine Learning - NIELIT, New Delhi

2022 - 2024 · Afghanistan

Bachelor of Arts (B.A. Programme) - University of Delhi, School of Open Learning

2021 - 2024 · 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 sinceJul 2026

Skills (32)

Click a skill to find developers with the same skill

Report Automation Power BI Service Window Functions ETL Query Optimisation DAX Business Intelligence Data Visualization RFM Segmentation KPI Analysis +22 more

Similar Profiles

Rahul Agarwal

Data Analyst

Raushan Kumar

Data Analyst | Data Scientist

Divyanshu

Data Analyst

Saijyothi A

Data Analyst

View All Developers →