• Six years of experience in developing, maintenance and enhancement projects in Data Integration, Data Migration and Data Warehouse technology solutions. • Extensively worked on Data Warehouse environments with domain knowledge in Insurance • Informatica (Data Integration): 6 plus years of experience in Data Warehousing and Extraction, Transformation, Loading (ETL) of data from various sources into Data warehouse and Data Mart using Informatica Power Center 9.1/8.6. • Database: 6 years of Database experience using Oracle 11g/10g/9i; Experience in working with databases like MS SQL Server 2000/2005, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader. Well versed in using TOAD, PLSQL Developer 3.0 interfaces. • Data Quality & Analysis: 3 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis. • Data Modeling: 4 years of Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0, Dimensional Modeling, Ralph Kimball & Bill Inmon Approaches, Star/Snowflake Modeling, DataMarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling. • Extensively used database objects like tables, Index, views, Materialized Views triggers, Packages, functions and procedure. • Programming: Well experienced in Oracle SQL, PL/SQL scripts and UNIX shell scripting. • Well-versed with Configuration Management using version control systems and working under structured and controlled Change Management system. • Expertise in preparing Functional & Technical Specifications besides User Guides. • Experienced in Coordinating and leading off shore Development team. • Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.