Prem Salagundla

Cell: 847-***-****

Email: aceg7t@r.postjobfree.com

EXPERIENCE SUMMARY

A senior SAP BW/BI Consultant Total 9 + years of experience with 8 +years

of experience in IT industry, including 3 full life cycles implementations

experience in SAP BW 3.5,BI7.0,BW 7.3& BO 4.0 and production Support of

SAP BW/BI

. Involved in Understanding the Business Processes, Organization

Structure, Functional Specifications and identification of relevant

areas for Customization.

. Implementation in the area of Insurance, Sales and distribution (SD),

Finance and Controlling (FICO),Accounts Payable (AP), Accounts

Receivable (AR),Material Management(MM).

. Good planner and organizer with demonstrated ability to master new

concepts quickly, incorporate the latest technology and develop

business solutions that increase efficiency, productivity, and

profitability.

. Proficient in creating and customizing Info Source, InfoObject, Info

cubes, ODS Objects, Remote Cubes, MutiProviders, and Infoset and

knowledge of BI data flow, which includes creating Info Cube, Data

store by using Transformations, Data Transfer Process (DTP).

. Extensively worked on Extraction using various methods LO Cockpit,

Generic, CO-PA, FI/SL.

. Worked on POC, BW COE, Integrated Planning(IP)

. Worked on Integration of SAP BI and BO

. Worked on Crystal reports

. Working on migration project BI 7.0 to BW 7.3

. Expertise in BW - Analysis, Configuration, multi-dimensional modeling.

. Worked on SAP Net Weaver 2004s BI (Transformations & Data Transfer

Process) and migrating 3.X data sources into BI 7.0.

. Analyzed the GAPS in SAP provided Business content extractors and Data

sources to enhance them or to create new extractors using Generic Data

Extractors.

. Experience in BW Architecture, Multi Dimensional Modeling, Data flow

strategy, Source System, Data Source, Data modeling (Star Schema),

Info Source, Info Objects, PSA, Data Targets, ODS (DSO), Multi

Providers, Info cubes, Info spokes, process chains, Lo-cockpit -

Enhancements, BExQuery Designer BEx Analyzer, Info sets, Query

Optimizations with new concepts.

. Worked on LO Cockpit, FI-AR, FI-AP, CO-PA and Generic Extractions.

. Experience in web application development and web reporting, Web

portal and extensive experience in Front End BW components like

Workbooks, Queries, Calculated key figures, Restricted key figures,

structures, variables, Formula Variables, Filters, Restrictions,

Conditions, Navigational attributes, Publishing reports to portal,Authorizations, Role Maintenance, Adhoc Reports and Web Reports etc.

. Transferred data from Info Provider to Flat Files by using Open Hub

(Info Spoke) and loaded data to the data targets from different

sources (R/3, Flat Files).

. Expertise in the Performance techniques like Performance tuning,

Aggregates, Compression, Indexes, Statistics and Rollups (Performance

Improvement).

. Involved in documenting Functional specifications, Technical

specifications, Test cases, Test results and Production support

documents.

. Involved in writing ABAP programs to create (Transformations) update

rules and transfer rules, start routines, End routines

. Expertise in Logistics extractors and application specific

extractors such as 2LIS_02_HDR 2LIS_02_ITM 2LIS_06_INV 0FI_GL_4

0SRM_TD_PO 0SRM_TD_CONF

. Experienced with semantic layer creation in BW 7.3

. Supported all phases of a project life cycle including analysis,

design, development, configuration, testing, and development of

solutions, as well as documentation, and end user training.

. Worked on New concepts in SAP BW 7.3, Infospoke BADI migration to Open

Hub Destination Schematic Partitioning etc.

. Extensive experience with SAP BW Accelerator (BWA) setup and index

creating,Trouble shooting in Upgrade project and find out the SAP

notes

. Worked on POC on SAP HANA

. Use BICS to make OLAP connection with BO and BI.

. Expertise in the front end business warehouse components like BEx

analyzer, Query designer, Web Application Designer, Web Reports, WEBI,

Xcelsius, IDT and Dash Boards.

. Working on Business Objects (XI 3.1, 4.0), Web Intelligence,, Info

View, Dashboard Manager, Crystal Reports 2008, Xcelsius 4.5/2008, SAP

Integration Kit

Technical Skills

ERP packages: SAP R/3 Release 4.6B, 4.6C, 4.7, ECC

5.0/6.0, EP 6.0/7.0, Netweaver'04, NW2004S,

SRM 4.0, CRM 4.0/5.0, BW 3.5/7.0/7.3

SAP BI SAP BI versions BW 7.3,BI 7.0, BW 3.5

Operating Systems: Windows 9x/00/XP/NT, UNIX, LINUX, IBM AIX,

SUN- SOLARIS, HP-UNIX

Reporting Tools: Business Objects (XI 3.1, 4.0), Web

Intelligence, Desktop Intelligence, Info

View, Dashboard Manager, Crystal Reports

