Sales Data

S rilatha

SAP BI/BO Consultant

E-mail: s abgykq@r.postjobfree.com

Phone: 224-***-****

Professional Summary:

• Over 7 years of experience, mainly focused on Design, Development, Implementation of SAP BI

N et weaver 7.0/ BW(3.5,3.1C), SAP ECC 6.0 & R/3 (4.7, 4.6C) and SAP BO XI R3.1/R3.0

• Implemented 2 F ull Life Cycles i nvolving all phases of ASAP methodology on versions B I 7.0

a nd BW 3.5 t hat includes P roject Plan, Business Blue Print, Realization, Final Preparation & Go-

Live Support.

• Expertise in D ata Modeling and Re-Modeling of I nfo Cubes, DSOs (Standard, D i rect

U pdate and W rite-Optimized), I nfoObjects, I nfoAreas, I nfoSets, I nfoProviders,

M ultiP roviders, Data Ma r ts, Open H ub Services and P ortals.

• Experience in BW-BPS and good knowledge on S EM-BPS

• Involved in the system u pgrade of BW 3.5 to 7.0. E xtensively worked on the new

features of BI 7.0(NW 2004) including D ata t ransformations, Data T ransfer P rocess,

R emodeling of the I nfo Cubes, Data Store Objects and the New Data Sources,

T ransfer Rules, Update Rules, PSA, BW T ransports, Aggregates, and

P erformance T uning.

• Proficient in E T L activities involving D ata Extraction, Data Modeling, Loading ( Full/

Delta upload), Scheduling, Monitoring and Creation and Maintenance of P rocess

C hains for automated data loads from different source systems.

• Experience working with B usiness Objects X I R3.1/R3.0 and proficient in D esktop

I n telligence, Web I n telligence, Designer, I nfo View, Dashboard Manager,

L ifecycle Manager, Cent ral Management Console, XCelsius 2008, Query as a Web

Service (QAAWS) & Live Office, C rystal Reports for both SAP and Non-SAP

sources.

• Worked on Functional/Business requirements and involved in the design and development

of Multi Dimensional Data Models using BW concepts of Extended Star schema and

DataSources (Installation of standard data sources, Enhancing existing data sources and

c reating custom data sources).

• Good understanding on F I/CO, M M, SD & H R modules.

• Experience in the c ustomization of the standard business content extractors and

e nhancement of the data sources in various applications using customer exits.

• Remodeling on the existing cubes to accommodate new key figures and characteristics.

• Experience in A BAP to wri te start routines, update/transfer r ules and user exits .

• Involved in the development of generic data sources w ith ability of delta functionality.

• Worked on S tanda rd User Exits to enhance the functionality of the standard business

applications.

• Proficient in P erformance Tuning techniques w hich involves the evaluation of

s tatistical performance, data load improvisation and query performance using

compression, aggregates and p a rtitioning techniques.

• Worked on pre-calculated w eb templates and user control queries to increase the

p erformance of the query and also worked on OLAP cache.

• Proactive team player with excellent interactive and interpersonal skills to communicate

w ith team members, developers, clients and end users at all levels.

Skill Set:

ERP Packages : ECC 6.0 and SAP R/3 - 4.7 / 4.6C, 3.1C

SAP Modules : FI, CO, HR, PP, M M, SD, CO-PA, APO

Data Warehouse : SAP BI 7.0 and SAP BW 3.5 / 3.1C

Enterprise Database Server : Oracle 9i, SQL Server

Reporting Tools : BEx Reporting Tools, Business Objects XI 3.1-

Desktop

I n telligence, Web In telligence, Xcelsius 2008,

C rystal Reports

Languages : C, C++, Core Java, SQL, PL/SQL

Web Technologies : HTML, Java Script, XML

Education:

• Bachelor of Technology at Jawaharlal Nehru Technological University, Hyderabad, India.

Professional Experience:

Client: Fannie Mae June 2010 -

P resent

Location: Herndon, Virginia

Role: SAP BI/BO Consultant

Technical Environment : SAP ECC 6.0, SAP BI 7.0, FI-AR, FI-AP, FI-GL, FI-SL, ABAP/4, BEx

