We provide IT Staff Augmentation Services!

Data Warehouse Expert Resume Profile

SUMMARY

  • Fifteen years of extensive industry experience with Nine Years in OBIEE/Siebel Analytics, Nine years of Informatica, Six Years in OWB, two years in ODI and Twelve year of Data Warehousing.
  • Complete Solution provider of OBIEE/ETL/Data Warehouse Project from Hardware architecture, Requirement analysis till Implementation in the field of OBIEE, ETL Informatica, ODI and OWB and Data Warehouse
  • Extensive Experience in User Training of OBIEE
  • Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, Testing and Implementation of the OBIEE/Siebel Analytics/ETL/Data warehouse project
  • Extensive experience of creating star schema/Data Modelling for OBIEE/Siebel Analytics Projects
  • Hands on experience in implementation of more than Twenty five OBIEE/Siebel Analytics project, informatica/OWB/ODI project and data warehouse Project
  • Hands on Experience of upgrade of OBIEE 10g to OBIEE 11g.
  • Hands on Experience of upgrade of Siebel Analytics Application from version 7.5.x to 7.8.x.
  • Hands on Experience of Implementing Agile PLM BI Application 3.0 version and customization.
  • Hands on Experience of upgrade of Agile PLM BI Application from version 3.0 to 3.2 which includes the upgrade of data mart, oracle data integrator ODI and OBIEE application.
  • Sound technical background and strong analytical skills and very quick in problem solving.
  • Very strong aptitude of learning new technologies

Skills

Software Development

Technologies

  • Experience in gathering requirement proof of concept, gap analysis, Design, Development, Testing and implementation of OBIEE/Siebel Analytics projects
  • Complete Solution provider of OBIEE/ETL/Data Warehouse Project from Hardware architecture till Implementation in the field of OBIEE, ETL Informatica, ODI and OWB and Data Warehouse
  • Experience in Requirement Analysis, Design, Development, Testing and implementation of OWB/Informatica Projects
  • Experience in creating Stored Procedure in oracle and Sybase
  • Designed the Data Model for the data mart to store the metadata details and the Data quality results.
  • Experience in Tuning the Stored Proc in Sybase and Oracle.
  • Experience with Oracle Designer for Data Modeling
  • Experience in shell script in UNIX
  • Experience with defect prevention tool. Clear Quest
  • Experience with version control tool. Clear Case
  • Experience with TOAD.
  • Experience with Oracle SQL Developer
  • Tool: OBIEE 11g ,OBIEE 10g, Siebel Analytics 7.5.x/7.7.x/7.8.x, Informatica 5.x/6.x/7.x/8.x, DAC 7.8.x, OWB 10g, ODI 10g, ETI Tool
  • Application: BI Apps 7.5/7.8/7.9.x, Agile PLM BI Apps 3.0/3.2
  • Operating Systems: MS Windows 9x / NT 4.0/ 2000/2003/XP, UNIX, LINUX
  • Languages: C, PL/SQL
  • Database: Oracle 8, Oracle9i, Oracle 10g, Sybase,UDB

Professional experience

1

Confidential

The aim of this project is to create the OBIEE report, data warehouse and populate the data using OWB, from Network Backhaul system. Data was coming in the file from hadoop system then loaded in the data warehouse using owb and making report in OBIEE.

.

OBIEE, OWB and Data Warehouse Expert
  • Gathered the requirement, completed the proof of concept, Designed, Developed and Tested the data warehouse loading using OWB. Created slowly changing dimension and facts.
  • Created Physical Layer, Business Layer and Presentation Layer of OBIEE rpd
  • Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs
  • Created OWB mappings and workflows.
  • OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
  • High Level Design and Detail Design for Data Warehouse and OWB.
  • Used OWB Mappings and Transformations to load data into the data mart.
  • Created Called Stored Procedures and functions using OWB.
  • Created Workflows to Schedule and Trigger Mappings.
  • Used Upsert Strategy to update tables.
  • Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
  • Designed, Created and used multiple functionalities of OWB.
  • Used different transformations to develop Mappings such as Joiner, Aggregator, Router and Expression
  • Designed the data warehouse tables for large data with Partitioning
  • Upgraded OBIEE 10g to 11g

Windows XP, Linux server , Oracle 11g , OWB 11g, OBIEE 10.1.3.x, OBIEE 11g

2

Confidential OBIEE and Date Warehouse Project

The aim of this project is to design the OBIEE, data warehouse and populate the data using OWB, from Oracle ERP, Agile OLTP System and Data from file, and making report in OBIEE.

.

OBIEE/Siebel Analytics, OWB and Data Warehouse Expert
  • Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
  • Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs
  • Migrated the Tested Code from Dev to Test and Test to Production of Repository, Dashboard Reports and OWB mappings and workflows.
  • Designed the logical and physical data model for Forecast data, ERP Data in warehouse to store OLAP data.
  • OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
  • High Level Design and Detail Design for Data Warehouse and OWB.
  • Used OWB Mappings and Transformations to load data into the data mart.
  • Created Called Stored Procedures and functions using OWB.
  • Created Workflows to Schedule and Trigger Mappings.
  • Used Upsert Strategy to update tables.
  • Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
  • Designed, Created and used multiple functionalities of OWB.
  • Created Primary keys using Sequence Generator.
  • Used different transformations to develop Mappings such as Joiner, Aggregator, Router and Expression
  • Designed the data warehouse tables for large data with Partitioning
  • Windows XP, Linux server , Oracle 10g , OWB 10.x, OBIEE 10.1.3.x

