Aayesha Ashraf

Business Intelligence and Data Analytics Professional

LinkedIn

About

Highly accomplished Business Intelligence and Data Analytics professional with a proven track record of transforming complex data into actionable insights and high-impact dashboards. Expert in leveraging Power BI, SQL, and Python to drive significant improvements in field sales, optimize operational efficiencies, and enhance user experiences. Adept at developing scalable solutions, automating processes, and utilizing advanced analytical tools, including AI assistants, to streamline workflows and accelerate data-driven decision-making.

Work Experience

Associate Manager – Business Analytics

PhysicsWallah

Aug 2022 - May 2024

Managed business intelligence and data analytics initiatives to optimize sales, operations, and user engagement, driving data-driven strategies and process improvements across various departments.

  • Developed high-impact Power BI dashboards to track field visits and sales performance, significantly improving visit efficiency and contributing to a projected 3x boost in conversions by November 2024.
  • Designed and implemented a comprehensive Power BI dashboard for daily order, sales, SKU, and inventory management, incorporating predictive analytics for stock forecasting; this initiative resulted in a 2x sales increase in FY 23-24 and eliminated stock shortages.
  • Directed the end-to-end data strategy for an NGO-backed educational initiative, mapping the student journey to inform program enhancements, directly contributing to securing renewed funding and expanding free education programs.
  • Conducted in-depth analysis of over 1,000 coupon codes to identify campaign performance trends, differentiate high- and low-performing campaigns, and implement targeted strategies that successfully revived underperforming codes, significantly driving revenue growth.
  • Developed and deployed a robust school code assignment framework, optimizing lead management processes and significantly enhancing conversion rates across the sales funnel.
  • Automated key operational workflows using Doc Studio and Apps Script, resulting in a 40% reduction in manual effort (saving approximately 20 hours per week) and significantly boosting overall process efficiency.
  • Spearheaded the "School Connect History" initiative to consolidate multi-source school engagement data into a unified, standardized database, providing leadership with a clear, holistic view of engagement across SIPs, book sales, and batch enrollments, thereby enhancing targeting strategies.
  • Mentored and trained multiple team members on advanced reporting techniques, including data structuring, Google Sheets formula application, and Power BI visualization, which elevated the overall quality and consistency of departmental reporting.

Education

Computer Science & Engineering

Jamia Hamdard

87%

Aug 2020 - Jun 2022

Computer Science & Engineering

Al-Falah University

80%

Aug 2015 - Jun 2019

Projects

School Conversion Funnel Optimization

Aug 2022 - May 2024

Mapped the comprehensive school engagement lifecycle to identify key stages and optimize conversion pathways.

NGO Learning Pathways Dashboard

Aug 2022 - May 2024

Developed a robust dashboard to track and visualize student progression through educational pathways for an NGO-backed initiative.

Awards

Star Performer of the Month

PhysicsWallah

Dec 2024

Recognized for building high-impact dashboards, automating reporting processes, and driving measurable improvements in field conversion rates and inventory forecasting.

Star Performer of the Month

PhysicsWallah

Jun 2024

Recognized for building high-impact dashboards, automating reporting processes, and driving measurable improvements in field conversion rates and inventory forecasting.

Star Performer of the Month

PhysicsWallah

Feb 2023

Recognized for building high-impact dashboards, automating reporting processes, and driving measurable improvements in field conversion rates and inventory forecasting.

Skills

Analytics & BI Tools

  • Power BI (DAX)
  • Qlik
  • Looker
  • Excel
  • Data Modelling
  • Doc Studio
  • Google Sheets (Advanced)

Programming

  • SQL
  • Python (Pandas, NumPy, Matplotlib, Seaborn)
  • Apps Script

Project Management

  • Planning
  • A/B Testing
  • Team Collaboration

Data & Visualization

  • Data Mining
  • Statistical Analysis
  • Report Automation
  • Charts
  • Storytelling
  • KPI Tracking