A nalyzer, Query Designer, Web Application Designer, BO Designer (XIR 2.1, 3.1), WEBI (XI R

2.1, 3.1), Xcelsius 2008.

Fannie Mae provides financial products and services that increase the availability and

a ffordability for low, moderate and middle income customers.

Responsibilities:

• Involved in the f ull life cycle implementation w hich includes Gap Analysis, Design,

Development, Testing, Implementation and Support.

• Understanding the business challenges and t ranslating them in to requirements.

• Involved in building a planning model using BW-BPS, for a close focus on issues related to

Accounts data.

• Activation of the Business Content for Accounts payable (AP), Accounts Receivable

(AR), P rofitability Analysis (PA),General Ledger ( GL), Special Ledger ( SL), Cost

C enter Accounting (CO-CA) and customizing them as per the client requirement.

• Developed wri te optimized DSO’s for EDW layers and standard DSO for consolidation

layers and created direct update DSO’s for creating history data and for snapshot scenario

reports.

• Developed t ransformations with start routine, update routine and end routine and

i nvolved in the creation and maintenance of D TP and I nfoPackages for loading data

i nto data targets.

• Created generic data sources w ith ability of delta functionality.

• Experience in the enhancement of the master data and t ransaction datasources with Z-

fields and are populated using User Exits.

• Enhanced the business content datasources by appending structures, User Exits and

customized delta built up for the datasources

• Worked on Accounts payable cubes and accounts receivable cubes and created InfoSets

and MultiProviders according to the requirement.

• Created InfoObjects, InfoSources, InfoCubes and developed t ransfer structure, update

r ules and t ransfer rules as per business requirement and extracted data from external

sources.

• Created p rocess chains for periodic upload of master data, t ransactional data, text data

and scheduled and monitored the data loads with delta update and full update

mechanisms.

• Created Aggregates on InfoCubes to improve the query performance.

• Created BEx queries for reporting on InfoCubes, InfoSets, ODS and MultiProvider.

• Created universes, classes and objects by ret rieving the data from data sources like BW

queries and defining necessary connections.

• Created W EB I reports and c rystal reports and deployed them through info view with

B W universe as source

• Generated m onth to date and year to date reports for FI and monthly distribution

reports for Human Resources

• Experience in creating formula variables, conditions, exceptions, exception

aggregation, cell editors, customer exit var iables and structures for developing

complex custom reports.

• Created exception aggregations, cell editors, formula var iables, RK F’s and CKF’s

i n the queries.

• Extensively used WAD and published reports on Enterprise portal as i View

• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and

d ice, alerts for creating business objects reports.

• Created inventory accuracy D ash Boards (Xcelsius) and for management reports for

i nventory management and wages and costs report from cost center accounting

• Created advance analytics like speedometers, in teractive metric t rends to gauge the

performance of the key business.

• Involved in the migration and deployment of the universes and reports across multiple

domains.

• Implemented analytics across the organization and used tabs on company p erformance

v ia f lexible management d ashboards and implemented index awareness.

Client: S taples Inc Februa ry 2009 – June

2010

Location: F ramingham, MA

Role: SAP BI Consultant

Technical Environment: SAP ECC 6.0, SAP BI 7.0 NW 2004s, BEx Analyzer

S taples Inc is the world’s largest office products company. The company sells a wide range

of office products, including supplies, technology, furniture and business services.

Responsibilities:

• Extracted the t ransaction data from SAP ECC 6.0 (PUR, SD and FI) and Flat File to BI

using L O Cockpit by maintaining the extract structures, maintaining data source,

replicating the data sources into BI.

• Designed and Modified InfoObjects, Transformations, InfoCubes and loaded these objects

w ith Master data and Transactional data from ECC 6.0 and Flat Files by creating

I nfoPackages and DTPs.

• Activated available b usiness content for SD functional area. Created necessary custom

objects like InfoObjects, DSOs, Infocubes, Update rules etc.

• Created Custom Infocubes for accommodating the global data available across the

organization from SAP and Non-SAP sources using DB Connect and Flat Files.

• Installed Technical Content to collect B I statistics.

