PROFESSIONAL SUMMARY:

• Having around 8 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 and Tableau
• Having international client facing experience covering clientele from across the globe like USA, Canada, Sweden, UAE, UK, and the MEA Region.
• 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
• Expertise in configuration and creation of MAPS using Oracle Map viewer and Map Builder.
• Expertise in creating Customized Maps as per the user requirement.
• Expertise working with Business Intelligence data visualization tools with specialization on Tableau Desktop,server,mobile and public
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Strong experience in Data Warehousing and ETL using Informatica Power Center
• Expertise in creating mappings, interface and packages in Oracle Data Integrator.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
• 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 all different views (table, pivot, graph and trellis) available in the latest OBIEE 12c version
• 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),DVD(Data Visualization Desktop
• 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, DVD,Mapbuilder, Tableau 8.0/8.1

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

DBMS: Oracle 10g/11g/12c

Operating System: Windows, UNIX

Languages: SQL, PL-SQL, JavaScript

Others: Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential

Solution Environment: OBIA, EBS

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

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

Confidential

Solution Environment: OBIEE 12c, Siebel CRM, Map viewer

Tools: OBIEE 12c, ODI12c, Oracle 12c

Responsibilities:

• Involved from scratch implementation of BI Project for OPS
• Experience developing Metadata repository suiting to data requirements using OBIEE Analytics Admin Tool.
• Implemented logical and physical data modeling with STAR schema techniques in Data Mart.
• Organize presentation layer in a format that is easy for end user to use as basis for reporting.
• Developing custom Dashboards and Reports using OBIEE Answers. Created Prompts, Filters, Charts, Pivot Tables and different Views as per client requirement.
• Developed report with conditional filters and global filters.
• Created drill down and master detail action links.
• Created agents to schedule the reports in different formats (PDF,EXCEL) for end-users as per the requirement.
• Created and configured customized Maps using map builder tool as per the requirement.
• Configured OBIEE map viewer and map management data.
• Implemented OBIEE security created user, groups and application roles.
• Creating Report level Navigation and Dashboard level Guided Navigation Link.
• Created reports and dashboards using OBIEE 12c visual analyzer.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Oracle data warehouse.
• Used ODI 11g for extraction, loading and transformation ETL of data in the data warehouse
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components
• Created different design level documents.
• Implemented migration of OBI objects from one environment to another using catalog manager.
• Involved in conducting end-user .

Confidential

Solution Environment: OBIEE 11g, Tableau 8.x, EBS, CDH

Tools: OBIEE 11g, Oracle DB.

Responsibilities:

• Migration of Critical OBIEE 11g BI Reports to Tableau platform and creating additional reports and dashboards.
• Extracting data from different sources connecting them and used the same to create dashboard
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Experience with the design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Experience with the design and development of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Developed complex SQL scripts database for creating BI layer on DW for tableau reporting.
• Identify new metrics and enhance the existing KPI's.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter Local, Global and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various 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
• Involved in the design and implementation of data warehouse system EDW from multiple source systems (IVR,ACD and WFM) based on the user requirement
• 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
• Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• 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