SAP BW HANA senior consultant

VENKATA S GORAKARAPU- SAP HANA / BW Consultant

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

Phone : +91-961*******

Experience Summary

• Over all 7.3 years of IT experience and Technical proficiency in SAP HANA,

SAP BW/BI.

Relevant Work Experience

• Working as a SAP HANA/BW/BI Consultant in Accenture India pvt ltd,

Bangalore from Aug 2010 to till date.

• Worked as a System Engineer in IBM India Pvt Ltd, Pune from Sep 2007 to

Aug 2010.

SAP HANA Experience

• Experience in 1 full lifecycle HANA implementation in Native HANA (HANA

Studio) and BW on HANA implementation.

• Created Technical specifications and Logical modeling documents for HANA.

• Experience in Creating Schemas, Structural packages, nonstructural

packages, Design and creation of HANA (HANA1.0 SP7) Information Models such

as attribute views, analytic views and calculation views, calculated columns,

Restricted Columns, Calculated attributes and input parameters.

• Experience in importing data from Flat files to HANA data base tables.

• Having good experience in data provisioning method SLT(SAP Landscape

Transformations) and maintained real time data replication from ECC to HANA.

• Good experience in Loading the Source system tables (Essbase, Salesforce

etc) into HANA through ETL tool BODS.

• Worked on different type’s transformations in BODS like Query, Merge,

Case, key generation, and Pivot Transformations Etc.

• Knowledge and experience on using BODS concepts like Job creation, Data

stores, Repositories, Administration, Job server,Data flows, ABAP Data flows.

• Experience in debugging execution errors using Data Services logs (trace, statistics

and error) and by examining the target data.

• Experience in creating the Decision tables for planned data using flat files.

And loaded the planned data into the Decision tables.

• Worked on multiple SAP and Non SAP source systems like SAP ECC, SAP

BW, Essbase, FlatFiles and integrated with SAP HANA system.

• Experience in creating Analytical privileges.

• Good Knowledge in SAP BOBI 4.0, information Design tool (IDT), Creating

relational connections for HANA column views and creating OLAP connections for

BW models, Business Layers, creating universes (Publishing Business layers), Webi

reports.

• Migrated HANA content (Packages, Information models)from development, testing

environment to Production environment using delivery units.

• Converted standard info providers to HANA optimized info providers