3

Confidential Confidential OBIEE and Date Warehouse Project

The aim of this project is to design the OBIEE, data warehouse and populate the data using OWB, Informatica, ODI from Oracle ERP, Agile OLTP System and Data from file, and making report in OBIEE

.

  • OBIEE/Siebel Analytics, OWB/Informatica/ODI and Data Warehouse Expert
  • Architecture design/ Hardware recommendation of OBIEE environment/ ETL environment and database environment
  • Implemented Agile PLM BI Application 3.0
  • Upgraded Agile PLM BI Application from 3.0 to 3.2
  • Implemented BI Apps 7.9.5 for OOB for E Business Suite 11.5.10
  • Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
  • Created the OBIEE and OWB environment for Development, QA and Production environment.
  • Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs
  • Designed, Developed and Tested Data security and Dashboard security in OBIEE
  • Migrated the Tested Code from Dev to Test and Test to Production of Repository, Dashboard Reports and OWB mappings, Informatica/DAC mapping, ODI mapping and workflows.
  • Designed the logical and physical data model for Forecast data, ERP Data in warehouse to store OLAP data.
  • OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
  • High Level Design and Detail Design for Data Warehouse and OWB.
  • Used OWB Mappings and Transformations to load data into the data mart.
  • Created Called Stored Procedures and functions using OWB.
  • Created Workflows to Schedule and Trigger Mappings.
  • Used Upsert Strategy to update tables.
  • Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
  • Designed, Created and used multiple functionalities of OWB.
  • Created Primary keys using Sequence Generator.
  • Used different transformations to develop Mappings such as Joiner, Aggregator, Router and Expression
  • Windows XP, Windows2003 server , Oracle 10g , OWB 10.x, OBIEE 10.1.3.x, ODI 10g

4

Confidential Confidential OBIEE and Date Warehouse Project
  • The aim of this project is to design the OBIEE data warehouse and populate the data using OWB from JDE OLTP, Demantra System and Data from file, and making report in OBIEE
  • .
  • OBIEE/Siebel Analytics, OWB and Data Warehouse Architect
  • Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
  • Created the OBIEE and OWB environment for Development, QA and Production environment.
  • Designed, Created and Tested Report in the Dashboard and created the adhoc report according to the client needs
  • Designed, Developed and Tested Data security and Dashboard security in OBIEE
  • Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and OWB mappings and workflows.
  • Designed the logical and physical data model for JDE data, Demantra Data in warehouse to store OLAP data.
  • OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
  • High Level Design and Detail Design for Data Warehouse and OWB.
  • Used OWB Mappings and Transformations to load data into the data mart.
  • Created Called Stored Procedures and functions using OWB.
  • Created Workflows to Schedule and Trigger Mappings.
  • Used Upsert Strategy to update tables.
  • Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
  • Designed, Created and used multiple functionalities of OWB.
  • Created Primary keys using Sequence Generator.
  • Sourced Data from multiple databases files.
  • Used different transformations to develop Mappings such as Joiner, Aggregator, Router and Expression
  • Windows XP, Linux , Oracle 10g , OWB 10.x, OBIEE 10.1.3.x

5

Confidential Siebel Analytics and Date Warehouse Production Support
  • The aim of this project is to constantly support Siebel Analytics Application and regular enhancements as needed by end users.
  • Siebel Analytics, Informatica and Data Warehouse Expert
  • Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of Siebel Analytics
  • Created and Tested Report in the Dashboard.
  • Designed, Developed and Tested Data security and Dashboard security in Analytics
  • Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and Informatica mappings and workflow and DAC Entities.
  • Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
  • Analytics Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
  • High Level Design and Detail Design for Informatica.
  • Used Informatica Mappings and Transformations to load data into the data mart.
  • Created Called Stored Procedures and functions using Informatica.
  • Used Oracle Loader to Load Bulk Data.
  • Created Worklets Workflows to Schedule and Trigger Mappings.
  • Used Update Strategy to update tables.
  • Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
  • Designed, Created and used Mapplets for Repeated functionalities.
  • Created Primary keys using Sequence Generator.
  • Sourced Data from multiple databases files.
  • Used different transformations to develop Mappings such as Joiner, Aggregator, Router, Normalizer Expression
  • Windows 2000, Unix, Oracle, Informatica, Siebel Analytics

6

Confidential Siebel Analytics and Date Warehouse Upgrade
  • The aim of this project is to Upgrade Siebel Analytics Application from version 7.5.x to version 7.8.x. This upgrade includes the upgrade of Siebel Analytics Data Warehouse, Informatica and Siebel Analytics Application..
  • Siebel Analytics, Informatica and Data Warehouse Expert
  • Defined Upgrade steps and created Design Document for upgrade from version 7.5.x to 7.8.x
  • Un Installed all the software related to old version of Siebel Analytics
  • Installed latest version of Informatica, Siebel Analytics Web server, Siebel Analytical Server and DAC
  • Repository Upgrade, Database upgrade, Infomatica Repository Upgrade.
  • Repeated all above steps in QA and Production Environment.
  • Windows 2000, Unix, Oracle, Informatica, Siebel Analytics

Hire Now