Professional Summary

• Over 7 years of experience in OBIEE Oracle Business Intelligence Enterprise Edition , Oracle BI Applications with Oracle EBS as the Source.
• Sound Knowledge of Data warehouse concepts OBIA Customizations.
• Experience in working with DAC design and development including Customizing Execution Plan, Subject areas, Tables groups and Task definitions.
• Experience in leading and managing OBIEE projects.
• Experienced in Requirement Analysis, RPD Development, Report Design, Report Development and Testing using OBIEE 11g, Oracle BI Publisher tool.
• Strong Knowledge of Finance modules like GL, AP AR and also in Supply chain Modules like Purchasing, Sales and Order Management Developed and maintained data warehouse/BI solutions through the entire project life cycle Strong SQL skills ability to write and debug complex queries
• Have working knowledge on all the technology components of BIAPPS. Expertise in implementing Oracle BI Apps in all phases like customizing Out of the Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse ,OBIEE RPD development, OBIEE reports and Dashboards.
• Experienced in Oracle EBS R12 Supply Chain and Order Management, Financial Analytics Modules.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE 11g, Oracle BI Publisher, and Informatica Power Center. Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices. Maximum exposure to RPD Development, Report Development, Requirement Analysis, Installation and DWH designing. Capable to execute large OBIEE implementation Project with customization. Worked on upgrade process to convert OBIEE 10g reports to OBIEE 11g. Ability to organize/distribute team work and lead them in technical or Functional issues. Experience in configuring BI Publisher with Oracle Business Intelligence and developing reports.
• Experience in working on BI Publisher Data Model, Templates and Integrating BI Office Plugin Experience in OBIEE11g Security LDAP Security Implementation with Microsoft Active Directory and configuring the OBIEE Scheduler to deliver the emails.
• Worked on the Query Diagnostic logs and Cache Management techniques like Cache Purging and Cache Seeding.
• Migrating the RPD and Catalog across DEV, TEST and Production Environments.
• Experience in migrating Informatica mappings to DEV, TEST and PRODUCTION environment using KINTANA Tool Proficient at interviewing stakeholders and end users, and in translating users' statements of needed system behavior and functionality into Business and Technical Requirements. Education: Bachelor of Engineering Computer Science Technical Skills: OLAP Tools OBIEE 11g/OBIEE 10g Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager , Oracle BI Applications.
• ETL Tools Informatica Power Center 8.1.1/8.6, Designer Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations , Workflow Manager, Workflow Monitor, Repository Manager, DAC. Operating Systems MS DOS, Windows 95/98/2000/XP/Vista/7, 8, UNIX
• RDBMS Oracle 11g/10g/9i, MS SQL Server 2000/2005 Programming Query Languages C, SQL, PL/SQL, Java, XML, HTML Query Tools SQL Plus, SQL Developer, TOAD Data Modeling Star Schema Modeling, Snow Flake Schema Modeling, Fact and Dimension Tables and ER Studio

Work Summary

Confidential

Role: Lead OBIEE Developer

Role Responsibilities:

• Reports are developed for Business Development Officers, Financial Analysts and Sales Executives role.
• Involved in the Requirement Gathering and transforming it into the Technical specifications.
• Coordinating the team and reviewing their work Customized out of the Box Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administration tool.
• Customized the existing Business Layer as per the End User requirements to add more Dimensions in the OBIEE Administration Tool. Customized the Pre-Built mappings and also designed new mappings and Workflows in the ETL Front using the Informatica Power center.
• Experienced in scheduling the Informatica Mappings and monitoring Using DAC.
• Experienced in setting up a Multi-User Development Environment MUDE .
• Worked on creating and configuring BI Publisher reports. Worked on 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.
• Providing training to the New End Users/Business Users on the new logics included in the reports. Scheduling Reports using Agents to automate the report emailing. Team work for Successful release.

Environment: OBIEE11G/10G, BI Publisher 10.1.3.4,Toad, Windows XP, ORACLE EBS, Informatica 8.6, SQL Server 2005, Oracle 10g/11g, SQL

