SUMMARY

• Over 8 years of professional experience as OBIEE Consultant and BI APPS Consultant with understanding of Oracle E-Business Suite Applications in HR analytics OM order management, Purchasing PO, Inventory INV, Bill of Material BOM, Work in Process WIP, General ledger GL, Account Payables AP and Account Receivables AR.
• Nearly 6 years of experience in OBIEE 10.1.3.4.1/11g Analytics Architecture and Reporting. Vast experience in IT involving gathering Business Requirements, GAP Analysis, Data Modeling Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts.
• Proven skills in complete lifecycle of Design, Analysis, Development, and Implementation of Business Intelligence with Star and Snow flake Schemas using Kimball and Inmon Methodology using OBIEE, Siebel Analytics 7.x and Informatica 8.x/7.x/6.x, Informatica B2B data transformation.
• Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies
• Extensive experience in providing end-to-end BI solution by dimensional modeling design, Logical/Physical models, building/configuring RPD, Answers, Delivers / iBots, creating reports / Dashboards, Cache management, and setting up Security using LDAP Authentication and Basic RPD Authentication
• Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, OBIEE Security Setup groups, access / query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports
• Very strong in developing Informatica Mappings / Mapplets using various transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets various Tasks and scheduling them using both Workflow Manager
• Good at database Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions
• Extensive experience in business process reconciliation, design, configuration, testing, quality analysis and production support
• Expertise in building Metadata Repository, Designing Complex Business and Presentation Layers, Answers, Delivers / iBots, developing dynamic Interactive Dashboards with drill-down drill-across capabilities, Security Setup, Web Catalog Objects using Oracle Business Intelligence and Metadata Migration to different environments.
• Strong understanding of data warehousing concepts, dimensional modeling and establishing referential integrity of the system, designing Star and Snowflake schemas.
• Developed and scheduled IBots using BI delivers to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented complex Aggregation strategies for Metadata in BMM layer.
• Experienced in creating guidelines and templates for designing developing BI Applications.
• Implemented and extensively worked in Multi User Development Environment MUDE and performed Administration tasks such as Creating users, groups, projects and provide required authentication as needed.
• Experienced in complete Software Development Life Cycle SDLC which includes Business Requirements Gathering, System Analysis Design, Data Modeling, Development, Testing and Implementation of Data warehouse and Business Intelligence Applications.
• Devised strategy for refreshing reports Query caching. Optimized database indexes and ran statistics process for enhancing query performance.
• Extensive experience in writing SQL queries, PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Database Objects and possess good understanding of oracle data dictionary.
• Expertise working with Oracle 7x/8x/9i/10g, Oracle Developer Suite, PL/SQL, Forms 10g/6i/4.5, Reports 2.5/6i/10g, SQL Loader, UTL FILE, Discoverer 4i/10g, BI Publisher 10.1.3.x/11.1.1.7.x and XML publisher 5.6.3/5.6.2.
• Installed and Configured DAC to manage ETL processes for OBIEE Analytics.
• Created Custom Containers and ETL execution plans in DAC.
• Adept at development and customization of RICE Reports, Interfaces, Conversions, and Extensions objects.
• Great communicator and diligent team member with strong technical background and good inter-personal skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

BI Reporting Analyst

• Extensive work on the relational and star schema data modeling.
• Gathered reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Created centralised Dimesional models for the developers of University to work easily on the target physsical tables using CA ERWIN and SQL architect.
• Expert on data analysis for all the upgrade projects of Enterprise source systems of university.
• Expert on servers maintainance and administrative tasks on security and management on obiee 11.1.1.7.0
• Successfully completed upgrading and configuring OBIEE 11.1.1.7.0 tools on the servers and clients without errors on BI publisher reports and obiee reports and dashboards
• Worked and successfully completed configuring the OBIEE 11.1.1.7.0 on Shiboleth authentication for security which is a challenge for even oracle as they were all mostly experienced on ldap authentication.
• Working on Informatica Designer Components - Source Analyzer, Transformations Developer, Mapplet and Mapping Designer with Source Oracle and Redshift.
• Implemented security based on LDAP Authentication.
• Used OBIEE Web Catalog to set up groups, access privileges and query privileges
• Worked on the complex star schema models in the industry with multiple facts uder a logical fact with more than 40 million records each and had tuned to give the best perfomance on all most complex reports in the industry.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Worked with various different Hierarchies on different Levels, and implemented Business Logic by creating level based measures in OBIEE business model and mapping layer.
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files and SAS cubes.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Worked on complete SDLC from Extraction, Transformation and Loading ETL of data using Informatica.
• Scheduling and monitoring of all jobs through DAC and informatica and communicating with the other teams for the dependant jobs to avoid hassles.
• Subject matter expertise with strong communication and skills who can work in a team or independently.

Environment: OBIEE 11.1.1.7.0, Informatica 9.1, SQL Developer, sql server, MS Analysis Services cubes,TOAD, Oracle 10g/11g, HP Quality Center, UNIX.

Confidential

BI TECH LEAD

