Sap Bi
Resume:
Goutham Katarapu
SAP BI/BOBJ Consultant
* abl2zz@r.postjobfree.com
SUMMARY
. Around 6 years of extensive techno-functional experience in SAP
BI/BW in 3.0, 3.5 and Netweaver 2004s (7.0) versions.
. Hands on experience in integrating Business Objects with SAP BI 7.0
. Able to design BOBJ Universes and integrate with backend SAP BI
Infoproviders
. Expert in frond-end reporting with BOBJ/BI, BEx, WAD, Excel
development, BSP, and other web technologies.
. Extensive hands-on experience in working with SAP application
modules such as Logistics, SRM & FI-CO.
. Worked in the realization of complete reporting solution in Procure
to Pay (P2P) area.
. Experinece working with Cross-Functional Analytics and Operational
reports from SRM, MM and AP subject areas.
. Realized KPI's like Costcenter Allocations (Variances), Feature-Mix
& TCP, Vendor Reliability metirc, Balance Sheet, Sales Cockpit
etc.
. Sound Understanding of the SAP BW architecture and able to realize
complex BI solutions.
. Expert in designing logical data models based on functional
requirements and load strategy specifications to capture source
data, data consolidation mechanisms, and integration scenarios for
reporting purposes
. Competency in all phases of the project from analysis, design,
development, configuration, testing, as well as documentation, and
providing end-user training
. Technical and functional expertise well augmented by excellent
analytical and interpersonal skills, with the ability to deliver
innovative and profitable solutions well within timeframe and
budgets.
PROFESSIONAL EXPERIENCE
NBC Universal, LA, CA
Feb 2009 - Present
SAP BI Developer - Procure to Pay BI Reporting
. Working as a SAP BI Consultant for NBC Universal a media and
Entertainment Company, that has implemented SAP BW 7.0
. This project is a brand new full implementation of P2P reporting in
SAP BI.
. Worked in the realization of complete reporting solution in Procure
to Pay (P2P) area.
. The Reporting included Cross-Functional Analytics and Operational
reports from SRM, MM and AP subject areas.
. Used LO cockpit for ECC data extractions.
. Enhanced and used these standard SAP extractors to pull P2P data in
BI:
o 0BBP_TD_SC_1 (SC)
o 0BBP_TD_SC_APPR_1 (SC Approval)
o 2LIS_02_SCL (PO)
o 2LIS_06_INV (MM Invoices)
o 0FI_AP_4 (vendor Line Items)
. Extensively used Netweaver 2004s Features, Business Content was
migrated from 3.5 versions.
. Latest functionalities like DTP, Remodeling Tool, Transformations,
Advanced WAD, and Report Designer etc were used.
. Automated the loads, aggregate rollups and change runs using
process chains.
. Effective Dashboard was deployed for all the web reports developed.
. Portal Themes, 0ANALYSIS_PATTERN were used to create custom web
reports
. Extensively used Reporting functionalities like Information
Broadcasting, RRI, Cell Editors and Custom variables.
. Analyzed collective performances of various queries to improve
performance.
. Created Indexes, Aggregates, partitions and other optimizing
techniques to improve loading times.
. Lead a Pilot project to integrate the backend SAP BW with BOBJ
The Whirlpool Corporation, Benton Harbor, MI Jan
2008 - Nov 2008
SAP BI Development - Procurement & Manufacturing
. Working as a SAP BI Consultant for Whirlpool, a major kitchen
appliances manufacturing company that has implemented SAP Business
Information Warehouse BW 3.5
. Worked extensively with the Funtional Team to bring out a global
Total Cost Productivity Metric solution in Procurement &
Manufacturing Areas.
. Initially worked in productivity metric at Part level in Procurement
with involving complex part-to-part relationships.
. Extensively developed an automated Allocation methodology to
Procured & Manufactured Finished Goods.
. Developed Metrics like Cost of Production (With allocation done till
a SKU level), Feature Mix & Total Cost Productivity (TCP)
. The above metrics were implemented to North American region of
Whirlpool Corp.
. Was able to provide a unifom solution for WMCS, PRMS & SAP r/3
source data.
. Both planned and monthly currency conversion techniques were
employed.
. The TCP tool built is very effective and able to deliver reults by
the fourth day of every month and is open to manual adjustments too.
. Used most of BW functions to realise the TCP solution in BW.
. Developed performance effective ABAP code to realize the solution.
. Developed loading stragtegy so that global loads are synchronised.
. Developed Extensive and User friendly Web reports and integrated in
portals.
. Created Indexes and other optimizing techniques to improve loading
times.
. Analyzed collective performances of various queries to improve
performance.
. Automated the loads, aggregate rollups and change runs using process
chains.
. Created Custon BSP Support Page to do Manual Adjustments.
Proctor & Gamble, Cincinnati, OH
July 2006 - Dec 2007
SAP BI Developer
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_4 data sources.
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.
The Coca-Cola Company, Atlanta, GA
Mar 2005 - May 2006
ALE Pipeline / Basis Performance Reporting
. Working as a SAP BW Consultant for client, a major soft drink
manufacturing company that has implemented SAP Business Information
Warehouse BW 3.10
. Working extensively with the Financial and System Performance
reports
. Working extensively in the realization of Financial reports on the
web
. Carrying out bug fixing and correcting more than 50 errors present
in the existing model and reports with coordination from users
. Working on the development of about 30 Web Reports with a viewership
of over 300 users
. Creating effective process chains to overcome the errors in the
existing ones
. Creating custom Business Server Pages (BSP) to display some existing
ABAP Reports on the web
. Developing a Quick Reference Guide for first time users of BW
. Working on the realization of a data model that addresses the need
of capturing the performance related data in the whole SAP system
into BW
. Creating generic DataSources, custom InfoCubes, and MultiProviders
to realize the reporting scenario
. Creating workbooks and developing Excel macros to realize complex
reporting scenarios that included reporting features such as
sophisticated charts, jump targets, and pre-calculation
. Analyzing collective performances of various queries that are based
on the same InfoCube and improving the overall performance by
creating suitable aggregates
. Automating the aggregates' rollups and change runs using process
chains
International Game Technology, Reno, NV Dec
2004 - Mar 2005
SAP BW Upgrade and Support
. Worked as a SAP BW Consultant for client, a gaming manufacturing
company who had implemented SAP BW 3.5 with BPS
. Worked initially in the BW Support Team during the upgrade of SAP BW
from 3.0B to 3.5, and later participated in developing a complete
replacement of their current R/3 reports in Logistics with BW
. Interacted closely with the Basis team to formulate working plan for
the pre-upgrade, upgrade, and post-upgrade phases
. Performed web consistency checks to delete any unused workbooks
before and after upgrade
. Worked with the Basis team in the installation of the pre-
calculation server
. Worked in a major way in providing end user training with BW queries
and the new functionality available within BW 3.5
. Worked with the functional users in gathering reporting requirements
and analyzed the existing R/3 reports to identify the reports to be
delivered in BW
. Participated in developing 60 queries that covered the MM, PP, and
SD modules
. Developed queries that used jump target future to drill down from
InfoCube queries to line item details, stored at the ODS level
. Developed an extensive report distribution scenario with Information
Broadcasting
. Worked extensively with 0FI_GL_4, 0FI_AR_4, and 0FI_AP_4 extractors
and developed the required line item ODS
. Provided the solution of iViews in web reporting as an alternative
to using complex structures
. Developed Excel macros to counter the problems caused in some of the
Web Reports
. Trained end users extensively with various capabilities of BEx and
Web Reporting
pic]
Contact this candidate