Professional Summary

• 9 Years of experience in IT with full life cycle implementation of Oracle Business Intelligence Product suites OBIEE and Oracle Business Intelligence Applications OBIA
• Involved in all the phases of gathering requirement, Proof of concept, gap analysis, design, development and implementation of software applications
• Extensive expertise in providing end-to-end business intelligence solution by configuring metadata building analytics metadata repository, star schemas, snow flake schemas, dimensional modeling design, building business models, generatingreports, and creating interactive BIdashboards
• Extensive experience in building and customization of interactive dashboards with drill down capabilities using global local filters, contextual navigation, guided analytics, Business Rules with User Identity roles, profiles personalization and creating and scheduling I-Bots
• Experience in upgradation from OBIEE 10g to 11g migrating RPD, Catalogs and applying patches
• Proficient in development and production support and OBIEE application design, build, test, experience, including requirements gathering, ownership of metadata and dashboards and reports
• Extensive experience in migration of OBIEE Presentation Services objects using OBIEE Catalog Manager and repository files between different environments
• Experience in development of BI Publisher Reports using various templates using BI Publisher Desktop Tool
• Experience in performance tuning, security, cache management, aggregation and usage tracking
• Experience of working in MUDE, resolve conflicts and maintain consistency
• Exposure to OBIEE Administration activities as OBIEE Installation, LDAP Configuration, Map Viewer Configuration, Essbase Connectivity and Cluster Configuration
• Experience in development of mappings using InformaticaMapping Designer using various transformations like Expression, Router, Lookup, SQ, Update Strategy,etc.
• Experience in development of sessions and workflows and using Informatica Workflow Manger
• Experience on execution, monitoring and troubleshooting of the ETL executions using Informatica Workflow Monitor
• Experience in migration of informatica repository using Informatica admin console and also individual folders, mappings, sessions, workflows using Informatica Repository Manager
• Experience on development, configuration and scheduling of tasks and execution plans using DAC
• Expertise in debugging, optimizing the performance tuning of Oracle BIEE 10g/ 11g Repository Dashboards / Reports by implementing Aggregate tables, Fragmentation of data sources, Indexes and Cache management.
• Experience in performing end to end testing including Data Validation, Unit Testing and UAT
• Implemented a PoC on GoldenGate for data replication for ODS
• Proven experience and ability to adapt quickly and work in teams, a can-do ability to take charge when necessary and drive the work to completion
• Excellent interpersonal skills, outstanding problem solving and decision making skills

Technical Skills

Reporting Tools : OBIEE 10G/11G, OBIA 7.9.6.3, BI Publisher, BI Publisher Desktop

RDBMS : Oracle 8i/9i/10g/11g, MS SQL server, MS Access

ETL Tools : Informatica 9.0.1,7.x, Oracle Data Integrator ODI ,GoldenGate

Operating Systems : Unix,Windows Server 2003 Enterprise Edition

Scheduling Tools : DAC, Cron Jobs

Applications : MS Office Suites Excel, Word, PowerPoint, Access

Querying : T-SQL,PL/SQL

Database Clients : TOAD, SQL Developer

Professional Experience

Confidential

Role: OBIEE Developer

Environment: OBIEE 11.1.1.6.x

Responsibilities:

• Working closely with financial analysts to understand the report details to the end user community
• Requirement gathering and perform gap analysis and build the solution
• Customized and developed the OBI repository
• Implemented changes to the Star Schemas and in all the 3 layers of the RPD Physical, Business Model and Mapping Layer and Presentation Layer
• Involved in the design activities for providing reporting solution
• Created the sample BIP reports for the end user look and feel experience
• Development of the reports using BI Publisher for LCR module
• Created custom reports to produce pixel perfect reports using BI Publisher desktop to generate RTF templates for generating BIP reports.
• Analysis and implementation of the reporting requirements of the LCR project
• Functional Analysis of the data to be shown on the LCR reports
• Implemented R D on the reports User Interface requirements
• Implemented complex sql queries to implement the BI Publisher reporting requirements

Confidential

Role: OBIEE Developer

Environment: OBIEE 11.1.1.5.4, 11.1.1.7

Responsibilities:

• Conducted design sessions with data owners toward capturing business requirement for an analytics environment.
• Working closely with end user community to enhance and improve the user experience architecture look and feel
• Requirement gathering from the client and perform gap analysis and build the solution
• Proposed the enhancements required and effort estimates on the reporting requirements
• Proposed the required changes that are required in the data ware house for generating the required reports
• Customized and developed the OBI dashboards and reports
• Implemented changes to the Star Schemas and in all the 3 layers of the RPD Physical, Business Model and Mapping Layer and Presentation Layer
• Created and modified hierarchies in the Business Model and Mapping Layer
• Involved in the design activities and created the design specifications documents.
• Provided the knowledge transition to the project support team.
• Developed the reports using BI Publisher for the accounts reconciliation management ARM for GE Finance.
• Developed OBIEE reports for risk mitigation for GE Capital.
• Fixed performance issues for improving report performance.

Confidential

Role: OBIADeveloper OBIEE Administrator

