Professional Summary

Overall *.* Years of Experience in SAP BW/BI with two complete

implementation projects and three support projects with proven track

record of company and client satisfaction.

Expertise

. Involved in full life cycle implementation of BW/BI projects and

provided key services such as data modeling, data Extraction and

Reporting.

. Expertise in Data Modelling and reporting in BW 3.5, BI 7.0 and BI

7.3.

. Expertise in analyzing Functional Specification and building technical

Specification as per user.

. Technically having good skill in modelling - Designed and developed

InfoObjects, datasource DTP, transformations, DSO's, InfoCubes,

Multiproviders, Open Hub and Analysis Process Designer (APD).

. Having good knowledge of business process in logistics and

understanding business requirements.

. Experienced in Installation of Business content activation for the

applications SD, MM, SCM and EWM

. Good Analytical skills on Support issues from the applications SD, MM,

FI, and COPA.

. Worked on extracting data from SAP R/3 Source system by using LO

Cockpit, generic extractors and experienced in activation and

installation of business content.

. Worked on Data source enhancement using RSAP0001 to fill the data into

the enhanced Fields.

. Expertise in transporting the objects from development server to

quality server.

. Expertise in

. Creating process chain to load data for master data and transaction

data. Tuned Query performance of the BW system by maintaining

Aggregates, Compressing cubes to improve the loading performance.

. Expertise in creation of BEx query designer for analytical reporting

needs. Extensive knowledge of Queries using filters, structures,

calculated and restricted key figure, Exception, Conditions and Using

RRI Interfaces created jump queries.

. Created BEx reports by modifying existing Queries based on User

Requirement and created Variables and variables processes types.

BO Skills:

. Knowledge on SAP Business Objects XI 3.1/4.0.

. Knowledge on Central Management Console, Central Configuration Manager

and Info view.

. Knowledge on Web Intelligence, Desktop Intelligence Reports and

Universe, support, process initiatives using Business Objects.

. Knowledge on Universe creation with designer and importing and

exporting universe to enterprise.

. Knowledge on report creation with WEBI, Crystal Reports and Xcelsius

reporting tools.

Experience:

. Worked as SAP BI Consultant for Hcl in Kolkata from March '14 to till

date.

. Worked as SAP BI Consultant in Invenio Business Solutions, Delhi since

July'13 to Feb 2014.

. Worked as SAP BI Consultant in LnT InfoTech Bangalore from Dec "09" to

Jan 2012.

. Worked as computer faculty in little flower Degree College from Feb

2003 to Oct 2009.

Education:-

B.com ( Computers Applications) from S.K. University.

Skill set:

. ERP : SAP R/3, ECC 6.0

. Business Intelligence Solutions : SAP BW 3.5, BI 7.0

. Platforms : Windows XP/NT

. Programming Languages & Database : C, C++, and ABAP.

. SAP BO Tool : SAP Business Objects

XI R3 4.0, CMC, CCM.

Projects in Details

Project - IV

Client Name : Ford (Development & Support)

Role : BI Consultant,

Duration : March "14" to till date,

Organization : HCL,

SAP Environment : SAP BI 7.0.

Responsibilities:

. Extensively worked in Data Warehouse Work Bench for Data Modeling,

defining InfoObjects, Info Cubes, Info Source, DSO object,

Transformations, DTP's, Info area, Multi providers, Performance

Issues.

. Installed Business Content for Standard Info Cubes, Transformations,

and Info Objects of Logistic Applications.

. Extensively involved in setting up of procedures for extraction data

from SAP r/3 source system by using Generic Extractions, LO Cockpit,

SCM, EWM and extraction of data from Flat File.

. Experienced in data load management and also in Scheduling Start

Process and Process Chains of Events, OLTP data extraction, Loading

(Full /Delta Up-Load) Monitoring.

. Monitored the BW data loads for Daily/weekly/monthly chains and

resolve the load failures.

. Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW

are same or not after the data loads.

. Monitoring the performance of queries and effectively presented the

report as per the requirement.

. Increased the query performance with the help of RSRT and created

Aggregates to increase Query performance.

. Involved in escalating high-prioritized tickets regarding

extractions, performance issues and also loads failures.

. Developed Process chains and scheduled the data load.

. Involved in Load monitoring using RSPC, RSMO, SM37, and SM50.

. Experienced in BEx Query Designer, Sound understanding of Queries,

Calculated KeyFigures, Restricted Key Figures, Free Characteristics,

Work Books, Filters, Exceptions, Conditions, and Jump queries.

. Worked extensively on BEX analyzer/browser developed flexible queries

