SAP Experience – Summary

Over **+ years of experience, with over 5+ years in SAP BODS, 5 years in SAP BW/HANA (SAP HANA Certified) with 2 year in ABAP.

SAP BODS:

Expertise in Data warehouse development working with Data Conversion and Extraction/Transformation/Loading using SAP Data Services with SAP ECC, SAP BI, Oracle, SQL Server and files as sources.

Data warehousing experience using BODS (ETL), Designer, Management Console, Repository manager.

Extensively used BODS designer tools like Projects, Jobs, Workflows, Data flows, Data Store and Formats.

Used different performance tuning techniques like Parallel processing, Multi-Threading, Partitioning etc. to improve the extraction and loading performance.

Developing the Transforms and Data Flows based on the specifications.

Extensively worked on Data Services Designer Components-Jobs, Transforms, Data Stores, built-in functions and Custom Functions.

Worked on Data Profiling and Data Cleansing using Data Services Designer.

Preparing the documentation for the mappings according to the business requirements.

Involved in different cycles of testing including Unit testing, IT, Regression & UAT

HANA Modeling:

Expert in SAP HANA Data Modeling.

Extensively used HANA Information models like Attribute Views, Analytical Views & Calculation Views, also used SQL Script for complex transformations in Calculation Views

Extensively Worked on SAP HANA Data Provisioning Techniques ETL (BODS), SLT & Flat Files

Worked on HANA Live content installations, enhancements.

Created Universes using BOBJ IDT (Information design tool).on top of HANA calculation views and consumed them in Lumira dashboards and Webi reports

Knowledge in Creating Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development.

SAP ABAP Experience:

On-site Mannheim, Germany on Manual Remediation of parsed custom objects effected

by Auto tool.

We are in part of Tool development for smartShift named SAP Transformer Tool.

Followed major organization standards to implement SAP Projects where we can

Give full satisfaction and support to our clients.

Extensively worked on User Exits, Function modules, Reports, BDC, LSMW, customer exist.

ABAP/4 experience includes business requirement analysis, program design, coding,

Validation, configuration, testing, user training and documentation.

Experienced in review of development requests, writing technical specifications and

Technical documentation.

Worked on Offshore projects and experienced in coordinating with on-site resources for

Delivering development objects.

Good working experience in SAP SD, MM, SRM and FICO.

SAP BW:

Hands-on experience in design and maintenance of Info Providers like Info Objects, ODS Objects, Info Cubes, Remote Cubes and Multi Providers.

Good experience in analyzing and extracting data from SAP R/3 into BW using different extraction structures such as LO-Cockpit SD, PP, MM functional areas including development of complex customer exits to support extended extractor structures on SAP R/3 side.

Worked extensively on designing and developing generic extractors in R/3.

Worked on Open Hubs to extract data out of BW as flat files to Downstream systems

BW Statistics set-up. Involved in performance tuning activities like Aggregates, Indexes, Compression and Partitioning.

Extensively worked on Process Chains for loading Transaction and Master Data.

Monitored data loads for Cubes and ODS and effectively handled many data loading errors during data load.

Experienced in Report generation - worked extensively in BEx Analyzer, Query Designer, Web Application Designer, Info set queries, Jump analysis using RRI and virtual characteristics and virtual key figures.

Designed and developed custom queries using Cell Definitions, Conditions, Exceptions, Customer exist, Replacement path Variables, Structures, Restricted and Calculated Key figures.

Expert in ABAP and well versed with the BW context of creating start routines, end routines, expert routines, Class/Objects and BADI.

Worked with SAP BOBJ, WEBI and Universes.

Worked on multiple BW upgrades (BW3.x to 7.x including BW7.4) and HANA migration projects.

Consumption of HANA information Models in BW by creating Composite and Transient Providers.

Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.

Excellent communication, interpersonal, positive work attitude and self-motivated to work independently as well as in a team. Good understanding of both business processes and technical development.

BI/BO Reporting: Knowledge on integrating Business Objects with SAP and non-SAP systems.

