Aravya Verma

Business Analyst with experience across consulting and analytics roles in the UK and India. MSc in Business Analytics from Warwick Business School. Skilled in requirements gathering, process mapping, stakeholder management and UAT, with hands-on experience in SQL, Power BI, and Excel to extract insights and drive decisions. Proven track record of delivering reports and analyses for senior stakeholders, with measurable impact on operational efficiency and business performance.

Workforce Planning Analyst at GXO Logistics (2025-11 – 2026-02)

• Built 3 Power BI dashboards tracking 8 KPI's for 21 warehouse functions, improving daily staffing decisions by ~30%
• Reduced planning time by 40% via self-serve forecast-vs-actual dashboard integrating daily order volumes for pre-shift staffing
• Eliminated 15-20 capacity gaps by developing a heuristic model across 14 logistics functions & 260 operatives for reallocation

Business Consultant Intern at Blackmont Consulting (2025-08 – 2025-10)

UK Cosmetic Clinic Expansion Project

• Led European expansion strategy by evaluating competitors on 7 services, delivering positioning framework with breakeven analysis
• Identified pricing inefficiencies and redesigned service bundles, improving acquisition and retention via structured tiering model
• Diagnosed conversion leakages across website funnel, resolving 6 critical drop-offs, ↑conversions by 16% and ↓bounce rate by 15%
• Accelerated growth by 3-phase voucher strategy benchmarked against 5 competitors, defining redemption tracking and AOV metrics

Data Analyst Intern at Genpact (2023-07 – 2023-08)

• Built composite Power BI model, 4 data sources, 5 dashboards tracking 9 KPIs, resolving manual reporting for 4 internal teams
• Ensured data integrity by conducting EDA, resolving duplicate records, outliers, inconsistencies and standardised calendar table
• Enabled KPI tracking by performing SQL joins, 9 DAX measures and implementing RLS across 3 access levels for dashboards
• Eliminated 8 hrs/week manual reporting via ETL pipeline integrating RPA platforms, ChatBot, ServiceNow & PEG
• Authored BRD from 12 stakeholders defining data sources, KPI logic, dynamic filters and workflows, adopted for daily reporting

MSc in Business Analytics – Warwick Business School (2024-09 – 2025-09)

BBA in Business Analytics – Christ University (2021-08 – 2024-05)