Summary:

• Over Eight years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 11g/10g/9i/8i, Informatica power center 8.x/7.x/6.x, Oracle business Intelligence OBIEE which include over Seven years of experience in Oracle business Intelligence OBIEE Reporting.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards using Analytics and OBIEE.
• Very strong experience in developing OBIEE/Siebel Analytics Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, OBIEE/Siebel Security Setup users/groups, access / query privileges , configured OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog Objects Dashboard, Pages, Folders, Reports , scheduling iBots.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions etc., where ever necessary to increase performance.
• Expertise in developing all 3 layers of the Analytics Repository Physical Layer, Business Model Presentation Layer .
• Experience in Siebel Analytics 7.8.2/10.1.3.2 and in configuring repository, create/manage Dashboards, reports/Answers, Disconnected Analytics
• Experience in Debugging, Optimizing and Performance Tuning of Oracle BI Analytical Dashboards/Reports.
• Extensive experience with SQL and PL/SQL.
• Experience in OBIEE/BI Apps OBIA with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Experience on Data Warehouse Star Schema, Snow Flake and Extended Star Schema, ETL, DW, DM and testing as well.
• Possess good knowledge on Hyperion Essbase.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis , ETL processes in developing data marts and Enterprise Data Warehouse
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Analytical Dashboards/Reports.
• Extensively used Informatica Power Center 8.1/7.1.2/6.2/5.1 for creating various mappings.
• Expertise in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Work lets various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts pmcmd .
• Good experience with configuring Data Warehouse Administration Console DAC for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Experience in Installing, Configurating and setting up OBIEE/OBIA Environment with Different ETL Tools Like Informatica and ODI 11g.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.
• Experience with Peoplesoft, Oracle E-Business suite and Siebel CRM.

Experience:

Confidential

Oracle BI Consultant

Responsibilities:

• Involved in the Business Analysis, Functional design, Gap Analysis, Technical design, Development, Deployment and Testing and also in creating Traceability Matrices for the project.
• Customized, Configured and Created the OBIEE Repository physical, BMM, and presentation layers .
• Creating Subject Areas for Logical Stars and Snowflakes.
• Designed and Tested Reports in the Dashboards for the Oracle Procurement and Spend Analytics Financial Analytics modules and created the Ad-hoc report according to the Business needs.
• Worked on E-Business Suite Modules such as General Ledger, Profitability, Account Payables and Receivable, the Reports were made to analyze the past year's financials data to help grow the company revenue Increase profitability. The reports displayed the key Areas of Performance including the Balance sheet, Cash flow, Liquidity , GL Balance.
• Involved In performing full load using Informatica 9.0.1 DAC 10.1.3.4 and loading the Sales Financial Analytics data into Repository for the purpose of designing and developing of reports dashboards.
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.
• Worked Extensively on OBI Applications including Sales Analytics Financial Analytics to generate reports and identify any incoming changes.
• Managed security privileges for each subject area and dashboards according to user requirement.
• Performed Full and Incremental loads through DAC on different environments.
• Involved in Migration of Repository from Test Environment to Production Environment.
• Developed custom reports/Ad-hoc queries using Obiee Answers and assigned them to application specific dashboards.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Experienced in Data Modelling using Dimensional Data modelling , Star schema modelling ,Fact and Dimension tables including physical,logical data modelling in obiee Administration tool.
• Developed different kinds of Reports Pivots, Graphs, Tabular using global and local Filter.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Compared Data from Hyperion Essbase with OBI for Data Validation.
• Used existing Data from Hyperion Essbase for analysis.
• Possess Good Knowledge on Hyperion Essbase.
• Configuring Agents and Delivers.
• Applied Optimization Techniques for the better performance of the reports.
• Experience in Debugging of ETL Loads in DAC when they Failed.
• Extensively used SQL Tuning to improve performance.
• Created Financial Reports using SQL and PL/SQL in BI Publisher.
• Involved in Installing,Configuring OBIEE/OBIA 11.1.1.7 with ODI 11g on a Test Server as part of Upgrade Project.
• Involved in Customizing the ODI Mappings/Interfaces in ODI 11g.
• Experience in setting up ELT Loads using BIACM By defining a source Instance and configure offerings and creating a Load Plan.
• Involved in Running and Monitoring ELT Loads using BIACM and Operator in ODI Studio.
• Experience in Creating and Customizing ODI Interfaces ,Mappings and monitoring ELT Loads.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Created Highly formatted pre- built reports with BI - Publisher.
• Created proactive Agents and interactive Dashboards to alert the Sales team about incoming changes in reports.
• Created complex mappings in Power Center Designer using Source Qualifier,
• Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.
• Created Technical Documentation for ETL and BI .

