System and method for questionnaire data digitization and reconciliation

A system for questionnaire data digitization and reconciliation, 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 an automated email tool into a data flow pipeline, wherein the email tool generates an autonomous program for continuously monitoring a shared mailbox for unread emails originated from a computing system, wherein the computing system is utilized for reviewing a document including questionnaire data containing a plurality of line items filled out by a client utilizing a client computing device;
• fetch, in response to determining that the shared mailbox contains unread emails, the document as attached to an unread email and store the document in a shared drive;
• access the document from the shared drive;
• implement an optical character recognition (OCR) tool into the data flow pipeline;
• convert, using the OCR tool, the questionnaire data containing the plurality of line items into machine-readable format data;
• implement an automated reconciliation tool into the data flow pipeline;
• read, using the automated reconciliation tool, the machine-readable format data for each line item;
• compare, using the automated reconciliation tool, data for each line item against a corresponding predefined guidance data;
• identify, based on the comparing, missing response data, negative response data, and insufficient response data corresponding to the questionnaire data by applying predefined rules;
• and
• automatically reconcile the missing response data, negative response data, and insufficient response data, wherein automatically reconciling comprises:
• filtering the missing response data from the questionnaire data and group the missing response data into a first file;
• filtering the negative response data from the questionnaire data and group the negative response data into a second file;
• and
• filtering the insufficient response data from the questionnaire data and group the insufficient response data into a third file;
• transmit the first file, the second file, and the third file as output to the client computing device via a communication interface;
• receive input data from the client corresponding to each of the missing response data, the negative response data, and the insufficient response data;
• and
• repeat the converting, the reading, the comparing, the identifying, and the automatically reconciling on the received input data,
• wherein the automated reconciliation tool and the OCR tool are implemented as part of a data digitization and reconciliation module that is platform, language, database, browser, and cloud agnostic, thereby enabling orchestration and passing of the questionnaire data through the data flow pipeline across various components, and wherein configuration or data files utilized by the data digitization and reconciliation module are stored in a configuration-based language format such that the data digitization and reconciliation module is tunable or modifiable for performance without affecting the configuration or data files.

A non-transitory computer readable medium configured to store having instructions stored thereon, wherein the instructions are executable to cause a processor to perform operations comprising:

• implementing an automated email tool into a data flow pipeline, wherein the email tool generates an autonomous program for continuously monitoring a shared mailbox for unread emails originated from a computing system, wherein the computing system is utilized for reviewing a document including questionnaire data containing a plurality of line items filled out by a client utilizing a client computing device;
• fetching, in response to determining that the shared mailbox contains unread emails, the document as attached to an unread email and storing the document in a shared drive;
• accessing the document from the shared drive;
• implementing an optical character recognition (OCR) tool into the data flow pipeline;
• converting the questionnaire data containing the plurality of line items into machine-readable format data;
• implementing an automated reconciliation tool into the data flow pipeline;
• reading, by the automated reconciliation tool, the machine-readable format data for each line item;
• comparing data for each line item against a corresponding predefined guidance data;
• identifying, based on the comparing, missing response data, negative response data, and insufficient response data corresponding to the questionnaire data by applying predefined rules;
• and
• automatically reconciling the missing response data, negative response data, and insufficient response data, wherein the automatically reconciling comprises:
• filtering the missing response data from the questionnaire data and grouping the missing response data into a first file:
• filtering the negative response data from the questionnaire data and grouping the negative response data into a second file;
• and
• filtering the insufficient response data from the questionnaire data and grouping the insufficient response data into a third file;
• transmitting the first file, the second file, and the third file as output to the client computing device via a communication interface;
• receiving input data from the client corresponding to each of the missing response data, the negative response data, and the insufficient response data;
• and
• repeating the converting, the reading, the comparing, the identifying, and the automatically reconciling on the received input data,
• wherein the automated reconciliation tool and the OCR tool are implemented as part of a data digitization and reconciliation module that is platform, language, database, browser, and cloud agnostic, thereby enabling orchestration and passing of the questionnaire data through the data flow pipeline across various components, and wherein configuration or data files utilized by the data digitization and reconciliation module are stored in a configuration-based language format such that the data digitization and reconciliation module is tunable or modifiable for performance without affecting the configuration or data files.