Enterprise Hotel Management & Revenue Intelligence SaaS

Built multi-property revenue intelligence and centralized labor reporting for InnFlow's enterprise hotel management system — with database optimization, timezone-aware aggregation, and API integration for real-time cross-property analytics.

Company Context

A SaaS platform for enterprise hotel groups managing multi-property operations — reservations, billing, labor, and revenue analytics across properties in multiple locations and time zones. Serves hotel operators who need centralized financial and operational visibility across their entire portfolio.

Engineering Environment

.NETSQL ServerStored ProceduresMulti-timezoneRevenue AnalyticsHotel Management

What Our Scale Partnership Revealed

Reporting was built on complex stored procedures processing large reservation and billing datasets — query execution times were degrading as data volume grew, with no indexing strategy in place.
Each hotel property's data was siloed — hotel group operators had to manually consolidate reports from each property with no centralized view.
API token authentication was failing intermittently, causing data synchronization gaps that silently corrupted reporting outputs.
Properties in different time zones were producing timestamps in local time with no normalization — financial reports were inconsistent across the portfolio.
Linked server configuration for centralized data access was broken, blocking cross-property queries entirely.

Engineering Work

Audited all stored procedures and SQL queries — implemented clustered and non-clustered indexes targeted at the highest-frequency reporting queries.
Built a centralized reporting module that aggregates labor and revenue data across all properties into a unified view.
Implemented secure token-based API authentication using .NET — resolved authentication failures and added retry and refresh logic.
Fixed linked server configuration — cross-property data access now works reliably.
Built timezone-aware data handling: all timestamps normalized to UTC at ingestion and converted to property-local time at display.

System Outcome

Reporting performance significantly improved — stored procedure execution time reduced, system load decreased under reporting workloads.
Centralized portfolio reporting live — hotel group operators have unified revenue and labor visibility across all properties for the first time.
API synchronization reliable — no more silent data gaps from authentication failures.
Timezone-consistent data — financial and scheduling reports are accurate across all properties regardless of location.

Engineering Breakdown+

Index Strategy: Used SQL Server execution plan analysis to identify table scans in the highest-frequency stored procedures. Added clustered indexes on reservation date and property ID columns — the primary filter axes for all reporting queries.

Timezone Architecture: UTC normalization at the data ingestion layer — all timestamps stored as UTC regardless of source property. Conversion to local time happens at the API response layer using the property's configured timezone offset.

Token Authentication: Implemented OAuth token refresh flow with automatic retry on 401 — the previous implementation was failing because tokens expired mid-session with no refresh logic.

Scale Partnership

Want to see what we'd uncover in your engineering environment?

Every engagement starts with understanding your actual system constraints.