Colleen Farrand Email & Phone Number

Toronto, Ontario, Canada

Montreal, Quebec, Canada

• Prepared, executed, and analyzed monthly company-wide phishing emails test campaigns.• Led education workshops on how to identify and report phishing emails.• Refactored the security incidents database for resolved entries and improved risk labelling.

Toronto, Ontario, Canada

• Processed, using Python and Excel, geographic data of infrastructure projects for addition to Ontario Builds’ interactive map.• Collaborated with stakeholders for resolving data discrepancies in infrastructure costs reporting to ensure high quality data for future analysis.• Conducted preliminary analysis of future infrastructure repair costs.

• Cleaned, organized, and analysed co-op student survey data ready for publication on Waterloo’s co-op information page.• Conceptualized and conducted, using R and Excel, an analysis of student experience when returning to past co-op employers.• Presented findings and conclusions of the analysis to the department at the end of the work term.

Waterloo, Ontario, Canada

• Produced R generated map diagrams of COVID cases in Ontario for a research paper on efficient distribution of PPE to hospitals.• Assisted PhD student’s research into optimizing locations of pharmacies in rural areas.• Generated maps of populations’ access to pharmacies using Canadian census data and publicly listed pharmacy locations.

Burlington, Ontario, Canada

• Constructed a data pipeline, using MuleSoft and SQLite, of BlackBerry Radar data on delivery trucks to a database.• Wrote documentation for the NetSuite and AWS components of a client tracking system.

Mississauga, Ontario, Canada

• Built, using Groovy, a server log tracking system, and displayed the data’s results and insights on custom R Shiny webapp.• Efficiently wrote complete test suite for criterial R library used in a clinical trial which needed testing verification at short notice.• Presented the use and benefits of using test coverage metrics in a weekly departmental knowledge sharing lecture.