Sangguniang Kabataan Management System
A web and mobile governance platform used by the Sangguniang Kabataan of Barangay Batong Malake, Los Baños, to plan programs, manage public funds, and publish transparency reports for its youth.
- Role
- Lead Full-Stack Developer
- Client
- SK of Brgy. Batong Malake, Los Baños, Laguna
- Engagement
- Laguna University capstone project
- Platforms
- Web portal, admin system, Android app
- Status
- Live, in daily use by the SK council
Sanggu is the digital governance platform of the Sangguniang Kabataan (SK) of Barangay Batong Malake, Los Baños, Laguna. It replaces paper-based planning, manual bookkeeping, and scattered social-media announcements with a single system that covers the council's full cycle of work: from the Comprehensive Barangay Youth Development Plan (CBYDP) and Annual Barangay Youth Investment Program (ABYIP), to program implementation, disbursement, and public reporting.
The platform has three parts. A public transparency portal lets any resident view programs, events, resolutions, and financial disclosures prepared in line with the DILG SK Full Public Disclosure Policy and COA guidelines. A secured administration system serves SK officials in managing budgets, sessions, resolutions, programs, and youth records. A companion Android app, published on Google Play, lets the youth receive announcements, register for programs, and complete their Katipunan ng Kabataan profile.
I served as the lead full-stack developer of our Laguna University capstone team. I was responsible for the system architecture, the backend and frontend of the web platform, the mobile application, and the complete DevOps pipeline that keeps the system running in production.
Architecture & backend
- Designed the domain model and database schema for plans (CBYDP and ABYIP), programs and their implementations, budgets, vouchers, payroll, cash receipts, sessions, resolutions, and youth profiling.
- Built the Laravel backend with role-based access for SK officials and residents, activity and authentication logging, and secure document and media storage.
- Implemented budget-versus-actual tracking, cash-flow ledgers, and fiscal rules from RA 10742, so the council can see available cash, utilization per program, and remaining appropriations in real time.
- Generated official COA- and DILG-compliant financial disclosure reports (budget allocation and utilization, register of cash in bank, statement of receipts and payments, and others) as downloadable PDFs and spreadsheets.
- Integrated AI-assisted features through Laravel AI, including guarded content generation for program requirements and template design.
Web frontend
- Built the public transparency portal and the administration system with Livewire, Alpine.js, and Tailwind CSS, including a plan-overview workflow, an events calendar, a rich-text announcement editor, and QR-based event check-in.
- Added passkey sign-in, real-time notifications over Laravel Reverb, and a responsive layout that works on the phones most residents use.
Mobile application
- Developed the resident Android app with React Native, Expo, and TypeScript: onboarding, announcements, program registration, events, and Katipunan ng Kabataan profiling.
- Implemented push notifications through Firebase Cloud Messaging, passkey authentication, and map-based features, and published the app on Google Play alongside a direct download from the website.
DevOps & production
- Containerized the application with Docker, running PHP-FPM, nginx, queue workers, the scheduler, and Reverb under Supervisor, with MySQL 8.4 and Redis behind a Traefik reverse proxy on a VPS.
- Built CI/CD with GitHub Actions: automated tests on every push, production images published to GitHub Container Registry, and zero-touch deployment to the server through Watchtower.
- Automated Android release builds (APK and AAB) on a self-hosted runner, cutting build time from about 36 minutes to about 3 minutes.
