How a national employment programme moved from scattered spreadsheets to one system of record for 100,000+ fellows across all six geopolitical zones.
A national employment programme needed to manage over one hundred thousand fellows placed with host organizations across all six of Nigeria’s geopolitical zones. Records lived in disconnected spreadsheets: onboarding was manual, placement and clearance status was hard to verify, and producing reliable numbers for programme leadership meant days of reconciliation.
At national scale, spreadsheet-driven administration had become a risk to the programme itself.
Unique programme IDs, placement history, host organization, zone, and clearance status in one place.
Status tracking from onboarding through placement to clearance, replacing email-and-spreadsheet chains.
Cohort-level imports and updates from Excel/CSV with dry-run validation that previews every change before it commits.
Live analytics by zone, cohort, and placement status; exports to Excel and PDF for programme reporting.
Automated backup and restore, invitation-based user onboarding, and role-based access.
Tools & methods: Next.js · React · PostgreSQL · Prisma · Dashboards & analytics · Excel/PDF export
Client name withheld for confidentiality — references available on request.
“From scattered spreadsheets to one national system of record.”