PAN Specialists tracked patient lists by hand in Excel and Google Sheets, switching between three or more tools to build one view of a patient. That cost each specialist 8.5 hours a week of admin work that should have been automated.
Worse, nobody could see the whole patient population. Clinicians made decisions from partial pictures.
The SNF Census. Every PAN Specialist kept their own version in Google Sheets
8.5 hrs
Weekly admin overhead per specialist
50
Specialists surveyed, all on spreadsheets
3+
Tools to assemble one patient view
Solution
One customizable table. Patient data, front and center.
We designed a smart table inside Episode Connect that puts patient data where clinicians already work. Specialists follow or unfollow patients, act on key info inline, and jump straight to a full profile.
It connects to activity feeds and clinical notes, so scattered data becomes one workflow. Filters, sorting and quick actions live in the row.
Episode Connect design system: semantic color tokens
Patients FollowedFeature view
Process
Research first. Then design. Then iterate.
Six phases of agile research and design. 50 PAN Specialists gave the feedback that shaped it. I tested it with InVision prototypes and worked closely with engineering to ship it. In all, I ran 75+ user research sessions.
01
User Research
SNF Census survey · 50 PAN Specialists · field interviews
02
Analysis
Translate findings into user needs and feature requirements
03
Design + Prototype
Design system components · InVision clickable flow
04
User Testing
Live demo sessions · usability feedback collected
05
Iteration
Design and requirement updates based on feedback
06
Handoff + Wins
Dev-ready specs · research shared across the org
Impact
The workarounds went away. People used it.
Spreadsheets gone
No more Excel or Google Sheets exports. Patient data lives in the system, where it belongs.
Usage up 30%
I pitched, designed and shipped Patients Followed. It flags patients falling out of the system because of incorrect DRG codes, and usage grew 30%.
Team alignment
It showed product and engineering what agile research and shared design system work can do.