A nightly reporting pipeline for school administrators
Target PEAK · Node.js microservices · daily reports for every level of a school system, from district down to class
- Problem
- Daily reports were generated once per user, even though everyone under the same part of the hierarchy saw identical content. Administrators also wanted Excel, not only PDF, and the reports had to reach them on WhatsApp.
- What I did
- Redesigned generation to run once per hierarchy scope instead of once per user. Added Excel (xlsx) output that shares one view model with the existing PDF path, and proved the PDF output stayed byte-identical across 13,830 test renders before changing the live path. Put generation and sending behind per-organization feature switches.
- Delivery
- One Excel file per scope (two sheets), sent each morning as a download link in a WhatsApp template through Wati. I chose a link over an attachment or an interactive flow so each delivery costs a single template message under WhatsApp's 2026 pricing.
- Result
- 11,000+ reports generated and stored in S3 in a single run.