Enterprise Revenue Management Platform
Full-Stack BI System for Hospitality Revenue Optimization
Centralized configuration system managing 150+ rate plans, 14 distribution channels, and real-time pricing analytics for a luxury resort property.
Sofia Solis
Software Engineering Student
Revenue management was running on spreadsheets
A luxury hospitality property needed to modernize how it managed pricing strategy, room allocation, and distribution channels across its entire portfolio.
Decentralized Excel Files
Rate plan management scattered across multiple spreadsheets with no single source of truth.
No Unified Tracking
150+ discount codes and pricing strategies impossible to manage cohesively.
Manual Processes
Room eligibility and inventory allocation required tedious manual intervention.
Limited Visibility
No real-time insights into channel performance and segment mix.
No Data Integration
Revenue decisions lacked real-time data warehouse connectivity.
No Audit Trail
Pricing changes had zero traceability, creating compliance and operational risk.
An end-to-end platform built from scratch
I designed and built a centralized configuration system that replaced fragmented Excel workflows with a production-grade web application.
Rate Plan Configuration
Centralized discount management with segment assignment, LOS restrictions, and commission rules.
Room Eligibility Rules
Visual matrix for room type availability per rate plan with bulk editing.
Channel Hierarchy
Distribution channel management with rollup logic and source attribution.
Segment Classification
Market segment mapping for standardized revenue reporting categories.
Real-Time Sync
Instant data warehouse integration powering downstream analytics.
Forecasting Feeds
Automated data pipelines feeding forecasting models and executive dashboards.
Revenue management concepts, visualized
Deep understanding of hospitality pricing strategy, customer segmentation, and distribution economics.
Market Segments
Customer Categorization
Classification of guests by booking behavior and channel -- Leisure, Corporate, Group, Wholesale, OTA, and more.
Business Value
Enables segment-specific pricing strategies and revenue mix optimization across the property.
System Implementation
Maps property management system segments to standardized categories for executive reporting.
Analytics Use
Powers segment mix analysis, ADR by segment, and RevPAR optimization.
From configuration to insight in real time
Changes made in the UI are instantly available for forecasting and executive reporting. Zero latency between configuration and analytics.
Configuration Platform
User makes pricing change
Real-Time API Sync
Instant propagation
BigQuery Data Warehouse
27 tables updated
Analytics Layer
Forecasting models & pace reports
Executive Dashboards
Revenue KPIs & booking trends
Production-grade capabilities
Every feature was designed to solve a real operational pain point identified through stakeholder interviews and process analysis.
Rate Plan Management
- CRUD operations for discount codes
- Market segment assignment
- LOS restriction configuration
- Commission rules & booking source eligibility
- Active/inactive status toggling
Room Eligibility Matrix
- Visual grid: Rate plans x Property types
- Bulk editing capabilities
- Notes field for business rules
- Audit trail (who changed what, when)
Channel Hierarchy
- Source management interface
- Rollup logic configuration
- Source code standardization
- Active channel tracking
Data Export & Analysis
- One-click CSV exports on all pages
- Custom date range filtering
- Real-time data refresh
- Search and filter capabilities
Real-Time Sync
- Instant BigQuery integration
- Powers downstream analytics
- Feeds forecasting models
- Updates executive dashboards
Four-layer production architecture
Designed for scalability, maintainability, and minimal operational cost.
Frontend Layer
API Layer
Data Layer
Analytics Layer
Measurable results, real outcomes
Every metric reflects actual production data from the live system.
Operational Metrics
150+
Rate plans managed
14
Distribution channels
18
Market segments tracked
2.5M+
Historical booking records
Performance Metrics
99.9%
Platform uptime
<100ms
API response time
Real-time
Data synchronization
Zero
Data loss incidents
Financial Metrics
$1,200
Annual budget approved
$0.01/mo
Infrastructure cost
100%
Excel processes eliminated
Data-driven
Revenue decisions enabled
Analytics Metrics
10-20%
MAPE forecast accuracy
Daily
Automated reporting
Real-time
KPI monitoring
Self-service
Leadership analytics
Problems solved, lessons learned
Real technical obstacles encountered during development and the solutions I engineered.
Large Integer Precision
JavaScript Number type loses precision with INT64 database IDs, causing silent data corruption.
Switched to string-based identifiers for all API operations with strict type validation.
Understanding data type limitations across technology boundaries.
Real-Time Data Sync
Configuration changes needed instant availability in the analytics layer without batch delays.
Direct BigQuery API integration with parameterized queries and event-driven sync.
Zero latency between configuration and reporting.
OAuth Security Implementation
Enterprise access control requirements with domain-restricted authentication.
Google Workspace SSO with domain restrictions ensuring employee-only platform access.
Balancing security requirements with user experience.
Build-Time Environment Variables
Next.js environment variable configuration behaved differently across Vercel environments.
.env.production file with proper Git handling and runtime vs build-time separation.
Infrastructure configuration nuances in serverless deployments.
Skills demonstrated
Technical chops and domain expertise -- not just a developer, but someone who understands the business.
Revenue Management
Data & Analytics
Software Engineering
Business Strategy
What this project delivered
For the Business
- Centralized rate plan management eliminating Excel chaos
- Real-time visibility into pricing strategies
- Full audit trail for all configuration changes
- Self-service analytics reducing data team workload
- Foundation for advanced revenue optimization
For Revenue Management
- Faster time-to-market for new pricing strategies
- Reduced configuration errors
- Data-driven discount recommendations
- Channel performance insights
- Improved forecast accuracy
Technical Achievement
- Production-grade system built from scratch
- Enterprise security and scalability
- 99.9% uptime on minimal budget
- Automated workflows replacing manual processes
- Clean, maintainable codebase
Ready to see it in action?
Explore the live demo platform with sample data. Full CRUD functionality, real-time updates, and every feature demonstrated.
SAMPLE