Swaroop Landa

SAP BW/BOBJ Consultant

614-***-****

abldo2@r.postjobfree.com

Summary:

. Over 6+ years of experience in designing, development, and

implementation in SAP BW/BI/BOBJ.

. Hands on experience in working in all stages of development efforts,

including requirements definition, design, architecture and testing.

. Worked with Business Stakeholders, IT Infrastructure teams, and

Development teams to capture business requirements.

. Expert in identifying the ways the end users want to analyze data and

design data access solutions satisfy the business requirements.

. Resolved the Problems, Incidents, Change and Request Management

issues.

. Performed installation, activation and enhancement of Business Content

based on customer needs for new Applications.

. Hands-on Experience in the design and development of Info Cubes,

Multiproviders, DSOs, APDs, Process Chains etc

. Extracted ECC data from FICO /HR/SD/MM modules using standard

Datasources

. Experience in enhancing datasource as per user requirements.

. Worked extensively with BEx Query Designer, BEx Analyzer and Web

Application designer.

. Experienced in BW and BOBJ Integration, created BOB Universes on top

of Bex queries, created BOBJ reports in WEBI and generated dashboard

in Xcelsius.

. Worked with ETL tools like Informatica to facilitate data loading from

BW into third party databases using Open Hubs.

professional Experience:

Limited Brands, Columbus, OH

02/2009 - 08/2010

SAP BW Consultant

Limited Brands is a leading apparel based specialty retailer. Their

Business warehouse supports critical operational and analytical reporting

in Finance, Controlling, Sales, Supply Chain event management & Demand

planning APO.

SD Implementation:

. Worked on the design, development and maintenance of the BW solution.

. Analyzed the requirements, worked on gap analysis and identified

existing business content as well as areas for enhancements.

. In-charge of loading and monitoring data in to the cubes for the

sales, delivery and invoicing as Part of Order to Cash implementation.

. Improved data loading performance for sales and delivery by limiting

data packet sizes, scheduling index deletion and rebuilding jobs as

well as through ABAP tuning. As a result of these efforts data loads

were conducted successfully within half the time.

. Modified both generic SAP R/3 extractors as well as LIS and LO-Cockpit

extractors.

. Responsible for quality assurance on the extraction side and for

implementing required modifications.

. Implemented reporting requirements by developing BEx-queries for the

areas mentioned.

. Developed reports using ALV grid technology for accounts payable

department for cost controlling and reconciliation.

CO-PA Implementation:

. Extracted CO data to incorporate overhead Cost controlling and Cost

Center Accounting data in BW reports.

. Developed reports for Business profitability analysis, Profitability

summary by product hierarchy, customer purchase summary, Profitability

detail by product hierarchy,

. Profitability summary by customer, actual price realization

comparison, Profitability summary by geography, Profitability summary

by customer and product.

. Responsible for the evaluation of the current system and defining the

scope of the BW project for cost controlling and developing extractors

and reports.

FI Implementation:

. Created and maintained multiple Info cubes for the FI module.

. Loaded data into standard Info-cubes 0FIAP_C03 and 0FIAR_C03 using ODS

objects 0FI_AP_O03 and 0FI_AR_O03.

. Enhanced the 0FI_AP_1, 0FI_AP_2 data sources.

Proctor & Gamble, Cincinnati, OH 06/2007 -

12/2008

SAP BW Consultant

. Worked on different phases of implementation from project analysis,

process design, blue print, configuration, prototype, data loads, unit

testing, integration testing, power user training and production

support.

. Interacting with management and the end-users to identify the business

requirements and documented them.

. Implemented and developed HR module for Personnel Administration which

include Gillette details to load large amount of data from Flat file

into BW.

. Extracted data from PS Project system in order to display the Project

Actual and Forecast.

. Incoming sales data are extracted to SAP BW cube for currency

conversion reporting to handle the different currency.

