Data Analyst Financial
Resume:
ELLEN S. WONG
Roslyn Heights, New York 11577
917-***-**** (Mobile)
*********@*****.***
OBJECTIVE To obtain a position in the financial community where my work experience and technology capabilities are utilized. EXPERIENCE
Bank of America Merrill Lynch, New York, New York
Regulatory Reporting/Compliance August 2015 – August 2019
Responsible for daily lock up of 15c3-3 customer/PAB reserve computations
Contribute to monthly trending and analytical reporting related to 15c3-3/PAB customer reserve computations (Client Protection Rules)
Key Compliance contact for SEC Rule 17A-5 related queries
Oversee process, risk and controls and integrate roles and responsibilities into policies and procedures to mitigate risk
Support standardization of data framework components (e.g. Authoritative Sourcing, Lineage, Metadata & Dictionary, Issue Management, Attestations & Controls)
Work with internal and external auditors on Regulatory Reporting/Compliance exams and any necessary remediation work
Assist with FINRA and other Regulator examinations and inquiries
Lead on Special Projects and cross training of new employees The Bank of Tokyo-Mitsubishi UFJ, Ltd., New York, New York Comptrollers/Regulatory Reporting Department March 2011 – August 2015
Project work specific to Project Hudson: writing business requirement documents, testing (DUT, SIT, UAT) specific to Regulatory Reporting requirements, CDL (Central Directory Layer) Redesign, Datawarehouse Enhancement, Genesis/Fixed Income, Core Banking System upgrade, REG- Reporter Tool upgrade/replacement
Responsible for preparing the FFIEC 002 Foreign Branch Call Report, FFIEC 009/009A/019 Country Exposure Report, FFIEC 031 BTMUT Call Report, forms specific to the Head Office US GAAP Package
Created procedure manuals to guide the preparation of Head Office and regulatory reports
Served as Administrator for the Lombard Risk REG-Reporter software tool used in the regulatory reporting process through mapping, data clean-up, testing, reconciliation, maintaining the transformation processes and coordinating with IT the installation of Maintenance Releases and other updates to the REG-Reporter software
Business Content Publisher (BCP) for RRD website on Prism/SharePoint (Moss2010)
Provided technical guidance/support to Regulatory Reporting Department J.P. Morgan Chase, New York, New York
IB Credit Risk Reporting September 2008 – April 2010
Streamlined and automated processes utilizing MS Excel and MS Access to eliminate potential mistakes and enhance department productivity by reducing employees’ work hours
Responsible for providing data and analytical reporting to IB Credit Risk and Senior Management in addition to crisis reporting
Prepared ad hoc reports, including presentations, for senior management Bear, Stearns & Co., Inc., Brooklyn, New York
Controllers/Regulatory Reporting November 2006 – September 2008
Responsible for data mining and aggregation of accounting and other financial data in support of the firm’s regulatory reporting obligations (e.g. SEC FOCUS, Consolidated Supervised Entity reports and Federal Reserve Treasury International Capital system reports)
Created and developed monthly production reporting, ad hoc requests and Regulatory department automation initiatives
Worked closely with Agent Lenders and Bear Stearns Stock Loan Department to resolve any/all ALDOP contract/collateral breaks utilizing Sunguard
Supervised rotating Controller’s analysts in daily, weekly and monthly tasks
Provided sole technical support to Controllers Regulatory Reporting and Futures Accounting Swiss Reinsurance Financial Services Corporation, New York, New York Operational Risk Management May 2002-November 2006
Responsible for publishing Financial Services Monthly Operational Risk Report (FS MORR) on Swiss Re intranet
Provided support for bi-annual Financial Services Operational Risk Report (FS ORR) by compiling all Business Unit data on a timely basis to create charts/graphs for analytical purposes of entire Financial Services business
Administrator for SOX Express tool (developed by OpenPages)
Knowledge expert for ORMIS (Operational Risk Management Information System) tool
Supported creation and development of Key Risk Indicator (KRI) report for Asset Management
Worked on ad-hoc reports/projects
Financial Data Analyst
Prepared and conducted cross-functional training as a result of application development or software enhancements
Continued to further streamline Finance reporting and analysis processes, in particular via automation using Business Objects, Access and/or Excel expertise utilizing macros, templates or manipulating underlying SQL codes, thereby enhancing time efficiency
Created and developed datamarts via DB2 development platform for quicker turnaround time of reporting results and archiving historical data on a going forward basis
Detailed documentation and/or workflow charting of all processes to adhere to Sarbanes-Oxley (SOX) Act
Created and engineered specifications for front-end of Integrated Accounting Facility (IAF), in-house account booking system
Performed User Acceptance Testing (UAT) on integrated Accounting, Claims, and Underwriting systems
Supported usage of the Divisional Data Warehouse, with a focus on the Cascade report system and its associated quality control mechanisms Goldman, Sachs & Co., New York, New York
Investment Banking Division June 2000-June 2001
Primary function was to provide informational and quantitative research support to all industry sectors of the Investment Banking Division
Responsible for researching, analyzing, and/or preparing current and historical financial and economic data for presentations or pitch books for further analysis
Conducted information searches using various research methods including on-line services and/or referencing sources such as CDA, SDC, and FactSet
Developed complex charting, league tables and ownership runs with results from data queries
Performed regression analysis
Quantitative research and operation in all financial data application EDUCATION
St. John’s University Jamaica, New York
Bachelor of Science in Finance, September 2000
LANGUAGE Fluent in Cantonese
SKILLS Extensive knowledge of :
Business Objects Bloomberg Comshare/Essbase Datawarehouse Essbase FactSet Internet tools Lotus Notes MS Access MS Excel MS Power Point MS Query MS Word OBIEE QMF for DB2 RegReporter SDC Sharepoint SQL for DB2 SQL for Oracle Sunguard Thomson Financial TOAD for Oracle Visual Basic Web Publishing INTERESTS Traveling, Classical Music, Arts, Tennis and Volleyball
Contact this candidate