Summary

An accomplished, professional, certified SAP BW consultant with 9 years of experience in End-To-End Implementation, Upgrade and Support Projects. In-depth experience in SAP BW & ECC, with expertise in Requirement gathering, Data Model design, Data modeling, Extraction, BEx Reporting, BI Accelerator, BOBJ WebI and ABAP/4. Sharayu has strong BW and ABAP technical capabilities along with the ability to independently function with global clients and lead globally distributed teams.

SAP BI/BW consulting responsibilities include Business process understanding, System analysis, Design and configuration, Unit and integration testing, Documentation and resolving user queries.

SAP BI/BW data modelling experience includes Design and maintenance of InfoCubes, ODS and Master data objects using extended star schema and efficient multi-dimensional data modeling techniques. Creation of InfoProviders like MultiProviders and InfoSet for reporting. Creation of Open Hub Destination, Creation of Logical Path and Logical File for Open Hub Destination, Process Chain creation to Automate, schedule and monitor data loading into Info Providers.

SAP BI/BW data extraction experience includes Activation of SAP delivered Business Content DataSources, Migration of DataSources, transfer rules, update rules, InfoSource from BW 3.x to BI 7.3, Creation of generic extractor using tables/views/function modules, Enhancement of standard DataSources, Creation of classification DataSource, Creation and customization of Info Sources, Transfer Structures, Update Rules, Transformations, Start and End Routines and Extract Structures, Creation of APD’s for providing master and transaction data.

SAP BI Reporting experience includes creation of BEx Queries, Creation of Calculated and Restricted Key figure, Creation of Variables, creation of Exception and Condition. Creation of workbooks and dashboards using BEx Analyzer.

SAP ABAP experience includes customization of standard extractors, creation of Function Module base DataSources, creation of customer exit variables and transformation routines.

SAP BI Accelerator experience includes creation and maintenance of BIA Indexes.

SAP BOBJ experience includes creation of OLAP universe on Cube/MultiProvider/BEx Queries, Creation of Web Intelligence reports and system upgrade to BOBJ 4.1

Certifications:

SAP Certified Application Associate- Business Intelligence with SAP NetWeaver 7.0

SAP NetWeaver 2004 - Application Development Focus ABAP

Education:

B.E. in Computer Science

Technical Skills:

SAP BI 7.3, BI7.0, BW 3.5, ECC 6.0, SAP R/3 4.7, SOLMAN 4.0, SRM 4.0, SCM 7.0, BWA 7.0, SAP BO 4.1, BO XI 3.1, BEx, ABAP4, Oracle, Remedy, Control-M, Solution Manager, Bug Track

Functional Exposure

Materials Management(MM): Purchasing, Receiving, Inventory Management etc.

Sales and Distribution (SD): Billing, Sales, Sales Documents, Order Types, Pricing & conditions, Item Categories, Schedule Lines etc.

Finance & Accounting: AP, AR, GL Accounting, COPA

Human Capital Management : Employee attendance

Experience

EPSON America, CA (BW Implementation) Dec 2012 - Jan 2015

SAP BW-BOBJ-ABAP Technical consultant

Roles:

Production support for existing PTP data flow and WebI reports

Support and development of SAP BI System during 7.3 upgrade and Latin America SAP deployment

Support and development of SAP BOBJ 4.1 upgrade

Lead onsite and offshore BI team, dedicated to PTP area

Design and development of optimized ETL of all modules for different phases of deployment

Manual data consistency handling of Hard deletion of PTP documents

Custom datasource and data flow creation for PO Pricing Conditions data

Enhancement and optimization of existing Function Module based DataSources

Work closely with business and Client's SAP team to understand and implement functionality through reporting model

Extensively involved in the life cycle of the implementation from the GAP Analysis, Business Blue print to the Go-Live

BOBJ report design and development

Custom TCODE creation for data load, to be used by business users

Creation and maintenance of Open Hub to provide data files to third party and legacy system

Issue resolution in minimal time frame during all phases of project

Environment: SAP BI 7.3, ECC 6.0, BOBJ 4.1

Capgemini Mar 2010 - Dec 2011

Senior SAP BW/ABAP Consultant

National Oilwell Varco, TX (BW Upgrade)

Roles:

Analysis of existing Functional development in BI for various areas like Purchasing, Sales, Finance, Inventory etc. for any existing issues

Remodel existing architecture to satisfy client’s reporting requirements and improve performance

Creation of technical Design documents for Purchasing, Sales and Finance applications for the remediation of existing data flow

Re-design and optimization of existing data flow and the Process Chains (SD, FI & Purchase module)

Optimization of existing Function Module based DataSources

Creation and maintenance of BI Accelerator Indexes

Preparation, documentation and test of Unit Test Cases

Work closely with business and Client’s SAP team to understand and implement functionality through reporting model

Production support for existing architecture during Upgrade process to ensure smooth transition for business

Business dashboard creation for Super User using BEx Workbooks and VB coding

Environment: SAP BI 7.0, ECC 6.0

L&T Infotech Oct 2005 – Feb 2010

SAP BW/ABAP Consultant

Saud Bahwan Group, Oman (Incentive System Implementation) Jul 2009 – Feb 2010

SAP BI-ABAP Technical Consultant

Roles:

Design and development Technical documents to meet business requirements

Design and development of complex Incentive scheme based on existing Revenue system

Design of DSOs to give dynamism in maintaining complex conditions for Incentive system

Creation of ABAP Routines to derive employee attendance and leave records

Development of APDs to simplify complex data model

Creation of BEx queries based on Business requirement

Design and development process chain to automate the data loading process

Design and Development of Custom R3 Extractors to fetch Incentive conditions

