Sophie Chen

Experience

• 

  UTCSSA

  Apr 2017 - Apr 2019

  Executive Member

  - Planned and managed the budget and cost for the association, including campaign marketing, advertising, ad events organization, etc.- Prepared monthly reports in detail using Excel (such as funding, grants, expense, and balance, etc.) for the association management team- Worked with the marketing team for fundraising through membership promotion, liaising with potential sponsors, and private partners

• 

  Toromont Cat

  May 2018 - Sept 2019

  Data Analyst

  - Cleaned and manipulated data using Excel and VBA to ensure consistent data format; loaded data into database for reporting purpose- Performed analysis and prepared reports to support requests related to customs compliance import regulations of temporary tariffs placed on Canadian imports- Designed and implemented several processes using Excel and VBA macros to automate a manual cross-referencing exercise used for customs audit

• 

  TD

  Sept 2019 - Sept 2020

  Wealth Operations Officer

  - Processed customer transactions including withdrawal and contribution transactions placed in RRSP and TFSA, reviewed and verified forms requesting to withdraw funds from Home Buyer’s Plan - Utilized VBA macros to process cheque transactions and prepared daily summary reports for managers- Worked with both internal and external groups to resolve transaction issues and data discrepancies- Assisted in analysis, development, testing, and implementation of new operating procedures

• 

  Davies - Consulting Division

  Nov 2020 - Jan 2025

  - Manage database to ensure applicable regulatory content is loaded and available to support engagements- Support Financial Crime and Compliance Team with all aspects of data requests, including data cleaning, processing, quality check and result presentation- Share ideas with the developer to assist useful function development and bug corrections

  • Consultant

    Jan 2022 - Jan 2025

  • Analyst

    Nov 2020 - Jan 2022
• 

  Sun Life

  Jan 2025 - now

  Manager, Compliance Technology, Compliance PMO