From 20,000 Validated Cases to an AI-Assisted Validation Engine
Executive snapshot
| Business problem | A validation team transcribed 15–20 fields per case from a degree certificate and a passport, under more than 100 conditional rules that the client revised continuously. The rules had never been written down as rules, they were dispersed across a site, per-field PDFs and update mails, and every value was typed by hand. |
| My role | I wrote the rule book the specification had never been written as, then built and maintained three tools on top of it. I defined the rules, designed the tools, tested them against real cases, and audited their output. |
| Solution | A rule book of 100+ rules covering passports, qualifications, names and dates; a Google Sites hub with one PDF per system field; a NotebookLM guide that answers a question and links back to the full rule; and a Google AI Studio assistant that turns an uploaded degree and passport into prepared field values. |
| Methods and tools | Structured rule derivation from 20,000 correct historical cases; Google Sites; Google Docs and PDFs; NotebookLM; Google AI Studio; manual sample-based validation. |
| Project status | January to August 2026. The rule book, the site, the guide and the assistant are live and in team use, with about 20 performers working a daily volume of 25–30 cases through the assistant. The autonomous agent was designed and costed, and not built. |
| Verified outcomes | 95 of a random sample of 100 cases handled by the assistant carried no field error. Performers who use the assistant now audit and correct prepared values instead of transcribing from scratch. Time saved has not been measured. |
| Key limitations | A manual sample, not a system metric. No time study, no cost saving and no ROI are claimed. The organisation later took a similar initiative forward through its IT team; I stopped developing my own version at that point and have kept the assistant running as my team’s support tool. |
1. Executive Summary
In validation, a performer receives a degree certificate and a passport and enters 15 to 20 fields into the internal case system. What goes in each field is not simply what is printed on the document. It is what the client’s specification says to put there — and that specification is more than 100 rules long, conditional, and revised continuously. Every case arrives from a different university, in a different country and language, on a differently laid out document.
Before I started, those rules had never been written down as rules. They existed as know-how, and as documents spread across a site, per-field PDFs and update mails. Performers could miss an update, spend a long time looking for the right instruction, and still apply the wrong one, because a general instruction such as “enter the name as printed” is wrong on a meaningful share of cases.
I treated the missing rules, not the typing, as the problem. I took about 20,000 previously validated and correct cases as the evidence base, grouped them by the scenario each one represented, and worked backwards from the correct answers to the decisions behind them. That took more than two months and produced a rule book of more than 100 rules written as explicit conditions: a passport’s fields are read from fixed positions in the machine-readable zone; a qualification is handled by a rule written for the country that issued the degree; a name is entered in Arabic and English or in English alone depending on the language of the document; and where a certificate carries several dates, the rule names the one that governs the field.
On that foundation I built three tools in sequence, each answering a limitation observed in the one before it. A Google Sites hub, organised by system field, with one PDF per field. A NotebookLM guide that answers a question and links back to the full rule. And finally a Google AI Studio assistant that takes an uploaded degree and passport and returns the values for the system fields.
The assistant is in daily use by a team of about 20 performers, working through a daily volume of 25 to 30 cases. In a random sample of 100 cases it handled, 95 carried no field error. One of the five is instructive: the assistant chose the wrong qualification date on a certificate carrying several dates, so I audited the case, traced the logic back to the rule book and corrected the rule. The change I care most about is behavioural: a performer no longer retypes the fields, they audit prepared values against the source document.
What I have not done is measure the time this saves, and I make no claim that it does. The agent that would remove the manual step entirely — opening the case, writing the fields, checking sufficiency and routing the case onward — I designed and costed but did not build, because it needed organisational approval, a budget and integration with the case system. Section 4.7 sets out that design.
2. Business Context and Problem Definition
2.1 How the work actually happens
The operation verifies education documents for a government ministry client whose decisions determine who may travel or study abroad. A case arrives with the applicant’s documents. A performer reads the degree certificate and the passport, decides what each of the 15 to 20 system fields should contain, and types those values into the internal system. On some cases more fields are required than on others, depending on the documents presented and on the applicant’s situation.
2.2 The rules are conditions, not answers
The client’s specification is more than 100 rules long, and the important property of it is that it is not a list of answers. It is a list of conditions. A generic instruction is wrong on a meaningful share of cases, which is why the specification is difficult to apply and difficult to hold in one person’s head.
- Passport. The machine-readable zone encodes every field in a fixed position, so the rules specify which position carries which value, with additional handling written for particular countries.
- Qualification. The value entered depends on the country that issued the degree, because degrees issued within a country follow a consistent layout while degrees issued elsewhere do not. The rules are therefore written per country, with edge cases written as their own scenarios.
- Name. The format depends on the language of the document: an Arabic-language applicant is recorded in Arabic and English, an English-only applicant in English alone.
- Dates. A certificate can carry several dates, and the rules specify which of them governs a given field.
2.3 What made it hard
- The rules were never written down as rules. They were tacit know-how. Nobody could look up a rule that had never been stated, and every new performer had to acquire them through experience.
- They were scattered. Guidance lived across a site, a set of per-field PDFs and update mails, and the client issued updates continuously. Updates were missed, and searching for the right instruction consumed time.
- They are conditional. A general instruction cannot be made safe by being general, so guidance had to be restructured before it could be shared, let alone applied.
- The cost of the work sat in transcription. Every value was retyped by hand, so time lost finding a rule was time lost checking the case.
2.4 One constraint shaped the whole design
The company permits Google tooling only, so the solution had to be built with Google Sites, Google Docs, NotebookLM and Google AI Studio. That limit did not reduce the ambition. It shaped the sequence, because each of those products answers a different part of the problem: one stores the rules, one finds them, and one applies them.
3. Data Discovery and Root Cause Analysis
3.1 The evidence base that already existed
This project did not begin with an analysis of operating data, and I do not claim a Six Sigma method, a control plan or a statistical technique. It began with an evidence base that was already in place: a reference sheet of 20,000 cases that had been validated and were known to be correct, each carrying the qualification and certificate details behind it. I used that corpus as 20,000 known-good answers — which is a far stronger starting point than an opinion about where the errors come from.
3.2 How the rules were derived
The method was deliberately unglamorous, and it is the part of this project I would most want to be judged on. I worked backwards from correct outcomes to the decisions behind them:
- Group the cases by scenario — the country of the university, the type and language of the document, the shape of the certificate.
- Ask what decision a person had to make to get the recorded value right.
- Write that decision as a condition — “when the issuing country is X, enter Y”, never “the value is usually Y”.
- Collect the edge cases that break the condition, and write each of them as its own scenario.
- Attach a worked example from the corpus, so the rule can be checked against a case already known to be right.
- Keep the book open. Every scenario met in live work was added as a rule.
Working through the corpus this way took more than two months. It is the largest single investment in the project, and it is the reason the tools themselves could stay small: the difficulty was moved into the rules, where it can be reviewed, argued about and corrected, rather than left inside an instruction that has to guess.
3.3 Root causes
| Factor | Category | How it was established | Status |
|---|---|---|---|
| Rules existed only as tacit know-how | Knowledge | No written rule set existed; the specification had never been expressed as conditions | Confirmed |
| Guidance dispersed across a site, PDFs and update mails | Process | Updates were missed and performers spent time locating the applicable instruction | Confirmed |
| The correct value depends on case context | Information design | 20,000 correct cases group into scenarios that produce different values for the same field | Confirmed |
| All values were transcribed by hand | Effort | 15–20 fields per case, entered manually from the source documents | Confirmed |
| Time lost to rule lookup rather than case checking | Effort | Consistent with observed behaviour, but never separately measured | Plausible, unmeasured |
3.4 What I did not establish
Two gaps are worth stating plainly, because they bound the claims in this document. I never measured the time a performer spent searching for a rule or typing a field, so I cannot put a number on the time that was lost or on the time that was saved. And I did not separate rule retrieval from rule application as causes; the two were addressed by the same design, and isolating them would have needed a measurement I did not take.
4. Solution Design and AI-Directed Development
4.1 The rule book — two months before any tool
The first deliverable was not software. It was the rule book: more than 100 rules, each stating a condition, the case it governs, and a worked example taken from the 20,000-case corpus. Writing it exposed the parts of the specification that had never been stated at all, including the cases where a general instruction is not safe.
| Rule family | The decision it encodes | The condition it depends on | Why it is a rule, not an example |
|---|---|---|---|
| Passport fields | Which value goes into each identity field | Position within the machine-readable zone, plus country exceptions | The position is fixed, so the rule is deterministic and can be applied without interpretation |
| Qualification | How the qualification is recorded | The country that issued the degree, because layouts are consistent within a country | The same field takes a different recorded value in each country, so a single example would mislead |
| Name | Which form of the name is entered | The language of the document presented | A bilingual name has to be recorded in two forms and a monolingual one in a single form |
| Dates | Which date on the document governs a field | The field being completed and the document type | A certificate carries several dates, and only one of them is the one the client means |
4.2 Stage 1 — a knowledge base organised by the field you are filling
The first tool was a Google Sites hub. The organising decision was to structure it by system field rather than by subject, and to give every field its own PDF holding the rules and logic that apply to it. That turned a search problem into a lookup problem: a performer filling a field opens that field’s PDF and reads exactly the rules that govern it. It also gave client updates a single landing point.
4.3 Stage 2 — asking instead of searching
Even organised this way, performers were still locating and reading. So I consolidated the whole rule set into a single written document and loaded it into NotebookLM, which answered questions grounded in that document. The detail that made it trustworthy was that every answer came back with a link to the field-specific PDF, so the performer could verify the full rule rather than rely on a short answer alone. The remaining weakness was that the answer still had to be read, understood and applied by hand.
4.4 Stage 3 — the assistant that applies the rules
So I moved the rules into Google AI Studio and built the assistant as a chat: the performer types a question or asks by voice, or uploads the degree certificate and the passport as a PDF or an image, and the assistant returns the values for the system fields, applying the rule set. Figure 4 shows the interaction as it is designed to work, and it shows a partial view of the fields, as the real interface scrolls through them.
4.5 The directed-development loop, on a real example
The assistant was wrong about the qualification date on a certificate that carried several dates. The correction is the part worth describing, because it shows how the system was improved rather than merely built:
| Step | What happened | What changed |
|---|---|---|
| Symptom | The assistant entered a qualification date that the rule did not intend, because the certificate carried more than one date | The error was located in the output, not in the performer |
| Audit | I reviewed the case against the source document and traced the logic back to the rule book | The defect was identified as an ambiguous rule rather than as a reading mistake |
| Correction | I rewrote the instruction so that it names the wording that precedes the qualification conferred date, making the intended date unambiguous | The corrected instruction was applied to every case that meets the same condition, not only to the case that failed |
| Re-test | The corrected case was re-run and checked against the source | The defect closed across the rule, not against one case |
The principle underneath this is the one I would carry to any similar problem: a wrong output is treated as a defect in the rules, and fixing a rule once improves every future case that meets the same condition. Correcting the performer would have fixed one case; correcting the rule fixed the class.
4.6 Where the human stays
The assistant prepares; the performer decides. Nothing enters a case without a person comparing the prepared values against the source document. That is not a workaround for a limitation — it is the control that makes the whole approach defensible, because a field that affects an applicant’s outcome is read by a person before it counts.
4.7 The next design — the assistant as the performer
The natural end point of this work is an assistant that performs the whole field-entry task: the interface behaves as if the performer is speaking to a manager who knows the rules, the assistant opens the case, writes the fields, checks whether the documents are sufficient, and submits the case onward. The team’s role changes with it — from producing the fields to auditing the work and maintaining the rules.
I designed this and costed it, and I did not build it. It required organisational approval, a budget and integration with the operational system, and I had none of the three. Figure 6 shows the design as I left it.
5. Project Management and Implementation
I ran this as an operational improvement project with a hard constraint on tooling and a clear rule about what I would and would not build. The phases were sequential because each one was built on the artefact of the previous one, and each was closed by a decision rather than a date.
| Phase | Period | What was delivered | The decision that closed it |
|---|---|---|---|
| Rule book | First 2+ months | More than 100 rules written as conditions, each with its scenario and a worked example from the corpus | Every case type met in live work had either a rule or a deliberate decision that it did not need one |
| Knowledge base | Stage 1 | Google Sites hub organised by system field, one PDF per field | The site was reliable enough for performers to use unprompted |
| Guided answers | Stage 2 | NotebookLM grounded in the consolidated rule document, with a source link on every answer | Answers could be verified against the full rule without leaving the tool |
| Assistant | Stage 3 | Google AI Studio assistant: typed or spoken questions, document upload, prepared field values | 95 of a random 100-case sample carried no field error, and the errors that did occur were correctable in the rules |
| Autonomous agent | Designed, not built | A four-stage design covering trigger, field population, sufficiency check and routing | Blocked by approval, budget and system integration |
5.1 The two scope decisions that shaped the outcome
I stopped at the point where the organisation took the work forward. The end-to-end agent needed an operational decision that I could not make alone: it would write directly into the case system and move cases between stages, which makes it an operational change and not only a tool. It also needed a budget and an integration that only the organisation could provide. When the organisation subsequently took a similar initiative forward through its IT team, I stopped developing my own version rather than run two competing efforts inside the same operation, and I kept the assistant live as my team’s support tool — which is where it still is, used and maintained by me.
The tool was optional, and that is the point. I set no adoption target and measured no adoption rate. Performers adopted it because it saved them time and improved the quality of the case — that is their judgement, not a time study I have run. If it had not, the correct outcome would have been that it was not used. I would rather report a tool that people chose than one that was mandated and quietly abandoned.
5.2 Risks, and how they were handled
| Risk | How it was handled | Status |
|---|---|---|
| An incorrect value enters a case and affects an applicant’s outcome | A human gate before submission: every prepared value is compared with the source document | Controlled by design |
| Rules change and earlier cases are decided on the old rule | The rule book is versioned by revision, and a change is applied to the cases that meet its condition from that point on | Partly controlled; no automatic re-run exists |
| The assistant produces a plausible but wrong value | Every wrong value is treated as a rule defect and corrected in the rule book, and the correction applies to the whole class | Controlled |
| A change to the specification is missed, as it was before | One controlled source, so an update lands in one place and reaches every tool that reads from it | Controlled |
| Passport and personal data handled in a chat interface | Google-only tooling inside the company environment; no data leaves it, and no real data appears in this document | Controlled by constraint |
| No automated accuracy tracking exists | A standing evaluation set over the rule families is specified in Section 8 but has not been built | Open |
6. Preventive Improvement
I did not run a formal Six Sigma project and I claim no belt. The preventive thinking, however, is the backbone of the design: every failure mode I could identify was answered with a control that stops it recurring, rather than with more checking or more training.
| Control | Type | The failure mode it prevents |
|---|---|---|
| One rule book, written as conditions | Knowledge control | Missed or misremembered rules; inconsistent application of the same rule by different people |
| Rules derived from 20,000 correct cases | Evidence control | A rule written from assumption rather than from cases that were already known to be right |
| MRZ positions as the basis of passport rules | Mistake-proofing | Misreading or retyping an identity field from the visual page instead of the encoded line |
| A rule per country for qualifications | Decision control | Applying a qualification rule outside the country it was written for |
| A named date for every date field | Decision control | Selecting a plausible date that the rule does not intend, which was the most common failure observed |
| Grounded answers that link to the full rule | Verification control | Acting on an answer that cannot be traced back to the rule that produced it |
| The human gate before submission | Decision control | An unreviewed AI value becoming the recorded value on a case that affects an applicant |
| Wrong value → rule correction | Learning control | The same error class recurring, because only the individual case was corrected |
What is not yet in place, stated honestly: there is no standing evaluation set that runs the rule families against known-correct cases on a schedule, there is no automatic re-run of affected historical cases when a rule changes, and errors are corrected individually rather than through a maintained error taxonomy. Those are the next controls, and they are specified in Section 8 rather than claimed here.
7. Testing and Validation
Testing happened at three levels during the build, and one measurement was taken after it was in use. They deserve different confidence, so I describe them separately.
| Activity | Method | What it found | Status |
|---|---|---|---|
| Rule derivation | Written from a group of correct cases in the 20,000-case corpus, then checked back against those cases | Ambiguities in the date rules and the country-specific qualification rules | Completed during the build |
| Rule-by-rule testing | Each rule family applied to real cases and the output compared with the source document | Rules correct in principle but ambiguous in wording | Completed during the build |
| Live correction | Wrong outputs found in day-to-day use were audited, traced to the rule book and corrected | The qualification-date rule, which was the defect behind the observed errors | Ongoing; the report button that automates this step was still in development |
| Accuracy sample | A random sample of 100 cases handled by the assistant, each reviewed by hand against the source documents | Five cases in which a field was wrong | Completed; a point-in-time manual sample |
The measurement is worth being precise about. I drew 100 cases at random from those the assistant had handled, reviewed each one by hand against the source documents, and counted a case as an error if any field in it was wrong. Five cases carried an error, which is 95 per cent correct at the level of the case. It was a manual review, with no automated tracker behind it.
8. Business Impact and Performance Measurement
The measurable result is a correctness result, and the most important result is a change in what the work consists of. Both are set out below, with the evidence status attached to each one.
| Metric | Baseline | Result | Evidence status | Validation method |
|---|---|---|---|---|
| Cases with no field error | Manual transcription; no baseline measured | 95 of 100 sampled cases | Owner-measured sample | Random sample of 100 cases, reviewed by hand against the source documents |
| Rule application | Rules were tacit and dispersed; updates were missed | More than 100 rules in one controlled source, with each scenario written as a condition | Observed | The rule book itself; client updates are absorbed in one place |
| Performer activity | Read the documents and type 15–20 fields from scratch | Audit prepared values against the source document and correct them | Observed | How the team works with the assistant in daily use |
| Field-level accuracy | Not measured | Not measured separately | Missing measurement | Requires a field-level sample; specified in the plan below |
| Time per case | Not measured | Not measured | Missing measurement | Requires a time study; specified in the plan below |
| Cases cleared to verification | Not measured | Not measured | Missing measurement | Requires case-system timestamps; specified in the plan below |
8.1 The behavioural change, and why I treat it as the real result
Before, the performer’s job was production: read the document, decide the value, type it. Now, for performers who use the assistant, the job is judgement: read what the assistant prepared, check it against the source document, correct it if it is wrong, and let it stand if it is right. That is a different job, and it is a better one to be responsible for — but it only works because a human still reads every value that enters a case. I would rather report that honestly than present a number that suggests the human step was unnecessary.
8.2 Validation plan for the measurements that do not yet exist
The following turns the estimates into measurements. None of these has been performed, and none of the targets below is presented as a result that has already been achieved.
| KPI | Formula | Data source | Period | Target |
|---|---|---|---|---|
| Case-level correctness | Cases with no field error ÷ cases sampled | Blind re-audit of a random sample of assistant-handled cases | Monthly | 100% |
| Field-level accuracy | Fields entered correctly ÷ fields audited | The same blind re-audit | Monthly | ≥ 99% |
| Rule coverage | Case types with a documented rule ÷ case types encountered | Rule book index against the case reference sheet | Monthly | 100% |
| Update absorption time | Working days from client update to rule-book revision | Rule book revision log | Per update | ≤ 2 days |
| Time per case | Submission time − case arrival time | Case-system timestamps | Weekly | Baseline first, then a target |
| Audit effort per case | Minutes of human review ÷ cases audited | Sample timing study | Weekly | Below 50% of the manual transcription time |
9. Lessons Learned and Future Roadmap
9.1 What the project taught me
- The hardest asset in an operation is often knowledge, not labour. The typing was the visible work; the rules were the actual work, and they were not written down anywhere.
- A rule has to carry its condition. A rule that only shows what the value usually looks like is not applicable — it is wrong whenever the case is not the usual one. Writing the condition is what makes a rule shareable, and it is what made it applicable by a machine.
- Derive rules from cases that are already known to be right. Nineteen thousand correct cases answered questions that no amount of opinion would have answered reliably.
- Fix the rule, not the case. A corrected rule improves every future case that meets its condition; a corrected case improves one.
- Keep the human on judgement, and keep them there deliberately. The audit step is what makes the approach defensible, and removing it would be a change in kind rather than an improvement in speed.
- Let the tool be optional. Adoption that people chose is worth more than adoption that was imposed.
9.2 What comes next
| Horizon | Step | Why |
|---|---|---|
| Immediate | Build a standing evaluation set over the rule families, with known-correct cases and expected values | Turns a point-in-time sample into a repeatable measurement, and protects against a rule change silently degrading the rest of the set |
| Immediate | Version the rule book and re-run affected cases when a rule changes | Closes the gap where a corrected rule improves the future but not the cases decided under the old wording |
| Immediate | Maintain an error taxonomy alongside the rule book | Makes the next rule improvement evidence-based rather than a response to whichever error happened to surface |
| Near term | Complete the in-app report control so performers can flag a wrong answer directly | Closes the feedback loop in the workflow rather than depending on a person noticing and telling me |
| Near term | Run the measurement plan in Section 8 and publish the results | Turns the measurements this document does not yet have into documented operating facts |
| Longer term | Take the autonomous design forward when approval, budget and system integration are available | The sufficiency check and the routing decision are the parts a performer still does, and they are the parts with the highest error cost |
10. Skills Demonstrated
The competencies below are the ones this project actually evidences. They are separated from qualifications, which are recorded elsewhere and are not claimed here.
| Competency | My contribution | Supporting evidence | Business or technical value |
|---|---|---|---|
| Business analysis and requirements definition | Turned a client specification of 100+ loose requirements into explicit, testable conditions with the case each one governs | The rule book and its rule families (Section 4.1) | A rule set that can be applied consistently by a person and by a machine |
| Root cause analysis and structured problem solving | Established that the failure was in the absence of written, conditional rules rather than in document reading, and designed each stage to remove one cause | Root cause map (Figure 2) and the factor table (Section 3.3) | The fix targets the cause instead of adding a checking step |
| Knowledge management and standardisation | Built a single controlled source with a defined update path, organised by the field the performer is filling | The rule book and the Google Sites hub (Sections 4.1 and 4.2) | Client updates stop being an event that performers have to notice |
| AI-directed development and computational thinking | Defined the expected output, grounded the assistant on the rule set, evaluated outputs against the source, and refined the instructions where they were ambiguous | The qualification-date correction (Section 4.5); the assistant itself | A working assistant whose instructions are correctable, and a loop that improves them |
| Process and workflow design | Designed the operating loop, the human gate and the feedback path that converts a wrong answer into a corrected rule | Diagram B (Figure 5) and the workflow description (Section 4.6) | An operating method the team can run and a new performer can learn |
| Testing and validation | Derived rules from known-correct cases, tested rule families against real cases, and measured a random 100-case sample by hand | Section 7 and Figure 8 | A correctness claim with a stated method rather than a claim without one |
| Project and scope management | Sequenced four phases, stopped the autonomous step at the point where approval and budget were required, and released my own build when the organisation took the work forward | The phase table and the scope decisions (Section 5) | Delivery without a duplicate effort inside the same operation |
| Change management and team enablement | Made the tool optional, released it with the rules behind it, and let adoption follow demonstrated time and quality benefit | Section 5.1 and the assistant in Section 4.4 | A tool the team uses rather than one it was told to use |