Data Sap
Resume:
Praveen Kumar Kallakunta
SAPBW BOBJ HANA Consultant
Email: *******.***@*****.***
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