Experience Summary

• Overall 8 years of IT experience in OBIEE 11g/10g, OBI/XML Publisher 11.1.x, Siebel Analytics 7.8.4, Informatica 9.x/8.x/7.x, PL/SQL, SQL, Oracle 11g/10g/9i.
• 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 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.
• 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.
• Exposure to OBIA Financial Analytics and PeopleSoft HR Analytics .
• Experienced in working with transformations like Source Qualifier, Expression, Aggregator, Filter, Sorter, Update Strategy, Lookup, Joiner and Sequence Joiner.
• Scheduled and Monitored ETL mapping using Data warehouse Administrator Console DAC .
• Strong experience in Oracle database and fluent in SQL, PL/SQL Store Procedures and Functions
• Excellent Communication and Documentation skills, ability to learn and adopt new ideas and technologies, Self-motivated and result-oriented.

Technical Skills:

Professional Experience:

OBIEE Developer

Confidential

Responsibilities:

• Understand the existing OBIEE system architecture. Worked with client developing best practices for team.
• Worked on the tickets assigned and interacted with the end user to get the issue resolved.
• Developed different dimensional level Analysis, Filters and Prompts using Oracle Business Intelligence Answers.
• Created Time Series Measures, Hierarchies, Level Based Measures, Session and Repository Variables, Initialization Blocks.
• Created Agents to alert the business users.
• Implemented object level security for different web groups based on responsibilities.
• Handled migrations from Development to Test till Production.
• Involved in Active Directory integration with OBIEE for authentication.
• Involved in Performance tuning of the dashboards using cache management.

Environment: OBIEE 10.1.3.4.2, SQL Server, Windows

OBIEE Consultant

Confidential

Responsibilities:

• Actively involved with business team to understand user requirements.
• Modified the existing subject areas and created new subject areas as per the user requirements.
• Worked extensively on OBI Analytics to create attractive Analysis and Interactive Dashboards using different views like Chart, Pivot Table, View Selector, Column Selector, Text, Ticker, etc as per the detailed design requirements. Also used Dashboard components like Dashboard Prompts, Action links.
• Used several Action links to navigate through different reports.
• Created additional measures, Level based measures using expression builder and calculation wizard.
• Involved in migrating the Reports and Dashboards from the Development environment to the Production environment.
• Created Repository variables, Presentation variables and Initialization blocks.
• Create several users/ groups with different permission and privileges. Also applied row level/ object level security.
• Developed test cases according to testing documents to ensure that user is able to see the correct results on the Analysis and Dashboards. Also involved in Performance Testing and Data Testing.
• Involved in Performance tuning of the dashboards using cache management.

Environment: OBIEE 11.1.1.7, BI Publisher 11.1.1.7, Oracle 11g, SQL Developer, Hyperion

OBIEE Developer

Confidential

Responsibilities:

• Participated in the workshops and gathered requirements.
• Involved in communicating with client to understand/clarify requirements and suggest enhancements.
• Identified the different Facts and Dimensions and designed the Star schema for fact dimensional tables from the current OLTP and created alias for the dimensional tables when necessary.
• Involved in creating the Data model as per the user requirement.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle Business Intelligence Administration Tool.
• Created Session and Repository Variables, Initialization blocks.
• Developed customized and attractive Analysis/ Dashboards/ Reports with different Analytics Views Pivot Table, Chart, Tabular, 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.
• Created the BI Publisher reports based on RTF templates.
• Involved in integrating OBIEE with the transactional system using GoURL and Web Services.
• Created the Detail Design Document for the reports.

Environment: OBIEE 11.1.1.7, BI Publisher 11.1.1.7, Oracle 11g, SQL Developer, PL/SQL

OBIEE Developer/ Admin

Confidential

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Successfully upgraded RPD, Analysis, Reports, Dashboards and Presentation Catalog from OBIEE 10g to 11g using UA. Resolved all the issues to carry out the upgrade process successfully.
• Set up a Multi-User Development Environment MUDE for the convenience of the company's on-shore and off-shore teams.
• 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.
• 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 11.1.1.6, BI Publisher 11.1.1.6, Informatica 9.0, Oracle 11g, SQL Developer

BI Reports/ Dashboard Designer

Confidential

Responsibilities:

• Actively involved with business team to gather user requirements.
• Developed OBIEE Repository .rpd file by importing metadata from heterogeneous sources like flat files.
• Developed attractive Analysis/ Reports / Dashboards with different views Pivot Table, Chart, and Column Selector with global and local Filters using Oracle BI Presentation Services.
• Created Repository Documentation creation utility and Deployment Guide while migrating code from development phase to test phase and production phase using Catalog Manager.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Configured Action links and Alerts to notify the users depending on business requirements.
• Configured report schedulers and agents effectively to generate and deliver reports based on criteria. The reports were delivered to the concerned department as an email alert.
• Created KPIs and Scorecards with the vision, mission, objectives, and perspectives.
• Involved in performance tuning of the dashboards using cache management.
• Suggested the use of Materialized views to improve the performance of dashboard prompts.
• Involved in Quality Control and review of all the reports/dashboards during production release.
• Extensively used Informatica PowerCenter tools like Designer, Repository Manager, Workflow Manager and Workflow Monitor to create mappings/mapplets and various tasks.
• Used Informatica workflows and UNIX scripts to control and automate various complex loads.
• Used data modeling concepts in developing star schema, facts and dimensions using ERWIN.
• Created test conditions for test scripts, tested reports and dashboards, tested answers configuration, tested ETL processes or data conversions using relational databases/SQL.

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

BI Consultant

Confidential

Responsibilities:

• Was responsible to understand business requirements for Analysis, Design and Development.
• Meeting clients face to face and on site to ascertain requirements.
• Identified Facts and Dimensions with levels hierarchy .
• 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.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Extensively used OBIEE Delivers and iBots to deliver reports 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.
• Developed detailed test plans, implemented all related test cases and created a detailed documentation of the above test process.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages.
• Wrote PL/SQL stored procedures, Functions and triggers to implement business requirements.
• Creation of database table, integrity constraints, views, indexes using Oracle.
• Troubleshooted fixed and implemented bug fixes and enhancements within tight deadlines.
• Producing and updating relevant document.

Environment:OBIEE 10.1.3.4, InformaticaPowerCenter 8.1, Oracle 9i, SQL Developer, SQL Loader, Windows XP