Recent Projects
Self-Service Analytics - Empowering clients with on demand data.
2023
The Innovative Healthcare Collaborative of Indiana is unique in that it is an ACO (Accountable Care Organization) combining two key organizations - Community Health and Deaconess Health of Indiana. As an ACO they had a strong interest in showing both their clinical and claims data as close to real-time as possible using tools such as ADT and developing end-user tools such as PopAnalyzer.
This is a current 4-part focus including:
Preparing the data sources correctly and configuring Pop Analyzer to read them. (A on-demand data visualization tool)
Build care flows that align with their unique care pathways.
Build and train the client on how to create high-interest populations such as predicted high-risk.
Integrate external tools such as the ACG engine.
Ambulatory Analytics: A focus on Access optimization.
2023
Ambulatory Analytics is at the heart of clinical access outside of the hospital. It's knowing and having access to your primary care provider and associated physicians.
This project focuses primarily on patient access. It emphasizes how the schedule at an office exists to optimize its performance and access. It also focuses on staffing by predicting the busiest time of day and week so the office is staffed for appointments, calls and consults.
This is a 6 part focus including:
Schedule utilization and patient lead time.
Appointment reschedule volume and analysis.
Waitlist utilization and analysis.
Cycle time utilization and analysis.
Blocks and Slots utilization and analysis.
Provider Productivity Measures to close gaps.
Talent Acquisition - How to gain and retain high-level talent.
2022
In increasingly uncertain economic circumstances, a partnering organization wanted to increase its level of talent acquisition to effectively both incentivize and retain its talent pool.
To do so, I had to first understand and identify the gaps in talent acquisition and then create a framework around an improvement strategy.
This is a 9 part focus including:
Requisition Analysis
Talent Pipeline Analysis
Posting Analysis
Sourcing Analysis and strategy
Offer Analysis
Interview Analysis
Compliance strategies
Equity and Diversity Analysis
One large summary overview containing elements of each.
Denodo: A use-case for data virtualization.
2022
The goal of this project was to take data from various sources across the system and make them easily accessible and reportable to the client.
is was a 3-part focus including:
Mapping multiple sources together including Oracle SQL databases, MS SQL databases, Excel files, CSVs, and text files, and placing them into a data virtualization layer.
Creating an API access point (and virtual table) where end-users have in essence a one-stop-shop for all their data needs.
This project focus was on HR, supply chain, ACO, finance, and clinical Data.