College ERP
Admissions, fees and student records for colleges that ran on spreadsheets.
- Client
- Royal Cards Infotech
- Through
- Techindika
- Role
- Full-stack developer
- Focus
- Frontend, in a team
- Timeline
- Sep 2024 to May 2025
- Code
- PRJ-03 · 2025
The problem
The colleges using this system had admissions on spreadsheets, fees in ledgers and certificates typed by hand. Parents had no visibility, departments had no boundaries, and compliance reports were assembled manually every term.
Carrying data from one academic session to the next was the most error-prone task of the year.
The build
We built it with twelve staff roles, each with a scoped view of the system. Admissions run through a structured multi-step form with Razorpay and PhonePe payments and automatic merit list generation.
Fees are configured per course and per session, with outstanding balances tracked per student in PostgreSQL through Prisma. Certificates are generated in bulk from templates or live data, and every admin action lands in an audit log.
The application uses a microfrontend architecture so modules can ship independently. Reusable table components handle thousands of student records without the page slowing down.
Scope
- Multi-step admission flow
- Razorpay and PhonePe payments
- Merit list generation
- Dynamic form builder
- Fee configuration per session
- Outstanding fee tracking
- Bulk certificate generation
- Certificate verification
- Twelve scoped staff roles
- Admin audit logs
- MIS and compliance reports
- Parent portal
Stack
- Next.js
- React
- TypeScript
- Microfrontends
- Prisma
- PostgreSQL
- PM2
- Swagger