Schwan's runs more than a dozen US facilities across four job groups. Skills data sits in different places, so a simple question has no answer: if the person who knows the ammonia system leaves, who else can do it?

SkillSight answers the five questions in the challenge, one page each, in the order the challenge asks them, plus a view built for the employee rather than the manager.

  • Overview: a ranked "do this first" list, plus where coverage is lowest
  • Skills: every skill in the workforce and how well each is covered
  • Future skills: what the next two years need and how far short we are
  • Succession risk: which skills sit with three people or fewer, where, and what it costs
  • Employee view: the same data seen by the person, including the skills only they hold
  • Plants and offices: every site the data covers

THE PART THAT MATTERS Most dashboards show numbers and stop. SkillSight ranks them. Every at-risk skill is scored on how much the business is hurt if it is lost, how few people hold it, and how big the gap is, then sorted. A manager gets an order of work instead of a puzzle. The formula is shown on screen, not hidden.

ANSWERING "WE DO NOT HAVE THIS DATA" Every skill page names the systems a real deployment would read from. Ammonia refrigeration is the strongest case: systems over 10,000 pounds are an OSHA covered process, so refresher training every three years and a record naming each trained employee already exist by law. Food safety has the FDA preventive controls qualified individual. One skill honestly says it has no system of record anywhere, and that is the finding rather than a gap in the tool.

HOW I BUILT IT Plain HTML, CSS and JavaScript. Four files, no framework, no build step, no dependencies, nothing loaded from a CDN, so it runs with no internet and cannot break on a bad venue network. A verification script renders every page and asserts 42 skill-and-list combinations. It caught a real bug where plans saved from one list were invisible in another.

ABOUT THE DATA Coverage percentages, per-site headcounts and employee records are simulated and the app says so on its own front page. The job groups, plant locations, the Sioux Falls build-out, the Salina expansion, the CJ CheilJedang ownership and the regulations are real and sourced. Ten sources are linked in the app. Three claims were cut during a fact check because they only traced back to blogs, and one error was corrected. The full audit is in FACTS.md.

WHAT IS NEXT Real HR data instead of seeded numbers, plans matched to people automatically, and a badge tap at a plant that pulls up that person's skills and training.

Built With

Share this project:

Updates

Submission history