SUMMARY

• Over 13 years of professional experience in implementation of SAP HANA, ABAP/4, BI/BW and client server systems, exposure to SAP Net weaver - EP and Web Dynpro.
• Types of SAP projects worked on include Implementation, Upgrade, Roll-Out and Support Projects.
• Responsibilities include Senior SAP Consultant, Developer, and Supervisor.
• Exposure to best business practices (Dairy, Mining, Manufacturing, Retail, Security and insurance domains)
• Strong understanding of the full life cycle of the implementation from the concept stage to go-live and support activities. Excellent interaction skills, communication and teamwork skills.

PROFESSIONAL EXPERIENCE

Confidential

Senior HANA/BPC/BI/BW/ABAP Technical Consultant

Responsibilities:

• Worked in HANA migration, pre-migration and post migration phases.
• Profit center and employee dimensions loading in BPC, the development tasks involve SLT replication, HANA calculation views, HANA AMDP class and BADI UJD ROUTINE implementation.
• Cost object - Cost center/WBS/Internal order dimension loading in BPC, the development tasks involves SLT replication, HANA calculation views/Table functions, HANA AMDP class and BADI UJD ROUTINE implementation.
• Replicate BW hierarchy to the BPC for cost center and profit center dimensions using function module RSNDI SHIE STRUCTURE GET3 and BADI UJD ROUTINE implementation.
• Headcount data load and universal Orlando cost object load for NBCU in BPC, the development tasks involves SLT replication, HANA calculation views/Table functions, HANA AMDP class and BADI UJ CUSTOM LOGIC implementation.
• Involved in SAP Gateway/ODATA, FIORI applications and CDS views creation
• Developed SAP Gateway/ODATA using data model methods DDIC structure/ RFC/BOR interface
• Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines as per business requirement.
• Develop an interface program to set the user status BUDG of WBS Elements (Child), when WBS Element (Parent) status is BUDG using standard transaction CJ20N and BAPI BUS2054 SET STATUS
• Quarterly data load and Universal Orlando Walk (Add/Del/LOA) calculations in BPC, the development tasks involves SLT replication, read BW DSO's data, HANA calculation views/Table functions, HANA AMDP class and BADI UJ CUSTOM LOGIC implementation
• Implemented SAP notes based on business issues in FI, SD and MM areas, it includes understanding the business issue, coordinated with business users, basis team and approaching SAP whenever it is required.

Confidential

Senior HANA/BPC/BI/BW/ABAP Technical Consultant

Responsibilities:

• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the Calculation views as final model in HANA Studio Using Graphical & SQL scripting, CE functions, Analytical Privileges.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines as per business requirement.
• For BI/BW, created generic data sources in Dispatch and Equity modules using Table/View, Query and Function Module (RSAX BIW GET DATA SIMPLE) extraction methods.
• Extensively worked on importing SAP BW cubes, DSO's and multiproviders into SAP HANA Studio.
• Developed complex SQL scripts and implemented CE functions for HANA Calculation views.
• Worked in HANA migration, pre-migration and post migration phases.
• Using HANA advanced modelling features analyze the performance of queries on different models.
• Designed and developed the data models in HANA from multiple sources system via SLT using (SAP and non-SAP) for Real-time replications and BODS for Batch Job replications.
• Involved in SAP Gateway/ODATA, FIORI applications and CDS views creation
• Developed SAP Gateway/ODATA using data model methods DDIC structure/ RFC/BOR interface
• Involved in optimization of various data models using HANA best practices.
• Importing BW Infocubes into HANA as Information models and creating Calculation Views for the reporting requirements.
• Data Replication scenarios of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Replication of Master data table into HANA using SLT.
• Replication of Transaction tables into HANA for AP / AR using SLT.
• Created calculated and restricted column using calculation view in HANA.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Participated in the initial POC effort to do customer validation for ECC/BI on HANA.
• Created Variables and applied them as filters in HANA View.
• Created Hierarchies for Attribute Views in HANA.
• Created Transient providers on Hana Models and mapped them in Composite provider for reporting Hana data in Bex Explorer
• Collected and Migrated objects in Hana Landscape using Import/Export and delivery units in HANA
• Created Variables, Input parameters, calculated and restricted columns on analytical views in HANA
• Involved in BODS process flows for data provisioning in SAP HANA.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Implemented user exit COPA0002 to update the material master commercial price to COPA value fields when billing document is created.
• For BI/BW, Extract and enhance data sources from various SAP modules - OTC, PTP, FI/CO data sources: 2LIS 11 VAHDR/VAITM/VASCL/VASCH, 2LIS 12 VCHDR/VCITM, 2LIS 13 VDHDR/VDITM, 2LIS 02 HDR/ITM, 2LIS 03 BX/BF/UM, 0FI GL 14, 0FI AP 4, 0FI AR 4, COPA and several master data sources like initialize the delta (RSA7) process by running the setup of application components to synchronize the daily loads.
• In Dispatch module, developed Customer and Hauler weekly/daily publishing ADOBE forms.
• Implemented user exit COPA0001 to update to populate Milk marketing COPA Characteristic fields and correct COPA characteristics when invoice created from multiple Sales orders.
• In BI/BW, created custom DSOs, InfoCubes and Multiproviders in Dispatch and Equity modules.
• In Equity module, developed Base capital report letter, Equity base capital calculator, Retain payment request, Capital retain certificate, Base capital statement, Hauler annual letter using ADOBE forms.
• In BI/BW, developed Profitability Analysis Multiprovider which brings the data from different year’s InfoCubes.
• Implemented user exit COPA0002 to update the sales quantity values to COPA value field “Free of Charge goods” for the list of item categories relevant to Free of charge goods.
• Implemented user-exit FEDI0003 in FI, to change the IDoc segment E1IDKU3 runtime values. This enhancement FEDI0003 is invoked by IDoc PEXR2002 and program RFFOEDI1 for International Payment Medium by EDI.
• Implemented BADIs CUSTOMER ADD DATA CS and CUSTOMER ADD DATA to add Dispatch module screen in Customer Master (XD01).

Confidential

Senior BI/BW/ABAP Technical Consultant

Responsibilities:

• For BI/BW, Enhanced data sources from SAP MM: 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SGR, 2LIS 02 SCN, 2LIS 03 BF.
• In BI/BW, worked on LO Extraction to extract sales order, delivery and billing InfoCubes and DSO.
• In BI/BW, worked on planning functions revaluation, distribution by keys for the FI AR (Account Receivable)cubes.
• Implemented User-Exit VSV00001 to populate Partner Function of Ordering Address and Goods Supplier records in the segment E1WYT3M of IDoc CREMAS05.
• In BI/BW, Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems.
• In BI/BW, developed a customized invoice cube linked with modules SD, MM and FI.
• Involved in performance Tuning measures like Aggregates, Compression, and Partition& Indexes in BI/BW
• Implemented Implict enhancement point ze i1391 zshpmntin idocstat and user-exit V55K0020 for Idoc SHPMNT05 data to change the status from 51 to 63 for unpacked deliveries in SD.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines and ABAP routines for the customer exit variables.
• Developed an inbound interface program to extend the materials from one plant to multiple plants using BAPI BAPI MATERIAL SAVEDATA.
• Developed an inbound interface program to create PO using BAPI PO CREATE1, GR using BAPI GOODSMVT CREATE and Batch characteristics using BAPI OBJCL CHANGE simultaneously. Also, developed custom transaction to mass transactions in one go.

Confidential

Senior BI/BW/ABAP Technical Consultant

Responsibilities:

• Developed an outbound IDOC to send Demand data from SAP to PKMS. The Idoc segment carries the details of the materials with their number of days of arrival into the warehouse to assist with warehouse slotting. Also, involved in PI mapping.
• Implemented BADI BADI MATMAS ALE IN for Inbound material IDOC /AFS/MATMAS05 to change the weights and measures of material from NWS. Also, involved in PI mapping.
• Developed a program to create Goods receipt Posting using BAPI /AFS/BAPI GOODSMVT CREATE to adjust the SAP inventory to match the PKMS inventory quantity.
• For BI/BW, Extract and enhance data sources from various SAP modules - 2LIS 11 VAHDR/VASCL/V SCL, 2LIS 12 VCSCL, 2LIS 13 VDITM/VDKON, 2LIS 02 SCL/SCN and 2LIS 03 BX/BF/UM.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines and ABAP routines for the customer exit variables.
• Using custom inbound IDOC receive the PKMS Warehouse Inventory data in SAP. Also, involved in PI mapping.
• Developed an interface program in SAP R/3 (ECC 6.0) and FI, to pass the custom fields of AS02, using extension structure BAPI TE ANLU. This program uses BAPI FIXEDASSET CHANGE to change/set tax status of existing assets in FI area.
• Implemented a BADI FDM AR DEF DUE DATE to determine Default Value for Processing Deadline in SD.
• Developed an outbound IDoc which sends the case#’s and contents for carton labels to the PKMS so they have visibility to the incoming cartons. Also, involved in PI mapping.
• Developed Vendor portal Capacity Management user interface component using ABAP Web Dynpro.
• Spending Authorization user interface component using ABAP Web Dynpro.

