Case study · Illustrative example

Reading supplier test certificates in minutes, not by hand, for a pharma plant

Illustrative example. This shows how an engagement of this kind typically runs. It is not a report of a specific client's project, and the figures are typical outcomes, not measured client results. Your numbers depend on your data; the readiness assessment tells you what to expect.

The typical situation

Every incoming raw-material lot comes with a supplier certificate of analysis, as a PDF or a scan. QC staff read each one, check the values against the specification and type them into the lab system. It is slow and it is exactly the kind of work where tired people miss things.

A regulated plant cannot let a model approve anything. It can let a model do the reading, provided a person checks the result and every check is recorded.

What the data looked like

Two years of certificates from about 40 suppliers, the specifications for each material, and the values QC staff typed into the lab system for the same lots, which give the correct answer for every document.

What we built

  • Extraction of every test, value and unit from each certificate, with the source location highlighted for the reviewer.
  • An automatic comparison against the specification, flagging out-of-limit or missing tests.
  • A review screen where QC staff confirm or correct each certificate, with an audit trail of who changed what.
  • Accuracy measured per supplier, so a new or messy supplier format is spotted early.
Your systemsClean data layerModel or rulesAlerts and reports

Typical outcome

MeasureBeforeAfterPeriod
Time to process one certificateabout 8 minutesunder 2 minutestypical outcome
Fields extracted correctly on a reviewed sampletyped by handabout 97%typical outcome

What usually trips these projects up

Accuracy is uneven across suppliers. Reporting it per supplier from the first week, not as one average, is what keeps QC staff willing to trust the screen.

Have a similar problem?

Tell us what is going wrong and what data you keep. The first conversation is free and usually ends with a straight answer about whether this is worth doing.