Ladies Let's Talk: EPP Volunteer Matching
Client-facing capstone project where I led project management, solution architecture, and development to automate the matching process for a program serving more than 1,600 learners and 900+ volunteers.
- Roles
- Project Manager, Solutions Architect, Lead Developer
- Stack
- Airtable, JavaScript, Automation Scripts, Trello, Slack
Project Goal
The English Practice Partners (EPP) program pairs immigrant and refugee women with volunteer English-speaking partners. Before this project, the entire process was done manually in Google Sheets across hundreds of participants per cohort.
Our goal was to build a scalable, automated system capable of reliably matching large cohorts (150–250 participants each cycle) while reducing coordinator workload and eliminating manual matching errors.
Key Metrics
Core Features
- • Three Matching Algorithms: Preferred Partner, Randomized, and Location/Availability-Based
- • Automated Email Workflows: 400+ templated emails per cohort
- • ERD with 5 major tables and 200+ linked fields
- • Dashboard Interfaces: Match progress, unmatched users, and key metrics
- • Archival Scripts: Preserve match records into master tables
Impact
- • Reduced matching time from hours of manual work to under 60 seconds
- • Eliminated hundreds of manual data-entry errors
- • Enabled LLT to run large-scale cohorts without external developer support
- • Created a scalable model supporting 500+ matches per cycle
Note: Scripts, documentation, and project materials are not publicly available due to client confidentiality.