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.

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. 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.

Available to hire

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.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert

Work Experience

Data Analyst at TOPPERS NOTES
March 1, 2026 - Present
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.
Data Analyst at ORAVEL STAYS PRIVATE LIMITED (OYO)
July 1, 2019 - November 1, 2020
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

B.Tech in Civil Engineering at Indian Institute of Technology, Bombay
July 1, 2015 - April 1, 2019
Engineering Services Exam (UPSC) at Engineering Services Examination
January 1, 2021 - February 1, 2023

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Education, Professional Services