Pavan Kankanala

SAP BI/BW Consultant

Phone: 201-***-****

E Mail: abmrn5@r.postjobfree.com

Summary of Professional Experience

. 7 years of experience in SAP BI/BW with 2 full lifecycle implementations

and strong production support expertise.

. Exposure to BI 7.0, ECC 6.0, Netweaver2004s, BW versions: 3.5, 3.1c, 3.0b

and SAP R/3 versions: 4.6c, 4.7.

. Expertise in front-end Business Warehouse components for Queries,

Workbooks, Calculated Key Figures, Restricted Key Figures, Structures,

Variables, Exceptions, Conditions, Ad-hoc Queries, BEx Analyzer, Query

Designer, Web application designer(WAD), Information Broadcaster.

Extensively worked on Complex reports such as Trend reports, Reports on

Virtual Key figures, Dashboard/Cockpit reports, R/RI and iViews etc.

. Experience in designing, development Business Objects 3.1 universes,

reports and Xcelsius dashboards using SAP BI Integration kit.

. Excellent data warehouse modeling skills. Expertise in translating

business requirements into technical implementations supported by sound

data models.

. Good exposure to ASAP methodologies in all phases like gap analysis, blue-

printing, design specification, development, performance tuning, testing,

documentation, maintenance, training, security authorizations and trouble-

shooting.

. Prepared Functional Specification Documents, Technical Specification

Documents, user requirements documents and end user manual.

. Proficient in manipulating data in both BI/BW and R/3 and have used

combinations of standard BW functionalities and custom enhancements to

fulfill reporting requirements.

. Expertise in extracting data using LO Logistics Cockpit, CO-PA and

Generic DataSources from Views and Function Modules, DB connect and Flat

Files.

. Extracted data from HCM (Payroll, Time Management, PA), SCM (MM,

Purchasing), PLM (PM, QM, PS), WHM, SD, FI-CO, PP

. Experience in activating standard Business Content, extending and

enhancing InfoCubes according to the requirements, datasource

enhancements, user exit variables, virtual Key Figures, start routines

and formula builder.

. Excellent working knowledge of datawarehouse concepts and extensive

experience in BW Architecture, Extended Star-Schema, Multi Dimensional

Modeling, Data Flow Strategy, Defining Dimensions, InfoCube, Multi-

Provider, InfoSets, DataSource, InfoSource, InfoObjects, PSA and ODS

. Involved in design, creation, and monitoring of Process Chains and Event

Chains. Production support experience in handling batch jobs, load

failures, delta failures and system issues.

. Worked on Transports in SAP system Landscape. Experience with RealTech

Transport Manager.

. Excellent Communication and Interpersonal skills, Problem solving

abilities and effectiveness in working independently or as a team player.

Technical Skills

ERP ECC 6.0, 5.0, SAP R/3 4.7, 4.6c

Business BI 7.0, Netweaver2004s, BW 3.5, 3.1c

Intelligence

Programming SQL, PL/SQL, ABAP/4.

Languages

Databases Oracle 10g, DB2 V9, SQL server, MS Access, and

MS-SQL Server

Reporting Tools BEx Analyzer, WAD,MS Office, Business Objects

Scripting Languages XML, HTML, and VBScript

Protocols TCP/IP, FTP, SMTP, POP and HTTP

Operating Systems Windows 95, 98, 2000, XP, AND UNIX

Professional Experience

SAP BI Consultant (February 2008 -

January 2010)

Client: Kimberly Clark Corp., Appleton, WI

Kimberly-Clark is a leading global health and Hygiene Company with

operations in 37 countries and their brands sold in more than 150

countries. KC has a wide implementation of SAP applications and has several

BW & R/3 landscapes focusing on their business content at different

locations worldwide.

Environment: BI 7.0, R/3 4.6C, BEx 3.X & 7.X, DB2, Business Objects 3.1

ERA User Support & Small Enhancements Team

Responsibilities & Key Tasks performed:

. Evaluating the Requests submitted by the business, with domain leads, and

estimating the scope and effort required for the enhancement.

. Gather requirements from business users and communicating the impact of

the changes to the Domain leads. Implement the BI backend changes & new

developments.

. Investigating the reasons behind the data inconsistencies found by the

users between BI reports and R/3, & non SAP systems Essbase, Marble, M*

etc. Correct the identified issues either at the reporting end or the BI

backend end.

. Performed changes to the existing queries and reports and publish new

ones using the standard Fast Track publishing procedure.

. Worked on several COPA and CCA Cubes. i.e. data load monitoring and

consistency checking, uploaded Europe Data again from Source System and

tuned the load Performance.

. Worked on FI-AR Line Item InfoCubes (0FIAR_C03) and InfoSources

(0FI_AR_1, 0FI_AR_3) for loading the data from SAP R/3 and historical

