PROFESSIONAL SUMMARY:

• Around 8 years of diversified IT experience in Consumer Goods, HR analytics, Services Industries, financial Domain.
• Certified Implementation Specialist of Oracle Business Intelligence Application 7 for ERP.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Well - versed in Data Transformations and Data Migrations using Oracle Data Integrator 10g/11g from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Experienced in OBIEE solution architecting (OBIEE 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server.
• Experience with all components within Oracle's BI Applications (OBIEE) including configuring RPD, creating and managing OBIEE Dashboards, OBIEE Answers, Agents/ IBots, Presentation Services, BI Server and BI Publisher, DAC and Extraction Transformation and Loading using Informatica.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), customizing reports, filters, Interactive Dashboards, KPIs, Scorecards using global and local filters, Security setup (groups, access/query privileges).
• Experience in creating and building Elasti Cubes and Dashboards using Sense BI Tool.
• Experience in Oracle BI Apps (OBIA) and strong Working knowledge with Oracle EBS modules of HR Analytics, Financial Analytics and Supply Chain Analytics.
• Integrated OBIEE with EBS for Single Sign On (SSO) for Users.
• 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.
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Conducted design sessions with data owners toward capturing business requirement for an analytics environment.
• Working closely with end user community to enhance and improve the user experience architecture look and feel
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Experienced in troubleshooting production issues and production support for projects.
• Involved in performance tuning of Oracle SQL, PL/SQL queries.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Excellent exposure to GL, AP, AR and PO modules, and further specialization in the EPM product line which includes Financial Service Industry (FSI).
• Implemented BI solutions in various domains such as Oracle Financial, Sales, and Human Resources worked on end to end implementation of BI APPS which include (OBIEE, ODI)
• Created highly formatted reports in Oracle BI publisher by using Oracle BI answers and Oracle BI server metadata. Performed RPD and web Catalogue merging.
• Configured and installed metadata objects and Web Catalog Objects, BI Publisher and integrated with OBIEE server.
• Mapped Dashboard field requirements to OLTP/OLAP Physical/Business Model.
• 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, SQL, and PL/SQL.
• Unique combination of personal, analytical, technical and communication skills

TECHNICAL SKILLS:

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

Business Intelligence: OBIEE 10G, OBIEE 11g, OBIEE 12C OBIEE Administration, WebLogic Administration, Oracle Fusion, BI Publisher, ODI, Map Viewer, Map Builder, EBS R11, EBS R12, OBIA 7.9.6.4

ETL Tools Database: ODI 12.2.1.0/11.1.1.9/11.1.1.3/10.1.3.5 , Informatica 9.x/8.x/7.x/6.x Informatica Power Mart, Informatica Power Center, Oracle Data Integrator (ODI).

RDBMS: Oracle 11g, 10g, 9i, Hyperion, SQL Server 2008, SQL Server 2008 R2 Verticals Sales, Pharma, Manufacturing, Judiciary, Healthcare, Banking, Retail, Financials, Supply Chain

OBIA: Supply Chain and Order Management Analytics, Case Management analytics, Human Resource Analytics, Procurement and Spend Analytics, Finance Analytics, Retail Analytics

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, XML, PERL

Application Tools: OBIEE 11g/10g, Discoverer /9i/10g/11g, BI Publisher, Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g

Operating System: UNIX, Linux (Red hat enterprise),Solaris and WINDOWS 98/2000/NT/XP

Other Tools: Toad, SQL Navigator, SQL*Plus, SQL*Loader.

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

Web Technologies: ASP.NET, CSS,HTML, XML, Java Script

Methodologies: Software Development Life Cycle (SDLC) -Waterfall ModelAgile Methodology, Rational Unified Process (RUP)

Toad, SQL Navigator, MS Visio, MS: Office (Excel, Ppoint, Word), JIRA

PROFESSIONAL EXPERIENCE:

OBIEE/ODI Developer

Confidential, Jersey City, NJ

Responsibilities:

• Worked on Oracle Enterprise Manager 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
• 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.
• Designed architectural frameworks for OBIEE 12C applications to meet business needs
• Designed & Implemented Map viewer integration with OBIEE 12c.
• Installing ODI 11.1.1.6 on all the environments and configuring ODI.
• Patching ODI 11.1.1.6.0 to 11.1.1.6 and Upgrading ODI from 10.1.3.4 to 11.1.1.6.4 .
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• 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.
• Customized Out of the box Repository (RPD) to work with other ERP systems and Essbase.
• Financial Planning Manager and other developers
• 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 12c, SQL*PLUS, SQL Developer, Windows XP.

OBIEE Developer

Confidential, New York, NY

Responsibilities:

• Communicating with SME's, Business Analysts and Users for gathering and analyzing the Business Reports Requirements and did the necessary GAP analysis, translated them into technical design documents and made recommendations to close the GAP.
• Performed the Setup, Installation and Configuration of the complete Analytics platform environment OBIEE, Informatica and DAC and the required connectivity for integration with the data warehouse.
• Utilized Informatica (ETL) and Implemented Financial Analytics, Supply Chain Analytics, Integrated data from Finance and other enterprise systems and transformed data.
• Extracted the data from the source system (EBS R12), transformed the data and loaded into the OBIEE analytics warehouse using Informatica.
• Setup of Multi User Development Environment (MUDE) in OBIEE.
• Analyzed, Designed, and Developed OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Designed, implemented and tested security privileges on Dashboards and Reports.
• Worked using Catalog Manager to migrate Web Catalog among Instances.
• Built reports using Answers including drilldown objects, union based reports and formatted functions within the reports.
• Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.
• Customized Out of the 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.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Developed many complex Full/Incremental Informatica Objects (Workflows/Sessions, Mappings/ mapplets) with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customization and enhancement of standard Oracle applications reports in Account Payables module like Invoice Aging Report, Invoice Validation report, Cash requirement report using Oracle BI Publisher.
• Developed process and business rules around setup of new users (Logins, Responsibilities).
• Conducted meeting with project managers, business users during testing and deployment stage of the application development life cycle.

Environment: Oracle EBS R12.1.1 (General Ledger (GL), Account Payables (AP), Accounts Receivable (AR), Inventory (INV), Purchase Order PO), OBIEE 11.1.1.6, BI Apps 7.9.6.4, Informatica 9.1, DAC 11g, .NET, Toad

OBIA Consultant

Confidential, Dallas, TX

Responsibilities:

• Installed the Oracle BI Enterprise Edition on distributed environment and responsible for administration and migration of repositories between various environments.
• Involved in translating functional requirements into technical requirements assisted in building detailed project schedule, gathering the requirements, completed the proof of concept.
• Actively involved in creating custom Interactive Dashboards, Answers and Administering Oracle BI Apps Applications
• Responsible for configuring HR Analytics module, which is associated with the data sourced from People Soft?
• Involved in Daily status meetings and preparation of operational plan and Involved in technical Conference Room Pilot sessions.
• Worked with Oracle BI Apps (OBIEE) Installation, Oracle BI Server, Presentation Server, Repository and Oracle BI Administration.
• Development using Oracle BI Repository like, Physical Layer, Logical Layer, Presentation Layer Analysis, Design, development and customization of Reports and Dashboards in OBIEE.
• Daily client interaction. Preparation and execution of the test plans.
• Developed customized reports like gross and net reports on the number of new Connections/Cancellations made by the customers hourly/ Daily/ Weekly/ yearly from different regions and used BI Publisher tool to generate the pixel perfect reports based user criteria.
• ETL process using Informatica for deploying OBIEE reporting solution and optical metadata modeling. Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
• Created Guided Navigation Links within OBI Dashboards
• Customized the OBIEE web user interface to meet Client reporting standard and developed key business Reports and Dashboards. Developed yearly and quarterly sales trending reports using time series functions like ago and To-date.
• Involved in applying department level data security for all BI reports and dashboards.
• Implemented the Cache Purging Strategy and usage tracking of Reports.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.

Environment: Oracle BI Apps 7.9.6.3, OBIEE 11.1.1.6, Informatica 8.6, PeopleSoft HR Analytics, DAC, OBAW, Oracle11g, SQL Developer, PL/SQL.

OBIEE Consultant

Confidential, Chicago, IL

Responsibilities:

• Involved in requirement gathering, customer interaction, analysis of the requirements and project module designing.
• Involved in logical & physical database layout design.
• Developed back-end Logic.
• Experience with data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques.
• Involved in writing SQL queries and functions and applying optimization techniques.
• Created packages and procedures to automatically drop table indexes and create indexes for the tables.
• Experience with oracle supplied packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Developed stored procedures and triggers using PL/SQL in order to calculate and update the tables to implement business logic.
• Worked extensively on ref cursor, external tables.
• Expertise in dynamic SQL, records, tables, collections (nested tables and arrays) and exception handling.
• Used pragma autonomous transaction to avoid mutating problem in database trigger.
• Implemented SQL loader, DB links, materialized view & UTL File.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Experience with performance tuning for Oracle RDBMS using explain plan and HINTS.
• Have done code reviews, debugging, bug fixing, performance tuning and unit testing.
• Have documented overall system resources in migration document, testing procedures in user acceptance testing document.

Environment: Windows, Linux, OBIEE 11g, Oracle 11g, BI Apps 7.9x, Informatica, DAC, SQL Developer, Oracle E-Business Suite.

OBIEE Developer /Admin

Confidential

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created High-level Design Documents (HLD) according to the Business System Requirements (FR/NFR)
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC, Analytics for creating Auto Execution and Scheduling Tasks.

Environment: OBIEE 10g, Oracle 10g, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL*Loader, SQL*Plus, PL/SQL, Windows 2000, Autosys, UNIX (Sun Solaris), TOAD, PL/SQL Developer.