Data Project

SUMMARY

Around * years of SAP BW/BI HANA experience including in design and

development and

experience on Native Hana (POC). Which are done using ASAP methodologies,

and provided hands-on technical expertise in the development,

implementation on SAP BI 7.0,7.3, HANA SP07.

SAP BI EXPERTISE

. Created the Info cubes, DSO(Standard Write optimized, Direct updated

DSO objects), Multiproviders, Info sets,Transformations, Info objects

Catalogs, Info objects as Data Targets, Characteristics and Key

figures info objects, Data Sources, Info packages, DTP, Error DTP.

knowledge in using ABAP to create start routines, End Routines and

expert routines, Knowledge of CMOD in SAP BW and R/3. Knowledge of

Displaying data using hana optimized cubes and pulling data from SAP

BW using Open Hub Service and transferring the data to non-SAP

systems. worked on ERROR DTP's for effective loads and Error

Handling, Monitoring Process chains. Knowledge in migration of

emulated data sources. Worked on Transports Request Management.

. Configured Flat file Extraction,R/3 Extraction. Implemented Business

content LO data sources for Sales, filled setup tables for Init loads,

scheduled V3 updates using LO Cockpit after Initialization of Delta

Processes s, Knowledge in Inventory, FI extraction. Involved in Data

Loading (Full /Initial/Delta Up-Load/ Master, Transaction data) and

Open Hub Services. Extracted data from various sources by using

Business content data sources (Enhancing Data sources) and Generic

data sources on the R/3 side.

. Performance tuning and Testing - Used RSRT Improved data load and

query performance by aggregates, compression of Requests,

partitioning of info cubes, Line Item Dimensions

Experience in various BEx Suite Components (Reporting)- Created

Queries, Calculated Key figures, restricted key figures, Structures,

Variables using Customer exits (CMOD) in BW, Exceptions, conditions.

HANA Responsibilities:

. Designed and implemented SAP HANA data modeling using Attribute View,

Analytic View, and Calculation View.

. Good exposure on Schemas, table definitions, Attributes, Measures

. Trained at in-memory data base technology i.e. SAP HANA. Having good

experience on HANA Modeling like creating package, views, Delivery

unit, Schema mapping.

. Knowledge on calculated columns in information models.

. Worked with the Import and export functions in Native HANA.

Technical skills:

ERP Packages : ECC 6.0.

Data warehouse tools : BI 7.0 and BW 7.3,HANA Studio

Operating Systems : Win 98/XP/Vista/Win7.

Professional Experience:

. Currently working with WDPF(Waandreams pixel flow) as a SAP BW

HANA Consultant From April 2011 to till date.

Project Experience:

Project:

Client : Hershey's

Project : Foods

Project Duration : February 2014 -till date.

Role :SAP BW HANA Consultant

Client Information : The Hershey Company, known until April 2005 as

the Hershey Foods Corporation[3] and commonly called Hershey's, is the

largest chocolate manufacturer in North America.[4] Its headquarters are

in Hershey, Pennsylvania, which is also home to Hershey's Chocolate World.

It was founded by Milton S. Hershey in 1894 as the Hershey Chocolate

Company, a subsidiary of his Lancaster Caramel Company. Hershey's products

are sold in about sixty countries worldwide.[4][5] In addition, Hershey is

a member of the World Cocoa Foundation.

Responsibilities in Implementation:

. Worked with Data analysis and Data harmonization of Data in source

system.

. Workbench, InfoObjects, DSO, InfoCubes, InfoPackages.Experience with

SAP BW version 7.0/7.3 Data Modeling

. Hands-on Experience with ABAP program Debugging and experience with

performance tuning.

. Strong analytical and conceptual design skills; strong problem-solving

skills

. Worked on all Landscapes like development, testing, quality &

production system during the Implementation.

. Conducted various meeting with business and management team to have a

good hands on the Development flow.

. Handled important tasks like transportation, developing objects during

the implementation.

. Involved in team meetings like Client meeting, Internal meeting about

the status pending works or for Issue resolution or for business up

gradation etc.

. Strong experience in Extraction & Modeling (configure BW - info

providers, DTPs, DSOs, data sources, etc).

. Build InfoCubes, DSO Objects, PSAs, Multi-Providers, Info Packages.

. Perform transformations (BI7), DTP, Aggregates, Open Hub Service, and

Business Content activation

. Execute data loads including Info Package scheduling, delta/full

updates, DSO data activation, data load in cubes, aggregate roll-ups

. Activate, Configure & Customize (extending) Generic and Business

Content Extractors

. Drive Performance Tuning of Queries through Aggregates, InfoCube

Compression.

. Understanding of core data warehouse concepts and excellent experience

