Attachment_-_Systems_Subsystems_Applications.docx

ATTACHMENT

Title: Sources Sought Notice for Hosting Migration Services; Mortgage Backed Securities (MBS) processing; and Operations and Maintenance in support of the Government National Mortgage Association (Ginnie Mae)

DESCRIPTIONS OF APPLICATIONS & DATABASES

The Contractor shall utilize the applications and systems listed below to complete the work outlined in the Sources Sought Notice. The Contractor will be responsible for hosting, operating, and maintaining the following applications and systems until the BNYM technology selected for the hosting migration is migrated to the new ITIC Provider:

PPA/CPTA Applications, Databases & Systems

Portal

1. Customer Service Inquiry

2. Generalized Mortgage-Backed Securities Subsystem (GMBS) Central Registry

(i) Tax Reporting and P&I Processing

(ii) Transfer Processing

3. New Pool Processing Subsystem (NPPS)

4. Platinum Pool System

5. Pool Reporting System (PRS)

1. Adjustable Rate Mortgage (ARM) Index

2. Commitment Management (CM)

3. Congressional Budget (CB)

4. Master Agreements Management System (MAMS)

5. Pool Transfer System (PTS)

6. Report Center

7. Request Pool Numbers (RPN)

8. RSA SecurID Token Management

9. Unclaimed Funds (UFS)

1. Enterprise Wide Operational Data Store (EWODS) On Line Transaction Processing (OLTP)

2. Customer Service

3. Letters of Credit

4. Public Facing Searchable Databases Multifamily Database

(iii) Platinum Database

(iv) REMIC Database

5. GinnieNET System

6. Ginnie Mae Enterprise Portal (GMEP) 1.0

7. Informatica

8. MyGinnieMae (GMEP 2.0) Multifamily Pool Delivery Module (MFPDM)

(v) Platinum Application

(vi) Unclaimed Funds

9. SAP Business Objects (BOBJ)

Legacy IPMS (L-IPMS) Mainframe

(1) Customer Service Inquiry:

The Customer Service Inquiry system is a mainframe based system. It performs three (3) major functions:

1. GMBS Registry Inquiry:

The Generalized Mortgage-Backed Securities Subsystem (GMBS) Registry Inquiry system enables users to conduct inquiries on Issuers, investors, certificates, investor distributions and monthly transfer activity.

(viii) GMS File Maintenance:

The Generalized Mortgage Subsystem (GMS) File Maintenance System enables users to update and maintain the files with investors’ names and addresses, payment addresses as well as certificate masters.

(ix) GNMA Pool Reporting System:

The GNMA Pool Reporting System (PRS) enables users to look up records by commitment, loan package, pool, Issuer and multiple Issuer pool.

(2) Generalized Mortgage-Backed Securities Subsystem:

The Generalized Mortgage-Backed Securities Subsystem (GMBS) is a mainframe-based application. It performs three (3) major functions: Central Registry, Transfer Processing as well as P&I payment processing, which includes Tax Reporting.

Central Registry:

The Central Registry stores information on every single security issued. The Central Registry is Ginnie Mae’s official record of an investor’s certificate/position for payment of monthly P&I. Investor data and the corresponding certificate/positions are automatically updated on the Central Registry as a result of new pool issuances or certificate transfers. The Central Registry has an inquiry function which allows for on-line viewing of certificates/positions. The Central Registry maintains historical data of all outstanding certificate/position and cancelled securities. With this information, the system can generate a certificate history by Issuer, pool or investor. This allows Ginnie Mae to reconstruct certificate ownership throughout the entire life of the pool, thereby, providing a valuable tool for monitoring activity.

(x) Tax Reporting and P&I Payment Processing:

This application facilitates the collection of P&I from Ginnie Mae I and Ginnie Mae II MBS Issuers. It ensures the timely disbursement to Ginnie Mae investors. Based on Remaining Principal Balances (RPB) reported by Issuers, IPMS/Pool Reporting Module (PRM) calculates the P&I for each pool. The pool P&I from IPMS/PRS is transmitted to GMBS. GMBS identifies registered holders for the specified record date. The pro-rata share of each open certificate/position is calculated and aggregated for each pool to obtain 100 percent. Edits are built into the payment processing program in GMBS to ensure that the total P&I calculated by IPMS/PRM for each pool is equal to the total P&I being distributed to the investors by GMBS. Exceptions are resolved prior to collecting the P&I from the Issuers. Upon curing all discrepancies, GMBS generates checks and vouchers (Remittance Advices). The checks and vouchers are mailed to certificated security holders one (1) day prior to payment date. On the payment date (20th calendar day) a Fedwire is sent to the Depository for its share of the P&I and to any investor requesting an electronic payment.

A. This application facilitates the payments to Ginnie Mae I security holders on behalf of Ginnie Mae, when the Issuer of the securities does not or cannot make payments directly. Once the payments are in proof, funds are requested from Ginnie Mae. Payments to investors will be made on the distribution date (upon receipt of funds from Ginnie Mae) to each holder of record as of the record date. For book entry securities, funds will be wired to the Depository; for securities held in physical form checks will be mailed to the investors.

B. This system facilitates the calculation of factors. A factor is the percentage of the original principal amount that will remain outstanding once the scheduled monthly payment on the securities has been made. These factors are used by securities dealers, investors, and others involved in trading Ginnie Mae securities and are vital to the proper allocation, among classes of Ginnie Mae REMIC securities, of monthly cash flows on the underlying Ginnie Mae MBS.

(xi) Transfer Processing Updates:

This application performs the back-end updates (Issuer re-assignments) that need to occur to complete the pool transfer process.

(3) New Pool Processing Subsystem:

The New Pool Processing Subsystem (NPPS) is a mainframe application that is used to certify, review, and approve loan and pool documents in order to issue new mortgage backed securities. The main objective of this system is to check transfer eligibility status of pools and Issuer, and reassign purchased pools to the purchasing Issuer’s portfolio on the transfer effective date. NPPS performs the following functions:

1. Accepts for processing and issuance;

(xiii) Re-edits pools from GinnieNET;

(xiv) Allows data entry of manual pools;

(xv) Checks Master Agreements;

(xvi) Checks Commitment Authority, Status, and Pool Numbers;

(xvii) Generates Multiple Issuer Pools (MIP);

(xviii) Releases New Issue files to the Federal Reserve;

(xix) Updates Bank’s Fed Delivery System with Pool Delivery Instructions;

(xx) Updates Pools to Pool Reporting Module;

(xxi) Creates investor position on Central Registry;

(xxii) Updates the Multifamily Database; and

(xxiii) Updates Data Disclosure data tables.

(4) Platinum Pool System:

The Ginnie Mae Platinum Pool System is a mainframe application that maintains information on Ginnie Mae I and Ginnie Mae II pools. The Platinum Pool System performs the following functions.

1. Update or Inquiry Ginnie Mae I and Ginnie Mae II pools;

1. Un-Release Function; and

1. Platinum Pool Adjustments.

(5) Pool Reporting Subsystem:

The Ginnie Mae IPMS PRS is a mainframe application that maintains pool level detail for Ginnie Mae I and II pools, loan packages and Platinum pools. There are multiple components to PRS which facilitate RPB reporting, P&I collection, Guaranty Fee collection, factor calculation and Platinum pool issuance. PRS performs the following functions:

1. Processes RPBs that the Mortgage Backed Securities Operations and Analytics (MBSOA) Contractor has released to Enterprise Wide Operational Data Store (EWODS);

(xxviii) Allows for the manual data entry of RPBs by the PPA/CPTA Contractor;

(xxix) Edits RPBs;

(xxx) Calculates and disseminates Factors for Ginnie Mae I, Ginnie Mae II, and Platinum pools;

