Sap BW/Hana

SHIVENDRA PRATAP SINGH

SAP BW Consultant

Mobile : +91-962*******

Email ID: *************@*****.***

Professional Summary

Over all 9+ years of IT Industry experience in SAP Analysis, Design, Development and Implementation of Solutions with 8+ years of experience in SAP BW and SAP ABAP using AGILE and ASAP methodology. Possess excellent inter-personal, phone and digital communication skills. Proven technical expertise includes SAP Business Suite products (ECC 6.6, CRM 7.0, MDG 7.0, SCM, MDM) SAP Netweaver products (BW/4,BI/BW, PI, BO, CLM, MDG Ehp6). Proven ability to implement SAP solutions in international environments such as Europe, Canada and India.

I have worked for clientele, which are from varied backgrounds such as Retail (NESTLE), Life Science (Boston Scientific), Telecom (Vodafone), Conglomerate Energy and Finance (ANSTO).

Position

Solution Designer / Lead/Co-Ordination

SAP BW Administration / Implementation/Support

SAP ABAP Implementation/Support

Native/S4/ABAP on Hana Implementation/Support

Education

06/2005- 05/2009 Bachelor of Engineering in Computer Science

07/2004- 05/2005 High School (Science)

07/2002- 05/2003 Secondary School (Science)

German Language Proficiency

A1 from the SRM Institute in Chennai in 2007

SAP Products

ECC 6.0 EHP5, EHP6, EHP7

CRM 7.02

SCM 7.0

GTS 9.0

BW 3.5, 7.30, 7.31, 7.50

SAP HANA 2.0 SPS 04

SAP BO XI 4.0

Industries

Networking

Retail

Enterprise Business Software Product

Telecom

Conglomerate Energy and Finance

Other Products

Control M

UC4

Nestool

Open Text

Operating Systems

Windows 2008 R2

Linux (SUSE, RED HAT)

UNIXS

Programming Languages:

PL/SQL

ABAP

PYTHON

Databases

MAXDB

MS SQL Server

Oracle 10 and 11 G

Experience Summary

No of Large Scale Implementation Projects

3

No of Support Projects

1

No of Upgrade Projects

1

Overall IT Experience

9 years and 2 Months

Overall SAP Experience

9 years and 2 Months

Overall SAP BW Experience

8 Years and 2 months

Overall SAP Sub-Specialization Experience

SAP BI/BW Administration/Implementation/Support

8 Years

SAP ABAP

8 Years

Native/S4 Hana

5 Years and 6 months

ABAP on Hana

5 Years and 6 months

SAP BO XI 4.0 and Design Studio

4 Years and 6 months

Config Tool, UC4, Control M

3 Years and 6 months

Products/Standards/Experience

AGILE/ASAP Implementation Methodology

•Extensive experience in ASAP methodology of Implementation. Worked in 2 large-scale full life cycle implementation projects with both Big Bang and Phased release methodologies spanning multiple years.

•Involved in SAP solution design and system strategy. Involved in Sizing of various solutions using Quick Sizer, working through Blueprint, realization and Go-live phases.

•Experience in deciding on Client strategy, System Landscape design, and Transport strategy.

•Experienced in disaster recovery planning and execution. Have performed support from Basis for Operational Readiness test.

•Support Performance Engineering team with various performance test cycles.

SAP BI/BW Administration/Implementation/Support

•Extract – Extraction of data from ECC using standard and generic data sources (from Delta and ODP queues) based on Function modules, from Flat Files and third party system through SAP BODS.

•Load - Expertise in Data Loading (initial, Delta load and Full load), APD, Scheduling and

•Monitoring of Process chains, data loads to open hub.

•Transform –Created start, end, Expert and field routines.

•Worked on Logistics and FICO data extractors, its configuration and customization.

•Created Info Objects, Data sources, ADSOs, Transformations, Composite Providers.

•Created Generic Data sources based on Function Module.

•Worked on LO Cockpit enhancements and performing necessary activities, like deleting and filling up of set up tables.

•Worked on ABAP routines and customer exit variables

SAP ABAP -Implementation

•Created Expert Start, End, Field, Expert Routine and AMDP Scripting based on business requirement.

•Created Function Module to extract data based on generic extractor.

•Debugged Logics for different modules based on multiple scenario.

•Created Customer exit for Variables used in bex query.

•Developed ALV list report provides data that is used as the basis for metrics administered by the Strategic Planning Group. It provides pricing details on all sales documents. Configured CCMS Alerts and Alert Categories and Alert Rules.

•Developed SD ALV report to provide information on all warranty return material.

•Automated the month-end exchange rate update process. Used BAPI to create exchange rate records in SAP table. Developed and maintained several ALV reports and standard reports for Treasury module.

SAP Native/S4/ABAP on Hana

•Worked on POC involving SDI Replication Methodology.

•Worked on Remote Subscription methodology and Streamline process chain.

