Analytics Engineering | Cloud, Data & Transactions | Canadian Banking Technology (CBT)• Data Engineer & Lead Developer for 16 consumer-zone applications (Apple Pay reporting, creditor insurance, etc.)• Agile project management, JIRA to manage user stories (project tasks) • Tools for code version control: Bitbucket, Git Bash, and TortoiseSVN• CI/CD: Jenkins pipelines for code release to UAT and production environments• Write Hive SQL (HiveQL) and Linux/Bash scripts in Notepad++• Cisco Tidal (SysAdmiral) application to manage table loads in Development, UAT, and Production environments

• Hive SQL scripts to create tables in Hadoop• Bash (Linux) scrips to run SQL scripts sequentially• Various layers for user groups• Cisco Tidal (SysAdmiral) application to manage table loads in production• Agile project management, JIRA to manage user stories (project tasks)• Git Bash, TortoiseSVN, and Bitbucket for code version control

• Converted SAS programs for reporting— Old database: Netezza— New database: Hadoop• Revised SAS programs to account for limitations in Hadoop/Hive (for example, table updates not allowed and non-equal joins not allowed)• Improved efficiency of SAS code, SQL code, and data-source input/output where possible

• Performed cluster analysis for business customers (PROC CLUSTER in SAS)• Developed AML software tools for various lines of business using a variety of applications (e.g., Microsoft Excel VBA, Microsoft InfoPath, Jira)• Some Hadoop, Scala/Java• Jira administrator

• Campaigns:— New Customer Welcome campaign continua (omni-channel, customer lifecycle) for Auto Finance Indirect Loans, chequing accounts and plans, small-business accounts, multicultural banking— Chequing acquisition email campaign for SCENE members— Relationship-touch campaigns— Referral campaigns• Offers:— Pre-approved credit cards, invitations-to-apply for credit cards— Chequing accounts and plans, savings accounts— Sequence-sell offers— Relationship-touch surveys• Channels:— Digital (email, Scotia Online message centre, Scotia Online intercept pages)— Next Best Activity / Next Best Action (NBA) for inbound calls— Outbound telemarketing, direct mail— Email— External vendor for gift-card incentives• Roles:— IBM Campaign Developer / Unica Affinium Campaign Developer— Senior Data Analyst— Campaign Execution Data Analyst— Database Marketing Analyst— Business Analyst— Business Systems Analyst— Data Investigator— Execution Data Pre-analyst and Execution Data Analyst— Data Quality Assurance, Data Quality Testing, Data Quality Control• Tools:— IBM Campaign (also known as Unica Affinium Campaign or Unica Campaign)— SAS Base remote access, SAS EG (SAS Enterprise Guide)— IBM DB2 database, Control Center— UNIX shell scripting, UltraEdit— Microsoft SharePoint document management, Microsoft Office

• Marketing campaign data execution • Documentation and implementation of continuous process improvement • Presentations: — “Email Previewer Tool”, a Perl script run in UNIX (presentation adapted for Canada)— “Staging, Data-Integrity Validation, and Business-Intent Validation” — Interpreting data-interface reconciliation reports (informal) — “Archiving and retrieving Teradata tables”• Teradata 13 — Teradata SQL Assistant — BTEQ (“Basic TEradata Query”) for scripting in a UNIX-shell environment (ksh) • Data preparation and exchange for “Customer Panel”, a web-based focus group • Backup data analyst for Customer Pool, including script updates and monthly process runs• SAS Enterprise Guide 5.1 (SAS EG 5.1) • Perl— Canada data analyst supporting the email previewer tool

• Teradata 13• UNIX shell scripting• SAS Enterprise Guide 4.2 (SAS EG 4.2)• Unica Affinium Campaign running on Teradata 13

• Microsoft SQL Server 2000• Unica Affinium Campaign running on Oracle 11g

• Microsoft SQL Server 2000• Unica Affinium Campaign running on Oracle 11g

• Database marketing (direct mail and outbound telemarketing)• Variable compensation reporting and calculations for financial advisors• Management reporting on investment-product cash flows and assets under administration

• Reduced the daily run time by 90% (from 20 minutes to 2 minutes) of a legacy Microsoft Excel macro in Visual Basic for Applications (VBA)• Converted the client mailing list from a single, flat Microsoft Word table to a Microsoft Access relational database