Shilpa

Senior SAP BI/BW Consultant

Mob: 949-***-****

PROFESSIONAL SUMMARY:

. Overall 9yrs years of experience out of which 7+ years in SAP BW 3.5/BI

7.0/BI7.3, SAP Business Objects XI R 3.1 & 4.0.

. Involved extensively in implementation and support projects for Supply

Chain modules (SD, MM, Real State and APO) and FI in SAP BI/BW.

. Expertise in SAP BW/BI architecture, back end data modeling and front-end

development using BEx query designer and BEx analyzer.

. Expertise in SAP business objects Universe development and reporting

tools such as Webi.

. Analyzed the business requirements and translated into dimensional data

models by using extended star schema techniques.

. Extensively involved in the LO data extraction, Generic (View, FM, Info

set Query) and non-SAP data into SAP BW server.

. Strong experience in working (Design, code, test) with Custom Extraction

(using function modules and Views).

. Experience in enhancing the Business content based on requirements.

. Experience with BI/BW components including data source, DSO's, Info Cube,

Multiprovider, transformations, DTP's, Info sources, BI content.

. Performed data load management, experience in scheduling start process

and process chains of Events, data source enhancement, OLTP extraction

data, loading (full/delta up-load), monitoring, data mart and open hub

service.

. Expertise in BW performance tuning by maintaining aggregates,

compression, partition, process chains, indexing of info cubes and use of

statistics for the same. Extensively used variety of techniques to boost

the performance of BEx query.

. Expertise in BW reporting using BEx Analyzer, BEx designer, Web

Application Designer, and implementing BEx queries, calculated and

restricted key figures, variables and workbooks, security roles and

profiles.

. Developed flexible queries using filters, navigational attributes,

variables, in BEx designer to facilitate data analysis in a drill down or

summarized way to give details level of information.

. Customized the postproduction data model and generated Adhoc queries as

per the specifications.

. Coordinated integration testing with process teams to validate data and

seek end user acceptance.

. Created Universes using Universe design tool and information design tool

(IDT).

. Created Web Intelligence report using Bex Query and Universe.

. Efficiently managed teams of various sizes and worked with the team to

achieve company and client's goals.

. Understanding of Order To Cash (OTC) life cycle and backend tables.

. Knowledge of SAP HANA, SLT and BODS.

TECHNICAL SKILLS:

ERP Packages SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0

SAP SAP BI 7.0,BI7.3, BW 3.5, SAP Business Objects XI R 3.1

& 4.0, Info View, SAP HANA

Reporting Tools BEx Query Designer, BEx Analyzer, Workbooks, Web

Application Designer, Report Designer, Visual Composer,

Crystal Reports, XCelsius, WEBI, QAAWS.

Functional Module Logistics (SD, MM), APO, FI (AP, AR, GL)

Languages/Scripts ABAP/4, PL/SQL, C, C++, Java, JSP, HTML, DHTML, XML

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

Operating Systems Windows 95/98/NT/2000/XP/Vista/7, Windows 2000/2003

Server

PROFESSIONAL EXPERIENCE:

Employer: Popular Tech, Irvine, California Feb

2013 - Current

Client: P&G, Cincinnati, OH

Project: S2C

Role: SAP BI/BW Project Lead

Description:

Procter & Gamble (P&G) is the largest manufacturer of household products in

the US, Head quartered out of Cincinnati. P&G manufactures and markets

approximately 250 Brands to nearly 5 billion consumers in over 130

countries

Responsibilities:

. Played the role of Project Lead in the core BW team for Procter &

Gamble.

. Worked closely with Business owners, stakeholders to create user

requirement specification, functional and technical design documents.

. Analyzed business requirements, performed gap analysis with respect to

the data model needs and available SAP business content.

. Project status monitoring and reporting to the client

. Design the backend architecture for report requirement and an end-to-

end implementation.

. Design front-end for Bex reports.

. Hyper care after Go Live and production support.

. Provide project cost estimation based on the number objects to be

enhanced or create.

