G.Indra Sena Reddy

ceajh0@r.postjobfree.com

Mobile: +91-886******* SAP BI consultant

Summary:

Have 3 plus years of experience in Production Support of SAP Business Information Warehouse including Development experience in BI (7.0). Hands on Experience on Data-Modeling, Data Extraction, Data Loading (Full/Delta Upload), Scheduling, Monitoring and Reporting.

SAP BI/BW Expertise:

• Design & Maintenance of Info objects, Info Cubes, DSO Objects, Multi providers and Infosets.

• Involved in Installing & Activating Business Content objects.

• Good experience in BI 7.0 data loading through DTPs and transformation, created DTPs and Transformations.

• Experience in Data Loading (Full/Delta Up-Load) of Master and transactional data from SAP R/3 and Flat files, Scheduling, Monitoring of process chains.

• Capable of handling errors while extracting from SAP R/3 and loading the data into Data Targets.

• Extensively involved in setting up the procedures for LO Cockpit, Involving Activating the Business Content Data Sources, Maintaining the Extract Structure.

• Involved in creating Generic Extractors.

• Hands-on Experience LO data Source enhancements.

• Designed and developed process chains (RSPC) for master data loads and transaction data loads.

• Development of Queries in BEx Query designer using Calculated and Restricted key figures, Structures, Variables, constants, Exceptions, Conditions, cell restrictions in BEx Analyzer.

• Good experience in improving the Effectiveness for query performance as well as loading of data to the data targets by using Indexes, compression, Aggregates, partitioning, Maintaining Data packet Sizes.

EDUCATION QUALIFICATION:

• B.Sc from Acharya Nagarjuna University.

Technical Skills:

Data Warehouse : SAP BW3.5/BI 7.0

ERP : SAP ECC 6.0

Programming Languages : C, .Net C#

Operating Systems : Windows 2000/NT/XP

Professional Experience:

Currently working as a SAP BI Consultant with Mahindra Satyam Computers, Bangalore from Jan 2009 to till date.

Worked as a SAP BW Consultant for Bristlecone India Ltd ., Bangalore from Nov 2007 to Dec 2008

Project #1:

Company : Mahindra Satyam Computers

Client : American Bottling Company

Duration : Jun 10 – Mar 11 till date

Role : SAP BI Consultant

Environment : SAP BW 3.5, SAP ECC 6.0

CLIENT DESCRIPTION:

Cadbury Schweppes is one of the biggest international beverage and confectionery companies in the world with a market capitalization of £9 billion. With a history stretching back over 200 years, today Cadbury Schweppes has around 54,000 employees and its brands are enjoyed in almost every country around the world. CS is also called as American Bottling Company.

Responsibilities:

• Monitoring of Process Chains and analyses of failures of process chains.

• Maintained Info Packages and scheduled them in order to load Master Data and Transactional Data from SAP R/3, File Source Systems into Info cubes.

• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BI are same or not

• Informing Clients about the Success / Failure of the loads as soon as the activity is finished.

• Handling the tickets requested by team lead.

• Created copy of Process Chain as per Requirement.

• Performed roll up activities, and Compressing the info cube to improve query performance.

• Maintained Aggregates and Indexes for Info Cubes to improve performance.

• Monthly, weekly and Daily schedules of Data Loads.

Project #2:

Company : Mahindra Satyam Computers

Client : Texaco BI (Implementation)

Duration : Jan 09 – May 10

Role : SAP BI Consultant

Environment : SAP ECC 6.0

CLIENT DESCRIPTION:

Texaco Corp. is a leader in applying its core technologies (upstream and downstream) in technical service, support and research and development in oil and gas, refining processes, petroleum products and power with the goals of creating and expanding business opportunities, building new revenue streams, reducing costs and increasing efficiencies in all business segments

Responsibilities:

Creating objects like DSOs, Info Cubes, Info Objects.

Creating Transformations, DTPs and Info Packages.

Preparing Object design documents for Objects.

Testing the objects like DSOs, Info Cubes, Multiproviders and Info Objects.

Testing the transformations and Info Packages and DTPs.

Loading the data targets using DTPs and Info Packages.

RE-MODELING of Info Cube by adding Info Object to it.

Testing the loaded data with R/3 data (Reconciliation).

Monitoring and analyzing the reasons for frequent failures of info packages.

Maintaining the queue – related to the system generated and customer generated tickets.

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

To communicate with the customer who posted the Ticket.

Resolved customer reported tickets through email and phone.

Checking previous load failures to load new loads and resolved.

Project #3:

Company : Bristlecone India Ltd

Client : Unilever

Duration : Nov 07 – Dec 08

Role : SAP BW Consultant

Environment : BW 3.5, SAP ECC 4.7

CLIENT DESCRIPTION:

Unilever was arguably the world's first packaged goods manufacturer, and is still one of its biggest companies. "Meeting the everyday needs have people everywhere" is how the group describes itself. It is the world No1 in culinary foods, ice-cream, and tea-based beverages; also in personal wash, prestige fragrances and deodorants. Brands include Dove and Axe/Lynx, as well as Knorr, Lipton and Magnum. A US-based Best food, Unilever's foods business is the world's third largest after Nestle and Kraft.

Responsibilities:

Monitoring the process chains (RSPC) for master data loads and transaction data loads.

Monitoring the jobs in source system and make ensure that all the jobs executes by end of the working day

Schedule daily /weekly/ monthly data loads and jobs, monitored the loads and analyzed the reasons for frequent failures

Worked extensively on Remodeling and Re-partitions

Creation of Info Packages for scheduling the data load process with Full, Initialize delta and Delta Update modes

Maintenances of Transfer rules and Update rules in the data flow

Loading of flat files

Created Info Packages and scheduled to load the data from various Source systems SAP R/3, Flat File

Performing the data targets by having the correct and up-to-date data like

Reconstructing the data requests from PSA in case of data load failures.

Roll up of data from Info Cubes to Aggregates, Compression.

Interacted with client to get the input from the user to close the tickets

Supported the client by providing long term solutions to the tickets and maintained

Contact this candidate