System and method for implementing a regulatory and statutory reporting generic multi-disclosure processor

A system for processing of multiple files having different formats and structures, the system comprising:

• a processor;
• and
• a memory operatively connected to the processor via a communication interface, the memory storing computer readable instructions, when executed, causes the processor to:
• implement a data processing module (DPM) configured to implement a generic single ETL (Extract-Transform-Load) processor for configuring and loading multiple files having different formats and structures which can be extended to a plurality of files, the DPM including an identifying module, an implementing module, a receiving module, an uploading module, a monitoring module, a determining module, an outputting module, and a communication module, wherein each module being called via corresponding application programming interface (API);
• identify, by calling the identifying module, a plurality of data files each having a predefined file format and structure and viewing corresponding file status, the plurality of data files being received from various data sources;
• implement, by calling the implementing module, the generic single ETL (Extract-Transform-Load) processor for front loading of ETL in a manner such that user input is received to configure the plurality of files and transmit to multiple downstream systems for further processing via User Interface (UI) mapping;
• implement, by calling the implementing module, a user interface (UI) platform that includes a configuration UI layer and an upload UI layer;
• receive user input, via the configuration UI layer, to configure the files and corresponding fields that are to be generated in the multiple downstream systems;
• receive, by calling the receiving module, approval for the files that has been configured;
• upload, in response to receiving approval, the files via the upload UI layer by calling the uploading module;
• monitor the uploaded files by calling the monitoring module;
• determine, by calling the determining module, that an uploaded file is valid based on matching corresponding configuration details and file rules received from the generic single ETL processor;
• transmit, by calling the communication module, the valid file to a corresponding downstream system based on received corresponding output configuration and outbound rules;
• and
• output, by calling the outputting module, a final publication by the downstream system based on receiving the valid file,
• implement, by calling the implementing module, the generic single ETL processor for the front loading of ETL;
• and
• plug components of the generic single ETL processor along with front loading approach to an application in the downstream system.

A non-transitory computer readable medium configured to store instructions for processing of multiple files having different formats and structures, the instructions, when executed, cause a processor to perform the following:

• implementing a data processing module (DPM) configured to implement a generic single ETL (Extract-Transform-Load) processor for configuring and loading multiple files having different formats and structures which can be extended to a plurality of files, the DPM including an identifying module, an implementing module, a receiving module, an uploading module, a monitoring module, a determining module, an outputting module, and a communication module, wherein each module being called via corresponding application programming interface (API);
• identifying, by calling the identifying module, a plurality of data files each having a predefined file format and structure and viewing corresponding file status, the plurality of data files being received from various data sources;
• implementing, by calling the implementing module, the generic single ETL (Extract-Transform-Load) processor for front loading of ETL in a manner such that user input is received to configure the plurality of files and transmit to multiple downstream systems for further processing via User Interface (UI) mapping;
• implementing, by calling the implementing module, a user interface (UI) platform that includes a configuration UI layer and an upload UI layer;
• receiving user input, via the configuration UI layer, to configure the files and corresponding fields that are to be generated in the multiple downstream systems;
• receiving, by calling the receiving module, approval for the files that has been configured;
• uploading, in response to receiving approval, the files via the upload UI layer by calling the uploading module;
• monitoring the uploaded files by calling the monitoring module;
• determining, by calling the determining module, that an uploaded file is valid based on matching corresponding configuration details and file rules received from the generic single ETL processor;
• transmitting, by calling the communication module, the valid file to a corresponding downstream system based on received corresponding output configuration and outbound rules;
• and
• outputting, by calling the outputting module, a final publication by the downstream system based on receiving the valid file;
• implementing, by calling the implementing module, the generic single ETL processor for the front loading of ETL;
• and
• plugging components of the generic single ETL processor along with front loading approach to an application in the downstream system.