SS

Featured Project

Evermore Intelligence Platform

End-to-end revenue intelligence for a luxury resort. A unified data warehouse, configuration management system, and AI-powered analytics layer — built solo over six months.

27Tables in Production
6Months to Build
100+Rate Plans Managed
1Engineer
View
View RepositoryConnect on LinkedIn

The Challenge

Fragmented data, manual processes, zero visibility

Evermore Orlando Resort, a luxury property with 1,200+ keys and complex commercial operations, had no centralized data infrastructure. Revenue teams relied on spreadsheets, manual exports, and tribal knowledge to make pricing decisions.

Rate plans lived in one system. Market segments in another. Booking sources scattered across channels with no unified taxonomy. Leadership had no single source of truth for revenue performance.

Before
  • Manual Excel exports every morning
  • No historical trend analysis possible
  • Configuration changes required developer tickets
  • Leadership reports took 2-3 days to compile
After
  • Automated daily pipeline refreshes by 6am
  • 18+ months of historical data for trend analysis
  • Self-service configuration with audit logging
  • Real-time dashboards with natural language queries

What I Built

Three integrated systems, one unified platform

The platform comprises a star-schema data warehouse, a React-based configuration manager, and an AI layer for natural language analytics. Each component was designed to work independently while sharing a common data model.

Data Warehouse

A centralized repository that consolidates all revenue data into a single source of truth. Executives can now access real-time performance metrics, historical trends, and forecasting data through intuitive dashboards.

The system automatically processes booking data, calculates key performance indicators like Average Daily Rate, Revenue per Available Room, and occupancy, and surfaces actionable insights for revenue optimization.

27Production Tables
50K+Daily Records
BigQueryDataformSQLStar Schema

Configuration Manager

A self-service application that allows revenue managers to update commercial definitions without developer intervention. Rate plans, market segments, and booking channels can be modified through an intuitive interface.

Every change is logged with full audit trails, ensuring governance and compliance. Role-based permissions ensure only authorized users can modify production configurations.

100+Rate Plans
15+Market Segments
ReactNext.jsPostgreSQLTypeScript

Evermore Intelligence

An AI-powered interface that allows anyone to query revenue data using natural language. Ask questions like "What was our average daily rate last weekend?" or "Show me pickup trends for corporate groups" and receive instant, accurate answers.

Democratizes data access across the organization, eliminating the need for SQL knowledge or technical training. Executives can get answers in seconds, not days.

<5sQuery Response
95%Query Accuracy
Claude APIRAGSemantic LayerPython

Measurable Impact

Results that matter

2-3 days5 min
Report Generation
0 months18+
Historical Data
100%0%
Manual Excel Work
—99.9%
Pipeline Uptime

Revenue team can now make data-driven pricing decisions same-day instead of waiting for weekly reports

Leadership has real-time visibility into performance metrics across all channels and segments

Configuration changes that previously required developer tickets now take minutes with full audit trails

Natural language queries democratize data access across the organization regardless of technical skill

Interested in the technical details?

The full codebase is open source. Explore the Dataform transformations, schema definitions, and CI/CD workflows on GitHub.

View RepositoryGet in Touch