Holiday Beach Platform
An intelligent digital system — website, mobile app and AI chatbot — unifying 34,000+ reservations scattered across 186 scanned documents.
- OCR
- AI Chatbot
- React Native
- FastAPI
- MySQL
Context
Djerba Holiday Beach managed its reservations in a fragmented way: data was spread across 6 PDF files and 186 scanned documents, with no unified view. This project grew out of a field internship (hotel operations & data) that revealed the scale of the problem: 34,000+ reservations to reconcile.
Problem
Without a central platform, there was no way to track reservations in real time, cross-reference data across channels, or respond quickly to guests — everything relied on scattered paper and scanned documents.
Architecture
- Data pipeline: OCR (i2OCR) on the 186 scanned PDFs → CSV extraction → MySQL loading.
- Web platform: React + TypeScript + TailwindCSS, FastAPI backend, real-time dashboard.
- Mobile app: React Native / Expo, QR-code booking, local SQLite storage synced with MySQL.
- AI chatbot: a Flask microservice connected to an LLM (Google Gemini) with MySQL business context, for 24/7 customer support.
- Deployment: microservices architecture on Netlify (frontend) and Render (backend).
Stack
React, TypeScript, TailwindCSS, React Native/Expo, FastAPI, Flask, MySQL, SQLite, OCR (i2OCR), Google Gemini LLM, Netlify, Render.
Results
- 34,000+ fragmented reservations unified from 186 scanned documents.
- Self-service QR-code booking, without relying on on-site staff.
- 24/7 customer support via the AI chatbot, with direct access to business context.
Screenshots
Screenshots coming soon.