Data Extraction & Mapping Software
Project Overview
The Product Database team currently handles benefit changes manually, consuming substantial time. We were tasked with a solution aimed at reducing labor hours, streamline this process, and improving efficiency
As a Senior UX Designer, I collaborated with stakeholders to define product strategy and design direction. I oversaw the end-to-end execution of the UX design process, managed junior designers, and ensured quality control.
Team
Design Manager - Chandrashekar Mehra
Senior Designer - Gnanaeshwar Srinivas
UX Designers - Rishobh Hota, Venkatesh Podili
Business Problem
At present, the task of renewing or changing benefits is manually handled by the Product Database team. This process, while functional, is labor-intensive and can consume a significant amount of time. The business team sees this as an area that can be improved for better efficiency and productivity. Their proposed solution is to develop a streamlined application specifically designed for this purpose. The primary aim of this application would be to reduce Full Time Equivalent (FTE) hours, thereby saving on labor costs and allowing the PD team to focus their efforts on other vital aspects of their work.
Problem Statement
Create an platform to improve efficiency, and reduce labor hours in mapping policy changes for application downstream
User Persona
Detailed User Flow
With a clear understanding of user flows, we can streamline multiple processes, reducing friction, and ensuring that users can achieve their goals with minimal effort.
Wireframes
Wireframing our solutions helps map out the hierarchy of functions and focus on capturing the service portal's core purposes. This enabled us to validate our preferred design direction with stakeholders.
Final Product
Systematic and intuitive data extraction
The new mapping software allows quick and easy extraction of all the data points from PDF documents. These processes previously needed to be done manually by the benefit coder and presented opportunities for errors. The new system uses an in-house developed AI screenreader to extract all the necessary information while also allowing benefit coders to edit and add variables in case of accidental omission by the AI.
Validate and compare extraction
The new feature enables users to compare data extracted from various documents side by side, allowing them to verify the information before moving forward. Users can also easily flag any discrepancies if values differ across different documents.
Quicker Variable mapping
Variable mapping is a crucial feature for success. Previously, benefit coders manually mapped each variable on an Excel sheet and waited for days for verification, if there were no errors.
The new feature allows benefit coders to automatically assign and map variables using a dropdown menu, which has over a 90% likelihood of matching the variables with the help of AI. This reduces the time for verification from 3 days to just 3 hours and significantly improves the accuracy of mapping.
Testing
Our key objective was to measure the usability of our solution through observing user interactions the following keys flows.
Data Extraction from Client intent letter and sales comments
Verify and validate consolidated data extraction. Raise Discrepancies in case of issues.
Data Variable Mapping flow
© Gnanaeshwar 2024