SpotSpace

My Contributions

• Architected modular backend services using NestJS 11 and Prisma ORM with PostgreSQL database
• Implemented proximity-based space discovery utilizing the Haversine formula and Google Geocoding API to calculate distance directly on the server with minimal latency
• Integrated Midtrans Payment Gateway (Snap & Webhooks) secured with SHA-512 signature hash validation and transactional state machine handling
• Engineered a dual-action dynamic QR Code ticketing system enabling camera-based Check-In and Check-Out with native Web Audio API acoustic feedback
• Built automated background cron tasks (@nestjs/schedule) to handle automated session checkout and release expired reservations
• Developed automated financial report generation pipelines exporting monthly summaries to PDF (PDFKit) and Excel (ExcelJS)
• Implemented JWT multi-role authentication (Member & Space Admin) with route guards and Google OAuth 2.0 integration
• Built responsive client interface using Next.js 16, React 19, Tailwind CSS v4, and Radix/shadcn UI primitives
• Containerized multi-tier stack (Frontend, Backend, PostgreSQL) using Docker Compose and deployed to GCP Compute Engine behind Nginx reverse proxy with Let's Encrypt SSL

Key Features

• Proximity-based space discovery with Haversine distance calculation
• Real-time space availability checking and overlap prevention
• Midtrans multi-channel payment gateway (QRIS, VA, e-Wallet)
• Secure webhook processing with SHA-512 signature verification
• Dual-action QR code digital e-ticket (Check-In & Check-Out)
• Automated background checkout scheduler (Cron)
• Role-based access control (Member & Coworking Admin)
• Review and rating system with official admin replies
• Financial reporting engine with PDF and Excel spreadsheet export
• Production deployment on GCP VM with Docker, Nginx, and HTTPS

Tech Stack