Sign in

Data Sap

December 30, 2018

Contact this candidate


D. RAMESH KUMAR Contact: +91-988*******

Bangalore India email:


Certified consultant

14+ years’ experience with SAP implementations, upgrade & support


Involved in all stages of Implementation, initial analysis, set-ups, testing, customization, documentation, roll-out and hyper

Proven success in 8 Implementations (5 outside India & 3 within India), 3 Upgrade projects & several support projects of SAP BW, BW4HANA, S4HANA, BODS, LUMIRA

Handled BW4 HANA, S/4, Native, Embedded Analytics using CDS views, and using Hana live to add vaue. Addressing hybrid, embedded and mixed scenarios

Possess high level consulting skills, involving understanding client’s business problem, architecting viable solutions and guiding the implementation of same within the client’s environment

Successfully worked in both managerial and architectural aspects; independently completed complex project tasks; identified key drivers of defined problems and proposed innovative solutions

Gained 5 years onsite experience across Europe (Germany, U.K., US, Netherlands, Czech Republic)

Big picture thinker, proactive & solution-oriented with analytical, decision making and problem-solving skills


Functional Areas worked on:

Utilities & SCM

Supply chain management



Technical Skills:

BW4 HANA, S/4 Embedded Analytics, Native and BW on HANA, both on Side Car and Enterprise HANA using Data Services & SLT for Data

Experience in HANA Native Hana, CTS++ transports, HALM

BO webi, BO Dashboard, BO Administration, Analysis Authorization

Experienced in Embedded Analytics (building CDS views) and other Odata services

Experienced in Lumira, Analysis for OLAP sourcing data from HANA & Hadoop

Worked Composites, ADSO’s and Open DSO Views along with SDA focussing on mixed scenarios to reduce TCO

Worked on both Agile and waterfall adopting SAP best practices and fit scenario

Transport Management including forming of strategies, corrections, obtaining business, technical go–live sign-offs and their cut over plans

Worked on Predictive Analysis using Time series and Binning forecasting techniques

LSA ++ Architecture involving sourcing of data from heterogeneous landscape environments

Cutover planning, implementation of applying support packs, system refresh’s technical and business go-live

Supply Chain Management SME (Subject Matter Expert) in Demand Management, Inbound Monitor, Cost to serve

Worked extensively with FICO, HR, SRM and Supply Chain modules


2012 year: SAP BW

2016 year: SAP HANA

2007 year: SAP BIW Net Weaver V


2002 year: Masters in Business Administration (Marketing) from Andhra University

1999 year: Bachelor in commerce

IBM India pvt ltd Since Jun’2017-Till Date

BW4 HANA & BO Technical Architect

Client Shell


Managing BW4 HANA and Native HANA deliverables

Worked with Embedded Analytics on CDS views to address the business requirements which includes Cost to serve Lumira Dashboards with rolling and forecast scenarios

Worked with ODP ODQ to source data from SAP source systems

Worked with VDM’s to publish the same in Fiori apps – created Analytic tiles for business users

Designed mixed scenarios to consume data from S4 hana and BW4 hana without persisting the data

Worked on Plan data to homologize the data with Actuals and building what if analysis Dashboards

Extensively worked on HCM building HANA views for Available to work, Absentees, LSO and maternity scenarios

Worked on Cost to serve reporting using BW,Lumira Dashboards - sourcing from Shipping cost/GL,Purchasing and PCA

Sourced data using Data services from Non SAP and used them in our Analytics

Used SDA for building views from S4/HANA

Handling the projects by assuring Agile EDGE

Obtaining approvals from Client for the changes / Design document, FS

Tracking the development progress on a daily basis

Managing FUT, SIT & UAT

Handled HANA transports using CTS++ Charm transports for S/4 Hana and HALM for Native Hana through Solution Manager

Handled support incidents to deliver them in SLA

CGI Since Oct’2007- April’2017

BI BO & HANA Tech Lead and Solution Consultant in CGI

Current Role: Role: BI & Analytics Stream Lead


Managing end-to-end implementation, support & upgrade of SAP BI BO, HANA & Data Service Modules

Performing review of business process flow and mapping of business requirements (As-Is & To-Be Analysis)

Identifying gaps, converting business requirements into functional design documents & technical specifications, data migration and delivery

Worked on HANA Views, Optimizing Data loads with the use of SLT and minimizing HANA space

Preparing & maintaining business blueprint, functional specification and test scripts; contributing to the design, development, testing, troubleshooting and debugging of the solutions

Performing Unit Testing & System Integration Testing; testing various scenarios in development environments and tracking them till production; performing root cause analysis & resolution of defects

