Post Job Free

Resume

Sign in

Financial Analyst Data

Location:
Toronto, ON, Canada
Posted:
January 14, 2019

Contact this candidate

Resume:

Eileen Chen, MSc

Phone: 416-***-****

Email: ac77df@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Over 4 years of project experience in business analysis with proven results of implementing successful initiatives across industries

Expertise in data analytics, gap analysis, end-to-end data lineage, and process mapping, UAT, and BRD elicitation

Solid working experience with fixed income, derivatives, equity, precious and base metals

Hands-on experience in Financial Reporting, Risk P&L Attribution, VaR and SVaR, and Data Analytics

Proficient in SQL, MATLAB, Python, Excel – VBA, Access DB, Visio, Bloomberg, Murex, Calypso

Outstanding presentation skills in negotiating differences in opinion and charting collaborative plans of action

FRM part I; FRM part II

WORK EXPERIENCE

Niagara Capital Partners - Friedberg Mercantile Group Ltd. Toronto, ON Investment Risk Reporting (Part Time) Jul 2018 - Dec 2018

• Preformed function testing within Investment Risk and priorities of analytical daily trading products position, research, source and analytical manage risk data

• Integrated risk analytics to support the Investment Risk’s mandate, analyses various daily risk data measures and provided analysis for new investments

• Conducted in process reviews and audit in accordance with trading risk standards and/or propose initiatives to improve more efficiency in business support

• Executed on ad-hoc analyses base on required conditions by management and working closing with trading business management, market risk control and IT team

RBC Toronto, ON

Derivatives Business Analyst Oct 2017 - Mar 2018

• Acted as SME in Derivatives daily operations process management; provide timely response to inquiries and effective issue resolution; ensure that data in market risk feeds including IPV feeds are accurate and where appropriate, manual adjustments are applied based on investigation results with proper documentation

• Executed on CC&L to Murex commodity swaps and options migration with thorough gap analysis, process mapping, and complete set of QA/UAT testing cases

• Proactively manage various projects with capital market products such as Swap Merge from start to finish, including facilitating discussion regarding the development of new reporting models and/or enhancement of existing reports with all stakeholders, recommending reporting design for application efficiency and accuracy after assessing derivatives features & business requirements, finalizing BRD scope, A&L and testing requirements

• Conducted ongoing risk data quality review for all capital market data sources; document and maintain procedures for verifying process design, implementation, and modelling methodologies meets business and market standards

• Provided cross-training sessions to business clients with clear and concise information; participate in other ad-hoc project such as code testing for system upgrade

SCOTIABANK Toronto, ON

Consultant-Financial Analyst, Precious Metals (Contract) Mar 2017 - Jun 2017

• Led reporting analyst in Capital Market and Base Metal business line; acted as SME in liaising with downstream stakeholders to ensure P&L accuracy; provided leadership in month-end reporting (GL reconciliation, trade order and settlement)

• Led the design and development of Trade Confirmation Tracker; elicited business requirement from downstream clients and established new centralized reporting infrastructure that merged SQL with Access database to enhance reporting efficiency

• Delivered daily London Precious Metal trade balance (opening, closing) reporting and weekly portfolio-wide commodity reporting; monitored Murex system booking on new deals and liaised with TFRM, Product Control, and RMIT to resolve discrepancy in timely manner

• Collaborated and developed close working relationship with Capital Market and Front office stakeholders to resolve ad hoc issues, including trader orders, amendments, balance confirmation, cash settlement, funding, and GMIS reporting

• Conducted gap analysis and provided UAT scenarios and validation in support of new system initiatives with Risk IT team Eileen Chen, MSc

Phone: 416-***-****

Email: ac77df@r.postjobfree.com

• Developed VBA tools (embedded Vlookup and Pivot functions) to automate reporting consolidation, data massage, and ETL process; Provided ad hoc support to query Mocatta transfer data, updated hierarchy mapping in Murex, request for book closing SCOTIABANK, GLOBAL BANKING AND MARKETS Toronto, ON Product Control Analyst (Contract) Oct 2016 - Nov 2016

• Delivered daily P&L reports for Scotia Mocatta Base Metals transits with corresponding P&L commentary; ensured daily reported P&L, APAR, interest income and expenses are reconciled to the general ledger accounts

• Calculated price volatility across asset classes, ensured reported results reconcile with the Murex system and interpreted price movements factors from Capital Market to Front Office

• Proactively involved in multiple projects to improve Murex process efficiency; utilized expertise in programing ability to develop VBA automations for month-end reporting, reconciliations, and account payable entries posting

• Worked closely with Front Office and IT teams, and provided cross training and problem solving for new systems CIDO RESEARCH LTD. Toronto, ON

Market Research Analyst Feb 2016 - Oct 2016

Facilitated interviews to understand investment behaviour and provided investment strategies consultancy to HNWI investors, primarily from BMO and HSBC mutual fund and ETF fund investors

Reviewed investment account statement, charted portfolio performance trend, and analyzed investment behaviors

Processed over $2 million per week of different HNW Fund projects and worked closely with senior management to prepare market research reports and provide suggestions to enhance clients’ investment strategies

Conducted data ETL through MS SQL; performed data analysis and manipulation using SAS to summarize investment trend; communicated with clients to gather and elicit requirements and delivered resolution in timely manner TORONTO COMMUNITY & CULTURE CENTER Toronto, ON

Associate Accountant Jul 2014 - Nov 2015

Investigated projects gain/loss and pricing variances by building Excel-based model to manage and analyze financial data, and escalated any issues regarding budgeting, financial and accounting discrepancies

Developed Access database and macro automations to manage financial data and to calculate project-based budgeting reports

Proceeded month-end journal entries by over 2000 accounting transactions with 100% accuracy, prepared G/L reconciliations and generated financial statements reporting ahead of deadline BARCLAYS BANK Luton, UK

Financial Analyst (Co-op) Feb 2013 - Jun 2013

Documented business BRD for Barclays Basel II reporting infrastructure upgrade, including implementation process flow (as-is and to-be) on MS Visio, gap analysis, success criteria, data mapping, and UAT test scenarios

Conducted analysis and liaised with IT team in data sourcing, data standardization, and validation on Basel II minimum capital requirement, Value at Risk (VaR) and Stress VaR models

Performed back-testing on MATLAB using historical simulation; validated risk exposure against corresponding costs to optimize capital structure

Enhanced testing process streamline; developed regression automation and improved UAT process efficiency over 60% EDUCATION

Enterprise Risk Management, University of Toronto, Toronto, Canada 2018 MSc in Finance and Business Management, University of Bedfordshire, Luton, England 2012 - 2013

Relevant Courses: Financial Analysis, Data Analysis and Financial Modeling, Financial Reporting BSc in Computer Science, JiMei University, Xiamen, China 2006 - 2009 REFERENCE

Available upon request



Contact this candidate