How would you handle nulls, duplicates, and inconsistent data formats in legacy manufacturing systems at ATC Manufacturing?