Smoking Cessation Pharmacist App
A secure web app that pharmacists use to record each participant in one of the few social impact bonds in Canada, where repayment to investors depends on measured outcomes.
- MySQL
The problem
The bond funds pharmacist-delivered support for Manitobans who have tried unsuccessfully to quit smoking. Qatalyst is evaluating it, and because investors are repaid based on measured outcomes, every participant’s record has to be complete and reliable.
What I built
- Participant records for every stage: readiness to quit, the initial assessment and quit plan, prescriptions and quitting aids, and follow-up support.
- Weekly reminders that email each pharmacist the follow-ups they have due.
- Monthly reporting. I later connected the participant surveys to Qatalyst’s internal platform for monthly progress reports.
Under the hood
A secure web application on a MySQL database. I was responsible for the database design, the pharmacist app, data security and reporting.








