Client Management
Registration, service tracking, and billing.
SaaS
ISP Management System
Every cable, every ONU, every technician — tracked in real-time across every branch. The full-stack ISP operations brain that replaced 14 spreadsheets and 3 WhatsApp groups.
6+
Equipment categories tracked
2
User roles (Admin/Manager)
Multi-branch
Branch isolation
Screenshots
Overview
Production-running operational platform for a multi-branch Internet Service Provider — clients, staff, branches, networking equipment, daily distributions, team assignments, audit logs. Multi-role, multi-branch, full audit trail. Deployed via Docker, used live by field teams every day.
The Challenge
An ISP loses money in two places: equipment that walks out the back door, and customer issues that take three days to resolve because nobody knows who has what. Spreadsheets can't track cable reels across 5 branches. WhatsApp groups can't show who installed which ONU. The result: cash bleeds, customers churn, and the manager spends Sunday counting inventory by hand.
The Solution
I built a Next.js + Prisma + MySQL system with role-based access (Admin, Manager, Technician), branch-level data isolation, real-time stock tracking for every equipment type (ONU, cable reels, patch cords, switches, splitters, adapters, tie clips), team-cable assignment workflows, equipment transfer between branches, and a complete audit log. 22+ migrations, deployed with Docker + Nginx, running in production today.
Tech Stack
Frontend
Next.jsTypeScriptTailwind CSSRadix UIReact Hook FormZod
Backend
Next.js API routesPrisma ORM
Database
MySQL
Auth
JWT with RBAC (Admin/Manager roles)
Testing
JestPlaywright e2e
Deployment
DockerNginx
Key Features
Branch Management
Multi-branch operations with branch-level data isolation.
Team Management
Staff assignment and team coordination.
Stock/Inventory Tracking
ONU devices, cable reels, patch cords, switches, splitters, and adapters.
Team Stock Assignments
Equipment allocation per team.
Asset Tracking with Audit Logs
Full audit trail for all stock movements.
Role-Based Access
Admin and Manager roles with branch-level control.
Dashboard Views
Separate admin and manager dashboard perspectives.
Map View
Geographic visualization of branches and assets.
Reports & Analytics
Operational reporting and data analytics.
My Role
Full-Stack Developer
Full-stack development—designed the database schema, implemented API routes with Prisma, built the frontend dashboard, set up role-based access control, and deployed with Docker.
Results & Impact
- Eliminated spreadsheet-based inventory tracking
- Real-time stock visibility across all branches
- Role-based access ensuring branch-level data security
- Comprehensive audit trail for all stock movements
- Deployed and running in production with Docker