Data Management
Resume:
Wai Cheung (Donny) Yau
Brooklyn N.Y. 11214
Tel: 917-***-****
Email ******@*****.***
Professional Summary
•6 years of comprehensive business analysis / data analysis experience within financial services as well as formal training.
•10+ years of total experience working with general ledger, financial reporting, securities (fixed income, equity, derivatives), corporate & core banking.
•Experience includes Front to Back office, equity, fix income, ETL, data modeling, trade capturing process, stakeholder analysis, requirements definition and management, reference data, data governance, data mapping, data warehousing, wireframes, stress testing, interface architecture, AML, KYC, Gap and Impact Analysis, Agile, Full SDLC, BRD, FRD, UAT and user training manuals.
•Microsoft Excel, Visio, PowerPoint, Word, Project, Access, SQL Server, Charles River 9.0, and Simcorp.
•Excellent verbal/written communication, organization, graphical and quantitative modeling, documentation and presentation skills.
WORK EXPERIENCE
Feb 2016 – Present Bank of America. New York, N.Y.
P&S Reporting
•Maintained the data integrity, validation, queries, extraction, manipulation, processing, analysis and storage in Master Reference (SQL) database.
•Provide input into developing and modifying systems to meet group needs and develop business specifications to the support these modifications.
•IT interface for the new income trading business unit located in US.
•Provide day to day support to traders for the trading applications and general systems support
•Identifying Process Patterns, Developing Process Workflows, Process Transformation, and Gap and Impact Analysis to improve efficiencies
•Worked in a cross functional team of Business, Architects and Developers to implement new features
•Documented detailed process flows, business process re-engineering analysis and design, extracting business rules from existing computer applications/systems.
•Implementation of legacy system upgrades extensive requirements gathering, data analysis, data modeling, spec development, change management, traceability and impact Analysis.
July 2007 – Nov. 2015 Macquarie Corporate Bank, Ltd. New York, N.Y.
Macquarie Fund Group.
•Provided trade execution and settlement support for Capital Markets and Fix Income products via direct communications in FIX system with foreign brokers and settlement agents.
•Assisted in validating and generating month end information necessary for produce net asset values for funds as well as weekly performance and market risk estimates.
•Mapped a complete end-to-end pricing data and trade flow.
•Updated and maintained accurate portfolio values by performing monthly transaction, asset position, market value, market risk, pricing, and cash reconciliations on excel spread sheets using V-lookup and VBA macros.
•Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
•Full lifecycle implementation, requirements gathering, and preparation for a comprehensive Charles River 9.0 and SimCorp development project includes collaboration with numerous stakeholder groups, creation of data map for reporting definition, consolidation of data libraries, and integration with other systems / projects.
•Extensive data analysis for client reference data warehousing, translated disparate system data into cohesive business intelligence.
•Developed user acceptance test plans in functional terms that can easily
be understood by end users of systems.
Feb. 2005 – July 2007 Mizuho Corporate Bank, Ltd. Jersey City, N.J.
Global Transaction Services.
•Resolve trade discrepancies and settlement problems between GSS, DTC,
and Trust 3000 systems.
•Assist associates and executives in identifying and mitigating various
corporate actions and settlement risks.
•Validate pricing and settlement of various corporate and government coupons
in all of the firm’s holdings.
•Prepare various operations reports for management analysis.
•Provided various trade allocations to corporate, government coupons,
and structure notes.
April 2000 - Sept 2004 Schroder Investment Management, Hong Kong, China.
Mar. 2002 – Sept. 2004 U.S. Domestic Trade Desk
•Processed and calculated foreign exchange rates.
•Achieved optimal trade execution and problem solving throughout fund traders, brokers, and clients.
•Responsible for trade processing, rate setting, pricing reports, confirmation
of trades, and P&L reports.
•Processed daily derivatives, fixed income, foreign and domestic trades into
Open Trader and Portia systems.
Schroder Investment Management, New York, N.Y.
April 2000 – Mar. 2002 Equity/ Fixed Income Trade Desk
•Analyzed periodical Pricing, Gains and Loss reports.
•Resolved daily trade discrepancies and settlement problems between
Oasis and Portia trade systems.
•Allocated various trades in Prime broker and swap accounts.
•Participated in daily trade transactions for domestic, equity and fixed income
accounts at a net worth of $5 billion dollars.
Jan. 1999 – April 2000 Tag Associates, New York, N.Y.
Portfolio Management Group. Associate.
•Assisted in managing portfolio assets of over $536 million dollars.
•Reconciled fund accounts in Advent and in DTC systems.
•Managed multiple account holdings of mbs, government, corporate bonds,
and structure notes.
•Validated status reports and performed calculations to verify and monitor
client accounts.
EDUCATION
Sept. 2007 to Present New York University, New York, NY
Master of Business Administration - in Finance and Accounting
Sept. 1995 to June 1999 St. John’s University, Jamaica, NY
Bachelor of Science - Computer Science and Criminal Justice
Cumulative GPA: 3.5 out of 4.0 Major GPA: 3.75 out of 4.0
COMPUTER SKILLS Microsoft Access, Office, Word, Word Perfect, Excel, Power Point, SQL,
Advent Axys, Moxy, ADP, Charles River, Lotus 1,2,3, Lotus Notes, Open Trader,
Oasis, Paradox 7.0, Pads, Portia, Reuters, Scribe, SEI, Sim Corp, FIX, Swift, GSS,
Bloomberg and Internet Systems.
LANGUAGES Fluent in Chinese (Cantonese and Mandarin)
REFERENCES Furnished upon request.
Contact this candidate