Shiva Kumar

408-***-****

Email:-abhaeu@r.postjobfree.com

Summary:

. Over 8 years of professional experience as OBIEE Consultant and

Consultant in Oracle E-Business Suite Applications with expertise in

Order Management OM, Purchasing PO, Inventory INV, Bill of Material BOM,

Work in Process WIP General ledger GL, Account Payables AP and Account

Receivables AR.

. Nearly 5 years of experience in OBIEE (Siebel 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

. 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/11g 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.

Education:

B.Sc in computer engineering India.

Technical Skills:

Oracle Oracle E-Business Suite R12/11i (Order Management,

Applications Inventory, Purchase Order, General Ledger,

Accounts Receivables, Accounts Payables, Bill of

Material, Work in Process)

Application Tools OBIEE 10.1.3.4.1/11g, Siebel Analytics 7.x,

OBIA/BI APPS 7.9.6/7.9.5, Toad, SQL Navigator 4.5,

SQL*Plus, SQL*Loader, UTL_FILE, XML Publisher

5.6.3/5.6.2,BI Publisher 10.1.3.4.1/11g and Oracle

Developer Suite

ETL Tools Informatica 8.x/7.x/6.x

Databases Oracle 8i /9i/10g, MS SQL Server 2000/2005/2008

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

Web Technologies HTML, JAVASCRIPT, ASP and PHP

Operating System UNIX, Linux (Red hat enterprise) and WINDOWS

98/2000/NT/XP/VISTA

Professional Experience :

METLIFE,Tampa, FL Sep'

2010 - Till Date

OBIEE Consultant

. 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: Oracle EBS R12 (General Ledger GL, Account Payables AP,

Account Receivables AR, Inventory INV, Purchasing PO, Order Management

OM), Oracle 10g, TOAD, PL/SQL, OBIEE 10.1.3.4.1/11g, 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.

PRIDE MOBILITY,Philadelphia.PA

Mar'2010 - Aug' 2010

OBIEE Consultant

. Responsibilities:

. 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 monito 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.

Progressive Insurance, MA

Mar' 09 - Feb '10

BI APPS Consultant

The Case Management Analytics solution will enhance decision-making process

regarding Operation Enhancements. The system will allow Customer Relation

Management Team to perform data analysis and track the solutions provided

to subscribers.

Responsibilities:

. 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

Home Depot, Atlanta, GA Sep

'08 - Feb'09

OBIEE Application Architecture Consultant

The goal of this project is to implement a data mart as a single

repository for Enterprise wide data and enhance business processes to

capture sales, marketing, and finance data to enable reporting. The DM is

a consolidation of different sales reporting systems and provides

Multidimensional Reporting of Opportunity, Quote, Order Bookings, and

Forecast and Goal, Invoice, Backlog, and Shipment data for the Sales,

Marketing, and Finance Organization. The Reports were developed to cater

the needs of all levels of organization, from Executives & VP's

(Analytical) to Sales Representatives (Operational).

Responsibilities

. 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

. 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.

. Created repository, session variables, and initialization blocks for

security and dynamic time periods.

. Set Aggregate Navigation for all aggregate fact tables in the BMM layer.

. 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.

. Implemented Security by creating roles, web groups, and external tables.

. 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

Functional Area: Sales and Marketing, and Finance

Whirlpool Corporation,

MI

Nov '07 - Aug '08

OBIEE Consultant

Competitive Marketplace Insight enables more effective decisions that drive

profitable market share growth through simple, accurate, timely access to

marketplace intelligence data for all levels and functions at whirlpool and

for our trade customers.

Responsibilities:

. Involved in translating business requirements into logical business

dimensional model

. Performed GAP Analysis between the 'AS-IS' process and 'TO-BE' process

. Involved in converting business requirements into Functional

Specifications and Technical Specifications

. Responsible for creating a prototype

. Mapping of data sources using OBIEE Admin tool to create repository

. Installation of Siebel Servers and Web Servers

. worked in implementing SSO using Siebel

. Experience with Server and component monitoring etc

. Worked on development of OBIEE RPD - Physical, Business Model and Mapping

and Presentation Layer, configured metadata objects (Subject Area, Table,

Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)

. Created Drill Down Hierarchies and implemented Level Based Measures,

Cache Management, and Performance Tuning using Aggregate tables in OBIEE

Business Model Layer

. Created Session and Repository Variables and Initialization Blocks for

desired functionality

. Created Groups/Users and set up Security using LDAP Authentication

. Created Pivot Tables, Pie charts, Column/Bar Charts, View Selectors,

Narrative Views, and Column Selectors in OBIEE environment.

. Migrate and Deploy of RPD and Webcat in Development, Test, and Production

Servers

. Worked on Siebel Answers to build Interactive Dashboards with drill-down

capabilities, Dashboard/Page Prompts

. Created i-BOT's using OBIEE Delivers and scheduled daily and weekly

reports

. Responsible for RPD and Webcat back up process.

. Designed and developed the ETL Mappings for the source systems

(Relational, Flat Files, and Excel) data extractions, data

transformations, data staging, movement and aggregation

. Performed data manipulations using various Informatica Transformations

like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy

. Extensively worked on performance tuning of Informatica mappings

. Involved in Migration, UAT, Go-Live, and Production Support

Environment: OBIEE, Informatica PowerCenter 7.x, Oracle 9i/10g, LINUX

Functional Area: Marketing

Empire Today, Northlake, IL

Sep '06 - Oct '07

Informatica Siebel Analytics Consultant

Empire Today is America's largest home improvement and furnishing

company. The Process Improvement project provides Empire Payroll and

Administration with Siebel Analytics/OBIEE reports regarding their

installers and sales representatives.

Responsibilities:

. Worked with functional and technical project leads, marketing, sales,

finance and administration, and other business groups to identify,

analyze, and document Business requirements.

. Identified and worked with various application areas in identifying,

analyzing, and documenting various information sources solutions to meet

the business requirements. Related data sources were derived from Siebel

CRM as well as numerous enterprise applications, retail and supply chain

systems.

. Installation of OBIEE on Development, Stage, and Production Servers

. Worked extensively on Siebel Analytics applications (Siebel Answers,

Delivers, and Dashboards).

. Ability to perform Server and component tuning, optimization

. Created Dashboards by embedding reports and providing intuitive

drilldowns and links to exploit the full benefit of Analytics.

. Created various reports using Column Selector, View Selector, Pivot View,

Chart View, and Guided Navigation

. Involved in design and development of repository (Creating / Modifying

objects in Physical, Business and Presentation layer) and the process of

repository migration.

. Migration and Deployment of OBIEE in Development and Production Servers

. Used ETL processes to accommodate changes in source systems and new

requirements.

. Development of many complex Informatica mappings and mapplets to build

key interfaces using transformations and reusable transformation units

(Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for

loading data into Data Warehouse.

. Used Workflow Manager for Creating, Validating, Testing and running the

sequential and concurrent Sessions and scheduled them to run at specified

time with required frequency. Used Workflow Monitor to monitor the

performance of the Jobs.

. Created and maintained metadata and ETL documentation that support

business rules and detailed source to target data mappings.

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x, Oracle 9i,

UNIX

Functional Area: Finance

GreenPoint Mortgage, CA

Jul '05 - Aug '06

Sr. Siebel Analytics Consultant

SmartWorks is implemented for measuring the performance of GreenPoint

resources by providing interactive Dashboard access to strategic business

information from the company-wide data warehouse with analytical

information.

Responsibilities:

. Interacted with functional & technical leads, SME's, sales and marketing

teams, and other business groups to identify, analyze, and document

business requirements.

. Designed and implemented custom business intelligence solutions (Metadata

and Dashboards/Reports) using the Siebel Analytics platform

. Developed of Metadata Repository (.rpd) with multiple business layers

using complex joins, presentation catalogs with access validations and

external table security repository and repository migration.

. Designed and developed many Smart Works Dashboards/Reports that are

Dynamic & Interactive with intuitive drilldowns, drill-across & flash-

based drillable charts (bar-charts, pie-charts, radars, and bubble-

charts), Capabilities split reports for summary & details information,

and local & global filters and cache monitor using Siebel Analytical Web.

. Performed the Security management for users, groups and web-groups using

the various authentication systems.

. Enhance performance by requesting Aggregate tables, Indexes and managing

Cache after Benchmarking performance tuning strategies with business

model-level calculations versus database level pre-computations and

aggregations.

Environment: Siebel Analytics 7.x, Oracle 9i, Sun Solaris

Functional Area: Sales and Marketing

Countrywide, CA Apr '04 - Jun '05

Siebel Analytics Consultant

The Siebel Analytics BI Platform Solutions was implemented for providing

interactive Dashboard access to strategic business information from the

company-wide data warehouse analytical information assets in retail

finance at Countrywide a nation-wide leading financial services company.

Responsibilities:

. Design and development of repository (Creating / Modifying objects in

Physical, Business and Presentation layer) and the process of repository

migration

. Development of interactive flash-based drillable charts such as bar-

charts, pie-charts, radars, bubble-charts, etc

. Implementation of Siebel Delivers using iBots for delivery of reports

through email, hand-held devices and mobile phones

. Security management for users, groups and web-groups using the various

authentication systems such as LDAP, OS, Database and External table

authentication using Session Variable features, as well as Dashboard /

Report-level security

. Analytics Application Response-time Performance management using

optimization efforts such as aggregate navigation, indexes and Oracle

materialized views

. Implementation of criteria filters to narrow-down the result set from the

analytics requests

. Developed/Bench-Marked performance tuning strategies with business model-

level calculations versus Data warehouse level pre-computations and

aggregations

. Developed and executed test plans and played an active role in product

rollouts

. Life-cycle support for migration efforts from development to QA to

production analytics

. Involvement with ETL (Extract-Transform-Load) development team to

communicate the specification for the required dimensional, aggregate and

indexed data tables

. Development of many complex Informatica mappings and mapplets to build

key interfaces using transformations and reusable transformation units

(Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for

loading data into Data Warehouse

Environment: Siebel Analytics 7.7, Informatica PowerCenter 6.x,

Oracle 9i, Sun Solaris

Functional Area: Finance

BellSouth, GA

Dec '02 - Mar' 04

Informatica Consultant

BBIS

Bellsouth Broadband and Internet Services (BBIS) Datamart is

implemented to analyze the usage metrics and also to measure performance

of customer operations.

Responsibilities:

. Designed, developed and documented multiple interfaces using the

Informatica Power Center.

. Developed many complex Informatica mappings and mapplets to build key

interfaces using transformations & reusable transformations (Source

Qualifier, Joiner transformation, Update Strategy, Lookup transformation,

Rank Transformations, Expressions, Aggregator) for loading the data into

Data Warehouse.

. Optimal utilization of object-reusability features like reusable

transformations, mapplets, copying objects from other repositories, using

variable/parameters for simplifying complex mappings.

. Performance Tuning of Informatica data warehouse loads, including

Informatica Server Manager and PL/SQL procedures.

. Designed and Developed many Shell Scripts for pulling data from remote

machines, session using Cron, Backup/Migration of metadata from version,

development and production, FTP, untar & sending files to source

directory, managing sessions files in the server directory.

Environment: Informatica PowerCenter 5.x/6.x, Oracle 8i/9i, HP UNIX.

Contact this candidate