Created Universes using BOBJ IDT (Information design tool) on top of HANA calculation views and developed the Web Intelligence reports.

Education / Certifications / Blogs

Master of Computer Application in Osmania University, India

HANA Certified: C_HANAIMP151 Application Associate - SAP HANA (Edition 2015)

Open SAP Certified in Big Data with SAP HANA Vora

Open SAP Certified in Text Analytics with SAP HANA Platform.

SAP Blogs: https://blogs.sap.com/2015/01/05/enhancement-to-send-po-output-to-multiple-vendor-contacts-in-srm/

SAP Project Experience

Customer

Mohawk, Atlanta, Ga (MAR 2017 to Till Date )

Industry

Manufacturing

Project Description

UNILIN and IVC Carve out

Role

BODS and HANA Consultant

Description:

Client is a Retail in Flooring and manufacturing solution provider located in Atlanta Ga US, offers hundreds of top-quality products made with recycled and renewable resources.

The goal of project is to remove the BW system and taken all the ODP extractors through BODS to HANA . Multiple source systems into HANA Mart and Universe and Webi reports

Roles and Responsibilities:

ECC/BW extractor are pulling to BODS using ODP concept, worked on FI-GL, COPA, Sales Inventory and Master data.

Delta mechanical implemented in BODS and create Historical load mechanism and Initiation without data transfer using sap standard function sap_extractor_delta_initialize.

Written the control scripts for data loads, and build the Custom Function for difficult calculation and reusability.

3 ways of data storing in BODS as Landing (Extract all the data in the landing table), EDW (BW Calculation) and MART tables in HANA.

Scheduled the jobs in Tidal as per the BW process chain working, and promote objects to 3 levels of environments. Before we promote we tested all jobs are working as per the BW.

Creating Analytic and Calculation views in SAP HANA and merge with existing views in Cal view. Master data and calculations are done in Analytic view.

Creating Currency Conversions in HANA to convert the amounts from local currencies to USD Hierarchy creations in HANA based on the requirement.

Understanding the reporting requirements of the client and implanted in Webi.

Using filters for data restrictions and creating calculated columns to get desired data values.

Testing - unit testing of the before delivering to the clients.

Prepared technical specifications for the development of data integrator (ETL) mappings to load data into various target tables and defining ETL standards.

Analyzing requirement and co-ordinate with offshore team clarifications if required .

Customer

Stanley Black & Decker- Indianapolis (Jun 2016 to Feb 2017)

Industry

Manufacturing

Project Description

GEMS-Phase2 Financial Transformation

Role

BODS and HANA Consultant

Description: This phase of the Finance Transformation BA&R Project will further enhance the capability of BA&R by transitioning the source systems that were out of scope during the original GEMS wave by fully integrating into the BA&R environment. Specifically, this phase will include the following objectives:

Roles and Responsibilities:

Source enhanced dimensionality such as Product, Customer & Brand for commercial entities

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Loading Data into the SAP HANA Database using SLT, BODS and DXC. Bringing Data from ECC and Flat files, also implemented Data Flows in BODS.

Transported HANA content from development, testing environment to Production environment using delivery units.

Integrating HANA views with Reporting tools like SAP Lumira.

Automate FDM feeds for in-scope source systems so that the data for BA&R and HFM are extracted at the same time from each source systems.

Involved in extracting data from flat files and MS-SQL.

Created re-usable components like Workflow, Data flows and batch jobs.

Worked with Data Integrator and Platform Transforms.

Good exposure on Query and Merge transform.

As per mapping specification we implemented Case, Validation transforms.

Extensively worked on mappings with BODS Transformations like Map Operation, Table Comparison, History Preserving, Key Generation, Pivot, Reverse Pivot etc.

Used Data Services inbuilt functions like Aggregate, Date and Lookup Functions.

Used Central Repository to Check-In and Check-Out of the Jobs to maintain version history and for multi-user development.

Worked on SAP ECC and extraction the data from Tables and Idocs.

Implemented type 1 and type2 slowly changing dimensions in several jobs.

