Summary

• Around 8 years of experience in implementing Business Intelligence and Data Warehousing solutions for various clients across different business units.
• Expertise in developing Oracle BI and Siebel Analytics Repository consisting of three layers Physical Layer, Business Model Presentation Layer .
• Good Understanding of Data warehousing Concepts like Star schemas and Snowflake Schemas.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance.
• Extensively worked on OBIEE Administration Tool, Answers, Dashboards, Job Manager, Catalog Manager.
• Expertise in converting and using Oracle's Out of the Box rpd's Supply Chain Analytics, Procurement and Spend Analytics according to business requirements.
• Expertise in installing, configuring and administering different versions of OBIEE 11g, 10g and Web Logic Server 10.3.3.
• Strong Experience in Physical and Logical Data Modeling.
• Expert in setting up and managing security Data Level Security, Object Level Security in OBIEE 11g, 10g.
• Experience in setting up Multi User Development MUD environment
• Excellent knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Expert in supporting the implementation and maintenance of reports and dashboards using Oracle Business Intelligence Enterprise Edition OBIEE , Hyperion Essbase.
• Excellent problem solving and inter-personal skills with strong technical background.
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure.

Technical Skills:

Professional Expereince:

Confidential

Sr. OBIEE Developer

Responsibilities:

• Gathered the requirements from the business users and IT team for report and RPD design from an OLTP Transactional system and Data Warehouse. Projects worked on Noetix EAM ITS, Spend Analytics, Incremental
• Involved in gathering requirements from the business users understanding the conversion data from Pinnacle to Noetix Oracle EAM.
• Worked with the business analyst to understand the source tables that are required for designing the RPD Reports.
• Implemented Oracle SQL Views against the source tables to maintain the star schema in the RPD.
• Designed the Physical, BMM Presentation Layer of RPD as per the requirement.
• Designed dimensional hierarchies, materialized views and aggregate tables to support the reporting system.
• Developed reports, dashboards, standard filters and prompts.
• Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View.
• Created initialization blocks in RPD to populate the session variables for the Data Level Security applied security on the required tables.
• Implemented data and object level security based on the business requirements through External table.
• Authentication Authorization has been implemented in RPD Weblogic using the Oracle Responsibilities.
• Created Application Roles assigned users to these roles by defining policies.
• Extensively used OBIEE MUD to check out check in projects.
• Migrated the RPD Catalog from DEV to QA UAT.
• Worked extensively in configuring scheduling Agents on timely fashion to the business to meet the requirements.
• Involved in Performance Tuning of reports by identifying the indexes required on the source tables and also from the data available in the Cache.
• Trained users in understanding the new features of OBIEE11g.

Environment: Oracle 11.1.1.7, Oracle 11g,Informatica 9.1.5, SQL Developer, Windows XP, LINUX

Confidential

Sr. OBIEE Developer

Responsibilities:

• Gathered and analysed reporting requirements for the Long Rang Forecast OBIEE Project.
• Performed detailed source system analysis and documented observations in Technical Design Document and conducted review sessions on the same with Solution Specialist, Functional Analyst, and Project Manager.
• Integrated OBIEE 10g/11g with Hyperion Essbase 11.1.2.1.
• Independently designed and developed subject areas in the RPD.
• Created reports with different views Compound, Chart, Table, Pivot
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot.
• Created and customized various Reports and Dashboards for various user groups
• Created the Logical calculation in Business model layer based on requirement and created sub folder in presentation layer.
• Created Time Series measures Year Ago, Month Ago, Year-to-date measures using Ago and To Date Time series functions.
• Mapped sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates .
• Followed best practices while design and development of OBIEE repository/Reports.
• Created all the users and groups in the Web Logic Administration console, assigned all the users to the required groups.
• Upgrade the from OBIEE 10.1.3.4.1 rpd and webcatalog to OBIEE 11.1.1.7.0.
• Solve the RPD and web catalog Issue after upgrading to OBIEE 11.1.1.7.0.

Environment: OBIEE 11.1.1.7.0,OBIEE 11.1.1.6.X, OBIEE 10.1.3.4.1, Web Logic Server 10.3.3, SQL Developer, Oracle 11g, Hyperion Essbase 11.1.2.1, Windows 7,Solaris box, Excel Smart view.

Confidential

OBIEE Developer

Responsibilities:

• Worked closely with Business Users in understanding the Analytics requirements and to identify and refine business requirements and translate Design Specifications in to Technical Design Document.
• Created/Modified Metadata repository .rpd , Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Configured facts, dimensions and Hierarchies And do the following calculation in Logical layer
• Developed Time Series Objects using Ago and To Date functions for time series comparisons
• Created aggregate tables for Fact at Brand/Plan-to Party/ Period level in database and imported and configured it in Admin tool.
• Created reports and Dashboard as per the business requirement.
• Installed OBIEE 11g in Dev Functional Test Box
• 10g Rpd Web-Catalog has been upgraded to 11g.
• Modified all the OBIEE Security that has been completely changed from the previous
• Versions 10g to the newer version of 11g.
• According to the new security setup - Refreshed all the GUI's Global Unique Identifiers of the users to login to the OBIEE 11G Analytics.
• Created all the users and groups in the Web Logic Administration console, assigned all the users to the required groups.
• Created Application Roles and policies in the Fusion Middleware Enterprise Manager and added the users.
• Performed Unit testing and System Integration Testing to Validate the Report

Environment: OBIEE 11.1.1.5.0, OBIEE 10.1.3.4.1, Web Logic Server 10.3.3, Informatics Power center 8.6.1 , Oracle 11g, Teradata,SQL Developer, Windows XP, Linux.

Confidential

OBIEE Developer

Responsibilities:

• Understanding the Client requirements.
• Created metadata repository .rpd as per business requirements at three layers in Oracle BI Administration Tool
• Designing the Technical Design documents by understanding the Functional Design documents
• Interacted with business Management representatives for gathering the Metadata/ Dashboards requirements and to define business and functional specifications.
• Worked with Business Analyst to make sense of business performance by adding context to real-time business measure.
• Designed Oracle BIEE Repository at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer as per the Universes in Business Objects and followed best practices.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Provided guidance and support to end users during the implementation and in production.
• Extensively worked on Answers, Created Reports using different Analytics, Materialized Views Pivot Table, Chart, Column Selector and Table .

Environment: OBIEE 10.1.3.4.1, Informatica 8.6.1,Oracle 11g, SQL Developer, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository .rpd .
• Worked with business analyst and users Financial Advisors to gather analytics requirements and created the business model using star schemas.
• Worked with System Engineering team to design Facts, Dimensions and Hierarchies of the business model.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Modified presentation layer dimensions and attributes to match user requirements.
• Creating global filters, complex queries, prompts, reports charts, tables, graphs in Answers.
• Configured repository and session variables to get dynamic reports and dashboards.

Environment: OBIEE 10.1.3.4.1, Informatica 8.6.1, Oracle 10g, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Conducted meetings with business representatives for gathering the business requirements.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a model plan to implement the analytical repository from an Oracle Business Intelligence perspective.
• Designed and developed Analytics Metadata Repository .rpd using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies , Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Implemented comprehensive security functionality by creating users web groups, setting up LDAP ADSI authentication and associating catalog objects and Web modules with the created users and groups.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.

Environment: OBIEE 10.1.3.3.1, Informatica Power Center 8.1, Oracle 10g, Windows XP.