Anonymes Freelancer-Profil

SARANG BHALERAO

Certified SAP BI/BW Consultant

Professional Summary

• Certified Consultant SAP BI with Netweaver 7.0.

• Overall IT Experience – 8.8 years.

• Overall SAP Experience – 8.3 years.

• Overall SAP Specialisation Experience in BI/BW – 8.3 years.

• Overall SAP Sub-Specialisation Experience –

SAP BW 3.5 – 3 years.

SAP BI 7.0 – 5 years.

SAP BW 7.3 – 3 months.

SAP ABAP – 5 years.

SAP BI/IP – 1.5 years.

• No of Implementation Projects – 5.

• No of Support Projects – 2.

• No of Upgrade Projects – 1.

• Strong Experience in SAP ABAP/OOABAP and SAP IP (Integrated Planning).

• Domain Experience in SAP SD/MM/PP/FSCM/QM/FI/WM/MAP (Merchandise and Assortment Planning).

• Specialize in Project Work Plan, Estimates, Requirement Traceability Matrix, Functional and Technical

Specifications, Object Inventory documents.

• Worked in Switzerland, Germany, France and South Africa, involving end-to-end implementation of various SAP

Modules.

• Work with business users to understand business requirements and facilitate technical solution in designing

integration efforts to meet user needs.

• Provide technical expertise and guidance in developing complex BI reports involving standard objects or

customized content based on user requirements.

• Lead user workshops and conduct formal presentations to communicate proposals, methodology, development

plans, and deliverable status reports.

• Provide technical resolution and advisory services to technical issues

• Develop test plans, test scripts and coordinate entire end to end testing efforts for SAP development.

• Develop cutover and go live plans to realize SAP solutions.

• Prepare knowledge transfer documents for all SAP technical solutions implemented.

Position

Software-Development / Programming

Consulting

Coaching / Training

Team -Lead / Organisation / Coordination

Administration / Support

Education

• 08/2001 - 07/2005 Bachelors of Engineering

• 11/2008 - Certification SAP BI with Netweaver 7.0

• 01/2011 - Certification in Packaged Application Designing, in collaboration with Accenture and Massachusetts

Institute of Technology

Operating Systems

Windows

Programming Languages:

ABAP4/ OOABAP

JavaScript

Databases

Oracle

Products/Standards/Experience

SAP expertise

• SAP BI/BW/ABAP

Layered and Scalable Architecture

Modelling, Extraction, Reporting

Datasource enhancements (CMOD, BADI)

LO-COCKPIT, Setup Tables, Delta Queues and Generic Data Extraction

Queries, Workbooks, Dynamic Currency Conversions, OLAP variables

Transformations routines,Process Chains, Transports

ABAP Workbench, BADIs, FM, Programs, Debugging

• SAP BI/IP

Aggregation levels, Planning Functions including FOX, Planning Sequences,

Data Slices.

Input Ready Queries and WAD (Web Application Designer).

Communication with external services

Configuration of the server components

• SAP SCM

Worked with Purchase Orders, Sales Orders, Delivery and Billing Documents,

Business Partner Hierarchy

• SAP SRM

Worked with Procurement, Sourcing, Shopping cart Lifecycle

• SAP Modules : MM, SD, FI, QM, WM, FSCM, MAP

Methodologies knowledge

• Project management

• Software development

• Quality assurance

• Conducting workshops

• Architecture design

Industries

• Service providers

• FMCG

• Retail

• Banking

• Telecommunication

PROJECT EXPERIENCE

CODE (Inventory Management)

Client Nvidia, Global

Project Type SAP ECC/APO END TO END IMPLEMENTATION

Industry Graphics and Semiconductors

Duration January 2004-Till Date

Role SAP BI/BW Consultant

Synopsis The main objective of this project is to implement mapping between Wafer Material and Finished

Goods and use it for planning Stock Quantity on weekly basis.

Team Size 5

Technology SAP BW 7.3 and SAP ABAP/4

Tasks

• Study the relation between Finished Goods, Die Material and Wafer Material and prepare a technical specification

for the data model design.

• Gather Reporting requirements from Business users for Report design based on Good die and Free die

indicators.

• Implement the data model in BW by integrating datasources from ECC for Wafer Material and APO for Finished

goods.

• Create a Report showing Stock Quantity on weekly basis.

BARCLAYS CAPITAL (Investment Banking)

Client Barclays, United Kingdom

Project Type SAP SRM/Procurement END TO END IMPLEMENTATION

Industry Banking

Duration July 2012– December 2013

Role SAP BI Lead

Synopsis The main objective of this project is to implement SRM and Procurement lifecycle in SAP BI7.0 for

various Business Areas of Barclays group

Team Size 7

Technology SAP BI 7.0 and SAP ABAP/4

Tasks

• Automation of User Creation and Role Assignment in BW for Manager Self Service users. Created program and

RFC FM to fetch HR information from ECC using various Infotypes – 105, 002. Program helps in mass creation of

users and assigns specific roles to them.

• Worked on Request to Pay SRM eProcurement lifecycle for Shopping cart. Online application for company to

purchase goods and services using inbuilt catalogues, SRM functionality. Created datasources in SRM to pull the

required information in BW and also built datasources in R/3 for extracting Invoice information of shopping carts.

• Worked on P2P Compliance reporting using FI_GL_4 as the datasource. Main purpose of this reporting was to

capture the Invoice Clearing and Late payments done to 3rd Party Vendors.

• Automation of Spend Management – deliver Spend Reports to business users that helped them manage

Company Spend on various vendors across the globe. Project involved creation of Normalized vendor and Spend

Dashboards (using Qlikview) according to Region/Country, Top N vendors, Profit Centre.

JD GROUP

Client JD Group, South Africa

Project Type SAP MAP and IP (Merchandise and Assortment Planning)

END TO END IMPLEMENTATION

Industry Retail

Duration August 2011–July 2012

Role SAP BI Lead

Synopsis The main objective of this project is to implement MAP (Merchandise and Assortment Planning) in SAP

BI7.0 for JD Group, South Africa. Project involves an end to end implementation with Integrated

Planning as the base.

Team Size 6

Technology SAP BI 7.0, SAP ABAP/4, SAP BI-IP 7.0

Tasks

• Working as a BI and IP lead for MAP (Merchandise and Assortment Planning). Involved in requirement gathering

and technical realization of MAP for SAP Retail.

• Designing of Article Hierarchy Master Data; Sales and Inventory Data model with 2Lis_11*/12*/13* and

2Lis_02/03* Extractors.

• Cube Designing, RSRV checks, Sizing and table space allocation, Transformation Routines, Infosource, Queries,

Variables, and Customer Exits for Time Hierarchy, Process Chains, and Transports.

• Designing of Planning Architecture for MAP which includes creation of History, Actual, Projected, Budget,

Merchandise, Strategic and Key Item Planning Versions.

• Creation of Aggregation levels, Planning Functions including FOX, Data Slices for elapsed months, Input ready

queries with Distribute functionality, Preseason, Inseason and rolling season time hierarchy.

• Customer specific WAD templates with Multiple Layouts, cell locking features, copy/paste/clear and Print

functionality.

• Defining Cut-over activities, set-up table filling and Delta initialization.

• Customer Support post Go-live and issue resolutions.

• Worked with Project Work Plan, Estimates, Requirement Traceability Matrix, Functional and Technical

Specification, Object Inventory documents.

ALCATEL- LUCENT

Client ALCATEL-LUCENT, France

Project Type SAP FSCM- (Credit Management, Collection Management + Dispute Management)

END TO END IMPLEMENTATION

Industry Telecom

Duration May 2010–August 2011

Role SAP BI Architect + Developer

Synopsis The main objective of this project is to implement FSCM – Credit Management, Collection Management

+ Dispute Management Module for Business Partners in SAP BI7.0 for ALCATEL-LUCENT, France.

Project involves an end to end implementation cycle on both R/3 and BW Systems.

Team Size 4

