Sap Project

*** * ******* ****** #*- ***,

Los Angeles, CA - *0004.

Mob : 732-***-****

Email : acpmxu@r.postjobfree.com

SAP BW Consultant with 12 years of extensive experience in IT industry and

10+ years of experience in SAP BW Implementation, Upgrade, Support and

Enhancement projects. Experience includes system configuration, technical

developments, system testing, user training, documentation and post go live

support.

Experience Summary

. 12 years of IT experience as a technical consultant.

. 10 years experience in SAP BW 3.5, SAP BW 7.0, SAP BW 7.4 and BO XI

R2, BO XI R3 and BO 4.1

. Worked in multiple industries like Manufacturing, Oil & Gas,

Shipping, Retail, Insurance Services, Construction, Steel and

Entertainment.

. Managed SAP BW/BI and BODS support project for 9 live countries.

. Involved in 5 Full Life Cycle implementations of SAP BW/BI.

. Blueprinting, gathering requirements, designing and rolling out BI

solutions to end users.

. Examined and evaluated reporting requirements for various business

units across the organization.

. Responsible for ensuring high levels of BI availability through

support functions and in depth testing.

. Designed, developed and implemented data models for enterprise

level applications and systems.

. Ensured integration of data from both SAP and non-SAP sources.

Performed impact analysis of changes and enhancements.

. Regular review of system performance. Oversight of installations,

integration, upgrades, migrations and ongoing maintenance.

. Overseen testing procedures and signoff procedures. Quality gate

management as well as change control and release/transport

management.

. Identified and grouped scope of BW development and defined patterns

for SAP BW vs ECC/BODS reports.

. Worked on Global Implementation of SAP BI with BO.

. Exclusively worked on reports of OTC, P2P, SCE and FICO.

. Solid End to End Technical Expertise - Extraction through Modelling

to Analytics.

. Expert in building custom Update rules, Transfer rules,

Transformations, Start Routine and End Routine.

. Expertise in design and development of BW Objects and Business

Objects Reports.

. Extensively worked with ABAP on user exits, update rules and

transfer rules.

. Developed and enhanced BW reports using SAP BO 3.1 and BO 4.1

. Worked with reporting agent for sending emails, alert monitor

entry, exporting data, RRI.

. Extensively worked on optimizing the loading performance of SAP BW

data loads and reports.

. Experience in Unit test, Integration testing, User acceptance tests

(UAT).

. Hands on experience in archiving BW objects using ADK.

. Integration of SAP BI System and Non SAP System using SAP BODS.

Created Global variables to read the files from the shared location

from the BODS Designer Also worked on the FTP process to put & get the

files on the data-exchange servers.

. Experience in support for BODS jobs and feeds. Creating Jobs, Work

flows, data flows and scripts in Data Integrator to pull data from the

legacy systems and load the data into target database.

. Conducted BW reporting (BEx, BO/WEBI) features workshop with

business users.

. Conducted reporting workshop strategy to gather new report

requirements in BW landscape.

. Worked on reporting Governance in BEx and BO reporting areas.

. Experience in working with scheduling agents like Control M,

Maestro for SAP and Non-SAP Jobs scheduling.

. Experience in working with See burger for EDI reports and partner

reporting.

. Involved extensively in SAP BW upgrade from 7.0 to 7.4 and SAP BO

upgrade from 3.1 to 4.1

. Demonstrated ability to complete multiple assignments

simultaneously and maintain high standards of client satisfaction.

. Prepared Business process documents and handled end-users training

sessions by educating them on the technical limitations and

alternative & efficient approaches for accessing BI data.

. Delivered excellent solutions against demanding Timescales

. Experienced in the areas of Project and Operations Management & Co-

ordination, and Solutions' Architecting, Testing and Development,

Onsite/Offside Coordination.

SAP BW Expertise

Modeling: Info Objects, Info object Catalogs, Info cubes, DSO objects,

Info Sets, MultiProviders, Application Component, Info Sources, Data

Sources, Update Rules, Transfer Rules, Communication Structure,

Transfer Structure, Info Packages, Info Package Groups, Process

Chains, PSA, Transformations, Data Transfer Process (DTP) etc.

Extractions: Used Business Content extensively, loaded statistical

