Post Job Free

Resume

Sign in

Business Analyst System Consultant

Location:
Toronto, ON, Canada
Posted:
November 17, 2022

Contact this candidate

Resume:

DALONG WANG, MBA, MEng, CFA, CMT

adtj96@r.postjobfree.com 647-***-**** www.linkedin.com/in/dalongwang/

Capital market specialist with long-term experiences in derivatives modelling, pricing, risk management and business analysis. Possess strong analytical skills, excellent communication skills, quantitative strength, and advanced computer and systems skills. Promptly respond to all requests, work well under pressure within timelines.

Qualifications Highlights

Schulich MBA (Distinction), Financial Engineering Graduate Diploma, MEng International Business and Finance, BEng Computer Science.

Hands on experiences in derivatives and cash products trading, independent price verification, risk management and risk system implementation.

Strong modelling skills in valuation of financial instrument (fixed income derivatives, Equity Derivatives, FX, options, futures, swaps and other derivatives). Solid knowledge and experiences in market risk and credit risk management for capital market products.

Strong data analysis skills and solid computer proficiency in Bloomberg, Excel, Macros and Database (SQL), strong programing skills with C++, VBA, Python and PowerShell.

Strong written and verbal communication skills.

PROFESSIONAL EXPERIENCE

Senior Business System Consultant – FIS Global (formerly Sungard Financial) Aug 2021 – Present

Implemented the Adaptiv risk management system for a new client as the primary consultant

Built scripts to convert all kinds of trades from csv format to Adaptiv format

Configured the workflow to transform the market data from raw files to Adaptiv system format, including curve bootstrapping and model calibration.

Configured the workflow to conduct market risk calculation (Historical Simulation Var, Monte Carlo Simulation Var), credit risk calculation (Monte Carlo Simulation, Deterministic Credit Risk), and liquidity risk calculation.

Configured the Adaptiv Interface to schedule and streamline the workflows

Tested the required functionalities, raised tickets for issues and tested the fixes

Installed and configured the Adaptiv systems for multiple versions of hotfixes and upgrades (ICS, Adaptiv Analytics, Market Data Toolkit, Risk Cube, Memory Cube, Risk UI, Task Distribution, VIS, Adaptiv Interface, Rabbit MQ, Redis)

Supported clients for the issues/questions they encountered

Ensured overnight EoD run to complete successfully

Senior Consultant — Bank Of Montreal Oct 2018 – Aug 2021

Worked on counterparty credit risk system upgrade project.

Converted historic trades from 2007 version Apativ system to 2017 version Apativ system for back testing purpose, analyzing the conversion rules, programming codes with Python to convert 50 types of derivative products, investigating the MTM discrepancies and fine-tuning the conversion codes, collaborating with vendor, modelling team and market data team to address the un-reconcilable discrepancies. Completed the task well ahead of team leader’s expectations.

In charge of mapping Equity Total Return Swaps (TRS), Fixed Income TRS and equity options trades from source system to the new CCR system, working closely with source data system team, CCR production team, modelling team and tech BAs to analyze mapping needs, drafting mapping specification, creating testing cases and conducting regression testing to ensure correct mapping, MTM and PFE for both live trades and planed new types of trades. Collaborate with modelling team and market data team to address the un-reconcilable discrepancies.

Helped to design and maintain attribute mapping, security master and market data.

Conducted PFE testing, Independent Amount testing, EoD testing, Intraday testing, Pre Deal Check testing, regression testing etc.

Worked with production team to ensure all trades are properly captured by the system; solved production issues in a timely manner after system went on live.

Built a lot of tools with Python and VBA for various testing/analyzing/operational purposes

Created/updated user manual and other documents

Senior Derivative Trading Analyst and Trader — Manulife Financial 2008 - 2018

Promoted to manage multi-billion dollar Canadian Universal Life portfolios with assets covering global equities and fixed income securities, traded ETFs, futures, institutional funds and FX to rebalance the portfolios on daily/weekly basis

Managed four Standard Life funds (two TSX60 index portfolios and two S&P 500 index portfolios, about 1.5 billion AUM) in 2015, rebalanced and executed the portfolios based on cash flow and index rebalancing change.

Led, monitored and executed Base Metal Public Equities Investment project with 30 names on 6 stock exchanges, globally, One billion dollar AUM, from 2016 to 2018. Executed the program with high investment returns. Handled asset swaps for Asian private debt project of $1 billion investment in the global market in 2017. Both project team were awarded with Team was awarded with Manulife Star of Excellence

