Distributed search and retrieval using uniform identifiers of loan pools and rule-based tools for restructuring of the loan pools

1 . A system for conducting distributed search and retrieval of loan-level data for a plurality of loan pools and for generating rules-based validity indicators and disclosure documents associated with reorganization of loans within the loan pools, the system comprising:

at least one memory storing instructions; and

at least one networked server computing system having at least one processor in communication with a plurality of client terminals, the at least one processor configured to execute the instructions to perform operations comprising:

generating and providing a web portal for interactively communicating with the plurality of client terminals;

receiving, from one of the client terminals via the web portal, a first comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a first unique identifier of a first loan pool, a loan pool number, and an original par amount, the first loan pool being associated with a first electronic mortgage backed security;

deconstructing the first electronic mortgage backed security by:

verifying that the first unique identifier and the loan pool number conform to one or more alphanumeric format requirements;

receiving, via the web portal, a first ownership indicator associated with the first loan pool;

generating a first distributed search and retrieval request for a first multi-tiered determination of at least an interest rate, loan term, and a balance for each loan in the first loan pool, the first request including the first unique identifier;

transmitting the first request through a network of distributed databases to a first remote server identified by a database management program as storing information regarding the first loan pool; and

receiving, from the first remote server information regarding the first loan pool such as an interest rate, loan term, or balance for each loan in the first loan pool, wherein a first electronic certificate is preserved for the first electronic mortgage backed security;

receiving, from the one of the client terminals via the web portal, a second comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a second unique identifier of a second loan pool, the second loan pool being associated with a second electronic mortgage backed security or the first electronic mortgage backed security;

deconstructing the second electronic mortgage backed security by:

receiving, via the web portal, a second ownership indicator associated with the second loan pool;

communicating with a securities database to identify, based on the second unique identifier, a second remote server or at least one of the distributed databases storing information associated with the second loan pool;

generating a second distributed search and retrieval request for a second multi-tiered determination of at least an interest rate, a loan term, and a balance for each loan in the second loan pool, the second request including the second unique identifier;

transmitting the second request to the identified distributed databases or the second remote server identified by the database management program as storing information associated with the second loan pool; and

receiving, from the second remote server information regarding the second loan pool such as an interest rate, loan term, or balance for each loan in the second loan pool, wherein a second electronic certificate is preserved for the second electronic mortgage backed security;

obtaining one or more stored pseudo pool rules, the pseudo pool rules identifying required characteristics of loans in a pseudo pool related to a validity indication of the pseudo pool, the loans in the pseudo pool comprising a combination of the first loan pool and the second loan pool loans, wherein the required characteristics relate to information received by the first remote server and the second remote server in response to the first and second distributed search and retrieval requests;

determining whether the first request and the second request originate from a shared server;

based on the determination that the first request and second request originate from a shared server, generating a combined request and sending the combined request to the first remote server or the second remote server;

receiving a completed data template from a client terminal, the completed data template including one or more data entries;

analyzing the completed data template by prescreening for errors and verifying the relationships between the one or more data entries and the pseudo pool rules;

generating, based on the completed data template, a data file, wherein the data file is an input to a client terminal, the data file including information to automatically partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the data file;

receiving a structured data file identifying a proposed pseudo pool from the web portal, the structured data file identifying a portion of the loans in the first loan pool and a portion of the loans in the second loan pool;

applying the one or more pseudo pool rules to the structured data file to generate a validity indicator within minutes of receipt of the second ownership indicator, the generated validity indicator being based on application of the one or more pseudo pool rules to the information received in response to the first and second distributed search and retrieval requests, the validity indicator comprising a Boolean;

storing the Boolean in the memory;

responsive to a determination that the validity indicator is false due to a violation of the one or more pseudo pool rules by the proposed pseudo pool, identifying the violated one or more pseudo pool rules based on the stored Boolean, generating an error message and providing the error message for display in the web portal;

responsive to a determination that the validity indicator is true, generating a proposed disclosure document including the information received in response to the first and second distributed search and retrieval requests for each loan in the proposed pseudo pool,

wherein the first and second electronic certificates remain unmodified by the generation of the proposed disclosure document, and

wherein the proposed disclosure document includes information that configures one or more payment processing systems associated with at least one of the first loan pool or the second loan pool to automatically partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the proposed disclosure document;

determining, in the one or more pseudo pools, the presence of an error;

providing, to the web portal, a graphical user interface having hyperlinked information to provide at least one of:

results or errors of the deconstruction of the first mortgage backed security; or

results or errors of the deconstruction of the second mortgage backed security;

responsive to the determination of an error in the one or more pseudo pools, blocking access to the hyperlinked information; and

transmitting the proposed disclosure document to the client terminal via the web portal.

2 . The system of claim 1 , wherein the one or more pseudo pool rules comprise a term rule requiring that terms of loans in the proposed pseudo pool match.

