Aayesha Ashraf

Business Intelligence and Data Analytics Professional
New Delhi, IN.

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

PhysicsWallah
|

Associate Manager – Business Analytics

Summary

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

Highlights

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

Jamia Hamdard

Master of Technology (M.Tech)

Computer Science & Engineering

Grade: 87%

Al-Falah University

Bachelor of Technology (B.Tech)

Computer Science & Engineering

Grade: 80%

Awards

Star Performer of the Month

Awarded By

PhysicsWallah

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

Awarded By

PhysicsWallah

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

Awarded By

PhysicsWallah

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.

Projects

School Conversion Funnel Optimization

Summary

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

NGO Learning Pathways Dashboard

Summary

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