Database Design

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