Environment: Oracle 11G, OBIEE 11.1.1.7, OBIA 7.9.6.3, Oracle BI Apps HR Analytics, Financial Analytics ,Sales Analytics , Informatica Power Center 9.01, ODI11g, DAC 10.1.3.4, E Business suite 12.1.X,Toad,BI Publisher.

Confidential

Oracle BI Consultant

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Install, configure, and administer the OBIEE platform.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Upgraded from 10g to 11g
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Creating KPI's Key Performance Indicators , Interactive Dashboards, Administering Oracle OBIEE Applications.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Implemented Multi User Development Environment MUDE for concurrent rpd development.
• Developed and debugged many Dashboards using different Analytics Views Pivot, Table, Chart, and Column Selector, View Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Implemented SSO setup in project which helped in retrieving information from back end
• Worked on Core Modules like GL, AP, AR.
• Worked on the Hyperion Essbase Cubes.
• Created complex reports using SQL and PL/SQL.
• Upgrading the OBI Apps from 7.9.6.2 to 7.9.6.3 and also involved in setting up of the DAC which has the backup of your DAC client and Server and DAC metadata files.
• Developed various mappings to load data from various sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target table.
• Involved in creating Technical Documentation for ETL and BI after the completion of Project.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Upgraded the Informatica repository to Informatica 8.6.1 to 9.0.1.

Environment: Oracle 11G, OBIEE 11.1.1.6 BP1 , OBIA 7.9.6.3,Oracle BI Apps HR Analytics Financial Analytics ,BI Publisher, DAC, Informatica Power Center.

Confidential

Oracle BI Consultant

Responsibilities:

• Involved in building detailed project schedule, gathering the requirements, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and made Technical designs and Unit test scripts.
• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE/Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters using Presentation Services/Siebel Analytics Web.
• Upgrading OBIEE 10g to 11g and fixing the errors coming on the way.
• Well versed with DataModelling/Data Quality/ETL/BI application design.
• Implemented Security by creating roles and web groups, checks with External tables and LDAP.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Created VPD security for reports in OBIEE.
• Migration of existing reports in Oracle EBusiness Suite such as Purchase Orders, Deposit slips, checks etc. to BI Publisher.
• Life-cycle support for migration efforts from Development to Integration Test to Production Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE/Siebel Analytics Repository.
• Performed Data Validation of data in the reports, Fixed all the errors and warnings in the repository and web catalog.
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
• Supporting Informatica Server and related components with in the Oracle BI Package
• Involved in Upgrading the OBI Apps from 7.9.6.2 to 7.9.6.3 and also involved in setting up of the DAC which has the backup of your DAC client and Server and DAC metadata files.
• Oracle warehouse builder 11GR2 OWB and Oracle Data Integrator implementation and training for staff to enable building the obiee logical layer.

Environment: Oracle 11G, OBIEE 11.1.1.3/10.1.3.4, OBIA 7.9.6.3,Oracle BI Apps HR Analytics Financial Analytics Data Modeling ER Win , BI Publisher, DAC, Informatica Power Center,ODI, TOAD.

Confidential

Oracle BI Consultant

