Work experience encompassing Enterprise Architecture Planning, Data Administration (SQL Server, Oracle), Data Warehouse/Mart Development, Metadata Management, ETL (Informatica, SSIS/DTS, Datastage), Information Strategic Planning, Business Needs Analysis and Project Management
Extensive IT experience in Design, Development and Implementation of Data Warehouse/Data Mart (Star Schema / Snow-Flakes, ODS) - Dimensional Modeling using Kimball and Inmon methodologies
Expertise in analyzing RDBMS and ETL (Informatica and SSIS/DTS) Performance Issues
Expert level knowledge in T-SQL, Oracle-SQL, PL/SQL & Teradata-SQL
Experience in conducting JAD sessions with business and technical subject matter experts to capture business and IT process requirements
Extensive experience with Logical/Physical design experience with Oracle and SQL Server Databases - both OLTP & Data Warehouse databases using Erwin, Visio and SQL Server Enterprise Manager
Proficiency/Work experience with vari