Post Job Free

Resume

Sign in

Investor Accounting/Reporting Analyst

Location:
Irving, TX
Posted:
February 16, 2015

Contact this candidate

Resume:

Sharon Rutherford

**** ********* ***** **** #****

Grapevine, TX 76051

972-***-**** Hm / Cell

acoccm@r.postjobfree.com

CAREER OBJECTIVE

Strong reconciliation experience in GSE and Private Investor Custodial bank

accounts. Recognized as a top performer with consistent track record of

meeting deadlines and exceeding expectations. Seeking a challenging

position with a progressive company.

Nationstar Mortgage, Lewisville, TX

Jul 13 - Present

Investor Accounting - Bank Recon Analyst

* Reconcile complex GSE & Private P&I and T&I custodial accounts according

to Investor and Department guidelines. Perform analysis using Test of

Expected Cash reviews on Scheduled/Scheduled, Scheduled/Actual and

Actual/Actual custodial accounts. Reconcile GL Accounts and research for

Root Cause analysis. Actively work with Investor Reporting to

identify custodial account outages, Test of Cash discrepancies created by

loan modifications, liquidations, Arm changes, BK cramdowns, wire errors,

etc.

* Work with team members to look for new ways to streamline the

reconciliation process, such as system enhancements or process flow

changes. Be proactive in identifying recurring problems and offer

solutions as to how the problems can be eliminated.

* Follow strict adherence to the Agency and Private Investor Servicing

Agreements, Regulatory requirements, departmental guidelines.

* Clear reconciling items within 90 days from point of identification and

reconcile accounts within 30 calendar days.

* Perform Root Cause Research and Analysis of exception items for loan

modifications, liquidations, paid offs, claims, pool to security

differences, corporate advances, loan acquisitions and service

releases.

* Meet monthly production and quality scorecard quotas as mandated by

production management.

Project Consultant - Bank of America, & First United Bank

Oct 12 - Jan 13

Foreclosure Project - Bank of America (OCC Consent Order for Foreclosed

Loans)

* Conduct a comprehensive review of foreclosures that were in process or

completed in 2009.

* Identify financial injury to borrowers that resulted from errors,

misrepresentations, and other deficiencies in the foreclosure process.

* Reviewed foreclosed loan files of certain events, conditions, and

circumstances leading up to the decision to foreclose on the property.

* Review all state, investor, and market rate guidelines. Determine

whether impermissible Fees remain outstanding or have been paid by the

Borrower.

* Reviewed supporting documentation for participant loan applications and

financial

hardship withdrawals.

* Develop complex program models to extract data and use databases to

provide statistical and financial risk measures.

* Manages a portfolio of delinquent loans by working with loan modification

and disposition specialists to determine solutions that will cure the

account in a timely manner.

* Ensuring processes are clearly defined and properly documented, all

regulations are understood and complied with, change governance is well

executed, and colleagues are engaged and committed to mitigating risks.

*

Bank Reconciliation Project - First United Bank

* Completed monthly reconciliation of Expected Principal and Interest

differences for scheduled-scheduled portfolios.

* Ensured items affecting the custodial bank accounts and general ledgers

were resolved in a timely manner.

* Researched and resolved GNMA out of balance conditions. Performed root

cause analysis of

Exception items for loan modifications, claims, pool to security

differences, corporate advances, loan acquisitions and service

releases.

* Develop new Excel template to meet investor format requirements.

* Research FNMA accepted reports and MSP end of the month reports T653

S214/215, for corrections and explanation of prior shortage/surplus

discrepancies.

* Reconcile FNMA/GNMA 14 months of T & I reconciliations.

JP Morgan Chase

Oct 11 - Oct 12 (JP Morgan Chase, Lewisville, TX)

Sr Ops Specialist - Mortgage Default Loss Analysis- QC

* Perform quality review of Mortgage Loan Loss Analysis and Reconciliation

to include Conventional, 3rd Party, Private, FHA loan types. Determine

Gain/Loss by reviewing MSP system transactions for Sale Proceeds,

Investor Claim Receipts, Escrow Payment/Refunds, Suspense and Corp

Advance. Provide comments/guidance to analyst when Quality Review

results in rejection and return to analyst for rework. Coordinate with

Research Department to reconcile and correct system cash transactions

posted to wrong cost center, department code, or reason code. Determine

accuracy of request to return Investor funds and mortgage write-off

transactions.

* Review validity of vendor billback requests and investor check request

refunds in accordance to Investor Guidelines for FNMA, FHLMC and various

Private institutions.

* Meet daily production and quality scorecard quotas as mandated by

production management. Currently ranked in Top 10% nationwide.

Robert Half Account temps

Jun 11 - Oct 11 (JP Morgan Chase, Arlington, TX)

Analyst - Default Financial Reconciliation

* Perform due diligence and review of borrower, investor and reserve

charges assessed on modification, foreclosure, bankruptcy and

reinstatement of home loans. Classify losses and determine why loss

occurred.

* Validate accuracy of Fund application and expense entries to corporate

advance and escrow accounts. Reclassify corporate advance to recognize

non recoverable losses.

* Reconcile borrower's account in MPS system utilizing macro enabled excel

spreadsheet software. Report data results to management to drive process

improvement.

DFW Accountants PLLC

Mar 11 to Jun 11 - (SKYCHEF, Irving, TX)

