Allyssa Johnston Email & Phone Number

Vancouver, Bc, Ca

-Identify trends in fraudulent behaviour and implement timely fixes by building heuristic rules which evaluate the risk level of incoming payments -Perform analyses using SQL, Python, and Excel to make data-driven recommendations on new features to build, by identifying gaps in current systems and quantifying the value of new work-Propose, implement, and monitor various A/B tests to measure the impacts of new features -Develop reports and visualizations in Looker to… Show more -Identify trends in fraudulent behaviour and implement timely fixes by building heuristic rules which evaluate the risk level of incoming payments -Perform analyses using SQL, Python, and Excel to make data-driven recommendations on new features to build, by identifying gaps in current systems and quantifying the value of new work-Propose, implement, and monitor various A/B tests to measure the impacts of new features -Develop reports and visualizations in Looker to track performance of risk controls, measure progress on OKRs and other goals, and create alerts on leading and trailing indicators of fraud attacks -Maintain and manage data pipelines and ETLs to ensure quality and correctness of data Show less

Toronto, Ontario, Canada

-As the sole data-focused member of the Marketing and Product teams, I handled all day-to-day tasks to help PMs and marketers use and understand data for each project: testing feasibility, defining success metrics, and identifying trends to ensure each project can be measured with confidence-Used tools such as SQL, R, Python, Google Analytics, and app store analytics to draw insights from large datasets: identifying trends in sales and retention, performing statistical analysis on VPN… Show more -As the sole data-focused member of the Marketing and Product teams, I handled all day-to-day tasks to help PMs and marketers use and understand data for each project: testing feasibility, defining success metrics, and identifying trends to ensure each project can be measured with confidence-Used tools such as SQL, R, Python, Google Analytics, and app store analytics to draw insights from large datasets: identifying trends in sales and retention, performing statistical analysis on VPN performance, and measuring campaign success-Took on PM opportunities by managing my own projects, such as managing the end-of-life process of a product. This involved modelling out refund plans to reduce liability by $500K, recommending go-forward plan based on financial risk and resourcing, and coordinating with members of different teams -Researched pricing strategies and performed pricing experiments to test localized price points, which led to a 10% increase in users in Mexico Show less

Toronto, Ontario, Canada

Toronto, Ontario, Canada

-Handled ad-hoc requests for database design updates, such as adding data collection points, improving current processes for a better end-user experience, and to ensure data storage methods followed the ethical protocols per the Research Ethics Board-Led the development and distribution a research data package, which involved the verification and cleaning of 150+ records with 3 years of data collection and was used by doctors worldwide in their respective studies-Played a major… Show more -Handled ad-hoc requests for database design updates, such as adding data collection points, improving current processes for a better end-user experience, and to ensure data storage methods followed the ethical protocols per the Research Ethics Board-Led the development and distribution a research data package, which involved the verification and cleaning of 150+ records with 3 years of data collection and was used by doctors worldwide in their respective studies-Played a major part in the migration of all Stroke Program research data from multiple sources into one REDCap (Research Electronic Data Capture) database, by mapping data for over 6000 international patients, coordinating with doctors to handle unmatched data points, and thoroughly documenting the process Show less

Cambridge, Ontario, Canada

-Managed all personal expenses for Managing Directors, all business expenses, and reviewed and tracked all employee expenses-Created project and departmental budgets for the upcoming year based on historical data and resourcing-Worked alongside Executive Assistant in planning internal team building events, organizing international travel for employees, and resolving Human Resources conflicts