Full Stack

My AMS Connect - Application Management System

A full-stack system to manage student applications from submission to automated document generation and interview scheduling.

Application Management

Automated Letters

Interview Scheduling

MySQL

Nest.js

React

Live Demo

0:00 / 0:00

Project Overview

This was a freelance project built for a France-focused consultancy to handle a rapidly growing number of student applications. The platform streamlines the entire workflow from application submission to automated generation of offer letters, COE/AOE documents, interview scheduling, and extension letters based on existing templates.

I led the backend development using Nest.js, Prisma, and MySQL, deployed on a Namecheap VPS with DNS configuration. I also worked on frontend UI fixes and real-time API integrations using React Query Client. The frontend was co-built with Rupesh Thapa, who collaborated with me on UI development and integration.

This project significantly reduced manual effort for the consultancy, centralizing all processes and ensuring accuracy, speed, and consistency across hundreds of student applications.

Key Features

Core functionality and capabilities that make this project stand out

End-to-End Application Workflow

Handles the complete process from student application submission to review, offer letters, COE/AOE issuance, and extensions.

Interview Scheduling

Enables institutions to schedule and manage interviews directly from the application dashboard.

Automated PDF Generation

Generates offer letters, confirmation of enrolment (COE), accommodation letters, and extensions using existing templates with student and institution data.

Multi-role Access

Supports students, agents, institution staff, and admins with tailored permissions and dashboards.

Robust Data Management

MySQL database with Prisma ORM ensures structured data handling and maintainability.

Real-time Updates

Integrated React Query client for instant UI state syncing and status updates across the platform.

Technology Stack

Key Technologies I Used on This Project

Backend

Nest.jsPrismaTypeScript

Database

MySQL

Frontend

ReactReact QueryTailwind CSSshadcn/ui

PDF Generation

pdf-lib

Deployment

Namecheap (DNS)VPS

Challenges Overcome

• Designing a flexible PDF template system to automatically populate offer letters and confirmation documents with dynamic student data.

• Managing complex status transitions and permissions across students, agents, and institution staff.

• Maintaining real-time state synchronization between frontend and backend during application reviews and document generation.

Key Learnings

• Gained deep experience building scalable, production-ready systems with Nest.js, Prisma, and MySQL.

• Learned how to design dynamic PDF generation workflows integrated into a live application system.

• Improved collaboration skills by co-building with another developer Rupesh Thapa and managing frontend integration tasks.

Interested in This Project?

This project showcases practical development skills and problem-solving experience. Explore the features, review the implementation, or get in touch to discuss similar work.

Get in Touch