Ridhi Aggarwal

Business Analyst

Faridabad, India 1+ yrs exp 83 · Excellent

About

Detail-oriented Business Analytics graduate (Warwick, Merit) with 1.7 years of experience in data analysis, dashboard reporting, and operational KPI tracking. Proficient in Excel, SQL, Python, and Power BI. Experienced in translating data findings into actionable recommendations for stakeholders, with strong interest in customer journey analysis and product operations.

Skills & Expertise (15)

Microsoft Excel Advanced

8.0/10

1.7

Years Exp

VLOOKUP Advanced

7.5/10

1.7

Years Exp

XLOOKUP Advanced

7.5/10

1.7

Years Exp

SUMIFS Advanced

7.5/10

1.7

Years Exp

Charts Intermediate

7.0/10

1.7

Years Exp

Data Cleaning & Validation Advanced

7.0/10

1.7

Years Exp

Power BI Intermediate

6.5/10

1.7

Years Exp

MIS Reporting Intermediate

6.0/10

1.7

Years Exp

Trend Analysis Intermediate

6.0/10

1.7

Years Exp

Python Intermediate

5.5/10

1.7

Years Exp

SQL Intermediate

5.5/10

1.7

Years Exp

Database Management Intermediate

5.0/10

1.7

Years Exp

A/B testing Intermediate

4.5/10

1.7

Years Exp

Statistical Modelling Intermediate

4.0/10

1.7

Years Exp

EDA

Work Experience

Business Analyst

Slate and Sandstone

Jan 2023 - Jul 2024

Improved shipment forecast accuracy by 12% by analysing order and fulfilment data across 50+ monthly cycles to identify packing-to-shipping bottlenecks. Enabled monthly procurement and dispatch decisions by building and maintaining Excel dashboards tracking three core KPIs (revenue, top products, fulfilment status). Improved operational throughput by 20% by identifying fulfilment delays through order timeline trend analysis and recommending workflow changes. Maintained data accuracy across business planning reports by owning validation checks using Excel formulas (VLOOKUP, XLOOKUP, Pivot Tables, SUMIFS) and Power Query.