Back to Portfolio
Desktop


Mobile
CLIENTHospitality / OTA•2024
COZINN
Full-stack OTA booking platform with 28 database models, role-based admin dashboard, and Razorpay payment processing, live on Vercel with PostgreSQL.
View Live Site28
Database Models
Full relational data architecture
40+
API Routes
Production-grade endpoints
60-70%
Load Time Reduction
Achievable via performance audit
Live
Platform Status
Production on Vercel + PostgreSQL
Desktop



The Challenge
Build a complete online travel agency (OTA) platform from scratch — property listings, booking requests, payment processing, owner management, and admin dashboard with role-based access control.
The Approach
Developed a production-grade Next.js application with Prisma ORM on PostgreSQL, implementing a multi-role architecture (Guest, Owner, Admin) with 28 database models. Integrated Razorpay for payments, built a comprehensive admin dashboard with 40+ route handlers, and conducted a performance audit identifying 47 optimization opportunities.
What We Built
- →Full-stack OTA platform (Next.js 16 App Router, TypeScript)
- →28 database models with Prisma ORM (PostgreSQL)
- →Role-based access control (Guest, Owner, Admin)
- →Property management system (listings, units, bedrooms, amenities)
- →Booking request flow with status tracking
- →Razorpay payment integration
- →Admin dashboard (properties, bookings, users, analytics)
- →Performance audit identifying 47 issues with optimization roadmap
- →Google Ads + GA4 analytics setup
- →Responsive design with mobile-first approach
Technology
Next.js 16TypeScriptPostgreSQLPrisma ORMRazorpayTailwind CSSVercelJWTResendZustandRecharts
Results
28
database Models
40+
api Routes
3 (Guest, Owner, Admin)
admin Roles
47
performance Issues Found
60-70%
estimated Load Time Reduction
