Ctrip Data Transformation

Extracts data from a ZIP file, performs several transformations and audits, then creates a new archive file for loading process. Email notifications sent as needed throughout the data flow.