SUMMARY

• Over 8 years of experience of design and development of Oracle Business Intelligence OBIEE and Oracle Data Integrator ODI .
• Strong understanding of the principles of Data warehousing, ELT, Fact Tables, Dimension Tables, Star and Snowflake schema modeling.
• Expertise in Implementing the Extraction, Loading and Transformation ELT of data using Oracle Data Integrator.
• Expertise in configuring the ODI Master and Work repositories, ODI models, and ODI Change Data Capture CDC mechanism.
• Expertise in Working with ODI Designer, Topology Manager, Operator, Security Manager.
• Experienced in defining and organizing the ODI project including interfaces, packages, procedures, variables, user defined-functions, and knowledge modules.
• Proficient with Business requirement for Oracle Data Integrator and mapped the architecture and used ODI for Reverse Engineering to retrieve metadata from data storage and load it to the repository.
• Experienced in configuring Knowledge Modules such as Reverse Knowledge Modules, Loading Knowledge Modules, Integration Knowledge Module and Check Knowledge Module when loading data.
• Strong technical knowledge of OBIEE Administration tool, Security, Answers and Dashboard development.
• Extensively worked with OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layers of the metadata repository.
• Experienced in configuring the Security Settings in OBIEE to set up Groups, Users, Access Privileges and Query Privileges.
• Extensively worked in configuring Analytics metadata objects and Web Catalog Objects, developed and Customized Dashboards / Reports with different Analytics Views as per the requirement.
• Got strong analytical problem solving skills using SQL.
• Implemented Multiuser Development Environment MUDE Using Oracle BI Administration Tool.
• Extensive experience in testing the Data Warehouse and Business Intelligence applications.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

TECHNICAL SKILLS:

PROJECT SUMMARY:

Confidential

OBIEE Developer/Admin

RESPONSIBILITIES:

• Worked with Business analyst, Management Professionals for gathering requirements and Business Analysis.
• Extensively worked on Physical, Business and Presentation Layer for developing repository.
• Used ODI for Reverse Engineering to retrieve metadata from data storage and load it to the repository
• Worked on Topology and defined Schemas and Data Servers in Physical and Logical Architecture.
• Implemented Constraints Keys, Reference Keys, Mandatory Columns, Conditions, Complex Reference to Attain Data Integrity.
• Implemented Slowly Changing Dimensions to keep track of changes on Specific Columns.
• Created and worked with different Packages, Procedures, Variables, Sequences and User Functions
• Loaded and configured various Knowledge Modules such as Loading, Integration, Check, Reverse Engineering, Journalizing, and Data Server
• Worked with different ODI Navigators such as Designer, Topology, Operator, and Security.
• Used Oracle Data Integrator security to secure any action performed by authenticated users against the design-time and run-time artifacts and components of Oracle Data Integrator.
• Designed and developed the Repository .rpd by importing the required Facts and Dimensions with integrity constraints into physical layer.
• Used Repository and Session variables to streamline administrative task.
• Built schema in Business model and mapping layer by using Complex Joins, created logical tables and columns, also created Hierarchy levels, level based measures for drill down capability, used Time series functions for calculating year ago and month ago assets.
• Involved in developing different Views on the dashboard and many Widgets.
• Extensively used guided navigation capability, drilldowns in reports and created dashboards.
• Designed different Error handling Method.
• Performed Integration Testing for various mappings. Tested the data and Data Integrity among various sources and targets.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.

ENVIRONMENT: OBIEE 10g, ODI 11g/10.1.3.x, Essbase 11g, Oracle 10g, SQL Loader, TOAD, UNIX.

Confidential

OBIEE Admin

RESPONSIBILITIES:

• Worked closely with the business and technical team to understand requirements for the development of the Project.
• Used ODI Topology manager module to manage the data information systems physical and logical architecture
• Used ODI Designer module to pull metadata of source and target information system tables into Models as datastore.
• Created interface between source and target technologies.
• Having the good knowledge on importing relevant knowledge modules.
• Have automated the process of purging the logs in the ODI Operator module.
• Created ODI Packages, Jobs of various complexities and automated process data flow
• Creating and maintaining the full lifecycle of ETL Interfaces/processes/ flows
• Configured Security manager for multiple users and assigned the required profile to those users.
• Designed and developed the OBIEE Repository .rpd by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Involved in developing different Views on the dashboard.
• Extensively used guided navigation capability, drilldowns in reports and created dashboards.
• Setup the visibility of dashboards to employees depending on their roles and responsibilities.
• Used Repository and Session variables for storing values.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Created logical column aggregations with complex calculations using the inbuilt functions and expressions.
• Maintained Security by assigning permissions to reports and dashboards based on users and groups.
• Slice and Dice data using filters and used pivot tables, charts and Narrative Views for better presentation.
• Experience in upgrade/migration process to 11g.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.

ENVIRONMENT: OBIEE 10.1.3.4, BI Publisher, Oracle 10g/11g, ODI 10.1.3.x, SQL, Toad.

Confidential

OBIEE Developer

RESPONSIBILITIES:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectations.
• Used OBIEE Administrator tool to develop and enhance Data model.
• Developed and customized OBIEE Repository rpd and involved in creation and modification of the Physical, Business, and Presentation Layer repository using OBIEE Administration Tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed and developed schemas using Fact, Dimensions, and tables like Logical, Physical, Alias, and Extension and made relationship between them by declaring Keys.
• Created Measures, Dimension Hierarchies, Aggregates, Variables, Time series Measures in rpd.
• Used Answers to create queries, format views, charts and added user permissions.
• Worked extensively with dashboard prompts to filter dashboards and populate variables.
• Used Security setting in OBIEE to set up authorization and authentication for users.
• Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.

ENVIRONMENT: OBIEE 10g, Oracle 10g, Unix Shell Scripting, MS Excel, Flat Files, SQL Server 2008/2005, PL/SQL, Windows.

Confidential

OBIEE Developer.

RESPONSIBILITIES:

• Worked extensively on Siebel Answers Dashboards Delivers.
• Created requests in Answers added filter prompts formatted views and charts.
• Created dashboard pages for dynamic drilldown guided navigation embedded contents images.
• Worked in Physical layer, Business layer, Presentation layers according to business Requirement.
• Created Authentication method to provide access to users
• Created column filter prompts column selector views pivot table views title views tabular views and static views in compound layout
• Created Dashboard prompts global filters and combined similar requests in Siebel Answers
• Designed pivot table reports setting aggregation rules sort orders and formulas
• Managed presentation catalog groups and users settings to web group folders
• Managed privileges and permissions to Answers Dashboards Subject Areas Catalog using Object level and Data level security.
• Modified Cascading style sheets and XML message files.
• Used Delivers to configure schedule and deliver personalized alerts to Interactive Dashboards using Scheduler iBots.
• Created Service Request reports based on call and email resolution
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.

ENVIRONMENT: Siebel Analytics 7.5, Informatica 6.5, SQL Server 2000, Linux.