Frutarom required data from its global operations (daily) to facilitate consolidated reporting. Engaged to develop a robust batch solution to automate this process. Engaged with key stake-holders; assessed business/ data requirements; designed data extraction using Transact SQL; created DTS / SSIS packages; developed FTP script for file transfer and led testing. Succeeded in creating a fit-for-purpose solution that facilitated use of a sophisticated EIS system that has enhanced business decision- making.