Tancred Wolverstone-Appiah

Produce daily pickup, pace, and STR comp-set reports for 6 properties; flagged 40+ compression nights in 2025 that drove rate moves worth an estimated $312K in added room revenue. Review and override IDeaS G3 rate recommendations for 2 downtown hotels during St. Patrick's Day, SCAD events, and cruise-port weekends; ADR on those dates rose 12% year over year with occupancy held above 94%. Rebuilt the group-displacement calculator in Excel so sales managers can price wedding and SCAD blocks in 10 minutes instead of a day; win rate on quoted groups rose from 31% to 38%. Audit rate parity across Expedia, Booking.com, and brand.com twice a week; cut parity breaks 70% and helped shift 6 points of mix from OTA to direct, saving about $95K in commissions. Wrote SQL queries against the Opera Cloud data warehouse to build a Power BI dashboard (segment mix, length of stay, lead time, cancellations) used in the weekly revenue strategy meeting. Tested a 2-night minimum-stay rule on 18 peak Saturdays; RevPAR on those weekends rose 7% with no drop in Sunday occupancy.

Loaded rates, restrictions, and packages in SynXis and the channel manager for 9 room types and 14 rate plans with zero rate-loading errors in the final 6 months. Built a weekly forecast-versus-actual tracker that cut the hotel's 30-day occupancy forecast error from 8.2% to 4.6%. Answered 60+ reservation calls and emails a day, upsold suites and parking packages, and added $21K in incremental revenue over the internship. Cleaned 3 years of no-show and cancellation data, which supported a new 48-hour cancellation policy that cut same-day cancellations 27%.

Checked in 80–120 guests a shift, handled night audit backup, and kept guest satisfaction scores above 4.6 out of 5 on Medallia. Trained 5 new agents on Opera PMS check-in, folio, and key-card procedures.

GPA 3.71, Dean's List 6 semesters Capstone: Dynamic Pricing Model for a 120-Room Coastal Hotel (Python and Excel regression on 4 years of demand data)