SAP ABAP BW consultant

Summary:

• Over ** years of IT experience, ** years in SAP development, configuration, implementation and upgrade

• Worked on BW 3.5 and SAP BI 7.0. Experience with the design and development of SAP BI/BW applications

• Extensive experience with ALE/IDocs, ABAP development including reports, interfaces, ABAP Objects, Workflows, SAPScripts and SmartForms.

• Worked on LSMW and data migration.

• Worked on several modules including MM, SD, PP, QM, WM, FI-CO and APO

• 2 Full life cycle implementations experience

• SAP R/3 Releases worked on: 4.5B ,4.6 C, 4.7, ECC 5.0 and ECC 6.0

• Technical Lead consultant on 7 projects and was employed by SAP America as a Technical lead

• Knowledge of the Insurance, Defense &Aerospace, Healthcare, AFS, Banking &Financial sectors

• Excellent written and oral communication skills

BW/BI skill set:

• Experience working with the SAP BW tools, focusing on Extraction, Transformation and Loading of Data (ETL)

• Knowledge of the SAP BW Metadata repository, concepts and OLAP functions of SAP BW Reporting

• Activation and enhancements of Datasource from LO cockpit.

• Performed Generic data extraction and customized standard SAP extractors. Also extracted data from flat files.

• Developed Transfer /Update Rules and ABAP user exits for transaction and master data

• Experience working with standard Infoproviders - InfoCubes, InfoObjects, ODS/DSO, Infoset.

• Experience in creating InfoPackage to create Process chains and Scheduling of data, loading with full/initialization/delta upload method

• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables.

• Experience in Reporting Agent and Web reporting/ publishing using Web Application Designer and EP.

ABAP skill set:

Areas of expertise include:

• ABAP/4 reporting for MM, SD, PP, QM, WM and FI modules across various implementations

• ABAP Objects using MVC design pattern in ABAP Workbench

• RFCs, Function modules, BAPIs and BAdIs

• Custom User Exits, Screen exits and Menu exits

• Reports using ALV grid and event processing

• Batch Jobs, Process Chains, and BDCs

• Workflow programming and configuration

• IDocs, ALE, and EDI Technologies

• ABAP Debug, SAP Trace and Analysis Performance tools

• SAPScript: Custom Development and Modifications to SAP defined Layout Sets and Print programs

• Dialog Programming: SAP Process Reengineering, Interfaces to custom data repositories and reference tables

Experience:

Technical Consultant, Northrop Grumman, Redondo Beach, CA 10/09- Present

• Responsible for design and development of several One source projects (8C, 8B and 9R). For e.g.

• Created an online transaction and a conversion program for SAP Signature authorization. This application will allow for new approval types for all the One Source Sectors.

• Created a report to display manual transfer of lot costs (NRE) associated with the part costs for 415Q transfers. Fixed performance issues for some existing programs.

• Created ALV reports in MM and FI. Created user exits and enhanced existing BAdIs.

• Worked on providing detailed technical documentation for all projects.

Environment: SAP ECC 6.0, MM, FI, BAPIs, BAdIs, ABAP.

Technical Consultant, Curtiss Wright Inc, Santa Clarita, CA 04/08- 08/09

• Involved in the BI 7.0 implementation as part of their ECC 6.0 implementation project.

• Designed the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW. Extracted data from the Planning Area (DP).

• Developed custom InfoCubes and enhanced standard Data sources by appending with ZZ Fields and populating them with user exits.

• Developed ABAP Routines for lookups and used LIS extraction for getting orders and Deliveries.

• Designed and developed several BEx Queries for LAG reports – Actuals vs. Forecast

• Created process chains to automate the load process.

• Developed RICEF objects in APO and SD.

• APO - Updated user exit: CIFMAT01 in R/3 and APOCF005 in APO to add and validate custom fields in the CIF. Developed a RFC function module to return MRP controller data from R/3 back to APO.

• SD - Developed an outbound interface program to send files of master order data by plant to the legacy weigh and price scheduling systems. Created a custom number range for BCE output files. Developed a filename exit function module to get next available number for output file name.

Environment: SAP ECC 6.0, BI 7.0, BW 3.5, APO 4.0, SD, ABAP.

Technical consultant, Warnaco Inc, City of Commerce, CA 06/06-02/08

• Participated in meetings with users to determine requirements and scope.

• Extracted data using flat files for raw materials in order to track inventory.

• Performed Data extraction from R/3 (LO Extraction) and Flat files.

• Designed & developed custom Infocube based on clients’ specification.

• Extracted and loaded data from SAP R/3 into Purchasing Groups infocube (0PUR_CO4) using datasource (2LIS_02_HDR), and into Purchasing Data infocube (0PUR_C01) using Infosource (2LIS_02_ITM – Purchasing Data Document Item Level) and Infosource 2LIS_02_SCL – Purchasing Data Document Schedule Line Level)

• Activation and installation of Business Content datasource 2LIS_03_BF (Material movement from Inventory management), 2LIS_03_UM – Material Revaluations were used to load data into Material movements infocube 0IC_C03.

• Worked on job schedules by creating Process Chains to run periodic loads.

• Created custom reports using Business Explorer (BEx) to give detailed level of information from queries based on ODS Objects.

• Used BEx analyzer to develop and facilitate data analysis using Filters, Navigational attributes, Calculated and Restricted Key Figures.

• Created Aggregates on InfoCubes to improve Query performance.

