RB

Ramesh Babu

available

Last update: 06.09.2022

SAP BW/HANA Lead Consultant, SAP BW Consultant, SAP BW Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: k. A.

Skills

SAP BW (3.5/7.0/ 7.3/BW 7.4/ BW 7.5), SAP BW/4 HANA, SAP HANA, SAP Analytics Cloud, SAP Business Objects, SAP, SAP Lumira, SAP Analysis for Office, SAP BODS 4.2, SQL (HANA & RDBMS), SAP BW, HANA, HANA Studio, Business Objects, data modelling, Object -Oriented, ABAP, SAP Controlling, SAP PS, Data Warehouse, Info Cubes, DSO, Info Objects, DTP, Info packages, Agile, Scrum, Data Integration, SDI, BigData/Hadoop, MySQL, stored procedures, SQL Script, SAP HANA Studio, flat file, extractor, input parameters, DB, ODBC, Pivot tables, Microsoft Excel, MDX, databases, Data Modeling, FI, extractors, EDW, ODS, Info, Debugging, query performance, partitioning, Database Management, Computer programming, Java, C++, Computer Science

Project history

06/2016 - 07/2019
SAP BW/HANA Lead Consultant
Cognizant Technology Solutions

* Worked with customer team to define and convert business requirements, processes and designs
into comprehensive, robust, efficient, scalable and stable BW/4HANA Solutions.
* Built End-to-End solution with SAP HANA models using HANA Studio and generated Reports using
Business Objects (BO) Web Intelligence & SAP Lumira
* Worked on end-to-end SAP BW data modelling, data Staging & reporting activities with relevant
Object -Oriented ABAP .
* Experienced in Technical Specifications based on Functional Documents in both SAP BW and SAP
HANA areas.
* Used Integration Planning(SAP IP) for product level planning.
* Experienced as Subject Matter Expert (SME) and Trainer in SAB BW/HANA areas for End Users .
* Installed in extracting Business Content with respect to SAP Sales & Distributions, Material
Management, Finance & Inventory Management functional areas and developed End to End solution
in SAP BW /HANA.
* Extensively worked on SAP Controlling & Profitability (COPA) and SAP Project Systems (SAP PS)
extractions & reports
* Extensively worked on Data Warehouse Workbench - Advanced DSO, Composite Providers, Open ODS
Views, Info Cubes, DSO, Info Objects, DTP, Info packages, Data sources in SAP BW
* Worked on Agile/Scrum software development in SAP implementation projects.
* Worked with Data Provisioning methods using SAP LT Replication Server (SLT), Smart Data
Quality (SDQ), Smart Data Integration (SDI) and Data Services 4.2 (SAP BODS) to replicate the
data from SAP and NON-SAP applications like BigData/Hadoop, MySQL
* Coded stored procedures in SQL Script for matching the business requirements in HANA
* Worked extensively in support projects and involved in fixing defects, involved in Change
Requests and Enhancements.
* Worked with catalog and Information views (Attribute view, Analytical view, Calculated viewgraphical
and Scripted) in SAP HANA Studio.
* Involves in Extracting data from ECC and flat file using different extractor-LO Cockpit,
Generic Extractor, Operational Data Provisioning (ODP) data sources and involved in Data
Source Enhancement at ECC side for meeting the client's business requirement.

05/2014 - 06/2016
SAP BW/HANA Lead Consultant
Indian Tobacco Corporation

* Created Calculation Views using BW Composite Providers.
* Created calculated measures, restricted measures and columns, input parameters to satisfy
reporting requirements.
* Involved in creation of calculated attributes, measures, restricted measures, calculated
columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements
using SAP HANA studio.
* Created SQL script for calculation views in order to address complex business requirements of
extracting purchase orders information with respect to invoiced amounts, delivered amounts
based on the PO history category type and debit/credit indicator.
* Involved in data loading using BODS from flat files to SAP HANA DB.
* Used Information Design Tool IDT to create Relational Connection, Data Foundation and Business
Layer and publish these connections and layers to SAP BO Repository.
* Involved in Accessing Analytic and calculation views from Business Objects Analysis via ODBC
connection BOBJ Integration.
* Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
* Imported data through flat files into SAP HANA and created schema and required tables.
* Used Information design tool to create connections to SAPHANA databases, Create data
foundations, Create Business Layer and publish these connections and layers to the SAP BO
repository

04/2011 - 05/2014
SAP BW Consultant
Logica

* Worked with the users to get the requirements, performed gap analysis, created functional,
architectural designs, reviewed
* Data Modeling designs with functional team Participating and finalizing the functional
requirements from the business users
* Responsible in converting the functional requirements to technical designs
* Successfully implemented SD, MM and FI/CO modules Developed custom function module extractors,
used ABAP routines in transformations
* Providing project work load and timelines to the business users Responsible for defining
technical strategy and tactical plan for implementing data and information delivery solutions
Participated in design reviews, spec reviews, code reviews, test plan reviews
* Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.

05/2010 - 04/2011
SAP BW Consultant
Wipro Technologies

* Designed and developed various Data targets and Info providers like DSO (ODS), Info cubes,
Info objects, Multi providers and Infosets using Admin workbench (EDW, RSA1)
* Developed various transformations to cleanse the data and enhance the master and transaction
data using Formula Builder and start and transfer routines with ABAP4 to suit the business
requirements
* Populated various data targets like Info objects, ODS and Info cubes, with Master data and
Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging
area (PSA)
* Debugging the Extractor checker, Start routines and End routines Performance Tuning -
Evaluated statistical performance and provided recommendations for optimization.
* Improved data load and query performance by doing compression, aggregates, and partitioning
* Created DTPs, Info packages for Full, Initial, Early Init, Delta and Full repair loads for
both Master data and Transaction data
* Created process chains using various process to automate data loading, activation of DSO,
compression, drop and create indexes, roll up, attribute change run and DB statistics etc.

09/2005 - 10/2009
Lecturer

* Providing lectures for topics such as Database Management Systems (DBMS), Computer programming
(Java, C++), and Advanced Mathematics.
* Trained over 150 students with different backgrounds for graduates University level for
information Technologies and Computer Science

Local Availability

Only available in these countries: India
Profileimage by Ramesh Babu SAP BW/HANA Lead Consultant, SAP BW Consultant, SAP BW Consultant from Bangalore SAP BW/HANA Lead Consultant, SAP BW Consultant, SAP BW Consultant
Register