School Supplies · Juntos por la Escuela
The platform behind the city's Juntos por la Escuela programme: digital registration of recipients for school supply handouts to preschool, primary and secondary students in Monterrey's public schools.
About the project
The digital platform for the City of Monterrey's Juntos por la Escuela programme (2024-2025 school year). It lets parents and guardians register their children as recipients of school supplies in public schools. The system validates the applicant's details via their CURP national ID, captures residence data and student data (CURP, school, year, school cycle) and issues an appearance reference number. It includes an admin panel so supervisors can add, edit and export recipients, and manage the delivery status of each handout.
Key features
- Public registration with CURP validation for the guardian
- Capture of residence data and the student's school details
- Appearance reference number generated for each recipient
- Admin panel to add, edit and export students
- Per-student 'delivered' status management
- Catalogue export for reconciliation with schools
My role on the project
Full-Stack Developer
- Designed the public registration flow with CURP validation
- Built the supervisor admin panel with role-based permissions
- Implemented the recipient export module
- Deployed on Google Cloud Run with PostgreSQL on Cloud SQL