Professional Summary

• Over 7 years of experience in OBIEE Oracle Business Intelligence Enterprise Edition ,Oracle BI Applications and Oracle Apps Oracle EBS 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, Oracle BI Apps, 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.
• 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 implementation Project with customization. Worked on upgrade process to convert OBIEE 10g reports to OBIEE 11g. Regular interaction with Oracle Supply Chain and Finance modules. 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 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. 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, Analysts and Sales Executives role. Sales Metrics, Analyze shipping scheduling, Improve transportation and inventory planning, Increase your transportation management efficiency, Track just-in-time delivery metrics and Model product demand. Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool. Modified the existing Business Layer to add more Dimensions in the OBIEE Administration Tool. Created Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group. Experience in setting up a Multi-User Development Environment MUDE . Worked on integrating and configuring BI Publisher with OBIEE. 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 Inventory and Order Management 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: OBIEE11G/10G, BI Publisher 10.1.3.4,Toad, Windows XP, ORACLE EBS, Informatica 8.6, SQL Server 2005, Oracle 10g/11g, SQL

Confidential

Role: Lead OBIEE Developer

Role Responsibilities:

• Reports are developed for Business Development Officers, Analysts and Managers role. 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 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 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. 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

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 Region/ 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 Central Bank. 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. 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. 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

Role Responsibilities:

• Starting from requirement gathering to required report development and dashboard development with UAT. Report are based on requirement for analyzing Customer profitability, Revenue and Total Assets.
• Effort Estimation for report development and ETL Mapping. 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 workflows.

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

Confidential

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 different functionalities of OBIEE such as Oracle Answers combined reports, action link, Navigation link etc Catalog, Dashboard, Agents
• 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
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor Agents
• Worked with the team and a DBA to communicate and negotiate data needs
• 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.

Confidential

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.