Project Analyst

John R. Leeper, Jr.

Manassas, VA *********@*******.***

571-***-**** LinkedIn-john-leeper

DATA QUALITY ANALYSIS/BUSINESS APPLICATIONS/MANGEMENT REPORTING

EXPERIENCE

FANNIE MAE 2005 – 2017

Data Quality Analyst (2005 – 2017)

Data Compare Project

Developed a reusable compare mechanism at the loan attribute level working with external parties and vendors.

Upon project implementation assigned servicers to perform quarterly compare runs to perform analysis on exceptions and to initiate corrective measures to ensure loan data quality. Elimination of exceptions allowed for the straight through processing of monthly loan activity reporting.

Loans with Principal Forbearance Top 10 Servicer Reconciliation Project

Instituted and completed all phases of the project.

Developed queries (Toad/SQL) to pull the loan attributes required to support the reconciliation.

Researched and resolved forbearance balance exceptions while interacting with the servicers.

Quarterly OFHEO/FHFA Risked Based Capital (BRE) Review

Analyzed and resolved loan Business rule exceptions.

Provided data points for weekly and monthly senior management reporting.

Earnings Restatement and Get Current Initiative

Worked to validate various loan attributes that were requested by Deloitte & Touche, LLP, as part of the overall Restatement and Get Current audit process.

Acted as the lead analyst to Deloitte for follow up ad hoc questions pertaining to loan quality issues.

FREDDIE MAC 1991 – 2003

Business Applications Analyst-Senior (Funding & Investments) (2001-2003)

Project Enterprise (PE)/Aladdin Project

Wrote the requirements by assimilating all the necessary information and working with various business areas across the division (Operations, Treasury, Data Integrity Group and Aladdin).

Quickly gained knowledge of the Cash Auction/Trade/Settlement processes to document issues in support of the project. Technology group was able to take the requirements and complete design and development of the application.

GNMA Conversion Change in Paying Agent Project

Responsible for the automation of the redemption date insertion into the All Securities Database (ASDB).

Coordinated with the business areas the requirements, test plans, testing and scheduling the implementation date.

Supported modifications to the Graphical User Interface (GUI) to support the change in paying agent to the Federal Reserve Bank (FRB).

John R. Leeper, Jr. Page Two

Change Management Analyst I/II (1999 - 2001)

Gold Cash Xtra (GCX) Project

Supported User Acceptance Testing (UAT) effort.

Responsible for the completion and validation of the LPX Web Client test plan.

Interacted on a weekly basis with an outside vendor and development staff to resolve issues and defects that were identified during the testing phase.

Credit Enhancement (CE) Recovery Management System Project

Developed and executed test scripts and loan scenarios for UAT. Acted as a point of contact for the ISS team during the testing period.

Credit Enhancement (CE) Manager Project

Analyst for UAT phase of CE Front end Rewrite.

Developed and executed over four hundred loan scenarios during the testing effort.

Worked alongside the Control & Management Reporting (C&MR) business area.

Mortgage Insurance Cancellation Project

Lead Analyst for MIDANET UAT.

Developed MI Masterfile Change Procedures for Midas. Participated in the documentation of project requirements.

Investor Accounting Specialist II (1997 - 1998)

Responsible for all aspects of reporting, remitting and reconciliation of two of Freddie

Mac’s top 30 customers. This involved identifying and correcting database discrepancies and advising customers on Freddie Mac servicing guidelines and training internal/external personnel.

Senior Portfolio Representative II (1996 - 1997)

Matrixed to Event Driven Simple Interest (EDSI). Change Management project for Bank of America. Served as Business Analyst involved in all phases of project development and testing. Lead Analyst responsible for verifying no loan data was corrupted during the conversion of 110,000 loans.

Custodial Account Reconciliation Administrator (1995 - 1996)

Managed all areas of focus in regards to the review of Servicers' monthly reconciliation

of Freddie Mac P&I and Escrow accounts. Point of contact for both internal and external inquires. Lead self-audit of the custodial review process.

Portfolio Representative I-II (1991 - 1995)

Assigned to 10 of Freddie Mac's top 100 servicing customers. These accounts consisted of

structured loans. The reconciliation of the monthly reporting and remitting of these

loans were a manual process outside the normal Freddie Mac accounting cycle workflow.

ADDITIONAL EXPERIENCE

Accountant/Loan Administrator, Bankstar N.A.

TECHNICAL SKILLS

Microsoft Excel, Access, Word, PowerPoint, Project, Outlook, Visio, SharePoint, Toad for Oracle.

EDUCATION

Bachelor of Business Administration (B.B.A.), Finance, Ohio University, Athens, OH

Contact this candidate