SDESAI
Mail Id: *******@*****.***
Phone: 317-***-****.
EXPERIENCE SUMMARY
. Over Eight years of IT Experience with 7 years of proven SAP project and
implementation experience as an ABAP/4 technical consultant.
. Broad technical experience with WM, MM, SD, PP, QM, SM, PM and FI
modules.
. Have worked on various Manufacturing, Distribution and Pharmaceutical
industry projects.
. Experience in writing Technical Specifications and its Component
Specifications along with Unit Test Plans.
. Experience in full life-cycle implementations including post Go-Live
support.
. Got progressive experience evaluating, designing, programming, testing,
supporting and integrating SAP.
. Extensive experience in design, development and analysis of ABAP Programs
(Dialog Programming, Standard and Interactive Reports), ALV Reporting,
Object oriented Programming, Area Menus, SAP Scripts, Smart Forms, Adobe
forms, Menu Painter, Screen Painter, BAPI, User exits, BADI, Interfaces
and Conversion Programs, Programming using BDCs, LSMW, Data Dictionary
Objects, Batch Job Management, RFCs, Workflows,EDI, ALE and IDOCs.
. Hands on experience in SQL Trace and Runtime analysis for the
performance tuning.
. Expertise in List processing and SAP Query.
. Experience with Dynamic programming.
. Experience in extending IDocs to make them suitable for customer
requirement.
. Experience in RICEF Development Review.
. Excellent Knowledge of ABAP Workbench concepts.
. Experience in Workflow, Web Dynpros and Web Services for ABAP.
. Experience in developing BSP applications using HTML.
. Experience in using Report writer and Report Painter.
. Experience applying SAP OSS Notes.
. Experience with Solution Manager.
. Over one year experience in developing applications using Java and
Oracle.
. Ability to work independently as well as in a group.
. Strong team player and very good in interacting with Business users,
Functional and Technical team to meet the project deadlines.
. Good problem solving and analytical skills, sound technical knowledge,
willingness and ability to learn quickly.
EDUCATION
Master's Degree: Masters in Computer Applications.
TECHNICAL SKILLS
Operating Systems : UNIX, LINUX, Windows.
ERP Packages : SAP R/3 4.6B, 4.6C and ECC 6.0.
Cross Functionalities : BAPI, LSMW, IDOCs.
DBMS : ORACLE (7, 8 and 9i), SQL Server 7.0.
Programming Languages : C, C++,
ABAP,J2EE(JAVA,Servlets,JSP,Applets,JDBC).
PROJECT EXPERIENCE
Ditan Distribution LLC (Subsidary of CINRAM), Indianapolis
03/2007-Present
Ditan Corporation is a logistics management solutions provider specializing
in retail product lifecycle management offering custom solutions to
effectively maintain supply-chain pipeline.
Role: Sr ABAP Programmer/Analyst
Description:
Responsible for designing, developing, testing, documentation along with
continuous support for resolving day to day issues and immediate customer
needs in SD MM, WM and FI modules(ECC 6.0). Simultaneously scheduled and
managed various background jobs .Recognized as resourceful contributor and
acknowledged with increased developing responsibilities. Managed multiple
projects successfully and met all deadlines.
Responsibilities:
. Develop and demonstrate functional and technical understanding of
business process.
. Ensure all code is well documented and can be navigated by others in
the next phase.
. Active involvement in preparing testing, documentation, tracking and
reporting while improvising tracking of test areas of proven trouble
spots.
. Analyze, design, code and implement changes to resolve break/fix
issues to and close tickets. Provide appropriate communication
related to these issues as outlined in service levels.
. Identify, address and provide solutions to open issues related to
tickets and Service Requests
. Complete / review detailed work history and documentation for tickets
and Service Requests. Achieve assigned service level performance
metrics.
. Mentor, assist and leverage other team members, when appropriate, by
actively sharing knowledge.
Projects handled:
Warehouse Management Project:
. Implemented user exit EXIT_SAPLL03A_001 to restrict the maximum number of
line items in a TO to a specific number.
. Implemented user exit EXIT_SAPLL03A_009 to change the order quantity to
full pallet when the order quantity is below full pallet for bulk storage
location.
. Implemented user exit to change the pallet type of material to Odd pallet
based on business requirements.
. Developed a Module pool program using for wave planners and CSRs to be
able to create TRs and TOs manually depending on sku type and order type
as per business needs. Secondary TOs are being in foreground and
background when the product is being confirmed to EOA locations. An
assisting report and background job is also scheduled to create and show
the status of TOs at specific intervals. Also the functionality of
L_TR_Change_INTERN function module has been used to allow wave planner to
update the destination bin in TR. Did configuration adjustments as
needed.
. Developed audit trail ALV report using Object oriented concepts to show
customer specific information on transfer orders.
. Implemented method 'mb_document_before_update' of BADI MB_DOCUMENT_BADI
to capture business details on specific goods movements and send auto
emails to the customer.
. Developed an RF program for inventory team which would automatically
check SAP qty and
. Physical quantity of bins when a TO is confirmed as per business
requirements. Used Function module L_LAGP_VERAENDERIN to incorporate Put
away block on the bin and discrepancy in quantity along with other
necessary details are notified to the team through auto-email alerts.
. Developed several inventory snapshot programs to download the files to
customer ftp.
CLAIMS Project(Dialog Programming):
. Developed a tool for Claims Analyst to be able to track and file claims
for carrier undelivered packages over 3 days as per business
requirements. Developed programs to send auto-email notifications with
supporting documents to customers and carriers Held classes targeted at
familiarizing the users with the functionality of the project reducing
the delay in critical support scenarios initially.
Returns Project:
. Developed a Module pool program using screen painter and menu painter to
capture License plate number, RMA number and serial number of the product
returned from the customer and segregate them into different types of
stock based on business process requirements and post the goods movement
in the system.
. Developed billing routine to help bill returns to customer by finance
team based on License plate, RMA No and serial number to calculate
customer specific charges to be incorporated in billing.
Billing project (FICO-Reports):
. Developed billing routine using Object Oriented Concept for storage
billing based on aging level of customer specific skus in the warehouse
from initial receipt date. Separate functionality has been incorporated
to perform billing either unit based or pallet based depending on
customer needs.
. Developed Asset management report to determine the capitalization effort
for assets over a period of time.(AA)
. Developed Monthly Withholding Tax reports in AP.
. Developed Material ledger list of manual changes report for documents
effected using MR22.
. Developed billing routine using Object Oriented Concept for Production
billing based on production order confirmations during a particular
billing period.
. Developed a program to upload Journal entries using
BAPI_ACC_GL_POSTING_POST.
Order Processing (SD-Reports):
. Developed a program to create mass sales orders using
BAPISDORDER_GETDETAILEDLIST
and BAPI_SALESORDER_CREATEFROMDAT2.
. Developed a report to display order lines that have a delivery block,
or billing block, or credit hold, or forward buy check hold using
Dynamic Programming.
. Developed Carry Over report for tracking the progress of sales orders
not shipped.
. Created customer master IDOC using program RBDSEDEB.
Interfaces:
. Developed an interface for Accounting Journal in FI module.
. Developed Inventory Reconciliation Interface for 3rd Party warehouse
using LSMW.
. Developed inbound interface to load freight charges information from
Kewill system for Westchester shipments.
. Developed import interface as well as export interface from SAP to Dorner
Autologik system and vice versa for processing waves using order
information.
. Developed an inbound and outbound interface with Fortna System for
processing the orders using waves.
Workflow:
. Implemented Purchase Order system with different release codes and
release strategies for various approval levels and purchasing groups
within the organization using workflows to process the approval flow.
Webdynpro:
. Experience in creating several Web Dynpro ALV applications for WM module
while exporting and importing data from Excel file.
. Inserted a logo to an existing WD4A application.
. Added a code for popup window when an event relating to stock changes is
triggered.
. Added a URL link to a screen button in an existing WD4A application.
EDI/IDocs:
. Worked on Inbound and Outbound IDocs for EDI transactions Purchase orders
(850), Purchase order acknowledgment (855), Purchase order change (860),
and Invoice (810). Worked on outbound Remittance Advice/ Payment Order
(820).
. Transferred data with and without using message control.
Others:
. Developed program to read spool job contents (OTF or ABAP list) and
convert to PDF format and download using FM CONVERT_OTFSPOOLJOB_2_PDF and
CONVERT_ABAPSPOOLJOB_2_PDF.
. Developed an RF program for Goods Receipt against Production Order using
BAPI_PRODORDCONF_CREATE_HDR and FM MB_POST_GOODS_MOVEMENT.
. Developed programs to download and archive customer specific database
data.
. Applied OSS Note 1256200- for Web Dynpro ABAP ALV for a short dump caused
during export to excel.
. Developed several RFC enable Functional Modules exposing them outside SAP
as Web Services.
. Generated several ABAP query reports requested by users.
. Developed BSP applications using MVC architecture for displaying Business
Partner data using BAPI.
. Developed program to read spool job contents and convert to pdf.
. Developed several module pool RF programs for cycle count functionality.
. Developed and modified various SAPScripts and Smartforms to provide
packing list layouts as per customer requirements.
Coca Cola Bottling Co. Consolidated, NC
03/2006- 02/2007
Role: Senior ABAP Developer
Description: CCBCC is the biggest Coca-Cola Bottler company in United
States.
The project involved implementation of Service Management and Plant
Maintenance modules using ABAP Objects(ECC6.0).
Reports:
. Developed an ALV Report, Escalation of Prioritization on Notifications
using CL_GUI_ALV_GRID class.
. Developed an ALV REPORT to update the Last Count Date field (DLINL) in
the MARD table. This report also provides the functionality to display
the errors, correct them and re-process the records.
ModulePool:
. Developed Modulepool programs for Call Center Processing Transactions
using ALV Grids for replacing the transactions that the Dispatchers
currently use to assign Work Orders to technicians. Used several ABAP
Objects classes like CL_GUI_CUSTOM_CONTAINER, CL_GUI_ALV_GRID etc.
BAPIs:
. Developed Custom Business Object for updating the priority of Service
Orders using BAPI_ALM_ORDERMAINTAIN. Used IDOC_INBOUND_ASYNCHRONOUS
function module to create the Inbound IDOC. Incorporated IDOC
SERIALIZATION CHECK and POST functionality.
. Developed a Custom Business Object and RFC enabled Custom BAPI for
creating and loading Catalog Codes using BAPI_QPGR_SAVEREPLICA.
. Developed a custom function module for determination of Sales Price of
Spare Parts for CCNA customers using BAPI_INFORECORD_GETLIST and
ME_GET_INFORECORD_CONDITIONS.
. Developed a Function Module for Planning Plant assignment to Delivered
Equipment and Notification.
. Developed a Custom Business Object which is used to Load Initial
Inventory for equipment. This object is accessed through LSMW.
. Developed a RFC enabled wrapper FM to load Attributes and Characteristics
for Equipment Master Data using two separate Function Modules. Status of
IDOC is captured and updated here.
. Developed a Custom Function module executed inside wrapper FM to update
attributes of each piece of Equipment using BAPI_EQUI_CHANGE.
. Developed a custom Function module executed inside wrapper FM to update
characteristics of each piece of Equipment using BAPI_OBJCL_CREATE_KEY.
BADI:
. Implemented method change_data_save of BADI, NOTIF_EVENT_SAVE to provide
SAP generated Work Order Priority default on Service Notifications and
save the changes to the same.
Enhancements/User Exits:
. Used Function exit, EXIT_SAPLV60B_002 for A/R line (transfer to
accounting).
. Used Screen Exit SAPLIQS0 for Customer subscreens on Service Orders.
. Used Field Enhancement to add a new field ZZMODELNUM to MARA and provide
the Search Help for the same.
. Used User Exit to enhance standard Customer Master Search help DEBIX to
include Telephone No. on search and return 'Street2' and 'TelNo'.
LSMW:
. Performed data conversion task needed for uploading CCNA and CCBCC
Catalog CodesGroups and Codes using BAPI method.
. Involved in loading Initial Inventory for Equipment from legacy system
EMO to SAP
via BAPI method.
. Performed On-Demand conversion task for loading and updating the
attributes and characteristics for Equipments from Legacy System to
SAP.
. Performed One-Time Data Conversion task for Loading Initial Inventory for
Parts in SAP from Maximo using BAPI method.
. Performed One-Time Data Conversion task for Loading Purchase Info Records
in SAP from Maximo using Direct Input method.
ALE/IDOCs:
. Developed an ALE Inbound interface for uploading Catalog Codes and
CodeGroups.
. Developed an ALE Inbound interface for updating the Priority of Service
Orders.
Used IDOC_INBOUND_ASYNCHRONOUS function module to create the Inbound
IDOC and incorporated IDOC SERIALIZATION CHECK and POST
functionality.
. Developed an ALE Inbound interface for processing IDocs for loading and
updating the Attributes and Characteristics for Equipments from Legacy
System to SAP.
SmartForms:
. Developed Purchase Order for Spare Parts to be procured from external
vendors using SMARTFORMS.
Bucher and Christian Consulting Inc., Indianapolis
08/2004-02/2006
Client: Eli Lilly
Role: ABAP Developer
Description:
Eli Lilly Ltd. is a major American pharmaceutical manufacturer. The project
involved implementation of MM, SD and QM modules.
Reports:
. Developed GR, IR analysis report in MM module.
. Developed a report to process Hospital Green sheets and Customer Mailing
Labels.
. Developed Purchase Order Ageing report.
. Developed a report to provide complete and detailed information about the
quantity of the drug product distributed under the approved application,
including those distributed to distributors.
. Developed some QM reports like On-Demand Recall Summary Report to monitor
the on-going market recall process and report for Inspection Plans by
Site.
. Developed Account Definition Report for GL, Fixed Assets for Indiana
Personal Property Report and Property Tax statistical Utility program for
Asset Accounting in FI/CO module.
Interactive Reports:
. Developed a Rebate Remittance Advice report.
. Developed Material Master Status report which lists all the materials
Created, Changed and Flagged for deletion in Material Master.
Module Pool:
. Developed a Transaction Program for On Demand Inspection Lot Initiation
for Bulk Tank Monitoring in QM
. Developed a custom Function Module to retrieve Bulk Batch Numbers from
Custom Table based on Target Location and Plant for Movement Types '261',
'201' and '310'.
. Developed a Module pool Program for Global Supplier Quality Management to
evaluate suppliers in QM.
BAPIs:
. Used 'BAPI_SALESORDER_CHANGE' for changing a Sales Order.
BDC:
. Developed BDC to change Vendor information using Transaction Code XK02.
. Developed BDC program to upload Vendor Source List.
Interfaces:
. Developed Sales Interface(Italy) from Elanco Warehouse to generate new
order creation Idoc.
. Demand/Sales History outbound Interface from SAP to GDMS using IDOCS.
. Developed an Interface to transfer hospital group prices which have been
entered as bids into the Euridyce system via the local French SAD.
. Developed outbound Interface which extracts valid Purchase Order numbers
from SAP and writes the output to IDOC.
User Exits:
. Used EXIT_SAPMF02K_001 for Validating Vendor master data.
. Used EXIT_SAPLMLSP_031 for ME54N in MM module.
. Developed a Custom Search Help Enhancement for Standard SAP Search
Help SD_DEBI used in transaction VA01 and VA02.
ALE/IDOCs:
. Modified standard IDOC ORDERS04 to add new segment needed for message
type ORDRSP.
ABB Limited
04/2003 - 06/2004
Role: ABAP Consultant
Description:
ABB is a leader in power and automation technologies that enable utility
and industry customers to improve performance while lowering environmental
impact.
Reports:
. Developed a report to display order lines that have a Delivery block or
Billing block or Credit hold or forward by Check hold.
. Developed a report for tracking progress of Sales orders not shipped.
. Developed a report to retrieve Customers based on sales area, Customer
group and Price List type entered on Selection Screen.
. Developed Open Delivery report.
. Developed an interactive report to display information about quantity of
drug product distributed under the approved application.
Module Pool:
. Developed the program to update, create Bulk Batch Numbers, Display the
Change Log for certain materials in manufacturing processes in MM module.
. Developed transactions for storing details related to carton numbers a
feature that is not supported in SAP.
BDCs:
. Developed BDC to Create Batch Selection Condition records.
. Developed a generalized BDC for Supply Chain Management using Call
transaction.
BADIs:
. Used the BADI definition MB_MIGO_ITEM_BADI for MIGO transaction code. It
was used for validating the Jurisdiction Code, Tax Code and quantity in
unit of entry, quantity in delivery note against the quantity ordered in
MM module.
BAPIs:
. Developed a BAPI Interface for changing a sales order using
'BAPI_SALESORDER_CHANGE'.
Smartforms:
. Developed and modified various existing layouts as per user requirements
in MM and SD modules.
User Exits:
. Used EXIT_SAPLMEWP_002 for processing of purchase orders via BAPI.
ABAP Query:
. Used ABAP/4 query for providing on-line information to clients based on
their requirements.
Performance Tuning:
. Used Runtime analysis to analyze the processing of the reports. Based on
the estimated time for each action, modified queries to ease the database
interaction.
. Also used SQL Trace for analyzing the SQL statements in the reports.
IDOCs:
. Developed an Outbound Interface for Planned Orders from SAP to GDMS.
. Involved in extracting customer information using SAP standard IDOC
DEBMAS.
Pavani Engineers
02/2002- 03/2003
Role: JAVA&PL/SQL Programmer
. Involved in the design and development of Purchasing System module to
produce web based reports using JSP, Java Script, HTML and other web
development technologies.
. Developed the front-end GUI using JSP and JavaScript.
. Developed complex procedures, functions, triggers to do background
processing of the data.
. Developed a connection pooling strategy for JDBC connections to
database to effectively use the resources.
. Developed test plans and scripts to test functionality of the system
and ensure quality.
. Involved in Unit and Integration testing.