PROFESSIONAL SUMMARY:

• Having around 9 years of experience in requirements gathering, application development, testing with a comprehensive background in Oracle Business Intelligence Enterprise Edition (OBIEE), OBIA, BI Publisher, ETL and ELT Tools like Informatica, ODI and scheduling tool like DAC
• Having international client facing experience covering clientele from across the globe like USA, Sweden, UAE, UK, and the MEA Region
• Working knowledge on the Essbase integration with Obiee Repository.
• Implementation experience on Obiee integration with Smart view.
• Administration and implementation of Oracle Business Intelligence Applications with different EBS modules and custom applications as source on Financial, SCM of Oracle BI Applications for the Development and Enhancement of Out of the Box (OOTB) Dimensions and Facts
• Expertise on OBIA installation, configuration and good understanding of OBIA Architecture and Development Process.
• End - to-end implementation of Oracle BI Application ( 11.1.1.7.1 ) for Oracle Financials, Procurement & Spend, Supply Chain & Order management and Price Analytics
• Experience in OBIEE upgrade from OBIEE 11g ( 11.1.1.7.1 ) to OBIEE 12c ( 12.2.1.1.0 )
• Expertise in OBIEE 12c advanced features including Visual Analyzer, Heat Matrix Graphs, Data Mashups, Predictive Analytics, Mobile Application Designer
• Experience building OBIEE 12c Baseline Validation Tool for automating regression testing
• Good Understanding and Implementation experience of Oracle Business Intelligence Applications (OBIA) components like DAC, Informatica and pre built Data model.
• Experienced in configuring and integrating maps in several OBIEE Reports & Dashboards using the map viewer
• Expertise in developing OBIEE report with different views (table, pivot, graph and trellis)
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Mapping and Modeling Layer & Presentation Layer)
• Expertise in creating iBots/Agents in Delivers to send alerts to the recipients on occurrence of a business event or at the time specified
• Expertise in Business Model development with Connection Pools, Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Cache Management
• Experience in Full Systems Development Life-Cycle (SDLC) Implementation of Various Oracle BI Projects
• Good experience on OBIEE security and migration across environments
• Practical understanding of the concepts like Star and Snowflake Schema modeling, fact and dimension tables modeling of data
• Ability to translate functional specifications into detailed technical design specification
• Experience in DAC (Design, Setup, Execute, Other Setup and Configuration Utilities)
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE and OBIA
• Hand on experience on the BICS (Business intelligence Cloud System)
• Good communication, presentation and problem-solving skills

TECHNICAL SKILLS:

Reporting Tool: OBIEE11.1.1.9.x, OBIEE11.1.1.7.x, OBIEE11.1.1.6.x, OBIEE 12c 12.2.1.1.0 , OBIEE10g, OBIA 7.9.6.x, OBIA 11g, BI Publisher 10/11, and BICS

ETL Tool: Informatica 9.0.1, DAC 10.1.3.4.1 , ODI 11g

DBMS: Oracle 10g/11g/12c

Operating System: Windows, UNIX

Languages: SQL, PL-SQL, JavaScript

Others: Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, CT

Solution Environment: OBIEE 12c, Siebel CRM

Tools: OBIEE 12c, Oracle DB.

Responsibilities:

• Upgrade OBIEE 11g BI stack to OBIEE 12c platform.
• Experience developing and configuring Calls Offered and Calls Answered reports, dashboards in OBIEE 12C
• Experience building visualizations for call center dashboard reports like Call Volume and Transfer statistics through Visual Analyzer, create Heat matrix graphs & Data Mashups.
• Experience building use cases in predictive analytics, configuring mobile application designer and scorecards.
• Experience leveraging OBIEE 12c Baseline Validation Tool for automated regression testing of call center dashboards.

Confidential, CT

Solution Environment: OBIEE 11g, Siebel CRM

Tools: OBIEE, Informatica, SQL Developer

Responsibilities:

• Developed multiple call center dashboard reports encompassing Call Volume and Transfer Statistics, Calls by Caller Type, Outbound Callbacks, Call Activity Detailed Reports, Weekly Call Center Status, Daily Call Center Status, Agent by Skillset Performance
• Developed multiple reports with charting and interactive drill down capabilities including Daily/Weekly Call breakdown with average speed of answer, Phone Application count by weekday, Phone Application duration by weekday, Calls Offered and Calls Answered by Call Count, Calls Offered and answered by Call Time, Weekly Call Summary, Fallout calls by hour
• Designed conditional formatting for patterns of interest.
• Developed OBIEE Agents for delivering reports by email.
• Customization of Knowledge management analytics.
• Involved in Bug fixing in 3 environments prior to deployment in Production