Analyst - Unclaimed Property (Internal Audit)

* Perform due diligence and review of state auditor billing ($11M) for

Unclaimed Property Assessments in Delaware and California.

* Audit and re-classified over $1M of AP customer payments "not claimed"

and owed to State.

* Prepare backup/support for 500+ checks designated as unclaimed property.

Perform financial analysis of ledger accounting transactions to provide

support for disputing the auditor's reports. Prepare Summary of document

review and conclusion of audit results & check liability status with

State.

Aerotek (ALEGIS GROUP)

Feb 10 to Oct 10 - Bank Recon SWAT TEAM PROJECT - (AHMSI, Irving, TX)

Investor Accounting Analyst II

* Perform mortgage loan reconciliation for private to include loan

modifications, liquidations, payoffs and foreclosures of existing

investor portfolios.

* Reconciliation process includes identifying cash and non-cash

transactions, researching variances and determining the resolution of all

outages from miscalculations of principal and interest, posted and

trailing adjustments, timing of events and data integrity. Determine

root cause of outages for reporting purposes.

* Cleared over 2500 loan breaks related to modification, liquidation,

payoff and foreclosure.

* Responsible for clearing aged loan outages and completing recon

support/backup for future audit review.

* Developed linked Batch Upload analysis spreadsheet for upload of 30 loan

modification recons into CARD database.

* Performed analysis for Bulk Clearing of like outages, prepare bulk upload

worksheet and supporting documentation.

* Assist in preparation and testing of raw remittance data for new Access

Database built for reconciliation tool.

Accounting Principals

July 09 to Dec 09 Contract - (JP Morgan Chase WSS Headquarters, Dallas)

Financial Analyst

* Perform account reconciliation for Global Billing - Payment Processing

Department to include US, Boston, New Zealand, and Australia GL accounts

(Deferred Credit, IDS-Wire, A/R, Nostro). Perform financial analysis

of transaction movement for Global Payment Processing Centers for Process

improvement. Assist Processing Center Team to clear daily imbalances.

Prepare and upload GL journal entries to correct daily imbalances.

Corrected and cleared 150+ global account imbalances to-date totaling

over 3M in cash applications. Develop Excel financial model for

transaction analysis and movement in multiple GL accounts.

* Responsible for daily senior management reporting of cash imbalance

status. Provide details of daily progress in clearing global account

imbalances. Researched and cleared 200+ cash imbalances on Australia

Wire GL.

* Develop, write new Standard Operating Procedures for ManilaOPS Team to

clear wire accounts and apply client payments accurately.

Thomas Edwards Group

September 07 to October 08 Contract - (Client- Methanex)

Financial Analyst

* Perform billing adjustments (prior 4 years) for client auditors. Develop

new customer contract billing models for prior year invoice adjustment

and reconciliation. Correct formula and data errors on existing Excel

billing models. Full accounting and reporting responsibility for SG & A

functions of North America business unit. Performed budget vs. actual

variance analysis on all GL accounts and reported results to Corporate

Finance in Vancouver. Reconcile inter-company account transactions for

39 business units to sub-ledger balances. Corrected and cleared 530K of

erroneous prior year inter-company balances.

Foundation Systems, Inc.

March 07 to September 07 Contract - (Client Alcatel-Lucent)

Fixed Assets - Analyst

* Reconcile Fixed Asset General Ledger against BU physical inventories.

Develop and maintain Excel Database with Pivot Table Reporting for Fixed

Asset Cycle Counts. Issue mandates for corporate SOX reporting and

Compliance regulations. Compile monthly BU Cycle Count reporting with

statistical results for management. Coordinate BU asset transfers and

disposals for Oracle processing. Reconcile BU accounts for un-located

assets and prepare schedules for reserve journal entries. Maintain and

track monthly cycle count calendar by asset category.

CGI-AMS, Inc.

October 2004 to November 2006

Financial Analyst

* Reconciled 3 years of P & L and Balance Sheet accounts for $120M

Outsourcing Client resulting in 120K expense reduction, 228K Unpaid A/R

collections, 2M Revenue correction, and elimination of 2M WIP balance

* Developed multiple linked Excel workbooks for consolidated financial

reporting requirements.

* Responsible for Annual Budget using Corporate Budget Toolkit and perform

monthly variance analysis to actuals.

* Responsible for Weekly Forecast reporting to project manager and upper

management.

* Full P & L responsibility for PeopleSoft Business Unit Cost Center

financials and reporting to CMO and divisional controller. Prepare and

post PeopleSoft Journal Entries.

* Responsible for preparation of work papers for annual audit by Deloite

and Touche.

COMPUTER EXPERIENCE: Advanced MS Excel (Pivot Tables, VLookup), MS Word,

MS Access, MS Powerpoint, PeopleSoft, SAP,

Lawson, Oracle, ACCPAC, Peachtree, SBT,

Quickbooks, Advantage Fee Bill, Titan, Cosmic,

Merit, Rumba, MSP, LPS Desktop, LSAMS, Ivault,

IClear, DRI, Flaws, AS400, IPORTAL, LAMP,

AACER, HOMESAVER, HOMEBASE, ISERIES,

CASETRACKER

EDUCATION: Collin County Community College, Plano,

Texas

AA Degree - 2003 GPA 3.2



Contact this candidate