Data Project

SAP BW on HANA

Dineshkumar P ********@*****.*** M No: +919*********

Summary

SAP BW HANA Consultant with 3 years of Professional experience, involved in Implementation & support projects.

Professional Summary

Involved in multiple full cycle SAP BW implementations from requirement gathering, design and development, testing, go-live and post production support phases.

Modelling –Extensive experience in data modelling.

Customizations – Extensively worked on activating standard Business Content and enhancing data sources according the business requirement.

BEx Reporting – Extensively worked on Query Designer components like Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions and Conditions.

ABAP (Related to BW) – Expertise in ABAP programming in writing the CMOD for customer exit variables and writing the start routine, end routine and Field level routines.

HANA - Having knowledge on SAP HANA Data Modelling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based),CDS Views, OData Services.

Good Knowledge on Composite provider, Advance DSO, and Open ODS view.

BO - Knowledge on Lumira Dashboards and IDT.

Excellent communication skills, leadership qualities, systematic approach and ability to work effectively in fast-paced environments.

Employment History

Company Employment Period

HTC Global services pvt (Ltd.) – Chennai February 2016 - Till date

Education

Bachelor of Engineering (CSE) Maharaja Institute of Technology, Coimbatore.

Professional Experience

GMCR

From January 2017

BW7.5 on Hana Implementation Project - Offshore

Till date

Position

SAP BW & HANA Consultant

Keurig Dr Pepper, formerly Keurig Green Mountain and originally Green Mountain Coffee Roasters, is a publicly traded American beverage and beverage-maker conglomerate with dual headquarters in Burlington, Massachusetts and Plano, Texas. Its east-coast division sells coffee and other beverages, and Keurig brewers.

Project Responsibilities

Performed data modeling and developed Analytical views for the transactional data, Attribute

views for the master data, Calculation views and CDS views as final model and exposed as OData Services in HANA Studio.

Expertise knowledge and hands on experience in writing SQL queries and CE functions.

Developed data models for the operations MM, Quality management tables in HANA.

Created Composite Provider, ADSO.

Good knowledge of SAP HANA Architecture.

Extensive knowledge on LSA,LSA++,Composite provider, Transient provider, Advance DSO

and Open ODS view-using BW modeling tool in HANA studio.

Created the Odata Services for CDS Views and exposed to Fiori launchpad in HANA Studio.

Provided team training on Introduction to development on SAP HANA Suite and currently

handling the training task with projects.

Drive Medical

From November 2016

BW 7.5 Implementation Project - Offshore

To July 2017

Position

BW Consultant

Drive Medical manufactures a complete line of durable medical equipment including mobility products, beds, bariatric products, wheelchairs, sleep surfaces and pressure prevention products, respiratory equipment, self-assist products, power operated wheelchairs, long-term care and rehabilitation products, patient room equipment, personal care products and electrotherapy devices.

Project Responsibilities

Responsible for design, development and extraction of data from ECC source system into BW from SD and MM using LO cockpit extraction methods.

Created setup tables for the LO-Cockpit extraction using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.

Performed LO-Cockpit extraction to pull data from ECC (SD & MM ) modules into BW system

Developed Open Hub Destinations to generate text files and exported into specific location.

Written Start routines, End routines and Field level based on the requirement.

Have involved in designing and development of data models and data flows in SAP BW and have used custom Infoproviders, Multiproviders, DSO, InfoObjects, Infosources, Transformations, Infopackages, DTP, Process Chains, Aggregates, BEx Queries.

Enhanced Custom data sources according to business requirement.

Developed the Master data process chains, Transactional data process chains, automated the triggering and monitoring of the same on daily, weekly and monthly basis.

Involved in Info Cube maintenance like Partitioning, Indexing, Compression and Roll-up.

Prudential Insurance

From February 2016

BW 7.3 Enhancement Project - Offshore

October 2016

Position

BW Consultant

Prudential Assurance Malaysia Berhad (PAMB) is the Asian division of a leading UK-based retail financial services group, dealing with life insurance, fund management, and consumer finance operations. Prudential used several disparate systems for managing its customer complaints.

Project Responsibilities

Enhanced data source with required fields and transported successfully to production environment.

Maintain the process chain for each enhancement.

Monitor daily loads to various data target system.

Monitor the process chain based on daily, weekly, monthly.

Manually loading and roll up data into data target.

Handling tickets with priority P1, P2, P3, and p4.

Worked in process chain to automate, delete index in cube, ODS activation, further updating, PSA request deletion and attribute change run.

Rectify the process chain due to data issue.

Worked on source system for development and production environment.

Contact this candidate