Data Warehouse Architecture,Modeling, Requirements, Analysis, Design, ETL • 10+ yrs of architecting, analyzing, designing, modeling & loading Enterprise Data Warehouses and star schema data marts • 10+ yrs ETL data migration with 6+ yrs Informatica PowerCenter, Datastage, SQL & more• 10+ yrs Database modeling, design and tuning for Oracle 8i - 10g, DB2/UDB, MS SQL Server, Informix • 10+ yrs Business Analysis using Cognos FrameWork Manager and ReportNet, Brio, Essbase, Excel 2007Data Warehouse and Data Mart Design, Modeling and Architecture • Designed Data Warehouses and star schemas for clients in Healthcare Insurance and Financial industries• Full Data modeling (including conceptual, logical, physical, metadata and DDL) for both OLTP and OLAP applications using Erwin & other tools• Developed full lifecycle architectures for Staging, Data Warehouse / ODS, MDM, Star Schemas and various BI applications Informatica, ETL • 6+ years as mapping and developer, administrator and consultant thru PowerMart and PowerCenter 7.1 / 8.x • Expert at data quality analysis, integration of multiple data sources; metadata and master data managementSpecialties: Data Warehouse architecture and design, data modeling, ETL, data quality, data management, BI