Vatsal R

Cluster Business Analyst

Accor • Full-time

Feb 2025 - Present • 1 yr 7 mos

• Lead data-driven revenue management across a multi-property hotel cluster, analyzing occupancy, ADR, RevPAR, revenue, booking pace, demand, pricing, and business mix to support commercial decisions. • Develop demand calendars and dynamic forecasts using historical performance, seasonality, holidays, events, festivals, flight trends, market conditions, and booking patterns. • Apply statistical analysis, predictive modeling, and machine-learning techniques using Python, Pandas, NumPy, SciPy, and scikit-learn for demand forecasting, segmentation, classification, and revenue optimization. • Perform daily pickup, booking-pace, competitive, market, OTA, and channel analysis to identify trends, risks, pricing opportunities, and distribution optimization actions. • Analyze customer and country-market segments using revenue, room nights, LOS, lead time, cancellation behavior, packages, promotions, and booking patterns to identify high-value markets and growth opportunities. • Develop Power BI dashboards and analytical reports for revenue, occupancy, ADR, RevPAR, pricing, distribution, sales, marketing, and operational KPIs. • Integrate and transform hotel, reservation, marketing, promotional, flight, and external datasets using SQL, Power Query, Excel/VBA, and data-automation tools. • Automate recurring reporting and data workflows using Power Automate, Power Query, and Excel, improving reporting efficiency, consistency, and data quality. • Analyze digital marketing performance using spend, impressions, reach, engagement, CPA, ROAS, conversions, and direct-booking data to evaluate campaign effectiveness and ROI. • Conduct forecast-versus-actual, budget variance, competitive benchmarking, and market-trend analysis to identify performance gaps and recommend measurable revenue actions. • Collaborate with Sales, Reservations, Marketing, Finance, and Operations teams to translate analytical insights into pricing, promotion, distribution, and revenue strategies.

Business Analyst

Consultancy • Full-time

Jul 2023 - Jan 2025 • 1 yr 6 mos

• Analyzed product sales, category, inventory, and financial data to identify growth opportunities and support channel, assortment, promotional, and operational decisions. • Built interactive Power BI and Tableau dashboards and standardized monthly, quarterly, and annual reports to support data-driven stakeholder decisions. • Developed SQL queries, stored procedures, and data models for data cleansing, transformation, KPI reporting, and analytical workflows. • Designed and optimized SSIS ETL pipelines and Power BI data workflows to improve data quality, processing efficiency, and reporting reliability. • Automated recurring business processes and data workflows using Power Automate, reducing manual effort and improving operational efficiency. • Developed Python regression and classification models for inventory-risk analysis, forecasting, predictive insights, and data-driven business cases. • Applied statistical analysis and exploratory data analysis to identify trends, patterns, anomalies, and key drivers of business performance. • Defined, monitored, and analyzed business KPIs, translating analytical findings into actionable recommendations for product and business stakeholders. • Produced monthly, quarterly, and annual analytics reports covering inventory performance, risk assessment, financial impact, trends, and business recommendations. • Collaborated with cross-functional stakeholders to translate complex datasets into actionable insights and support data-driven business strategy.