Customer

CareFusion(BECTONDECITION),CA, Sandiago (Feb 2015 to April 2016 )

Industry

Health Care Industry

Project Description

REPLICATION SAP TABLES, SQL SERVER DATA USING BODS

Role

SAP BODS Consultant

• Implemented Master Data Management (MDM 1.2) project

• Good experience in implementation of Data Quality Components like Address Cleanse, Data Cleanse and de-duplicate of Master Records.

• Conversion of ABAP Programs into possible BODS ETL Logic

• Designed Standard FSD and TSD and got approved by client.

• Implemented Geocoding Services with real time job as an alternative to Yahoo Path Finder

• Implemented Infection Prevention interface to address Dashboard’s requirements

• Implemented integration b/w SAP BODS and QlikView by generating .QVD file.

• Performed Migration of Several SSIS Porting Conversions into SAP BODS.

• Performed Migration of SQL Server 2005 to SQL Server 2012 and resolved Data conversion issues.

• Performed Migration of Oracle Database to SQL Server 2012.

• Implemented upstream and downstream SFDC jobs.

• Handling MDM and other BODS Interfaces support tickets with ServiceNow Interface.

• Implemented EDW SAP ECC6.0 SD interface for SAP BW.

• Performed Data Extraction from OHD and Underlying tables of infocube for SAP BW as a Source system.

• Performed Data loading into Datasources 7.x for SAP BW as a Target.

• Handling MFT and EFT of Source files for BODS once gets processed Via GoAnywhere MFT Tool.

• Implemented MFT and EFT jobs and scheduled BODS Jobs.

• Implemented MFT jobs to Transfer files from one server location to another server location.

Customer

COCA-COLA (Mar 2014 to Jan 2015 )

Industry

Manufacturing

Project Description

CONA Built Data Migration

Role

SAP DATA MIGRATION Consultant

Description:

Coca-Cola is a carbonated soft drink sold in stores, restaurants, and vending machines throughout the world. It is produced by The Coca-Cola Company of Atlanta, Georgia, and is often referred to simply as Coke. CONA, or Coke One North America, has build and deploy a common North American Coke One operating system that enables a positive and consistent experience for our customers and our associates, and drives Direct Sales Delivery process efficiencies for bottlers. . The full scope of the projects includes CONA deployment for four bottlers, including CCR, Coca-Cola Consolidated, Coca-Cola United, and Swire Beverages.

Roles & Responsibilities:

Used Pivot and Reverse Pivot Transforms, to map the columns according the Dashboard Schema tables as per Dashboards requirement.

Implemented version management on top of the BODS local Repository by using the Central Repository (Secured)

Loaded sample data and tested the ETL for both Standard and Customization, tested and refreshed standard reports with sample data for testing

Recovering Data from Failed sessions and Workflows.

Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.

Worked on the check in and checkout of the objects. Managed the version control

Created Scripts, Jobs, Workflows and Data Flows according to their Business and implemented their business logic using SAP Data Integrator

Preparing the Technical Specification Document based on the provided Functional Specification.

Configure the Central Repository for the purpose of Importing jobs and project and checkout and check in.

Used Pivot and Reverse Pivot Transforms, to map the columns according the Dashboard Schema tables as per Dashboards requirement

Implemented version management on top of the BODS local Repository by using the Central Repository (Secured).

Work with operation different push down operation to increase the performance.

Customer

FARO Technologies, US (Apr 2013 to Feb 2014)

Industry

Manufacturing

Designation

SAP BW/HANA Consultant

Description:

•The produced, among others, FARO, mobile 3D – Mess technik has prevailed in recent decades in industrial production. It has over conventional measurement techniques (measuring table, calipers, gauges, gauges etc.) a number of advantages. With mobile 3D metrology, it is possible to perform measurements of components and systems on the shop floor or in the manufacturing process. Thus, production errors can (inaccuracies, standard deviations) recognize more quickly than with conventional quality assurance, since the measurement can be performed directly on the component without moving this into a measurement space where the measurement would be performed with traditional 3D coordinate measuring machines.

