Portfolio
Area E—Clinical & Commercial Ops
CPT Exam Codes Dashboard & Version Comparator
Catalog analytics · change detection
Thousand-row manual catalog diffs replaced by an automated change report.
- change types detected
- 4
- change types detected
- manual row-by-row diffs
- 0
- manual row-by-row diffs
01/Problem
CPT catalogs are large, facility-specific and constantly revised. Querying them meant ad-hoc SQL, and every release meant someone manually diffing thousands of rows.
02/Approach
A two-mode Streamlit app: a Polars dashboard with facility, modality, body-region, contrast, laterality, RVU-range and regex filters; and a comparator computing modified, added, removed and expired codes between any two files, with field-level diffs and an Excel summary. Normalization ensures the diff reflects real changes, not formatting noise. Containerized on GCP behind nginx.
03/Outcome
- Manual multi-thousand-row reconciliation eliminated.
- Self-service catalog visibility across every relevant dimension.
04/My role
- Directed the diff tool be built properly once — the difference between a tool operations trusts and one they double-check by hand.
Stack
StreamlitPolarsDockernginx