(xxxi) Calculates and generates Ginnie Mae I and Ginnie Mae II Guaranty Fee Automated Clearing House (ACH) Collections;

(xxxii) Calculates certification due dates;

(xxxiii) Tracks Issuer reassignments and mergers;

(xxxiv) Tracks custodian changes using Snapshot of a pool;

(xxxv) Calculates Ginnie Mae II P&I collection;

(xxxvi) Processes Adjustable Rate Mortgage rate changes;

(xxxvii) Maintains MBS and Multiclass pool detail; and (xxxviii) Updates the Multifamily database.

(a) Modernized IPMS (M-IPMS) Portal ARM Index:

The ARM Index system is accessed by both PPA operators and Ginnie Mae users. It allows:

1. PPA ARM viewers to view ARM reports and screens.

(xl) PPA ARM submitters to enter and update index values, and submit index records for PPA approval.

(xli) PPA ARM approvers to approve and reject index records submitted by PPA submitters.

(xlii) Ginnie Mae ARM viewers to review ARM reports and screens.

(xliii) Ginnie Mae ARM approvers to approve and reject index records approved by the PPA.

Commitment Management:

The Commitment Management (CM) application provides an Issuer with an automated method to:

1. Submit requests for Commitment Authority;

(xlv) Confirm the associated commitment fee;

(xlvi) Proactively monitor their Commitment Authority balance and request status;

(xlvii) Submit payment instructions for ACH debit of commitment fees; and (xlviii) Request reports.

An Issuer must comply with Ginnie Mae’s eligibility requirements and have sufficient Commitment Authority available to successfully issue Ginnie Mae securities. Commitment Authority allows an Issuer to issue up to an authorized dollar amount of securities and constitutes a commitment line balance.

(6) Congressional Budget:

The Congressional Budget (CB) application provides Ginnie Mae Operations with an automated method to:

1. Update Congressional Budget Allocation Security Access Roles;

(l) Implement various types of commitment based on program type and track separately (in total and at individual Issuer level);

(li) Allocate, adjust, reserve, freeze/restore, ration or delete Congressional Budget Allocation;

(lii) Edit carryover amount and not to exceed controls;

(liii) Commitment expiration;

(liv) Perform Issuer initiation rollover;

(lv) Enter newly allocated budget allocations from Congress;

The CB application also provides the following functionality for Ginnie Mae operations:

(lvi) Auto application of freeze annually of congressional budget amounts;

(lvii) Auto application of default reserve amount;

(lviii) Auto application of Fiscal Year initiation; and (lix) Auto application of Congressional Budget allocation close-out timestamp.

(7) Master Agreements Management System:

The Master Agreements Management System (MAMS) provides Issuers, Subservicers, Participation Agents and Document Custodians with an automated method to:

1. Input the data required to create the agreements;

(lxi) Upload and import scanned copies of the physical documents, where applicable;

(lxii) Print agreements;

(lxiii) Search and view agreements;

(lxiv) Access and view reports; and (lxv) Certify forms using a multi-factor authentication methodology.

(8) Pool Transfer System:

The Pool Transfer System (PTS) application provides an Issuer with an automated method to:

1. Initiate and update pool transfer request information;

(lxvii) Import and update pool numbers being transferred;

(lxviii) View and receive the associated approval documentation;

(lxix) Approve or reject pool transfer requests from the selling Issuer;

(lxx) Access and view reports;

(lxxi) Confirm associated transfer fees and submit payment instructions for ACH debit; and (lxxii) Receive electronic notifications of transfer requests and reports to Ginnie Mae Account Executives and the Pool Processing Issuer.

(9) Report Center:

The Report Center application provides Ginnie Mae users with access to the already made (canned) IPMS reports generated by each application. Ginnie Mae users can query already made reports, print and Portable Document Format (PDF) these reports. Users can not generate new customized reports in Report Center.