Rigorous Testing of data model and reports

Environment: SAP BI 7.0 and ECC 6.0

Ingram Micro, CA (BW Implementation) Dec 2008 – Jun 2009

SAP BI-BOBJ-ABAP Technical Consultant

Roles:

Design and Development of Custom R3 Extractors for Vistex (Customer Rebates and Sales Incentives)

Design and development of data model for efficient data load into SAP BI

Activation and enhancement of LO Cockpit DataSources

Activation of Business Content Objects (InfoObject, DataTarget, Transfer and Update Rules)

Migration of DataSource, InfoSource, Transfer rules and Update rules from BW 3.x to BI 7.0

Development of ABAP/4 code for calculating field values using Start Routine, End Routine and Characteristic Routine

Design of BEx Query based on requirements provided by Business User

Universe Creation based on MultiProvider and Super BEx Query

Creation of Costing based COPA extractor and corresponding data flow

Creation of BIA Indexes for most used InfoCubes

Reports development using BO XI 3.1 Web Intelligence

Automated data loading by creating process chains

Rigorous Testing of Reports and Data model to ensure smooth operation post Go-Live

Environment: SAP BI 7.0, ECC 6.0 and BO XI 3.1

HD Supply, CA (BW Implementation) Aug 2008 – Nov 2008

SAP BW-ABAP Technical Consultant

Roles:

ETL for loading Historical Data into SAP-BI from legacy system like Oracle and current data from ECC

Design and Development of Custom R3 Extractors. ETL from SAP R3 / Flat File Source into SAP BI

Activation and enhancement of LO Cockpit DataSources

Activation of Business Content Objects (InfoObject, DataTarget, Transfer and Update Rules)

Optimal design of BI Query on the requirement provided by Business User

Design of various Customer Exits to meet reporting requirements

Design and creation of InfoProviders to meet History requirements

Automation of data load using process chains

Maintenance, Creation & Deletion Transport requests

Rigorous Testing of Reports and data flow

Environment: SAP BI 7.0 and ECC 6.0

Procter & Gamble, NJ(Customized Spend Visibility Dev.) Mar 2008 – Jul 2008

SAP BW-ABAP Consultant

Roles:

Capture the erroneous PO records and their details using several custom programs

Design and development of function module to determine and update open PO for an info record

Design and development of function module to update condition in the PO Line Items

Development of function module to create and send mail depending upon several events identified in the project

Development of Transparent table to store erroneous PO records for further processing

Development of Custom DataSource and data flow for uploading erroneous PO records in BI

Design and development of BEx reports and Workbooks to show details of erroneous PO

Environment: SAP BI 7.0 and ECC 6.0

Procter & Gamble, NJ (Shopping Cart Archiving) Dec 2007 – Feb 2008

SAP ABAP Developer

Roles:

Design & Development of Custom table to hold entire Shopping Cart related data (including backend data)

Implementation of BADI (SAVE BADI & ARCHIVING BADI) to update Custom Table with shopping cart data

Development of report to upload shopping cart data into custom table before actual archiving

Environment: SAP SRM 4.0

L & T Ltd., India (Production Support) Oct 2005 – Nov 2007

SAP BW-ABAP Consultant

Roles:

SAP SOLMAN 4.0 was used to capture bugs and issues in the system

Reporting requirement includes creation of reports for super users in R/3, BW 3.5 and Solution Manager. This project also included on going developments as per Business requirement

Development of Bar Code Label printing and scanning which were made compatible with SAP R/3 through ABAP Code

Development of User Exit and Field Exit to provide validations to SAP standard transactions

Customization of several standard SAP reports to meet custom made requirements

Implementation of reports for validations in ticket posting and listing in Solution Manager

Implemented of ‘Ticket Creation Alert’ system in form of pop-up for Solution Manager

Development of Mailing process of ‘Ticket Status Change Mail Triggering’ to streamline mailing process for Solution Manager ticketing system

Development of ‘Automatic Mail Reminders’ for consultants or clients to change status of ticket after fixed time interval (as per SLA)

Handled Production support activities for all L&T Operating Division’s SAP BW systems while adhering to SLA

Environment: SAP R/3 4.7, ECC 5.0, BW 3.5 & SOLMAN 4.0

COE Experience

Project

Trade Promotion Management (Sep 2011 – Dec 2011)

Role

Lead SAP BW Consultant

COE Project Profile

The scope of this development was to design solution for SAP CRM Trade Promotion Management. This includes creating plan profiles for TPM, connectivity between CRM, SCM and ECC. Reporting requirement included custom IP report and dashboards to display final overall Plan.

Responsibilities

Requirement Gathering and Analysis of all modules and systems in order to understand the dependency of data flow.

R&D on SAP CRM Trade Promotion Management w.r.t. SAP BI development

Design of Robust and Optimized ETL design to provide effective solution

Coordinating with BI team and allocate task to resources

Prepared Test Cases, documents and effort estimates

Environment

SAP BI 7.0, ECC 6.0, CRM 7.0 and APO 7.0

Project

GREAT BI Estimation Tool (May 2010 – Jul 2010)

Role

SAP BI SME

COE Project Profile

The scope of this development is to provide estimation matrix for different SAP BI objects in order to calculate estimates.

Responsibilities

Interaction with GREAT team to understand working of GREAT tool

Define and test estimation matrix for all BW objects that are available in SAP BI 7.0

Environment

MS-Excel

Personal Information

First Name Sharayu

Last Name Kumatkar

Address 11108 Mirasol, Irvine, CA 92620

Date of Birth May 29, 1984

Email actibm@r.postjobfree.com

Mobile 858-***-****

Contact this candidate