PROFESSIONAL SUMMARY:

• Over 8+years of experience in Information Technology industry in which over 7 years of experience as OBIEE Consultant.
• Involved in creation of Repository and Generation of Business Reports and Dashboard using OBIEE.
• Creating a new Presentation catalogue, modifying presentation layer objects, rename tables, reorder tables and organizing presentation layer.
• Add users to the new group and apply the data level and object level security at repository level as well as presentation services.
• Configured Repository variables to generate dynamic reports.
• Experience in creating Repository variables and session variables.
• Implemented prompts to provide x filter condition to end users.
• Create the reports like Table, Chart, Pivot, column selector and Narrative views and publish them in dash board using answers.
• Worked on delivers, iBots, alerts and BI Publisher reports.
• Good Knowledge on OLTP, OLAP, Dimension Models like Star schema & snowflake schema, Galaxy schema, OBIEE Architecture and Data ware housing concepts.
• Technical experience in dealing with Business Intelligence applications using BI tools like informatica and OBIEE (Seibel Analytics).
• Experience on OBIEE Admin related tasks like Installation, configuration and Migration
• Experience in unit testing and validating the repository
• Experience in Migration from 10g to 11g.
• Having good exposure in Oracle9i/10g/11g
• Having good working knowledge on OBIEE 11g
• Experience in Performance Tuning Analytics Dashboards / Reports and Data Warehouse database.
• Having good Knowledge on BIApps Financial Analytics & Procurement & Spend Analytics.
• Having extensive working knowledge on oracle ApplicationsR2 (App,AR).
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, DML, DDL etc.).
• Having Good Knowledge in Creating transformations (Expression, Aggregator, Lookup, Router, Rank, Update Strategy, and Filter) and developing Mappings using Informatica.
• Knowledge in designingBusiness Objects universes, complex BO reports bothfull client andWeb Intelligence Reports, Web Intelligence and Crystal Reports to develop and publish thin client reports.
• Extensively Knowledge onBusiness Objects Architecture & Administration.CreatedUsers and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMCon Daily, Monthly, Weekly basis.

TECHNICAL SKILLS:

OLAP Tools: Oracle Business Intelligence Enterprise Edition 10.3.4.1. Oracle Business Intelligence Enterprise Edition 11.1.1.5, Oracle BI Apps

ETL Tool: INFORMATICA 8.1.1, SSIS.

Languages: SQL/PL SQL

Data Base: Oracle 9i/10g/11g, SQL Server

Operating Systems: Windows XP, 2000 Professional, Linux, UNIX

Office Tools: Ms - Word, Ms-Power Point, Ms-Excel

ERPs: Siebel CRM, Oracle APPS (AP, AR, GL& PO)

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

OBIEE-Consultant

Responsibilities:

• Involved in requirements gathering (Reports/Dashboards/Delivers), analysis, design, used various data sources, development and implementation of the project.
• Experience in developingPhysical Layer, Business Model & Mapping and Presentation Layerusing Oracle BI Administration Tool (RPD).
• Importing physical tables and columns in to physical layer and establishing relationship between them.
• Customized the logical table source in the business model and mapping layer based on the business requirement.
• Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting
• DesignedSchema/Diagramsusing Fact, Dimensions, Physical, Alias and Logical tables.
• Created Drill down Hierarchies and implemented Business Logics forFacts.
• Implemented Aggregate tables for better performance.
• Utilized various building blocks likecalculation measures,time series measures,initialization blocks, session and repository variables, fact tables, dimension tables, dimensionhierarchies using RPD Admin tool.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation layer considering errors, warnings and best practices.
• Developed report with filters, presentation variables, prompts, column selector, view selector, charts, narrative, gauge views, pivot table and other views.
• Adding new additional data fields in existing reports and publishing reports in dashboards.
• Analysed reporting requirements for dashboard reports and adhoc reports.
• Developed Reports, Dashboards with different Analytics Views (Drill-Down / Dynamic Pivot Table Chart, View Selector).Reduced the number of reports using Column Selectors and View Selectors.
• Unit testing the reports and testing navigation links in reports.
• Coordinating with admin team regarding production deployments.
• Created and distributing ibots to subscribed users.
• Involved in implementing OBIEE upgrade from 10g to (11g RPD& Catalog) and customizations in 11g.