Confidential

Senior ABAP/BI/BW Technical Consultant/Lead

Responsibilities:

• For BI/BW, created generic data sources in Dispatch and Equity modules using Table/View, Query and Function Module (RSAX BIW GET DATA SIMPLE) extraction methods.
• Developed an outbound and inbound interface programs to extract General Ledger data from GEMS and WP1 systems, and to create G/L Account posting using BAPI BAPI ACC DOCUMENT POST in Eagle system.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines as per business requirement.
• Developed a custom transaction for BOM change Request using workflow, on the successful approval of BOM changes, the changes will be updated in standard SAP tables. Printing of Material components of respective BOM using Adobe form.
• BADI WORKORDER UPDATE is implemented to cater for Cross plant stock determination and the immediate creation of STO, Goods Posting for the immediate fulfillment process. If the material is warehouse material create Transfer requirement (LB01), Transfer order(LT04) and confirm transfer order(LT12) in MM and WM areas.
• Develop an interface program to set the user status BUDG of WBS Elements (Child), when WBS Element (Parent) status is BUDG using standard transaction CJ20N and BAPI BUS2054 SET STATUS
• Implemented Implicit Enhancement Option ZSD SALES ORDER POPULATE in program RV60AFZZ and routine USEREXIT PRICING PREPARE TKOMP to display Sales Order and its item in the COPA Characteristics for Inter Company Billing documents.
• Developed an outbound and inbound interface programs to extract Account Payable data from GEMS and WP1 systems, and to create an Invoice or Credit Memo using BAPI INCOMINGINVOICE CREATE in Eagle system.
• Implemented a BADI AC DOCUMENT to replace DUMMY Profit Center with valid Profit Center from other line item at the time of accounting document creation.
• Implemented a BADI WHTAX SPLIT UPDATE to populate withholding tax code. When we try to create an Invoice/ Credit Memo using BAPI INCOMINGINVOICE CREATE the Withholding Tax Code is not populating properly. This enhancement technique solves the Withholding tax code issue.

Confidential

Senior ABAP/BI/BW Technical Consultant

Responsibilities:

