Yanhao Lu Email & Phone Number

Vaughan, On, Ca

Toronto

• Issue and respond to Variation Margin and Initial Margin calls which are reflected by the fluctuationof market for total exposure of each ISDA CSA contract• Manage the collateral (OTC derivatives) – book and monitor the incoming or outgoing collateral forrehypothecation throughout the OTC market• Set up the contracts with observance of newly onboarding counterparties or newly executedamendments with existing clients, per legal team’s advice• Well communicated with assigned clients – be able to help clients for any queries or any urgence• Reconcile and resolve any breaks that caused by operational issues• Manage the interest payments for cash collateral each month• Coding using VBA to create useful Macros that helps managing the daily tasks• Reporting to senior management weekly for any improvements or big breaks• Be recognized to manage the big-name clients – Morgan Stanley, Deutsche Bank, HSBC, JPMorgan Chase, Goldman Sachs, etc.

Toronto

• Conducted extensive data analysis by filtering technology consumer data to explore potentialbusiness insights and made quarterly business summary and recommendations for board meetings• Created dashboard by utilizing Excel pivot table, VBA, and Tableau to optimize quarter endreporting process• Developed good interpersonal skills and led the BA team to develop a client onboarding system,saved over $300,000 on vendor spending

Toronto

• Collected and organized massive raw data via online survey, presented the valid data using Tableaufor further data analysis• Utilized advanced Excel skills in lookup Functions, Pivot table, If Functions etc., to performextensive quantitative analysis• Performed comparison analysis on competitors’ products and services in a goal of designing moreattractive products• Presented reports with business insights and recommendations based on the analysis results to assistsenior management with decision making process

中国 江苏省

• Identified, analyzed, and executed new products, services, markets, and advertising opportunities• Collected and analyzed data on established and prospective customers, competitors, and marketingchannels and sources• Collaborated with team members to prepare reports that interpret consumer behavior, marketopportunities and conditions, marketing results, trends and investment levels