Harland Clarke Customer Engagement SolutionsSr. Datawarehouse Engineer
Jan. 2000 - Oct. 2014Backend Technical Lead for ETL processes for Custom Datawarehouse that provided extracts and reporting for internal and external users. - Develop, Support and maintain SAP DSOs and cubes to support Internal and external reporting. - Develop, Support and maintain backend applications in Datawarehouse environment. Applications developed using combination of Microsoft SSIS ETL tool and stored procedures on SQL Server 2005/2008 database on Windows 2003 Platform - Worked on Datawarehouse refresh project that involved backend ETL conversion Informix/UNIX to SQL server 2005/Windows 2003.Involved in different phases of project life cycle including design, coding , testing with Microsoft team. - Develop, Support and maintain backend applications in Datawarehouse environment. Applications developed using combination of IBM DataStage ETL tool and scripts and stored procedures on IBM informix database on UNIX platform. - Upgraded and enhanced existing marketing and finance applicaions in Datawarehouse using Datastage ETL tool and Unix scripts. - Provide Support and troubleshooting for Datawarehouse weekly , monthly and quarterly load processes.