data from flat files.

. Developed several interactive reports in FI-CO module, which included

reports to generate: advertising and promotion expenditure by cost

center, list all the reversed accounting documents, GL Balance Sheet.

. Created & documented Daily Sales - Product Detail, Pace to Financial

Forecast, Sales Trend - by Month/Week, Forecast Comparison reports as

part of Sales Reporting in the newly implemented OTC project.

. Trouble shooting the access issues & reporting errors experienced by the

users.

. Performed testing after applying new patches & support pack upgradation

in the development and Quality environments.

. Worked on the Front End Enablement project for migrating BEx 3.X queries

& workbooks to version BEx 7.X. Created analysis authorization objects to

be used for authorizations.

. Created analysis authorization objects to be used for authorizations.

. Used the attributes 0ORGUNIT, 0EMPGROUP, 0PERS_AREA of 0EMPLOYEE as part

of analysis authorization for HCM.

. Extensively worked on creating Customer Touch Management Profitability

reports.

. Enhanced 0MATERIAL to have new attributes with different EAN/UPC for

different base units. Sourced the data from 0MAT_UNIT.

. Resolved the data inconsistencies in stock values and amounts by

redesigning the Inventory reports.

. Enhanced 0CRM_SALES_ACT_1 data source to have new timestamp fields in

local time zone, sourcing the data from tables in CRM system.

. Installed Costs and Allocations & Project systems cubes on the European

Landscape.

. Added new key figures to the MidCycle and Operational Forecast cubes

sourcing the data from the HealthCare APO demand planning system. Created

Forecast Conformance & Summary queries and reports.

. Experience in BIA monitoring and administration tasks.

. Completed a POC using Business Objects 3.1 on top of SAP BI 7.1

. Worked with the BO architect in analyzing the existing authorization

objects & BI Analysis authorizations and coordinated with the BO admin

team in setting up single sign on.

. Identified the BEx data elements required for the BO Universe considering

the BOE supported features.

. Developed new BEx queries and created modified versions of existing

queries for use in BO universes.

. Experience with BO reporting tools including WebI and Universes.

. Designed and developed Xcelsius dashboards using Live Office and QAAWS

SAP BW Consultant (November 2006 -

January 2008)

Client: Southern California Edison (SCE), Los Angeles, CA

SCE provides electricity to the entire Southern California region with

about 500,000 customers. It is one of the biggest implementers of SAP in

the nation, which has gone through the big-bang approach of implementing

various modules of SAP simultaneously.

Environment: SAP BI7.0, ECC 6.0, Oracle 9i, BEx Analyzer, Windows NT.

Responsibilities

. Gathering Business Requirements from Users & Business Analysts for data

modeling.

. Identified the gaps and suggested necessary enhancements for some

transaction data and master data extractors.

. Drafted Final business requirement document and the requirements document

as per SAP best practices including the requirements matrix.

. Performed extractions from multiple source systems including SAP (using

LO, LIS, Generic extractors) and flat files.

. Used LO extract structures for extracting sales order, delivery-billing

information.

. Customizing of extract structures for MM and SD data sources like

2LIS_02_ITM, 2LIS_02_SCL, 2LIS_03_BF.

. Installed the material movements cubes 0IC_C01 & 0IC_C03 and slow moving

items cube 0IC_MC01.

. Worked extensively with payroll results from cluster, headcount and

Personnel actions Extractors and developed respective cubes &DSOs.

. Installed Time Sheet Data cubes & multiproviders 0CATS_C01, 0CATS_C02,

0CATS_MC1 in CATS.

. Installed Payroll and Personnel Time Management cubes 0PT_C01, PY_C02 &

0PY_MC02. Extracted Payroll data using the Payroll Datasources.

. Worked extensively on transfer rules, update rules and user exits for

transaction data.

. Creation of Info packages for schedule the data load process with Full

and Delta update mode. Created transformations and DTPs for the necessary

objects in development.

. Expertise in Reports Generation using BEx Analyzer in building Queries

and saving in Workbooks (Excel Work Sheets), creation of Custom Queries

using Conditions, Exceptions, Variables & Structures and created

aggregates for frequently used queries.

. Used RRI feature to jump between the Queries to analyze the data

efficiently.

. Worked extensively on administration workbench and Managed and Monitored

data loads with Full update and Delta mechanism.

. Handled performance tuning of queries using aggregates, table

partitioning, indexing of InfoCubes.

. Created Drill through queries from summarized InfoCube to detail DSO

data.

SAP BW Consultant (September 2004 - November

2006)

Client: Novellus Systems, Santa Clara, CA

Environment: SAP 4.6C, BW 3.5, Oracle 9i, Windows NT, Crystal Report.

Responsibilities

. Interacted at multiple levels in the Client's org., modeled requirements