data using (BC) Technical Content. Extracted data from ECC,

classification system, through Web service and Flat File. LO Cockpit

Extraction, Generic Extraction, Flat file Extraction for Master data

and Transactional data, and Activating Data structure, transport data

sources, customizing and Enhancement of Extract.

Scheduling: Creation of Batch process and scheduling load jobs in

parallel. Process Chain Maintenance.

Reporting: Expertise in Reporting with Business Explorer using BEx

Analyzer, BEx Query Designer, Web Application Designer, Condition

Reporting, Exception highlighting, developed Queries, queries using

Filters, Free Characteristics, Calculated Key figures, and Restricted

Key figures, Variables, Structures and RRI (Report to Report

Interface).

. Performance Tuning and Optimization: Extensively worked on performance

tuning of data loads, Bex Query and BO Reports. Performance tuning by

maintaining Aggregates, Compression, Partition, indexing of info cubes

and use of statistics for the same. Worked on overall performance of

BW system.

Technical Skill Set:

. Business Intelligence Tools: SAP BW 3.5,7.1, 7.02, 7.4

. SAP Modules: FI, CO, COPA, FM, SD, MM (PUR), IRDA, Solution Manager.

. Reporting Tools: Query Builder, BEx Analyzer, WAD, Report Designer,

Pre Calculation server, Enterprise Portal

. Business Object: Web Intelligence, Universe Designer, Xcelsius, SAP

BusinessObjects Analysis

. BODS: SAP Business Objects Data Services 4.1

. Programming Tools: C, ABAP/4, JAVA, SQL, PL/SQL, HTML, and VB 6.0.

. Operating Systems: WINDOWS 2000 Server, WINDOWS NT 4.0, UNIX, WINDOWS

XP/98/95 and LINUX.

. Databases: Oracle Database 11g Release 2: 11.2.0.1-11.2.0.4, Oracle 8,

9i, DB2, MS ACCESS, and SQL Server

. Service management tools: Servicenow - BMC, Remedy, HPQC

. Presentation/Utility Tools: MS-Office, MS-Project

Academic Profile:

. MCM (Master's in Computer Management) from Pune University.

Professional Training Attended

. SAP BW 3.5, SAP BI 7.0, Business Objects XI R3 Webi, BO 4.1, BODS

SAP Experience

Larsen & Toubro Infotech Ltd., Sept 2010 - Present, Sr. SAP BW consultant

Project: Upgrade - SAP BW 7.4

Role: SAP BW Consultant

Client: Paramount Pictures

Location: Los Angeles, CA,

Duration: April 2015 - Present

Responsibilities: Upgrade

. Managing SAP BW upgrade from SAP BW 7.0 to SAP BW 7.4

. Responsible Pre upgrade and Post upgrade activities

. Responsible for Project Plan Preparation and Project tracking

. Involved in Pre upgrade activities like consistency check, Clean up

activity, Temp table checks, Check/Repair Status of Info Objects,

Clean/delete the messages for error logs, Checks for Master data

consistency, Clean up background jobs, Repair inconsistent info packages

and backup for Bex query outputs before upgrade.

. Involved in HANA migration cockpit install and check pre and post upgrade

activities.

. Checked RFC's and source system connections and replication of source

system.

. Involved in Post upgrade activities like check for Delta working fine,

Check data flow for master data and Process chain upto Bex query.

. Migrated older version of Bex queries to newer version.

. Involved in testing the master data and transaction data loads.

. Checked the routines, transformations and DTP's.

. Checked Aggregates and Indexes of Info cube.

. Validated Bex query and report output after upgrade.

. Involved in checks for existing and new functionality of BW 7.4

. Involved in UAT for Quality and Mock testing before Production.

Project: SAP BW AMS support

Role: SAP BW AMS manager

Client: Ingram Micro

Location: Santa Ana, CA,

Duration: May 2012 - Mar 2015

Responsibilities: Support

. Managing 24/7 support for 9 live countries for SAP BW. Well versed with

onsite - offshore model.

. Responsible for delivery of reports to 3000 customers/partners.

. Responsible for monthly release and change management for SAP BW/BOBJ.

Well versed with Solution manager.

. Responsible for incident tracking and timely resolution of tickets

. Extensively worked on different service management tools like Servicenow

- BMC, Remedy and HPQC.

. Experience with proper data architecture, PSA maintenance, Info Packages,

Data Transfer Process (DTP), Delta functionality, Flexible Master data

staging, and debugging loads using the Data load Monitor.

. Hands on experience undertaking performance tuning activities for SAP BI

and BOBJ, managing upgrades, creating technical and functional design and

support, up keeping the Knowledge Management System.

. Daily Monitoring of complex Process Chains. Taking care of Daily / Weekly

/ Monthly Jobs as per client requirements.

. Troubleshooting the process chains and keeping track of the issues that

occur and identify to find long term solutions for them.

. Extensively worked on scheduling, rescheduling, decommissioning, setting

up alerts, defining dependency of SAP and Non SAP jobs using Control M

agent.

. Closely worked with See Burger team for distribution of EDI reports to

more than 600 partners.

. Responsible for BODS and LDB support to 3 data centers

. Responsible for Weekly and Monthly maintenance activity for SAP

BW/BOBJ/BODS

. Timesheet and effort estimate on weekly and monthly basis and reporting

to Project Manager.

. Hands on working experience with SAP BO tools set like SAP Universe

designer, Web Intelligence, Analysis For Business Explorer, Xcelsius

(Dashboard) and SAP BI tools like Query Designer, BEx Analyzer, BEx Web

analyser and Application designer.

. Integration of SAP BI System and Non SAP System with SAP BO Using SAP

BODS

. Maintenance of documentation of the daily loads, process chain status,

etc.

Project: SAP BW Development

Role: SAP BW Consultant

Client: Ingram Micro

Location: Pune, India

Duration: Sept 2010 - May 2012

Responsibilities: Development

. Worked Extensively on Data Warehouse Workbench and customized info

objects, info cubes, DSOs, Data Sources, DTPs, Transformations and

multiproviders

. Set up periodic Data loads from legacy system (flat files)

. Analyze business requirements and use Business Objects Xcelsius

Enterprise to create visualizations to meet those requirements

. Involved in extracting data from External Source system like Informatica,

Oracle Tables, DB6.

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

. Creating and managing dataflow using DTP, transformations and info

packages.

. Created more than 70 Open Hubs for Partner connectivity group.

. Data Source, Multi provider and Info sets & cubes enhancement according

to customer requirement.

. SAP BI ABAP - Created Update rules, Transfer rules, Transformations,

Start Routine, End Routine, user exit and function module code for

generic data source.

. SAP R3 Source Configuration systems: Extracted Data from Flat File (CSV &

Notepad), ECC / R3, SAP BW ( Data marts), Oracle Data Base, GTS and

vistex.

. Designed and developed queries to generate reports in BEx Analyzer.

. 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 ODS, Infocubes, Multi-providers and infosets and

extracted SD data (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM,

2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction.

. Schedules DTP for loading Transactional Data from PSA to Info Provider

using process chains.

. Extensively used Structures, cell definition, calculated key figures,

restricted key figures, new selection, new formula, exceptions and

conditions.

. Configured security roles and authorizations for both BW objects and

reports

. Involved in frequent client meetings to discuss project status.

Essar Information Technology Limited, India NOV 2006 - SEPT 2010 SAP BW

Consultant

Project: Project Basant - BW 7.0

Client: Oriental Insurance Company Ltd.

Role: BW Team lead

Responsibilities: Implementation & Support

. Feasibility study for the project and preparation of Proposal and

Project Plan.

. Participated in Blueprint preparation, conducted workshops to describe

BI capabilities and advantages over legacy.

. Assisted in determining if reports are BI or ABAP reports, done Fit-

Gap analysis, involved in requirement gathering and preparation of

technical specs.

. Assisted in preparing test specifications for BI reports, Involved in

production support and user training.

. Checking the Patch levels for R/3 and BI servers and both on latest patch

with help of Basis Team.

. Direct interaction with End users at client site. Involved in all client

meetings.

. Preparation of Design document and getting reviewed by Practice Lead.

. Timesheet and effort estimate on weekly and monthly basis and reporting

to Project Manager.

. Making sure proper documentation is done for each and every development.

. End user training for BEx reports, Workbooks execution and on

Enterprise Portal.

Project: Global Cash Flow - BI 7.0

Client: Essar Global Ltd

Role: BW Team lead

Responsibilities: Implementation & Support

. Preparation of Project Plan for development.

. Activation of 0FIGL_O02 standard business content.

. Creation of source systems for different instances.

. Development of Global Data Model for GL Accounts.

. Developed reports based on Global Data Model and published them on

Enterprise Portal.

. Timesheet and effort estimate on monthly basis and reporting to Project

Manager.

Project: IIRMS [Integrated Investment Risk Management System] - BI 7.0

Client: Life Insurance Corporation of India

Role: SAP BW Consultant.

Responsibilities: Implementation

. Worked on modeling IRDA Cube, 13 info sets on various DSO and Infoobject

combinations, 12 no's Z- DSO's and two Multiproviders'.

. Understanding of FS from client and functional team.

. Involved in Documentation for Cubes, DSO's and Multiprovider.

. Creation of customer exit variables.

. Carried out Unit testing and Integration testing with functional

consultants and end user.

. Worked on queries: 12 queries for Board Notes, 18 for yearly Schedules, 5

for FICO, IRDA etc.

. Post Go-live support to users and daily monitoring and Change Request

Management.

Project: Lakshya - BI 7.0

Client: Essar Oil Ltd.

Role: SAP BW Consultant.

Responsibilities: Implementation & Support

. Took part in rounds of discussion with the Business users to generate

functional requirements / specifications and conducted GAP analysis.

. Involved in the analysis, development, and data modeling.

. Created Generic Data Source on R3 side to meet reporting requirements.

. Worked in BEx Query Designer. Created Calculated and restricted key

figures, Variables and Conditions.

. Worked on cell editor, WAD templates and Workbooks.

. Creation of customer exit variables like MTD, YTD, and No of Days in a

month, No of MIS days etc.

. LO setup for sales, inventory and purchasing modules and initialization

for these modules.

. Involved in designing the data model by identifying the characteristics

for dimension and key figures for the fact tables and defined the display

and navigational attributes for the BI extended star schema.

. Creation of process chains for data loads.

. Exposure to the Business Content and implementation of the same in the

appropriate. Functional area and to activate business content.

. Created and Maintained Data Sources, Transfer Structures, Communication

Structures, Transfer Rules and Update Rules for Infosource, DSO objects

and Info Cubes.

. 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.

. Created Transfer rules, update rules using ABAP routines and Formula

builder while creating Cubes and ODS.

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

BW.

. Involved in Performance Issues like Creation of aggregates, RollUp and

Compressed the InfoCube 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 Infopackages.

. Resolved Customer reported tickets through email and phone.

SAPzen Consulting Pvt Ltd, Mumbai AUG 2004 - NOV 2006 Jr.SAP BW Consultant.

Responsibilities:

. Worked extensively on Bex Analyzer. Created queries using BW-Reporting

Variables, Navigational attributes. Developed several queries and

workbooks using Bex Analyzer according to end users requirement.

. Involved in the analysis, development, and data modeling.

. Created Generic Data Source on R3 side to meet reporting requirements.

. Worked on production related issues, dataload monitor and repair.

. Worked on project documentation according to Quality standards.

IT Experience (Non SAP)

Rishabh Software Pvt. Ltd, Baroda, Gujarat, India APR 2004 - AUG 2004

Roles & Responsibilities:

. Worked on the Appointment Scheduling, Inventory Management System and

Purchase Order system.

. Getting requirements from the Clients and passing on the requirements to

the Development Team Leader.

. Worked with the development team in resolving technical problems,

debugging and problem resolution.

. Architecting, implementing, managing and diagnosing very high performance

and very large databases.

. Designed software for the training clients on the real time environment.

. Provided training to the Clients.

Environment: VB 6, Oracle 8

American Computer Connection, Baroda, Gujarat, India MAY 2003 - APR 2004,

Customer service representative

Roles & Responsibilities:

. System study of the existing Customer Relationship Information Systems.

Getting user feedback on existing system and passing on to the Team

Leader.

. Worked with the development team in resolving technical problems,

debugging and problem resolution.

. Support all user problems.

. Training executives on the new developed software.

Environment: VB 6, Oracle 8

[pic]

Contact this candidate