• Created Mul tiProviders on Info Cubes (Orders, Delivery, and Billing for specific queries)

and DSO for unique restricted document level data.

• Enhanced the Data Source for adding new fields in the Extraction Structure according to

requirement through User Exit CMOD.

• Developed Process Chains to automate the data upload and aggregates rollup etc.

• Extensively worked on Performance enhancement features such as Cube Parti tioning,

I ndexing, maintaining aggregates and Compression. Worked on concept of remodelling of

I nfo Cube.

• Transported InfoObjects, InfoCubes from Development to Quality for Testing & to

P roduction System during Cut-Over Phase.

• Created T ransports for moving the roles within the landscape.

• Developed Reporting jump targets using R R I ( t-code RSBBS) to other reports. Created

RRI reports for drilling down from aggregated reporting on cube to line i tem detail report

on DSO.

• Performed detailed analysis to improve the Performance of Cubes using BI Statistics.

I mproved performance by choosing appropriate query modes and regularly tuning the data

models for Info Cube and queries besides creating aggregates and indices.

• In teracted with S ubject Matter Experts (SME), Business Analysts and Users for

p reparation of Data Modelling, Business Content, Granulari ty and Query design. Worked

extensively on customization of SD Info Cubes as per the User Requirements.

• Created Variables, Filters, Exceptions, Calculated key figures, restricted key figures,

G lobal and Local structures and other features to meet user requirement.

• Created O pen H ub Destination t o retrieve data from BI to Flat File using Open Hub

Service Concept.

C lient : McKesson Drug Company Janua ry 2008 –

J une 2009

Location : San Francisco, CA

Role : SAP BI Consultant

Environment : SAP BI 7.0, BO XI R 3.0

McKesson is based in the United States and distributes health care systems, medical

supplies and p harmaceutical p roducts. Additionally, McKesson provides extensive network

i nfrastructure for the health care industry; also, it was an early adopter of technologies like bar-

code scanning for distribution, pharmacy robotics, and RFID t ags.

Responsibilities:

• Involved in complete f ull life cycle i mplementation on SAP BI. Conducted meetings with

other team members of the functional modules like M M, FICO to gather the required data

f rom the respective functional modules in order to implement the requirements of the

client.

• Involved in gathering, analyzing, and documenting business, functional requirements and

data specifications for B usiness objects.

• Extracted the data from the tables in S D and F ICO by using standard extractors,

2 LIS_13_VADHR, 0FI_AR_03, 0FI_AP_03.

• Created custom data sources for S ales & D istribution for extracting the data and

replicated the data source to BI.

• Enhanced the C ustom extractor to add up a new functionality as per the requirements

g iven by the client by wri ting ABAP code which updates tables that is used to load data into

B I System.

• Used ABAP coding for Start Routines and update routine to meet the customer

requirements.

• Created t ransformations a nd applied the d ata t ransfer process for loading the data

f rom ECC to BI. Replicated the data source to BI, created the i nfo packages and loaded

t he data from ECC to BI using f ull and delta processes.

• Designed data model and Info Cubes for FI-CO. Customized info objects and info cubes for

F I-CO. Customized the InfoObjects and InfoCubes.

• Worked on r emote cubes t o support real t ime data.

• Extracted the required data and loaded the data into D SO by creating I nfoObjects.

C reated i nfo cubes and multi providers and buil t queries on SD and M M in Query

designer.

• Gathered the information from Sales and Distribution module for reporting which is in

t he form of q ueries like sales, braches customers, profits.

• Used Aggregates, compression, and partit ioning techniques to improve data load and

query performance.

• Created different r eports in M M, SD module such as p roduct stock value available

based on the p roduct type, best selling products, billed selling orders based on

ter ri tory, Sales and profits in a particular year.

• Developed the r eports based on several characteristics and k ey figures a nd added a few

calculated k ey figures based on the additional requirements of the clients and for making

t he report end user friendly. Modified the reports and added additional d imension, detail,

a nd measure objects according to the requirements.

• Designed H ie ra rchies t o support drill down reports.

• Developed WEB I Reports using Rank, Alerter, Conditions and Calculations,

c reated H yper link using Open document Function.

