Proof of work, not just claims.
Reports, dashboards, and automated workflows where hotel revenue strategy meets modern AI tools. Built to eliminate spreadsheet friction and accelerate daily decisions.
Selected work
Production-grade solutions deployed in active hospitality environments.
Visual pickup & segment wash dashboard
Transformed dense, multi-tab PMS data exports into an intuitive visual dashboard tracking net room nights, ADR shifts, and segment wash across 756 keys.
| Market Segment | Rooms OTB | Net Wash (DoD) | ADR (AED) | RevPAR Impact |
|---|---|---|---|---|
| Transient (BAR) | 318 | +42 | 540 | +AED 22,680 |
| Corporate Contract | 210 | +18 | 460 | +AED 8,280 |
| Group Block | 228 | +82 | 390 | +AED 31,980 |
01 // The Problem
Daily morning pickup reports relied on copying and pasting raw exports into cumbersome workbooks. While functional, the layout was dense, slow to parse, and made spotting pacing anomalies difficult under time pressure.
02 // The Build
Engineered an advanced Excel workbook leveraging dynamic `LET`, `SUMPRODUCT`, and conditional formulas. It maintains the familiar daily paste-and-refresh workflow while feeding clean, instant visual charts.
03 // The Impact
⚡ Cut daily morning reporting prep time by 75% (saving 45+ minutes every day) and eliminated manual transcription errors across multi-property reporting.
Dynamic pace & compression tracker
Developed an early-warning booking velocity model comparing real-time On-The-Books (OTB) pacing against Same Time Last Year (STLY) and RMS budget targets.
| Compression Date | OTB Occ % | STLY Occ % | Variance | Action Status |
|---|---|---|---|---|
| Peak Event Weekend | 84% | 70% | +14% | Hurdle +15% (Active) |
| Mid-Week Corporate | 78% | 72% | +6% | Hold Rate |
| Citywide Conference | 96% | 81% | +15% | Close Open CTA |
OTB Ingestion
Velocity Spike Flag
Hurdle Adjustment
01 // The Problem
Waiting for standard weekly report cycles meant high-demand compression dates during major Abu Dhabi events were often identified too late to maximize optimal hurdle rates.
02 // The Build
Created a predictive pace tracker that automatically flags booking velocity spikes against historical curves, alerting commercial leadership the moment group or transient demand accelerates.
03 // The Impact
📈 Flagged high-demand compression dates 21 days earlier than previous manual cycles, capturing an additional +14.2% pace velocity during peak event windows.
AI morning brief & upgrade audit
Automated the daily room upgrade audit and morning commercial commentary using AI agents to spot revenue leakage and summarize overnight metrics.
> INGEST_PMS_EXPORT –target=756_keys –status=success
> AUDIT_UPGRADES –flag_unbilled_comps=true (0 discrepancies found)
> DISPATCH_EXECUTIVE_BRIEF –time=07:30 –channel=leadership
01 // The Problem
Manually cross-referencing PMS upgrade logs and drafting daily performance summaries consumed valuable time before morning strategy meetings.
02 // The Build
Deployed an agentic AI workflow that ingests daily property exports, audits complimentary upgrades for revenue leakage, and formats an executive summary ready by 07:30 AM.
03 // The Impact
⚡ Achieved 100% daily audit coverage with zero manual spreadsheet cross-checking, shifting leadership focus directly to strategic execution.
Have a report that needs a rebuild?
If you’re buried in spreadsheets or repeating the same analysis every week, let’s talk about what could be automated.