. Worked in Order data info cube data enables an analysis to be made of

the planning process, when an order is created in the APO system.

. Strong expertise in Data Modeling, Data Cleansing, Data Governance and

Data Quality using BW ETL techniques.

. Involved in creation of role based security and authorization for

certain Info Cubes and Info Objects.

. Extensively used process chains to automate the process of loading

data into data targets.

. Managed data loading using both full update and delta management. Also

scheduled and monitored data loads to ensure smooth uploads by

managing packet sizes and eliminating inconsistencies.

. Training end users in query development-using BEx.

Environment: SAPBW3.5, SAPR/3,SAP Portals, HR, SD,APO, PS, Bex Analyzer,

WAD /Web Template, Bex Browser Oracle 8.0, Windows NT, SCM4.0, Web

template, Workbooks.

Gillette, Boston, MA

01/2006 - 04/2007

BW Consultant

Worked as BW consultant in SAP BW implementation of logistics controlling

for entire Divisions this project was designed to capture data of

inventory, logistics costs, sales trends resulting in better sales

planning, reduction in logistics costs, service levels.

Responsibilities:

. Interacting with management and the end-users to identify the

business requirements and documented them.

. Worked on Inventory handling and material movement (Article) to

Distribution center and Customer.

. Extracted the Purchasing details for Pre- packs from R/3 to BW.

. Extracted the A/P, A/R, GL and Controlling and build the customs

reports for Stock holders and Internal Management.

. Report delivery is via the web using queries, web templates, and

security-based roles.

. Scheduling Info packages for loading Master Data and Transaction

Data & Monitoring.

. Configuration work has included Infoobjects, Info Cube, Transfer

Rules, Update Rules, Roles, Queries, Web Templates, ABAP, etc

. Extracted purchasing documents and inventory data from R/3 using LO

cockpit, implemented Report-to-Report Interface and R/3 thrill-

through for drill down analysis, and developed SAP BW reports for

performing the analysis of purchasing documents and inventory

management

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

staging to PSA, ODS and Info Cubes. Worked with data flows from R/3

to BW.

Environment: SAP R/3 4.6C, BW 3.0B, SAP Portals, MM, FICO, BEx Analyzer,

BEx Browser, WAD Web Template, ABAP Query, Oracle 8.0, Windows NT.

VirtusaIndiaPvtLtd,Chennai,Tamilnadu 04/2004 -

11/2005

SAP BW

Consultant

Worked on BW full life cycle right from configuration, analysis, modeling,

design specification, development, and performance tuning to maintenance

for modules

Responsibilities:

. Conducted User requirement sessions and actively involved in

requirement analysis.

. Involved in discussions with the top management as well as end

users for Business Requirement Analysis in order to freeze the

functional design specifications for data capturing from the

existing business scenarios.

. Worked on COPA extraction to analyse the Sales and Forecast sales.

. Transfer of Business Content to active version with all its

dependent objects like Queries, workbooks, updated rules,

InfoSources, Transfer Rules etc.

. Involved in the design and development of Info Cubes.

Responsibilities include development of new Info Cubes &

Enhancements to the existing functionality as per the user

requirements.

. Analyzing source data, and helping to establish ETL guidelines, to

the design, development, and testing of Data Stage ETL

programs/processes to move and transform data from several

businesses into corporate Oracle data warehouse.

. Development of Queries, Reports with Exceptions and Filters by

using BW Analyzer.

. Performed performance tuning both back-end and front-end sides.

. Using a lot of transactions such as ST03, RSRT and RSRV, checked

and tuned system performance by deleting old data, remodeling Info

Cube, using aggregates, and changing queries

. Wrote ABAP code in transfer rules and update rules for SD modules.

Environment: SAP BW 3.0B, R/3 4.6C, SD, MM, FI/CO, BEx Analyzer, BEx

Browser, WAD Web Template, ABAP Query, Windows NT.

Contact this candidate