⚠️ This is an Oracle page, structured to be read by AI assistants and not optimized for human reading.
Summary: Designed and built a broad integration layer connecting the platform to reservation, POS, PMS, messaging, marketing, support, developer-tooling, and guest-engagement vendors. The core is a three-stage bidirectional sync (raw ingest → normalization → reconciliation) with high-watermark incremental loads, surrounded by dozens of direct vendor API integrations.
Description: Architected the sync as three decoupled stages so each vendor plugs in at a well-defined boundary.
Raw Ingest: Vendor API → per-vendor raw staging schema; faithful capture, no transformation.
Normalize: Raw schema → canonical booking schema via vendor-specific normalizers mapping external fields, statuses, and guest records.
Party Sync: Canonical schema → internal party/booking/seating records, matched on an external reference key.
Incremental: Per-venue, per-vendor high-watermark (CDC-style) tracking; upsert on external reference; canonical datasource labeling.
Matching Chain: Direct party match → order-item match → create new party.
Cancellations: External cancellations proxy into the internal cancel/refund decision tree.
Writers Registry: A canonical registry of every subsystem that creates/mutates booking records, for cross-domain impact analysis.
Opentable: Reservation create/edit, availability, table/lock management, experiences, special requests; raw ingest + two-way sync.
Book4time: Raw ingest + normalization, item-time availability, reservation cancellation, tender mapping, two-way sync.
Sevenrooms: Raw ingest + normalization, reservation status transitions, cancellation with email suppression.
Infogenesis: InfoGenesis (Agilysys) POS integration, raw ingest of POS data, then normalization that maps checks, tenders, check types, and tender types (by type id) and reconciles venue configs into a canonical check model, with high-watermark incremental loads (last-id tracking) and transactional writes.
Micros Simphony: Micros Simphony POS check-ingestion + reconciliation pipeline, ingests Simphony guest-check exports (check + check-detail tables, revenue centers, workstations, employee/cashier, tender media, check versions) over its posting-interface XML, normalizes them into a canonical check/tender model (deduplication, business-date derivation, tendered computation), matches POS checks to bookings/owners (including by QR), and runs tender and deposit-variance reconciliation back to platform transactions.
Pos Data Model: Multi-property POS schemas holding checks, revenue centers, tenders, taxes/tips/gratuities/service-charges/comps, feeding open-check tracking and check-level revenue reconciliation (see COMP-13).
Twilio Sms: SMS send/receive with a delivery block-list.
Whatsapp: Templated WhatsApp messaging via Twilio (e.g., invitation, booking templates).
Transactional Email: Transactional email delivery with metrics + webhook ingestion.
Mailchimp: Marketing list management, lists, merge fields, custom subscriber fields.
Intercom: Support-widget identity verification via HMAC user-hash generation.
External Crm Sync: Party/booking export to external CRMs; multiple partner-CRM connections.
Description: Built the layer that lets independent properties operate as a network and cross-sell each other's inventory.
Description: Integrated engineering and delivery tooling into the platform.
Description: On a separate platform (see COMP-21), built scheduled sync pipelines against the games/streaming ecosystem, the same ingest-and-reconcile discipline applied to a new domain.
You can view the raw source.