LMSV Portal

Little Minds Strong Values (LMSV) transforms a national education initiative for Rotary International District 3220 from a fragmented system of WhatsApp groups and paperwork into a structured 10-tier digital ecosystem. The platform coordinates a value-enrichment program across Sri Lanka, managing 12 distinct system roles from national directors down to classroom teachers. It handles the entire lifecycle of a national competition—from monthly task submissions with media evidence to an automated points engine that aggregates results across a massive organizational hierarchy.

LMSV is a national-scale education platform built for Rotary International District 3220 (Sri Lanka) to digitize and automate a value-enrichment program for school-going children. The system replaces manual coordination with a single Next.js monolith that manages 10 levels of organizational hierarchy, providing role-scoped dashboards and automated workflows for institution enrollment, task submissions, and competition management.

The core engineering challenge was modeling a complex 10-level hierarchy without the performance overhead of traditional relational junction tables. I implemented a JSONB-powered RBAC system where permission matrices for 13 modules are stored directly on the roles table. This choice allows the system to fetch an entire permission set in a single row and enables instant, global permission updates without requiring schema migrations or re-logins. For data integrity, I designed an append-only points engine. Rather than updating mutable counters, every point awarded is an immutable entry in a ledger, ensuring every leaderboard change is traceable, auditable, and resistant to concurrency issues.

10-Level Hierarchical RBAC: Enforces data isolation at the database level via a scoped query pattern, ensuring teachers and regional admins only ever interact with data within their specific geographic or institutional branch.
Direct-to-Storage Video Pipeline: Engineered a resumable upload path for 500 MB competition videos that bypasses the app server to hit MinIO/S3 directly, including a workflow to automate publishing approved entries via the YouTube Data API.
Hierarchical Analytics & Reporting: Built a role-aware reporting engine that aggregates performance data and generates PDF/XLSX exports, providing national directors with unified regional stats while strictly isolating data for individual schools and zones.
JSONB Permission Matrix: A scalable authorization model that supports 12 system roles and 13 modules, allowing for rapid expansion of the platform's feature set without the need for ALTER TABLE operations.
Append-Only PointLedger: An event-sourced approach to scoring where leaderboards are computed aggregates of an immutable transaction log, providing a perfect audit trail for national competition results.
Resumable Media Pipeline: Implemented chunked video uploads to handle unreliable network conditions in rural regions, ensuring large competition entries can recover from dropped connections.

I manually designed the UI/UX for all three system surfaces—the public marketing site, the authentication flow, and the management portal—then expanded the design system using AI to maintain consistency across hundreds of views. Each surface serves a distinct demographic, requiring high-performance desktop dashboards for national administrators and low-friction mobile interfaces for teachers in regions with varying connectivity.

The system was developed using agentic AI workflows under my structured technical direction, manual verification, and fine-tuning. Currently in Phase 4 of a 9-phase roadmap, the project is transitioning to a production deployment on a self-hosted VPS with integrated AWS S3 media storage.

Tech Stack

Role

Client

Timeline