MA
Portfolio

Area EClinical & 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