Thapar Hostel Management System

A robust records, leave, and attendance management system tailored for university dormitories, ensuring secure and automated workflow processing.

Key Highlights & Features:

• Rest API Development: Built a REST API using Node.js, Express.js, Prisma, and PostgreSQL to manage student accounts, leave approvals, attendance logs, and CSV reports. Verified with Postman test suites.
• Relational Databases & Auth: Designed complex relational schemas with atomic updates, implementing secure JWT authentication with flexible header and query fallback strategies.
• Automated CI/CD: Set up an automated CI/CD pipeline using GitHub Actions deploying the Node.js backend to AWS EC2 (managed with PM2, Nginx reverse proxy, and SSL via Certbot) and frontend hosting on Vercel.