(10) Request Pool Numbers:

The Request Pool Numbers (RPN) application provides an Issuer with an automated method to:

1. Submit requests for pool numbers and receive immediate response;

(lxxiv) View available pool numbers;

(lxxv) Submit override requests to Ginnie Mae Account Executives for additional pool numbers;

(lxxvi) Download and view status reports and (lxxvii) Receive auto-reminders of pool number inventory.

(11) RSA SecurID Token Management:

The RSA SecurID token is part of a two-factor authentication process in which a user can access a system and/or submit an approval by entering their User ID and password, for that system, followed by entering a four-digit PIN, (assigned when a user performs the initial RSA SecurID validation) along with the six-digit code provided by the RSA SecurID . The RSA SecurID Token Management application can be accessed by both PPA operators and Ginnie Mae internal and external users.

(12) Unclaimed Funds:

The Unclaimed Funds System (UFS) allows Ginnie Mae to track and reconcile Ginnie Mae I and Ginnie Mae II MBS unclaimed P&I payments. Ginnie Mae’s UFS is used for tracking, honoring claims from Issuers and investors and reconciling receipt versus payment of unclaimed funds.

1. Ginnie Mae I P&I funds that are unclaimed for six (6) months from the payment date, along with related form HUD 11714 and 11714 SN are forwarded by Issuers to Ginnie Mae’s PPA. UFS is used to track the amount of unclaimed funds received and pertinent information from form HUD 11714 and 11714SN for each Issuer. The unclaimed funds check received from the Issuer is deposited into an Unclaimed Funds Account. After four (4) days the funds are wired via Pay.gov to Ginnie Mae. As claims are received from Issuers, they are verified against the UFS to ensure their validity. All valid claims are forwarded to Ginnie Mae along with a request for funds. Once Ginnie Mae has approved the request, funds are forwarded to Ginnie Mae’s PPA, who then honors the claim and mails a check to the Issuer. The Contractor will work with the Issuer and Ginnie Mae to clear any exceptions and/or discrepancies.

(lxxix) The Ginnie Mae’s PPA Customer Service Group tracks Ginnie Mae II unclaimed funds on UFS. Funds for all returned and/or uncashed checks that have aged six (6) months are remitted to Ginnie Mae. All claims received from investors are verified against UFS. If the claims are valid, the funds are requested from Ginnie Mae. On receipt of the funds a replacement check is issued to the investor. Monthly reconciliation reports are forwarded by Ginnie Mae’s PPA to Ginnie Mae for both Ginnie Mae I and II MBS programs.

(b) Other Applications & Databases

1. Enterprise Wide Operational Data Store:

EWODS is an Oracle relational database that stores transaction processing data that is sourced from various Ginnie Mae applications. Conceptually, EWODS is the repository of data that is collected and shared across the Ginnie Mae enterprise and with multiple contractors.

1. EWODS has three (3) environments: Staging; Operational and Transactional Repository; and Reporting Mart. Data is processed by EWODS to move data between the environments. The data movement is a function of the Extract, Transform, and Load (ETL) process. Data is extracted from source systems, transformed, and loaded into both Staging and Repository. The Staging environment is used if additional clean-up will be required of the data. The Repository environment is used to store the data.

(lxxxi) EWODS supports centralized data collection and feedback for all MBS new Issuer processing, new pool originations, monthly accounting and reporting for single family and multifamily pools, and Multiclass securities. EWODS provides a secure single source for all Ginnie Mae’s enterprise data, minimizing redundancy and data synchronization across disparate systems.

1. Online Transaction Processing:

Ginnie Mae’s databases are in the process of being restructured into Online Transaction Processing (OLTP) databases that will support various data warehouses and reporting data marts also under development. References to “EWODS” are intended to include OLTP databases when transitioned.

(14) Customer Service:

This database is used with six (6) customer service desktop applications including:

