Summary

• Around 9 years of professional IT experience which includes maintaining OLAP/OLTP applications by using OBIEE , Informatica , Siebel and Actuate
• 5 years of experience in OBIEE 11.1.1.7/10.1.3.4,OBIA which includes building and creating repository RPD , creating and managing the Oracle Intelligence Dashboards, Answers and creating Delivers and iBots
• Experience in Development of Siebel Analytics/OBIEE Repository Administration, and creating, modifying Intelligence Dashboards for integrated Siebel Analytics applications, using Siebel Answers
• Developing Dimensional hierarchies, Expression builder, Time series wizard, Calculation wizard.
• RPD Development physical, Business Mapping Modelling, presentation Layers by using OBIEE 11.1.1.1.7/ 10.1.3.4.
• Involved in Repository Configuration, Troubleshooting, Defect Fixing by using HP QC
• Extensive experience in application , Functionality , integration and Business End to End testing
• Trained the user groups in HP QC
• Updated and closed the tickets in HPQC.
• Created the test cases based on the requirements
• Worked with the users to set up the Siebel remote application in their system.
• Involved Siebel DB initialization.
• Involved in customization of Screens, views,applets, BC and BO in Siebel.
• Experience in migrating metadata and web catalogue between different environments like DEV, BRK STG and PRD
• Expert knowledge on peoplesoft applications
• Experience in implementing Out of the Box OBIEE OBIA and RPD and Dashboard customizations
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE 11.1.1.7
• Expertise in Cache management, performance tuning at report level
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters for Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Experience with RPD development, configured metadata objects subject area, Alias table and column and web catalog objects Dashboards, Pages, Folders, Reports
• Experience in providing end to end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports/dashboards
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Interacted with team to understand the Data warehouse requirements.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Experience in Siebel eBusiness Application configuration by using Siebel Tools.
• Expert knowledge in developing reports for Siebel Applications by using the Actuate Tool.
• Experience with preparing the High level and Low Level Design Documents.
• Experience in communicating with the User's directly.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies

Technical Skills Summary:

Operating System : Windows 2000/NT/xp/7

Oracle Application: OBIEE 11g/10.1.3.4, Dash Boards, Answers, iBots, BI publisher, Siebel 7x/8x, Actuate 7/8

ETL Tool: Informatica 8/9.1

RDBMS: Oracle 11g, 10g, 9i, Toad.

Professional Experience

Confidential

• Requirements gathering and understanding, preparing the design documents.
• Preparing the functional, Technical and Test cases document preparation.
• Provided the support for the users at the time of UAT.
• Interacting with the Business Owners to understand the requirements
• Creating the Data Model for RPD development.
• Created the measures based on the requirements.
• Created the Dashboard Prompts.
• Communicating with Administration team to merge the RPD and catalogs in Dev ,STG and PROD environments.
• Involved in preparing implementation plan.
• Handling the Remedy ticket creation Toyota process to move objects to Production Environment,
• Creation of physical, BMM and presentation layers.
• Creating the Reports, Filters, Graphs, Tables , presentation variables, Dashboards at answers level.
• Expert in creation of Subject areas and Developing the Reports
• Implementation of criteria filters to narrow-down the result set from the analytics requests
• Preparing the Testcases
• Creation of Agents iBots
• Identifying the User Groups and assigning the LDAP Group as part of Security.
• Involved Code Reviews
• Interacting with Administration team to deploy the STG and PRD environments

Environment: OBIEE 11.1.1.7, Maximo 5.2, Maximo 7.5 , Windows 7.

Confidential

Technical Leader

• Interacted with the business for requirement gathering reports and dashboards and to define the Functional design Documents.
• Communicating offshore team to provide clarifications for issue resolution
• Involving in Functional and Technical design Document preparation.
• Accepting,assigning,and closing the tickets for support task.
• Updating the status reports.
• Involved in Effort estimation for objects.
• Running and monitoring the DAC jobs on daily and weekly basis.
• Involved RPD , Reports and Dashboard creations
• Involved in maintaining the object status tracker
• Involved MOM preparation.
• Scheduling the meeting with the offshore team to know the status and issues.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Interacted with users to resolve issues and requirement clarifications.
• Helping and guiding the team to resolve issues

Environment: OBIEE 10.1.3.4,Siebel, DAC and Informatica.HP QC

Confidential