•Created Attribute View, Analytic View, and Calculation View on tables from ECC and other

•Database.

•Worked on Stored procedures and Scripted calculation views.

•Expertise in SAP BW HANA components like Advanced DSO, Composite Provider, Open ODS View, ABAP CDS View.

•Worked on SAP Demand Signal Management, which SAP HANA, to Analyze, powers improve the sales, and brand performance.

•Native HANA XS application development to read tables in HANA database using HANA Studio.

•Consuming of SAP data using OData HANA service.

•Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.

•Building CDS Views using HANA Studio & HANAXS Concepts.

•Implementation of stored procedures to retrieve data from HANA database schema.

SAP BO Administration/Implementation/Support

Created WEBI reports creation on top of BEX queries.

Created Universe on top of HANA Views and Bex queries.

Created Design Studio Report on top of HANA Views and Bex queries.

HANA Administration

•Implement, Debug and Support SAP HANA Deployment

•Solution Provisioning of SAP HANA Appliance

•Adding SAP HANA System in SAP HANA Studio, Stopping, Starting and restarting SAP HANA Services

•Adding user to SAP HANA System, Exporting/ Importing SAP HANA System

•Managing SAP HANA License, Managing SAP HANA users and monitoring system.

•Managing Table in SAP HANA, Scaling SAP HANA

•Backing up and recovering SAP HANA Database

Project Management

•Managing Support Project Life Cycle

•Project planning, scheduling, reviewing/monitoring

•Undertake requirement management with client

•Ensure adherence delivery on time

•Monitor and review project standards and metrics basis multiple parameters

•Identify key risks and review mitigation plans for the projects

•Ensure implementation of best practices in project Management across domain

•Manages client expectations by communicating regularly

•Estimate, Plan, and Execute training projects by ensuring the processes and adhering to the set standards of quality

•Monitoring product development activities and timely risk assessment.

•Delivering & implementing the project as per scheduled milestones.

•Providing solutions to RFP

People Management

•Managing performance, career growth and developmental needs of team members.

•Delegating the work to the team members on a priority basis and based on the skill set.

•Ramping up the teams’ technical and soft skills by providing appropriate trainings.

•Managing & providing guidance/support to the project team.

•Motivate and lead project teams including setting & reviewing goals

Project Experience

Organization

Techmahindra

Project

Nestle (Globe)

Industry

Retail - Discount department store, hypermarket, supercenter, superstore.

Project Type

Implementation

Role

Solution Designer

Duration

March2017 -Till Date

Location

Bangalore-India / Barcelona-Spain

Team Size

25

Solution Environment

ECC 6.0 EHP6, CRM 702MDM 6.0, SAP NW 7.5 BW.

Database

Oracle 11 G OS: SUSE Linux on Cloud Environment

Tasks Performed

•Involved in SAP solution design and system strategy. Involved in Sizing of various solutions using Quick Sizer, working through Blueprint, realization and Go-live phases of ASAP Implementation methodology.

•Involved in Performance tuning activities. Extensive experience in tuning the system for optimal performance

SAP BW on Hana Implementation

•Worked on P2P Scrum to Develop Cash Efficiency and Business Opportunity Report, which involved showing payment information year wise against each vendor on SAP BI 7.5 using ABAP/4.

•Implemented POCs Involving Star Join Views, CDS Views and Active table Views for SD and FI module.

•Extract – Extraction of data from ECC using standard and generic data sources (from Delta and ODP queues) based on Function modules, from Flat Files and third party system through SAP BODS.

•Load - Expertise in Data Loading (initial, Delta load and Full load), APD, Scheduling and

•Monitoring of Process chains, data loads to open hub.

•Transform –Created start, end, Expert and field routines.

•Worked on Logistics and FICO data extractors, its configuration and customization.

•Created Info Objects, Data sources, ADSOs, Transformations, Composite Providers.

•Created Generic Data sources based on Function Module.

•Worked on LO Cockpit enhancements and performing necessary activities, like deleting and filling up of set up tables.

•Worked on ABAP routines and customer exit variables.

SAP ABAP Implementation

• Created Expert Start, End, Field, Expert Routine and AMDP Scripting

Based on business requirement.

• Created Function Module to extract data based on generic extractor.

• Debugged Logics for different modules based on multiple scenario.

• Created Customer exit for Variables used in bex query.

• Created ABAP CDS Views so it can be consumed in a calculation view for

Reporting purpose.

•Developed ALV list report provides data that is used as the basis for metrics administered by the Strategic Planning Group. It provides pricing details on all sales documents. Configured CCMS Alerts and Alert Categories and Alert Rules.

•Developed SD ALV report to provide information on all warranty return material.

•Automated the month-end exchange rate update process. Used BAPI to create exchange rate records in SAP table. Developed and maintained several ALV reports and standard reports for Treasury module.

SAP Hana Implementation

•Worked on POC involving SDI Replication Methodology.

•Worked on Remote Subscription methodology and Streamline process chain.