Roles & Responsibilities:

Extensively worked on HANA Studio and Modeling by exposing BW Models as well as on HANA Models

Imported BW Models as HANA models, expanded them, created back-up of BW Models in HANA and re-imported, Imported Analysis Authorizations and leveraged BW based data level security.

Created HANA Models like Analytic View, Calculation view, Attribute views and Security roles and authorizations

Extensively tested Explorer features with the data from HANA/BW Models on BW on HANA

Created several Information Spaces, Views and View sets with geographical dimensions.

Worked on BW transport management

Expert on BW transport like collected all Objects and validated using SE09 T-Code

Used STMS T-Code, to transport all objects from DEV to QA and done Unit testing

Transported objects from DEV sys to PRD sys, after completion of UAT from client by using STMS T-Code

Resolved issues while importing transport requests from DEV to QA and DEV to PRD

Developing flows from info-objects to Multi Providers.

Migrated Master Data 3.x data flows to 7.x, after data load, transported them to QA and PRD

Worked on standard data source enhancement from ECC and replicated them in BW for Inventory Management.

Worked on Multi Providers, Info cubes, DSOs, transformations, DTPs in order to meet the end user reporting requirements.

Installing Business Content Info Cubes and DSOs and used BC Data sources.

Involved in deploying the mapping document, detecting the Field-to-Info Object mapping.

Working on Data Extraction from SAP R/3 using Generic, LO Extractions, Data Loading (Full/Delta Upload).

Creation of Generic Data Sources from table, view.

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

Worked on error stack DTP.

Created Aggregates and used Line item dimensions to increase the performance of the query.

Performance tuning by compressing the cubes and creating batch indexes.

Creating Structures for reusable purpose, creating Conditions & Exceptions analyze reports.

Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.

Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System( R/3)

Worked with transactional Data Info Sources to load data from SAP R/3 and Flat Files into SAP BW.

Involved in activating Business content for Standard info Cubes, Info Source& Info Objects of Sales and Distribution as per the Client Requirements.

Created Info Packages and Info Package Groups and scheduled them in order to Load Master Data and Transactional data from SAP R/3 as well as Flat File Source Systems into BW.

Worked with PSA in Monitoring the Data Transfer from Source System into BW.

Involved in Performance Issues like Creation of aggregates, Roll Up and Compressed the Info Cube to improve the query response.

Involved in solving the tickets regarding extractions, Performance Issues and also load failures.

Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

Maintaining Work History for all the tickets until it is closed down.

To inform the onsite people if there any deadlocks.

Resolved Customer reported tickets through email and phone.

Customer

TESORO USA (May 2012 to Mar 2013 )

Industry

OIL and GAS

Project Description

SAP BW/HANA Implementation/Support

Role

Implementation BW model and reports in SAP BW 7.4(BW on HANA)

Roles and Responsibilities:

Created attribute, analytic and calculation views as part of the current project.

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

