SUMMARY:

• Over 8+ years of involvement in planning, creating and execution of OBIEE 10g & 11g and ODI 11g/12c studios 3+ years' involvement in 11g.
• Valuable knowledge of OBIEE 11g and also having hands on experience in OBIEE 10g in integration with BI publisher Extraction, Load and Transformation (ELT) using Oracle Data Integrator (ODI) 11g, Informatica 9.x/8.x/7.x and SQL, PL/SQL.
• Strong experience in configuring and developing the Analytics/OBIEE Repository (RPD), which involves Schema Import, Implementing the Business Logic by customization, Dimensional
• Hierarchies, Utilities, Subject Areas etc.
• Administration of OBIEE and the OBIEE Web Catalog
• Good knowledge on Data Warehousing concepts like star and Snowflake Schema Methodologies along with the Strong Banking domain skills and experienced IT project lifecycle in a banking environment as the OBIEE Report Developer and ODI Developer.
• Responsibility includes involvement in gathering business requirements, analysis, design, data modelling, development, which include in designing ETL Process, building and configuring repository.
• Actively involved setting up OBIEE and BI Publisher across multiple server locations
• Integrated the BI Publisher with Oracle EBS, BI Answers, Reports, and Dashboards, to generate standardized reports.
• Designed and developed the OBIEE/ Metadata Repository using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer.
• Worked on slowly changing dimensions (SCD), Change data capture (CDC) as part of data warehousing concepts.
• Experienced in General Ledger, Account Payables, Accounts Receivable, Inventory, Purchase Order and Order Management.
• Oracle Data Integrator (ODI) reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Primary responsibility include but not limited to installing and configuring the Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL to improve query performance.
• Experienced in configuring the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges using LDAP and external database authentication.
• Experienced in Installation, Configuration, up gradation, Migration and Administration of Informatica Power Center/Power Mart and ODI.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Conversant in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse (DWH) and Business Intelligence (BI).
• Expertise in ETL methodology in Data Extraction, Transformation and Loading using ODI and Tableau.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Strong aptitude for learning and understanding business process and needs.
• Exceptional leadership, written and oral communication, and meeting facilitation skills
• Excellent Team Management Skills with good business acumen, effective communicator, experience in working with Business Users and Senior Managers and Executives.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10g/11g, BI Publisher, BI Apps, Oracle EBS, OBIA 7.9.x, Scheduler DAC 7.x, Siebel Analytics 7.7 / 7.8

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order.

ELT Tools: Oracle Data Integrator (ODI) 11g/12c,Informatica Power Center 9.x/8.x, Informatica Power Mart

Data Modelling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams, IBM-Rational Rose, MS Visio

Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS.

Databases: Oracle 10g/9i/8i, MS SQL Server, Teradata and DB2

Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic

Web Technologies: HTML, XML, Java Script

Job Scheduling Tools: Autosys, Control MOperating Systems: Windows, UNIX, MS-DOS

Others Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader IDQ, DB2.

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Sr. OBIEE/ ODI Developer

