Blenheim Youth Centre
Data & Software Developer
- Replaced paper sign-in for 100+ youth, identified a missing member database, built and installed an on-site React kiosk on PostgreSQL, set up RLS to hide personal data of the youth from the terminal, and shifted hours of manual transcription to one-click Excel exports.
- Restructured a non-profit's Excel-based data systems, auditing and repairing 15 years of inconsistent membership, attendance, and donor records, and building Power BI dashboards connected directly to the kiosk database, replacing manual spreadsheets for non-technical stakeholders.
- Within a 6-person team handing off to non-technical staff, set up the organization's newsletter email system, documented and trained staff to run the kiosk and Power BI dashboards independently with team feedback throughout, so staff can operate every tool with minimal maintenance.
- Dates:
- May 2026 – Aug. 2026
- Location:
- Waterloo, ON
- Tech:
- React, PostgreSQL, Power BI, Excel