Technology SAP BI 7.0 and SAP ABAP/4

Tasks

• Study the FSCM Module in R/3 and prepare technical analysis of the functional specification provided by the

client, for requirement gathering.

• Be a part of the Business Process to discuss the Architecture Design, Business Partner Hierarchy, Credit

Management, Collection Management and Dispute Management Process with the end customer and provide

them with an Axis of analysis to be reported on.

• Prepare a business blue-print covering all requirements and get the same verified from onsite team.

• Prepare workload estimation for Design, Realization Phase, Integration Test, UAT and Go-Live.

• Prepare a Detail Design Document to support the Customer Requirement, involving all technical details of the

Architecture Entities including Master and Transaction data.

• Enhance the 0BPARTNER_ATTR datasource to create a flat Business Partner hierarchy as per the Business

group and make this hierarchy available at report level.

• Setup Promise to Pay and Dispute Master and Transaction Data as part of Collection Management.

• Create a Generic Datasource on view V_UKM_ITEM and append it as per customer Requirement.

• Create the FSCM flow on BW system and consolidate this with Accounts Receivables with required DSO, Cubes,

Transformations, DTP’s, Multiprovider, Queries and Variables.

• Perform Unit and Integration testing especially for delta extraction by creating New Business Partners,

• Groups and Sub-groups, setting dummy Credit limits and Creating Disputes on Invoices.

• Created Credit Risk Exposure Report, Due Date and Cash Collection Reports using dynamic exchange rates and

Multiple Currency Conversions with required Calculated and Restricted key Figures to highlight the Backlogs and

Receivables for each Business partner.

• Provide extensive knowledge transfer to the client on the design flow and support during User Acceptance testing

and Go-live.

ALCATEL- BLUE PLANET WAVE 3A AND CANADA

Client ALCATEL-LUCENT, CANADA

Project Typ SAP QM - Quality Management END TO END IMPLEMENTATION

Industry Telecom

Duration July 2009–April 2010

Role SAP BI Developer

Synopsis The main objective of this project is to implement Quality Management Module in SAP BI7.0 for

ALCATEL-LUCENT, Canada. Project involves an end to end implementation cycle on both R/3 and BW

Systems.

Team Size 5

Technology SAP BI 7.0 and SAP ABAP/4

Tasks

• Study the Quality Management Module in R/3 and prepare technical analysis of the functional spec provided by

the client, for requirement gathering.

• Be a part of the Business Process to discuss the Architecture Design with the end customer and provide them

with a Overview on what needs to be done.

• Prepare a business blue-print covering all requirements and get the same verified from onsite team.

• Prepare workload estimation for Analysis, Design, Realization Phase, Integration Test, UAT and Go-Live.

• Prepare a Detail Design Document to support the Customer Requirement, involving all technical details of the

Architecture Entities.

• Do custom Enhancements for standard 2LIS_05* datasources using CMOD.

• Build Custom datasources to support additional requirements.

• Build the Quality management flow on BW system with required DSO, Cubes, Transformations, DTP’s,

Multiprovider, Queries and Variables.

• Perform Unit and Integration testing especially for delta extraction by creating Notifications and modifying them.

• Create Notification Discrepancy Report and Supplier Corrective Action Report to track rejections found during

incoming inspection and manufacturing.

• Provide extensive knowledge transfer to the client on the design flow and support during User Acceptance testing

and Go-live.

BW-AM

Client T-COM, Germany

Project Type SAP SD - Development, Enhancement, Testing and Support

Industry Telecom

Duration December 2007-July 2009

Role SAP BI Consultant

Synopsis The main objective of this project is to Develop, Enhance, Upgrade, Test and Support the Application

Management Modules of T-COM. Project basically involves Change Management, Testing, Migration

from 3.5 to 7.0, Data Load Monitoring, Incident and Problem Management.

Team Size 10

Technology SAP BW 3.5 and BI 7.0

Tasks

• Created Business Data Flow for Extraction for SAP FI and SD Modules involving ODS and Info-Cube Design,

Transfer and Update Rules along with Creation of IP’s and Aggregates as per the Client requirements, in

