NAREN

SAP HANA CONSULTANT

acpeqa@r.postjobfree.com

Mobile: 860-***-****

Professional Summary

. Over TWELVE (12) years of professional experience in the development

and Implementation of the business applications with extensive

experience in SAP HANA 1.0 SPS 9,BODS,SLT,MODELLING, BW7.3 /BI 7.0 BW

3.5, Business Objects tools / ERP (SAP)/ SAP ECC /SAP CRM as a

techno functional consultant.

. SAP HANA: 2 years' experience in designing, developing and maintenance

of persistent models (Schemas, Tables, Views), SAP HANA STUDIO-

Information Models (Attribute Views, Analytic views, Calculation

Views, SQL Script based Calculation views, Hierarchies, Decision

Tables), Data Provisioning (Flat File, SAP Landscape Transformation

for SAP & Non-SAP, Data Services, Direct Extractor Connections), Text

Search (Full text search, Freestyle search, Fuzzy Search), SQL

(Procedures, CE Functions, SQL Scripts), Migration of BW Database to

SAP HANA (Hardware Sizing, prepare/export/import, BW Data Conversion,

SAP BODS (Data Services 3.2,,4.1, 4.2)

. 5 years' experience in delivering data warehousing and analytics

solution on using using SAP BW/ BI 7.3 . Customized Info Objects, Info

Sources, DSO objects, InfoCubes, Multi-Providers,complex

Transformations and DTPs in Extended Star Schema, OLTP Extractions

from SAP R/3 & analytics platforms. Extensive development experience

involving in Implementation & Support. Proficient in Business Objects

tools - Universe Designer, Web Intelligence, Crystal Reports, Live

Office and Lumira. Completely utilized various features in the

Business Objects Web Intelligence and Crystal Reports such as Pre-

defined Filters, Prompts, Cross-Tab, Hierarchies, Drill Down, Charts/

Graphs, Report layout/ format features etc.

. 5 years' experience in Software Design, Development, Project

Management, and Maintenance of ERP (SAP) and E Commerce applications

and SAP CRM Implementation combined with extensive experience in

enterprise application software and testing skills

. Worked closely with Client and the Business user throughout the whole

life cycle of the implementation and consulting, Excellent Client

facing Skills

. Participated in large and small inter-disciplinary teams, including

managing information flow and facilitating quick collaborative problem

solving across organizations.

Professional Skills

Designed, developed, implemented, maintained database, data processing,

application layer platform (web based) using the latest In-memory Appliance

SAP HANA 1.0 SP 9. Expertise in BODS, SLT, MODELLING. Worked extensively

in SAP BW/ BI 7.3, OLTP Extractions from SAP R/3 for FI, MM, SD and Generic

Extractions. SAP CRM & R/3 SD, Proficient in Business Objects tools -

Universe Designer, Web Intelligence, Crystal Reports, Live Office and

Lumira. SAP CRM Service, CRM functional and technical design and functional

enhancement, customization of Sales transaction.

ERP

SAP ECC 6.0,R/3 4.7, R/3 4.6C

ETL Tools

SAP BODS 3.2,4.1,4.2,SAP BW 7.31, SAP BW 7.3,BI 7.0,

BW 3.5/3.1C/3.0B/2.1C, SAP BO 4.0/3.1 XI

SAP Products

HANA 1.0 SP9, SD, FI/CO, COPA, HR, MM, PM, Closing Cockpit.

Reporting

BO 4.1 Explorer,BEx Analyzer, BEx Reporting (BI 7.0/BW 3.5), Query Browser, Web

Reporting, Web Rich Client, Web Intelligence, Crystal Reports, Live Office, Central

Configuration Manager (CCM), CMC (Central Management Console), Dashboard manager,

Xcelsius 2008,Lumira

Client - ConAgra Foods Inc. Omaha, Nebraska

Feb 13 to Present

ROLE: SAP HANA CONSULTANT

ConAgra Foods, Inc. is an American packaged foods company headquartered in

Omaha, Nebraska. They are in Food processing Industry producing a wide

array of food products under various brand names that are available

globally. It is the one of the leading food companies and the largest

private label food business in North America.

Responsibilities:

. Review and gather business requirements and interpret these into an

architectural design and information model in SAP HANA SPS 9

environment

. Participated in Blueprint and design sessions, review options and

provide recommendations while communicating the benefits, risks, and

constraints to both the business and IT stakeholders and implemented

Best practices for modeling.

. Administration and operation including monitoring, backup and restore,

security and user management

. Worked in SLT -Data provisioning like Real time replication, schedule

by interval, schedule by time using SAP HANA Studio.

. Created Packages and worked in Attribute views, Analytic views and

Calculation Views based on replication data using HANA modeler.

. Worked on Restricted, Calculated columns, Variables and Input

Parameters,Semantics-hierarchy, Currency conversions

. Worked extensively in SAP BODS (Data Services) involving data

Integrator mappings to load the data warehouse, the mappings involved

extensive use of simple and complex transformations like Key

Generator, SQL Query Transform, Table Comparison, Case, Validation,

Merge, lookup etc. in Data flows

. Worked extensively on all features of HANA SPS 9 views like Import,

Export, Mass copy, Redeploy, Switch ownership, Change authoring-

mapping of schemas, Maintain specific default schemas,joins,Decision

tables, Smart Data Access from various data sources

. Worked with various transformations like Query, SQL, Key Generation,

Merge, Case, Map Operation and Table Comparison in Platform and DI

Transforms and extracted data according to the business rules and

Technical Specifications

. Experience in Stored Procedure, SQL plus, PL/SQL

. Improved the performance and reduced the coding by learning and

implementing use of CE functions

. Developed existing reports in HANA.

Project : Development, Enhancement, ETL Migration, Reporting

Environment: SAP HANA 1.0 SP 9, SAP BW 7.3, SAP BODS (Data Services

4.1,4.2)

Client - Whirlpool Corporation, Michigan

Oct 11 TO Nov 12

Role: SAP BI/BW Consultant

Whirlpool Corporation is the world's leading global manufacturer of home

appliances with $19 billion of sales in 2013 with 69,000 employees,

operating in more than 170 countries. The company markets Whirlpool,

Maytag, Kitchen Aid, Jenn-Air, Amana, Brastemp, Consul, Bauknecht and other

major brand names.

Responsibilities:

. Implemented Full life cycle implementation.

. Design and implement the integration of SAP HANA with SAP Business

Objects including design and creation of BO reports and supporting

universes.

. Completely utilized various features in the Business Objects Web

Intelligence and Crystal Reports such as Pre-defined Filters, Prompts,

Cross-Tab, Hierarchies, Drill Down, Charts/ Graphs, Report layout/

format features etc.

. Identified and activated SAP business content required for the

Infocubes, created customized Info Objects, Info Sources, DSO objects,

InfoCubes, Multi-Providers and complex Transformations and DTPs.

. Worked on sales COPA Profitability Analysis and created customized

extractors and creating data sources related to FI and HR as per the

client requirement.

. Worked extensively on HR, loaded the data from ECC to BI and used

initialization with delta update and full update methods

. Created Start routines and End routines in transformations to update

characteristics and key figures in the InfoCubes to facilitate various

reporting requirements.

. Created Process Chains to automate the loading process for master data

(attributes, texts and hierarchies) and transactional data (with Delta

loads).

. Used BEx Analyzer to Create Queries with Variables, Filters,

Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions

with Charts and Worksheets to access data from BI/BW Data Targets to

Generate Reports.

. Worked on COPA reports, performance tuning and troubleshooting of BI

issues, connector issues and reporting errors.

. Involved in resolving day to day Production issues and also

coordinated with onsite team and Business.

. Provided training sessions to the business end user according to their

requirements.

Project: Implementation and Production Support, Reporting

Environment: SAP ECC 6.0, SAP BI 7.2/7.3, BO 4.0

.Client - Yancoal

Oct 10 to Aug 11

Role : SAP BI/BO CONSULTANT

Yancoal is a growing, Australian based Coal Company known for its

innovative, technologically advanced approach to environmentally

sustainable coal production. They focus on advanced coal mining technology

including Ultra Clean Coal, Premier Char and Long wall Top Coal Caving make

us one of the world's most innovative coal companies.

Responsibilities:

. Designed and maintained Standard and Custom Info Objects, Info Cube,

DSO, Multiprovider, Info set,Data Extraction, Data sources, Info

Package, Transformation and Data Transfer Process

. Loaded Master data and Transactional data from flat file, multiple

Data Sources to multiple DataTargets with different Transformations

and DTPs by scheduling different updates, configuring data sources in

R/3 using LO-Cockpit and implemented Full and Delta loads with

different Update mode.

. Created process chain, Aggregates and indexes to improve Query

Performance. Worked with Transportation to transport work bench

request from Developing system to Quality system

. Worked with Transportation to transport work bench request from

Developing system to Quality system

. Worked extensively on Bex Query Designer and Query Analyzer using

Variables.

. Creation of BO reports (specifically WEBI and Explorer reports), and

supporting universes.

Project: Global Standardization Project and Production Support

Environment : SAP ECC 6.0, SAP BI 7.2/ BO 4.0

Client - Stora Enso, FINLAND

APR 09 to Sept 10 Role: SAP BI/BW Consultant

Stora Enso is an integrated paper, packaging and forest products company

producing newsprint, magazine paper, fine paper, consumer board, industrial

packaging and wood products. Stora Enso's sales totaled EUR 10.3 billion in

2010.

Responsibilities:

. Expertise in OLTP extractions from ECC6.0 using Sales and

Distribution, Material Management.

. Worked on Business Content Data Sources and Generic data sources.

. Created process chains as per the requirement.

. Involved in customization of objects like Info Cubes, and info

objects, transporting the objects in the landscape.

. As per Client requirement involved in designing BEx Reports using

Formulas, Calculated Key Figure and Restricted Key Figure.

. Designed, developed, and implemented BI Objects like Info Cubes, DSO

related.

. Improved the query performance by creating aggregates, compression and

creating indexes.

Project : Implementations and Production Support

Role : SAP BI/BW Consultant

Environnent : SAP R/3 ECC 6.0, SAP BI 7.2, SD, MM, BEX Reporting

Client - Havells India Limited

Aug 07 to Mar 09

Role : SAP BI/BW Consultant

Havells India Limited is a $1.3 Billion leading Fast Moving Electrical

Goods (FMEG) Company with a strong global footprint. Its global network

constitutes of 6500 professionals across 91 branches & representative

offices in over 50 countries. Its 11 state-of-the-art manufacturing plants

in India and 7 world class manufacturing plants located in Europe, Latin

America, Africa & China manufacturing globally acclaimed products,

synonymous with excellence and precision in the electrical industry.

Responsibilities:

. Expertise in OLTP extractions from ECC6.0 using Sales and

Distribution, Material Management.

. Worked on Business Content Data Sources and Generic data sources.

. Created process chains as per the requirement.

. Involved in customization of objects like Info Cubes, and info

objects.

. Involved in transporting the objects in the landscape.

. As per Client requirement involved in designing BEx Reports using

Formulas, Calculated Key

. Figure and Restricted Key Figure.

. Designed, developed, and implemented BI Objects like Info Cubes, DSO

related.

. Improved the query performance by creating aggregates, compression and

creating indexes.

Project : Implementations

Environnent : SAP R/3 ECC 6.0, SAP BI 7.0, SD, MM, BEX Reporting.

Client - MRF LTD, Chennai

April 06 to June 07

Role: SAP Consultant

MRF Ltd manufactures the largest range of tyres in India and exports to

over 65 countries worldwide. SIEMENS is involved in the implementation of

SAP in MRF. MM, SD, FI, CO, PP, PM, PLM, PS, QM, HR, Payroll modules are

being implemented along with EP, XI and BI

Responsibilities:

. Involved in developing Technical specification by understanding the

Functional requirements. Developed critical invoices pertaining to

SD Module for Tyredrome service Invoice which will be used whenever

the stock has been received or sent the entry will be made based on

the Invoice Receipt for the vehicle

. Involved in developing the sales report on daily basis which will be

run daily for the detailed sales report for the products such as Tire,

Tube and Flap which has been sold out for plant wise, customer wise,

material group wise, country wise and material wise in SD Module

. Involved in developing smart forms in FI Module for displaying RCS

Account statement which in turn give the detailed account summary for

all the customers under the particular plant for the given period

. Involved in creating multilevel BOM report in PP Module making a copy

of standard report in order to add the logic to add few more fields

since the standard does not met the customer requirements.

Project : SAP ECC 6.0 Onsite Implementation

Environment : SAP ECC 6.0, Oracle 10g

Client- John Keels Holdings, Srilanka

Feb 05 to Jan 06

Role: SAP Asso.Consultant

John Keels Holdings PLC (JKH) is Sri Lanka's largest business group and a

leading investor in the country's economy. SIEMENS was involved in the

implementation of SAP in HR module predominantly.

Responsibilities:

. Involved in Developing Cumulative No pay days Report which will give

the employee with number of days that has been cumulated for No pay in

Payroll Module

. Involved in Developing Coin analysis Report which will display the

amount in the given denomination for the total amount that has been

calculated in PY Module

. Developed Hiring letter, Settlement letter & Increment Letter in HR

Module using Smart forms.

Project : SAP R/3 4.7c Implementation

Environment: SAP 4.7c, Oracle DB

Client - World Tyres Colombo, Srilanka

May 04 to Jan 05

Role: SAP ABAP Developer

World Tyres, markets the tyres and tracks manufactured by Loadstar across

the globe. SIEMENS was involved in the implementation of SAP in world

tyres. MM, SD, FI&CO modules are being implemented. Since its just

marketing products of Loadstar modules like QM and PP were of no relevance

as it had been already implemented at Loadstar.

Responsibilities:

. Involved in developing report for Downloading of purchase orders

. To enable the user to download all the Purchase order into the

preferred document in MM module

Project : SAP R/3 4.7c Implementation

Environment : SAP 4.7c, Oracle DB

Client - Satyam

April 2003 to Feb 2004

Role - SAP CRM Asso. Consultant

Responsibilities:

. Build Competency with a Strategy

. Project Scoping

. Estimation

. Project proposal for GE - Implementation & post Production support

. Saint Gobain - Production Support & implementation

. Pre-Sales activities

. Used Solution manger 3.1 for implementation Project

. Project proposal, Client meeting, Initiating talks & client Demo

. Installation of Sand box CRM 4.0 with all the modules implementation

with integration

with R/3

Client - Xansa

May 2002 to March 2003

Role - SAP CRM Asso. Consultant

Responsibilities:

. Xansa's SAP Business Processes Definition and Assessment

. mySAP CRM Implementation Service Process

. Xansa-Resource planning

. Competency output & Vision

. Training Documents

Client - Hewitt, Chicago

March 2000 to Aug'2000

Role - Programmer

Responsibilities:

. Low level Design with Rational Rose 2000 for Questionnaires Module

. Writing of Test Cases for the same

. Using Visual age Java tool coded programs using Swing Components

. Development of client side programs using JAVA SERVER PAGES (JSP)

. Design of programs using parsers to retrieve the XML file and display

for the user using JAVA SERVER PAGES (JSP)

. Development of client side validation using JavaScript and designing

with HTML

. Development of JDBC connectivity and Database transaction with DB2.

. Client side validation using Java Script

. SQL commands were used to update, retrieve data from database.

. Session bean and entity bean was done with EJB

Environment: Java (JDK1.2), Swing, IBM VISUAL AGE for JAVA, Java Server

Pages (JSP), Servlets, EJB, Rational Rose 2000, JDBC, Dream Weaver, Java

script, XML, HTML, DB2, MS-SQL, Windows-95.

Client - Orient Express, Portugal

March 99 to Feb 2000

KG Information System, Coimbatore - Knitxpress

This company has three main products for sale such as Knitxpress,

Bagxpress, Watchxpress, This includes complete designing of the site and

makes the site user friendly for selecting the products and allowing the

user to select the features respectively to each products based on user

discretion. There is chatting module to ask queries to the company by the

client.

Responsibilities:

. Involved in client side validation using JavaScript and designing of

the screen using HTML

. Involved in browser compatibility for the programs

. Chatting module was done using Java (JDK 1.2)

. Screens were developed using AWT

. Applets were also used to design the GUI screens

Client - Advanced E-commerce Solutions

Feb 97 to March 99

. Involved in client side validation using JavaScript

. Involved in designing of the screen using HTML

. The server side programs was done using servlets Involved in

developing JDBC connectivity and Database transaction with Ms Access

Environment: Java (JDK1.2), Servlets, HTML, Java script, JDBC, MS Access,

Ms-SQL, Windows'95

Contact this candidate