PATAN. VASEEM KHAN

Mobile No: +91-900*******

SAP BI Consultant

Email:dvp3qa@r.postjobfree.com

Experience Summary

Around 3 years of experience in SAP BI/BW.

•

•

Good Experience in understanding Business Requirements and Business Process.

•

Good experience in all phases of BI implementation- Modeling, Data Extraction, Reporting

and Data Analysis.

•

Expertise in working with different types of extractors like generic extractors, LO-Cockpit.

Good experience in creating SAP BI components like Info objects, Info cubes, Info source,

•

Multi providers, ODS objects, Transfer structure, Transfer rules, Update rules and Info

packages.

•

Knowledge on Performance tuning for Improving data loading and query performance by

maintaining Aggregates, Compression, Partitioning, Indexing of Info Cubes

•

•

•

Involved in Extracting the data from R/3 to BI, Loading (Full/Delta Up-Load) and Monitoring.

Have knowledge in Remodeling, Repartitioning.

Created Queries having Filters, Free Characteristics, Exceptions and conditions, Variables,

Restricted Key Figures and Calculated Key Figures.

•

Good experience in Process Chains creation to automate loading of all Master and Transaction

data in background and sending mails in case of errors.

Worked on all kind of Transport activities in BI (Transporting of info cubes, ODS, Queries

•

etc)

Involved in extracting data from SAP R/3 and flat file.

•

Good Experience in generating the Reports.

•

Experience:

Presently working with TCS in Bangalore, as an SAP BI Consultant.

Education:

•

B.Tech (Mech) from Jawaharlal Nehru Technological University, Anantapur in the Year of

2009

Technical Skills:

ERP

Data warehouse

Reporting Tools

: ECC 6.0

: SAP BI 7.0 BW

: BEx Suite, SAP BO

Career Profile:

Project 3#

Client

Duration

Project type

Role

Environnent

Responsibilities:

•

•

•

•

•

•

•

Extensively worked with Basic Cubes, Dsos, Info objects, Data sources and Process Chains.

Involved in Installing and Customizing the Business Content Objects.

Activated and modified standard extractors as per Business Requirement

Created Generic extractors in Project System Module as per Business requirement

Worked on controlling Standard extractors like on Generic Extractor

Involved in standard master data source enhancement

Experience in Extracting data from SAP R/3 Source systems by using LO Cockpit and

expertise in extracting data from Generic Extractors

Improved data loading and query performance by compression, aggregates, indexes and

rollups onto Info cubes

Maintained routines for required objects.

Monitoring of Master Data and Transaction Data uploads via process chains

Actively involved in Rectification of Load failure Errors like Master Data Loads and

Transactional loads

Involved in validating data consistency in reporting with Data Target against PSA after

loading them to data targets

Involved in creation of Transformation and DTP (data transfer process).

Involved in defining queries using Filters, Variables, Conditions and Exceptions, Restricted

and calculated Key Figures in BEx Analyzer to facilitate data analysis

Involved in the Transport connections.

Involved in the designing of Queries on Info Cubes and on ODS

Created with the application specific and generic data extractors in Logistics.

•

•

•

•

•

•

•

•

•

•

: A.S Watson, USA

: August 2010 to Till Date

: Implementation

: SAP BI consultant

: ECC 6.0, SAP BI.

Project 2#

Client

Duration

Project type

Role

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

Involved in scheduling the data to info cubes, info objects and ODS objects daily, weekly and

monthly

Created Process chains for effective scheduling of various loading processes

and Info Package Groups for loading and scheduling, Delta and Full loads

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

Involved in both the Activities monitoring and Production Support.

Involved in validating data consistency in reporting with Data Target against PSA after

loading them to data targets.

•

•

•

•

•

•

•

: Lupin Pharma, Kalina, Mumbai.

: Jan 2010 to July 2010

: Support

: Technical consultant

Involved in Debugging Update Routines, Start routines.

Involved in maintaining lot of documentation for all the Support Activities.

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

Actively involved in Rectification of Load failure Errors like Master Data Loads and

Transactional loads

Have worked on Performance issues for Data loading and faster Query Execution

•

•

•

•

•

Project 1#

Client

Duration

Project type

Role

Performed Data Extraction and Data Staging.

Installed and worked with FI-AR (line items) and AP (line items) cubes. Also worked with the

standard ODS objects (line items).

Installed and activated the standard Info Cubes, ODS objects, Info Objects and various other

relevant objects.

Optimized the load performance by adjusting the packet size, number range buffering, etc.

Loaded the data from R/3 to BW using Initialization with delta update and full update methods

Involved in the designing of Queries on Info Cubes and on ODS

Worked with the standard SD business content Data sources and Cubes (Billing and Sales

Overview).

Involved in uploading both Master data and Transaction Data from the source system into the

SAP BW

Involved in Performance Tuning of Queries by maintaining Aggregates, Compression,

partitioning, indexing of Info Cubes, etc

Created with the application specific and generic data extractors in Logistics.

Worked extensively on BEx Analyzer and created queries using calculated and restricted key

figures. Structures, Variables, Conditions, Exceptions, Free characteristics and Filters.

Customized BEx Queries for Users Requirements

Created Workbooks and used RRI jump queries to drill down to others queries and R/3

transactions.

: Textrade International Ltd., Mumbai

: Mar 2009 to Dec 2009

: Support

: Technical Consultant

Contact this candidate