Ryan Cheng Email and Phone Number
toronto, ontario, canada
Ryan Cheng's Location
Toronto, Ontario, Canada, Canada
Ryan Cheng's Contact Details
Ryan Cheng work email
- Valid
- Valid
Ryan Cheng personal email
n/a
About Ryan Cheng
Ryan Cheng is a Manager at BMO Financial Group at BMO Financial Group. He possess expertise in financial analysis, financial accounting, financial reporting, data analysis, microsoft excel and 88 more skills.
Ryan Cheng Work Experience Details
-
ManagerBmo Financial Group Apr 2022 - PresentToronto, Ontario, CanadaFinance Master Data Management -
Senior Data AnalystManulife Apr 2020 - Apr 2022Toronto, Ontario, CanadaLiability Driven Investments• Led a team of four analysts to manage the investment data used by portfolio managers at the fixed income trading desk• Advised on the data pipelines of existing financial systems infrastructure during the migration to a new platform• Proposed cost-saving strategies for market data vendors by limiting redundant and excessive API calls• Developed VBA and PL/SQL scripts with business logic to transform datasets used for security selection within… Show more Liability Driven Investments• Led a team of four analysts to manage the investment data used by portfolio managers at the fixed income trading desk• Advised on the data pipelines of existing financial systems infrastructure during the migration to a new platform• Proposed cost-saving strategies for market data vendors by limiting redundant and excessive API calls• Developed VBA and PL/SQL scripts with business logic to transform datasets used for security selection within portfolios• Collaborated with developers and analysts across Bloomberg, FTSE, and internal teams to resolve data quality and pipeline issues Show less -
Senior Financial AnalystBmo Financial Group Aug 2018 - Mar 2020Toronto, Canada AreaLiquidity & Derivatives Reporting• Built an Excel VBA automation tool for financial analysis and controls capable of decreasing a month’s workload into a day• Developed the infrastructure and stored procedures on a SQL Server used for automating financial reporting and ETL processes• Constructed an Excel front-end VBA application for end users to store and retrieve financial information from a SQL Server• Designed a statistical Power BI model with a SQL Server back-end to… Show more Liquidity & Derivatives Reporting• Built an Excel VBA automation tool for financial analysis and controls capable of decreasing a month’s workload into a day• Developed the infrastructure and stored procedures on a SQL Server used for automating financial reporting and ETL processes• Constructed an Excel front-end VBA application for end users to store and retrieve financial information from a SQL Server• Designed a statistical Power BI model with a SQL Server back-end to identify report value anomalies and the underlying drivers• Analyzed trends and provided commentary on the bank’s outstanding positions on repos, secured lending, and swaps Show less
-
Contract AnalystDeloitte Feb 2018 - Aug 2018Toronto, Canada AreaFinancial Advisory• Worked on an anti-money laundering engagement for a major Canadian bank across corporate and retail client segments• Designed a one-click Excel dashboard for senior managers to visualize insights on live project productivity metrics and trends• Developed web scraping tools to automatically assemble risk reports based on existing financial system infrastructure• Built a toolkit using VBA to improve the efficiency of an essential data remediation workflow by… Show more Financial Advisory• Worked on an anti-money laundering engagement for a major Canadian bank across corporate and retail client segments• Designed a one-click Excel dashboard for senior managers to visualize insights on live project productivity metrics and trends• Developed web scraping tools to automatically assemble risk reports based on existing financial system infrastructure• Built a toolkit using VBA to improve the efficiency of an essential data remediation workflow by 74% across 86 analysts• Presented tools and dashboards to the client’s senior leaders to showcase project insights, efficiency gains, and best practices Show less -
Banking Operations AnalystBmo Financial Group May 2017 - Aug 2017Toronto, Canada AreaGovernance & Oversight• Built dynamic Excel dashboards for business leaders to drive quantitative insights on corporate and retail banking risk trends• Created an automatic risk-categorized scorecard for the head of capital markets operations to monitor outstanding critical issues• Developed in-house automated report building and analysis tools through Excel VBA to free up 304 annual labour hours• Automated data consolidating and cleaning processes using Access VBA and SQL to… Show more Governance & Oversight• Built dynamic Excel dashboards for business leaders to drive quantitative insights on corporate and retail banking risk trends• Created an automatic risk-categorized scorecard for the head of capital markets operations to monitor outstanding critical issues• Developed in-house automated report building and analysis tools through Excel VBA to free up 304 annual labour hours• Automated data consolidating and cleaning processes using Access VBA and SQL to improve reporting efficiency by 89%• Collaborated with software developers to resolve overlooked system bugs during a risk program rollout across 48 departments Show less
-
Financial AnalystTd Sep 2016 - Dec 2016Toronto, Canada AreaPersonal Banking Finance• Modelled product line profitability implications based on key expense driver scenarios for a transfer pricing due diligence• Constructed an automatic spreadsheet to compute product line budget variances based on a $252 million CAD financial data store• Automated monthly reporting using Excel VBA, nested logic formulas, tables, and index/match to reduce 86 annual labour hours• Analyzed private banking profit and loss trends worth $11 billion CAD to… Show more Personal Banking Finance• Modelled product line profitability implications based on key expense driver scenarios for a transfer pricing due diligence• Constructed an automatic spreadsheet to compute product line budget variances based on a $252 million CAD financial data store• Automated monthly reporting using Excel VBA, nested logic formulas, tables, and index/match to reduce 86 annual labour hours• Analyzed private banking profit and loss trends worth $11 billion CAD to support managerial discussion on profit segmentation• Established a consolidated reporting framework using Excel VBA and dynamic tables to report departmental productivity gains Show less -
Internal AuditorTreasury Board Of Canada Jan 2016 - Apr 2016Toronto, Canada AreaOntario Internal Audit Division• Performed statistical analysis to assess compliance risks amongst 37,818 expense reports totalling $1.7 million CAD• Audited expense reports and procurement cards of government employees for adherence to ministry directives• Utilized regression, vertical, and horizontal analysis on a 16,351 entry database to identify insights on post-secondary education• Extracted and cleaned raw data from 19,311 financial statements to assemble flat file… Show more Ontario Internal Audit Division• Performed statistical analysis to assess compliance risks amongst 37,818 expense reports totalling $1.7 million CAD• Audited expense reports and procurement cards of government employees for adherence to ministry directives• Utilized regression, vertical, and horizontal analysis on a 16,351 entry database to identify insights on post-secondary education• Extracted and cleaned raw data from 19,311 financial statements to assemble flat file databases for audit sampling• Drafted a management report identifying 14 audit issues and recommended controls to mitigate business process risks Show less -
Strategy AnalystReinsurance Group Of America Jan 2015 - Apr 2015Toronto, Canada AreaGlobal Accounts• Conducted a comprehensive audit on the DCF model for a $31 million CAD acquisition of a digital insurance aggregator• Enhanced the accuracy of an acquisition target’s NPV by 34% through re-aligning revenue growth forecasts from a material error• Researched quantitative insurance market trends for the modelling assumptions in the due diligence of an acquisition• Produced research reports about high net worth individuals within the private health insurance… Show more Global Accounts• Conducted a comprehensive audit on the DCF model for a $31 million CAD acquisition of a digital insurance aggregator• Enhanced the accuracy of an acquisition target’s NPV by 34% through re-aligning revenue growth forecasts from a material error• Researched quantitative insurance market trends for the modelling assumptions in the due diligence of an acquisition• Produced research reports about high net worth individuals within the private health insurance industry to be used as white papers• Conducted a preliminary cost-benefit analysis amongst services for 12 global accounts by quantifying key performance indicators Show less
Ryan Cheng Skills
Financial Analysis
Financial Accounting
Financial Reporting
Data Analysis
Microsoft Excel
Finance
Team Leadership
Teamwork
Time Management
Aop
Sdl
Design Patterns
Concurrent Programming
Database Design
Distributed Systems
Operating Systems
Java
Aspectj
C
C++
Sql
Xml
Javascript
Java Enterprise Edition
C#
Angular 2+
Agile Methodologies
Object Oriented Programming
Object Oriented Design
Business Process Management
Html5
Cascading Style Sheets
Angular Material
Unified Modeling Language
Pl/sql
Json
Jquery
Sass
Representational State Transfer
Soap
Ajax
Hibernate
Sql Server Integration Services
Node.js
React.js
Git
Webpack
Jira
Xcode
Objective C
Cspo
Typescript
Coffeescript
Web Services Description Language
Drools
Npm
Backbone.js
Gruntjs
Bitbucket
Sdlc
Ood
Oop
Uml
Windows
Ms Dos
Unix
J2ee
Jdbc
Ejb
Servlets
Assembler
Html
Css
Asp
Asp.net
Microsoft Office
Eclipse
Ibm Rational Clearcase
Bea Weblogic
Apache Ant
Visual Studio .net
Visual Web Developer
Db2
Oracle Database
Cvs
Adobe Photoshop
Weblogic
Web Services
Software Design
Linux
Unix Shell Scripting
Vss
Quality Center
Ryan Cheng Education Details
-
Accounting And Financial Management
Frequently Asked Questions about Ryan Cheng
What company does Ryan Cheng work for?
Ryan Cheng works for Bmo Financial Group
What is Ryan Cheng's role at the current company?
Ryan Cheng's current role is Manager at BMO Financial Group.
What is Ryan Cheng's email address?
Ryan Cheng's email address is rh****@****rloo.ca
What schools did Ryan Cheng attend?
Ryan Cheng attended University Of Waterloo.
What skills is Ryan Cheng known for?
Ryan Cheng has skills like Financial Analysis, Financial Accounting, Financial Reporting, Data Analysis, Microsoft Excel, Finance, Team Leadership, Teamwork, Time Management, Aop, Sdl, Design Patterns.
Who are Ryan Cheng's colleagues?
Ryan Cheng's colleagues are Ying Ping (Shirley) Lin, Badr Raji, Nala Soma, Jason Schwing, Karen Ferrazzano, Muhammed Khan, Richard Mercier.
Not the Ryan Cheng you were looking for?
-
-
Ryan CHENG
Master Of Financial Risk Management @ Rotman | Open For Positions In Business And Financial RiskToronto, On -
-
Ryan Cheng
Greater Vancouver Metropolitan Area
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial