RAMBABU GADDE Mobile:- +91-8919978026

SAP BI/BW HANA Consultant E-mail:- rambabu.g.sap@gmail.com

Professional Summary
 Strong specialization with 9 Years of experience in SAP BI/BW and HANA, been part of THREE
Implementation projects covering SAP BI/BW and around 2.5 Years of Experience in ETL
tools SSIS and Talend build schemas in SQL server on top of schemas used Business Objects
(Only On relational data bases) flavors developed reports.
 Good experience of Life Cycle Implementation using SAP BW. Work expertise with the BW
system in Data Extraction, Modeling, Data Loading, Scheduling, Monitoring and Reporting
Environments.
 Experience on SAP HANA projects with both Native HANA, BW/4 HANA and SAP BW on
HANA Landscapes based on Agile Methodology. Experience in designing HANA models -
graphical calculation views using Union, Join, Projection & Aggregation nodes and having
good knowledge with SQL script.
 Experience in Data-Provisioning techniques using SAP Smart data Access (SDA) and Smart
data integration (SDI) from different sources such as ECC and BW Systems.
 Expertise in creating BW objects from HANA Studio such as Advanced DSO’s, Open ODS
Views Composite Providers, Transient providers and Virtual info providers and master data
objects.
 Created reports using Business Objects functionality’s like Queries, Drill Down, Cross Tab,
Variables, Break, Alerts, Dash Boards, Prompts Functions to meet the client requirements
 Experience in extracting data from LO cockpit data sources using various update methods
V1, V2 and v3 Delta Mechanism.
 Worked extensively in SAP BI specific to ECC - SD, MM, PP, QM, AR, AP and HR modules
 Created Queries used by SAP BEx Suite – Calculated Key figures, restricted key figures,
Variables, Formulas, Structures, Exceptions, Conditions, filters and free Characteristics;
Providing drill down functionality in reporting using BEx RRI
 Used delta update mechanisms for uploading data to BW from R/3 in specific intervals and
extensively used Process chain to load data to the data targets.
 Extensive experience interacting with business users, business owners for requirements
gathering, analyzing business process and making necessary changes to schema objects to
fulfill reporting needs.
 Extensively worked on transporting objects between SAP ECC system environments and
corresponding BW systems
 Good communicational skills being a team player with excellent interpersonal skills.

Technical Expertise
Languages : ABAP/4, C, C++
SAP : ECC 6.0, SAP HANA 2.0, S/4 HANA, BW4HANA, SAP BI/BW 7.X and 3.X
Reporting Tools : Lumira, Business Objects, BEx Reporting Tools and Hyperion IR
Other Tools : SSIS, Talend Open Studio 4.0
Database : HANA 2.0, Oracle 9.0, SQL Server 2008
Professional Experience

 Working as SAP BW/HANA Consultant in O2F, Hyderabad from FEB 2020 to June 2020
 Worked as a SAP BI Consultant in Capgemini, India from July 2019 to Jan 2020.
 Worked as a Consultant in Syntel, Pune from Feb 2018 to Jan 2019.
 Consultant with TekLink Software India Pvt Ltd., Hyderabad from March 2016 to Aug 2017
 Module Lead with Wipro InfoTech., Hyderabad from November 2012 to April 2015
 BI Consultant in Exxova Solutions Pvt. Ltd., Hyderabad from June 2009 to November 2012

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 1

  SAP Consultant for Infotech Enterprises Ltd., Hyderabad from July 2007 to June 2009
 SAP BW Consultant for Quinnox India, Bangalore from August 2005 to June 2007

Client Cepheid (BW On HANA and HANA Implementation)

Role SAP BW HANA Consultant
Duration Feb 2020 to Till Date
Team Size 5
Environment SAP BW on HANA 7.5 and ECC 6.0 EHP7 & HANA Modeling

Roles and Responsibilities:

 Created Composite Provider, Advanced DSO (ADSO) and Open ODS view using BW Modeling
Tool in HANA Studio
 Created the Virtual tables used by SDA connection and SLT Replication for ECC DB in HANA
and those tables are used in HANA modeling for different type of Views.
 Created different types of SQL Analytic Privilege (Attributes, SQL Editor and Dynamic) to
restrict views data at row level security by different users dynamically.
 Created by Calculation views used BW data base tables (DSO Active tables and Master data
tables) and used by calculated columns, restricted columns, variables and input parameters
and those views are consumed into composite provider and used in POWER BI users reports
 Created Service contract report in BW used by Billing, Revenue Reorganization, Bill Plan data
and Sales data.
 I have created by different test cases to test the functionality of HANA studio and BW system
after upgrade of BW on HANA 7.5 Version.

Client GE (BW/4 HANA ) and HANA Implementation

Role SAP BW HANA Consultant
Duration July 2019 to Jan 2020
Team Size 9
Environment ECC 6.0 and Native HANA Modeling and BW/4 HANA

Roles and Responsibilities:

 Created HANA views and use those Calculation views into composite provider and generate