•Worked on SAP Demand Signal Management, which SAP HANA, to Analyze, powers improve the sales, and brand performance.

•Used DSIM to fill in the Harmonized Records values using the data from the assigned Source Records (SAP ERP, SAP CRM (Customer Relationship Management)). Given that multiple Source Records may be mapped to the same Harmonized Record

•Used DSIM to Deliver Mobile Showcase for Key Account Managers and Marketing Directors, and so forth.

Organization

Tata Consultancy Services

Project

Boston Scientific

Industry

Healthcare IT service

Project Type

Implementation

Role

IT Analyst

Duration

April 2016-January 2017

Location

Bangalore-India

Team Size

15

Solution Environment

ECC 6.0 EHP5, SAP Net weaver 7.30 BW, SAP HANA 2.0 SPS 04

Database

Oracle 10 G OS: Linux

Tasks Performed

SAP Hana Implementation

Used CDS Views to create custom queries with SAP Analytics Cloud for S/4HANA.

•Native HANA XS application development to read tables in HANA database using HANA Studio.

•Consuming of SAP data using OData HANA service.

•Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.

•Building CDS Views using HANA Studio & HANAXS Concepts.

•Implementation of stored procedures to retrieve data from HANA database schema.

•

SAP ABAP Implementation

•Created Expert Start, End, Field, Expert Routine and AMDP Scripting based on business requirement.

•Created Function Module to extract data based on generic extractor.

•Debugged Logics for different modules based on multiple scenario.

•Created Customer exit for Variables used in bex query.

•Created ABAP CDS Views so it can be consumed in a calculation view for reporting purpose.

•Developed Transfer PCR scenario in CPM project, which include developing of jsp pages and developing bapi for transferring data to and from the portal to SAP.

Organization

HCL Technologies

Project

ANSTO

Industry

BIOMEDICAL

Project Type

Implementation

Role

SAP Consultant

Duration

June 2014-April 2016

Location

Bangalore-India / Prague- Czech Republic

Team Size

21

Solution Environment

SAP Netweaver 7.10 BI, PI and EP, ECC 6.0, MDM

Database

Oracle 10g OS: Linux

Tasks Performed

SAP BW Implementation

•Created Info Objects, Data sources, DSOs, Info cubes Transformations, OHD and Multi Providers. •Created BEX queries and WAD. •Created process chains for data loading and Housekeeping activities. •Reconciliation of BW reports with ECC tables for Functional testing. •Involved in performance tuning of Queries by maintaining Aggregates, Compression, building BIA Index on Info cubes. •Worked on Business Planning and Simulation tool for Trade Promotion Planning. •Modifications in the existing reports and Data modelling (Change requests). •Proposed solution to minimize work effort. •Worked with Functional team to correct the Business Process for Product Costing as part of Problem

SAP BO Implementation

• Worked on WEBI reports creation on top of BEX queries.

• Worked on Universe on top of HANA Views and Bex queries.

SAP Hana Implementation

•Created Attribute View, Analytic View, and Calculation View on tables from ECC and other Database.).

•Worked on Stored procedures and Scripted calculation views.

• Created Hana solution as part of ONE POC shown to the client where we collected Social media data into the HANA systems. Then created calculation views on top of that having few business logics. Report delivered to the business created by BO team.

Involved in SLT Replication.

Organization

IBM

Project

Vodafone

Industry

Telecom

Project Type

Support

Role

SAP BW Consultant

Duration

July 2010-July 2014

Location

Bangalore-India

Team Size

12

Solution Environment

SAP Net weaver 7.30 BW

Tasks Performed

•Modifications in the existing reports and Data modelling as part of change requests and incident management.

•Designed and developed process chains for master data loads, transaction data loads and Open Hub destinations.

•Involved in the monitoring of process chains production support.

•Handling the regular data loads issues proactively and precisely.

•Preparing the status of data loads and issues generated and updating the stakeholders.

•Resolving tickets raised by Business Users for their issues on BW Reports on data availability.

•Worked on tickets for data load failure issues.

Additional Training Courses

Course

Institute

Duration

ABAP on Hana

Tech Mahindra

1 Months Full time

SAP BW NETWEAVER 7.5

Tata Consultancy Services

Completed in June 2016 (2 months fulltime)

Project Management Institute PMP training

Tata Consultancy Services

Completed in August 2017 ( 72 Hours )

Educational Qualification:

QUALIFICATION DETAILS:

Si. No.

Course

Board

Institution

Year Of Passing

Percentage

1.

B.Tech(I.T)

SRM University

SRM Engineering College, Chennai

2009

7.0 CGPA*

2.

12th Std

CBSE BOARD

Vivekananda Kendriya Vidyalaya

2005

68.8

3.

10th Std

CBSE BOARD

Vivekananda Kendriya Vidyalaya

2003

70

*CGPA -Cumulative Grade Point Average (Up to 8th Semester)

Contact this candidate