Bright Mind Enrichment
Data Engineer · pro bono · Aug – Dec 2024 · Austin, TX
- The problem
- A nonprofit's chapters tracked volunteer hours, donations and outreach in a patchwork of spreadsheets and intake forms. Monthly reporting took about twenty hours.
- What I did
- Centralised the data into an OLAP structure and built dashboards connecting Street Care app, volunteer and donation KPIs, so chapter leads pull their own numbers instead of waiting for someone to compile them.
- Results
- Monthly reporting cut from about 20 hours to under 2
- Dashboards for 10+ chapter leads, who now pull their own numbers
- 12,600+ people aided, and every one of them counted