automated procedures to etl and cleanse legacy data