. Manage and guide offshore team for project activity.

. Create APD with query as source and resolved the issue on performance.

. Created Webi report using BICS connectivity.

. Written and provided the logic to write ABAP code for routines.

Environment: BI 7.0, BW 3.5, ECC 6.0, APO, ABAP/4, Query Designer, BEx

Analyzer, HPQC 10, BMC remedy 7.5, Req pro.

Client: Mazda Motors, Irvine CA

Role: SAP BI/BW BO Consultant

Description: Mazda is a major car manufacturing company with an employee

based of more than 14000. Originally established in 1920, headquartered in

Japan, Mazda has its presence across the globe. Irvine office is the

headquarters of North America.

Responsibilities:

. Led the team through SDLC life cycle.

. Gathered Functional requirements, prepared Functional & Technical

specifications and developed blue prints by interacting with

functional experts, business analysts, management and end users.

. I have led the team through SDLC life cycle (Requirement gathering,

gap analysis, HLD, DD, development, Unit testing, Assembly testing,

System test support, migration to Production environment and post go-

live support).

. Involved in customizing the business content to suit the Company's

specifications.

. Activated data sources in ECC and created generic data sources from

views, function modules and info set query.

. Worked extensively in DSO's, Cube, Info set, Multiprovider, transfer

rules, update rules and user-exits for transaction data.

. Involved in data analysis via Open hub destination process from SAP

BW.

. Developed and enhanced LO cockpit data sources.

. Created BEx queries using variables, structures, calculated key

figures, restricted key figures, exceptions, conditions and RRI

features.

. Designed process chains for scheduled loads and enabled batch

processing for various administration activities in data ware housing

system.

. Implemented best practices of SAP to improve performance of loading

and reporting.

. Created aggregates for cubes and created Secondary indices in ODSs and

updated DB statistics cube. Analyzed BW statistics for optimization of

data loads and report performance during production support.

. Experienced on cutover activities, pre and post deployment activities.

. Resolved and delivered Visual composer based complex dashboard as per

the requirement.

. Worked on Analysis Process Designer (APD).

. Transported BW objects from development to QA and Production.

. Effectively coordinated different team (Basis/QA/Ops/Portal/Dev.) for

successful deployment.

. Experience on process chain automation and daily data load.

. Defined BO Classes, Objects in the Universe, Cardinalities, Contexts,

Joins and Aliases.

. Involved in designing, developing and deploying using Universe

Designer and Web Intelligence.

. Checked the Universes for Integrity and exported to the Repository to

make resource available to the users and groups and created Adhoc

Reports, Standard Reports, Cross-tab Reports, Sub Reports and Drill

Down Reports by accessing the Universe.

Environment: BI 7.0, BW 3.5, ECC 6.0, ABAP/4, Query Designer, BOBJ 4.0, Web

Intelligence.

Client: AT&T, St. Louis, MO through Accenture April

2010 - Jan 2013

Role: SAP BI/BO

Description: AT&T is a leader in telecommunication services, including cell

phones, wireless, U-verse, digital TV, high speed Internet, DSL, home

phones, STB etc. Their business involves in marketing these products with

the functionality of SAP modules like Real Estate, Sales & Distribution,

and Material Management.

Responsibilities:

. Led BW-development team to deliver complex change request.

. Worked closely with Business owners/users to analyze business

requirement that could be satisfied with SAP business content and

created the necessary objects required.

. Extracted data from R/3 & files, monitored data loads and fixed any

loading issues.

. Worked on start routine, end routines, transformation involved in data

flow.

. Worked extensively with the Logistics Cockpit customization for

extraction of Sales and Inventory using LBWE transaction.

. Created BEx queries on DSO, Info Cubes, Multiprovider and RRI using

CKF, RKF, Conditions, and Exceptions.

. Interacted with Business community to gather and analyze the Business

Requirements in developing and modifying Universes and building the

reports.

. Participated in designing the universe to meet the requirements of

each report.

. Created formulas and store procedure and different alerts based on the