3 . The system of claim 2 , wherein the term comprises a length of remaining payback time.

4 . The system of claim 1 , wherein the one or more pseudo pool rules comprise a security coupon rule requiring that pass-through rates of loans in the proposed pseudo pool match.

5 . The system of claim 1 , wherein the one or more pseudo pool rules comprise a category rule requiring that pooling categories of loans in the proposed pseudo pool match.

6 . The system of claim 5 , wherein the pooling categories comprise at least one of an initial interest rate category and a relocation category.

7 . The system of claim 1 , wherein the one or more pseudo pool rules comprise a payment delay rule requiring that time lengths of payment delays of loans in the proposed pseudo pool match.

8 . The system of claim 1 , wherein the generated disclosure document indicates that the proposed pseudo pool backs a group in a multi-class security.

9 . The system of claim 8 , wherein the multi-class security is a Real Estate Mortgage Investment Conduit (REMIC).

10 . The system of claim 1 , wherein the operations further comprise:

receiving, via the at least one processor, a second proposed pseudo pool from the web portal comprising a portion of the loans in the first loan pool but not in the proposed pseudo pool and a portion of the loans in the second loan pool but not in the proposed pseudo pool;

applying, via the at least one processor, the one or more pseudo pool rules to the second proposed pseudo pool to generate a second validity indicator;

responsive to a determination that the second validity indicator is false, generating, via the at least one processor, an error message for display in the web portal; and

responsive to a determination that the second validity indicator is true, generating, via the at least one processor, a second proposed disclosure document including the second proposed pseudo pool.

11 . The system of claim 1 , wherein the error message includes an indicator of at least one rule in the obtained one or more pseudo pool that caused the validity indicator to be false.

12 . A system for conducting distributed search and retrieval of loan-level data for a plurality of loan pools and for generating rules-based validity indicators and disclosure documents associated with reorganization of loans within the loan pools, the system comprising:

at least one memory storing instructions; and

at least one networked server computing system having at least one processor in communication with a plurality of client terminals, the at least one processor configured to execute the instructions to perform operations comprising:

generating and providing a web portal for interactively communicating with the plurality of client terminals;

receiving, from one of the client terminals via the web portal, a first comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a first unique identifier of a first loan pool, a loan pool number, and an original par amount, the first loan pool being associated with a first electronic mortgage backed security;

deconstructing the first electronic mortgage backed security by:

verifying that the first unique identifier and the loan pool number conform to one or more alphanumeric format requirements;

receiving, via the web portal, a first ownership indicator associated with the first loan pool;

generating a first distributed search and retrieval request for a first multi-tiered determination of at least an interest rate, loan term, and a balance for each loan in the first loan pool, the first request including the first unique identifier;

transmitting the first distributed search and retrieval request through a network of distributed databases to a first remote server identified by a database management program as storing information regarding the first loan pool;

receiving, from the first remote server information regarding the first loan pool such as an interest rate, loan term, or balance for each loan in the first loan pool, wherein a first electronic certificate is preserved for the first electronic mortgage backed security; and

applying one or more rules relating ownership indicators to loans in a loan pool to the first ownership indicator and the loans of the first loan pool to automatically select a relevant first subset of loans;

receiving, from the one of the client terminals via the web portal, a second comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a second unique identifier of a second loan pool, the second loan pool being associated with a second electronic mortgage backed security or the first electronic mortgage backed security;

deconstructing the second electronic mortgage backed security by:

receiving, via the web portal, a second ownership indicator associated with the second loan pool;

communicating with a securities database to identify, based on the second unique identifier, a second remote server or at least one of the distributed databases storing information associated with the second loan pool;

generating a second distributed search and retrieval request for a second multi-tiered determination of at least an interest rate, loan term, and a balance for each loan in the second loan pool, the second request including the second unique identifier;

transmitting the second request to the identified distributed databases or the second remote server identified by the database management program as storing information associated with the second loan pool;

receiving, from the second remote server information regarding the second loan pool such as an interest rate, loan term, or balance for each loan in the second loan pool, wherein a second electronic certificate is preserved for the second electronic mortgage backed security; and

applying, via the at least one processor, the one or more rules relating ownership indicators to loans in a loan pool to the second ownership indicator and the loans of the second loan pool to automatically select a relevant second subset of loans;

obtaining one or more stored pseudo pool rules identifying required characteristics of loans in a pseudo pool related to a validity indication of the pseudo pool, the loans in the pseudo pool comprising a combination of the first loan pool and the second loan pool loans, wherein the required characteristics relate to information received by the first remote server and the second remote server in response to the first and second distributed search and retrieval requests;

determining whether the first request and the second request originate from a shared server;

based on the determination that the first request and second request originate from a shared server, generating a combined request and sending the combined request to the first remote server or the second remote server;

