Etl And Data Warehouse Developer – Technical Solutions Group
Development and deployment of a variety of database and data warehouse solutions for BI-based operational and customer SLA reporting. These customers include the following: British Aero Space, Este Lauder, Ingalls Ship Building, Nissan, Raytheon, Textron, Westinghouse and Zurich Financial Services. Developed many ETL methods using Visual Studio 2005, 2008, 2010 and 2013. • Standard and custom data extraction techniques using table-driven parameters passed to SSIS packages to support near real-time reports. Sources included: Oracle, MS SQL Server, Web Services, and Excel, CSV files.o VB.Net Script Tasks to extract data and create CSV files and either SFTP or email to various parties.o VB.NET Script Task to handle and process MS SQL Server Change Data Captureo Developed Staging and Operational Data Stores (ODS) used with above ETL solutions. • Standard and custom staging ODS databases based on customer requirements. This includes the development of stored procedures to transform and load the data into ODS tables.• Design of conformed dimensions to support reports based on ITIL process areas. This was needed to maintain minimal dimension tables in order to keep down cube processing times.