• Worked on complete Software Development Life Cycle SDLC , from gathering requirements to deployment and all aligned phases of the overall project.
• Understanding Oracle Apps Financial core structure and Gathering of the functional requirements of the Financial Users and analyzing the creating feasible design approach.
• Getting data from different sources into OBIEE for reconciliation process which are not in main data sources of Oracle ie.,11i and R12
• Configuring the Technical Specifications Document and signoff from Business User
• Developed the overall Design of the profitability in SDD Solution Design Document and add ons of different versions as per new requirements on T M basis and took the Sign Off from Solution Architect team and users on the same
• Preparation of Project Plan for Different Phases of the Project Including Development, UAT and Go live of the Project by working Insync with Project coordinator.
• Developed and coordinated the ETL Mappings along with the Offshore team in Informatica 8.1.1,Informatica B2B data transformation and OBIEE 10.1.3.4.1,11g and rpd development and dashboards for PGBU Profitability Analysis and migration to Stage Environment for UAT with Global users.
• Solely carried all enhancements relating to code change in all ETL mapping of Informatica and OBIEE RPD changes and modifications for all entities identified in project and migrated to the production environment through the Cummins change request process successfully.
• Worked extensively on design of DAC Datawarehouse Administration Console 10.1.3.4.1.20090415.0146, execution plan for the project and ran and monitored the loads during US time for all uploading of the CSV files to UNIX server for ETL s and pull data to OBIEE Front End during UAT and post development phases.
• Solely supported the issues resolution during the UAT and pre UAT along with the Business users
• Developed complex designs of Elimination process and Line of Business Categorization which will give the exact figures for financial users for their entities for particular product basis.
• Worked extensively on CSV files data interpretation for bringing data to OBIEE through all CSV files and UNIX scripting for possible reconciliation with HFM Hyperion Financial Management .

Environment: OBIEE 10.1.3.4.1/11.1.5, Oracle EBS R12 General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM , Oracle 10g, TOAD, PL/SQL, , Oracle BI APPS 7.9.6, DAC, Crystal reports, Informatica B2B, XML publisher 5.6.3,BI Publisher 10.1.3.x/11g, SQL Loader.

Confidential

BI ANALYST

• Worked on complete Software Development Life Cycle SDLC , from gathering requirements to deployment.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica ETL .
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Monitored incremental and full load of data through Data Warehouse Administration Console DAC and Informatica.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBots queries to obtain daily and weekly reports.
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in answers calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Granting access to users and maintain security by using database authentication and authorization.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
• Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console DAC and Informatica.
• Involved in developing the Incremental ETL processes i.e., Mappings Mapplets using various Transformations and Workflows with Sessions/Tasks for data extraction from E-Business suite.
• Used Heterogeneous sources in Informatica like flat files and Oracle apps tables.
• Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics and Procurement and Spend Analytics.
• Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Involved in complete Procure-to-pay P2P and Order-to-Cash O2C life cycle.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables AP using OBIEE.
• Developed Replenishment Interface in Oracle Inventory INV based on data sent from warehouse in flat file. Used Loader program to load the data into the staging table, and then performed PL/SQL validations to load the data into the interface tables.
• Developed balance sheet, profit and loss statement using BI Publisher.
• Worked on tools like TKPROF and Explain Plan for tuning of PL/SQL queries for better database performance.
• Resolved open issues with production system
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents.

Environment: OBIEE 10.1.3.4.1/11g, Oracle EBS R12 General Ledger GL, Account Payables AP, Account Receivables AR, Inventory INV, Purchasing PO, Order Management OM , Oracle 10g, TOAD, PL/SQL, , Oracle BI APPS 7.9.6, DAC, Informatica 8.6.1, XML publisher 5.6.3,BI Publisher 10.1.3.x/11g SQL Loader.

Confidential

BI APPS ANALYST

• Identified Created Facts, Dimensions and Hierarchies of the business model and mapping layer.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc reports according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports pivots, charts, tabular using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.2, Oracle BI Applications 7.1.3, Informatica8.1.1, DAC, Oracle 10g, SQL Developer, SQL Plus, BI Publisher 10.1.3.x,XML Publisher, Windows-XP.

Confidential

BI APPS Consultant

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Server Admin tool by importing the required objects Dimensions and Facts 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
• Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters
• 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
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles web groups, checks with LDAP Authentication
• Involved in developing Initial and Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Developed many PL/SQL procedure functions and used the same in mappings, pre and post sessions
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• 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 the OBIEE Repository.

Environment: OBIEE 10.1.3, Informatica 7.1, Oracle 11g, SQL, PL/SQL, TOAD Functional Area: Sales and Marketing, and Finance

Confidential

OBIEE Application Architecture Consultant

• Gathering, Analyzing and identifying the Gap of Business Reports Requirements.
• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Responsible for creating a prototype of the application, create the Functional Requirements Document FRD , and demo the prototype to the end users for sign off
• Implemented Security by creating roles, web groups, and external tables.
• Developed many Analytical and Operational reports using different Analytics Views Pivot Table, Chart, Column Selector, and Narrative View , Dynamic / Interactive Dashboards with drill-down and drill through capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots.
• Set Aggregate Navigation for all aggregate fact tables in the BMM layer.
• Created repository, session variables, and initialization blocks for security and dynamic time periods.
• Identified Facts and Dimensions with levels hierarchy and developed OBIEE Repository RPD at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model /data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed the Initial and Incremental / Delta ETL process i.e., Mappings Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• 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 Siebel Analytics Repository.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD Oracle
• 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.

Environment: OBIEE 10.1.3, Informatica 7.1, Oracle 10g, SQL, PL/SQL, TOAD