Worked closely with business groups including ALM, VA Hedging, Treasury, Universal Life, Fixed Income Desk, Asian Entities, and Global Investment Strategy. Collaborated to formulate and implement hedging strategies, leveraged detailed understanding and technical expertise to choose hedging instruments, provided market updates and co-decided timing for efficient execution of trades.

Traded various derivatives and cash products with multi-billion dollars notional annually, accomplished lots of different projects:

—Interest rate derivatives, including interest rate swaps, cross currency swaps, swaptions, bond forwards and bond futures.

—Equity derivatives, including equity index options, futures and total return swaps.

—FX, including FX spot, FX forward, FX swaps and currency futures.

—Credit derivatives, iBoxx and Dex bond indices total return swaps.

—Cash bonds and cash equities, ETFs and institutional funds across the global market

Developed and maintained many spread sheet applications with Excel and VBA for different business purposes, such as rebalancing calculation for multiple Canadian Universal Life portfolios, back testing trading strategies, pre-pricing a large numbers of swaps, especially cross currency asset swaps for foreign bonds.

Maintained good relationship with dealers in the market, kept abreast of market development.

Priced embedded options for private placements, mortgages, and inter-company loans.

Closely followed the development of derivative pricing convention after the financial crisis. Had extensive research and hands-on experience in building curves for pricing swaps in the current sophisticated market including OIS dual curve stripping, multi-currency collateral discounting, etc. Have deep understanding in XVA adjustment.

Collaborated with modelling group to set up instruments and curves in derivatives booking system (Findur).

Derivative Trading Analyst — Manulife Financial 2006 - 2008

Supported and collaborated with ALM, VA Hedging, Treasury, Universal Life, Fixed Income Desk, Asian Entities, and Global Investment Strategy to formulate hedging strategies, implement and execute trades efficiently. (See Senior Derivative Trading Analyst description.)

Built and maintained several Excel, Bloomberg macro and VBA based a global yield search tools, using Bloomberg SWPM engine to automatically calculate cross currency asset swaps and compare the yields. Greatly improved calculation accuracy and eliminated manual and approximate estimate process. Tools were widely used in different Manulife business group and entities globally.

Co-led project involving various swaps including cross currency and zero coupon swaps with about $1 billion notional and 100 trades in the very first year. Executed with manager to accommodate accounting rule change within a tight timeline, quickly acquired derivative modelling and pricing skills, interacting with dealers and understanding the market.

Led project to build a model for Treasury to improve tracking of RSU/DSU hedging, replacing inefficient procedure.

Senior Analyst, FX Options Back-Office — TD Securities Inc. 2004 - 2006

Collected and verified independent market parameters and completed independent MTM verification.

Investigated and resolved discrepancies and provided in-depth analysis of daily and monthly P&L.

Automated FX options P&L reporting and IPV process with Excel, Access and VBA, improved the daily analysis and reporting efficiency by 8 times.

Using my strong programming and data analysis skills, successfully delivered several critical trading system (Murex Currency+) related projects, such as P&L attribution analysis tool, accounting cleaning-up, and correction of accounting rules.

Collaborated with quantitative analytics group to develop and implement new Reval models for exotic options.

Achieved TD Act for Impact Award.

Intern, Quantitative Developer— J & J Investment Quotient. 2004

Developed a proprietary options trading system using Excel and VBA, for booking, pricing, P/L reporting, measuring risk of KOSPI index options and futures trading and performing simulation.

Developed a tool with Excel, VBA and Matlab for pricing and measuring risk of various exotic options.

Designed and tested hedging strategies using historical back-testing method.

Measured risk of options portfolios, developed and evaluated options trading and hedging strategies.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Master of Business Administration, Schulich School of Business, York University

Specialization Financial Engineering Graduate Diploma and Finance (Dean’s Honour)

Master of Engineering, Management School, Shanghai Jiao Tong University, China

Specialization Finance and International Business

Bachelor of Engineering, Computer Science Dept, Southeast University, China

Specialization Computer Science (Dean’s Honour)

Chartered Market Technician, Market Technician Association

Chartered Financial Analyst, CFA Institute

Certified Public Accountant, China Institution of Certified Public Account



Contact this candidate