( Infocubes& DSO’s.

SAP BI/BW Experience

• Involved as a key member of project teams through all phases of realization,

go-live, and post implementation support of SAP BW in SD, MM, FI applications.

• Worked on extraction from SAP ECC,SAP R/3 4.7,Flat File

• Involved in testing and trained end-users to run reports at UAT stage

• Extensive knowledge in Design/Implementation, Data Load Management,

Process Chain and Reporting.

• Extensive Knowledge of SAP R/3 with emphasis on BI. Well acquainted with

LO Cockpit, Generic Data-Source customization.

• Good working knowledge of data modeling concepts: Star Schema and

Extended Star Schema. Have worked comprehensively in BI designing Info-Cubes,

DSO, Multi-Providers

• Customized various components in BI. Components which included Business

Content Enhancement, Data-Source Enhancements, Generic Extractors,

Transformation, DTP and Queries

Extensive work experience with performance tuning Techniques. Functionalities included

•

Aggregates, Compression, and Indexes.

Technical Skills

Operating system : Window 98/NT/2000

Data Warehouse : SAP BI/BW 7.0,7.3&7.4,SAP HANA1.0 (SP7)

OLTP : SAP R/3 4.6x, ECC 6.0.

Reporting : SAP BO BI4.0

Languages : C, SQL, PL/SQL, Basics of ABAP/4.

ETL Tools : SAP Data Services4.0

Education Details

• SSC from RKMA High School, Koppolu With 86% (2001 pass out).

• Board of Intermediate from Umamaheswara Junior College, Ongole with 93.1%.

(2003 pass out).

• B.TECH from High Tech College of Engg&Tech,JNT University, Hyderabad With

76.57% (2007 pass out).

Project Experience

Project 1:

Client Alcatel-Lucent

Project Duration Jan’13 to Till date

Environment SAP HANA 1.0(SP7),SAP BODS4.2, SAP BW 7.4,SAP ECC

6.0,SAP BOBI 4.0.

Role SAP HANA Consultant

Responsibilities

Interacting with client and onshore HANA architect for business requirements

•

gathering, functional and technical design, data model verification and UAT.

Project involved multiple source systems like SAP ECC, SAP BW, Essbase

•

(Teradata) and Flat files. Involved in integrating all source systems to SAP HANA (HANA

1.0 SP7) database using SAP Data services4.2 and SLT.

Followed Accenture Delivery methods (ADM) for Project Development activities

•

Involved in Designing and Creating Schema’s, Tables, SAP HANA models like

•

Attribute views, Analytical views and calculation views for data modeling and consume

using different BI tools.

Created calculated columns and restricted columns (KPI’s), input parameters,

•

Calculated attributes, according to the business requirements.

Identified and mapped Source database table and fields and helped data replications

•

from Source Systems to HANA using BODS.

Created HANA models for different functional areas like Headcount &Costs, Cash

•

Flows, Orders & Sales, P&L etc.

Imported data from Flat files directly into HANA tables.

•

Imported SAP BW info providers directly into HANA schemas.

•

Created Jobs, Data flows, Data stores, query transformations, merge transformations.

•

Tuned performance for large data files by increasing block size, cache size and

•

implemented performance tuning logic on sources, workflows, and data flow's.

Created Technical specifications and Logical modeling documents for HANA.

•

Involved in Unit Testing and UAT.

•

Project 2:

Client Shell

Project Duration Feb ’12 to Jan ’13

Environment SAP BI 7.0,SAP ECC 6.0

Role SAP BI Consultant

Responsibilities

Handling whole SAP BI project Independently and reporting directly to Project

•

Manager

• Handling SAP BW in SD, MM applications

Redesigned custom cubes which caused poor reporting performance,Corrected by

•

Changing Dimensions.

Daily monitoring of Process Chains and data Loads.

•

Handling Change request and new developments

•

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or

•

not on monthly Basis

Handling the end user issues on reporting.

•

Handling the issues on data loading and Extraction

•

Worked extensively on creating BI objects and Extractors .

•

Worked on performance tuning techniques to Improve Report performance

•

Created Aggregates on frequently using characteristics like Material,Sold-to-party,

•

fiscal year period, Business Area, Sales organization

Enhanced Process Chains to insert newly created objects

•

Experienced in working with Business Explorer (BEx) and publishing the reports on

•

web using Web Reporting tools.

Worked on Housekeeping activities to Improve Loading performance.

•

Used BEx to develop reports and facilitate data analysis using filters, navigational

•

attributes, calculated and restricted key figures.

Performed various tuning techniques (PSA deletion, aggregates, Compression,

•

partitioning) to optimize the query performance

Resolved different priority Remedies assigned without missing SLA.

•

Project 3:

Client Henkel,Düsseldorf, Germany

Project Duration Oct’10 to Jan’12 date

Environment SAP BI 7.0, ECC 6.0

Role SAP BI Consultant

Responsibilities:

Created Transformations, DTP’s, DSO, Info Cubes, and Multi providers.

•

Involved in writing Routines while loading cost center master data.

•

Modeled DSO’s to stage the data before transferring into the data warehouse layer.

•

• Installed 20 transaction data sources and 45 master data sources

• Designed more than 10 info cube, 15 dso,5multiproviders

• Designed 30 plus reports in SD,MM,FI applications

In LO Extraction, maintained the Extract structures as per the requirement.

•

Involved in FI & MM extraction

•

Developed Purchasing and Inventory reports on Custom and Standard Cubes.

•

Uploaded master and transactional data from files and SAP as the OLTP source

•

Customized Info Objects, Info Sources and Info Cubes.

Designed Process Chains for Batch job Scheduling for Data Loads & Updating Data

•

Targets.

Improved the query performance using techniques like Partitioning, Compression,

•

and Aggregates.

Extensively worked in building Queries using Calculated and Restricted key figures,

•

Structures, Variables with User Entry/Default Value, and Customer Exit, Exceptions,

Conditions.

Worked on transports

•

• Coordinated with SAP OLTP and Basis teams on various developments and involved in

all transportation issues.

Project 4:

Client PANASONIC

Project Duration Dec 2008 - July 2010

Environment SAP BI 7.0, ECC 6.0

Role SAP BI Consultant

Responsibilities

Panasonic used SAP ERP central component to develop a standard business process across

eight Panasonic divisions that traditionally operated independently of one another. This

standardization allowed for a single set of master data, flexible reporting and, among other

things, a consolidated invoice for the customer. Panasonic has achieved over $21 million in

operational savings over the last three years by streamlining operations and has created a

one-stop-shop for corporate clients, eliminating divisional barriers. Panasonic Business

Functions includes Accounting & finance, Sales, Order processing/fulfilment

Role: SAP BI Consultant

Responsibilities:

Coordinating with project architecture to understand the requirements.

•

Worked Extensively on Data Warehouse Workbench and customized info objects,

•

info cubes, DSOs, Data Sources, DTPs, Transformations and multi providers.

Set up periodic Data loads from legacy system (flat files),Enhanced the data source

•

2lis_02_ITM and written logic in CMOD.

Installing and creating BI objects like info objects, DSOs, Info cubes.

•

Creating and managing dataflow using DTP, transformations start routines and info

•

packages.

Data Source Enhancement according to customer requirement.

•

Designed and developed queries to generate reports in BEx Analyzer.

•

Worked extensively on query designer.

•

Extensively Worked on Lo Cockpit and performing necessary procedures like setting

•

up of update Mode, deleting set up tables, filling up of set up tables and loaded data from

ECC to BI system.

Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.

•

Created Info objects, DSO, Infocubes, Multi-providers and extracted SD data (Data

•

sources Like 2LIS_11_VAITM, 2LIS_11_VAHDR).

Project 5:

Client Toyota Motors Sales,USA

Project Duration Oct ’07 to Nov’08

Environment J2EE, JSP, Oracle Sqldeveloper, IBM DB2, Windows 2000

XP, IBM Web sphere MQ series,MQ put message,OTM.

Role Software Test Engineer.

Responsibilities:

Coordinating with project architecture to understand the requirements.

•

Creation of high level scenarios.

•

Writing Functional Test cases and Test scenarios

•

Uploading Test cases in Mercury Quality Centre 9.0

•

Preparing Test data for Development and Test environments.

•

Executing Test cases and updating status in Mercury Quality centre 9.0

•

Participating in product releases, performing production support activities.

•

Doing the Database testing by using SQL queries and verifying Reports data with

•

Database tables data.

Performing GUI Testing, Functional Testing, and Regression Testing in SIT phase.

•

Analyzing the test results and Logging Defects in Defects tab of Mercury Quality

•

centre 9.0

Participating in UAT with Business Team

•

Contact this candidate