to dimensions (both logical & physical), assess gap/fit with Business

Content to gauge enhancements.

. Designed & configured complete data model (Info objects/ Info sources /

Source systems / Data sources) and configured Info cube.

. Document the reporting needs of the business service and support

organization and distribute those requirements into a data warehouse

strategy resulting in both operational and analytical reporting.

. Extracted data using CO-PA (cost or account based) for analyzing the data

on various criteria/partitions like cost centers, companies, controlling

area, regions to compare cost of sales or overhead costs, product costs.

. Setting up customized InfoCubes with optimal star schema, InfoCube

partitioning for query performance. General ledger (0FIGL_C01), accounts

payable transaction data (0FIAP_C02), published key figures (0COPA_C01)

and quick start (0COPA_C03) is customized according to the client

requirement. ODS objects are created for data staging before InfoCube

loading.

. Worked on InfoSources for general ledger (0FI_GL_1), accounts payable

transaction data (0FI_AP_2), Profitability analysis quick start

(0CO_PA_3).

. Worked on FI-SCM integration to get Amounts Spent and Commitments on a

Purchase Order.

. Worked on Portraying Financial statements in two different reporting

timeframes.

. Worked on calculating cumulative balances for GL Accounts for a

particular fiscal year.

. Extensively involved in creating purchasing data, Material movements Info

Cubes.

. Customized Business Content InfoSources, InfoCubes and activated Business

Content to meet business requirements.

. Analyzed InfoCubes created and maintained aggregates to improve the

performance.

. Enhanced the Info cubes by adding custom InfoObjects to reflect modified

R/3 business process. Created Aggregates on info cubes in order to

generate reports and improve query performance

. Developed ODS and InfoCubes for sales and controlling areas like

procurement, cost center, order status and sales overview.

. Designed InfoSources, activated transfer and update rules, scripted

extraction routines using ABAP for master data, texts and hierarchies.

. Integrated Actuals Cube and Planning Cube for Cost Center variance

analysis report.

. Explored KPIs to define user reports and business dimensions.

. Created Transfer routines, Update routines and Start routines for data

update in BW.

. Created Drill through queries from summarized InfoCube to detail ODS

data.

. Transported InfoObjects, InfoCubes, Queries, update rules, Multi cubes

from Development to Quality.

. Worked extensively on BEx Query Designer. Developed flexible queries

using filters, navigational attributes in BEx Analyzer to facilitate data

analysis in a drill down or summarized way to give detailed levels of

information. Created reports with exceptions, conditional formatting,

restricted key figures and calculated key figures. Worked on currency

conversion as per the user requirements.

. Created web reports through report template in Web Application Designer.

. Provided End User training to help them utilize the BW Reporting tools

more effectively and efficiently.

SAP BW Consultant (August

2003 - July 2004)

Client: Jabil Circuits, St.Petersburg, FL

Environment: SAP 4.6B, BW 3.5, BW3.1c Oracle 9i, HP UNIX, BEx.

Responsibilities

. Participated as a team member in discussion with business analyst and end

user for data modeling, business content, granularity and performance

tuning.

. Interaction with the management and decision-makers to identify business

requirements and define project charter.

. Actively involved in identifying data sources based on end-user reporting

requirements, design and creation of extended star schema structures for

customized cubes from data extracted from different modules like SD, MM

and FI.

. Designed, developed and modified InfoObjects, InfoCubes, ODS Objects,

InfoSources, Transfer rules, Update rules to suit the business

requirements.

. Created MultiCube for specific queries of SD, Purchasing and FI.

Incorporated transfer rules for InfoCubes and customized update rules

using ABAP/4. Extended standard Business Contents based on client

requirements using User Exit and Function Module.

. Involved in creating MultiCubes, Infosets based on the requirements and

reporting on them using BEx.

. Extracted data from SAP R/3 using LO Cockpit, CO-PA, Generic, Business

Content Extractors and from flat files.

. Used Delta Update process for loading the data to BW from R/3 in specific

intervals. Used interface DB connect to get data from external sources.

. Populated the Info Objects, ODS Objects and InfoCubes with Master data

and Transactional data from SAP R/3 via Data Staging area (PSA) by

creating InfoPackages.

. Created Process chains for effective scheduling of various processes.

. Worked in Production support and handled batch jobs, load failures, delta

failures and system issues.

. Used RRI jump queries for drilling down to other queries and R/3

transactions.

. Involved actively in supporting the various issues addressed by the

Users.

. Extensively worked on Query designer for building queries, BEx Analyzer,

BEx browser for creating queries, calculated key figures, restricted key

figures and variables.

. Performed end user training sessions in reporting scenarios, and

documented the whole project

Education

Bachelor of Technology in Mechanical Engineering, JNTU, Hyderabad, India.

References

Available upon request.

Contact this candidate