Business Analyst Senior
Resume:
WILSON LIU
SKILLS
Extensive experiences in providing expertise and delivering services for financial industry, specifically in securities trading (equities, fixed income and derivatives), asset management and risk control.
Thorough understanding and hands-on experience on trading system and trade life cycle— front-end
order capture/entry and position management, middle-office risk control and collateral management,
and back-end book keeping and settlement.
Working knowledge on exchange and OTC derivatives, including options, swaps/swaptions, risk reversals, FRAs, futures and forwards.
Professional experience and knowledge in derivatives pricing (Black-Scholes, Binomial Tree and Monte Carlo), trading, hedging and risk management (Option Greeks & VaR).
Excellent business writing skills in drafting Visio workflows, Business Requirements Documents (BRD), Functional Specifications Documents (FSD), Nonfunctional Requirements Documents and User Stories.
Advanced data retrieval and analysis skill using SQL.
EXPERIENCE
Massachusetts Financial Service (MFS) Boston, MA
Business Analyst, Trading
9/2022 –
Analyzed and documented functional specifications on Charles River Development (CRD) trading system’s FX forward-curve based pricing for currency forwards, set up system parameters and user profile for currency traders in CRD Manager Workbench, and customized CRD trade Blotter to facilitate currency forwards (deliverable and non-deliverable) trading.
Analyzed non-zero cash balance issue at sub-portfolio level and documented solutions to ensure zero cash balance for hedge share class and line of credit accounts.
Diagnosed pricing discrepancy for some inflation bonds, proposed and documented solutions to address the issue.
Analyzed intra-day trade flow between CRD and EAGLE (golden source), identified certain swap products and documented solution to suppress updating properties for these swaps in intra-day messaging.
Analyzed contents, designed layout and documented functional specifications for CRD Transaction Summary daily report.
Bank of America Boston, MA (Remote)
Senior Business Analyst, FICC trading
11/2021 – 8/2022
Analyzed CFD (Central Funding Desk) back-to-back trades workflow and drafted Business Functional Specifications of risk transfer between BAC and BANA through back-to-back booking of B2B trades.
Performed data fields mapping between Pioneer (front-end trading system) and Vmaster (back-end repository) for swaps STP (Straight-Through Processing) workflow.
Analyzed and documented multiple trading venues/ECNs, mapped and derived venue IDs based ECN, asset class, trading desk and LOB (Line of Business).
Managed Agile sprints, backlogs in JIRA and user story release process in Remedy.
Charles Schwab Corporation Boston, MA (Remote)
Business Analyst, Managed Accounts
02/2021 – 11/2021
Analyzed DI (Direct Indexing) product features and documented solutions to incorporate DI product into VM (Vestmark) as Investment Book of Record.
End-to-end configured and tested order routing, execution and messaging between CRD (Charles River Development) and Vestmark.
Analyzed end data points and reconciled cash, position and tax lots between Vestmark and custodian.
Streamlined the production and delivery of taxable and non-taxable data extracts to ensure proper reconciliation is done before each business day’s trading starts.
UAT-tested cash withdrawal, security deposit and mutual funds trading for Direct Indexing accounts so that proper operation work flow is in place to ensure integrity and accuracy.
Bank of America New York, NY
Senior Business Analyst, Market Risk
04/19 – 11/2020
Analyzed existing MRS (Market Risk Suite) system data processing workflow and loaded time-series data feeds into MRS and ensured data availability with integrity and completeness.
Analyzed and tested customized VAR computation in MRS for different business and product groups based on Virtual Hierarchy (VH).
Performed UAT testing on SOFR (Secured Over-night Financing Rate) futures, compared them with OIS-based instruments and documented the results.
Prepared, validated, and loaded data for FVA-C (Funding Value Adjustment-Collateralized) UAT testing, documented results and reconciled with non-collateralized results.
State Street Bank & Trust LLC Boston, MA
Senior Business Analyst
09/17 – 12/18
Identified, analyzed, and documented ALGO IRS data requirements for the calculation of VAR.
Performed data GAP analysis between what are required by ALGO and what out-of-box Calypso can provide.
Documented IRS and collateral data fields mapping and transformation rules between Calypso and RDR.
Drafted Calypso ALGO IRS position and collateral data extract use case.
Manulife Financial Inc. Boston, MA
Senior Business Analyst
05/15 – 08/17
Documented Functional Specifications for Findur to accommodate OTC derivatives (USD/HKD Quanto
Option) trading.
UAT tested and documented OIS-pricing model for Collateral Management Report in Findur.
Diagnosed and resolved issues with mark-to-market calculation in Variable Annuity Hedging Sensitivity Report.
Created, UAT tested and deployed Variable Annuity Hedge portfolio daily activity report.
Investigated and corrected variances and missing trades in Options Expiration report.
Bank of America New York, NY
Senior Business Analyst
03/14 – 01/15
Analyzed risk data reconciliation workflow between front office systems and middle office risk/pricing engines for BOA’s OTC derivatives trading business.
Identified and analyzed daily OTC derivatives i.e. Caps/Floors, Swaptions and FX Options Trade Population (TP), Master Agreement ID (MID) and Mark to Market (MTM) breaks and provided reports for front and mid offices to address them.
Classified and assigned reason codes for individual Master ID and Mark-to-Market recon breaks in Excel spreadsheet, uploaded the spreadsheet into Risk Data Validation Studio (RDV).
Systems and Tools
Trading Charles River, Findur (Version10 & 14), Calypso (Version11.1, SP5), Vestmark
Tools Toad, SQL Navigator, MATLAB, MS Office, Visio, JIRA, Remedy
Database Oracle, SQL Server
Education
University of Toronto
Bachelor (Honors) of Science -- Math & Computer Science
Kent State University
Master’s in Mathematical Finance
Contact this candidate