2008, Xcelsius 4.5/2008, SAP Integration

Kit.

Databases: Oracle 9i/10g, DB2, MS SQL Server, MS Access

Languages: SQL, PL/SQL, ABAP/4, C, C++, Java, Visual

Basic

Others: MS Office, MS Outlook, Adobe Photoshop

Education: B.Tech in Mechanical Engineering from Sri Venkateswara

University, Tirupati, A.P, During 2001- 2005.

PROJECT EXPERIENCE:

Client: Nike Sep

2013 to Till date

Project: Nike Enterprise Business Intelligence (EBI)

Role: SAP BW Consultant

Responsibilities:

. Responsible for providing the resolution for the issues which occur in

quality systems and make sure the issue is fixed as the same issue

will not occur when the jobs are moved to production environment.

. Responsible for monitoring the jobs in quality environment and deliver

the resolution of failed jobs and escalate the issues appropriately to

concerned teams.

. Responsible for providing the delivery status reports and maintain the

delivery is done on time and also review the work done by the team and

determine the actions to be taken to proceed further.

. Involve in batch support, preparing technical documents and coordinate

user acceptance testing.

. Facilitates or performs application support, problem solving, and

issue resolution with internal and external resources.

. Supporting Build/Go live activities and Executing on-demand requests

in QA Environment.

. Executing Business user's on-demand requests, Month end, and Year end

activities

. Coordinating with offshore team and NIKE COE (Center of Excellence)

team, Platform Configuration Teams, Functional teams for completion of

work.

. Use of BICs connections to SAP BW for use in BO reporting

. Created Executive, Managerial and Strategic reports

. Worked on Work space by using Dashboard &BI launch pad for FI, HR &

SRM Functional Users

. Worked on Logistics Extraction SD, PP and other Application specific

extractors

. Extensive experience with SAP BW Accelerator (BWA) setup and index

creating

Client: AllState, IL Feb

2012 to Sep 2013

Projects: Agency Economics, BW 7.3 Upgrade

Role: SAP BW Consultant

Responsibilities:

. Working on agency Economics Project Contributing to all aspects of

SDLC, including gathering of requirements, business and technical

assessments, back-end and front end designs reviews, data validation,

QC support and training

. Implemented new methodology to the agency program to pay under new

variable structure with great values of agency success factor and

customer satisfaction

. Maintain, monitor and execute the BW/BI process chains as per the

requirement.

. Analysis of the Production issues and provides support to Business

Users in a timely manner.

. Co-ordination with the Basis, Security and other teams as required.

. Documenting any changes, issues as required following the SDLC

practices.

. Suggesting any design changes for the Performance improvements.

. Coordinating to offshore to work with project deliverables.

. Involved in Portal, Query upgrade, 11g upgrade projects as part of SAP

BI 7.3 Upgrade.

. Established daily, Period end (Monthly) process to balances data

across upstream and downstream systems.

. Working on Business Objects (XI 3.1, 4.0), Web Intelligence, Info

View, Dashboard Manager, Crystal Reports 2008, Xcelsius 4.5/2008, SAP

Integration Kit

. Extensive experience with SAP BW Accelerator (BWA) setup and index

creating,Trouble shooting in Upgrade project and find out the SAP

notes

Environment: SAP R/3 ECC 6.0, BEX Analyzer, BI 7.0,BW 7.3, Business

Objects (XI 3.1,4.0), Windows server NT/2003

Client: All State, IL Mar 2011 to Feb

2012

Project: Allstate Insurance, FDW Maint & Support

Client profile:

The Allstate Corporation (NYSE: ALL) is the second-largest personal lines

insurer in the United States (behind State Farm) and the largest that is

publicly held. The company also has personal lines insurance operations in

Canada. The company has its headquarters in Northfield Township, Illinois,

near Northbrook.

Role: SAP BW BI Consultant

Responsibilities:

. Launching the data loads as per client requirement on daily basis.

. Scheduling BW jobs, monitoring these Schedules on Process Chains

Monitor and BW monitor.

. Responsible for Monthly Period End process loads for data coming from

R/3.

. Data Extraction from R/3 and flat file, loading the extracted data

into BW data targets.

. Designed and Developed Process chains for automating the Batch data

load of Claims, Premiums, Sales and Expense data coming from

Mainframes system.

. Involved in Performance Tuning and Data Maintenance by creating and

maintaining Aggregates, Compression, Partitioning and Indexing of Info

Cubes.

. Worked on logistics extraction from ECC to bw

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI

7.0, Windows server NT/2003

Client: All State Jan 2010 to Feb

2011

Project: ACSR

Client profile:

The Allstate Corporation (NYSE: ALL) is the second-largest personal lines

insurer in the United States (behind State Farm) and the largest that is

publicly held. The company also has personal lines insurance operations in

Canada. The company has its headquarters in Northfield Township, Illinois,

near Northbrook.

Role: SAP BW BI Consultant

. Worked on Agency Compensation System Re-write, Analyzed requirements

and translated them into Multi-Dimensional Data Models to BW Star