in data modeling

. Involved in Data Loading (Full /Initial/Delta Up-Load/ Master,

Transaction data) Extracted data from various sources by using

Business content data sources(Enhancing Data sources) and Generic

data sources.

Project:

Client : Apollo Tyres Ltd

Project : Manufacture(Proof of Concept on HANA)

Project Duration : October 2013 - February 2014 (4months)

Role : SAP HANA Developer

Client Information : Apollo Tyres Ltd is the world's 17th biggest tyre

manufacturer, with annual consolidated revenues of Rs 121.5 billion (US$2.5

billion) in 2011. It was founded in 1976. Its first plant was commissioned

in Perambra, Kerala. The company now has four manufacturing units, one in

South Africa, two in Zimbabwe and 1 in Netherlands.[16] It has a network of

over 4,000 dealerships in India, of which over 2,500 are exclusive outlets.

HANA Responsibilities:

. Good understanding of various components of SAP HANA.

. Having strong knowledge on SAP HANA Data Modeling using Attribute

Views, Analytic Views and Calculation Views (both Graphical & SQL

script based) & SAP HANA Data Provisioning using SAP LT Replication

Server (SLT).

. Good exposure on Schema mapping in HANA.

. Worked with transportation of packages and Worked with the Delivery

units.

. Worked with Import and export functions in HANA studio.

. Worked with calculated columns in views.

Project:

Client : Apollo Tyres Ltd

Project : Manufacture

Project Duration : May 2012 - Oct 2013(17 months)

Role : Associate consultant.

Client Information : Apollo Tyres Ltd is the world's 17th biggest tyre

manufacturer, with annual consolidated revenues of Rs 121.5 billion (US$2.5

billion) in 2011. It was founded in 1976. Its first plant was commissioned

in Perambra, Kerala. The company now has four manufacturing units, one in

South Africa, two in Zimbabwe and 1 in Netherlands.[16] It has a network of

over 4,000 dealerships in India, of which over 2,500 are exclusive outlets.

BW Responsibilities:

. Prepared end to end documentation for the running project.

. Worked on all Landscapes like development, testing, quality &

production system during the Implementation.

. Prepared knowledge based documents and applied in the portal to avoid

frequent issues from users.

. Generated various reports to understand the system performance by

knowing background jobs, CPU utilization, memory used etc.

. Performed delta queue draining during the system maintenance.

. Performed data volume management in testing & production system.

. Performed monthly activities like selective deletion, PSA deletion,

flushing queues etc.

. Involved in ABAP related to BI such as debugging of code through DTP.

. Involved in every day support, monitoring the production batch,

resolving the batch tickets etc

. Involved in Top Down approaches while there was any data mismatch or

documents discrepancy.

. Involved in data Scheduling, uploading full data and delta data into

providers, Monitoring and error handling.

. Monitored daily jobs and resolved issues without SLA breach.

. Performed Production Outages like handling the production batch, Delta

queue draining etc.

. Worked on all severity tickets in batch tickets and user tickets too.

Project:

Client : Mettler-Toledo

Project : Manufacture

Project Duration : April 2011-May 2012(13 months)

Role :Consultant

Client Information: Mettler-Toledo (NYSE: MTD) is a global manufacturer

of scales and analytical instruments. Mettler Toledo is the brand name

whereas Mettler-Toledo (with dash) is the name of the company. The company

consists of several operating divisions in North America and Europe.

Mettler-Toledo specializes in the area of precision instruments for

professional use. Mettler-Toledo laboratory instruments are used in

research, scientific, drug discovery, and quality control labs, amongst

many others in the pharmaceutical, chemical, food and cosmetics industries.

Responsibilities in Support Project:

. Data extraction and Loading in to reporting databases.

. Involved in the creation and maintenance of Info-Objects, basic Info

Cube, MultiProviders, DSO objects, Data Sources, loaded Master data

from flat files and from OLTP environment.

. Created transformations and Info Packages to load data, installed

Business Content objects according to the requirements.

. Involved in performance issues like maintaining Aggregates to the

cubes.

. Extensively involved on extracting data from SAP R/3 Using Generic

Extraction, Logistics (LO).

. Created reports with restricted key figures and calculated key figures

using formulas.

. Created Reports with variables, Filter and Free characteristics,

worked with conditions and exceptions.

Education:

University/College Degree Year

JNTU - Hyderbad Information Technology 7/2010

Cross Skills:

Serial No Name Period

1 SAP HANA 10/2013

3. SAP BW 7.3 06/2013

4. SAP BW on HANA 04/2014

Education:

> Bachelor of Technology in Information Technology (2010), JNTU, India.

Contact this candidate