receiving a completed data template from a client terminal, the completed data template including one or more data entries;

analyzing the completed data template by prescreening for errors and verifying the relationships between the one or more data entries and the pseudo pool rules;

generating, based on the completed data template, a data file, wherein the data file is an input to a client terminal, the data file including information to automatically partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the data file;

determining a proposed pseudo pool comprising a portion of the relevant first subset of loans and a portion of the relevant second subset of loans based on the automatically-selected first and second subsets of loans and using the one or more pseudo pool rules within minutes of the proposed pseudo pool being determined based on an application of the pseudo pool rules to information received in response to the first and second distributed search and retrieval requests;

generating a structured data file identifying the determined proposed pseudo pool;

generating a proposed disclosure document including the information received in response to the first and second distributed search and retrieval requests for each loan in the proposed pseudo pool,

wherein the first and second electronic certificates remain unmodified by the generation of the proposed disclosure document, and

wherein the proposed disclosure document includes information that configures one or more for configuring a payment processing systems associated with at least one of the first loan pool or the second loan pool to automatically route partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the proposed disclosure document;

determining, in the one or more pseudo pools, the presence of an error;

providing, to the web portal, a graphical user interface having hyperlinked information to provide at least one of:

results or errors of the deconstruction of the first mortgage backed security; or

results or errors of the deconstruction of the second mortgage backed security; and

responsive to the determination of an error in the one or more pseudo pools, blocking access to the hyperlinked information.

13 . The system of claim 12 , wherein the proposed pseudo pool determination is further based on characteristics of loans in the first loan pool and loans in the second loan pool in the information received by the at least one processor in response to the first and second distributed search and retrieval requests.

14 . The system of claim 13 , wherein the characteristics comprise at least one of a term, a loan-to-value ratio, an interest rate, and a credit score of borrowers.

15 . The system of claim 12 , wherein the proposed pseudo pool determination is further based on an optimization algorithm for maximizing a predicted retail value of the proposed pseudo pool.

16 . The system of claim 12 , wherein the operations further comprise:

determining, via the at least one processor, a second proposed pseudo pool from the web portal comprising a portion of the loans in the relevant first subset of loans but not in the proposed pseudo pool and a portion of the loans in the relevant second subset of loans but not in the proposed pseudo pool using the one or more rules,

wherein the proposed disclosure document includes the proposed pseudo pool and the second proposed pseudo pool.

17 . The system of claim 16 , wherein the proposed pseudo pool determination is further based on an optimization algorithm for maximizing a predicted combined retail value of the proposed pseudo pool and the second proposed pseudo pool.

18 . A method for conducting distributed search and retrieval of loan-level data for a plurality of loan pools and for generating rules-based validity indicators and disclosure documents associated with reorganization of loans within the loan pools, the method performed by at least one processor of a networked server computing system in communication with a plurality of client terminals, the at least one processor being configured to perform steps comprising:

generating and providing a web portal for interactively communicating with the plurality of client terminals;

receiving, by the at least one processor, from one of the a client terminals via the web portal, a first comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a first unique identifier of a first loan pool, a loan pool number, an original par amount, and a first ownership indicator associated with the first loan pool, the first loan pool being associated with a first electronic mortgage backed security;

deconstructing the first electronic mortgage backed security by:

verifying that the first unique identifier and the loan pool number conform to one or more alphanumeric format requirements;

determining, by the at least one processor querying a securities database based on the first unique identifier, at least one first remote server storing information regarding the first loan pool;

generating, by the at least one processor and using the first unique identifier, a first distributed search and retrieval request for a first multi-tiered determination of at least an interest rate, a loan term, and a balance for each loan in the first loan pool;

transmitting, by the at least one processor, the first distributed search and retrieval request through a network of distributed databases to the at least one first remote server; and

receiving, from the first remote server information regarding the first loan pool such as an interest rate, loan term, or balance for each loan in the first loan pool, wherein a first electronic certificate is preserved for the first electronic mortgage backed security;

receiving, from one of the client terminals via the web portal, a second comma separated value (CSV) file having collateral list information for a plurality of columns in a table, the collateral list information including a second unique identifier of a second loan pool, a loan pool number, an original par amount, and a second ownership indicator associated with the second loan pool, the second loan pool being associated with a second electronic mortgage backed security or the first electronic mortgage backed security;

deconstructing the second electronic mortgage backed security by:

verifying that the second unique identifier and the loan pool number conform to one or more alphanumeric format requirements;

determining, by the at least one processor querying the securities database based on the second unique identifier, at least one second remote server storing information regarding the second loan pool;

generating, by the at least one processor using the second unique identifier, a second distributed search and retrieval request for a second multi-tiered determination of at least an interest rate, a loan term, and a balance for each loan in the second loan pool;

