Data Analyst Financial

STACEY COOK Cell: 949-***-**** Email: ******.****@*****.***

SUMMARY

Dynamic and highly skilled Data Analyst, Mortgage Banking, Servicing Transfers, Mortgage Analyst, Treasury Expert in various sectors within the Financial Services. Extensive writing background as a Subject Matter Expert (SME) in treasury, banking, servicing, and originations. Diverse experience in collaborating and working with various levels of personnel and departments. Seeking a position that offers professional growth and innovative opportunities.

PROFESSIONAL EXPERIENCE

TEKsystems, Inc. – Irving, TX 07/17 - 3/20

Systems/Data Analyst (2018 – 2020/Fidelity Investments)

Data mapping for 401k data conversions from external sources translating to Data Element Listing templates for programmers

Projects involved working with external / internal sources, performing analysis and adhere to strict conversion deadlines

Project billing / workflow processes / understanding business processes

Business Analyst III (2017 – 2018/Bank of America)

Translate database and system technical descriptions of complex permission rights into user friendly stories provided by business owners for a global bank

Home Point Financial (AKA Stonegate Mortgage Company) – Dallas, TX 05/16 - 06/17

Investor Reporting Analyst

Investor reporting for private investors and corporate warehouse investors/ Reconciled bank accounts P&I / T&I

Monthly management metric reports (Bank Aging Summary, KPI’s, IR QC & GSE Audits)

Developed Job aide documentations and process flow written in user friendly terminology for Investor Reporting team

Nationstar Mortgage Company – Lewisville, TX

Sr. Loan On-Boarding Analyst / Mortgage Analyst 11/13 - 04/16

Performed on-boarding data servicing transfers for agency and private investor prelim to final from prior servicers

Ascertained seller/servicer loan data for pre/post boarding to system of record according to project plans/mapping/Vlookup

Manage audits for all GSE (FNMA/FHLMC/GNMA) bank account setup, bank ratings, forms, SOX controls

Responsible for investor header setup for servicing transfers for GSE reporting, banking, and treasury services

Accomplished 145K loan boarding from pre/post for a major private bank investor successfully without any holdups.

Wilks Brothers, LLC – Cisco, TX 04/13 - 08/13

Securities Accountant – Reconciled daily trade securities. Rate of Returns Restructure Project. 1099B Reconciliation Project

Bank of America - Fort Worth, TX 02/12 - 04/13

Investor Reporting Accountant II

Responsible for over 200 mortgage servicing loan portfolios reconciliations to Trustee and Master Servicing.

Financial analysis of mortgage loans for reporting to investors / investor reporting research

Integrity Staffing Solutions / JP Morgan Chase - Dallas, TX 06/11 - 11/11

Securities Trade Reconciler

Contractor – Reconcile Trades/Securities/ Hedge Funds to appropriate internal controls / Reconcile cash accounts for default loans

Volunteer Work- various Special Needs Charities / Food Banks- Plano, TX 12/10 - 12/11

Prudential Asset Resources – Dallas, TX 09/07 - 11/10

Senior Accountant I / Assistant Manager Treasury Operations

* Manage monthly and daily P&I / T&I bank reconciliations for 60 bank accounts

Reconcile daily service fees for corporate GL, JE, wires / JE Third Party Portfolios / servicing agreements compliance

Oversee daily Treasury operations for wires, ACH, EFT, Posi-Pay, checks, lockbox and bank balances

Project Manager automation wire upload process for external banking functions to Federal Reserve file format data mapping

Managed international office for wires, invoice payments, banking operations, training, and writing procedures

Achievements: Implemented manual wires to upload encrypted file process to external bank for Treasury Department (Phase I) Investor Reporting (Phase II). Project Lead for international treasury services for wires. Liaison for BCP process, procedures, and UAT. Used technical and analytical skills to implement low risk exposure and overall higher productivity for global risk management. Comprehensive concepts of cash movements including accounting systems. Requirement gathering and project billing. Researched treasury services for international wire process for testing, data mapping for wires/payroll/invoices.

STACEY COOK Page 2

Corestaff Services - Contractor: Great West Life Denver, CO Investment Portfolio Accountant 04/06 - 09/07

Monthly reconciliations of 45 investment portfolios, investment assets, rollovers, bank reconciliations, post cash, Bloomberg

NAV / Financials / Monthly close process

Achievements: Attained Lead Assistant for Investment Portfolio Group due to expertise of mortgage and secondary marketing experience.

NextGen Inc. – Contractor: Aurora Loan Services Englewood, CO Financial Analyst 01/06 – 03/06

Data analytics reporting for residential loan production and loan officer production to Senior Vice President

Stonecreek Funding Corporation – Denver, CO 08/05 – 03/06

Treasury Analyst

Treasury operations for Warehouse Banking facilities ($150MM). Provided cash flow analysis / hedging pipeline

Managed all wires related to funding or purchases and reconciliations

Responsible for E&O, Fidelity Bond Insurance / General Liability / Audits / Forced Place Insurance processes

Supported creation of warehouse contracts & annual recertification / sub-servicing contracts related to the Hurricane Katrina disaster. Assisted risk management for FEMA to minimize financial losses to due to Katrina

CBSK Financial Group, Inc. DBA American Home Loans – Santa Ana, CA 01/05 – 08/05

Risk Management Analyst / Trade Transaction Coordinator/Originations

Treasury operations for multiple Warehouse Banking Lines ($100MM+) & banking covenants

Secondary Marketing execution for loan sales – whole / bulk (Non-GSE) / loan due diligence to Sellers

Seller coordinator for correspondent lending / oversee compliance for warehouse banking, investor regulations

Responsible for accounting operations (JE/GL) for Secondary Marketing funding, purchase and escrow transactions

Homefield Financial, Inc. – Irvine, CA 12/02 – 01/05

Risk Management Analyst /Treasury / Seller/ Trade Correspondent/Originations/Compliance

Responsible for finalizing all loan trade deals, execution, bids, hedging pipeline, purchases and credit facility

Risk management for secondary marketing / correspondent lending / securitizations/Treasury operations

Responsible for corporate due diligence, compliance for lending, credit facility covenants and agency regulations

Project manager for MERS integration to LOS System, ACCESS DB and warehouse lenders into production requiring extensive data mapping. Project lead fund data mapping to banking facility. Trainer and procedure writer for banking and funding apps

Integrated new warehouse lenders coordinated technical integration and operational training/ treasury services

Achievements: Project Leader for MERS/ Funding Automation. Secondary Marketing skills along with effective relationship building skills increased profitability over 50%. Company received highest quality rating and compliance with the State of CA DOC due to expertise of treasury banking compliance and services.

TECHNICAL EXPERIENCE

Software: Treasury Applications (CashPro, Smart), Microsoft Excel/Word, VISO, Oracle, Lawson, PAM, CICS, FISERV, ALLTEL (MSP Related) LSAMS, FICS, Strategy

EDUCATION, CERTIFICATIONS & MEMBERSHIPS

Associate of Arts: Humanities: Anchorage Junior College, Anchorage, AK

Business Accounting: Delta Junior College, Stockton, CA

English& Business: Vanguard University, Costa Mesa, CA

CERTIFIED: * Commercial Mortgage Servicing Level 1 / 2 * Communication Courses (Leadership)

MEMBER: * Association Financial Professionals * LinkedIn Banking International and Finance

* 627 Cowboys Parkway #1011, Irving, TX 75063 *

Contact this candidate