DATA MODELING - Relational & Dimensional using ERWin, ER Studio, Power Designer ETL using Talend, SSIS, Informatica INDUSTRIES: Mortgage, Finance, Health, Telecom, Insurance, Education and Retail DATABASES: ORACLE, MS SQL Server, DB2, Sybase, MySQL, Netezza • 16+ years of Professional IT Experience in analysis, architecture, design, development, testing & implementation, and management of Client/Server, n-tier architecture software, web applications, Relational and Data Warehousing Solutions using RDBMS and BI Tools. • Extensively experience with Talend, SQL Server DTS & Integration Services (SSIS) Packages, and Informatica for Extract, Transform, and Load (ETL) Data Warehouse technique, Business Objects Universe Designer, Deski and Webi reporting tools, Microsoft Reporting Services (SSRS) and Integration Services (SSIS) tools, ORACLE, DB 2, and Sybase. • Strong experience with Data Modeling, Data Analysis and Conceptual, Logical and Physical modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems. • Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence (BI), and Reporting Systems. • Extensive implementation of Data Modeling techniques like Super-Type/Sub-Type, Normalization and De-Normalization, Facts & Dimensions, Slowly Changing Dimensions (SCD), Star Schema & Snowflake Schema, Data-Marts, Data Warehouse, Operational Data Store (ODS), and highly normalized OLTP Data Models. • Strong management, communication, analytical and technical skills. • US Patent as co-inventor for Measuring Data Quality Over Time. • Business Intelligence, Data Governance, Standards & Abbreviations, and Data Quality. • Performed Requirements gathering Joint Application Design (JAD) sessions, Data Modeling Reviews with peers, and Architecture/Model walkthrough with stake holders and Reporting System SMEs. • Extensive experience with designing Operational Data Source (ODS), Data Marts, Reporting Solutions, Decision Support Systems (DSS), and Business Intelligence Systems. • Extensive experience in Mortgage with Collateral Analytics, Default Assets, REO, Appraisal, BPO etc.