reports on the Composite provider in HANA Studio
 Experience in BW Modeling tool in HANA studio and create Composite providers and ADSO’s
for different templates
 Created Calculation views used by the different tables with Projections, Joins, Unions and
Aggregation nodes and using Filters, Different type of Joins, Parameters and Variables
 Involved in testing comparing the existing Classic BW reports data with newly created
B/4HANA reports and fix issues reported by the users

Client ALLSTATE (BW Support) and HANA

Role SAP BI Consultant
Duration Feb 2018 to Jan 2019
Team Size 5
Environment Flat Files,ECC 6.0,BI 7.3, SAP BEx Analyzer and BEx Designer

Roles and Responsibilities:

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 2

  Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads
using PC’s and to scheduling the process of loading data in to data targets wherever
required.
 Created HANA modeling scenarios and activities such as adding a system, creating ADSO’s
and Open ODS Views, Composite providers and content models as different type of Views.
 Created the Virtual tables used SDA connection for data base schema in HANA and those
tables needs to do modification as per requirement with SDI and those tables are used by
HANA modeler Views.
 Created information objects in HANA under the content Package (Attribute Views, Analytic
Views and Calculation Views – Graphical and SQL Script Based)
 Preparing the daily status report which includes the data loads statistics and day wise trigger
chains list of complete and incomplete report to client.
 I have done reconcile ECC data with BW and identifying missing records from ECC and reload
the same data into BW using repair full loads in PSA then loads respective data targets.
 Involved in solving production support issues like load failures, Rollup, Indexes, change runs.
 Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
 Scheduling Attribute change run activity on checking the locks for Indexes creation/deletion
and rollup activities for the respective cubes.
 Executing OHD’s by changing the period and year selections as required and ensuring the
BW data files are successfully moved to downstream systems.

Client PHILIP MORRIS (ALTRIA Group Inc. (BW Support)) and Kellogg’s
Role SAP BI Consultant
Duration Mar 2016 to Aug 2017
Team Size 5
Environment ECC 6.0,BI 7.0, SAP BEx Analyzer, BEx Designer

Roles and Responsibilities:

 Created Advanced DSO and Open ODS Views used by these objects developed by Composite
providers and developed by reports as per the user requirement.
 Converting the flows Standard DSO's to ADSO's manually 2LIS_11_VAITM, 2LIS_11_VAHDR
for Sales, 2LIS_13_VDHDR, 2LIS_13_VDITM for Billing, 2LIS_12_VCHDR,2LIS_12_VCITM for
Delivery and 2LIS_02_ITM and 2LIS_02_HDR Purchasing data sources.
 Resolved different priorities (Critical, High, Medium and Low) of End user tickets with in the
SLA By maintaining the proper work logs using the tool service now.
 Created and Involved in maintaining documentation for all the Support Activities and track
the Incidents and service requests weekly wise tracker.
 Designed and developed Process Chains (RSPC) for Master data loads Transaction data loads
and these Process chains are scheduled for periodic loads.
 Developing Transformation, Update Rules, transfer Rules, Communication structures in 7.X
and 3.x flows and involved migration of flows from 3.X to 7.X.
 ABAP coding for Filed, Start routine & End routines at Transformation level in BW modeling.

Client Saudi Airlines (worked on Sulb and Cairn India Projects)

Role BI Consultant
Duration January 2013 to April 2015
Team Size 2
Environment ECC 6.0,BI 7.0, SAP BEx Analyzer, BEx Designer

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 3

Roles and Responsibilities:
 Created customized Info Cubes in HR Module based up on the client requirements build
appropriate Transformations using formula builder and routines.
 We are used generic extraction using function module based on the tables TEVEN, CASTDB,
PA2001, PA2002 and PA0007.
 Developed reports like Manager detailed view for Employee Statistics, Time Slot Statistics
and Employee Statistics for Monthly View, Clock In/Clock Out irregularities, Lost Hours
Overview, Overtime Overview, Attendance Overview, Leave Overview, Executives Summary
Overview and CATSDB Statuses Counts.
 Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate
data analysis in a drill down/summarized way to give detailed levels of information.

Client Indian Additives Limited (IAL) and VVF – Implementation Project

Role BI Consultant
Duration November 2012 to December 2013
Team Size 2
Environment ECC 6.0,BI 7.0, SAP BEx Analyzer, BEx Designer

Roles and Responsibilities:

 Used LO structures for extracting sales Orders, Shipping and billing information into various
ODS and Info Cubes.
 Extracted CO data and generated reports on overhead cost controlling and cost center
accounting data.
 Created customized Info Cubes based on the client requirements with appropriate Update
rules using formula builder and start routines.
 Extracted CO data and generated ZICS report on overhead cost controlling and cost center
accounting data.
 Creation and maintenance of Standard and Customized Info Objects, Info Cubes, ODS, Multi
Providers, and Info Sets using Administrator Workbench.
 Worked on Inventory Management cube ZIC_C03 to get the inventory reports like Stock
