Chand Study Platform
REST API backend for an ed-tech platform: courses, lectures, enrollments, and a test engine with sections, negative marking, and Excel question import — on Node.js, Express, and MySQL.
The project
The Chand Study Platform is an online learning product built by a five-member team, where I was the backend engineer — the API repository's 78 commits across August and September 2023 are all mine. The API is Node.js and Express over MySQL with Sequelize, spanning eleven models from users and courses to tests, sections, questions, and results.
The core is a test engine: admins compose tests into sections of questions with per-section marks and negative marking, students attempt and save progress, and the API evaluates answers, applies negative marks per section, and totals the score. A question library supports importing questions in bulk from Excel files.
Authentication covers admins and students with JWT sessions — register and login by email or mobile number, verified through OTP sent by Nodemailer and Twilio. Around that sit the course catalogue endpoints (popular, featured, recently added, free, banner, category filters), a lecture library with uploads, enrollments, reporting, and blocked-student management behind role-based access.
What I owned
Backend developer on a five-member team — engineered the platform's entire REST API.
What I built
- Engineered the complete REST API as the team's backend engineer — 78 commits over August–September 2023
- Test engine: tests composed of sections and questions, per-section marks and negative marking, with attempt, save, and evaluation endpoints
- Bulk question import from Excel files into the question library
- JWT auth for admins and students — email and mobile login with OTP verification via Nodemailer and Twilio
- Course catalogue APIs: popular, featured, recently added, free, banner, and category filtering
- Lecture library with file-upload middleware
- Enrollments, reports, and blocked-student management behind role-based access
- Eleven Sequelize models over MySQL with express-validator and Joi validation