CASE STUDY:
MNsure
TECHNOLOGY USED
ABOUT MNSURE
For over five decades, MNsure has been Minnesota’s official health insurance marketplace. Its mission is to ensure all Minnesotans have the security of health insurance. Since MNsure was established in 2013, it has helped more Minnesotans than ever before get covered – and stay covered – with affordable, comprehensive health insurance.
THE SITUATION
- Created a new database flow that brought citizens through a series of questions that determined their eligibility status using Caspio’s rule functionality.
- Upon hitting complete on the application an application is sent to the queue of the call center’s Microsoft Outlook inbox. This was achieved by sending a notification via email through the .NET API when the application’s timestamp was logged in the database.
- Also upon completion of the application another API through.NET is sent to the State’s File net system for verification that that citizen is eligible for the insurance they signed in the zip code they have residence in. This took seconds and saved six weeks per application and millions of dollars.
- Created a HIPPA complaint authentication system where citizens can update their life events as they happen so their insurance can be adjusted through Caspio. The authentication system verified four pieces of PII from the citizen’s application to gain entry to the portal. Once in the portal they were able update any life event.
THE SOLUTION
In order to better understand their needs, a number of meetings were done both in-person and virtually to see the capabilities of the current software. Current reports and newly requested reports were gathered to help determine how the database needed to be developed. Once the infrastructure needs were understood, the Solutions Afoot team worked to map out the new table structure and flow of website pages. Since the new solution would be cloud-based, an updated look and feel was created to allow users to easily access the various website pages and information needed to perform their daily tasks. Below are a series of major tasks that were accomplished to create the new SaaS used by Excalibur:
- Relational Database Development: Created a series of tables where unique identifiers allow for the tables to be easily connected. The process included defining tables, relationships between tables, and enforcing data integrity constraints.
- Role-Based Authentication: Each role is assigned specific permissions that dictate what actions a user can perform. The admin users are able to access special reporting and data entry pages that employees working in the warehouse cannot access. By defining roles and permissions, Excalibur can enforce security policies and maintain strict control over who can view or modify client and project data.
- Complex Audit and Calculation Development: Since multiple people would be using the platform, and not all entries would be added live, a series of complex triggers and tasks were developed to ensure the audit trail accounts for all transactions down to the tenth of a cent ($X,XX.XXX). The ability for users to pre-date an entry and timestamp when the entry was submitted are just part of the ways a detailed audit trail was developed.
- Custom Front-End Development for Enhanced User Experience: Excalibur had a very specific look and feel. In addition, they wanted the various website pages to provide similar functionality to the current software being used. A special front end was built using HTML5 and CSS to make sure their branding was utilized while also ensuring the user experience matched their desired output.
THE RESULT
MNsure now has a HIPPA compliant portal that protects their citizens and allows them easier management of applications, insurance verifications and life event changes through one portal savings them time and money.
