Praveen Kumar Kallakunta

SAPBW BOBJ HANA Consultant

Email: acog8j@r.postjobfree.com

Phone: 732-***-****

Professional Summary:

> SAP Consultant around 10 years of experience in SAP BW/BI, SAP BO, SAP

HANA and Integrated Planning.

> More than 6 Years of Implementation experience architecting BW

solution with four full life cycle implementations for different

ERP modules Finance and Controlling(FICO), Sales and distribution(SD),

Material Management(MM),Purchasing, Production

Planning(PP)/Manufacturing, CRM, Finance-Special Purpose Ledger(FISL),

HR in SAP BI/BW.

> Worked on BW versions 3.5, 7.0, 7.3 BO Versions 3.1, 4.0,4.1 SAP HANA

1.0

> Worked on SAP BW ON HANA (BW Migration to HANA database).

> Involved in all phases like Gap analysis, Blue Printing, Realization,

Data extraction, Data modelling, Data loading, Production Support,

Testing, Documentation, Requirement analysis, End user documentation,

Reporting and Go-Live Check.

> Conducted workshops with the teams to identify the KPI's

> Experience in working on Retail data sources with AFS.

> Worked extensively on production support activities like Process chain

monitoring, resolving data load failures based on the priority in the

ticketing tool, solving the report issues by interacting with the

client.

> Upgrade Experience in SAP BW from 3.5 to BI 7.x and in depth knowledge

of migrating data sources from BW 3.5 to BI 7.x.

> Extensively worked on backend and frontend testing of BW and BO

objects after the upgrade

> Worked extensively on Business content Activation.

> Experience with complex transforms, multi-source data flows, data

workflows, parameterized data flows, embedded data flows

> Extensively worked in SAP BW Data modeling of Info Cube, Multi

Provider, Virtual Provider, DSO, Info Objects, Data source, Info

sources, Transformation & DTP, Process Chains, Aggregates, Info sets,

Open Hub Destination (OHD), APD, SPO, and Composite providers.

> Experience with Modeling, ETL, Reporting with BW and BOBJ Reporting

> Experience in working on BW dataflow using LSA architecture.

> Designed the Business Data Flows with SAP BW LSA++ Architecture using

Composite Providers, Virtual Providers, HANA-Optimized Info Cubes &

DSOs, and Data Sources for the SAP BW on HANA DB Scenarios.

