Operator Skills & Certification Matrix: One Grid for Who Can Run What
Stop asking the supervisor who's trained on which machine. Build a live skills/certification matrix — proficiency levels, certified and expiry dates, a supervisor approval gate on every grant, email alerts before certs lapse, and a cross-training gap report that flags single-point-of-failure skills.
A logged-in web app where you enter operators, skills, and certified/expiry dates, view a live matrix of who can run what at which proficiency level, approve every skill grant or recertification through a supervisor gate before it counts as current, get email alerts before certs expire, flag single-point-of-failure skills, and export both the matrix and a cross-training gap report as CSVs.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- Your list of operators, the skills/certifications you track, and any expiry rules
- Claude Code or any AI coding agent
The problem this kills
Who can run the press brake on second shift? Whose forklift cert expired last month and nobody noticed until the auditor asked? Who's the only person trained on the laser, so when they call in sick the cell sits idle? Right now those answers live in a supervisor's head, a laminated sheet taped to a filing cabinet, and three different spreadsheets that disagree with each other. Scheduling guesses. Cross-training never happens because nobody can see the gaps. And an audit becomes a fire drill of hunting down training records that may or may not exist.
A skills matrix isn't a fancy idea — it's just the one grid every plant needs and almost nobody keeps current. The reason it goes stale is that updating it is annoying, there's no control over who marks someone "trained," and time-bound certs quietly expire with no warning. You don't need an LMS the size of a building to fix this. You can build a clean, governed skills matrix yourself, in an afternoon.
What you'll build
A single internal web app that becomes the one source of truth for who can do what. You enter your operators, the skills and certifications you care about (machines, processes, safety certs), and for each operator-skill pairing a proficiency level and the certified / expiry dates. The tool shows it all as a live matrix — operators down the side, skills across the top, every cell color-coded by level and certification status. A supervisor or trainer approves every grant and recertification before it shows as current, so the grid you trust is actually trustworthy. Resend emails an alert before any time-bound cert expires, so it never lapses unnoticed. And a cross-training gap report flags the dangerous spots — especially single-point-of-failure skills where exactly one person is trained — so you know where to train next. You can export both the matrix and the gap report as CSVs for scheduling and audits.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your plant — your real operators and shifts, the exact skills and certifications you track and how you name them, your proficiency scale (do you use "trained / qualified / can train others," or numbers, or something else?), which certs are time-bound and how long they last, who is allowed to approve a grant, and the messy edge cases like a partial qualification or a cert that needs an outside provider. It reads a short spec back to you for a thumbs-up, then builds the matrix around your floor instead of a generic template. From there it walks the agent through the data model, the entry screens, the live matrix view, the approval gate, the expiry alerts, and the gap/single-point-of-failure report — each step ending with a ready-to-copy prompt.
The governance it includes (this is the point)
This is the part that makes the grid trustworthy instead of just another stale spreadsheet. The plan builds in login so only your team can use it, row-level security so a site or plant only ever sees its own people and skills, and a complete audit trail of every change — who granted which skill to whom, at what level, and when. The human gate is the heart of it: nobody is "certified" because someone typed it in. A skill grant or recertification is drafted, then a named supervisor or trainer reviews and approves it, and only then does it count as current on the matrix and in an audit. A duplicate guard keyed on operator + skill keeps the same person from getting two conflicting records for one skill. That's the difference between a matrix an auditor believes and one they pick apart.
Who it's for
Production supervisors and team leaders who schedule around who's trained, training coordinators who run cross-training, and HR or quality staff who have to produce certification records on demand for an audit. If you can list your operators and the skills you care about, you can build this.
You've got this — open the plan, paste the first prompt, and you'll have your first real skills grid this afternoon.