Sap Data

Rajpal

SAP BI&BO Consultant

Mobile : +91-814*******

E-Mail : ***************@*****.***

[pic]

Professional Summary

[pic]

> Having 2+ years of work experience as SAP BI & BO Consultant with one

implementation and one support projects.

> Work experience of BW Accelerator, BI Security, BI Transports, BO

Server Administration, Transportation of BO objects using Import

Wizard and Promotion Management (LCM).

> Worked with Webi, Crystal, Dashboard and Explorer tools.

> Having good understanding of the customer business processes.

> Excellent communication and presentation skills and Customer Oriented

attitude.

> Team player with excellent interpersonal skills.

> Ability to work independently with minimal supervision to meet

deadlines.

[pic]

SAP EXPERTISE:[pic]

. Modeling: Info Objects, Star schema, Transfer methods, Infocubes, DSO

Objects, Transfer rules, Update rules, Infosources, Datasources,

Transformations, DTPs, Business Content, Infopackages, Multiprovider,

Infoset, Full upload, Initialization, Delta upload, Open Hub Services,

Hierarchies, Navigational and Display attributes, Line item dimension,

PSA, BIA, Authorizations, Transport connection.

. Extraction: LO Cockpit and Generic data extraction.

. Reporting: BEx Analyzer, BEx Designer, WAD, Free Characteristics,

Filters, Formulas, Calculated Key Figures, Restricted key figures,

Conditions, Variables, Exceptions, RRI Reporting, Workbooks,

Structures, Infoset query and Reporting agent.

. BO: Universe Designer, Information Designer, Web Intelligence, Crystal

Report, Xcelsius, Live-office, Explorer, Infoview/LaunchPad and CMC.

. Performance tuning (Query and Load Performance): Maintaining

Aggregates, Rollup of aggregates, Compression, Partitioning of

Infocubes, Data Packet Sizing, Query monitoring (RSRT) and Index

maintenance.

[pic]

Professional Work Experience

[pic]

> Currently working with Tata Consultancy Services, Bangalore from Nov

2011 to till date.

> Worked with Keane India Ltd, Bangalore from Nov 2010 - Oct 2011.

[pic]

Educational Qualification

[pic]

> Bachelor of Technology (B.Tech) in Electrical & Communication

Engineering from JNTU University, Hyderabad in 2010.

[pic]

Summary of Technical Skills

[pic]

> SAP Business Warehouse : SAP BW 3.5, SAP BI 7.0, BO 3.01 and

4.0.

> ERP : SAP R/3 version 4.7, ECC

6.0.

> Operating Systems : Windows family.

PROJECT DETAILS

SAP AG Nov 11

- Till date

SAP BI/BO Technical Consultant

Client Description:

SAP is the market and technology leader in business management software,

providing comprehensive business software through SAP applications and

services. As market leader in enterprise application software, SAP helps

companies of all sizes and industries run better. Founded in 1972, SAP

(which stands for "Systems, Applications, and Products in Data Processing")

has a rich history of innovation and growth as a true industry leader.

Responsibilities:

V Handling of all priority tickets from Low to Very high and

Maintaining Work history until ticket's closure.

V Uploading Master and Transactional Data Loads on Daily, weekly, and

Monthly basis using Process Chains.

V Actively involved in data load Monitoring and rectification of load

failures (including master and transactional loads) for reporting

availability of data.

V Supported the client by providing long-term solutions to the

tickets by doing Root cause Analysis.

V Involved in deleting and filling of the setup tables on demand

basis.

V Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW

are same or not after the data loads on daily basis.

V Worked with Repair full, Init and delta loads.

V Analyzing the system dumps and applying the OSS notes to correct

the issues.

V Measuring query performance and aggregate effectiveness on monthly

basis and suggesting customer for better performance.

V Creation and maintenance of BI Accelerator indexes on cubes.

V Involved in activities like PSA deletion based on retention period,

Rollups and Compression of cubes.

V Regular monitoring of BO Systems and Alerts.

V Transporting the BI and BO objects from Development to Production

environment.

V Involved in trouble shooting of InfoView/LaunchPad and CMC

application issues by checking the EventViewer Logs.

V Involved in administration of Servers by performing Stop/Start of

Tomcats, SIAs and other BOE Services whenever required.

V Worked with Universe Designer and Information Designer Tools.

V Resolved the loops using aliases and contexts.

V Involved in creation of various Web Intelligence, Crystal and

Xcelsius Reports on OLAP and Relational DataSources.

V Monitoring and Indexing of Information spaces on demand basis.

TVS Motor Company Nov 10 -

Oct 11

SAP BI Technical Consultant

Client Description:

TVS Motor Company Limited is the third largest two-wheeler manufacturer in

India and among the top ten in the world, with an annual turnover of over

USD 650 million. TVS Motor Company is the first two-wheeler manufacturer in

the world to be honored with the hallmark of Japanese Quality - The Deming

Prize for Total Quality Management.

Responsibilities:

V Worked with RSA5 to install the Business Content data sources.

V Worked with RSA6 for the post processing of the data source.

V Replicated the data sources in BI.

V Extensively worked on LO Cockpit and performed necessary procedures

like setting up of Update Mode, deleting set up tables and filling

up of set up tables.

V Loaded the data from SAP R/3 to SAP BW using Initialization update

and delta update.

V Scheduled Info packages for loading Master Data and Transaction

Data.

V Designed Process Chains (RSPC) for master data loads and

transaction data loads with the help of InfoPackages and DTPs.

V Scheduled DTP for loading Transactional Data from PSA to Info

Provider using process chains.

V Implemented BI Statistics and involved in performance tuning of

Queries by maintaining Aggregates, Compression, Partition and

indexing of Info cubes.

V Setting up of procedures for extracting data from SAP R/3 by using

Generic Extraction, Customizing LO Cockpit as per requirements.

V Involved in Unit Testing and transports for the developed objects.

V Involved in creation of reports using Query Designer such that by

using Restrictions and Conditions, Exceptions, Free

Characteristics, Restricted key figures, calculated key figures and

Variables.

[pic]

Personal Profile

[pic]

1. Marital Status : Single

2. Nationality : Indian - Hindu

3. Passport : Available

4. Languages : English, Hindi and Telugu.

Rajpal

Mobile: +91-814*******

E-Mail : ***************@*****.***

Contact this candidate