MTR Traceability Register from 180,000 Mill Certificates
EPC Contractor, India — India
Payment released on schedule. Zero traceability gaps at inspection.
180,000
MTRs Processed
400+
Global Mills
247
Traceability Gaps Found
On Schedule
Payment Released
An EPC contractor in India needed 100% material traceability across 180,000 mill certificates from 400 global mills before the asset owner's inspector would release final payment. The QA team was manually keying data at 15 minutes per certificate.
The Challenge
180,000 mill test records across 400 different global mills — no standard format, no consistent layout.
QA team manually keying data at 15 minutes per certificate. At that rate, the register would take over 18 months to build.
The asset owner's inspector required 100% traceability: every spool item matched to its MTR with heat number, chemical composition, and mechanical test results.
Final payment release was conditional on passing the traceability review. Any gap would delay payment.
Our Approach
Ingested all 180,000 MTRs regardless of mill, format, or layout — PDFs, scans, and digital certificates.
Our models extracted heat number, chemical composition, mechanical test results, and material grade from every certificate.
Structured the extracted data and matched it against PO line items and spool item numbers.
Produced a comprehensive gap report: 247 spool items with no MTR on file, with specific PO references and expected mill sources.
The client's QA team used the gap report to request missing certificates from mills before the inspector arrived.
Delivered the complete traceability register in a format ready for the owner's review.
Results
All 180,000 MTRs processed and structured — regardless of mill format or layout.
Heat numbers, chemical compositions, and mechanical test results matched against PO line items.
247 traceability gaps identified — spool items with no MTR on file — with specific references for resolution.
Client resolved all gaps before the inspector arrived.
Final payment released on schedule — no delays, no disputes.
The gap report that would have taken a QA team a month was delivered in two weeks.
“We would have spent three months building this manually and still had gaps. Pathnovo gave us the gap report in two weeks that would have taken a QA team a month to produce.”
QMQA Manager
EPC Contractor, India
Documents Processed
Mill Test Records (180,000)
Purchase Orders
Spool Tracking Sheets
Capabilities Used
Target System
Material Traceability Register
Have a similar project? Let's talk.