Topic Accelerating reach to Health Care Insurance Service Providers.
Need:
- A leading U.S. healthcare insurance provider realized that meeting customer expectations and demands in reaching out to the nearest service provider can significantly boost its business agility and operational efficiency.
- Problem Statement was to figure out a consolidated list of health service providers providing the Insurance Plans and located within the given radius across the US Location Map to have faster access and can be consulted for any queries in no time.
- Regularly updating the list of service providers based on their locations so that users residing near them would be able to reach out to them in minimum time. This ultimately targeted on the need of maintaining and updating huge amount of detailed data at once.
Solution:
Mindful of the insurance provider’s need to minimize disruption during and after the implementation, we recommended the best suited architecture keeping in mind all the system-based requirements like :
- Develop a radius-based algorithm that can provide the zip codes of associated service providers based on their location and fetch the relevant details like contact numbers, address, specialized area etc.
- ETL tool to be used for data cleaning before storing the data into DB using ETL loading.
- Restful services helping to connect the UI with Java developed business layer and DB, providing better security.
- NoSQL Database MongoDB to be used to make the huge data storage and retrieval less costly and more effective.
- Bulk uploads using simple csv format to be used for upload of bulk data using ETL layer to validate and cleanse/update data before upload.
Benefits:
Real time access to the need – Service Provider details who can provide information about the Insurance plan that the customer is looking out for :
- Low data management and maintenance cost.
- NoSQL database helping save time and space for Data Storage.