A leading vision care Practice management company builds Data Warehouse and Analytics to provide Practice administrative services solutions to its customers
The Business Issue
- Build a data warehouse comprising of data from multiple practices EMR/EHR systems.
- Reports/Dashboard for management team/stakeholders to visualize consolidated data across all practices.
- Comparative analysis of data across various practices by Doctors, Locations, Insurance Payer, CPT Codes.
- Financial data to be collected from MS Dynamics.
- For NextGen (NEP, SEC, RCN Practices) EMR systems, data was collected from files provided by their vendor.
- Designed a reverse engineering model for New Eyes (EMR System) to fetch data directly from the SQL database.
- Practice data was collected, converted into a common format and loaded into DWH.
- The design was made simple and dynamic so that a new practice can be added with a simple process.
- Intelligent dashboards and reports made available to stakeholders for analysis & sound decision making resulting
- Enabled proactive Business management