Sales Data
Resume:
Shiva Kumar
Email:-******@*****.***
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