Selecting the most relevant tools/techniques to meet specific client requirements; understanding the benefits of using state-of-the-art methods and tools and their application on a particular engagement; contributing to continuous development of methods and tools

Ensuring strict adherence to project milestones, service level agreements, categorization schemas and rule policy

Acting as a point of technical escalation and resolution during the project lifecycle; identifying roadblocks and ensuring timely delivery of project

Leading a high-performing team of size 18; building & maintaining excellent rapport with team, improving team morale & promoting collaboration amongst team; delivering trainings for the team to help them tackle severity issues


Successfully acted as Tech Lead for a Stabilization project of client “PostNord”, involving migration of all objects to 7.3 SPO’s and re-designing of objects in 3.5 version

Appreciated by PostNord for delivering 1300 hours of work with minimal incidents and for numerous system refreshes, copies & cut over plans for both business & technical go-lives

Excellent track record of managing change requests and incidents for Haringey, UKPN, AKZO Noble Support project; received recognition from management and promotion as BI Architect for Logica India

Played a pivotal role in addressing a long pending issue of inconsistency between system landscape and obtaining sign-off from Solvay for implementation of the change

Received appreciation from:

oSAP and CGI, twice, for exceeding customer expectations

oOnsite Team from SAP America, in 2009 year, for accomplishing desired results in 1/3rd of the given time

oIT Director of Solvay for revamping the existing CVs to and providing solution to existing ETL process using BODS

Consistently contributed to the successful realization of client goals

Coordinated change management to interfacing systems such as ICH for upgrades and enhancements to ensure nil disruption to production time

Led engagements to analyse customer business processes, assess pain points and suggest areas of improvement using SAP solutions

Engaged with account teams and clients to identify opportunities for change; delivered detailed reports and presentations

Built communities of practice in collaboration with teams within the SAP ecosystem with the objective of sharing best practices and knowledge capital

Reduced defects by 34% and improved the Service Level Agreement (SLA) through defining best practices and department standards


oStar Award from United Utilities in 2015 year for delivering complex requirements on time

oGold Award for managing the entire Eon UK End-to-End Implementation project offshore; received appreciation from Head IT from E.on for the accuracy of the reports



Client: Solvay

Role: BI & Analytics Stream Lead

Period: 06’2015 – 04’17

Environment: SAP BW / BO / HANA

Source Systems: SAP ECC, SRM, NON SAP, ICH, FF

Client Profile: Solvay (headquartered in Brussels with around 27,000 employees in 58 countries) is a multi-specialty chemical company, committed to developing chemistry that addresses key societal challenges. Its products and solutions are used in planes, cars, smart and medical devices, batteries, in mineral and oil extraction, among many other applications promoting sustainability.

CGI transitioned Solvay’s present process from FR, Brazil. It also transitioned the BI Analytics stream and was successful in obtaining sign-off from Solvay. CGI has played a key role in S/4 HANA transformation of Solvay.


Worked on HANA Graphical and CDS Views,

Optimizing Data loads with the use of SLT and BODS

Worked on SAP SLT and Smart Data access (SDA) for S/4 Logistics application data

Converted existing reporting solution from ABAP to HANA by creating Calculated and CDS views

Migrated the existing scripted Calculation views to tabular functions

Created hybrid reports consuming both BW and HANA data

Resolved problem tickets to standardize the system to address recurring issues in data provisioning

Added value to the existing data flow by modifying / restructuring which resulted in saving significant provisioning time

Prepared POC for implementation of SPOs and got the same approved by the client

Used ADSOs and migrated data from DSO, CUBE & Hybrid providers

Steered migration from multi-providers/info sets to use composite providers

Worked on composite and ADSOs to migrate data from existing info providers but from Non- SAP data sources using smart data Integrator; worked on SLT replication and de-clustering scenarios

Devised strategy for usage of SLT (delta scenarios, master data updates and enhanced table updates)

Preparation of estimations for complex changes and obtained sign-off from Solvay

Client: PostNord

Role: BW BO Lead

Period: 04’12 - 05’15

Environment: SAP BW / BO / HANA / BODS

Client Profile: PostNord offered communications and logistics solutions to, from & within the Nordic region. CGI ensured mail delivery to private individuals and business in Sweden and Denmark Project.


Prepared blueprint; performed feasibility study; working with clients in the workshops to obtain Asis

Published webi reports for Sales Force Analysis using BW Bex reports as the data sources

Undertook BO administration such as user maintenance, roles and authentication/authorization

Developed data flows and workflows using BODS

Used SAP BW/ECC as source and HANA as target with SAP Data Services as the integrator

Built jobs in SAP BODS for ETL between Source and HANA

