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, generating reports, 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 up gradation 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
• Involved in various full cycle implementations of Oracle Applications R11i.
• 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
• Applying Patches one-off, CPU's and PSU's.
• Management of Database Creation and Maintenance of Table-Spaces, Data-files, Undo's, Redo Log-file, Temps, Archive Log-files and Backend objects .
• Monitoring the Storage Usage and Disk I/O by managing Table-Spaces, Data-files and OS File Systems using OEM.
• Database refreshes using Export-Import and Data-pump.
• Populating data from flat files to the database objects using SQL Loader.
• Oracle network Administration by Configuring tnsnames.ora, listener.ora.
• Providing various reports to management using oracle utilities like AWR, Explain Plan's and SQL trace.
• Database user creation and granting the necessary roles and permissions
• 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

TechnicalSkills

• Operating Systems : Unix,Windows Server 2003 Enterprise Edition
• ETL Tools : Informatica 9.0.1,7.x, Oracle Data Integrator ODI ,GoldenGate
• RDBMS : Oracle 8i/9i/10g/11g, MS SQL server, MS Access
• Reporting Tools : OBIEE 10G/11G, OBIA 7.9.6.3, BI Publisher, BI Publisher Desktop Tableau.
• 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.5.4, 11.1.1.7

Responsibilities:

• Involved with FINANCE Team and users to gather requirements
• Actively Interacted with project managers team members to discuss timely deliverables, project status documented technical specifications from functional specifications in reporting point of view
• Based on user requirements, identified various fit-gaps on existing Oracle analytics warehouse and developed solutions to meet Amazon's requirements and loaded the user required data into the OBAW
• Involved in developing Project Plan for the future SCOPE of the Financial Analytics project which includes developing learning management and recruitment subject areas from flat files provided by third party vendors using Universal adapters
• Involved with Project managers and users to gather KPI's from warehouse for Financial reporting
• Administrated BI Environment by debugging identified issues and delivered solutions
• Identified Financial Analytics facts, dimensions star schema models of workforce profile subject area
• Created Materialized Views to look up Organization Hierarchy Descriptions for OOTB Hierarchy tables
• Customized OBIEE repository by adding custom columns and tables using BI administration tool for Service Analytics tables like W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, W OPTY D tables in Service Analytics Oracle CRM .
• Involved in customizing Account Receivables, ACCOUNTS Payables and Oracle GL Subject Areas and corresponding dashboards. The tables like W AP BALANCE F, W AR BALACE F, W GL ACCOUNT D were customized as per user requirements.
• Identified bugs and UPDATED OBIEE Infrastructure with oracle provided UPDATES and patches
• Involved with DBA's to tune the DB by setting DB Parameters and tuning BI generated SQL queries
• Created custom Indexes on OOTB Tables to improve dashboard Report performance
• Used catalog manager to migrate custom dashboards, requests, filter and prompts to ProdFixed performance issues for improving report performance
• Involved in various full cycle implementations of Oracle Applications R11i.

Confidential

Role: OBIA Developer 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.
• Worked in OBIEE Answers to build reports for current vs. forecast comparison based on Essbase/Planning data and developed dashboards for upper management.
• 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 and maintained the environments with latest patches
• Integration of OBIEE with EBS Source Systems
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories
• Responsible for managing the PROCESS for code migration to different instances.
• Writing the Queries in EBS for developing the Report in OBIEE.

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 Procurement and Spend and Supply Chain modules
• Customized the data model and development and enhancement of ETL and DAC objects.
• Involved in DAC configuration for Procurement and Spend and Supply Chain modules
• Involved in customizing Informatica pre-built objects for Procurement and Spend and Supply Chain modules
• 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 Configured and Installing OBIA Out of Box Applications and OBIEE 11g and Applying OBI 11g applying interim and bundle patches, and refreshing the servers, services ,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 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
• Installed and configured Oracle Data Integrator ODI and developed Knowledge Modules
• Installed and configured Oracle Golden Gate for data replication from the MSS to MSS-R. Configured GoldenGate processes such as Manager, Extract, Replicat, Collector, etc.

Confidential

Role: Informatica Developer

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: OBIEE Developer

Environment: OBIEE 11g, Oracle 11g and Windows NT.

Responsibilities:

• Creating users and groups and assigning permissions based on responsibilities/roles.
• Reconfigured the OBIEE server metadata .rpd using the Admin tool to develop a reporting environment according to requirements.
• Giving security permission / privileges to the user.
• Running reports in OBIEE presentation services.
• Customized Answers, Filters,BI Publisher Reports and Dashboards using OBIEE presentation services.
• Creating and managing Web Groups and Reports Security using OBIEE Web Administration.
• Monitoring jobs Using Tidal scheduler Tool.
• Service ticket resolution of analytic s incidents raised by end users routed through L2 Support
• Analysis and fix for any bugs identified during analysis of service tickets
• Development of critical change requests to facilitate smooth maintenance release
• Interation with Onsite team to clarify certain key technical aspects related to the functionality desired.
• Proposing best possible solution to the business teams for all change requests .
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures.
• Developed many Reports using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Trained the Business Users/Power Users to use the new functionality in Analytics and also led them to best practices in managing and sharing reports.
• Fixed all Defects opened by users after the Production Release quickly and deployed the changes back into production.
• Creating New physical, logical and presentation tables.
• Enabling security for the new logical tables and other existing tables in the new subject area.
• Propose and execute different methods to achieve more productivity.

Confidential

Role: OBIEE Developer

Environment: OBIEE 11g, Oracle 11g and Windows NT.

Responsibilities:

• Creating users and groups and assigning permissions based on responsibilities/roles.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Design various reports i.e. Drill down, pivot, Breakdown reports, Narrative and Nested reports in answers and configured intelligent Dashboards for different groups of users to view across regions customer demography with the facility to drilldown and charts.
• Reconfigured the OBIEE server metadata .rpd using the Admin tool to develop a reporting environment according to requirements.
• Imported DAC repository from existing production and configuring it for Incremental and Full Loads.
• Giving security permission / privileges to the user.
• Running reports in OBIEE presentation services.
• Customized Answers, Filters, Reports and Dashboards using OBIEE presentation services.
• Creating and managing Web Groups and Reports Security using OBIEE Web Administration.

Confidential

Role: OBIEE developer

Environment: OBIEE 10.1.3.3.2, Oracle 9i, Windows NT.

Responsibilities:

• Extensively worked on Dashboards Layout.
• Responsible for evaluating the existing reporting environment and help define future BI Strategy direction.
• Created various types of reports using Siebel Answers
• Created various reports in deferent views like Pivot views, Charts view Graphical charts, pie charts Gauges and compound layout and table views.
• Developed Dashboards and Answers by using Prompts and Filters.
• Configuring the repository modeled physical, business and the presentation layer.
• Build Repository of all the 3 layers Physical Layer connecting Data sources import schema business Model data mapping create Logical tables data source mapping Presentation layer level create presentation catalogs , create presentation folders tested.
• Involved in creating Dimensions and Fact tables.
• Responsible for preparation of Test plans and the development of Test scripts as per the requirement from client.