Confidential

Solution Environment: OBIA 11g, EBS R12

Tools: OBIEE, ODI, SQL Developer

Responsibilities:

• Actively involved in Installation and configuration of OBIEE, ODI 11.1.7.0 with BI Application 11.1.1.7.0
• Involved in requirement gathering, Fit-Gap Analysis, creation of Module design document to track functional and technical requirement
• Configure & Customize Out-of-box prebuilt OBIA RPD, web-Catalog, ODI master and work repository for BI Application 11.1.1.7.1
• Configure Source files, lookup files for Oracle Financials, Procurement & Spend, Supply Chain & Order management and Price Analytics in BIACM and FSCM
• Perform functional configuration, Manage data load parameters, reporting parameters, export setup data, Manage Load plan through Configuration manager, functional setup manager and ODI Console
• Monitoring, executing and debugging ETL load on Development through Configuration manager and ODI Console, BIACM, FSCM
• Developing custom data model for Customer Transaction, Category Management, Sales Support and Pricing subject area in OBIA RPD and Web-catalog
• Setting up & testing performance parameter in BI Application environment to address performance issue on DEV, TEST and PROD

Confidential

Solution Environment: OBIEE 11g, Window, Essbase

Tools: OBIEE, ODI, SQL Developer

Responsibilities:

• Interacting with client and understanding the specific requirement provided by client and planning accordingly
• Preparation of Estimations for the new requirements
• Experienced in Customized OBIEE Admin Tool to develop the three layers in the Repository
• Creating new Logical tables and Logical columns in the Business Layer and calculation measures using logical columns based on the User Requirements and Enhancements
• Creating and making changes in Intelligent Dashboards for different groups of users to view across Regions, Product Demography with the facility to drill-downs and charts
• Making changes and Enhancements made by the clients on Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic), Pivot Table, Chart, Column Selector, Tabular, Trellis charts) using BI Analytics Web
• Deploying the changes to different Environments DEV to TEST and TEST to PROD
• Testing the reports and dashboards after successful migration
• Integrating Apex Application with OBIEE
• Development of APEX UI Screens/pages and developed Oracle APEX Application for supporting the OBIEE Security
• Utilized PL/SQL, JavaScript and HTML/CSS to provide customized solutions to meet business needs
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders
• Developed the custom reports/dashboards for Sales Analytics
• Creating Hierarchies, Levels, and implementing Business Logic by creating level based measures
• Worked extensively on Oracle Answers to create the reports
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns
• Preparing Technical documentation
• Unit testing for the developed RPD and Dashboards and test overall System functionality
• Preparing Test cases to report the Bugs reported by Clients
• Created Proactive Agents (iBots) and configured Interactive dashboards

Confidential, Denver, CO

Solution Environment: OBIA, PSFT

Tools: OBIA 7.9.6.x, OBIEE11g, Informatica 9.0.1, Oracle 11i, Windows XP.

Responsibilities:

• Used the BI Administration tool to develop and enhance Meta-data and Repository (.rpd) configuration
• Designed and Developed the Custom Dashboards and BI reports for the AP and AR Bucket Range Customizations
• Involved in the Design and development of BOBJ Reports
• Developed the Business Model (Metadata) using OBIEE 11.1.1.7.0 Admin Tool (RPD) for the AP and AR Bucket Range Customizations
• Responsible for designing and creating Logical Columns, Metric Definitions for the newly requested Bucket ranges
• Involved in creation of Dimensional Hierarchies for providing drill-downs and for creating Level Based Measures
• Creating new Logical tables and Logical columns in the Business Layer and calculation measures using logical columns
• Involve in the migration of OBIEE components to other environment
• Assigning roles and responsibilities as per the security matrix
• Involved in the creating iBots for caching seeding
• Applying patches for any Bug fix or upgrade
• Resolving issues related to data, report mismatch and monitoring DAC load for regular daily and weekly loads
• Applying different Performance tuning parameters to improve the performance
• Monitoring the application status and performance and taken actions accordingly
• Created Intelligent Dashboards for different groups of users to view across Regions, Product Demography with the facility to drill-downs and charts
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic), Pivot Table, Chart, Column Selector, Tabular) using BI Analytics Web
• Worked on custom styles and skins for OBIEE11g like changing the company logo
• Validated the data populated in the ware house

