Training Compliance Checker

Recreation notice: this is an interactive recreation of an internal tool, rebuilt for this portfolio with entirely synthetic data. No proprietary systems, names, endpoints, or data are used or referenced.

Try it: pick a shift preset and hit Update. Then search the results, sort columns, and export the CSV: it downloads for real (synthetic rows only).

The problem

Official training-compliance metrics lagged reality by hours or days. An associate could be assigned to a process they weren't certified for at the start of a shift, and nothing would flag it until well after the fact. Training managers needed the answer to a simple question, live: "Who is working right now without the required certification?"

The tool

Two systems, joined in the browser. A live workforce system knows who is assigned where; a training portal knows what everyone has completed. The script queries both and joins them client-side.
Configure once, run forever. An administrator maps each labor process to its required certificate(s), including OR-logic (Cert A or Cert B satisfies), and the mapping is shared as importable JSON. After that, users only pick a site and a time window; every configured process is checked automatically in one sweep.
Audit-ready output. A searchable, sortable results grid with an overall compliance gauge, links to each flagged employee's full transcript, and one-click CSV export for documentation and retraining scheduling.
Shift-aware. Saved shift presets ("Night Shift", "Morning Shift") make the daily check a two-click routine before start-up meetings.

Impact

Built while working as a Learning Trainer, the script grew from one building to 705+ active users across multiple sites, surfacing compliance gaps in real time, ahead of delayed official metrics, and giving trainers a concrete daily worklist for retraining.

What the demo shows

The complete workflow on synthetic data: 60 fictional employees, 10 visible processes (of a configured 28), staged progress messages that mirror the real fetch pipeline, matching with OR-logic certificate rules, and a genuinely working CSV download.