Next.jsTypeScriptTailwind CSSDrizzle ORMPostgreSQLSaaSMulti-TenantReact NativeExpoBetter Auth

Case Study

Redeemos School System— Enterprise multi-tenant School Management SaaS

One platform to run every operational layer of a school — from admissions to payroll.

Industry

EdTech / SaaS

Project Type

Full-Stack Web + Mobile Application

Timeline

Ongoing

Role

Full-Stack Developer

Project Overview

Overview

Redeemos is an enterprise-grade multi-tenant school management SaaS built for schools across Africa and emerging markets. The platform centralizes school operations into one unified system, replacing paper-based processes and disconnected tools with a secure cloud-based solution for administrators, teachers, students, parents, and staff.

The Problem

Many schools rely on manual processes and fragmented systems that create inefficiencies, poor visibility, and operational challenges.

Paper-based attendance, grading, and fee tracking

Disconnected tools with no centralized data system

Limited visibility for parents into student performance and finances

Manual financial processing causing accounting errors

Weak role-based access control and data security

Difficulty managing multiple campuses and departments efficiently

Impact — The absence of a unified, secure school management system meant schools were burning administrative hours on manual processes, leaking revenue through untracked fees, exposing sensitive data without access controls, and offering parents zero transparency — directly undermining trust and retention at every institution.

The Solution

Built a multi-tenant school management platform that unifies academics, finance, HR, communication, and administration into a single cloud-based ecosystem.

Developed a centralized school operations platform

Implemented isolated databases for each school tenant

Built dedicated portals for all stakeholder groups

Integrated real-time communication and notifications

Automated finance, attendance, and reporting workflows

Added companion mobile application support

The system was structured to ensure performance, scalability, and ease of use.

Features

Key Features

Student Information System (SIS)

Full student lifecycle management including admissions, profiles, documents, class promotion, and alumni tracking.

Academics and Timetable Management

Manage departments, classes, subjects, academic years, and terms. Build and manage timetables with clash detection.

Attendance Tracking

Mark attendance with QR code and biometric device support. Automated absence alerts sent to parents via SMS or email.

Examination and Report Card Management

Schedule exams, enter grades, configure grade scales, publish results, and generate printable report cards.

Finance and Online Fee Payment

Auto-generate student invoices, accept online payments via Paystack, manage scholarships and refunds, and export financial statements.

HR and Payroll Management

Manage staff profiles, leave requests, payroll runs, and staff attendance with auditable reports.

Real-Time Messaging and Announcements

School-wide announcements, bulk SMS broadcast, and Pusher-powered real-time chat with typing indicators and read receipts.

Library, Transport, Hostel, and Canteen Modules

Dedicated modules for book loans, vehicle routes, boarding room allocations, and canteen digital wallet management.

Multi-Level Role-Based Access Control

Three-layer RBAC enforcement across middleware, client UI, and API routes with 8 system roles and 60+ granular permission nodes.

Data Export and Reporting Tools

One-click export of any data domain to CSV, XLSX, or PDF, streamed from API routes with proper attachment headers.

Progressive Mobile App with Offline Support

React Native mobile app for students, parents, and teachers with offline-first caching, secure auth storage, and real-time push notifications.

Tech Stack

Technologies Used

Frontend

Next.jsReactTypeScriptTailwind CSSshadcn/uiTanStack Query

Backend

Next.js API RoutesPostgreSQLDrizzle ORMBetter Auth

Database & Services

VercelNeon PostgreSQLCloudflare R2Upstash Redis

Integrations

PaystackPusherSMS GatewayNodemailerResend - Email integration

Results & Impact

The system delivered measurable improvements across key areas.

Unified 20+ school management modules into one platform

Fully automated school onboarding and provisioning

Secure multi-tenant architecture with isolated databases

Real-time communication and operational workflows

Mobile application with offline support

Streamlined school administration, finance, and reporting processes

Challenges

Challenges & How I Solved Them

ChallengeMulti-Tenant Data Isolation

SolutionImplemented a database-per-tenant architecture to ensure complete data separation and security for every school.

ChallengeRole-Based Access Control

SolutionBuilt a three-layer RBAC system enforcing permissions across middleware, UI, and API routes.

ChallengeOffline Mobile Accessibility

SolutionDesigned the mobile app to function reliably in low-connectivity environments using offline-first caching.

ChallengeUnified Data Export System

SolutionCreated centralized export tools supporting CSV, XLSX, and PDF downloads across all modules.

ChallengeAutomated School Provisioning

SolutionAutomated tenant setup, database migrations, and configuration during school onboarding.

Key Insights

This project reinforced important principles that shape how I approach every build.

Built with Next.js, TypeScript, PostgreSQL, and Drizzle ORM

Multi-tenant database-per-school architecture

Real-time communication powered by Pusher

Integrated Paystack for online payments

Implemented secure authentication and RBAC

Built React Native mobile app with offline-first support

Automated school provisioning and database setup

Visual Showcase

Interface & Screens

hero-light

View full

Let's Work Together

Want a System Like This?

If you're looking to build a similar solution or improve your current system, I can help you design and develop it.

Start a Project Contact Me