Sr.OBIEE Developer Team Lead

Responsibilities

• Interacted with the business for requirement gathering reports and dashboards and to define the Functional design Documents for 10.1.3.4
• Involved Onsite and offshore activities.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository RPD file and modeled data in physical and BMM layer using physical and complex joins.
• .Extensively worked with Business and Functional owners to get the requirements clarifications.
• Effectively handled the team lead activities like Code Review approvals, maintaining the object tracker, conducting the team meetings to get the object status.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Extensively involved in review of the Design documents with the peers at different levels
• Involved in resolving the UI layer formatting issues at OBIEE Answers level
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Expertise in Creation of Subject areas and Developing Reports by using OBIEE 11.1.1.6
• Implemented event polling cache refresh strategy to cache reports and improve performance of long running reports.
• Responsible for the administration and migration of user reports or repositories between various environments
• Customized the out of box rpd to meet the functionality of business procedure.
• Extensively worked with Administration team to resolve the issues happened while migration to different environments DEV,BRK,STG and PROD
• Involved in root cause analysis and troubleshooting the ETL mappings which were resulting several data issues
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Involved in unit testing the reports.
• Extensively worked on the defect fixing, Technical document changes and migration process.
• Updating the status sheets on regular basis to know the status of the objects.
• Involved in MOM preparation
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: OBIA 7.9.6.2, OBIEE 10.1.3.4 , Oracle 10g, Win XP, Windows 7, Informatica 9.1, DAC10.1.3.4.1, Siebel 8.x

Confidential

OBIEE Developer

Responsibilities:

• Create/Modify Metadata repository suiting to company's data requirements by using OBIEE tool.
• Involved in Business Analytical activities like Migration, Testing, User Training and Production Support
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Managed security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts.
• Analyzed and recommended enhancement to metadata reporting in all three layers Physical Business and Presentation .
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the Server processing overhead.
• Defined session variables for users to enhance data level security.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured I-Bots to deliver analytics content-based alerts as per user requirements.

Environment: OBIEE 10.1.3.4, Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0,DataWarehouse Administration Console 10.1.3.4.1. , Siebel 8.0.

Confidential

OBIEE Developer

Responsibilities:

• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping
• Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, Sql server. Siebel 8.0,HP QC

Confidential

OBIEE Developer

Responsibilities:

• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins..
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, Sql server.Siebel 8.x, HPQC

Confidential

Responsibilities

• Understanding the user requirement and developing the technical documentation.
• Involved in customization of joins/links/BC/views/applets..etc
• Involved in fixing the defects and updated the defects by using the HP QC
• Creating the reports in Actuate eReporting Professionals 7 based on the user requirements like simple reports, parameterized reports and master detail reports
• Generating Actuate library .rol from Siebel tools.
• Configuration of Application for report specific changes.
• Creation of joins
• BC and Applet Creation for parameterized reports
• Design and Develop New Reports
• Execute and test the converted report.
• Uploading the ROX files to Server by using Actuate Management console
• Involved in Unit Testing and debugging the Bugs
• Export and import the .SIF files

Confidential

Actuate Reports Developer

• Understanding the user requirement and developing the technical documentation.
• Creating the reports in Actuate eReporting Professionals 7 based on the user requirements like parameterized reports, master detail reports and graphical reports etc
• Generating Actuate library .rol from Siebel tools.
• Configuration of Application for report specific changes.
• Design and Develop New Reports
• Execute and test the converted report.
• Customizing the reports as per functional requirement in Actuate e. Report Designer Professional
• Execute and test the report in multiple languages.
• Involved in developing the Critical Actuate Reports using data sorter .
• Uploading the ROX files to Server by using Actuate Management console
• Involved in Extensive Configuration and customization of creating applets, views, Business components
• Export and import the .SIF files
• Involved in Unit Testing and debugging the Bugs.

Confidential

Actuate Reports Developer

Responsibilities:

• Creating the reports in Actuate reporting Professionals 7 based on the user requirements like simple reports, parameterized reports and master detail reports
• Generating Actuate library .rol from Siebel tools.
• Configuration of Application for report specific changes.
• Creation of joins
• BC and Applet Creation for parameterized reports
• Design and Develop New Reports
• Execute and test the converted report.
• Uploading the ROX files to Server by using Actuate Management console
• Involved in Unit Testing and debugging the Bugs.
• Export and import the .SIF files.