Replication of the selected tables of MM from ECC to SAP HANA. Performed transformations during the replication process.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE (In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Migrating standard Info cubes to in memory optimized Info cubes using migration Tool.

Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.

Importing the BW Models in to HANA using HANA Studio.

Consuming the HANA Models in BW by creating the Transient Providers.

Transport the object to QA and production environment.

Customer

SBD (Stanley Black & Decker) (July 2010 to April 2012)

Industry

Manufacturing Industry

Designation

SAP BW Consultant

Description:

Stanley Black & Decker provides the tools, solutions, and services that the world counts on when it really matters. Build the tools that build and repair your home and car, they build the tools that build and repair your infrastructure, and we provide the services and solutions that protect what’s most valuable to you. Mainly focused on Tools & Storage, Commercial Security, Hospital & Healthcare Services, Fastening Solutions, Infrastructure Products and Pipeline Services.

Roles & Responsibilities:

•Monitoring the data loading, failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets.

•Enhanced Queries using Calculated and restricted key figures, Structures, Variables with User Entry/Default Value, and Exceptions, Conditions and Formula.

•Handling the dependency of BI loads on extraction jobs using process chains

•Maintenance of the Extract structures as per the requirement.

•Creation of Transformations, DTP’s, DSO, Info Cubes, Multi providers.

•Start Routines and End Routines in Transformations.

•Creation of Generic Data Sources on tables and views and also use of LO Data sources.

•Extract master and transactional data from SAP ECC 6.0 as the OLTP source.

•Customize Info Objects, Data Sources and Info Cubes.

•Design of Process Chains for Batch job Scheduling for Data Loads & Updating Data Targets.

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

•Involved in creation and loading of custom hierarchies

•Created and activated custom Info Cube as per the data model for Purchase order details.

•Data Extraction from SAP MM of SAP ECC and Flat File into the SAP BW.

•Created ODS update rules and Info Package to load data, installed Business Content.

•Extensively worked on BW Scheduler to load data into Info Cube, and ODS and Monitor the Status of the data loads.

•Created Aggregates to improve query performance.

Customer

UNIDO Vienna, Austria (Sep 2009 to June 2010)

Industry

Industrial Development

Project Description

SAP BW/BO Implementation/Support

Role

Senior SAP BW Technical Consultant

Based on the clients Requirement identified the Data Sources, DSOs and Info Cubes required for meeting their standard and customs reports.

Installed and Activated Business Content Objects in the Area of Materials Management, Sales and Distribution and FI-CO.

Prepared the Technical Specification Documentation & Unit tests Documents.

Created Transformations between DataSources and DSOs, Standard DSOs and Info Cube.

Written various routines at the Transformations level. Created DTPs for loading data from DataSource to DSO and DSO to Info cube.

Created Infocubes, DSOs, Multiproviders and Infosets based on the reporting requirements.

Created various standard and custom reports using Query Designer by incorporating all the features available in BI 7.3

Worked on Open Hub Services To Transfer The data from sap BW system to External system.

Created Own Data Sources Using Generic data extraction.

Worked on Transport Mechanism for transporting objects from Development to quality.

Worked with BEx Analyzer in building Queries and saving in workbooks(Excel work Sheets) by defining rows, Columns and free characteristics, providing drill- downs, worked with Restricted Key figures, Calculated Key figures, Formulas, Conditions, Exceptions, Variables & Structures.

Designed and developed the universe as per requirements and fixed the issues.

Test the business objects report as per client requirement.

Refresh and export the required universes.

Testing the reports and at business objects level and universe testing.

Created Custom Hierarchies at universe level for better results.

Created the reports using Business Objects functionality’s like Slice and Dice, Drill mode, Cross Tab, Master Detail, Custom Sorts etc.

Exporting the Reports to infoview and scheduled the reports depending upon the requirements.

Schedule the report as per time (provided by the client calendar) Reschedule the reports as per client requirement (Daily, weekly and monthly).

Monitoring the Instances for scheduled reports.

Publishing the scheduled reports.

Working with production teams and monitored the total process on every release and efficiently fixed the issues.

Support working on BO-dashboards in donor report.

Customer

MOA (Municipality of Anchorage, Alaska) (Jan 2009 to Aug 2009)

Industry

Service Sector Industry

Project Description

SAP BW/BO Implementation/Support

Role

SAP BW Technical Consultant

Participated as a team member in daily discussion with business analyst and end user for Data Modelling, Business Content, Granularity and Performance Tuning.

Analyzing & activate the Business content Components as per the functional requirements.

Did flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW through data staging to PSA and Infocubes or ODS objects.

Extensively used transfer rules, Update rules (ABAP Routines) to translate the business process into end reporting objects.

Developed info cube for Inventory Analysis.

Involved in purchasing data analysis project to carry out analysis of material groups, vendors, and materials.

Involved in creating purchasing and Sales Analysis info cubes.

Set up procedure for extracting R/3 data for MM using LO-cockpit. Customized wherever necessary as per customer requirements. Created function modules for custom extraction wherever system did not support delta update.

Developing the queries to suit the client’s requirement, Using Variables, Filters, free characteristics, restricted key figures and calculated key figures in developing the queries.

Worked extensively on Logistics Data Extraction Cockpit in SAP BIW 3.0B.

Have a strong understanding of database design, data modelling, OLAP and knowledge of SAP BW components and end-to-end cube development.

Performed performance tuning to Info Cube objects through indexing, aggregates, compressing & archiving etc.

Extensively involved in setting up procedures for generating Generic Data Sources for extracting data from ‘Z’ tables.

Created multi-cube on Quotations and Customer Info Cubes.

Created & Scheduled Info Packages and populated ODS objects & Infocubes with full update and Delta Update.

Designed various types of Queries on SD and MM cubes and generating reports using Bex Analyzer.

Got complete training on SAP BW and SAP ABAP/4.

Support Role:

Since I have been in BW development, I have involved in production support activities for couple of months after go-live period.

Extensively involved in setting up procedures for generating Generic Data Sources for extracting data from ‘Z’ tables.

Assure availability of all BW report, Manage the publication of approx 100 major reports.

Monitor all Administrator Workbench schedules, aggregate loads, realignment runs, ODS loads, batch jobs in BW & R/3 i.e. approx 140 Info Packages loaded per day via Event chains and process chains.

Working on issues like discrepancy in Reports data between BW and R/3.

Correct the problems raised in publishing reports to end users.

Customer

SGL Group - The Carbon Company (June 2008 to Dec 2008)

Industry

Manufacturing industry

Project Description

SAP Support cum Implementation Project

Role

SAP ABAP Technical Consultant

Responsibilities:

Developed a Report program and Custom Function module to store the completed batch jobs Spool Information into FTP Server.

Developed a report to display User provided authorization.

Implemented an Implicit Enhancement-Point for the Updation of Material Vendor Number in the Info Record for transaction ME13 through the transaction ME22N for the specified Purchasing Organizations.

Developed ALV for Material master display information’s.

Implemented Enhancement spot for anable the screen buttion by selcting long text radio buttion through tcode SOTR_EDIT

Created User Exit (SAPMV45A) for Sales Order

Implemented changes to the Order confirmation Script layout to meet the business requirements.

Developed a report to create the sales order using BDC.

Customer

smartShift (Germany) (Apr 2007 to May 2008)

Industry

Product & Professional Services

Project Description

SAP Upgrade 4.6,5.0 to ECC 6.0

Role

SAP ABAP Consultant

smartShift Transformer for SAP Accelerates Unicode Conversions, Upgrades and Cleaning up SAP Environments.

smartShift Analyzer for SAP (Other tool) brings transparency to your SAP application landscape. These insights into your current system configuration give you a solid basis to be able to transfer selected SAP sources that are to be transferred over and used in the new environment.

This brings us to another member of our suite of support tools: smartShift Transformer for SAP.

smartShift Transformer is used to automatically transform source code sequences according to customer requirements. In addition, you have the choice of using the opportunity to modernize your system by taking obsolete code and ensuring it to comply with current standards.

On-site work in Client work place (Mannheim, Germany).

Leads the team size of 6 – 8 members.

Take part in Manual Remediation after the Automatically Conversion Custom Developments by the by Transformer Tool.

Handled Custom Developments of Clients Clariant, Texas Instruments (TI) and Shell.

Made Unicode conversion check OK, Replaced obsolete FM with new FM’s / Class methods.

Made extra caution on Dynpros activation, Sub routine pools, Function pools, where ever REUSE_ALV_FIELDCATALOG_MERGE FM is involved we used set for 72 characters of length for Object.

Worked along with SPA for Unicode conversion of reports, Function groups and modules pools.

Tested all Objects using UCCHECK & resolved several UNICODE based issues.

Followed project Naming Conventions and Development standards.

Automated Conversions of customized reports and function modules.

Participated in design and code reviews. Bug fixes and performance tuning of objects during integration testing.

Followed and applied fixes based on the customer feedback.

Contact this candidate