David Li, Cfa Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

- Securitized four, 144A compliant, REALT CMBS deals to date, with a combined notional of $1.6 billion- Securitized the first Single Asset Single Borrower (SASB) transaction since CMBS relaunch in 2014- Prepare/review Offering Memorandum, Annex A & G, Presale Reports, AUP report and etc.- Upgraded underwriting template used by underwriters and originators for all CMBS deals - Created a centralized database to store and manage loans in the warehouse- Preparing weekly/monthly/ad-hoc reports and models for senior management’s review- Working with Corporate Treasury to manage interest rate risk and marking position to market- Streamline workflow with Excel VBA scripts to increase efficiency and automation- Extract and transform data from various sources for future analysis

Toronto, Canada Area

- Forecast daily cash funding needs for Residential and Commercial Mortgage Back Securities held by Corporate Treasury- Familiar with term funding, debenture, covered bond, structured products and credit default swaps handled by CT- Created a three way reconciliation template to reconcile all term funding and covered bond issued to date- Ensure all controls and procedures are properly followed for all cash flow and fair value hedges- Streamline workflow with Excel models as well as VBA scripts to increase efficiency and automation

Toronto, Canada Area

- Created a VBA macro to automate the account receivable spreadsheet, eliminating human error and manual reporting - Implemented 4 management reporting systems to evaluate financial performance of various aspect of the business- Managed internal and external stakeholder relationships professionalism through effective communication- Demonstrated analytical skills by building financial models to forecast payroll budget for 6 revenue centers and 1 cost center thereby identifying an opportunity to reduce budgeting time by 92%, from 23 hours to 2 hours on average - Successfully assisted the CEO and the management team with their investment pitch to secure external funding

Bachelor Of Business Administration (Bba), Finance, General

Education record