Wyndham Hotels India Revenue Analyst Interview: Rounds, Questions and Preparation

What the job involves

As a Revenue Analyst in travel, hospitality and food service, you manage pricing, inventory and demand forecasting to maximise revenue per available room (RevPAR) or per cover. Day to day you analyse booking curves, competitor rates and market demand, then recommend or set rates, restrictions and overbooking levels across channels. You work closely with sales, marketing and operations to balance occupancy, average daily rate (ADR) and total revenue.

Role and technical knowledge

1. 1

   What is RevPAR and how does it differ from ADR and occupancy?

   Define RevPAR as ADR times occupancy or total room revenue divided by available rooms. Explain that ADR ignores unsold rooms and occupancy ignores rate, so RevPAR combines both.

2. 2

   Explain the concept of rate fencing in a hotel.

   Rate fencing uses restrictions like advance purchase, minimum stay or non-refundable terms to segment customers and prevent high-rate guests from buying low rates. Mention how it protects ADR while filling rooms.

3. 3

   How would you forecast demand for a hotel in a city hosting a major cricket match?

   Look at historical event data, booking pace, competitor rates, flight and event schedules. Build a pick-up curve and adjust rates and minimum stay restrictions as the event nears.

4. 4

   What is the difference between dynamic pricing and fixed pricing in hospitality?

   Dynamic pricing changes rates based on demand, time and segment, while fixed pricing stays constant. Explain why dynamic pricing is common in hotels and restaurants to capture willingness to pay.

Practical scenarios and calculations

1. 5

   A 100-room hotel has 70 rooms sold at an ADR of Rs 5,000. What is the RevPAR? If tomorrow you expect 80 rooms at Rs 4,500, which day has better RevPAR?

   Calculate RevPAR as (70 x 5000)/100 = Rs 3,500. For tomorrow, (80 x 4500)/100 = Rs 3,600. Conclude tomorrow is better despite lower ADR because occupancy gain outweighs rate drop.

2. 6

   Your hotel is projected to sell out on a high-demand weekend. What rate and inventory actions would you take?

   Close low-rate segments, raise rates, apply minimum stay restrictions, and consider overbooking slightly based on historical no-show and cancellation rates. Monitor pick-up and competitor rates daily.

3. 7

   An OTA is offering a lower rate than your own website. How do you handle this?

   Check for rate parity violations, contact the OTA to adjust or close the rate, and reinforce best rate guarantee on direct channels. Explain the importance of direct bookings for margin and guest data.

4. 8

   How would you use pick-up analysis to decide whether to open or close discounted rates for next month?

   Compare current pick-up against the same time last year and the forecast. If pick-up is ahead of forecast, close discounts and raise rates. If behind, open selective discounts to stimulate demand.

Behavioural and situational questions

1. 9

   Tell me about a time you had to make a decision with incomplete data.

   Use a STAR example from a project, internship or college competition. Show how you identified key assumptions, used available data, and adjusted when new information arrived.

2. 10

   Describe a situation where you had to convince someone to change their mind using data.

   Focus on how you presented clear numbers, addressed their concerns, and listened to their perspective. Highlight the outcome and what you learned about communication.

3. 11

   How would you handle a conflict with a sales manager who wants to offer a large discount to a corporate client?

   Show empathy for the sales goal but use revenue analysis to evaluate the discount's impact on RevPAR and total revenue. Suggest alternatives like value-adds or restricted dates instead of pure rate cuts.

4. 12

   Give an example of a time you worked under a tight deadline.

   Pick a concrete example and explain how you prioritised tasks, used tools like Excel to speed up analysis, and communicated progress. End with the result and any lesson on time management.

HR and motivation

1. 13

   Why do you want to work in revenue management in the hospitality sector?

   Link your interest in data, strategy and travel. Mention how revenue management directly impacts business performance and offers a mix of analytical and commercial work.

2. 14

   What do you know about our company and how it competes in the Indian market?

   Research the brand's positioning, key markets, recent expansions and target segments. For a smaller or fast-growing employer, highlight agility, franchise model or focus on mid-scale and budget travellers.

3. 15

   Where do you see yourself in three years in a revenue role?

   Show a realistic progression, such as moving from analyst to senior analyst or revenue manager, and mention skills you want to build like RMS expertise, forecasting and team leadership.

4. 16

   How do you handle feedback, especially when your analysis is challenged?

   Demonstrate openness to feedback, willingness to re-check assumptions, and focus on learning. Give a brief example of incorporating feedback to improve a project or task.