conditions.

. Resolved Chasm traps, Fan Traps & Loop problems by using contexts and

aliases to reduce the complexity of the universes.

. Extensively used the @functions, worked on back end functions,

procedures, tables, views required by the business objects universes

. Created Dynamic Filters and Dynamic Conditions in universe level as

per Business rules.

. Improved the performance and reduced the coding with the use of

@functions like @Prompt (for user defined queries), @Where (for

creating conditional filters), and @Select to create duplicate objects

in the process of building the Universes.

. Created custom List of Values (LOVs) for better understanding of

prompts by the end users.

. Applied User and Group Restrictions in selected objects in universe

level based on User and Group.

. Designed and Developed WEBI reports, created charts and graphs for

quick analysis.

. Created Report Level Variables, Objects and Formula to create new

columns based on the result set.

. Reports features include functions, running totals, parameters and

conditional formats.

Environment: SAP BI 7.3, BW 3.5, ECC 6.0, SAP Business Objects 3.1 and 4.0

(Crystal Reports, WEBI, Dashboards IDT, BODS, Visual Intelligence, QAAWS)

and HANA.

Client: Reliance Info solutions Limited Aug

2007 - Apr 2010

Role: SAP BI/BW Consultant

Description: RISL is IT leading company. Project was involved in mapping,

data migration and reconciliation between Intex ERP with SAP. Reports were

created to track the details of marketing orders vis- -vis fabric

production cycle. Reports helped marketing executives to provide

information to customers regarding the current status of their respective

orders.

Responsibilities:

. Involved in functional requirement gathering.

. Involved in Analysis, design, development of info cubes and ODS

objects.

. Developed generic extractor based on view, ODS, transfer rules,

communication structure, update rules, info packages, info cube,

multiprovider and flat file data source.

. Involved in performance tuning by maintaining aggregates, compression,

partitioning of info cube and use of statistics for the same.

. Automated data load processes, maintained BW statistics, did roll up of

BW aggregates using process chain.

. Analyzed and activate relevant business content and setup R/3, flat file

and BW as source system. Reconciliation of data from various sources

system.

. Uploaded master data and transactional data from files and SAP R/3

system.

. Using Business explorer (BEx) created custom queries based on the

detailed query and business requirement.

. Used Filter, Conditions, Variables and posting of reports on the portal

with drill down and execution capabilities.

. Created Web templates using Web Application Designer (WAD).

. Transported BW objects from development to QA and production.

. Involved in development and debug of start routine, field routine and

customer exit.

. Support production system on data load performance and issues.

Environment: BI 7.0, BW 3.5, ECC 6.0, ABAP/4, Query Designer, BEx Analyzer

Employer: Salt River Info System, India Jun 2003 -

June 2005 Client: Cadila and Essar

Role: Software Developer

Description: Salt River Info system is an Information technology solution

and services provider, offers range of niche products and co-sourcing

services.

Project 2:Balance Score Card Quality Report.

Generate reports to monitor performance of departments/ sections for

various measurable parameters comparing Target vis- -vis Actual with

controlled access for viewing, entry and approval of targets and actual

performance values.

Responsibilities

. Design report layout.

. Development.

. Testing and documentation.

Project 1:Database Comparison Tool

Release Manager needs to make sure that the release applications are tested

before the production release and validate if there are any discrepancies

in the released application by comparing and verifying the data accuracy

between Quality Control (QC) database and Release Cycle (RC) database and

conclude if any major differences or problems like unexpected changes in

any of the data fields to minimize the major problems.

Responsibilities:

. Involved in requirement gathering

. Involved in designing the application for production use.

. Developed generic Java code for the comparison of the two similar tables

in different environments.

. Enhancements and maintenance of the tool from time to time.

Environment: Java, JSP, XML, HTML, SQL, Microsoft Visual Basic v 6.0,

Oracle-8I, MS Access 2003.

EDUCATION:

B.E in Computer Engineering 2003

M.E in Master Engineering 2007

Contact this candidate