Web tool that traces production data errors and finds incorrect data configurations on the lines, a check that used to be done by hand.

• Pulls production data from Oracle and compares the MES schemas automatically with CTE-based queries, flagging each case as MATCH or MISMATCH

• Cross-references live factory data from MS SQL Server and PostgreSQL

• ASP.NET Core REST API that keeps the reporting logic apart from the UI

• React and TypeScript UI that shows production line errors in a form the floor team can act on

• Tuned SQL queries and stored procedures to cut report time and fix data latency