Created Attribute views, Analytical view and Calculated views as per the requirement needs

Made CV’s to use the SQL Engine for various functional areas by copying the standard SAP live content

Optimized the join conditions and used Cube CVs as required

Executed Data Extraction Transfer Loading using SAP Data Services 4.0 to import .csv files into SAP HANA tables


oTables involving hierarchies and resolved them using Hierarchy Flattening

oBODS for transformation and loading data from heterogeneous source systems i.e. files, BW to HANA

Developed POC basing on HANA S/4 and showcased the same to Client using COPA Data Model

Client: United Utilities End-to-End Implementation

Role: BI Analytics Consultant

Period: 03’10 - 04’12

Environment: SAP BW / BO

Location: U.K.

Client Profile: United Utilities is a leading Water & Utilities provider in UK and holds license to provide water & sewage services to around 7 Million people in North West England. These services are carefully regulated with the water regulator Ofwat. To show how they put their earnings to work, between 2010 to 2015 UU invested > £3 Billion to improve the water & wastewater infrastructure and the environment across the North West. UU relied on manual process for their HR, FI, SCM & SRM reporting that was consuming > 100 man-days of work every month. UU aimed to automate all the reporting using SAP BI and BO.


Delivered technical solutions for around 40 functional specs including HCM, SCM, SRM, BO, Authorizations, BO Administration, BO Promotion and Transition

Provided alternatives to many BW limitations

Successfully delivered the most of the objects 85 Bex reports, 58 Business Objects webi reports, 8 dashboards –(both management and operational level) and 12 Hana reports for HCM

Client: Eon UK End-to-End Implementation

Role: Analytics Tech Lead

Period: 04’09 - 02’10

Environment: SAP BW / BO

Client Profile: Eon is one of the UK’s leading Power and Gas companies generating electricity and retailing power & gas. It is part of the E.ON group and one of the world's largest investor-owned power and gas companies. It employed around 12,000 people in the UK and > 79,000 worldwide.


Prepared functional specs after conducting workshops with the client till the reports were live

Managed FS, TS, SIT, UAT, Authorizations and Transition


o22+ reports out of which 16 were Webi reports on top of Bex queries

o6 Dashboards using Qaaws & Webi as data sources

Client: Welsh Water UK, Re-Implementation

Role: Support and Change Lead

Period: 11’08 - 04’09

Module: FI, HR, SD, MM, SRM, SIPS


Performed estimations; created several change requests by conducting workshops for understanding the actual requirement from the client


oComplex transformation logics to include both the transfer rule and update rule logic

oWrite Optimized DSO where ever applicable to improve the load performance

oBI Accelerator to optimize the query performance

Implemented Information Broadcasting for various workbooks and queries

Worked on:

oPS reports using numerous amount of customer exit variable to attain specific customer requirements from NATS

oComplicated Change Requests and provided solutions according to the client requirement

oBoth R/3 and BW copies from Production to Quality and provided the reconciliation document to the client

oBI transports while delivering the Change requests to the clients

Designed the Project Plan for system copies and executed them successfully

Resolved numerous amount of issues during system copies and even configured Idoc types for the source system to activate the same

Client: Haringey, UKPN, AKZO Noble - Support

Role: Tech Lead

Period: 10’07 - 11’08

Modules: FI, HR, SD, MM, CRM


Supported clients by fixing the problems while in the data loads

Completed the change requests on time and obtained sign-off from the customer

Led the BW team of 15 members; tracked quality of developments by the team members and helped them to resolve the tickets without escalations

Managed 20+ change requests and 200+ incidents

Client: Caterpillar Inc. - Implementation

Role: BW Developer

Period: 07’04 - 10’07

Environment: SAP BW

Client Profile: Caterpillar is a $40 Billion company which in initially into Earth moving Manufacturing and was now into whole range of Businesses to cater the Human needs.

Project Scope: This project was a new solution provided by SAP (Service Parts Management). SAP used both Ford & Caterpillar’s Process knowledge of over 100 years by joint venturing with both of them for building the legendary solution for Service Parts. SPM was implemented in CAT for a facility as a Ramp up Customer of SAP. This module as tested for the integrations between ICH, APO, SPP, CRM, SAP R/3 and EWM.


Involved in 2 important Business processes of SPM (Demand Management and Inbound Monitor)

Worked on data consistency between ICH, APO, SAP R/3, CRM systems before updating data in enterprise BW system

Worked on BW queries for Inbound monitor to check various discrepancies between to the order and the delivery

Worked on CRM extractor to source data to BW – the said data is used in APO for Demand forecasting using various models

Gained knowledge on Global ATP check while addressing data issues

Contact this candidate