Sr SAP BW/BI

SAP BI/BW-B* Resume

Nekkalapu

ido8tj@r.postjobfree.com

Ph: 303-***-**** (Mobile)

Summary

• Having 8+ years of IT experience, including 6+ years in SAP BI/BW and 2+ years in ABAP/4 programming development.

• Completed 3 full life cycle Implementations in SAP BW/ BI including Requirements gathering, GAP analysis, Business Requirement documentation & Business Blueprint, getting client approvals, Go-Live and Production support.

• Good understanding of BI 7.0- DSO, Transformation, DTP and remodeling Info Providers.

• Thorough knowledge of data warehousing principles including data modeling, extract / transform / load processes, job scheduling, indexing, and OLAP processing, defining and using aggregates based on queries and execution plans.

• Extensive experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, customizing SBC objects, custom data warehouse development, managing ETL jobs, troubleshooting failed processes.

• Thorough understanding of installation, configuration and customization of BW objects including InfoCubes, ODS Objects, MultiCubes, InfoObjects, Info Sources, Info Packages, Transfer Rules, Update Rules, Process Chains and ETL jobs, etc.

• Extractions: LO, FI, CO-PA, Master data extraction, Generic Extraction, Delta management, Business Content (Installation & Enhancement), extraction using DB connect and Flat files.

• Experience in extracting data from non-SAP (ORACLE), Informatica source systems.

• Good knowledge of developing query objects including restricted key figures, calculated key figures, user entry variables, replacement path variables, customer exit variables, SAP exit variables, and authorization variables.

• Expertise in Performance tuning in evaluating the statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Rollups, Partitioning, Indexes, and Data packet size.

• Expertise in Automation of BW jobs - scheduling/monitoring, Process Chains – Creation & Maintenance

• Thorough understanding troubleshooting in BW and problems associated with the interface to R/3 and external source systems.

• Strong understanding of SAP user exit programming principles, Function modules and the ability to develop enhancements using ABAP.

• Excellent interpersonal & communication skills to work cross functionally with other Enterprise team members and ensure all applications & reporting solutions are clearly integrated and synchronized

• Ability to quickly learn & explore new Functional/Technical areas and quickly adapt to a fast paced environment

Technical Skills

• BW Versions: 3.0B, 3.1, 3.5 & BI 7.0

• SAP R3 Versions: 4.0B, 4.6B, 4.6C, 4.7 & SAP ERP (ECC 6.0)

• ABAP/4: Data Dictionary, Routines, Function modules, User Exits (CMOD, SMOD), SAP Query, Info Sets, OLTP Reports, Classical and Interactive reports

• BI: DW Workbench, DTP, DSO, Transformation and BI Accelerator

• Reporting: BEx Analyzer, BEx Query Designer, WAS, Portal and Business Objects

• Database: DB2, SQL Server 2000 and Oracle 8i/9i/10g.

• Others : Mainframe, Informatica, Autosys and Test Director

JohnsonDiversey Racine WI Nov 09 to Till Date

SAP BI Consultant

Environment: SAP BI 7.0, BW3.5, ABAP/4, Portals, Bex Analyzer, BO XI R/3, Web Intelligence XI R3 and Info view XI R3

• Involved in the Logility project which is Extracted data from JD Edwards through Informatica to BI7.0 and created the reports on the Multiprovider.

• Involved in the User Acceptance Test with the Logility Business users and fixed the issues which created during UAT period and provided training on SAP Portal for Business users.

• Involved in the build activity and Go-Live activities for Logility project.

• Created the Bex reports (Demand Planning, Forecast Planning, Replenishment Planning, Inventory Planning and Long Term Supply Plan) Report as per the Business requirements.

• Implemented the Fiscal Calendar Period change in BI as per the business requirements.

• Given the Primary support after go live into Production.

• Extracted the COPA data from R/3.

• Involved the Central Europe and Russia migration project, BW source system has been changed from Local ERP to SAP R/3 system, worked on the corresponding changes in BW end and given production support for these changes.

NIKE INC Beaverton OR Jan 08 to Oct 09

SAP BW/BI Consultant

Environment: SAP BI 7.0, BW 3.5, SAP R/3 4.7, Oracle 10g and Informatica

• Worked on redesigning of OM Open demand and allocation project, pulling delta from

R/3 to staging environment and then into Integration layer, Worked on Batch Design for Open Demand and Allocation Delta pull into staging layer and Integration layer.

