Vaishali Agrawal
Hi, I'm Vaishali Agrawal, a data analyst with 2 years of experience spanning marketing analytics, fraud detection, and customer intelligence at OYO and Toppers Notes.
About
Hi, I’m Vaishali Agrawal, a data analyst with 2 years of experience spanning marketing analytics, fraud detection, and customer intelligence at OYO and Toppers Notes. I translate complex data into actionable insights that move metrics and drive business decisions. My work has delivered measurable outcomes, including a 60% reduction in fraudulent bookings and a 5% ROAS improvement, along with full automation of reporting pipelines.
I’m proficient in Python, SQL, R, and Power BI, and I enjoy building scalable dashboards and automated workflows that keep stakeholders informed. I’ve designed real-time dashboards, event-driven budget mechanisms, and customer segmentation models that guide pricing, campaigns, and customer experience. I thrive in cross-functional teams and love turning data into strategies.
- 2 years' experience
- Joined April 2026
Industry experience
- Software & Internet
- Education
- Professional Services
Work experience
Ad Budget Optimisation Model: Built a Power BI model using ROAS, marginal ROAS, spend and purchase volume; delivered a 5% increase in campaign ROAS. Implemented a 0-7 day post-budget-change cooling mechanism to minimise overreaction to short-term ROAS fluctuations and improve decision consistency. Integrated an exam/vacancy event calendar with aspirant scale to compute an Event Pressure Score, aligning budget recommendations to demand timing phases. Created a Creatives Performance Dashboard to monitor real-time performance of newly launched creatives and daily KPIs (spend, ROAS, budget allocation). Automated dashboard refresh and daily report distribution using Power Automate, saving manual data pulls.
Received COO Recognition Award for fraud detection and customer segmentation. Designed automated real-time dashboards using R and SQL to replace manual reporting and track business KPIs. Reduced fraudulent bookings by 60% by building an end-to-end detection and response workflow. Executed daily data extraction, processing, and analysis to address business issues and support performance targets. Led a Customer Segmentation project analyzing 1.5M+ users; developed an R-based clustering model to identify key behavioural cohorts, informing marketing campaigns and CRM conversations. Drove pricing and discount optimisation, resulting in cost efficiencies and a 1.5% increase in realisation. Led CRM campaign analytics, cohort strategy, and execution via daily dashboards to improve campaign productivity. Conducted traffic segmentation to improve IVR routing and reduce non-core queries.
Education
Hire Vaishali Agrawal today
Post a job and invite Vaishali, or contact them directly. No hidden commission.
