Experience in Analysis, Design, Development and Maintenance of various software applications in Data Warehousing. Extensively worked on SQL and PL/SQL - Stored Procedures, Functions, Packages, Cursors, Triggers, Indexes, Views and Inline Views. Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and denormalization Concepts. Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs- Type1, Type3&Type3). Have good knowledge on Tableau, Teradata, OBIEE and Business Objects (BO XI r2). Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses.
