Skip to content
← All work

Case study 11 / 17

RDS CRM

Tracks every licence application from signup to certificate, in one system.

Market
India
Type
Driving school operations CRM
Services
Web development · UI/UX · Custom LMS

/01

The spark

Raja Driving School runs driving lessons and handles the RTO paperwork around them: learner's licences, driving licences, renewals and commercial badges. That paperwork lived in registers and spreadsheets, with no single view of who owed what or which application was stuck. The school needed one system for intake, applications, payments, invoicing and reporting.

/02

The friction

The business is five workflows running in parallel, each with its own status lifecycle: learner's licences, driving licences, renewals, badge applications and training. One customer can be in several at once. Payments can apply to any of them, so balances and invoices had to reconcile across every service, not a single order table.

/03

The wiring

One Next.js app: server-rendered dashboard pages and an API talking to a single MySQL database, with no separate backend service. Two independent login systems run side by side, one for staff with role and per-module permissions and one for the customer portal, so a problem in one cannot reach the other.

/04

The build

Beyond the core CRM (customers, applications, renewals, training, payments, invoices, expenses and reports), a full learning platform. Staff author courses as a sequence of videos and quiz checkpoints. Uploaded video is transcoded on the server to encrypted streaming and served through short-lived signed links, never a direct file URL. A server-side unlock engine decides what a learner can see next, so there is no client-side rule to bypass. Finishing a course issues a certificate PDF with a QR code that opens a public page where anyone can confirm it is genuine.

/05

Live

Live at crm.rajadrivingschool.com, with the learning module running and its first course published.

/06

What's next

Awaiting details from the team

The follow-up phase.

/ SCREENS

Inside the build.

03 screens

  • RDS CRM customer portal dashboard
    01The customer portal: services, payments and invoices in one place. Demo account.
  • RDS CRM course page in the customer portal
    02A course from the learner's side: what is next and what is locked.
  • RDS CRM public certificate verification page
    03A public page where anyone can confirm a certificate is genuine.

Next project

SS Technical ServicesOne site for 11 licensed trades, with leads going straight to an admin panel.