using filters, navigational attributes in BEX analyzer to facilitate

data analysis in a drill down or summarized way to give detailed level

of information.

Project - III:

Client : Universal Music Group International

(Support)

Role : BI Consultant

Duration : July '13 to March 2014.

Organization : Invenio Business Solutions

SAP Environment : SAP BI 7.0.

Responsibilities:

. Involved in two activities like monitoring and production support.

. We are Supporting 18 countries for UMGI.

. Executing the Inventory report in Background every day.

. Daily have to send the logs to user and send the UMGI Flex P&L Reports

to user.

. Every month have to send the reconciliation for 18 countries users.

. Monitored Daily Chains, Weekly Chains, and Monthly Chains.

. Monitoring process chain and analyzing the errors in data loads and

provide solution.

. Checked the data for consistency and modified the data in PSA before

loading them to datatarget.

. Data packets were monitored and the failed packets were analyzed

issues and also load failures.

. Involved in monitoring the info package groups and process chains.

. Monitoring of infopackages and analyzing the reasons for frequent

failures of info packages.

. Handling tickets based on priorities and maintaining the Backlog with

respect to the SLA

. Reconciliation's to verify the data in SAP R/3 and SAP BW are same or

not after the data loads.

. Monitoring of info packages and analyzing the reasons for frequent

failures of info packages.

. Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.

. Involved in requirements gathering, design, and development for

reporting.

Project - II

Client Name : JOHNSON AND JOHNSON (Implementation & Roll Out)

Role : BI Consultant

Duration : Oct "10" to June 2013

Organization : LnT InfoTech in Pune

SAP Environment : SAP BI 7.0. SAP ECC 6.0.

Company profile:

Johnson & Johnson Pacific Pty Limited is taking the latest technology

and knowhow from its research laboratories around the world, and building

it into everyday products and services that are effective and easy for

anyone to use. So the quality and care you've come to expect from Johnson &

Johnson Pacific Pty Limited will also be available in medically recognized

products and health services for people of all ages.

Responsibilities:

. worked on Data Warehousing Workbench, creation of new customized

InfoObjects, Data

Source, InfoPackage, transformations, dso's, InfoCubes, and Open

Hub Destination.

. Involved in extracting the R/3 data for MM and Sales and Distribution

using LO-Cockpit.

. Enhanced the Data sources as per the requirement and using the

enhancement RSAP0001 to fill the data into enhanced fields.

. Installed Business Content and Activated to meet user needs. Used DSO

to stage the data transferring the DSO contents to the Info Cube.

. Designed and Developed Process Chains for Master Data Loads and

Transaction Data Loads with the help of Info Packages. Process chains

are scheduled for Periodic Loads.

. Monitoring of Info packages and analyzing the reasons for frequent

failures of Info packages.

. Experience in transporting the objects from development server to

quality server.

. Performance tuning of queries by maintaining aggregates, compression

and partition of info cubes

. Applied conditions, exceptions, restricted key figures, calculated key

figures, variables.

. Roll out for five countries which are India, ANZ, Chain, Japan and

Vietnam.

. Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.

. Involved in analyzing Functional Specification and building

technical Specification.

. Involved in extracting data from SAP ECC by using Generic Extraction

and install the business content datasource.

. Worked extensively on loading the data from ECC to BW and used

Initialization with delta updates and full updated methods.

. Worked on creating the test documents for SIT and UIT testing.

. Hands on experience in Controlling Dataflow using Transformations,

InfoPackages, and DTP's.

. Developed Process Chains for Master Data Loads and Transaction Data

Loads with the help of Info Packages. Process chains are scheduled for

Periodic Loads.

. Experience in transporting the objects from development server to

quality server.

. Experience in Resolving the Data load issues.

Project I

Client : P&G (Support)

Role : SAP BW Consultant

Organization : LnT Infotech Ltd Pune

Duration : Dec '2009 to March '2011

Environment : SAP R/3, SAP BW3.5

Responsibilities:

s

. Working on Process chain.

. Monitored Daily Chains, Weekly Chains, Monthly Chains.

. Analyze the errors in the data loads.

. Loading Master data, Transaction data and into the SAP.

. Activating and filling the Aggregates.

. Worked with the RSMO in solving the data load errors.

. Involved in monitoring the info package groups and process chains.

. Monitoring of info packages and analyzing the reasons for frequent

failures of info packages.

. Handling tickets based on priorities and maintaining the Backlog with

respect to the SLA

. Developing new enhancements as per the user requirements

. Reconciliation's to verify the data in SAP R/3 and SAP BW are same or

not after the data loads.

Contact this candidate