SUMMARY:

• Over 8 Years of IT experience in Business Analysis, Design, Development, Administration, Testing and Implementation of various OLAP & Client/Server projects in Business Intelligence & Data warehouse.
• Over 8 Years of experience in Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Over 8 Years of strong technical and functional experience in Business Intelligence working with different tools such as Oracle Business Intelligence Enterprise edition (OBIEE) & Oracle BICS(Cloud).
• Over 8 years of ETL Data warehousing experience using ODI & Informatica by using various databases such as Oracle, Essbase and MS SQL Server.
• Strong Knowledge on Oracle Analytics Cloud Service Enterprise (OACS) which includes Oracle Data Visualization Cloud Service (DVCS), Oracle Smart View and Oracle Business Intelligence Cloud Service (BICS).
• Expert level skills in Creating and Customizing ODI Interfaces, Mappings and Creating, Running and Monitoring ELT loads.
• Great knowledge about Topology, Designer, Operator & Security in Oracle Data Integrator.
• Strong knowledge in Oracle Golden Gate and Big Data Technology Stack combination for Real Time Reporting needs.
• Experience in Implementing Oracle BI Apps projects in Health Care, Manufacturing, Payroll & Insurance Domains.
• Implemented BI Apps with various modules like Oracle Sales, Finance, Procurement & Spend, Supply Chain and HR analytics integrating with the ERP Systems like PeopleSoft EPM, JD Edwards and Oracle EBS.
• Experience in Installing, Configuration and setting up OBIA 11g with OBIEE 11G/12C Environment and with different ETL tools such as ODI & Informatica.
• Experience in developing Metadata Repository for Business Layer, Data Layer and Presentation layer using OBIEE Administration Tool.
• Extensive experience with OBI Answers, OBI Delivers, OBI Agents, and OBI Intelligent Dashboards.
• Experience in using WebLogic administration console to manage Security (Access & privileges) for Users & Groups.
• Extensive experience in using Oracle Enterprise Manager for providing administration support.
• Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
• Good Hands on experience in Customizing the Out of the Box OBIA Informatica & ODI Mappings.
• Experience in providing Production Support for OBIEE, Informatica/ODI and the Data warehouse Environments.
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Experienced in Data warehouse Administration Console DAC to Configure, Monitor and Schedule ETL routines of Full and Incremental ETL loads of the Oracle Business Analytics Warehouse.

PROFESSIONAL SKILLS:

BI Tools: Oracle Business Intelligence (OBIEE) 10g/11.1.1.X, 12c, OBIA, QlikView 12, Tableau 8.

ETL Tools: Informatica Power Center 9.X, ODI 11.1.1.X.1.

Operating Systems: Windows 2008/12, UNIX, RED HAT.

Databases: Oracle 11g,12c, SQL Server 2008/2012.

ERP Data warehouses: E Business Suite 12.1.X, PeopleSoft 9.X, JDE 9.X

Data Modeling Tools: MS Visio, ERWIN, Toad.

Languages: SQL, PL/SQL, C, C++, HTML, XML, Jscript.

Other Tools: TOAD, MS Project/MS Office, DAC, Visual Studio2012, JIRA, RTC, ALM

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, FL

ODI/OBIEE Lead

Responsibilities:

• Involved in leading the implementation of Supply Chain & Procurement and Spend Analytics for Confidential .
• Leading the ETL Implementation for Supply Chain & Procurement modules and guiding team members on the same.
• Involved in closely working with the functional users in getting the requirements and Lead the team on the design/development of OBIEE Dashboards.
• Lead the upgrade project for Supply Chain & Procurement modules from OBIA 7.9.6 to OBIA 11.1.1.9.1.
• Involved in working with Peoplesoft 9.2 as a source for our project implementation and OBIEE 12c for our reporting needs and ODI 11g for our ETL needs.
• Extensively worked on Oracle Data Integrator 11g components such as Designer, Operator, Topology and Security.
• Used Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experience in customizing ODI Knowledge Modules to handle complex data requirements.
• Extensively worked on Topology Navigator for developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Involved in creating Slowly Changing Dimensions and Implemented Changed Data Capture (CDC) & setup incremental Fact’s & Dimension’s.
• Involved in performance tuning of ODI Interfaces.
• Involved in setting up Load Plans, Scheduling of Load Plans and debugging errors in case of any issues during the run.
• Involved in Reverse Engineering to Import Tables & Views from the Oracle Data Warehouse.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing tables and running explain plans to check cost.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Involved in the Identifying gaps & preparing technical design documents based on business needs and functional design documents.
• Developed highly formatted OBIEE/BI Publisher Dashboards with different kinds of Graphs and Pivot tables to satisfy business needs.
• Worked with OBIEE Action Links & Master - Detail functions to implement Drill down functionality and Interactive Dashboards.
• Created different kinds of Procurement and Inventory Dashboards to help the business to visualize their data and make smart decisions.
• Created new Logical Columns, Hierarchies and used various Time Series Functions to create different measures.
• Embedded Hyperlinks using Invoke to Browser Script functionality which connects our OBIEE Reports to Peoplesoft system.
• Worked on the RPD to create new Subject Areas and customizing Out of the box ones as per business needs.
• Gained knowledge on Oracle Analytics Cloud services and did a POC on Oracle Data Visualization Cloud Service (DVCS) & Oracle Business Intelligence Cloud Service (BICS).
• Responsible for Administration & Security Privileges in OBIEE environments.
• Worked on defining row level security & object level security in the OBIEE RPD.
• Involved in identifying risks and leading the decision-making strategy to fix it.

