Forrest Jones Email and Phone Number

Collaborate and strategize with Project Managers, Design and Build partners, IT QA and UAT, and the Lines of Business to gather, implement, and facilitate report business requirements throughout the project or Systems Development Life Cycle (SDLC) for GSE external reporting that is delivered to Fannie Mae and Freddie Mac.Interact with applicable systems administrators, IT Design and Build, UAT, Risk Validation, and Project Managers to ensure adherence with scope management, change request management (Change Control) and solution definition for projects.Act as a liaison between various lines of business and the IT project team to ensure timely delivery of reporting to external regulatory agencies, i.e., FNMA (Fannie Mae) and FHLMC (Freddie Mac).Work with IT business partners and data stewards to help solution sources and mappings of data elements requested by the lines of business for each new project intake.Track progress of error resolution, assist in research and perform data analysis to present findings to all levels of leadership within the company.Perform trending analysis on HAMP, Short Sale, Streamline, and Standard Mods that are serviced by Freddie Mac by monitoring loans that pass/fail internal edit checks.

Maintaining a group-wide MS Access platform to log and centralize all of the audits performed on reports within the Short Sale, Deed In Lieu, and REO platformsPerformed UAT internal governance review (user acceptance testing) on new metrics built out to be put into production on the bank’s data serverAudited creation of new Short Sale, Deed In Lieu, and REO reports as well as modifications to existing reportsConducted testing on data schemas and table counts on databases between separate servers in efforts to migrate data from old legacy servers to new servers.Performed Quality Control testing on bank data servers and databases to ensure accurate dataValidated integrity of the Short Sale, Deed In Lieu, and REO data by comparing it against front-end GUI screens and ensuring that the data matched in both sourcesSME for Exception Reports – where we find problems with data in the reporting database and create a report by supplying screenshots and the data points affected for the line of business to correctAuditing of the SQL code, reports, and data that relate to the Short Sale, Deed In Lieu, and REO Scorecards and Event Models used by senior leadership

Importing, merging, and combining data sets using SAS codeCreating, querying, merging and modifying data setsProc SQL and the Data Step ProceduresGathering highly disparate data and using SAS to create programs that locate, transform, combine, and report on desired informationUsing SAS Access, SAS SQL, SAS Graph, Print ProcedureTransforming raw data into formatted dataDebugging code from other sourcesMonthly reporting and analysis of originations trendsProducing and monitoring various credit risk profiles on applications and fundingsMonitoring industry publications and economic data sources for relevant trendsMaintaining ROE pricing model and associated rate tablesReview Monthly Static Pool Delinquency and Vintage Loss trendsMonitor Auction Recovery RatesUse SAS and SQL to query data for reporting and ad hoc analysis