1. Mail Room (lxxxiii) Customer Service (lxxxiv) Correction Help Desk (lxxxv) Ticket System Desktop application (lxxxvi) GinnieNET Help Desk (lxxxvii) Manual Prospectus Request

(15) Letters of Credit:

This database is used to track Issuer certifications. If an Issuer fails to timely final certify or recertify a pool or loan package and exceeds the threshold established by Ginnie Mae for final certification and recertification, the Issuer may be required to post a letter of credit with Ginnie Mae for the loans preventing certification. This application will provide notifications on certification status and issue a request to an Issuer for a letter of credit.

(16) Public Facing Searchable Databases:

1. Multifamily Database:

This database contains information about Ginnie Mae's Multifamily mortgage-backed securities at the security and loan level. Data can be searched based on certain information about multifamily pools: pool number, Committee on Uniform Securities Identification Procedures (CUSIP) number, FHA case number or Rural Development (RD) case number, Pool type, or Issuer number.

(lxxxix) Platinum Database:

This database contains information about Ginnie Mae's Platinum securities. Data can be searched based on CUSIP or pool.

(xc) REMIC Database:

The REMIC database is utilized as a search tool and a vehicle to post data by different partners of Ginnie Mae.

The PPA/CPTA and the Deal team (sponsor, trustee, financial advisor, and accountant) post various data to the site – Offering Circular Supplement, Announcement, Relay File, etc. Trustees also post deal factors on a monthly basis along with floating rates and series factors. The Contractor posts indices and utilizes this upload feature for Platinum Submission reporting;

D. The search tool can display REMIC deal data, payment factors & rates, and indices. Search page locates REMIC deals by either CUSIP number or Deal number.

(17) GinnieNET System:

GinnieNET is an internet application that is used by Issuers to electronically submit MBS pools, final certifications and recertification information. HUD forms include: 11705 – Schedule of Subscribers and Ginnie Mae Guaranty Agreement, 11706 – Schedule of Pooled Mortgages, 11708 - Transfers of Document Custodian Responsibility forms HUD 11711A - Release of Security Interest, 11711B - Certification and Agreement. GinnieNET is used by Document Custodians to certify or reject submissions. This includes Security Administration, Maintenance, New Pool Processing, Certifications, Host Communications and Reports.

(18) Ginnie Mae Enterprise Portal (GMEP 1.0):

Ginnie Mae Enterprise Portal (GMEP 1.0) is a browser-based system that includes points of entry via a common presentation layer including: RFS, Salesforce, SAP Business Objects (BOBJ), Query and Reporting Tool, plus M-IPMS. The table below identifies the suite of RFS applications that are maintained by the MBSOA and hosted by the Data Center/ITIC Contractors. The PPA/CPTA Contractor will not be responsible for the O&M for these RFS applications. However, the PPA/CPTA Contractor is responsible for hosting M-IPMS.

1. Contact Management (CMgnt);

2. Custodial Account Verification System (CAVS);

3. Data Disclosure (DD)

4. E-Notification (EN);

5. HMBS Reporting and Administration (HRA);

6. Independent Public Accounting (IPA);

7. Matching and Suspense (MAS);

8. Pool Accounting & Exception Feedback (PAEF), Single and multifamily modules;

9. RFS Administration (ADMIN);

10. Servicemembers’ Civil Relief Act (SCRA);

11. Widely Held Fixed Investment Trust (WHFIT);

12. Corporate Watch (CW);

13. Data Analysis and Reporting Tool (DART);

14. Executive Dashboard (in the future)

15. Ginnie Mae Meta Data System (GEMS);

16. Ginnie Mae Operational Data Store (GMODS);

17. Ginnie Mae Portfolio Analysis Database (GPADS);

18. Issuer Operational Performance Profile (IOPP);

19. Master Subservicer Operational Reporting (MOR).

