NIVASU

Email:acgs73@r.postjobfree.com

SAP BI Consultant Contact no:

+91-779*******

Professional Summary:

Having 3+ years of professional work experience as SAP Business Intelligence

Consultant, I Involved in Two Implementation and One support projects as a SAP BI

Consultant.

• Extensively worked on data modeling- Info cubes and DSOs, Data sources,

Transformations, Info packages, DTPs and Multiproviders, designing custom Info

objects.

• Expertise in Extraction, SAP Multi-dimensional/Extended Star Schema data models,

BW Customizing, BEx & Web Reporting and BO reporting using Web Intelligence.

• Extracted data from Logistics applications using LO Cockpit and performing

necessary procedures like Deleting Setup Tables, Filling up of Setup Tables and used

initialization & delta updates and Setting up of Queued Delta for deltas.

• Data load issues and Process Chain maintenance.

• Worked with PSA in monitoring the data transfer from source system into BI.

• Responsible for migrating data source for 3.x to 7.0.

• Involved in changing the Existing data model of an Info Cube by adding new

Characteristics and Key figures.

• Worked on BEx Query designer in designing reports using calculated key figures,

restricted key figures.

• Experience in installing the Business Content Objects depends on client

requirements.

• Experience in working in SAP BI Production Support Environment and Resolving the

Tickets based on Priority.

• Involved in transporting the objects.

SKILL SET:

• Modeling : Info Objects, Info Sources, Info Cubes, DSO/ODS objects, Multi

Providers, Virtual Providers, Data Sources, Transfer rules, Update rules,

Communication structures, Info packages, Info object catalogs and Process Chains.

• Extraction: Generic, LO cockpit, Activation and maintenance of data source in

source system, filling up and deleting setup tables, customizing and enhancement of

Extract Structures.

• Reporting: BEx-Analyzer, Condition reporting, Exception highlighting, restricted key

figures, Variables, filters, Free Characteristics and Structures in SAP BW.

• Performance :Aggregates, partitions and Compression, roll up.

Professional Experience:

• Presently working as a Netweaver BI Consultant for Arteria technologies from Sep

2013 to till date.

• Worked as Associate BW Consultant for Vivera IT from May 2012 to Aug 2013.

• Worked as Associate BW Consultant for Spectra Soft Technologies from Apr 2011 to

May 2012.

Educational Qualifications:

Bachelor of degree (B.com) from Acharya Nagarjuna University.

Technical Skills:

Operating System : MS-DOS, Windows

ERP : SAP R/3 4.6C, 4.7EE, ECC 6.0

Reporting Tool : BEx,

Data Warehouse : SAP BW 3.5, BI 7.0.

Application Programs: MS Word, MS Excel, MS Power Point.

Project #3:

Organization : Arteria technologies

Client : Flextronics International Ltd

Environment : SAP BI 7.0, ECC 6.0

Role : SAP BI Consultant

Type : Implementation

Duration : Sep 2013 to Till date

Client Description:

The Flextronics team spans 30 countries and four continents, and is over 200,000 people

strong. At Flextronics impossible is where breakthrough begins. As a socially-

responsible, global leaderin design, manufacturing, distribution and aftermarket services,

Flextronics is unique in its ability to provide end-to end solutions through its innovative

and proprietary systems-all to enhance customer competitiveness and success Working

across four business group and several business units, Flextronics is and success.

Working across four business groups and several business units, Flextronics is able to

unleash the full potential of the world’s most valuable brands and new ventures.

Roles & Responsibilities:

Involved in installing Business content Objects like Info Areas, Info Objects, and Info

cubes, Data Store Objects, Info packages and Data Transfer Process.

Involved in creation of Info cubes, Data store Object (standard DSO, Write Optimized

DSO) and Multi Providers.

I was also involved in writing start routine, end routines in building the

transformations to the different source objects.

Involved In Bex Query Designer and Bex Analyzer.

Created queriesby using Variables, Calculated key figures, restricted key figures,

Conditions and Exceptions, Filters according to end users requirement.

Involved in Jump Query using RRI (Report to Report Interface).

Involved in Performance tuning like Creation of aggregates, Partitioning, Indexes and

Compressed the Info Cube to improve the query Performance.

Project #2:

Company : Vivera IT

Client : Burberry

Project Type : Support

Role : SAP BI consultant

Duration : May 2012 to Aug 2013

Client Description:

Burberry Group is a British luxury fashion house, distributing clothing, fashion

accessories fragrances and cosmetics, Burberry is most famous for its trench coat, which

was designed by founder Thomas Burberry. The company has branded stores and

franchises around the world

and also sells through concessions in third-party stores. The company is listed on the

London Stock Exchange.

Responsibilities:

Schedule Daily/Weekly/Monthly data loads schedule new jobs

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or

not after the data loads

Monitoring master data loads and transaction data loads.

Monitoring process chains and handling problems

Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW is same.

Data loading was monitored and the failed data packets were analyzed and if possible

manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.

Used delta upload mechanisms to upload SAP R/3 source system data to SAP BW and

also involved in uploading of Master and Transaction data

Project #1:

Organization : Spectra Soft Technologies

Client : GBL (Godavari Bio Refineries Ltd)

Project Type : Implementation

Role : SAP BI consultant

Duration : Apr 2011 to May 2012

Description : GBL is one of the largest producer and manufacturer of Sugar, Alcohol

Based Chemicals and

Energy.

Responsibilities:

Worked on administrator workbench, and customized info objects, and created Info

Cubes and loading data into that by using transformations and DTP. Identifying

the key figures and attributes.

Worked on queries using Selections, Structures, Calculated Key Figure, Restricted

Key Figure and Used Variables.

Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW are same or

not after the data loads.

Data loading into SAP BW Info Objects, DSO and Info cubes.

Involved in creation of info set and multi provider.

Extensively worked in many Performance issue improvements in both loading and

Execution activities by maintaining aggregates, Indexes.

Designed and developed Process Chains for Master and Transaction data loads and

scheduled for periodic loads.

Created Meta chain and Process Chains.

Contact this candidate