Environment: OBIA 7.9.6.x, OBIEE11.1.1.6.4, OBIEE 11.1.1.6.2, 11.1.1.5

Responsibilities:

• Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Created complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Implemented Human Resources HR Analytics and Financial Analytics.
• Designed and implemented custom business intelligence solutions Dashboards/Reports and dashboard prompts using the BI Applications Analytics platform.
• Configured global filters, dashboards and page prompts in OBI Web.
• Modified presentation layer filters and attributes to match user requirements.
• Used the Security settings in Oracle BI Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimension hierarchies to achieve the drill down functionality.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Managed security privileges for each subject area and dashboards.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and to configure, monitor and schedule ETL routines.
• Used Informatica for data extraction, mapping and conversion using Informatica Power Center.
• Extensively worked in fine-tuning of Informatica mappings.
• Created mappings using different Transformations like Source Qualifier, Filter, Router, Aggregator, Lookup, Expression, Sequence Generator and Update Strategy to store the data in target table.
• Created sessions, tasks and workflows etc. in Workflow Manager.
• Worked with the Testing team to resolve, fixing and testing problems found during the systems integration test, UAT phases.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performed installation and configuration of 11.1.1.5, Informatica 8.6.1 and DAC 10.1.3.4.1.
• Responsible for Query Tuning to enhance the performance of reports and Dashboards.
• Managed upgrade and maintained the environments with latest patches
• Integration of OBIEE with EBS Source Systems

Confidential

Role: OBIA Developer OBIEE Administrator

Environment: OBIA 7.9.6.x Procurement and Spend Analytics, OBIEE 11.1.1.6.x, OBIEE 11.1.1.5.4

Responsibilities:

• Worked in analysis of reporting requirements and coming up the custom data model and creation of custom repository for meeting the reporting requirements.
• Worked on the Configuration files for configuring the modules and prepared the Data Lineage for HR Projects and Supply Chain Management Analytics for meeting the requirements.
• Customized the data model and development and enhancement of ETL and DAC objects.
• Involved in DAC configuration for HR, Procurement and Spend, Supply Chain module.
• Report Customizations in OBIA application and creating Data Validation test cases from Source to target.
• Involved in migration of code objects ETL, DAC, RPD and Catalog form development to the higher environments.
• Performed the Admin related Activities like Configuring and Installing OBIA Out of Box Applications and OBIEE 11g and Applying OBI 11g interim and bundle patches, and refreshing the servers, shutting and starting up the servers
• 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.

• Managed upgrade and maintained the environments with latest patches
• Trouble shooting the issues related to repository models and report development.

Confidential

Role: OBIEE Developer, Oracle Data Integrator ODI

Environment: OBIEE 11.1.1.3, OBIEE 10g

Responsibilities:

• Conducted design sessions with data owners toward capturing business requirement for an analytics environment
• Working closely with end user community to enhance and improve the user experience architecture look and feel
• Proposed and Configured a new Security model in order to maintain data-level security for the users
• Proposed the enhancements required on the reporting requirements
• Proposed the required changes that are required in the EDW data model for generating the required reports
• Involved in the DB design and required changes
• Developed the BI dashboards and reports
• Configured the security settings for the dashboards as well as data security
• Involved in the design activities and created the design specifications documents
• Documented test cases to test the reporting requirements functionality and carried out thorough testing
• Deploy the code to the OBIEE Production environments
• Upgraded the environment from OBIEE 10g to OBIEE 11g
• Installed and configured Oracle Data Integrator ODI and developed Knowledge Modules
• Installed and configured Oracle GoldenGate for data replication from the MSS to MSS-R. Configured GoldenGate processes such as Manager, Extract, Replicat, Collector, etc.

Confidential

Environment: Informatica 7.x

Responsibilities:

• Analysis of the Source data for the required reports
• Proposed the required changes that are required in the EDW data model given by the client
• Involved in the design activities and created the design specifications and the corresponding documents
• Involved in the DB design and implementation of the Staging Area
• Developed and tested the Informatica Workflows to load the EDW
• Executed, monitored and troubleshoot the ETL for the full and the Incremental
• Co - ordinate with the admin teams to deploy to the production environments and also executing the ETLs in the production

Confidential

Role: BO Data Services Developer

Environment: Business Objects Data Services

Responsibilities:

• Analysis of the Source data
• Customized the out-of-box Rapid Marts given by the SAP
• Involved in the design activities and documented the required changes for the mappings
• Involved in the DB design and implementation of the Staging Area
• Developed and validated the loads of the EDW
• Executed, monitored and troubleshoot the ETL for the History and the Incremental loads to test the customized rapid marts

Confidential

Role: OBIEE Analyst

Environment: OBIEE 10.1.3.4.1

Responsibilities:

• Analysis the required metrics and their functional usage
• Proposed and formulated the metrics as per the requirement
• Involved in the design activities and created the design specifications and documents
• Analyzed the functionality of the application from all the aspects of the data flows from different sources into the data warehouse
• Proposed the data model and provided inputs to the data model in order to generate the reports and the dashboards