transmitting, by the at least one processor, the second request through the network of distributed databases to the determined at least one second remote server;

receiving, from the second remote server information regarding the second loan pool such as an interest rate, loan term, or balance for each loan in the second loan pool, wherein a second electronic certificate is preserved for the second electronic mortgage backed security;

obtaining, by the at least one processor, one or more stored pseudo pool rules identifying required characteristics of loans in a pseudo pool related to a validity indication of the pseudo pool, the loans in the pseudo pool comprising a combination of the first loan pool and the second loan pool loans, wherein the required characteristics relate to information received by the first remote server and the second remote server in response to the first and second distributed search and retrieval requests;

determining whether the first request and the second request originate from a shared server;

based on the determination that the first request and second request originate from a shared server, generating a combined request and sending the combined request to the first remote server or the second remote server;

receiving a completed data template from a client terminal, the completed data template including one or more data entries;

analyzing the completed data template by prescreening for errors and verifying the relationships between the one or more data entries and the pseudo pool rules;

generating, based on the completed data template, a data file, wherein the data file is an input to a client terminal, the data file including information to automatically partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the data file;

receiving, by the at least one processor, structured data file identifying a proposed pseudo pool from the web portal, the structured data file identifying a portion of the loans in the first loan pool and a portion of the loans in the second loan pool;

applying, by the at least one processor, the one or more pseudo pool rules to the structured data file to generate a validity indicator within minutes of receipt of the second ownership indicator, the generated validity indicator being based on application of the one or more pseudo pool rules to the information received in response to the first and second distributed search and retrieval requests, the validity indicator comprising a Boolean;

storing, by the at least one processor, the Boolean in a memory of the computing system;

generating, by the at least one processor and responsive to a determination that the validity indicator is false, an error message and providing the error message for display in the web portal,

wherein the error message indicates a violation of the one or more pseudo pool rules by the proposed pseudo pool;

responsive to the determination that the validity indicator is false, identifying the violated one or more pseudo pool rules based on the stored Boolean;

responsive to a determination by the at least one processor that the validity indicator is true, generating a proposed disclosure document including the information received in response to the first and second distributed search and retrieval requests for each loan in the proposed pseudo pool,

wherein the first and second electronic certificates remain unmodified by the generation of the proposed disclosure document, and

wherein the proposed disclosure document includes information that configures one or more payment processing systems associated with at least one of the first loan pool or the second loan pool to automatically route partition and redirect electronic payments associated with the loans of the proposed pseudo pool to one or more electronic accounts associated with loans identified in the proposed disclosure document;

determining, in the one or more pseudo pools, the presence of an error;

providing, to the web portal, a graphical user interface having hyperlinked information to provide at least one of:

results or errors of the deconstruction of the first mortgage backed security; or

results or errors of the deconstruction of the second mortgage backed security;

responsive to the determination of an error in the one or more pseudo pools, blocking access to the hyperlinked information;

receiving, via the web portal, an indication of approval of the proposed pseudo pool identified in the proposed disclosure document; and

forming, by the at least one processor in response to the received approval indication, an electronic record of a pseudo pool corresponding to the proposed pseudo pool.

19 . The method of claim 18 , wherein forming the pseudo pool comprises:

identifying, by the at least one processor, a plurality of cash flows, each cash flow being associated with a loan in the first pool or in the second pool;

directing, by the at least one processor, one or more of the plurality of cash flows to the pseudo pool, the one or more cash flows being associated with the loans comprising the pseudo pool; and

forming, by the at least one processor, a security backed by the loans comprising the pseudo pool, wherein a holder of the security is entitled to at least a portion of the one or more cash flows.

20 . The method of claim 18 , wherein the operations further comprise:

receiving, by the at least one processor, a second proposed pseudo pool comprising a portion of the loans in the first loan pool but not in the proposed pseudo pool and a portion of the loans in the second loan pool but not in the proposed pseudo pool;

applying, by the at least one processor, the one or more rules to the second proposed pseudo pool to generate a second validity indicator;

when the second validity indicator is false: generating, by the at least one processor, an error message; and

when the second validity indicator is true:

generating, by the at least one processor, a second proposed disclosure document including the second proposed pseudo pool,

receiving, by the at least one processor, approval of the second proposed pseudo pool, and

forming, by the at least one processor, a second pseudo pool comprising the second proposed pseudo pool.

21 . The method of claim 20 , wherein forming the second pseudo pool comprises:

identifying, by the at least one processor, a plurality of cash flows, each cash flow being associated with a loan in the first pool or in the second pool;

directing, by the at least one processor, one or more of the plurality of cash flows to the second pseudo pool, the one or more cash flows being associated with the loans comprising the second pseudo pool; and

forming, by the at least one processor, a security backed by the loans comprising the pseudo pool, wherein a holder of the security is entitled to at least a portion of the one or more cash flows.