Confidential

Solution Environment: OBIA, Siebel, ORACLE

Tools: OBIEE 11g, Informatica 9.x, DAC

Responsibilities:

• Experienced in Customized OBIEE Admin Tool to develop the three layers in the Repository
• Involved in the up gradation of OBIEE 10g to OBIEE11g
• Experience in the RPD and Catalog up gradation
• Testing, debugging the Data loading
• Involved in the Regression testing
• Experience in the testing and bug fixing of the finalized reports by the client
• Unit testing for the developed RPD and Dashboards and test overall System functionality
• Preparing Test cases to report the Bugs reported by clients
• Experience in preparation of test cases and testing of mappings and reports
• Preparing Technical documentation
• Unit testing for the developed RPD and Dashboards and test overall System functionality
• Preparing Test cases to report the Bugs reported by Clients

Confidential

Solution Environment: OBIEE, Essbase

Tools: Oracle CRM on Demand

Responsibilities:

• Involved in understanding the requirements of the client, business scenario(s) and the application and prepare the design documents on the Reporting side (CRM Reporting Document)
• Analyzed the requirement and completed the Reports and Dashboards in the specified time
• Daily interacted with the client and got the requirements and update the completed work
• As CRM on Demand is SAAS (Software as a service) access is limited so, created column level formulas to meet the requirements
• Created Action Links for navigating from reports column to the CRM records like Account Details, Opportunities Details, Lead Details, and User Details
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users
• Involved in Embedding of Reports, using narrative view
• Integrating and configuration of obiee using smart view

Confidential

Solution Environment: OBIEE, Oracle, Windows

Tools: OBIEE 10.1.3.4, Informatica 7.1, Oracle 10g, Windows XP

Responsibilities:

• Configured dimension hierarchies and assigned levels and custom aggregation rules for each level
• Involved and developed various steps to improve the performance of the queries used in the reports by having the aggregate tables
• Involved in Configuring 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
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users
• Implemented the delivery of iBots using Delivers to alert the associated teams
• Involved in Unit Testing, Integration Testing and User Acceptance testing of the reports generated using OBIEE
• Configuration includes creating/modifying reports, dashboards, and delivers using iBots

Confidential

SQL Developer

Solution Environment: OBIEE, Oracle, Windows

Tools: OBIEE 10.1.3.3, Oracle 9i, Windows

Responsibilities:

• Configured dimension hierarchies and assigned levels and custom aggregation rules for each level
• Understanding the requirements of the client, business scenario(s) and the application and prepare the design documents
• Worked extensively on OBIEE Administration tool and Presentation Services
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the Presentation layer in the repository(rpd)
• Created Dimensional Hierarchies, Level based Measures in Logical Layer to achieve Drill down Functionality
• Developed Aggregate Tables, Time Series Functions & Bridge Tables
• Developed Rank & Shares, SCD based on the Business Requirement
• Configured Repository variables to generate dynamic reports
• Configured session (system) variables to implement data level security
• Using OBIEE Presentation service Web extensively developed Answers Pages and Dashboards with different views like Drill-Down / Dynamic Pivot Table, Chart, Column Selector, Narrative Tabular with global and local Filters
• Implemented prompts to provide dynamic filter condition to end users
• Experience in Oracle BI EE Unit testing report data validation report data testing based on SQL results OBIEE query log data validation

Confidential

Solution Environment: OBIEE, Oracle, Windows

Tools: OBIEE 10.1.3.3, Oracle 10g, Windows

Responsibilities:

• Worked on three layers of repository to define metadata based on requirements
• Created dimensional hierarchies to implemented level based measures
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages and Prompt
• Utilized time series functions to support historical time comparison analysis
• Analyzed end-user query performance when implementing and tuning OBIEE
• Used and created variables to dynamically modify conversion values for logical column formulas
• Managed security privileges for each subject area and dashboards according to user requirements
• Merged new RPD, dashboard and Answers requests with existing OBIEE content
• Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer(unit testing)