WORKLOAD AUTOMATION COMMUNITY
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new

Case Study : Insurance Claim Registration & Validation through HWA

6/5/2023

0 Comments

 
Picture
​This would be a first of a 4-part Blog on how HCL Workload Automation can mimic End to End Processes on the Insurance Business Side.
In this First Blog (1/4), we are looking at the below process and trying to mimic it End to End via HCL Workload Automation.
Picture
An Insurance Claim when submitted via a Manual Form or Online with all the enclosed Documentation would need to be validated for completeness both with respect to the details in the Claim Form, also with respect to all the Documentation attached.

The completeness check would need Scanning the Application Form in case of a Manual Submission along with the Scanning of the attached Document Set submitted.

In this Blog, we are using Docusumo APIs for the Scan Process, one could also substitute this with an equivalent product like IBM Discovery API, Google Cloud Vision API etc.

The Scanned Data along with the Documents are uploaded as a Document on Mongo DB.

The Insurance Company in this case has a developed APIs in Python for the Upload to the Mongo DB.

All Data Validations and Conditionally branching logic to carry out the Business Process is handled by HWA.

Scan Insurance Data:
The First step of this elaborate process involves Scanning the Insurance Data sent over form from the Customer Side, this would be carried out through a HWA Job where we would employ a RESTFUL Get Job to directly Scan the Document by calling the Docusumo Extract Data API:
Picture
Picture
​The call on HWA Side with a RESTFUL Get Job:
Picture
​The response on HWA Side returned would be as follows:
Picture
As noticed from the Form, all details Scanned like the Address of the Claimant, Date, Hospitalization Claim, Insurance Claim Number, Medical Bills Amount, OPD Bills Amount, SSN Number, Tax Identification Number, Total Claimed Amount, Type, id etc. are extracted successfully.
​
Upload Insurance Form Data:
To Upload the Insurance Data, the company employs a job in the flow which uploads this data via a RESTFUL Job into an Internal Mongo DB storing Customer Data.
An API developed by the company for CRUD Operations is leveraged for the Upload into Mongo DB.
RESTFUL call from HWA:
Picture
Picture
​Upload into Mongo DB through HWA Job:
Picture
Scan Images from Documentation Set:
​

The Documentation images are scanned via the same Docusumo “Extract Data API” and the data is extracted from the Documentation Set capturing all data in the Documentation proofs in JSON Format.
Picture
Upload Images from the Documentation Set:
​

A RESTFUL Post Job to call the API would upload all Data captured from the Documentation set into the Mongo DB as desired, here the job makes a call such as:
Picture
Picture
Completeness Check on Documentation Data:
​

The completeness Check on Form Data can be made by making a RESTFUL GET Call via a HWA Job into the same MongoDB serviced via an Internal API running in the background:
Picture
As noticed, details like Address, Hospital Bill No, Hospitalization Charges, Medical Bill Charges, Medical Bill No, Name, OPD Bill No, OPD Charges, Phone Number, SSN Number, Type, id etc are captured, some of the fields captured are Blank here like the Medical Bill Charges Field, Medical Bill No etc. are captured as N/A indicating a problem on Completeness.
 
This Particular job has a Conditional Dependency check for the characters N/A Returned in a field to translate as a Condition called “NOT COMPLETE”
Picture
This would in turn call another Mailing Job to send an Email intimating that the Documentation is not complete, so that Customer is intimated that the Claim is on Hold for now:
Picture
Insurance Data Completeness Check:
 
The Completeness Check of Insurance Data is also made via a RESTFUL GET Job whereby any misses in the Form Completeness can be captured readily and the same can be intimated in real time via an Email.
Picture
A Similar conditional Dependency on the job ensures that in case should any Data return N/A, the same is captured and the condition satisfied, all details like “Address of the Claimant”, “Date”, “Hospitalization Claim”, “Insurance Claim Number”, “Medical Bills”, “OPD”, “SSN Number”, “Tax ID no”, “Total Amount Claimed”, “Type” are captured.
Picture
As the Capture is complete, the Mail Notification job is suppressed in this case:
Picture
​Further we have Conditional Dependencies from these Mail Intimation jobs also to mark the Claim as Registered in “COMPLETE” State which would only happen when both the Mailing Jobs go to SUPRESS State.
Picture
Whole Flow as it looks at HWA Side:
Picture
Picture

Authors Bio
Picture
​Sriram V, ​Senior Technical Lead
​

I have been working with Workload Automation for the last 14 years , have had a chance to work with 100+ Customers from various industries as an Implementer , SME , India SME in IBM before also getting a chance to directly work on the Product Support Side as a DevOps Engineer on IBM SaaS Offering of the Product ,also had a stint with Lab Services Team developing Conversion Utilities to move from Competition,  have been working as a Technical Advisor on the Product lately on the Tech Sales Side.
View my profile on LinkedIn
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    January 2020
    December 2019
    November 2019
    October 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

    Categories

    All
    Analytics
    Azure
    Business Applications
    Cloud
    Data Storage
    DevOps
    Monitoring & Reporting

    RSS Feed

www.hcltechsw.com
About HCL Software 
HCL Software is a division of HCL Technologies (HCL) that operates its primary software business. It develops, markets, sells, and supports over 20 product families in the areas of DevSecOps, Automation, Digital Solutions, Data Management, Marketing and Commerce, and Mainframes. HCL Software has offices and labs around the world to serve thousands of customers. Its mission is to drive ultimate customer success with their IT investments through relentless innovation of its products. For more information, To know more  please visit www.hcltechsw.com.  Copyright © 2019 HCL Technologies Limited
  • Home
  • Blogs
  • Forum
  • Resources
  • Events
    • IWA 9.5 Roadshows
  • About
  • Contact
  • What's new