• Created M aster/Detail, Cross tab reports based on user requirements.

• Used d rill mode and slice and dice mode i n reports.

• Performed P e rformance tuning on reports as required

Client: Consol Energy Inc Februa ry 2007 –

J anua ry 2008

L ocation: Oakwood, VA

Role: SAP BI/BW Consultant

Technical Environment : SAP ECC 6.0, SAP BI 7.0, BW 3.5

Consol Energy is America’s leader in underground coal mining and the largest exporter of coal. I t

has evolved from a single fuel mining company into a multi-energy producer of both high-Btu coal and

gas. In addition to coal and gas operations, Consol Energy has other energy businesses and services that

meet the needs of our customers including r iver and ocean t ransportation services as well as industr ial

supply sales.

Responsibilities:

• Involved in the business requirement gathering, system design document, technical

specification, functional specifications, development, configuration, reconciliation to Go-

live.

• Implemented SAP BW for S EM, F I, SD, M M and PP modules which involves the

designing of data f low from R/3 to BW

• Involved in activating Business Content for Standard InfoObjects, InfoSources, InfoCubes

related to Sales & Distribution, Material Management and FI.

• Generated report on Business Content Cost Center Planning Cube 0SEM_C10 and Sales

P lanning Cube 0SD_C08 for planning and analyzing sales data in BPS created Multi

P lanning Area, level, Planning Folder, Variables, Planning Area and Package

• Used the Business Content Sales Overview InfoCube 0SD_CO3, for overall Sales

A nalysis. The t ransaction data is loaded from different Source Systems using the Info

Sources 2 L IS_01_S260 SalesOrder, 2 L IS_01_S261 Delivery, 2 L IS_01_S262 for Billing

Document and 2 L IS_01_S263 for Sales Order/Delivery using LO-Cock Pit.

• Actively involved in Monitoring Data Transfers from Source Systems in to BW using PSA

• Worked on accounts payable cubes 0 F IAP_CO2 and accounts receivable cubes

0 F IAR_C03

• Developed the datasource for C O-PA on basis of operating concern (Account based and

Cost based) and developed ODS object for the datasources and generated reports.

• Extracted data from M M modules and uploaded the data in to the procurement cubes via

2 L IS_02_HDR, 2L IS_02_IT M and 2 L IS_02_SCL and activated the appropriate

B usiness Content cube

• Customizations – Data source enhancement of business content cube by appending

s tructure,User Exits and Customized Delta built up for the datasources

• Build Transactional and Master P rocess Chains for periodic upload of data.

• Involved in the Performance Tuning of InfoCubes and Query reporting.

• Worked with B Ex Analyzer to generate Queries and embedding them into Workbooks

and also published the queries onto the web using Free Characteristics, RRI-Jump

Queries Calculated and Restricted Keyfigures, Filters, Variables and Exceptions

• Extensively used the Web Application Designer for creating customized templates

using web i tems like Table, Chart, Fil ter, Map, Web Broadcasting and more

• Extensively used the wizard in WAD and published the reports on E nte rp rise Portal as

i View

• Worked with B Ex Broadcaster to schedule monthly sales reports as e-mail to the users.

Client : I TC Limited November 2005 – October 2006

Location: Kolkata, India

Role : BI/BW Consultant ( SAP BW 3.5 to BI 7.0 Upgrade Project)

Environment : SAP ECC 6.0, BW 3.5/7.0, SAP BI 2004s, ABAP/4, Windows XP, BEx Analyzer

ITC has a diversified presence in Cigarettes, Hotels, Paperboards & Specialty Papers,

Packaging, Agri-Business, Packaged Foods & Confectionery, Information Technology,

B randed A pparel, Personal Care, Stationery, Safety Matches and other FMCG products.

Responsibilities:

• Played an active role in u pgrading the Legacy financial data wa rehouse system

f rom BW 3.5 to B I 7.0.

• Developed and tested the new features of B I 7.0 w hich includes new data f low, r e-

modeling, I n tegrated Planning, R eal-time Data Acquisition, enhanced features of

P rocess Chains etc.

• Testing has been done by taking the scenarios existing in the current B W 3.5