• Worked on Oracle Enterprise Manager (OEM) to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP, GL and FA
• GG setup integrated capture to replace CDC.
• Experience in installing, maintaining, upgrading and patching Confidential .
• Worked on the RPD for the new Subject area design for the Cash flow Metrics Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, SQL Server and Oracle).
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1. on all the environments and configuring ODI.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Patching ODI 11.1 to 11.1.1.and Upgrading ODI from 10.1.3.4 to 11.1.1.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios,, ODI Functions, ODI Mappings, ODI Load Plans.
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers
• As an administrator I was responsible for security across multiple users and groups.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Configured the OBIEE repository(Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Created PL/SQL stored procedures, functions and triggers for change data capture (CDC).
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• Developed interfaces for loading the lookup and transactional data.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0, ODI12c, WebLogic Server 11.x, OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential, Westlake, TX

ODI/ OBIEE Developer

• Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.
• Involved in system performance tuning to improve the performance from OBIEE report/dashboard wise and RPD.
• Designed Aggregate Tables modeled the repository for improving performance of reports.
• Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
• Designed ETL mappings for bringing in data from various data sources using ODI.
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
• Configured more than 90 Measures in the Business Model Layer that are not critical to performance and mapped them to multiple logical source tables
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
• Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
• Modify existing ETL jobs in Oracle Data Integrator(ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Developed OBIEE dashboards using JavaScript and Cascading style sheets.
• Created Roles/Groups in OBIEE to provide the access to multiple departments without relying on the responsibilities.
• Integrated LDAP server in order to authenticate the users along with Native authentication. Maintained the groups in LDAP and applied the security on user level.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Extensively worked on complex Interfaces which involved slowly changing dimensions.
• Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers

Environment: OBIEE 11.1.1.5.x, BI Publisher, Oracle 11g, ODI 11.1.1.9, SQL, PL/SQL, Informatica-Power Center 9.6, SQL*PLUS, SQL*Loader

Confidential, Columbus, OH

ODI/ OBIEE Developer

• Gathering requirements from users to develop interfaces, packages, Load plans.
• Created Master and Work Repository and developed the ODI mappings.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources, reverse engineering, to develop projects, and release scenarios.
• Worked on using component panel where we can use functionalities like aggregate, dataset, split, filter, join, set, sort.
• Worked on Physical and Logical tabs where in physical tab we can choose KM's and in logical tab we can create mappings.
• Worked with OBIEE Administration tool, Security, Repositories creation and management (Online and Offline ).
• Developed data across all the three layers-Physical, Business Models and Mapping, Presentation layer.
• Oracle EBS R 12/11.5.10.2 and OBIEE integration and LDAP Single Sign-on configuration.
• Developed customized dash boards, score cards and ad-hoc reports.
• Collaborated with the end-users, pilot users to identify their needs and improve the data delivery.
• Worked with PDF, Excel and word templates using BI-Publisher.
• Interfacing with management on all Oracle EBS project related issues, changes, reporting
• Developed additional views(narrative, pivot, chart views) for the data returned by the Query in order to visualize the data in different ways.
• Designing ETL Data Flow Mappings using OWB for data integration preparing a data warehouse creating mapping from source systems to Data warehouse targets from Oracle R12 EBS applications database and several other data sources.
• Data Modeling done with Multidimensional Architecture (Star Schema, Snow Flake Schema).
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Worked on different caching techniques, trouble shooting techniques to improve the performance of the system.
• Created test plans and performed unit testing to test the reports and dashboards.

Environment: (OBIEE) 11g, Oracle EBS R12, Informatica-Power Center 9.5.1, Oracle R12 EBS, Oracle 11g, Windows, SQL Server, Linux, Erwin 7.

Confidential, Dallas, TX

ODI/ OBIEE Consultant

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Involved in requirement analysis, designing of Data Warehouse, populating Warehouse using Informatica ETL, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design implementation and testing of Reports/Dashboards and Analytical Data Model (Metadata/rpd)ODI.
• Designed and built Starschemas/snowflake schemas upon requirements.
• Configured repository (RPD) to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Created and scheduled iBots as per the business requirements.
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process usingInformatica Power Center.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, Oracle Warehouse Builder customize and monitor ETL process.
• Applied Optimization techniques and tuned performance of the reports.
• Provided technical and user documentation and training. Created Dashboards onPharma Sales Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding ODI changes to OBIEE Repository.
• Opened the RPD in offline mode and make the appropriate changes.
• Migrated the tested code of Repository, Dashboard reports, and OW Mappings and Workflows from Development to QA and from QA to Production Environments.

Environment: Oracle Applications 11i/R12 iProcurement, General Ledger, Account Payables, Accounts Receivables, Fixed Assets, BI Apps 7.9.5, Siebel Analytics 7.8.4,OBIEE 10.1.3.4.0/10.1..3.3/10.1..3.2, Informatica 8.1.1, DAC 7.9.5, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i,, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential

OBIEE Developer

• Full project life cycle implementation for Business Analytics Warehouse.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Siebel Analytics 7.8, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.