ET GCO TOURS

• Architected a fully type-safe, decoupled Next.js 15 + Express + TypeScript application powering a complete tour booking platform with unique booking codes, customer management, and real-time inventory.
• Designed and implemented a normalized PostgreSQL schema with Drizzle ORM, strategic indexes, migrations, and connection pooling for production-scale traffic.
• Delivered LCP < 2.5s and Lighthouse scores of 100 SEO / 81 Performance / 98 Accessibility through Redis caching, SSR/SSG, and Gzip.
• Built an accessible, mobile-first interface using Radix UI components, enhanced with GSAP, Framer Motion, and Tailwind CSS.
• Managed end-to-end deployment: front-end on Vercel, back-end migrated from Oracle Cloud to DigitalOcean Droplet with reverse proxy, custom domains, and strict SSL/TLS.
• Implemented enterprise security (rate limiting, CSRF, SQL injection prevention, Express Validator, unit testing) and multi-language support with automatic browser detection.

link demo project : https://www.twine.net/signin