SUMMARY :

. Having * years of experience as SAP BW/BI consultant.

. This experience includes one full life cycle Implementation

project and One support project .

. More focused on Modeling, Data Extractions & Reporting.

BW/BI EXPERTISE :

Modeling:

. Worked extensively on Data warehouse Workbench.

. Involved in creation of customized Meta Objects (Info Objects, Info

Cubes, DSO, Transformations, DTP's, Aggregates, Multi providers, Info

sets).

. Has good knowledge of Business Content.

. Loading Master data & Transaction data using flat file & other Source

systems as R/3

. Creation of Info package & designing Process Chains for Data loading.

Reporting:

. Involved in creating Key Figures, Restricted Key Figures, Calculated

Key Figures, Defining Filters, selecting Filter values for

characteristics, suppressing the display of repeated text or key

figures, Drill down or across, Sorting Data.

. Business Explorer, Reporting Variables, Web Reporting, Pre-calculated

Web Templates.

. Knowledge in Crystal reports.

Customizations:

. LO Extraction, Generic Extraction, Flat File Extraction.

Admin Specialization:

. Extensive experience in support, Data loads, Validation and trouble

shooting of transaction data and Master data, Change management,

Transport Management, System Checks, Performance tuning and process

chains.

Performance Tuning:

. Improved Query and load performance using Aggregates, Indices, Packet

Size, Data Selection and Data Compression.

ACADEMIC CREDENTIALS :

. B.Tech in Electrical & Electronics Engineering at Nalanda Institute of

Engineering and Technology in 2012 from JNTU, AP.

PROJECT 1

SUPPORT PROJECT

CLIENT : RICH'S

Role : sap bi consultant

Organization : TECNICS

Duration : Jun 2012 to Sep 2013.

Environment : SAP BI 7.0

CLIENT DESCRIPTION

Rich products corporation is one of the world 's largest family-owned food

companies and a leading global supplier to the foodservice,in-store bakery,

retail and industrial maketplaces. The company is the world leader in non-

dairy toppings, icings and other emulsions. Other key products categories

include Cakes and Desserts; Pizza, Bakery products; Breads and Rolls;

Shrimp and Seafood; Appetizers and Snacks; BBQ; Meatballs and Pasta; and

Gluten-free and all-natural items. Rich's has been committed to developing

food solutions that raise the bar on quality, convenience and efficiency

for our customers. our delicious innovations can be found in kitchens and

bakeries around the world. Rich's has to reduce our environment footprint,

specifically in the areas of Energy efficiency Water management Waste

reduction Throughout our distribution network, we are looking at ways to

reduce total energy use and food miles.

Responsibilities:

. Handling tickets with different priority, and working on never missing

the SLA.

. Participating in submitting the ticket status (Open/ Close) report.

. Participating in both the activities monitoring and production

support.

. Maintaining work history for all the tickets until it is closed down

. Created and scheduled the Error DTP to handle the error records in the

Error Stack.

. Participating in validated data consistency in reporting with data

target against PSA after loading them to data targets

. Involved in maintaining lot of documentation for all the Support

Activities.

. Monitoring and Managing of DSO object, Info Cubes and PSA requests.

. Monitoring of data loading through process chains.

. To communicate with the customer who posted the Ticket.

PROJECT 2:

IMPLEMENTATION PROJECT

CLIENT : Zoetis Stream link (Pfizer)

Role : sap bi consultant

Organization : I B M

Duration : Oct 2013 To Till Date

Environment : SAP BI 7.3

CLIENT DESCRIPTION

Zoetis is a global animal health company dedicated to supporting customers

and their businesses in ever better ways. Building on 60 years of

experience Zoetis deliver quality medicines and vaccines, complemented by

diagnostics products and genetics tests and supported by a range of

services. Zoetis are working every day to better understand and address the

real-world challenges faced by those who raise and care for animals in ways

they find truly relevant. Zoetis approach our work with the understanding

that protecting animal heath helps protect and enhance human health.

Responsibilities:

. Installed Business Content and designed and activated Customer service

to meet user needs. Created several DSO objects which acts as data

staging. Configured Data sources in R/3 by using LO Cockpit (LBWE)

initialized the setup tables.

. Involved in Creating and maintaining Info Cubes, Data store Objects,

PSA, Info Objects, Info Areas, Multiproviders, Data Sources, and Info

Packages.

. Created custom queries and defined Calculated Key Figures, Restricted

Key Figures, Text Variables, etc. For customized reporting using Bex

Analyzer, Designed and developed several workbooks and global Views.

. Involved in creation of reporting using BEx Analyzer such that the

execution time is evenly distributed throughout the report by using

free characteristics, Restricted Key figures, and Calculated Key

figures, Variables, Exceptions.

. Uploaded master and Transactional data from flat files, SAP BW and SAP

R/3.

. Transported developed objects from development box to quality box.

. Created, Cubes and Multiproviders to load the transactional data

according to the BW star schema documents and data flow diagrams.

. Loaded the master data and transactional data.

. Updated Data through PSA for Info Cube, DSO using Delta, Full update.

. Updated Data from DSO to Info Cube using with Delta Update.

. Worked with open hub service to download the data from BW to flat

files.

. Maintain Aggregates, Rollups, and Compression for improving query

performance.

. Creation of Process Chains for Master Data and Transaction data.

. Involved in creation of SPO's (Semantically Partitioned Objects).

PERSONAL DETAILS:

Date of Birth : 04-06-1991

Gender : Male

Permanent Address :Guntur,

Andhra Pradesh-522403.

DATE:

STATION:

M.Siva Prakash

[pic]

Contact this candidate