Data Sap

Rajasekhar Babu A. E-mail: ***********@*****.***

SAP BI Consultant. Mobile: +91-950*******

Career Objective:

To obtain a challenging position in a global company to leverage my excellent communication skills, experience and grow professionally where acquired skills and education will be utilized towards continuous growth and advancements.

Professional Summary:

• 3+ years of experience as SAP BW & BI consultant.

• Involved in implementation, maintenance & supporting of Business intelligence module in SAP with prime focus on SAP BW, BI 7.0.

• Currently working with Content Logic Systems Pvt. Ltd., Bangalore as SAP BI consultant from September 2008 to Till Date.

Technical Skills:

• ERP and Data Warehousing packages: SAP R/3, SAP BW 3.5/BI 7.0.

• Operating Systems : Windows 9X, NT, 2000/XP

• Database : SQL

• Reporting tools: SAP Business Explorer (BEx) Analyzer, Web reporting.

SAP Skills:

• Actively Involved in managing of Info Cubes, Info Object maintenance, DSO Objects, PSA, Info Source, Data source, Transformations, types of DTPs, Info sets, Multi providers, Info packages and scheduling the data requests.

• Knowledge on open hub service (info spokes), DSO, Business content. Worked on Performance tuning to improve data load and query performance by doing compression, aggregates, rollup and partitioning.

• Involved in data modeling by designing info cubes which required Info cube management through Compression, Rollup, Reconstruction, Indexes Partitioning, performance tuning by developing Update Rules and Transfer Rules, transformations and DTP.

• Strong knowledge on enhancing data sources in LO-Cockpit extraction methods.

• Experience in creating Info Packages to create Process chains and Scheduling of data loading with Full/Initialization/Delta upload methods.

• Designed queries in BEx Query Designer, created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.

• Knowledge on Currency Conversion, Real Time Data Acquisition(RDA).

• Knowledge on Inventory Extraction, Web Application Designer(WAD), Analysis Process Designer,

• Knowledge on Integrated Planning – Aggregation Level, Filters, Planning Functions, Planning Sequences, Data slices etc.

Work Experience Profile:

PROJECT # 1

Client Thomson Reuters

Tools used SAP BI

Date MAR 2011 – TILL DATE

Client Description:

Thomson Reuters with headquarters in New York and major operations in London and Eagan, Minnesota is the world's leading source of intelligent information for businesses and professionals to combine industry expertise with innovative technology to deliver critical information to leading decision makers in the financial, legal, tax and accounting, scientific, healthcare and media markets, powered by the world's most trusted news organization

Responsibilities:

• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to the targets.

• Reconstructed the data requests from PSA in case of data load failures.

Worked on Reconciliation to verify the data in SAP R/3 and SAP BI side.

• Worked on performance tuning activities like creating indexes and aggregates, Roll up data from info cubes to aggregates.

• Monitoring of Info Packages and analyzing the reasons for frequent failures of Info Packages.

• Handled production support issues in transfer rules, extraction levels and PSA levels.

• Maintained full upload and Generic delta to load records from source system to BI system to generate reports.

• Responsible for migrating emulated data sources migration from BW to BI.

• Monitored process chain by assigning the start process to the other processes to perform the loads periodically.

• Designed info objects, info cubes and DSO and performed back ground scheduling through process chain by monitoring the data loads step by step by creating info package groups.

• Generated reports by using variables, variable processing by user value, replacement path, etc.

• Knowledge on BEx Reporting using Selections, Exceptions, Conditions, Structures, Calculated Key Figure, Restricted Key Figure and Variables.

• Handled tickets with different priority regarding extraction, performance issues and load failures

PROJECT # 2

Client WINCRO

Tools used SAP BW

Date JAN 2010 – FEB 2011

Client Description:

Wincro metals and industries, designers and manufacturers of high integrity stainless steel Buildings systems, Wincro systems are specified for major building developments throughout Europe.

Responsibilities:

• Redesigning process chain for Master Data Load and Transaction Data Load.

• Major Responsibilities include Data loading / Monitoring /Ticket solving.

• Performed generic extraction by view using relationships between tables

• Extracted data from different modules of SAP R/3(SD, MM) into SAP BI system.

• Process chain monitoring ,handling data loading problems etc

• Worked on Open Hub Services to transfer the data from sap bi system to External system.

• Involved in extracting ECC6 data for Sales and Distribution using LO- Cockpit and Generic Extraction

• Responsible for creating transformations, DTP processes, DSO and generate export data sources to transfer data from DSO to info cube and to info set.

• Worked on Variables such as Formula variable, Text variables, Characteristic variables, by processing type user entry/default, Replacement path and SAP Exit

PROJECT # 3

Client CHEMINOVA

Tools used SAP BI

Date NOV 2008 - OCT2009

Client Description:

Cheminova is a manufacturer of fine chemicals, with its main business area in production and marketing of plant protection products. Outside plant protection products, Cheminova maintains an important fine chemicals business. Flotation agents used in the mining industry is another business area and markets its products globally through subsidiaries in 20 key countries and through distribution partners in most other countries.

Responsibilities:

• Have experience to load MD and TD from flat files and from OLTP systems.

• Extracted data from OLTP by creating info packages with full, initialize delta, delta update methods.

• Handled various types of errors while loading data into info cube.

• Monitored the data loads (daily/weekly/monthly) by means of Process Chains

• Performed delta management using direct delta update, queued delta, un-serialized V3 update methods.

• Created reports using BEx analyzer, BEx browser by variable processing using user entry/default value, customer exit and replacement path.

• Scheduling of Extract Jobs using process chain, Grouping of extract Jobs, Monitoring of Transfer and Update for data Loads, Monitoring of Status display and Load Statistics for Update Process.

• Customized Drill down reports from Info Cube to DSO.

• Created generic data sources (using tables/views) for extracting the R/3 data from different tables.

• Worked on performance tuning activities like compression and partitioning of Info cubes to improve the query performance. creating indexes and aggregates, Roll up data from info cubes to aggregates.

• Created BEx Reports for User requirements using Filters, free Characteristics, New Formulas, New Selections, Structures, Calculated Key Figure, and Restricted Key Figure

Contact this candidate