Development System.

• Subsequent creation of Process Chains to automate the Data Load Process. Finally Created Transport Requests

and implemented the same across Quality System for regression testing.

• Involved in Testing of Extractors and Data Quality, both at DWH and Reporting Level to ensure Data Consistency,

for the various changes taking place in various R/3 systems.

• In continuation, carried out migration from 3.5 to 7.0 for the existing architecture involving migration of Data-

sources, creating Transformation and DTP’s and including the same in Process Chains and testing data load

extractions for the same.

• Worked with Reports (BEx, Web), Web Application Designer.

• Resolved Issues pertaining to Reports, Re-Initialization, Errors in Transformation, Short Dumps and issues

pertaining to Master Data Load.

• Worked with Incident and Problem Management issues.

• Involved in monthly Project Audit Process and worked as SCM Coordinator for the same.

Nestle-BIG

Client Nestle Business Services Limited

Project Type Implementation

Industry FMCG

Duration May 2007– August 2007

Role Team Lead

Location Switzerland, Germany + Bangalore

Synopsis The main objective of this project is to develop a new landscape which combines the business flow of

architecture existing within different market regions of Nestle.

Team Size 12

Technology SAP -BI 7.0 with 3.5 Functionality

Tasks

• Worked as an Onsite Coordinator for implementing data flow based on the Layered and Scalable

Architecture of BI.

• Responsible for creating and releasing the transports from development environment and implementation across

quality, pre-prod and production environment. Performed pre and post manual actions for the same.

• Involved in Master Data Testing and the issues pertaining to extraction in BI 7.0.

• Testing of newly built Generic Extractors.

• Understanding the existing architecture of different regions of Nestle and combining them to form a single data

flow in the new landscape.

• Created new process chains to enhance Data Load Stability and Report Availability On-time.

• Involved in design issues with regards to Data Load Extraction(R/3 extraction, delta handling), Attribute Change

Run and overall improvement in Data Load Performance.

• Involved in Data Quality check to ensure Data Consistency.

• Worked with LO-COCKPIT, Setup Tables, Delta Queues for extraction purpose.

• Provided extensive support after implementation to ensure successful Go-Live!

• Provided responsive support to the client pertaining to system set up and ongoing development.

Nestle Globe

Client Nestle Business Service Limited

Project Type Production Support

Industry FMCG

Duration January 2006–November 2007

Role Team Member

Location Bangalore

Synopsis The main objective of this project is to improvise the performance and operational efficiency of the

Nestle Business across the globe. Nestle has one of the biggest architecture in SAP, having a Market

wise split.

Team Size 50

Technology SAP-BW 3.5

Tasks

• Lead a team of 50 members for Change Implementation and Incident Management.

• Extensively implemented migration of the old architecture to a new one, including Market Split in SEM for almost

14 markets in Europe.

• Import of Transports in Production Environment and carrying out Pre and Post Transport Actions.

• Carrying out Market wise Disaggregation’s in SEM and COPA Realignments in BW on demand.

• Monitored and scheduled all data loading jobs through Process Chains across different systems (BW and SEM).

• Worked with Deletion and Re-Initialization from Source System during System Outage, which involved Activation

and De-activation of Extractors, deletion and filling of setup tables, scheduling V3 jobs to setup Delta Extraction.

• Created and Scheduled V3 jobs in LO Cockpit for various application components for delta mechanism.

• Involved in the Incident Management (First Level Support for tickets involving Data load issues and issues related

to SEM Production). Resolved Issues pertaining to Reports, Re-Initialization (LOC-COCKPIT), Errors in Transfer

and Update Rules, Short Dumps, Transport Failures and issues pertaining to Master Data Load.

PROFESSIONAL ACHIEVEMENTS

• Certified in Packaged Application Designing, 2011 while working with Accenture.

• Certified in SAP BI 7.0 during TechEd, 2008, while working with Cognizant.

• Recognized as Star Performer for providing excellent work abiding the Norms and Quality Procedures, in Satyam,

Year 2006-2007.