Environment: OBIEE 10.1.3.4.1/ OBIEE 11.1.1.5(Repository RPD 11.1.1.5), Oracle 10g/11g, Windows Server 2007, PL/SQL Developer, EXCEL, TOAD.

Confidential. Durham, NC

OBIEE-Consultant

Responsibilities:

• Involved in requirements gathering (Reports/Dashboards/Delivers), analysis, design, used various data sources, development and implementation of the project.
• Has design logical data model based on the source system tables.
• Worked on Dimensional Hierarchies (Drill down& Drill up), Level Based & Share Measures and Time series functions based on Business Requirements.
• Configured Physical & BMM layer-import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns.
• Worked on Repository Variables and Session Variables.
• Implemented Security by creating users, roles, groups, data level security, object level security.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Implemented Aggregate tables for better performance.
• Created Alias Tables and Opaque views for easy reporting and better performance.
• Enhance performance by managing Cache management in OBIEE.
• Worked on Answers, Dashboards, Delivers and BI Publisher.
• Developed report with filters, presentation variables, prompts, column selector, view selector, charts, narrative, gauge views, pivot table and other views.
• Created Dashboards prompts, pages, links, images, embedded content, text folders and guided navigation links.
• Created pivot tables in many dashboards for providing the ability to rotate rows, columns, and section headings to obtain different perspective of the same data.
• Has integrated different reports in to dashboards and has set access permissions accordingly based on user needs.
• Has configured the job manager for working with OBI Delivers, created iBots and scheduled them to display alerts as well as to send the reports to the inbox of users.
• Created different reports like Standard, Dynamic and Ad-hoc reports
• Perform unit testing and validating the repository.

Environment: OBIEE 10.1.3.4.1/ OBIEE 11.1.1.5(RPD), Oracle 11g, BI Publisher, Windows XP, TOAD, Oracle ApplicationR2.

Confidential, Dallas, TX, USA

OBIEE-Consultant

Responsibilities:

• Understanding the requirements of the client, business scenario(s) and the application and prepare the design documents.
• Designing the logics to be implemented at the RPD level.
• Using OBIEE Administration tool to develop and enhance Meta data to build Business Model and established relationships.
• Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Extensively used variables (repository and presentation) in the process of making the reports
• Implementation data and Object level security.
• Generated OBIEE reports using OBIEE answers, dashboards, filters and Prompts.
• Created guided navigation links to help files within the dashboards to help the end users.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Configure the Scheduler to deliver the reports to the Business using Ibots.
• Creating the Dashboard and Page level prompts.
• Displayed BI Publisher reports in BI Answers.
• Enhanced existing Business Models & created customized Dashboards.
• Fine-tuned the long running reports by re-organizing the data, re-building of indexes
• Build Informatica SDE mapping using JDE Enterprise One as a source and build SIL mappings to load data from staging table to target table.

Environment: OBIEE 10.1.3.4, Oracle 10g, Windows 2003, Informatica Power Centre 8.6.0, SQL Query Analyser, BI publisher, TOAD.

Confidential

OBIEE-Consultant

Responsibilities:

• Extensively used OBIEE Administration tool for customizing and modifying physical, Business and Presentation layer of the repository.
• Understanding the Business requirements, involved in Designing and Configuration of OBIEE Repository as per Business Needs.
• Performed repository Testing and validation before exposing business model in presentation layer.
• Customized the logical table source in the business model and mapping layer based on the business requirement.
• Created Alias and configured repository with logical dimensional modelling using star schema.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation layer considering errors, warnings and best practices.
• Created dimensional hierarchy in used shared child level when creating the sub level hierarchies.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Extensively worked on OBIEE Answers create reports as per client requirements.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards.
• Design and present the various scenarios for implementing organization and position based data security in OBIEE.
• Implemented LDAP and Security.
• Designed and developed Fronted dashboards and reports by incorporating complex business rules.
• Involved in development, documentation, testing phases of the project.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Implemented Prompts to provide dynamic filter condition to end users.
• Unit Testing of Analytics reports, along with data validations using queries for the correctness of data.

Environment: OBIEE 10g, Oracle 9i, SQL Query Analyser, Windows 2003