> Expertise in ECC Data Dictionary, ABAP/4 reporting (Classical and

Interactive ALV's), Object Oriented ABAP reporting (ABAP Objects), SAP

Application Extractors like BADI's and BAPI's.

> Worked on ABAP/4 code in writing routines (start routines, End

Routines and expert routines) to update characteristics and key

figures in the Info Cubes.

> Worked on creating Lookups to update data into DSO.

> Worked on Data Extraction from SAP Application Extractors/SAP ECC

(FI/CO, MM, SD, and CRM), flat files and BW using extractors such as

LO Cockpit, CO-PA, FI and Generic Extractors.

> Worked on loading data into OHD(Open Hub destination) and extracted

data using SSIS for analysis in SQL Server Analysis Services.

> Working Experience on Data source Enhancements with User Exits,

BADI's.

> Experience with Reconciliation techniques with ECC and other source

systems and troublehooting

> Expertise in reports generation using front-end Business Warehouse

components (BEx Analyzer, Query Designer, Web Application Designer,

Web Reports, WEBI, and Dash Boards) for Queries, workbooks, Calculated

Key Figures, Restricted Key Figures, Structures, Variables,

Exceptions, Conditions, Ad-hoc Queries and Web application designer.

> Worked on creating user exits for customer exit variables.

> Proficient in performance tuning techniques which involves the

evaluation of statistical performance, data load improvisation an/d

query performance using compression, aggregates and partitioning

techniques, OLAP cache/BW.

> Worked on Universe Designer tool and Information design Tool on

relational data sources and BEX

> Excellent at Advanced SQL skills like Sub queries, Inner Joins, outer

Joins writing Complex queries in RDBMS databases like Oracle Database

R12 and SQL Server.

> Experience in Business Objects reporting tools WEB Intelligence,

Xcelsius, Crystal Reports, Analysis for office, Visualization tools

like SAP design studio, Explorer

> Experience on creating Universes, WEBI reports on different sources

like Universe, Bex reports and giving access to Enterprise portal.

> Worked on SAP Business Objects Enterprise Administration like Central

Management Console (CMC), InfoView, Import Wizard

> Good at performance tuning Bex and WEBI reports.

> Experience in creating dash boards using Xcelsius and Dashboard

Builder.

> Experience using Open hub service extracted Data from BI and

transferred to other Systems.

> Good skills in dealing with production support issues, which involved

debugging of data loads, update routines and transfer routines,

process chains and monitoring and scheduling data loads.

> Worked on Integrated planning Real Time Info cubes, Real Time DSO's.

> Worked on Planning Modeler (RSPLAN), Create Info provider, Aggregation

Level, Planning Functions, Filters, Planning Sequences.

> Developed fox code for formulas of complex development requirements.

> Worked on Test management like creating the test cases for BI reports

during Unit testing, integration testing and User acceptance testing,

uploading the test cases to HPQC, running the test scripts, raising the

defects in HPQC.

> Worked on testing of Bex and BO reports of different functional

modules.

> Worked extensively in transporting activities using solution manager.

SAP HANA SKILLSET:

> Gather requirements from Business and translate Business and functional

requirements to Data Mapping document.

> Design and develop ER model and DIMENSIONAL Model

> Developed the Attribute Views based on Master Data Tables in the SAP

ECC.

> Used filters for data to minimize the data and increase the

performance.

> Created Variables for applying filter values at Runtime.

> Created calculated columns in analytic Views in Attribute Views

> Created the Analytic Views based on the Info cube models in SAP BW/BI

system.

> Worked with Calculation Views for master and Transaction Data.

> Created the Graphical Calculation Views by including the analytic views

using Unions, Projections and Joins based on the business logic.

> Created calculation views using SQL Script and Aggregations.

> Design and Define HANA VIEWS Data Flow for ER MODEL

> Design and develop HANA VIEWS for Modeling

> Code review and provide suggestions

> Used CE Functions for reading the data of information Views.

> Developed the Analytic privilege for end user security based on the

current BW Models.

> Created Decision for implementing for implementing business rules and

for performing what - if analysis.

> Used Data replication Techniques DXC,SLT and ETL BASED via BODS.

> Experience in SAP's Business Objects Data Services, BODS admin console.

> Experience in BODS designer, job and server manager tools

> Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs)

on the BW on HANA database Scenarios and imported them to the HANA

studio tool.

> Involved in importing the BW models from SAP BW system (using HANA DB)

to the HANA Studio.

> Code Deployments in Production

> Performance Tuning data models

> Imported and exported the HANA Models from development to Production

system using Delivery Units.

> Worked on assigning Analytic Privileges to Views in HANA

> Exposure to BODS and SQL Script Tool.

> Used the Eclipse Based Process Chain Monitoring via HANA Studio

> Published HANA Models into BW As Transient Providers

> Leveraged BW Analysis Authorization For HANA Models

> Used HANA Analysis Process and Open ODS View

Professional Experience:

Client: Coke, Georgia, USA

Oct 2013 to Till Date

Role: SAP BW and BO Consultant

Environment: SAP BW 7.3, BO 4.1, HANA 1.0

Responsibilities:

. Worked on BW Upgrade from BW 7.0 to BW 7.3.

. Worked on Test management like creating the test cases for BI reports

during Unit testing, integration testing and User acceptance testing,

uploading the test cases to HPQC, running the test scripts, raising

the defects in HPQC.

. Preparing the technical design documents from understanding the

Business process and the Functional Design.

. Worked on extracting data from SD, MM, FI, COPA applications.

. Involved in Activating the Business Content Data Sources, Generating

the Data Source.

. Developed BI customized objects like Info Objects, DSOs, Cubes, Multi

providers, Process chains.

. Created Transformation's, DTP's between data targets with Start

routines, End routines and field level routines.

. Worked BEX Report using CKF, RKF, Formulas, selections, Structures,

Variables as per the reporting requirement.

. Worked on creating reports using WEBI on BEX reports

. Created Dashboards using Xcelsius.

. Created Direct process chains and Meta chains for all Master data

attribute, Master data Text and Transaction data loads.

. Worked extensively with the Transportation activities.

. Working in resolving the issues during data loads, Unit testing and

SIT of the build objects and in fixing bugs.

. Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on

the BW on HANA database Scenarios and imported them to the HANA studio

tool.

. Involved in migration of SAP BW cubes and DSO's to In-Memory Cubes and

DSOs.

. Designed the Business Data Flows with SAP BW LSA++ Architecture using

Composite Providers, Virtual Providers, HANA-Optimized Info Cubes & DSOs,

and Data Sources for the SAP BW on HANA DB Scenarios.

. Replicated Master data and Transaction Data Tables Using SLT from SAP ECC

to HANA.

. Involved in importing the BW models from SAP BW system (using HANA DB) to

the HANA Studio.

. Created Information Models-Attribute Views, Analytic Views, Calculation

Views, Scripted Views on COPA tables imported from ECC.

Client: Ralph Lauren-Polo, New York, USA

Sep 2012 to Oct 2013

Role: SAP BW and BO Consultant

Environment: SAP BW 7.3 and BO 4.0

Responsibilities:

. Understanding the Functional designs by interacting with the Client.

Collecting the requirements and report functionalities

. Involved in Activating the Business Content Data Sources, Generating

the Data Source.

. Enhanced the standard data sources to meet the requirement.

. Created Generic Data source using Table, View and Function Module.

. Worked on extracting data from ECC system and in modeling BI objects

to publish the data at Feed store side by using Open hubs.

. Preparing the technical design documents from understanding the

Business process and the Functional Design.

. Worked on extracting data from SD,MM,FI,COPA, Special Purpose Ledger,

applications

. Involved in Activating the Business Content Data Sources, Generating

the Data Source.

. Developed BI customized objects like Info Objects, DSOs, Cubes, Multi

providers, Process chains.

. Created Transformation's, DTP's between data targets with Start

routines, End routines and field level routines.

. Worked extensively on production support activities like Process chain

monitoring, resolving data load failures based on the priority in the

ticketing tool, solving the report issues by interacting with the

client

Client: Dr Pepper, New Jersey, USA

May 2011 to Sep 2012

Role: SAP BW and BO Consultant

Environment: SAP BW 7.0 and BO 4.0

Responsibilities:

. Collect the business requirements for Order to Cash, Procure to Pay

and Finance requirements.

. Done Prototyping on BI 7.0 and Webi 4.0 Functionality on test systems

to check the feasibility of reports and backed design

. Worked on Business content Activation.

. Worked on Creating MultiProvider, Virtual Provider, DSO, Info Objects,

SPO, Data source, Transformation & DTP, Process Chains, Open Hub

Destination (OHD), APD

. Worked on BW dataflow using LSA architecture.

. Collected Report requirements from Onsite and worked on Front end

Functional Designs from BEx and Webi point of view.

. Created some complex Webi reports in BO 4.0 Version to check on how to

apply measure values, MTD and YTD as input control.

. Created Webi report with Grid and Graph layout, applied element

linking and content linking in input controls, based on the user

selection from input control Graph and grid values will change.

. Worked on Front end Technical Designs, the reporting tool used for the

Front end is Business Objects-Web Intelligence.

. Worked on Back end technical designs, which includes Business Partner,

Customer Master, Territory master data from CRM and Sales from

Informatica.

. Worked on Interface TD's with Informatica as Source System.

Client: BASF, Denmark

Dec 2010 to May 2011

Role: SAP BW and IP Consultant.

Environment: SAP BW 7.0

Responsibilities:

. Understanding the Functional designs by interacting with the Client.

Collecting the requirements and report functionalities

. Involved in Activating the Business Content Data Sources, Generating

the Data Source.

. Enhanced the standard data sources to meet the requirement.

. Created Generic Data source using Table, View and Function Module.

. Created BEX queries as per the requirement.

. Worked on Planning Modeler (RSPLAN), Create Info provider, Aggregation

Level, Planning Functions, Filters, Planning Sequences.

. Developed fox code for formulas of complex development requirements.

. Worked on Test management like creating the test cases for BI reports

during Unit testing, integration testing and User acceptance testing.

Client: Carlsberg, Denmark

April 2010 to Dec 2010

Role: SAP BW Consultant.

Environment: SAP BW 7.0

Responsibilities:

. Understanding the Functional designs by interacting with the Client.

Collecting the requirements and report functionalities.

. Preparing the technical design documents from understanding the

business process and the Functional Design.