• Worked as Team captain for EBI QA support and involved in fixing the BW and DM issues, coordinating with the offshore team.

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.

• Worked closely with the Corporate Consultants in providing Functional Specifications to enhance the current and develop new ODS and InfoCubes. Defined Custom Cubes and MultiProviders for the business scenarios along with aggregates. Defined Guidelines for Basis Team for Aggregates and Data Loading.

• Added new plants (distribution centre) in to the existed infopackage selection criteria, config tables, program variants, start routine and update rules as per the requirement.

• Designed Info Sources, activated transfer and update rules, scripted extraction routines for Master data, Texts and Hierarchies.

• Activation of standard InfoCubes and definition of new InfoCubes and provide enhancement to Business Content.

• Customized new Fact and Dimension tables in the star schema by creation InfoCubes.

• Worked extensively on the Open Hub service, created Info spokes to distribute the data to other EDW Systems.

• Created Info Packages to do Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.

• Created Process Chains to automate the data load and data target administration and monitored the processes.

• Used Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures and Characteristics in the Info Cubes.

• Created Info Sets, assigned user groups to the Info Sets and also defined Info Set queries. Create exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.

• Handled postproduction support and development of new design cycles simultaneously.

• Involved in Setting up and Monitoring Process chains for the complete data extractions and Loading.

• Performance tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.

• Implemented dimensional models, including aggregation and indexing strategies

• Developed, managed and updated data models including physical and logical models of the data warehouse, data marts and staging area

• Checking data consistency, aggregates and hierarchies through RSRV.

• Involved in creating Proof of Concept for the new Front end features in BI 7.0

• Worked on Production Support Kintannas and fixed those Kintannas as per requirements.

• Involved in Transportation of all Objects like: Info objects, Query’s and DS objects etc into BI production system after validation and testing the same in development system.

• Used DSO to stage the data before transferring the DSO contents to the Info Cube

• Modified start routines, update rules and user exits as per the production Kintannas.

• Managed & monitored several data loadings and optimized the performance by adjusting Packet Size and data selections.

• Created Info spoke based on DSO and pulled into the flat table and DB tables.

• Worked with end users to gather requirements to design and build the BW application.

• Prepared the technical specification from functional specification.

• Created TODS objects to load closed Sales orders schedule line level data from standards ODS partitions holding sales order data at grain level.

• Created InfoCubes in Analytical layer to load sales Schedule line data from TODS objects in Integration layer for US, AMER, EMEA and Asia Pacific regions.

• Created transfer routines, start routines and User Exit to lookup master/transaction data and populate key figures and Characteristics.

• Created Multiprovider upon 8 sales info cube partitions to enable reporting across all regions.

• Extended the extract structures by adding new fields and populating them with the User Exits.

• Worked on filing set up table for PO data and then loading into staging server and from there into Integration layer throughout the landscape.

• Created Business adds in’s (BADI) for populating the key figures in the Coverage queries.

• Extensively used the new process types in the process chains used Class builder.

Coca Cola Bottling Consolidation (CCBC) Charlotte NC Oct 07 – Dec 07

SAP BW Consultant

Environment: SAP BW 3.5, R/3 4.7, BEx, WAD, Workbooks.

• Worked on production support issues, monitor the loads, delivered the master data, transactional data within the specified time and provided the reports on time for end users.

• Solving the load issues, TRFC issues upon requesting the basis team.

• Performance tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.

• Designed and developed FI-GL, FI-AR, FI-AP data model in BW, responsible for modeling A/R cube, A/R aging Data Mart Cube and A/R Cash cube, AP Vendor Analysis and GL Reports.

• Designed and developed COPA and CCA (Cost Center Accounting) data models and the reports.

• Activation of standard InfoCubes and definition of new InfoCubes and provide enhancement to Business Content.

• Customized new Fact and Dimension tables in the star schema by creation of Info Cube.

• Checking data consistency, aggregates and hierarchies through RSRV.

Advanced Micro Devices (AMD) Sunnyvale CA Aug 04 – Sep 07

SAP BW Consultant

Environment: SAP BW 3.1c, SAP R/3 4.6c, Windows 2000

• Worked extensively on the transaction data and master data user exits on R/3 using RSAP0001 functions.

• Sourced data from variegated data sources including R/3 & legacy data system transformed and loaded data into data targets using ETL tool.

