Professional Summary

• Over 8 years of experience in OBIEE Oracle Business Intelligence Enterprise Edition /Siebel Analytics and Oracle BI Applications implementations, Requirement Analysis, Report Design, Report Development and Testing using OBIEE, BI Publisher tool.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse ,OBIEE RPD development, OBIEE reports and Dashboards
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Informatica Power Center.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Experience in DWH Data Warehouse life cycle designing and development. I have worked for technology selection, Installation and Data Modelling using Erwin Tool.
• Oracle BI Discoverer report developer using Oracle BI Discoverer Administrator, Desktop and Discoverer Plus.
• Experienced extensively in PL/SQL and SQL for mission critical project with US Client.
• Maximum exposure to Report Development, Requirement Analysis, Installation, DWH designing.
• Capable to execute large OBIEE Siebel Analytics implementation Project with customization.
• Worked on upgrade process to convert OBIEE 10g reports to OBIEE 11g.
• Regular interaction with Oracle CRM and Finance modules.
• Ability to organize/distribute teamwork and lead them in technical or Functional issues.
• Experience in configuring BI Publisher with Oracle Business Intelligence and developing reports.
• Experience in developing OBIEE repository development, configuring metadata objects Subject Area, Table, and Column and web catalog objects Dashboards, Pages, Folders, Reports .
• Proficient at interviewing stakeholders and end users, and in translating users' statements of needed system behavior and functionality into Business and Technical Requirements.
• Experience in working with DAC design and development including Customizing Execution Plan, Subject areas, Tables groups and Task definitions.

Technical Skills:

Confidential

Role: Lead OBIEE Developer

Project Description: Confidential Asset management and Retail Line of Business. Referrals to Sale automated tracking and trend analysis with Asset Management and Retails resulting in increased cross-sell opportunities increased all business segment revenue growth through increased sales and assets under management.

Role Responsibilities:

• Worked on integrating and configuring BI Publisher with OBIEE.
• Experience in setting up a Multi-User Development Environment MUDE .
• Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Modified the existing Business Layer to add more Dimensions in the OBIEE Administration Tool.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Reports are being generated for Asset Management Group and Retail line of business
• Referrals, Pipeline, Opportunities, and Performance to plan.
• Reports are developed for Business Development Officers, Analysts and Managers role -
• Worked on the testing and validating the Repository.
• Created various analytic reports using Global and Local filters.
• Customized the login page and dashboards using style sheets and XML files effort estimation for Report development.
• Data Modeling for Fact and Dimension.
• Data warehouse creation Data Analysis for Deal Won/Lost and At Risk/Lost Business subject areas , RPD Creation , Report Development in OBIEE.
• Scheduling Reports using iBots to feed presentation server cache and automated report emailing.
• Provide Training to business user on using BI Answer for Analysis Reports.
• Team work for Successful release.

Environment: OBIEE 10G,OBIEE11G, BI Publisher 10.1.3.4,Toad, Windows XP, Siebel CRM, Informatica 9.5.1, Oracle 10g/11g, SQL, TOAD, Windows XP

Confidential

Role: Lead OBIEE Developer

Project Description: Confidential has multiple objectives designed to drive two specific outcomes.

Improve sales communication and coordination with C IB, resulting in increased cross-sell opportunities. Accelerate Institutional Investments' revenue growth through increased sales and assets under management.

Role Responsibilities:

• Reports are developed for Business Development Officers, Analysts and Managers role.
• Reports are being generated for Asset Management Group.
• Implementing and installing OBIEE 11g in dev, test and production environments.
• Upgrading the Oracle BI repository and catalog from OBIEE 10g to 11g.
• Created various session variables and initialization blocks based on the requirement
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Created Interactive Dashboards with different views like Table view, Pivot Table, Charts etc.
• Implemented drill down and guided navigation to navigate to multiple sub requests based on the requirements.
• Created Direct Database Requests using MDX queries.
• Designed the security model for the product and Implemented Object and data level security for different user groups. Managed security privileges for each subject area and dashboards according to user requirements.
• Migration of presentation catalog across different environments like Dev, QA and Production.
• Designed the login page by modifying the login page style sheet login.css according to the requirement.
• Implemented cube and OBIEE cache management to enhance performance.
• Implemented OBIEE security using external table authentication.
• Involved in gathering business requirements from the business users.
• Effort Estimation for Report development Data Modeling for Fact and Dimension Data warehouse creation.
• Data Analysis for Deal Won/Lost and At Risk/Lost Business subject areas RPD Creation Report Development in OBIEE.
• Scheduling Reports using iBots to feed presentation server cache and automated report emailing.
• Provide Training to business user on using BI Answer for Analysis Reports.
• Team work for Successful release.
• Conducted User training Programs to educate business users about the tool.

Environment: OBIEE 11.1.1.6.0/10.1.3.4, Oracle 11g/10g, SQL Developer, BI Publisher 10.1.3.4, Informatica 8.6.0, DAC Toad, Windows XP,.