. Handling the Deliverables in specified timelines. Resolving the issues

and concerns in the team.

. Creating the objects as per the technical design documents and client

naming standards.

. Worked on Data Extraction from SAP ECC (FI/CO, MM, SD, and CRM), flat

files and BW using extractors such as LO Cockpit, CO-PA, FI and

Generic Extractors.

. Worked on Data source Enhancements with User Exits, BADI's.

. Created Queries, workbooks, Calculated Key Figures, Restricted Key

Figures, Structures, Variables, Exceptions, user exits for customer

exit variables.

Client: Hershey, Pennsylvania, USA

June 2009 to March 2010

Role: SAP BW and BO Consultant

Environment: SAP BW 7.0 and BO 3.1

Responsibilities:

. Lead the team from offshore and Involved in testing Phase apart from

doing development.

. Creating TD documents by understanding the FD documents shared by the

Client.

. Worked on Bex, WAD, and BO reports.

. Collecting all developed Queries into TRs and releasing them and

coordinating to get them transported to designated target systems.

. Testing of Bex Reports, Webi reports to check the data consistency

. Worked on Test management like creating the test cases for BI reports,

uploading the test cases to HPQC, running the test scripts, raising

the defects in HPQC.

. Worked on High priority defects as a Developer by coordinating with

the client.

Client: Whirlpool, Michigan, USA

Dec 2007 to June 2009

Role: SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

. Involved in total BW Application support from converting Business

requirement document into Functional specifications document,

technical specification document

. Interaction with Onshore and client team to discuss the Business

requirements.

. Worked on creating Info Cube, MultiProvider, Virtual Provider, DSO,

Info Objects, Data source, Transformation & DTP, Process Chains as per

the requirement

. Worked on Bex reporting tool and created the reports.

. Created test scripts for testing the objects

. Worked on testing of existing queries and updated them with new

changes as a part of standardization among all regions.

. Working on the defects raised by the users in QC tool.

. Worked extensively on production support activities like Process chain

monitoring, resolving data load failures based on the priority in the

ticketing tool, solving the report issues by interacting with the

client.

Client: Microsoft, Washington, USA

Jan 2006 to Nov 2007

Role: SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

. Implemented Project Washington and Project GTS in Microsoft.

. Involved in Activating the Business Content Data Sources, Generating

the Data Source.

. Enhanced the standard data sources to meet the requirement.

. Created Generic Data source using Table, View and Function Module.

. Worked on extracting data from ECC system and in modeling BI objects

to publish the data at Feed store side by using Open hubs.

. Worked on extracting data from GTS systems and in modeling BI objects

to provide the data for reporting through SSRS.

. Worked on loading data into OHD (Open Hub destination) and extracted

data using SSIS for analysis in SQL Server Analysis Services.

. Developed BI customized data targets like DSOs, Cubes, Multiproviders,

Process chains.

. Implemented Routines to meet the Requirement

. Created Direct process chains and Meta chains for all Master data

attribute, Master data Text and

. Transaction data loads.

. Scheduled the Process chains as per the client requested timings and

also resolved the upcoming issues during the Monitoring of Process

chains.

. Worked extensively with the Transportation activities.

. Working in resolving the issues during data loads, Unit testing and

SIT of the build objects and in fixing bugs.

Client: Project: Johnson & Johnson, New Jersey

Feb 2005 to Dec 2006

Role: SAP BW Consultant

Environment: SAP BW 3.5 and SAP BW 7.0

Responsibilities:

. Installed relevant SAP business content objects and enhanced them as

per requirement.

. Created Info objects, Info cubes, DSO's, Data Source and Multi Cubes.

. Created Transformations, DTP's between the Objects.

. Created Multiproviders for reconciliation.

. Created Queries, workbooks, Calculated Key Figures, Restricted Key

Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries

and Web application designer.

. Created Queries on Multi providers and Info cubes. Worked on Web

Application Designer.

. Designed process chains for Batch job scheduling of loads and Updating

data targets.

. Transported the objects in system landscape using Solution

Manager(SOLMAN)

. Solving performance-related issues by applying Partitioning,

Aggregates, and Compression

. Monitoring of BW loads through process chains and Solving load

failures during the data Loads.

Education:

> Bachelor In Technology(B.Tech)

Jawaharlal Technological University

Contact this candidate