i mplementation and creating the same in B I 7.0 system

• Checked for inactive Update & Transfer Rules and activated the same. All inactive and

u pdate rules which are not required were deleted.

• Checked for inactive Info cubes and activated which are required and deleted which are

not required.

• Ensured that all extractions and loads were completed and no requests are pending.

• Ensured that all d elta queues a re empty in SAP Source System.

• Tested In tegrated Planning by creating a scenario using real-time info cubes

M ul tiProviders and input-ready queries (for manual input).

• Tested the E T L process w ith new data flow using emulated data sources. Also tested

t he old dataflow for the data sources which are not emulated and cannot be uploaded using

new data f low process i.e. T ransformations and D TP (Data T ransfer P rocess).

• Closely worked with testing department for developing and implementing test scripts.

• Performed U nit, I n tegrity tests a nd data consistency was verified with E CC 6.0

• Created Info Sets with a temporal join using D SO, I nfoCube a nd I nfoObjects as I nfo

P roviders.

• Done BW Business Content data source enhancements using user exits and by creating

and maintaining customer appends.

• Created and monitored aggregates ( Custom Creation Based on statistics and on

usage).

• Front end reports were developed using both B Ex analyzer a nd Web Application

D esigner.

• Used BI Broadcasting services for the distribution (Print & E mail) of exception reports to

key business users.

• Created and maintained different types of D SO objects like Write Optimized DSO,

S tandard DSO and Di rect access DSO.

• P roduction support and monitoring activities i nclude the following : Design,

Development and Support of scheduled Loading; Application Support, Development,

p roviding strategic planning for data management; Data loading, monitoring, storage &

performance using process chains; Data uploading from R/3 & non R/3 Systems (Oracle /

F lat Files); Support, Optimization and revamping of scheduling and monitoring the system;

P roblem resolving related to data loading and query performance; Modification of Process

Chains on user demand; Optimization of major cubes with aggregates and compression;

Constantly reviewed project to analyze and optimize data in the production system.

Client : N TPC Electric Supply Company L td. June 2004 – November

2005

Location : Noida, India

Role : SAP BW Consultant

Technical Environment : SAP BW 3.5 and SAP R/3 4.7, M M, SD

N TPC Limited (formerly National Thermal Power Corporation ) is the largest state-

owned power generating company in I ndia. NTPC's core business is engineering, construction

and operation of power generating plants and providing consultancy to power utilit ies in India

and abroad.

R esponsibilities:

• Responsible for requirements gathering for reporting purposes as well as Extraction.

• Performed the t ransformation and loading process f rom OLTP to SAP BW system.

• Customizing standard info Sources 2 LIS_11_VAHDR, 0FI_AP_4 from the business

content for Sales Order and deliveries t ransactional data .

• Replicated source system in BW to made available SAP R/3 data source in BW system.

Designed and developed O DS objects to carry out a precise analysis of individual order.

• Created data sources using generic and application specific extraction (LIS) for S D and

M M modules and loaded the business content.

• Used start routines, routines for t ransfer and update r ules using ABAP.

• Created d ata sources using generic a nd application specific extraction (LIS) for SD and

M M modules and loaded the business content.

• Extended t ransaction data Sources by appending new data elements using e nhancement

component RSAP0001 and used the function exit EXIT_SAPLRSAP_001.

• Designed and developed InfoCubes, InfoSources and loaded data from SD module to BW.

• Customized Info cube for sales by adding new fields as per the requirement and updated

s tart routines and t ransformation rules.

• Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer

Rules to update.

• Created Info packages and Info package Groups to do Full, Ini tial, and Delta extraction

for both master and t ransaction data.

• Actively involved in BW standard business content installation, data modeling and

designing Info Cubes with various aggregate level. Created real-time Info cubes and Multi

p roviders.

• Designed Aggregation levels, fil ter, designed input enabled Queries.

• Involved in setting up roles, profiles and authorization objects.

• Created q ueries in the query designer for wri ting the reports

• Designed custom Sales Order info cube and defined t ransfer rules and update rules.

• Developed reports in Sales and Distribution module.

References Available upon Request

Contact this candidate