Environment: OBIEE 11.1.1.7/12 c, Oracle 11g, OBIA 796/11.1.1.9.1 , Informatica 9, ODI 11g, Peoplesoft 9.2

Confidential, Rochester, NY

ODI/OBIEE Lead

Responsibilities:

• Involved in Complete SDLC life cycle of the Project including Requirement Gathering, Analysis, Design, Development, and Testing & Migration.
• Involved in the preparing technical design documents based on business needs and functional design documents.
• Gained insight on company’s financial reporting strategy’s and developed/designed Business Intelligence solution for Finance based on the needs and requirements.
• Lead the OBIA implementation for HR Analytics & Financial Analytics.
• Lead the ETL Implementation for HR and Financial Analytics.
• Lead the Design & development of OBIEE Dashboards.
• Developed several Interfaces, Packages, Procedures and Scenarios in ODI 11g.
• Used ODI for Reverse engineering to retrieve metadata and load it to the ODI repository.
• Involved in creating Yellow Interfaces which are Reusable Objects for developing complex interfaces and implementing sub queries in ODI 11g.
• Used different Knowledge Modules to setup interfaces to run full mode or incremental and loaded the same into Oracle Datawarehouse.
• Expensively set up Full Loads and Incremental Loads as needed and Monitoring the same.
• Involved in scheduling the scenarios to execute in serial/parallel modes according to the business needs for data.
• Experience in creating database objects (Tables, Views, Procedures and Functions etc.).
• Wrote PLSQL Scripts to create store procedures and adding them to Load Plans for daily runs.
• Heavily worked on fine-tuning complex ODI processes for better performance.
• Responsible for migrating ODI code (Scenarios, Projects, Models, Topology connections) across different environments.
• Involved in writing SQL queries for Data Analysis & Validation.
• Worked on Financial Analytics Modules such as General Ledger, Profitability, Account Payables and Receivables. The Reports/Dashboards 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.
• Worked on HR Analytics Modules such as Absence, Compensation, Human Resource Performance, Workforce Development, and Recruitment. The Reports & Dashboards were built to provide strategic workforce Performance Information and to determine key factors that drive Employment Productivity.
• Lead the efforts and Implemented best practices while designing the OBIEE RPD.
• Responsible for leading & managing the entire data warehouse for HR & Financial Analytics.
• Created highly formatted pre- built reports with BI - Publisher.
• Performed Performance Tuning of OBIEE Dashboards / Reports.

Environment: OBIEE 11.1.1.7.1 , Oracle 11g, OBIA 11.1.1.7.1 , ODI 11g, Oracle EBS 12

Confidential, Columbus, OH

ODI/OBIEE Developer

Responsibilities:

• Involved in the setting up OBIA 11.1.1.7.1 environment and upgrading OBIA 796 to OBIA 11.1.1.7.1 .
• Involved in Development, Enhance and Support of the HR Analytics Modules using Peoplesoft 9.1 as source system.
• Involved in solving the BI defects that came across on HR Analytics Reporting Side and providing a best possible solution in solving it and documenting the same.
• Involved in having direct communicating with Business Users on the Problems and new enhancements in BI space of HR.
• Involved in working on ODI 11g to customize and/or build new ETL solutions for HR Analytics.
• Created various Sources, Targets, and interfaces using ODI Designer and created several packages, procedures and generated scenarios.
• Used ODI to load data from Oracle 11g and flat files.
• Created a Physical, logical schemas and Contexts for ETL process.
• Worked on customizing ODI Knowledge Modules (IKM, LKM etc.).
• Extensively worked on configuring ODI Agent on Unix server and creating new Agents as needed.
• Involved in writing complex PL/SQL & SQL queries for several data related activities.
• Involved in Configuration & Development of Repository including Physical layer, Business Model Layer and Presentation Layer.
• Worked intensively on HR Analytics Modules such as Workforce Profile, Recruitment and Compensation and developed Reports such as Headcount, Turnover, HR Performance, Open Positions Report, Absence Ratio Reports, and Absence Trends etc. and build corresponding Dashboards.
• Extensively used different types Variables which includes Repository Variables, Presentation variables and Session Variables.
• Implemented Row level Security, Column level Security on Subject Areas and implemented Security for Users, Application Roles, Reports, Dashboards.
• Involved in Migration Process of Repository and Web Catalog to different Environments.
• Involved in preparing Technical Design Documents.

Environment: OBIEE 11.1.1.7.1 , Oracle 11g, ODI 11.1.1.7.1 , OBIA 796/11.X, PeopleSoft 9.1.

Confidential, Houston, TX

OBIA Developer

Responsibilities:

