Thomas Yip
Strategy Consultant at BMO Wealth Management - Canada- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Chinese Limited working proficiency
-
English Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Destination Digital - Innovator
BMOAug, 2022- Nov, 2024 -
The Complete SQL Bootcamp 2020
UdemyMay, 2020- Nov, 2024 -
Academic Diploma in Business Analysis
IIBAMar, 2019- Nov, 2024 -
Canadian Securities Course
Canadian Securities Institute (CSI)Feb, 2017- Nov, 2024
Experience
-
BMO Wealth Management - Canada
-
Banking
-
700 & Above Employee
-
Strategy Consultant
-
Feb 2023 - Present
-
-
Business Analyst
-
Apr 2021 - Apr 2023
-
-
-
BMO Capital Markets
-
Canada
-
Investment Banking
-
700 & Above Employee
-
Senior Analyst
-
Oct 2017 - Apr 2021
• Elicited information from Managers and above of other derivative teams to understand dataflow of transactions regarding data channels, logic, and to mitigate risk • Mapped and analyzed dataflow between all related systems used by various teams to pinpoint root cause to determine issue or opportunity for improvement using Visio • Presented findings and propose changes to upper management (managers, directors, associate directors, etc.) through PowerPoint presentation • Analyzed and posted accounting entries for financial instruments to General Ledgers and various sub ledgers as well as perform reconciliation between cash and security to ensure nothing is missed at month end • Created Excel spreadsheets using advanced formulas such as Index, Match and Nested IF statement to streamline processes • Recorded and maintained Standard Operation Procedures for the team in case of training new team members and cross training purposing Show less
-
-
-
State Street
-
United States
-
Financial Services
-
700 & Above Employee
-
Senior Client Management Operations
-
Apr 2017 - Oct 2017
• Managed and resolved issues directly with clients and internal departments regarding trades, invoices, accounting issues, and any miscellaneous client inquiries• Documented and created Standard Operating Procedures for the team in the case of training new team members and cross training purposes• Created a spreadsheet using excel to check and ensure that client accounts were not in overdraft at the end of the day as well as making sure that accounting is in order for all transactions• Supervised offshore processing teams that trades were booked accurately and made sure that trades reconciled to blotters received from clients• Developed and maintained positive client relationships through communication and resolving issues with them Show less
-
-
Derivatives Operations Analyst
-
Dec 2016 - Apr 2017
• Analyzed daily trades to determine if instructions are valid and reconciles to the amount in the fund to reduce the risk of errors and overdraft before booking and settling the trades• Responsible for the trades of specific clients as trades must be booked and settled before daily deadline of 2pm (average daily trades amounts to more than 100 and worth over 5 million in various currencies)• Created a Financial Model to have an understanding of the impact to swaps based on various interest rate situations and to confirm the price of the swap legs are correct• Resolved issues with derivatives such as interest accruals and rollover dates with Investment Managers and internal departments• Initiated the wires for payments and receivables to counterparties of the client, through the use of MCH for the gains and losses regarding the trades made Show less
-
-
-
State Street
-
United States
-
Financial Services
-
700 & Above Employee
-
Financial Reporting Administrator
-
Jan 2015 - May 2016
• Prepared annual and quarterly financial reports for various US hedge funds, and investment companies following IFRS and US GAAP • Reconciled and performed account analysis on various financial statement accounts such as accounts receivable/payable, transfers in-kind within funds, and finding solutions to rectify GL accounts in a timely manner by analyzing raw data through manipulation using Excel • Escalated issues involving reconciliation between securities on record to existing holdings held by clients, by contacting other departments such as NAV team when solution could not be found with existing resources. Conducted follow up after 3 hours of the issue being escalated to ensure problem is resolved effectively without delay. • Utilized professional level excel skills to manipulate substantial financial data through the use of pivot tables, custom macros, and various functions such as VLOOKUP, SUMIF(S), and nested IF statements • Created and implemented new macro enabled spreadsheets using VBA coding in excel, to minimize human errors in daily operations such as data extraction and financial statement reconciliation Show less
-
-
-
TD
-
Canada
-
Banking
-
700 & Above Employee
-
Operations Officer
-
Feb 2014 - Jun 2014
•Followed industry regulations and practices (Basel I & II) when completing tasks •Abided TD Waterhouse standard SLA to ensure transfers of funds were completed in a timely manner to minimize potential money loss for the client or company •Ensured client satisfaction by investigating fund transfer statuses of client’s securities such as Shares, Mutual funds, and RRSPs with domestic/international financial institutions and credit unions while accommodating for their time zone differences •Identified and resolved various problems regarding transfer requests such as missing transfer forms and compromised marriage accounts, in a timely matter to avoid compensation •Verified the accuracy of information on transfer request forms (such as T-2033) that were being sent to financial institutions to decrease processing time and prevent the risk of securities being renewed with the external institutions Show less
-
-
Education
-
George Brown College
Graduate Certificate, Information Systems Business Analysis -
Ryerson University
Bachelor of Commerce (B.Com.), Finance and Marketing (Double Major)