Confdiential

Role: Lead OBIEE Developer

Role Responsibilities:

• Reports are developed for Business Development Officers, Sales and Managers role. Implementing and installing OBIEE 11g in Dev, test and production environments.
• Customized out of the Box implementations in both Informatica and OBIEE 11g. 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. Implemented drill down and guided navigation to navigate to multiple sub requests based on the requirements. Designed the security model 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, Test and Production. Designed the login page by modifying the login page style sheet login.css according to the requirement. Implemented OBIEE Aggregate Tables to enhance performance. Involved in gathering business requirements from the business users. Effort Estimation for Report development Data Modeling for Fact and Dimension Data warehouse creation. Scheduling Reports using Agents automate 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,.

Confdiential

Role: OBIEE Developer

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 , 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 Region/ Period level in database and imported and configured it in Admin tool.
• Created Oracle BI Publisher reports for Central Bank Reporting like Balance Due, Outstanding Amount, Net Profit etc.,
• Experienced in creating Data Model from various data sources like Oracle Database and Hyperion Essbase. Created reports and Dashboard as per the business requirement. Implementation of Cache Management and Cache Monitoring Techniques.
• Implementation of OBIEE 11g Security using Microsoft Active Directory. Implementation and Customization of Analytical Reports Starting from requirement gathering to report and dashboard development with UAT. Effort Estimation for Report development, Data Modeling for Fact and Dimension Data warehouse creation. Data Analysis for Loan, Advances, RPD Creation, Report Development in OBIEE. Oracle BI configuration for Scheduling Reports using iBots. 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. 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.

Confdiential

Role: OBIEE Developer

Role Responsibilities:

• Starting from requirement gathering to required report development and dashboard development with UAT. Reports are based on requirement for analyzing Customer profitability, Revenue and Total Assets.
• Worked closely with client in understanding the Business requirements, data analysis and deliver the client expectations. 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 reports.

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

Confdiential

Role: OBIEE Developer

Roles Responsibilities:

• Responsible for developing OBIEE repository RPD from the scratch. Worked closely with ETL team to understand and implement primary key, foreign key and composition key relationship among physical facts and dimension tables
• Provided content filtering at BMM layer of RPD and used complex joins on logical data source LTS to join tables in BMM layer
• Created and Managed Multiple Logical Table sources.
• Developed security matrix for enterprise users based on their role and provided role based security using variables
• Developed different Dashboards/Reports with different view Calculation, Detailed, Pivot, Charts, Filters using the Presentation services.
• Automated cache purging process using Agents and configured cache management at various layer i.e. BI server, presentation server, browser etc Configured Event Polling for clearing the stale cache.
• Used job manager to manage and monitor Agents
• Analytics Repository using Siebel Analytics Administration Tool
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies
• Worked extensively on OBIEE Answers
• Responsible for developing different kinds of reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards
• Configured presentation layer used by different user groups and also established the various standard queries, in order to support the presentation layer
• Created Security settings in OBIEE analytics Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in OBIEE Answers
• Managed security privileges for each subject area and dashboards according to user requirements
• Worked on the Time Series Wizard and implemented time comparison measures
• Responsible for unit testing, integration testing of the reports generated using OBIEE analytics
• Involved in user trainings on the generated reports for this project

Environment: Oracle 9i, BIEE 10G, SQL Plus, PL/SQL, Windows 2000,PL/SQL Developer.

Confdiential

Role : Applications Developer

Roles Responsibilities:

• Working in accordance with the provided Functional Specification to develop certain functionality for Core Banks.
• Develop certain new Interface Screens for the same.
• Writing PLSQL Packages, modifying certain existing packages as per business requirement.
• Develop modify RPD and OBI EE reports as per business requirement.
• Prepared the design, development procedural specification documents.

Environment: OBIEE 10.1.3.2, Oracle 10G, BI Publisher, SQL Server, Windows NT.