• Created reports related to COPA like Sales Margin, Sales Growth, Sales Trend, P&L, etc reports. Created reports in SD like Daily Sales Bookings, Deliveries and Billing, Monthly Sales Analysis, etc.

• Set up the logistics customizing cockpit by maintaining the extract structures and data sources, activating the update, setting up V3 update for SD documents: sales, delivery and billing orders.

• Setup flat files extraction for legacy data, assigning data sources to the Info Source, defining transfer structure, and metadata maintenance for the Info Source.

• Handled profit center accounting cubes (0PCA_C01, 0PCA_C02), accounts payable cubes (0FIAP_CO2, 0FIAP_C03), accounts receivable cubes (0FIAR_C02, 0FIAR_C03) as a part of cross-functional SAP BW implementation. Created Balance Sheet, Profit & Loss Reports, Trial Balance, and Cash Flow Statement on GL Info Cube.

• As part of Performance Tuning optimized the load performance by adjusting the packet sizes, data selections and number of Info Packages.

• Created batch processes & coded ABAP programs as required for using in routines on the InfoObjects and Start routines.

• Generated report to get the list for the sales Division based on Customer of the Current year, which calculates the credit returns and quantity procured by the customer and evaluated by comparing the same with that of the previous year for the same period.

• Generated report for the Manufacturer to notify the delivery date and the details of material based on sales order.

• Generated a report for PO History from the date of order to pay of amount if PO is in open status then listing the details of the delivery schedules can change the delivery schedule date.

• Generated report to list the detail information of consignment Issue/returns.

Schneider Electric North America (SENA) Sunnyvale CA Jan 04– sept 04

SAP BW Consultant

Environment: SAP BW 3.1c, SAP R/3 4.6c, Windows 2000

• Worked on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery and billing information.

• Configured and customized Logistic Cockpit extract structures and data sources in sales and distribution and material management to facilitate the data extraction to BW and to reporting using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user exits.

• LO-Cockpit extraction: 2LIS_11_VAITM, 2LIS_02_HDR, 2LIS_03_BF and 2LIS_03_UM using V3 update.

• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.

• Enhanced existing master data and transactional data extractors. Modified and Created User Exit programs to accommodate additional fields in the extract structure of the Data source.

• Responsible for transporting the objects Using STMS Transaction.

• Developed front-end reports using Business Explorer (BEx) and published in the workbook.

• Responsible for designing ODS, Info cubes to run Profitability Reports and year end balances

• Worked extensively on configuration using Administrator Workbench (RSA1). Customized data Sources, Info Objects, Info Sources and Info Cubes. Designed by making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.

• Used RRI interfaces, Filters, Conditions, Variables, Currency conversions and navigational attributes. Exception handling through SAP Mail, batch printing and alert monitor.

• Monitoring of Master Data and Transaction Data uploads. Added New Transfer Rule, Update Rules.

• Worked extensively on BEx Analyzer. Used Navigational attributes, Filtres, Exceptions, Conditions, Jump targets (RRI), Variables, Hierarchies, etc. Created Templates for WEB Reports.

• Extensively involved in publishing the Reports to Portal, email, Collaboration rooms and KM using BEX broadcaster for the end users to access them

• Created Info sources and Transfer rules to characteristic Info objects and Loaded Master Data into them from SAP R/3 Source systems.

Advanced Energy Fort Collins CO Jan 03- Dec03

ABAP/4 Technical Consultant

Environment: SAP R/3 4.0B (SD, MM, PO, SO), ABAP/4, Oracle 8.0, Windows NT

• Analyzed and studied Required Specifications.

• As a member of the ABAP Development Team, involved in Developing Reports, BDC, Layout Set and Module Pool Programming as per client’s requirement.

• Involved in the Support and Maintenance.

• Developing an Interactive report clubbed with BDC for calculating the Sales commissions for Internal and external agents.

Reports:-

• Created a Classical Report to find out Stock availability for a particular storage location using select options Plant, Company Code, Material Number, and Storage Location.

• Created an Interactive Report that List details Vendor No ands address in the Basic list and Bank details Like Account Number, Bank Name and Bank details in the Secondary List.

• Created a Report to find out total of net Purchase Order Values for a particular Vendor.

• BDC:

• Customer Master records (using XD01 transaction) and Vendor Master Records (using MK01 transaction) from legacy system were brought into SAP using BDC programs.

Education

B.Tech (Electronics & communications)

Contact this candidate