Data Warehouse Sql

PROFESSIONAL SUMMARY:

About Seven years of progressive expertise in Application design, data modeling, configuration, development and implementation of Data warehousing and Business Intelligence Application.

Experience in OBIEE 11g/10.1.3.x/Siebel Analytics 7.x, which includes Administration tool, Intelligent Dashboards, Oracle BI Publisher, Repository building, Answers, Delivers, iBots and Oracle BI Applications (DAC).

Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges),

Strong experience in building Siebel Analytics/OBIEE Repository (.rpd file) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer) using Administration Tool.

Experience in creating Logical tables and columns, Dimensional Hierarchies, Cache monitor, Level Based Measures, Time series data, and Repository Variables.

Experience in implementing cache seeding and purge mechanism after the loads.

Extensive experience in using OBI Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.

Strong Knowledge of Data Warehousing concepts and Dimensional modeling using Star schema and Snowflake schema.

Strong knowledge in Data warehousing development using ETL tools such as Informatica Power Center 8.x/7.x.

Experience in developing Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.

Experience in using Data warehouse Administration Console (DAC) to schedule and run Full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.

Strong experience in using different Informatica Designer Components.

Experience in writing SQL queries, creating different PL/SQL Objects and using SQL*Loader for loading data into Data Warehouse/Data Mart.

Experience in creating SSIS packages using pivot transformation aggregate, execute SQL task, data flow task and execute package task to export clean data from text file, MS Access and CSV files to data warehouse.

Profound knowledge of Systems Development Life Cycle (SDLC).

Excellent problem solving skills with strong technical background and good interpersonal skills.

Excellent team player and quick learner, with ability to meet deadlines and work under pressure.

TECHNICAL SKILLS:

BI Tools/Analytics : OBIEE11g, 10.x, Siebel Analytics 7.7.

ETL Tools : Informatica 8.x/7.x.

Database : Oracle 11g /10g/9i/8i/7.x, SQL server 2000/2005.

Scheduling Tools : DAC (Data warehouse Administration Console).

Languages : C, UNIX, SQL, PL/SQL, HTML, XML.

Oracle Tools/Utilities : SQL*Loader, Oracle Designer, SQL Developer, TOAD, SSIS,

SSRS.

Operating Systems : Windows Vista, Win 95/98/2000/2003/2007/XP, Linux, UNIX.

Contact this candidate