EXPERIENCE SUMMARY:

• Proficiency in OBIEE 10.1.x/OBIEE 11.1.x which includes Oracle BI Server, Oracle BI Dashboards, Oracle BI Analytics, Oracle BI Delivers, Catalog Manager, Oracle BI Publisher.
• Experience with OBIEE Installation and configuring components (BI Analytics, BI Publisher).
• Involved in SDLC phases like Requirement gathering, Designing, Development and Testing.
• Excellent skills in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository (RPD) using Oracle BI Administration Tool.
• Expertise in business model development with Dimensions, Skipped and Ragged-level Hierarchies, Measures, Aggregation Rules, Time Series.
• Experienced in implementing Row Level Security and Object level security in OBIEE.
• Extensive experience in setup and working in a Multi-user Development environment (MUDE).
• Good knowledge on Data Warehousing concepts like Star Schema, Snowflake Schema.
• Experienced in Code Migration from development stage to testing stage and production stage.
• Experience in creating out of the box, attractive, user specific and customized OBI Answers, Reports, and Interactive Dashboards using different views available.
• Experienced in configuring iBots/Agents using OBIEE Delivers to deliver Analytics and weekly/daily reports.
• Experienced in testing OBIEE Answers, Dashboards, Reports, KPIs and Scorecards.
• Strong experience in Oracle database and fluent in SQL, PL/SQL (Store Procedures and Functions).
• Good knowledge on Data Warehousing concepts like Star Schema, Snowflake Schema.
• Excellent Communication and Documentation skills, ability to learn and adopt new ideas and technologies, Self-motivated and result-oriented.

TECHNICAL SKILLS:

Reporting Tools : OBIEE 11g/10g (Administration Tool, Catalog Manager, Answers,

Dashboards), XML/OBI Publisher 11.1.x/10.x

ETL Tools : Data warehouse Administration Console (DAC), Informatica Power Center 9.x,

8.1x.7.x(Designer, Manager, Workflow Manager/ Monitor)

Database System : Oracle 11g/10g

Tools : MS office, SQL developer, TOAD

Operating Systems : MS Windows 7/Vista/XP/2000/98/95, Unix/Linux ( Shell Scripts).

Languages : C, .NET, SQL

Web Technologies : HTML, HTML 5, XML, CSS, Java Script

PROFESSIONAL EXPERIENCE:

OBIEE Developer/ Admin

Confidential

Boston, MA

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in communicating with client to understand/clarify requirements and suggest enhancements.
• Designed Star schema for fact & dimensional tables from the current OLTP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle Business Intelligence Administration Tool.
• Specified dimensional hierarchy, aggregate levels for the dimensions.
• Set up a Multi-User Development Environment (MUDE) for the convenience of the company’s on-shore and off-shore teams.
• Developed different dimensional level Analysis, Filters and Prompts using Oracle Business Intelligence Answers.
• Designed and configured Intelligent Dashboards in Analytics using KPIs and Scorecards for different groups of users which include business users from various parts of the world.
• Developed customized and attractive Analysis/ Dashboards/ Reports with different Analytics Views (Pivot Table, Chart, Tabular, Ticker, Column Selector and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Created Time Series Measures, Hierarchies, Level Based Measures, Session and Repository Variables, Initialization Blocks.
• Created Agents to alert the business users.
• Use Upgrade Assistant to upgrade metadata and schemas from 10g (RPD, Web Catalog, BI Publisher Repository, and BI Publisher Schema).
• Manually migrated the Custom Style/ Skin/ XML Messages/ Java scripts. Did the changes to instanceconfig.xml, NQSConfig.INI
• Implemented object level security for different web groups based on responsibilities.
• Improved the performance of the Reports by moving huge calculations to the Database and by using the Aggregate tables and Cache management.
• Installed and configured Informatica PowerCenter 9.0 to be used as ETL engine to load data into the Data Warehouse.
• Checked data consistency using SQL and PL/SQL queries in SQL Developer.

Environment: OBIEE 10g/11g, Informatica 9.0, Oracle 11g, SQL Developer, PL/SQL

OBIEE Developer

Confidential
Chennai, India

Responsibilities:

• Involved in Analysis, Study and Design of the Application.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository at 3 layers i.e., Physical Layer, Business Model / data mapping (created Logical tables & data source mapping) and Presentation Layer level (created presentation catalogs), created presentation folders, tested and validated the model.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Extensively used repository variables, session variables and presentation variables.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many OBI Answers using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Extensively used OBIEE Delivers and iBots to deliver reports (layout templates in RTF) to mobile users.
• Used Filters and provided customized prompts appropriately to avoid excessive data showing up in BI answers.
• Developed many complex Informatica mappings and reusable mapplets to build key interfaces using transformations and reusable transformation units ( Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduled them to run at specified time with required frequency.
• Used Workflow Monitor to monitor the performance of the Jobs.
• Explore prebuilt ETL metadata, including Informatica workflows and mappings, and DAC metadata.
• Use the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics Warehouse.
• Loaded consolidated data using SQL *Loader in parallel and direct mode.
• Developed detailed test plans, implemented all related test cases and created a detailed documentation of the above test process.

Environment: OBIEE 10.1.3.4, Informatica PowerCenter 8.1, DAC, Oracle 9i, SQL Developer, SQL*Loader, Windows XP

OBIEE Developer

Confidential
Chennai, India

Responsibilities:

• Actively involved with business team to gather user requirements.
• Installed and configured OBIEE Admin tool and web components including Intelligence Dashboards, answers, and requests.
• Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Involved in performance tuning of the dashboards using cache management.
• Tested and validated the unit test cases
• Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
• Worked on creation of repository variables and session variables.
• Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
• Designed and developed interactive navigational drill down reports in OBIEE Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
• Using the Presentation Variable in prompts Report filters.

Environment: OBIEE 11.1.1.3, OBI Publisher 11.1.1.3, Informatica 8.5, Oracle 10g, TOAD, SQL, PL/SQL, Unix.