Responsibilities:

• Business requirement gathering, understanding business objectives and analysis. One on One meeting with SME to understand the business scenario and process in Capturing User Requirement using technical specs.
• A full cycle development of Supply Chain Analytics was implemented. Involved in identifying, designing, configuring and testing the application.
• Responsible for setting up the environment including installation and configuration of OBIEE, BI Apps and Informatica.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository .rpd .
• Creating reports and publishing them in the dashboards using answers.
• Customized and developed repository, configured metadata objects Subject area table column and web catalog Objects Dashboards, Pages, Folders, and Reports. .
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics using OBIEE.
• Add users to the new group and apply the data level security and object level security at the rpd and Web catalog.
• Configured Low Level Security to allow users to view data only according to this requirement.
• Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Define iBots / Delivers for various requests if needed.
• Created reports in BI Publisher using PDF, RTF templates.
• Performed OBIEE Administration including creation of users and cache management.
• Worked on OBIEE Administration like installation, configuration of Obiee Security External Database, LDAP, Aggregate Table Configuration of nqs config file and also Instanceconfig.xml files, Setup and Configure OBIEE Delivers, Creating Materialized Views, Setup MUD Environment Repository Merge, Catalog Merge, Deployment from development to production.
• Created hierarchies based on the territory level to territorial level sales and contact reports.
• Used unconstrained filters, column filter prompts and various views such as Pivot tables.
• Created reports and delivered the same to the end-user through Delivers.
• Created Dimensional Hierarchy from Date, Facility and Location Dimensions, Level based Measures and Aggregate navigation in BMW layer.
• Merge Repositories two way and three way into master repository from each developer.
• Merging Catalogs folders to master catalog using Catalog Manager.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many dimensions and time series objects with Security settings for analyzing, Configured charts, pivot table views, filters, and ticker in user interface.
• Developed aggregate fact tables using the content tab.
• Configured Repository and session variables to get dynamic reports and dashboards.
• Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements, Mapped the configurations to accommodate for the Territorial hierarchy that were accommodated via chart drilldowns.
• Good Knowledge on Hyperion Essbase Cubes.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Developed many PL/SQL procedures and functions and used the same in mappings.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in analyzing ETL mappings using Informatica 8.6.1, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
• Used DAC Data warehouse Administration Console for both incremental and full loads.

Environment: OBIEE 10G, BI Publisher XML Publisher , Financial, Procurement, Supply Chain , Peoplesoft,DAC Data Warehouse Admin Console , informatica 8.6.1, Data Modeling ER/Studio , Essbase, PL/SQL, TOAD.

Confidential

Oracle BI Consultant

Responsibilities:

• Managed the connection pool entries associated with physical data sources
• Creating the logical data models like Hierarchies, Aggregate navigation, Level-Based-Measures, Reporting views.
• Defining the logical grouping and nesting of presentation variables and attributes
• Managing table level cache persistence and purging cache when needed
• Creating dashboard tabs within high-level dashboards in addition to managing the level of content displayed.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generating Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created guided navigation links to help files within the dashboards to help the end users.
• Worked in a multi user development environment MUDE .
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed BI Publisher, Publisher Desktop, integrated with OBIEE to develop template. Used MS OFFICE Add-ons in reports, Dashboards and answers.
• Creating Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Assisting in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple Data sources into targets.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance, Supply Chain and Order Management Analytics.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to subscribed users.
• Upgraded the Informatica repository to Informatica 8 to 9.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Built multiple execution plans in DAC for weekly and daily loads.
• Developed Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data into data warehouse.

Environment: OBIEE 10.1.3.4.0, OBIA/ BI Apps 7.9.5, Informatica 8.1.1, Data Warehouse Administration Console DAC 7.9.5, Financial Analytics, Order Management Analytics, Supply Chain Analytics, Oracle 10g, Essbase , SQL PLUS, SQL Loader, TOAD, UNIX.