Schema.

. Involved in developing the ETL documents and extracting data from SAP

R/3 using Generic extraction.

. Extraction of History data from mainframe systems in flat file

. Design and develop the data flow in BW with respect to functional and

Technical Specs.

. Worked on Reports, CR Projection Models and Report year Accident year

models in All State as per client requirements.

. Worked on Transportation of Queries and work book and maintain all

security related documents ensure that avoid bottle necks.

. Worked on Enhancement Queries based on user requirements

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI

7.0, Windows server NT/2003

Client: Daimler Jan 2009 to Dec

2009

Project: GPSIS

Role: SAP BI Consultant

Responsibilities

. Replacement of GPSIS

. Migrate the Current application to new architecture

. Creation of Reports Which Describes many available buyer, supplier and

commodity information.

. Provide Supplier's monthly performance data in EBSC

. Provide a global view of commodities: Value of business, which

suppliers deliver a commodity and which buyers buy it

. Interface the GPSIS system to current portals

. Participated in creating reports on annual sales comparison, gross

margin %by store, monthly sales report city and brand, product wise

sales analysis, Quarterly sales report and stock related reports for

the Mobile store.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI

7.0, Mainframe, Windows server NT/2003

Client: MWV Jun 2008 to

Dec 2008

Project: Mead Westvaco Corp

Role: SAP-BI Consultant

Client profile:

Mead Westvaco Corp. MWV is an American packaging solutions company based in

Richmond, Virginia. It has approximately 23,000 employees. Mead Westvaco is

a producer of packaging, specialty papers, consumer and office products and

specialty chemicals. The company has 153 operating and office locations in

30 countries, and serves customers in over 100 countries.

Responsibilities

. Continuous job monitoring using BW Monitor; Handling tickets which

involve solving issues in the area of data Extraction from R/3 and

Flat File, data staging and BEx reporting

. Developed reports using Bex Analyzer,Bex Query Designer and WAD

. Schedule Daily/Weekly/Monthly - data loads schedule new jobs.

. Maintaining Reconciliations to verify the data in SAP R/3 and SAP BW

are same or not after the data loads.

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

failures of info packages.

Environment: SAP R/3 ECC 6.0, BEX Analyzer, Bex Query Designer, WAD, BI

7.0, CRM, Windows server NT/2003

MIND TREE CONSULTING Ltd, BANGALORE

Client: VOLVO Oct

2007 to Jun 2008

Project: Auto Products - Implementation

Role: SAP BW Consultant

Client profile:

Volvo is a leader in the manufacturing of trucks and buses; marine,

aircraft, and industrial engines; and construction equipment. Volvo has

operations in over 185 markets and production facilities in 25 countries.

The company has approximately 70,000 employees worldwide. Volvo Information

Technology is the IT division of Volvo which employs 3,600 people worldwide

and provides IT services to the entire Volvo group.

Responsibilities

. Worked extensively on enterprise data warehousing (EDW)-InfoObjects,

dso's, InfoCubes

. Experience in new design concepts like remodeling and repartioning.

. Hands on experience in controlling data flow using Infopackages,

transformations, various dtp's and process chains.

. Extracted the transaction data by LO Cockpit from R/3 to BW by

maintaining the extract structures, maintaining data sources,

replicating the data Sources into BW

. Activate and extract data from LO-Cockpit, Schedule and Monitor the

load process.

. Involved with Performance tuning of Queries by maintaining Aggregates,

Compression, and Partition of InfoCubes.

. Involved in Data Extraction from CRM transaction data sources like

activity, lead and opportunity.

. Involved in creation of reports on CRM transaction info cubes

activity, lead, opportunity

Environment: SAP R/3 ECC 6.0, BEX Analyzer, BI 7.0, CRM, Windows server

NT/2003

MIND TREE CONSULTING Ltd, BANGALORE

Client: BURGER KING, USA June 2005 to Sep

2007

Role: SAP BW Associate consultant

Responsibilities

Post-Production Support - Responsible for 24X7 hour support of the system

on a regular basis and after new releases of programs or functionality.

Responsibilities included scheduling of failed programs, monitoring of

system resources and debugging.

Continuous job monitoring using BW Monitor; Handling tickets which involve

solving issues in the area of data Extraction from R/3 and Flat File, data

staging and BEx reporting

Extensively used calculated and restricted Key Figures. Created variables

for the queries

Developed reports using Bex Analyzer and Bex Query

Schedule Daily/Weekly/Monthly - data loads schedule new jobs.

Maintaining Reconciliations to verify the data in SAP R/3 and SAP BW are

same or not after the data loads.

Monitoring of info packages and analyzing the reasons for the frequent

failures of info packages.

Analyzed and corrected production problems as they occur in the SAP BW

Environment: SAP R/3 4.6c, BW 3.5, CRM 4.0, SRM 4.0, IBM-AIX 9.2.04, ITS

6.20, Oracle 8i, 9i, MS SQL 2000.

Contact this candidate