Data Cleansing and Migration
ILW helped a large propane distributer standardize their Point of Sale (POS) and accounting systems for 600 distributors on a customized SAP solution.
ILW created the data cleansing and conversion framework to read distributor data from the legacy POS system and apply several hundred data profiling and cleansing routines. The framework captured data quality and cleansing metrics for management and produced reports for each distributor. Millions of records were converted over the course of the effort.