• Involved in designing & creating new Business Model & Subject Areas in the RPD according to business rules.
• Performed Performance Tuning of Dashboards / Reports /Charts by aggregate navigation, cache management, Aliases and Oracle materialized views.
• Involved in creation of Level Based Hierarchy & Parent child Hierarchy to meet business requirements.
• Managed security privileges for each subject area and dashboards according to user/Roles requirement.
• Involved in Migration of Repository, Catalog from Development to Test & Production Environments.
• Developed different kinds of Reports (Pivots, Graphs, Tabular) using global and local Filters.
• Worked on Initialization blocks, repository and session variables.
• Applied Optimization Techniques for the better performance of the reports.
• Extensively used SQL Tuning to improve performance.
• Worked with various Informatica transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Involved in applying best practice and Performance tuning the mappings by using SQL Override, session override, Lookups, Caching, & many more.
• Extensively used Sorter and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Created Connected and Unconnected lookup transformation for better performance.

Environment: OBIEE 11.1.1.7, Oracle 11g, OBIA 7.9.6.3, Informatica Power Center 9.0.1, DAC 10.1.3.4, Peoplesoft 9.1

Confidential, Pittsburgh, PA

OBIA Developer

Responsibilities:

• Involved in Complete life cycle of the Project including Requirement Gathering, Analysis, Design, Development, and Testing & Migration.
• Involved in Checking & Validation of Sources and Targets.
• Worked intensively on Supply chain Modules which include Inventory, Order Fulfillment & Order Management to develop reports which has Inventory Information on Summary & Detail level.
• Worked intensively on Sales Analytics Modules such as Customers, Demand Generations, Effectiveness, and Competitors to develop Reports which include Customer Sales, Product Sales, and Revenue & Growth.
• Involved in the Creation of Sales & Financial Reports, Dashboards using Pre-Built OBI APPS 7.9.6.3 using JD Edwards 9.0 as Source and by applying various business rules & logics using OBIEE Answers.
• Extensively used different types Variables which includes Repository Variables, Presentation variables and Session Variables.
• Implemented Dimension Hierarchies which includes Level based hierarchies (Ragged, Skipped) & Value Based Hierarchy (Parent-Child) to meet business requirements.
• Involved in Creation of High-level Interactive Dashboards Using Pivot Tables, Graphs and Prompts.
• Involved in Implementing High Level User Interface Reports using BI -Publisher.
• Involved in Implementing Usage Tracking to keep track of Users logging in and logging out.
• Extensively involved in Creating & Implementing Aggregate tables, YAGO fact Alias tables, Role Playing Dimensions and Caching Phenomenon to improve performance.
• Involved in Creating, Running & Monitoring ETL loads including Incremental and Full loads using DAC 10.1.3.4.
• Involved in Customizing Out of the Box Informatica Mappings to pull in new columns from source JD Edwards 9.0 that did not exist and that were useful to business & fine-tuning the mappings.
• Created new SCD Type 1/Type 2 Mappings to load new Fact Tables into our Data-Warehouse which are coming from source JD Edwards 9.0 using Informatica Power Center 9.0.1.
• Involved in Debugging of ETL Loads in DAC when they get failed and fine tuning it.
• Involved in Debugging of Mappings whenever necessary to identify problems during ETL run.
• Responsible for managing the entire Dare Warehouse.
• Involved in creating Re-useable Worklets & Mapplets across different mappings & Workflows.
• Involved in writing complex SQL queries in Toad for Data Analysis & Validation.
• Involved in Developing Mappings & Workflows to load the Past 3 yrs. Sales History Data flat files into the Warehouse and build Reports using that data.

Environment: OBIEE 11.1.1.5, Oracle 11g, OBIA 7.9.6.3, Informatica Power Center 9.0.1, DAC 10.1.3.4, JD Edwards 9.0

Confidential, Buffalo, NY

OBIA Developer

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 Financial Analytics modules and created the Ad-hoc report according to the Business needs.
• Involved In performing full loads using Informatica 9.0.1 & DAC 10.1.3.4 using EBS as a source system and loaded the Financial Analytics data into the Datawarehouse.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, and Oracle materialized views and making changes to reports.
• Performed Full and Incremental loads through DAC on different environments.
• Developed different kinds of Reports (Pivots, Graphs, Tabular) using global and local Filters.
• Created highly formatted pre- built reports with BI - Publisher.
• Extensively worked in Configuring & fine-tuning the Out of the Box Informatica Mappings.
• Involved in Creating new SDE & SIL Facts and Dimensions tables to load external data and to bring and loading in Company's customized tables from EBS into the Data warehouse Environment.
• Involved in Performance tuning of the Mappings, Sessions and Solving issues that run into error and monitoring the ETL loads using the DAC Scheduler.
• Involved in Creating new tasks, Subject Areas and Execution plan in DAC for the new Mappings that were built.
• Implemented Slowly Changing Dimensions Type 2 to create new Fact's & Dimension's.
• Created Custom Mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target tables.

Environment: OBIEE 11.1.1.3, Oracle 11g, OBIA 7.9.6.2, Informatica Power Center 9.0.1, DAC 10.1.3.4, E Business Suite 12.2