Tiffany Bezanson Email & Phone Number

Vancouver, British Columbia, Canada

• Deploy ML models into production using Oracle Data Miner API • Design structure and maintain historical data for all ML Requests• Provide statistical expertise to assist in identifying and implementing future development opportunities• Enhance and update logic, tables and objects within data warehouse to create client development requests• Create ETL processes for third party integrations, automate nightly scheduling and maintain data integrity in production database• Consulting with clients to develop ad hoc reports and products to assist with day to day operations or large project needs• Design, automate and maintain complex regulatory reporting extracts• Keep detailed records of code changes and write detailed release specs for deployment into other client environments• Review, identify and repair production issues within dozens of client environments • Support clients with Oracle Business Intelligence product and performance issuesKey Achievements:✔ Developed custom Segmentation, Attrition, Next Best Product and Profitability models for individual clients to assist with company and team goals and projections✔ Promoted to DevOps team as developer. Designed and implemented development projects into production environments✔ Requested to Merger Team for high profile projects. Responsible for creating packages and stored procedures to translate and standardize data from legacy banking system to meet the requirements of the current system. This includes testing multiple cuts of data before merging into live production environments.✔ Automated balancing reporting for client onboarding process, saving dozens of hours of project time for future implementations✔ Expert within the support team for SQL client requests, including opportunity and data quality management identification and consulting✔ Developed numerous procedures to enhance error logging in daily summarization process, specific to client needs

Burlington, Ontario

• Act as the only data person responsible for co-creating and implementing the analytical products offered to credit unions• Perform competitive analysis with other Credit Unions identifying existing and emerging buying trends• Manage FTP site; create users, reset passwords, manage data transfers• Determine which transactions and services were performed at which stages of new member onboarding• Design custom new member onboarding map/plan for clients• Train and manage Junior analyst in basic analytic skills including SQL and reportingKey Achievements:✔ Created and developed attrition model to determine risk rate for all current members; created a top 100 risk list that currently captures 18% of total lost money✔ Co-designed, developed, and maintain custom Segmentation product, including automation and bimonthly refresh reports✔ Designed and maintain monthly rollup process including intake and standardization of external data, raw database design, storage and maintenance of stacked and formatted data storage✔ Created standardized mapping document available to clients that maps their raw data to our system✔ Co-designed, developed and maintain Engagement index product which measures customer engagement and tracks movement over multiple time periods✔ Created, developed, and maintain Next Best Product, a tool with a 30% overall response rate that determines which of the major account types the member will open next

• Acted as the sole anaylst and developed predictive models, segmentation solutions, and attrition models to identify opportunities for external Credit Union clients• Standardized external data and verify imported data and company-wide mining activities • Provided measurements and tracking to optimize pre and post-campaign performance• Provided consulting advice for Credit Unions with smaller budgets and memberships• Created custom analytics to suit the needs of requests; determined project costs and timelines • Generated cluster analysis to determine channel preference to aid in campaign targetingKey Achievements:✔ Compiled external data sources such as Manifold and Statistics Canada to provide custom fields RRSP contribution room, Savers and Investors bands unique to each Credit Union

• Performed predictive modeling and member management with the Segmentation and Marketing teams• Maintained and synchronized member/market data, segmentation analytics, and business intelligence • Monitored campaign progress and deciphered patterns to analyze effectiveness and maximize profits• Analyzed transactional data to establish flow of funds and determine transaction code effectiveness• Provided data for Media Relations team based on high priority ad hoc requests for various media outletsKey Achievements:✔ Created field mapping documentation – Defined BI system to create document explaining all fields for Segmentation department after IT could not provide documentation.✔ Overhauled the system for detecting unique members and provided aggregated data to internal teams✔ Developed automation scripts for reports of various frequencies using SSIS software

• Worked as part of the Advanced Analytics and Strategic Solutions Group to develop predictive models, segmentation solutions, and lifetime value models to identify opportunities for internal and external clients in a saturated market• Performed competitive analysis with other Credit Unions identifying existing and emerging buying trends• Standardized external data and verified imported data and company-wide mining activities • Conducted Trade Area analysis for branch utilization using GIS software and SQL Server to study demographic data from Statistics Canada and report on optimal new branch locations• Generated mailing and calling lists for campaigns based on model outcomes• Provided measurements and tracking to optimize pre and post-campaign performanceKey Achievement:✔ After minimal training maintained the department as the only analyst. Managed all processes and procedures including training/supervising student employee

Key Achievement:✔ Developed an automated template using SAS and Crystal Reports that would automatically create reports for all 543 municipalities in the jurisdiction✔ Instrumental in the major AVM Research Project compiling data on past, current, and future mortgage patterns coupled with information from AVM methods across Canada and the United States✔ Requested by internal clients more frequently than 5 peers to complete ad hoc requests during a demanding two week mandate to complete assignments

• Taught Multiple Regression Analysis to management and executive staff emphasizing the benefits• Ensured accurate costing for QA/QC and provided support to Commercial Assessors in Appeal Court Key Achievement:✔ Appointed as the youngest member to a high-profile QA/QC project and performed variance testing to ensure seamless transition of a mass of data for an appraisal system; received a letter of recognition✔ Completed the 2006 final roll statistics; created a study into a new qualified and unqualified sales system✔ Applauded for outstanding work as the appointed Statistical Consultant to provide expert witness opinion during a URB Board hearing for a federal property