overview and Inventory Stocks Report with price data and used data sources 2LIS_03_BX,
2LIS_03_BF and 2LIS_03_UM
 Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate
data analysis in a drill down/summarized way to give detailed levels of information.
 Developed Daily Gross Margin Report using the condition data source as 2LIS_13_VDKON.
 Developed Debtors aging report in FI using the data source 0FI_AR_4.

Client Harden Heath Care and Sujana Steel – Implementation Project

Role Consultant
Duration January 2011 to November 2012
Team Size 3
Environment SQL Server 2008,SSIS,BO XI 3.1, WEBI and Xcelsius
Roles and Responsibilities:
 Create database tables as per the design to meet the reporting requirements for the EDW
and Developed by mappings from source tables to target tables using SSIS for ETL
transformations
 Responsible for understanding Business requirements and the Functional Requirement
documents based on that design technical design documents

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 4

  Implemented ETL and business logic with various tasks and transformations using control
and dataflow tasks
 Created Web Intelligence documents using the features like User Response, drill options,
alerts, data purge, breaks, sections, Variables and formulas
 As per client requirements generate the reports in the form of Table, Matrix, and Charts
 Created reports containing all the information regarding the material, distributors and
retailers for drill downs
 Created Reports to display Purchase Orders by the Vendor, Sales Overview, and Inventory
Overview over given period of time using Webi reports.
 developed visualizations using Xcelsius that display information on regional wise sales Vs
Monthly, Weekly, Quarterly and Yearly
 Created Test cases for the report developed and developing unit test cases for every report

Client Good Year – Implementation Project

Role Consultant
Duration June 2009 to Dec 2010
Team Size 5
Environment SAP ECC 6.0, BI 7.0, SAP BEx Analyzer, BEx Designer, Hyperion IR

Roles and Responsibilities:

 Installation of the Master Data and Transaction data sources from the Business Content.
 Loading the data from PSA to Data Targets using Transformations and DTP’s with respective
data targets using Filed, Start and End routines.
 Responsible for job scheduling for loading data into Info Cubes, DSO objects from SAP R/3,
non-SAP systems and flat files and monitoring Process Chains to run periodic loads and other
processes.
 Develop Head Count and the Personnel Actions info cube (0PA_C01) and customized it for
Supervisor, HR Manager, Region, Market and Store
 Developed multiple reports like Head Count Reports, Reports for demographics, reports on
address and Location, Reports on Age Service and Anniversary information in SAP BEx
reports
 Created process chains to automate the data loads of the above processes for master and
transaction data
 Designed the Technical Specifications Document based on the Functional spec provided by
the BP team

Client WSK (Pratt & Whitney) Poland – Implementation Project

Role Consultant
Duration July 2007 to June 2009
Team Size 3
Environment SAP ECC 6.0, BW 3.5,BEx Analyzer, BEx Designer

Roles and Responsibilities:

 Worked extensively on LO Cockpit and Involved in mapping the SAP ECC Logistics data
starting extraction from data source till uploading the master/transaction data into Info
Objects and Info cubes
 Set up procedure for extracting SAP ECC data for General Ledger Line Item data display for
delta extraction 0FI_GL_4 ,0FI_AP_4 and 0FI_AR_4 in FI module

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 5

  Extracted data from ECC Source System for the Production Orders and designed the Multi
provider ZEMPRO100 to develop the Production Orders Report.
 Set up Procedure for extracting ECC data for Data sources of Notification, Notification Item,
Cause, Task and Activity in Quality management using LO-Cockpit and replicate in to BW side
and designed corresponding ODS and Info cubes

Client ModusLink Corporation, US – Implementation Project

Role Consultant
Duration August 2005 to June 2007
Team Size 7
Environment SAP ECC 5.0, BW3.5,BEx Analyzer, BEx Designer

Roles and Responsibilities:

 Set up procedure for extracting ECC data for Sales Order, Delivery, Billing Document in Sales
and Distribution using LO-Cockpit
 Created Multi provider on Billing and Accounts Receivable Info cube to assist the user in
providing with appropriate Billing and AR Invoices summary data
 Extensively worked on BEx Query Designer to create Query Analyze the inventory aging
according to number of days using Formula variable, Restricted Key Figures, Calculated Key
Figures, Variables and filters in Report
 Created the process chains and automate the data loads loading into different data targets
 Developed Formula variables using the Replacement path for summarizing the gross weight
(which is maintained as an attribute) of a Material
 Created different types of variables used by the respective processing types used by filters to
restrict the data into Bex report.
 Involved in transporting the developed objects from DEV environment to QA and hence to
the Production environments, both in ECC and BW systems
 Involved in the unit testing for the developed objects and maintained the documentation for
the same
 Designed the Technical Specifications Document based on the Functional spec provided by
the BP Team
Education

Master of Science (Computer Science) from Aurangabad, Marathwada University, Maharashtra

Passport Details

Passport no: M9355741

Passport Expiry date: 27-05-2025

Email id: Rambabu.g.sap@gmail.com Phone No: +91-8919978026 Page 6