Case Study: Rebate Tracking and Validation Problem

Problem Summary: Growing number of rebate requests coming in per month, Growing number of distributors and contract agreements, Submitted data was inconsistently formatted and came from multiple sources , Team was no longer able to validate all the incoming requests… solution?