An enterprise hotel equipment rental management system designed to prevent inventory shrinkage, reconcile multi-stage returns, and protect billing accuracy across commercial hospitality rentals.
Commercial hospitality rentals move equipment through quotations, dispatches, staged returns, inspections, claims, and payments. HERMS needed to connect those operations without allowing field submissions, pricing changes, or incomplete returns to create silent stock and billing discrepancies.
HERMS delivers an auditable operational system in which stock movements require verified physical counts, returns reconcile against delivered quantities, historical prices remain immutable, and management can monitor utilization, revenue, approvals, claims, and ledger activity in real time.
The quotation-to-order workflow supports both catalogue pricing and authorized custom overrides. Once confirmed, every line price is locked so later catalogue changes cannot alter the value of an existing contract or historical invoice.
Field submissions never change stock directly. A Store Admin must verify physical counts before an atomic database transaction records the movement. Multi-stage returns remain open until returned, outstanding, missing, and damaged quantities reconcile exactly with the quantity originally delivered.
Field crews can complete scoped checklists through expiring SHA-256 link tokens without signing in, reducing dispatch friction while limiting access. Damage claims use immutable price history from the recorded date of loss, and every monetary calculation is performed in integer cents before Finance verification.
The full-stack monorepo uses Bun workspaces, TanStack Start with React, Hono.js, and Drizzle ORM. Hono runs on AWS Lambda Function URLs behind a same-origin Nginx proxy, while the Neon PostgreSQL HTTP driver avoids connection-pool exhaustion and database triggers prevent changes to audit and stock ledgers.
An idempotent semi-annual scheduler applies ten-percent price escalations without changing historical invoices. The executive dashboard brings asset utilization, revenue, pending approvals, discrepancies, and exportable audit records into one real-time operational view.
HERMS demonstrates how strict business rules can be translated into a practical interface without weakening operational controls. The project treats inventory, pricing, claims, and audit history as connected financial records, creating a system that remains reliable as equipment moves between warehouse staff, field crews, customers, and Finance.
I learned to model multi-stage rental returns around explicit reconciliation invariants rather than relying on loosely connected status updates.
I strengthened my approach to secure passwordless workflows by combining narrow permissions, expiring tokens, and approval boundaries.
I gained deeper experience with serverless database access, immutable ledgers, idempotent schedulers, and precise financial calculations.