Confidential

Role: OBIEE Developer

Project Description: Confidential need to automate their process of submitting data and performing validation using various criteria's. OBIEE reports are generated to validate the trends of data. Also for analysis purpose reconciliation reports are created in Regulatory Information System dashboard.

Role Responsibilities:

• Proposed estimation and Architecture.
• 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.
• Implementation and Customization Analytical Reports Starting from requirement gathering to required report development and dashboard development with UAT. Reports are based on current and prior month counts for data submission. These reports are being generated for Regulatory Information Group.
• Effort Estimation for Report development, Data Modeling for Fact and Dimension Data warehouse creation.
• Data Analysis for home equity submission ,RPD Creation ,Report Development in OBIEE.
• Oracle BI configuration for Scheduling Reports using iBots.
• 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 System Security.
• Implementation and Customization Analytical Reports Starting from requirement gathering to required report development and dashboard development with UAT. Reports are based on current and prior month counts for data submission. These reports are being generated for Regulatory Information Group.
• Effort Estimation for Report development Data Modeling for Fact and Dimension ,Data warehouse creation.
• Data Analysis for home equity submission , RPD Creation , Report Development in OBIEE.
• Oracle BI configuration for Scheduling Reports using iBots.
• Provide Training to business user on using BI Answer for Analysis Reports.

Environment: OBIEE 11.1.1.6.0/10.1.3.4, Oracle 11g/10g, BI Publisher 10.1.3.4,Toad DAC , Web Logic Server 10.3.3, Informatics Power center 8.6.1,SQL Developer, Windows XP, Linux.

Confidential

Role: OBIEE Developer

Project Description: Confidential the customization component, interface requirements, Data migration from existing Oracle EBS applications. Proposed Hardware Sizing and Architecture System Security Implementation and Customization Analytical Reports.

Role Responsibilities:

• Starting from requirement gathering to required report development and dashboard development with UAT. Report are based on commission requirement for analyzing companies performance based on actual and target activities.
• Effort Estimation for Report development and ETL Mapping.
• 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 permission
• 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.
• Data Modeling for Fact and Dimension , Data warehouse creation Report Development.
• Oracle BI configuration for Scheduling workflows.

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

Confidential

Role: OBIEE Developer

Project Description Confidential Produce a decision support system in replacement of the existing system which provides technical and financial information to assist the Commission to discharge its duties and functions effectively. MERC can monitor on the utilities by generating reports on monthly, six monthly or yearly bases. They can modify the reports based on their requirement or able to create the new report. On other side utility will send the reports regularly to MERC.

Role Responsibilities:

• Understanding the Functionality of existing process.
• Worked as an Application Designer for Mapping Designing RPD and ETL development.
• Documented Application Design Mapping ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions Metadata and Dashboards/Reports using OBIEE platform.
• Developed the OBIEE Metadata repository .rpd model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions time series functions, Presentation layer with catalogs folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC, Pharma Analytics for creating Auto Execution and Scheduling Tasks.
• Involved in developing Informatica Mappings Mapplets during enhancements.
• Creating reports using BI Publisher and Discoverer Creating screens to open reports from the system.
• Reports output testing for performance and consistency.
• Database related activity like creating users, creating tables, functions, procedures and other database objects.
• Security Implementation for Newly Introduced Fact.
• Dashboard and Report Development, Data Modeling for Fact and Dimension.

Environment: Oracle 9i, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL Loader, SQL Plus, PL/SQL, Windows 2000, UNIX Sun Solaris , TOAD, PL/SQL Developer.

Confidential

Role: OBIEE Developer

Project Description: This system provide platform for improving lab processes throughput and reducing cycle time, It enable GIA to expand its Global presence by allowing it to handle multiple locations. Provide insight into lab processes from a managerial perspective, and please GIA's customers by giving them flexibility to view and control their items with various standard reports.

• Responsibility: Requirement analysis, implementation and Internal Testing.
• Implementation of reports pertaining to Management, Quality
• Assurance, Compliance and Grading Reports Module of the project.
• Database management activities and worked mainly for performance
• Tuning of SQL queries.

Environment: Oracle BI Publisher 10.1.3.2.0,Oracle Database 10g,SQL, PL/SQL

Confidential

Role: Application Developer

Project Description: The system executes each of the charge requests from direct billing processes, that contains security and contingency self-management mechanisms, an alert system that informs incidences to stakeholders, and which allows the execution of manual processes in case of contingencies.

Role Responsibilities:

• Supports wide range of reporting and file handling functionality for different stakeholders.
• Tasks: Coordination for understanding requirements.
• Preparation of the User Requirements Document.
• Reports Development, Internal Testing.
• Worked in the requirement analysis, design, development modules and testing phase of projects

Environment: BI Publisher, SQL, PL/SQL, Java