Data Mapping & Reporting Design
Summary
A large health plan transitioned to a new UM system and had perceived data quality issues based on results from back-end dashboard reports.
Our Role
We provided a project lead and two technical resources to conduct a full data mapping and modeling of front-end fields to the back-end database.
Results
Conducted data mapping walk-throughs with technical and operational teams to understand how data would be represented in the back-end dashboards
Updated all data models to reflect gaps and issues identified in the overall analysis.
Created data flow diagrams, enhanced data dictionaries, and built data mapping assets for the entire enterprise.
Resolved a list of 100+ defects logged by reporting end-users and increased the overall confidence level of dashboard reports.
Sample Deliverables