Business Analyst Data Quality

Jaime McKenzie

**** ****** ****** ****, *********, NC; Mobile: 347-***-****; Email: adzzs5@r.postjobfree.com

Keywords

Business Analyst, Financial Analyst, Foreign Exchange, SWIFT Payments, Trade Support, Capital Markets, Compensation, Reconciliation, International Business, E-Commerce, Online Business Banking, SQL, Fed Wires, Compliance, CCAR, UAT Testing, Stress Testing, Governance, Controls, Data Quality, Data Manipulation and Transfiguration, Sharepoint, JIRA

Relevant Experience

Wells Fargo & Co., Charlotte, NC (8/2018–1/2019 - Consulting thru Insight Global; Became FTE in 1/2019 - Present)

Business Analyst – Reconciliations and Control Wealth Management Department

. Verify/Validate data points and quality of counterparty inputs supplied to the bank by an outside vendor.

. Assist Corporate Treasury with various stages concerning calculating the bank’s capital requirements.

. Stress Testing of Reconciliation Projects from a UAT Environment to validating for Production

. Supports various stakeholder projects.

. Maintained Daily BAUs for Business Units and implemented improvements of Controls for efficiency

. Continued knowledge of banking credit risk, research, and analytics

. Ran SQL queries to facilitate data quality, analysis and reporting

. Communicated data quality issues to the IT department during various stages of the change process

. Monitor and Governed daily, weekly and monthly reporting for Business Units

. Updated Yearly procedures and attested the validity of the process and tool’s activity

. Informed, Updated, Recorded and Archived all activities by use of JIRA and Sharepoint

. Maintained and Controlled daily.Data Quality and Maintenance by Minimizing Risk Management with internal platforms

. Monthly Quarterly Regulatory Reporting and attestations for governed wholesale accounts

Bank of America, Charlotte, NC (8/2017 -5/2018) / Consulting thru Ettain Group

Business Analyst V– Counterparty Integrity Management

. Compliance Analytics which consist of supporting computer software applications Governance Deliverables.

. Deliverables include but are not limited to System Control Plans, System Technical Recovery Plans, System Access.

. Acted as a central point of contact for data quality remediation items related to all products

. Reviews, Security Stress Testing, Quarterly Certification and Remediation

. Performed in depth analysis of Bonds, Equity and Derivatives data to identify and report data quality issues.

. Support requests from Audit for internal testing and OCC Exams as well as Information Security assessments.

. Acted as a central point of contact for data quality remediation items related to all products.

. Informed, Updated, Recorded and Archived all activities by use of Sharepoint

. Monthly Quarterly Regulatory Reporting and attestations for governed wholesale accounts

Wells Fargo & Co., Charlotte, NC (4/2016 – 2/2017) / Consulting thru Signature Consulting

Financial Consultant V– Counterparty Integrity Management

. Verify/Validate data points and quality of counterparty inputs supplied to the bank by an outside vendor

. Assist corporate treasury with various stages concerning calculating the bank’s capital requirements

. Supports various stakeholder projects

. Continued knowledge of banking credit risk, research, and analytics

Wells Fargo & Co., Charlotte, NC (8/2015 - 1/2016) / Consulting thru Aerotek Corporation

Market Risk Consultant – Counterparty Credit Risk Management

. Composed 6 written Business Stories for Risk Management Products to be reviewed and approved by Business Management for current and future stress testing needs.

. Business Stories were later presented to Technical Analytics, Developers and Regulatory groups or further comprehension and implementation of a newer system called NextGen

. Leadership role in assisting Management to develop a newer format of writing prototype format of Business Stories for better understanding and representation to Upper Management

. Excelled in being a liaison between Technical Analytical Team and Treasury Department ensuring all CCAR regulatory standards and rules were being observed and maintained

. Informed, Updated, Recorded and Archived all activities by use of JIRA and Sharepoint

LPL Financial, Charlotte, NC (5/2015 - 7/2015) / Consulting thru Talent Bridge

Compliance Analyst – Compliance Department

. Took lead role in several projects which was assisting management of other departments in organizing and truncating their overall backlog of workload

. Lead several projects in directing workflow and reaching goal objectives

. Excelled in management of time sensitive projects

Bank of America Corporation, Charlotte, NC (2/2013 - 4/2014)

Officer, Senior Derivatives Analyst, Team Lead – CashPro FX Trading Platform

. Managed and developed a staff of three in the area of Foreign Exchange and FXOnline Trading Platform

. Successfully transcended Online Platform from the Concord, CA office to Charlotte Desk with seamless precision Leadership role in Straight Through Processing (STP) Initiative transitioning clients from their manual settlements prospective onto STP platform through stress testing, modeling and analytical review

. Gathered data from Team and presented information to the Technical Analysis team for improvements thru Excelled based Business Stories for weekly reporting

Wells Fargo Corporation / Wachovia Securities, Charlotte, NC (8/2007-11/2012)

Foreign Exchange Analyst – Charlotte Corporate Trading Desk

. Working third shift with an assistant to support 8 Hong Kong Money Marketers with confirmations, allocations, payment processing and settlements of currency transactions.

movements.

Non-deliverable forwards.

Worked within a Trade Support role monitoring Risk Analysis for High Profiled Client Accounts for the Corporate Trading Desk and assisting their day to day needs for Foreign Exchange Online (FXOL).

Stress Testing all clients transitioning them from FXOL to FXOL 2.0

. Gathered data from Triage Call Center for customer suggestions for upgrade, experience and customization requests within UAT environment

. Hybrid role of SQL Analysis creating programs and analysis reporting through modeling validation

Lehman Brothers Inc., Jersey City, NJ, (6/2001-5/2006)

Senior Financial Analyst - London Trading Desk

. Supported 20 London traders with confirmations, allocations and settlements of currency transactions

accounts

banks

positions

transactions

Morgan Stanley Dean Witter New York, NY (7/1999-2/2001)

Financial Analyst – Foreign Exchange Trade Support

. Monitored the retrieval of compensation losses due to failed trades

exposures

Credit Risk exposures

accounts

Union Bank of Switzerland, New York, NY, (9/1996-7/1999)

Senior Control Clerk – FX Control

. Analyzed and processed all foreign exchange SWIFT payments and US dollar claims placed against bank

Cases branches for SWIFT payments volumes and exposures

Bear Stearns Inc., Brooklyn, NY, (2/1994 - 9/1996)

Manager Trainee – International Department

. Responsible for the proper allocation of foreign exchange and US dollar trades and transactions via SWIFT payments

loans

metals

banks.

areas.

accounts.

accounting

Education

SQL Certification from Central Piedmont Community College, Charlotte, NC 8/2018

Associates Degree in dual major of Economics and International Business; GPA-3.2

Temple University, Philadelphia, PA; 5/1993

Skills

. SQL . EXCEL

. ACCESS . BLOOMBERG

. FXALL . FX CONNECT

. CCAR . CROSSMAR (CMS)

. EXCHANGE TRADING /CLEARING HOUSE PRODUCTS . REUTERS

. TRAM . NETSCAPE EXPLORER

SWIFT . CURRENCY LINKED SYSTEMS

. MISYS . PC LAN ACCOUNTING

Affiliations and Community Service

St. Matthews - Rite of Christian Initiation for Adults Member, Christian Doctrine teacher

Delta Sigma Pi – Community Service Board Member

Urban Bankers Coalition – Scholarship Committee Member, Tutorial Program Participant

Contact this candidate