• Developed an Exit routine for Substitution in FI and SAP ECC 6.0 to update lives of LOM assets in asset master using worklist transactions AR01 and AR31.
• The purpose of this program is to accept the input file with list of parent WBS elements. For each parent WBS element create a child WBS element using BAPI BUS2054 CREATE MULTI. For each created child WBS element set status of parent WBS element using BAPI BUS2054 SET STATUS.
• Developed LMS Account Payable interface in SAP and FI area using BAPI BAPI ACC DOCUMENT POST. This interface also notifies users with PDF attachment email whenever errors occur.
• Implement user-exits RFFOX100, RFFOX101, RFFOX102 and RFFOX105 to develop a NACHA file to Deliver ACH payments for garnishments to Bank. All the exits are invoked by program RFFOUS T.
• This Program is developed to post a negative allocation for Fringe Benefits and Incentives using SAP transaction FB01 i.e. BAPI ACC DOCUMENT POST. This automatic process will replace the manual data extraction, manipulation of data and SAP journal entry upload.
• For BI/BW, Enhanced standard extractors using BADI RSU5 SAPI BADI to populate the custom fields based on according to business requirement.
• Implemented user exit COPA0003 for COPA Characteristic Entry Modification.
• For BI/BW, created generic data sources using Table/View, Query and Function Module (RSAX BIW GET DATA SIMPLE) extraction methods.
• Implemented Screen Exit AIST0002 to a sub screen to add taxable and non-taxable custom fields for transaction AS01. Also, done configuration by me in FI area.
• Implemented a BADI AC DOCUMENT to Populate Trading partner and Partner profit center on Inter-company AR.
• To print check/s, develop a new bank check form based on standard SAP Script form F110 PRENUM CHCK and new driver program based on standard program RFFOUS C. Finally configure in Payment run transaction F110.
• Developed a program to load Bank master data using BAPI BANK CREATE and BAPI BANK CHANGE in FI area.
• For BI/BW, extensively worked on transformations - Start, End and Field Routines and ABAP routines for the customer exit variables.
• The purpose of BADI WBS USER FIELDS F4 implementation is to provide F4 help for Project Type field of Project systems(CJ20N) and appropriation request(IMA11).
• Worked on KE30 COPA reports to fetch the profitability based on Product/Customer/Customer group/Division/Sales area.
• Develop an interface program to set the user status BUDG of WBS Elements (Child), when WBS Element (Parent) status is BUDG using standard transaction CJ20N and BAPI BUS2054 SET STATUS
• Developed an inbound interface for Mass Journal Entry upload in FI area using direct input program RFBIBL00
• Using LSMW in FI area load Statistical Key Figure (KK01), Cost center (KS01) and Profit center (KE51) data into sap.
• Implemented logic in most of the SD Pricing Formula Routines to resolve quality rounding issues.
• Develop RFC Function Module to interface with XI and ADX to create Invoice in SAP and MM area using BAPI BAPI INCOMINGINVOICE CREATE
• Using Screen Exit CNEX0007, create a sub screen to add new custom fields for transaction CJ20N in FICO and project systems area.
• Implemented User Exit FYTX0002 in MM area for transaction MIRO to pass additional tax relevant data to Sabrix. This user exit passes data from SAP to Sabrix for tax calculation.

Confidential

ABAP/CRM Technical Consultant

Responsibilities:

• Develop an interface program in FI to change the profit center master data using BAPI BAPI PROFITCENTER CHANGE.
• Using LSMW with standard input programs RCRAPDX1 and RCRAPDX2. Uploading material master(MM) data using LSMW.
• In CRM, Implement a BADI definition CMS BFW DDH BADI to determine SD contract based on the legacy contract number.
• Implemented VOFM routines in SD.
• Program to extract indirect sale data i.e. RTCM, Seller DMU and Buyer DMU data from CRM channel management. The SAP data will be used by the Calidus system.
• Developed RFC function module to export email address details of the IT support. Customized table created to maintain support team data. The RFC called by the Web Dynpro and finally the data will be shown in the iView of Enterprise Portal.
• Implemented a BADI definition CMS BRE RULE BADI in CRM to perform Special Bid Claim validations which include End user specific, All or none and Promos.
• Pre sell-in validations, implement a BADI definition CMS PRE SI BADI in CRM-CHM to remove the unwanted order document type, item category records and change the division for required order records in CRM.
• Enhancing the Sales order IDoc based on the business requirement.

Confidential

ABAP/CRM Technical Consultant

Responsibilities:

• Inbound interface program using BAPI BAPI FIXEDASSET CREATE1 to place Asset Master Data into SAP FICO system.
• In CRM, implemented BADI ADDRESS CHECK to validate the Business partner address. SAP XI sends the BP address to store in CRM box which will be validated first by QS/DS before it store in CRM System. The stored business partner details will be called by the web Dynpro using RFC function module.
• Using Smart form, developed a form for Live HPTR
• Sales order creation using BAPI BAPI SALESORDER CREATEFROMDAT2 in SD area
• Developed an interface in CRM to create territory objects using function module CRM TERRMAN TERRITORY CREATE and, function module CRM TERRMAN TERRITORY UPDATE to update existing territory id with new zip codes for each dealership.
• Involved in customizing the standard IDoc CRMXIF PARTNER SAVE M02 which will create and change business partner, activity (BAPI ACTIVITYCRM CREATEMULTI) and lead document (BAPI LEAD CREATEMULTI) sequentially.
• Developed a mass maintenance of unprocessed consumers interface in CRM. The interface program is developed using function modules BUPA CENTRAL CI CHANGE, BAPI BUPA ADDRESS CHANGE