1. GMEP 1.0 also contains and enforces user access and elements of IT security. The GMEP Common Controls (CC) System Security Plan (SSP) identifies the security description of the infrastructure components, policies, and procedures. For information regarding the CC of GMEP, refer to the GMEP CC SSP.

(xcii) Another function of GMEP is to serve the historical reporting needs of the enterprise. It provides the user the ability to access canned reports and generate ad-hoc queries.

(19) Informatica:

Informatica is used to manage the transfer of data across Ginnie Mae’s environments. Installations of Informatica hosted, operated and maintained by the PPA/CPTA interact with applications and databases utilized by the MBSOA Contractor. Additional installations of Informatica are hosted at Ginnie Mae’s current Managed Data Center and operated and maintained by the existing MBSOA Contractor. The Informatica installation at the Managed Data Center and BNYM will be migrated to Ginnie Mae’s new ITIC Provider.

(20) MyGinnieMae Portal (GMEP 2.0):

MyGinnieMae is a collection of access control-based services, policies, rules, and technical methods used to manage access to applications or resources within the MyGinnieMae Portal. MyGinnieMae serves as the centralized security control solution for Ginnie Mae portals and applications, as well as the identity management solution for its users. MyGinnieMae provides users with an industry-standard secure means for access to the Ginnie Mae eco-system which will enable use of integrated applications to perform business processes. The solution provides client-side, delegated administrators with the ability to manage users’ access to the MyGinnieMae Portal. The system consists of an application infrastructure and Single Sign-On (SSO) environment, Web Services, and Identity and Access Management (IAM) services. There are currently three (3) applications that are accessible via MyGinnieMae with one additional application going into production in 2018:

1. Multifamily Pool Delivery Module (MFPDM) (to deploy in 2018) is an application that allows Multifamily Issuers to submit pool and loan data, to be assembled and issued as MBS. Pool and loan data can be entered manually or uploaded using a file. The above-mentioned process is currently initiated via a legacy system, GinnieNET. Document Custodians will continue to use GinnieNET to certify pool and loan data. In addition, Issuers will continue to use this application to accept pools, in the event that a transfer at issuance occurs.

(xciv) Master Subservicer Operational Reporting (MOR) is a centralized data repository that provides advanced analytics and reporting on Ginnie Mae’s Master Subservicers (MSS) and enables consistent views of Ginnie Mae’s MSS portfolio performance. It supports MSS loan-level operational and accounting analysis, advanced reporting and self-service querying capability. MOR collects, processes and validates data provided by Ginnie Mae’s MSSs. MOR is used primarily by Ginnie Mae and other Ginnie Mae Contractors. MOR is maintained by the MBSOA Contractor.

(xcv) Platinum processing application will allow depositors the ability to edit Platinum collateral as it is received in the MyGinnieMae Portal and to accommodate higher request volumes. The application also automates the following functionality:

1. Submission of Deposit Agreement and Confirmation: Pool Number, CUSIP Limited Purpose Account (LPA) in MyGinnieMae Portal.

F. Security CUSIP load to the Federal Reserve Bank of New York (FRBNY); automated integration into Mainframe.

G. Trust Receipt Generation in MyGinnieMae Portal.

(xcvi) The UFS is used to track the P&I payments sent to Ginnie Mae I and II security holders and never presented for payment and are six (6) or more months old. This application is only used by the PPA/CPTA operations team and is not an external facing module.

(21) SAP Business Objects:

SAP Business Objects (BOBJ) is used to support RFS Pool Accounting & Exception Feedback (PAEF) as well as M-IPMS. The PPA/CPTA will operate and maintain installations of BOBJ that support the functionality performed by the MBSOA Contractor; for example populating various EWODS tables and transferring other data necessary to support this contract. There are also installations of BOBJ at Ginnie Mae’s current Managed Data Center that are operated and maintained by the existing MBSOA Contractor. The BOBJ installation at the Managed Data Center and the BNYM will be migrated to Ginnie Mae’s new ITIC Provider.

[End]