# Golden Sea Hotel Management System

> Client: Golden Sea Hotel | Industry: service-hospitality | Duration: 16 weeks | Canonical URL: https://yariinfotech.com/work/hotel

## Executive Summary
A complete digital system for managing hotel operations, bookings, inventory, and financial reporting.

## The Challenge
Golden Sea Hotel's legacy booking system made room allocation, billing, and financial reconciliation slow and largely manual. Staff spent hours on repetitive tasks, errors were common, and guests experienced long check-in times.

## The Solution
We built a real-time, high-performance management platform that unified room, hall, and guest management with smart booking, automated billing, reporting, and inventory tracking. Modern UI, offline-capable, and integrated payments.

## Results & Measured Impact
Cut administrative overhead by 60%, sped up guest check-ins by 4x, and reduced billing errors to near zero. The system now supports 3x more bookings without added staff.

### Key Performance Metrics
- **Admin time**: −60%
- **Check-in speed**: 4× faster
- **Delivery**: 16 weeks

## Core Architectural Constraints
- Sub-second check-in processing over spotty hotel Wi-Fi networks
- Zero concurrency race conditions on suite allocation during peak arrival windows
- Local offline-first capability for front-desk terminals during broadband outages

## Initial Bottleneck & Diagnosis
Early prototypes relied on standard REST polling for room allocations, creating race conditions when multiple receptionists attempted to check in guests to the same suite simultaneously.

## Key Engineering Decisions & Trade-offs
### Decision 1: Migrated state synchronization to Convex reactive subscriptions
- **Rationale**: Guaranteed transactional atomic mutations on room inventory with automatic optimistic UI updates across all terminals.
- **Engineering Trade-off**: Required deeper client state integration compared to generic REST endpoints.

### Decision 2: Implemented local IndexedDB persistence for offline resilience
- **Rationale**: Allowed staff to check in guests and queue billing transactions during connectivity interruptions.
- **Engineering Trade-off**: Added synchronization conflict resolution logic when terminals re-established uplink.

## Engineering Retrospective
"Prioritizing offline-first local persistence from the first sprint protected operations when the hotel experienced a four-hour ISP outage during high season."

## Technologies Used
Qwik, Convex, TypeScript, Tailwind