Environment: SAP 4.7, MM, BW 3.5, ABAP.

Lead Technical consultant, Medtronic Inc, Northridge, CA 05/05-02/06

• Developed custom screens and logic for Automated Clearing House. Enhanced the sales order process with user exits to include ACH processing. Created NACHA file according to customer specifications.

• Created several user exits to increase the Lockbox efficiency.

• Designed and configured Java connector (JCO) to allow ACH processing. An RFC was created to access the Business connector, which in turn would call the Bank of America Payment gateway and validate the ACH account information.

• Developed several reports to handle the ACH process. Modified several existing programs according to client requirements. Extensive documentation provided to client at the end of the project.

Environment: SAP R/3 4.6 C, SD, FI, ABAP, Java Connector (JCo).

Lead consultant, Seminis Inc, Oxnard, CA 03/04-04/05

• Responsible for the design and development of custom RF console transactions using SAPConsole.

Developed twelve new transactions and modified four standard SAP RF transactions with user exits

in the Warehouse Management module.

• Extensive use of Mobile data entry configuration, user exits and dialog programming.

• Created six new reports and enhanced many existing reports in MM and SD.

Environment: SAP R/3 Enterprise (4.7), WM, MM, SD, ABAP, SAPConsole.

Technical Lead (Employee), SAP America, Newtown Square, PA 05/01-10/03

Customer: Statoil, Oil Downstream Industry (Denmark, Sweden)

• Responsible for developing a PP-PI prototype for 2 lubricant plants for a world’s leading manufacturer of products and services for Oil and Lubricants in Scandinavian countries.

• Responsible for performing basic configuration of PP-PI 3.1H including IS-Oil, sub-contracting, pipeline material, raw material purchasing, unit of measure conversion.

• Responsible for developing a common product costing model for their 2 lubricant plants

Environment: SAP R/3 4.6 C, PP-PI, MM, BAPIs, RFCs.

Customer: Canada Post

Involved in the Canada Post project team implementing SAP 4.6C modules MM and SD. Worked closely with functional consultants and designed processes for start-up data loads of Master Data, Inventory and Warehouse data using Batch Input, Direct Input, BAPIs and IDOCs. Primary contributions were as follows:

• Developed remote interfaces using full-control job scheduling

• Interface Design adopted as template for Canada Post interfaces using File Transport protocol

• Produced several reports in MM and SD using ALV controls technology

• Provided drill-down field help and search help enhancements

• Employed testing tools for run-time enhancements

• Queried OSS for problem resolutions

• Created BDC code to reverse inventory data load on an if-needed basis

Environment: SAP R/3 4.6 C, MM, SD, ABAP, ALVgrids, User exits, BDC, BAPIs,

SAPScript, IDOCs

Customer: Imperial Tobacco

Worked with a team of developers to create Sales and Forecast queries in the BEx Query Designer in an APO 3.0A/BW 2.1C system. The report was initially created in R/3 and involved complicated rolling weeks calculations for the Sales/Forecast key figures. The calculations were realized using BAdI implementations and user exits in APO. The following were the tasks performed:

• Worked on Remote InfoCubes to support real time data. Configured the data sources in BW to retrieve Sales/ Forecast data from APO

• Created Multiple Update and transfer routines

• Created multiple events and related jobs to automate the loads from R/3 and APO

• Worked on Query Designer. Used Free characteristics, Filters, Variables etc

• Created Variables with user exits and replacement path

• Used Calculated and Restricted Key figures

• Created ABAP Objects to separate sales/forecast data and calculations in BAdIs

Environment: SAP R/3 4.6C, SAP APO 3.0A/SAP BW 2.1C, BEx Analyzer/Browser, ABAP, BAdI

Project Lead (Independent), Alliance Consulting, Philadelphia, PA 09/00-03/01

Solutions Architect for the analysis, design and development of Plant Maintenance application and legacy

data capture for a start-up project. Created IDOCs for data transfer and developed SAP screen-exit

enhancements for Maintenance Order/Service Order SAP tables. Responsibilities included:

• Creating and maintaining SAP database objects

• Coding function exits for data transfer to and from SAP sub-screen

• Developing screen-flow logic for input data validation modules

Environment: SAP R/3 4.6C, PM, ABAP, IDOCs

Senior Programmer, AT&T Wireless Services, Dallas, TX 03/99 - 08/00

• Involved in recruiting and participated in the development of the RSF (Retail Storefront) Project. This application provided a catalog of services and routed the required provisioning transactions to other systems. The project utilized a web based front-end to leverage the ordering across the direct retail and dealer channels. The services that were offered to the customer through RSF were Consumer Long Distance, Accessories and Wireless Services. A customer had flexibility when requesting anyone of these services offered

Environment: Java 1.2, Servlets, JDBC, XML, Oracle 8.0.4

Programmer, Lennox International Inc., Dallas, TX 11/97 - 02/99

• Designed and implemented a three-tier application for the Sales dept. which had transportation software (ITLS-Inter Trans logistics system) interfacing with SAP that would optimize shipment processing for all the plant locations. This application replaced the optimization processes for shipments and deliveries for the smaller plants.

Environment: ABAP, MM, SD, SAP R/3 3.1H, ITLS (iTwo technologies).

Education:

SAP Academy Certifications in MM, SD and BW Configuration

B.Arch, Malnad College of Engineering, Hassan, Karnataka, India.

Contact this candidate