Motor Industry – Rules based data collection
Client: Provider of administrative services to over 200 motor vehicle dealerships across Australia.
Problem: Need to combine data from all of the dealerships each month (200+ files). Data sourced from different systems/vendors in inconsistent formats.
Solution: Rules-based solution to append all of the data together, apply transformations and perform validation checks – that can be maintained entirely by the business.