Aviral Awasthi

Business Analyst Intern

New Delhi 0+ yrs exp 71 · Very Good

About

No bio added yet

Skills & Expertise (24)

Python Intermediate

7.4/10

Years Exp

Power BI Intermediate

7.2/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

NumPy Intermediate

7.0/10

Years Exp

Google Workspace Intermediate

7.0/10

Years Exp

MS Office Intermediate

7.0/10

Years Exp

Data Visualization Intermediate

7.0/10

Years Exp

Data Analysis Intermediate

7.0/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

MySql Intermediate

6.2/10

Years Exp

GitHub Intermediate

6.0/10

Years Exp

VS Code Intermediate

6.0/10

Years Exp

HTML Intermediate

6.0/10

Years Exp

SQL Server Intermediate

5.5/10

Years Exp

JavaScript Intermediate

5.5/10

Years Exp

MongoDb Intermediate

5.0/10

Years Exp

Market Research Intermediate

5.0/10

Years Exp

Databricks Beginner

5.0/10

Years Exp

Snowflake Beginner

5.0/10

Years Exp

C++ Beginner

4.5/10

Years Exp

Airflow Beginner

4.0/10

Years Exp

Folium Beginner

4.0/10

Years Exp

Streamlit Beginner

4.0/10

Years Exp

Work Experience

Business Analyst Intern

Swiggy

Feb 2026 - Present

Leveraged Claude to automate DAG creation, cart-blocking workflows, and monthly I-Star refreshes, reducing manual effort by 70% and delivering Rs.5+ CPO savings through process automation. Built end-to-end IGCC and Discounting Power BI dashboards tracking claim%, CPO, and fraud signals across 10+ dimensions, saving 5+ hours weekly and enabling real-time monitoring for 4 teams. Designed and deployed a Store IGCC Rule within the hourly IGCC Fact workflow for NU/DU cohorts, driving projected savings of 10p CPO through POD-based claim blocking. Conducted OBD Pre-Delivery Check and store-level IGCC analyses across 8+ high-risk cohorts, identifying fraud patterns and delivering projected savings of 15p CPO. Built a payment-rule confusion matrix with cool-off signals, reducing false positives from 27% to 0%, improving precision from 73% to 100%, and generating 2p CPO impact.

Data Analyst Intern

We Care Club

May 2025 - Jul 2025

Enhanced data quality by identifying and resolving 8 critical data inconsistencies within the wellness database, improving reporting accuracy by 15% and minimizing reporting errors. Spearheaded automation of wellness reporting pipelines across 35+ companies and 12+ centres, enabling data-driven expansion decisions in under two months.