Swaroop Landa
SAP BW/BOBJ Consultant
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.