DAVID P. CAWLEY
2246
Coventry Court
Mechanicsburg, PA 17055

215 439 7702
cawleyconsulting@hotmail.com

 


PROFILE

ABAP developer with 9 years of SAP experience and expertise primarily in the SD, MM and FM modules. Varied design and programming skills including online reporting, dialog, interface, conversion, CATT,  SAPScript, BAPI, BADI, BTE and BDC programming. Abilities include mentoring junior developers and auditing programs for performance issues.

 


PROFESSIONAL SAP EXPERIENCE

 

Cawley Consulting Incorporated [Client: U.S. Navy]

July 2003 – present
ABAP Consultant

Supported the IS-PS year end processing.  Aided in the preparation for year end by developing custom reports, price update programs, and programs to update the pricing on open sales orders, purchase orders and purchase requisitions.

Post year end support – developed a report to analyze the Funds Management Carryforward transactions to determine which documents had not been carried forward completely and to determine which carryforward transactions were missing. 

Applied OSS Notes and communicated with SAP directly to fix problems with IS-PSM – Funds Management.

Participated in a patch upgrade from SAP 4.6C IS-PS Patch level 5 to patch level 14.  Re-copied standard functions and reapplied modifications.  Analyzed and adjusted userexits and custom code for upgrade impact.  Supported the system testing and provided go-live support for the patch upgrade.

Enhanced and applied bug fixes to custom reports and interfaces.  Supported interfaces using the Department of Defense MILS file structure.

 

Cawley Consulting Incorporated [Client: Owens Corning]

January 2001 – June 2003
ABAP Consultant

Participated in the upgrade from 3.1h to 3.1i.  Reapplied modifications and OSS notes and updated custom programs as necessary. 

Lane Capacity - Added transportation lane capacity checking to the order-entry capacity management functionality.  Created new custom tables and maintenance transactions for transportation lane definition and lane capacity configuration.  Wrote reports to manage lane capacity and monitor capacity utilization.  This customization enables more optimal usage of carrier capacity to reduce transportation cost.

No Touch EDI(six sigma project) -  worked on a team to devise a solution to EDI orders being placed on block and manually reviewed.  Designed a solution to evaluate sales order data and log orders that fail to comply with business rules.  Applied code changes to order entry programs to implement this design.  Built maintenance transactions for custom configuration tables to allow flexible implementation of the business rules.  Wrote a BAPI on the APO system to return Quota Arrangements to determine if most of the order was sourced from another plant.  

Wrote functional specification and performed programming for a rewrite of the sales order entry shipping constraints and delivery timing customizations.  This rewrite will allow for significantly easier support of this customization and will eliminate inconsistent results.  Customer requirements for receiving hours by division and European requirements for calculating transit times using a factory calendar are also addressed.

CRM – wrote reports using ABAP List Viewer in CRM 2.0 to report status of appointments and jobs by branch.  Developed and tested CATT scripts to load business partners and assign relationships between them.  Wrote an extract program to pull business partner data for interface to an external system.

No Touch EDI Phase II(six sigma project) - Provided feedback and input on design.  Made modifications to EDI processing to perform multiple inspections formerly done manually – block EDI orders based on the results of these inspections.  Added functionality to the order entry screens to display the inspection results.

GRIR/GRNI Automatic Clearing – modified a report of GRIR/GRNI data to extract unmatched goods receipts and invoice receipts for review by Accounts Payable.  Modified Standard automatic clearing program to use a custom account assignment strategy and to evaluate whether items are within the automatic clearing tolerance.  Wrote a program to upload the reviewed variances and call the modified automatic clearing program.

Modified Objects Catalog – designed custom reports and tables to catalog and classify modifications to the SAP system performed at this client.  This tool is primarily for use in upgrades to provide a worklist to each functional area.

Request Date Integrity – Calculation of the requested delivery date on the sales order based on customer guarantees and published service standards.  Development involved the modification of SAP code and userexits and the development of custom table maintenance screens to hold configuration for the new functionality.  Modified previous customizations to take advantage of the new guarantee and lead time data.

EOrder Automation Phase III(six sigma project)  - added further inspections to the EDI sales order processing.  Modified old inspections to be more flexible by allowing more precise configuration of the checking tolerances.  Managed an offsite resource to reduce the project timeline – designed an automatic order change program to fix a subset of the order defects and unblock orders that could be fixed to allow them to proceed through as no touch orders.

Cawley Consulting Incorporated [Client: Raytheon Technical Services Co.]

October 2000 – December 2000
ABAP Consultant

Conducted Performance & Tuning Reviews of sixty reports, interfaces, conversions and enhancments.  Reviewed the results with the developers.

Wrote an MM/PS report to show the status of purchase requisitions by project.  Designed and programmed three CO reports to allocate overhead to projects.

Executed custom CO conversion programs to load cost center balances, cost history and internal order balances.  Modified conversions and conversion reports as needed.

 

Cawley Consulting Incorporated [Client: FMC]

June 2000 – September 2000
ABAP Consultant

Created new matchcode ID for billing documents not relevant for accounting.

Enhanced custom report programs including modifying the structure and update routines of an SIS structure.  Added new fields, new selection criteria, new sorting options, Excel download capability.

Created a custom ABAP to reformat journal entries for processing by SAP standard load program.  Wrote custom report programs to solve various business requirements.

 

Cawley Consulting Incorporated [Client: Owens Corning]

 

November 1999 – June 2000
ABAP Consultant

Performance tuned nightly EDI Invoice program resulting in significant improvement.  Analyzed OSS Notes prior to their application.  Coordinated efforts among multiple consultants on related projects.  Served as the contact person for ABAP issues for an off-site development team.  Updated programming standards and performance tuning recommendation documents.  Mentored junior ABAP developers.

Added a custom function module to many custom reports and interface programs to add authorization checking by plant, sales organization or company code to the programs.

Developed custom production statistics recording transactions to maintain custom tables and call standard transactions to do production confirmations (CO11) and cancellation of confirmations (CO13).  Developed supporting reports to analyze the collected data.  Coordinated the efforts of multiple developers on this project.

Created inbound and outbound LiveInterface(UPI) programs for an interface to a new Warehouse Management bolt-on system.

Modified picking list SAPScript and driving ABAP program to print multiple deliveries on the same picking list sorted by material characteristics values.  Built a custom transaction to allow the picking of multiple deliveries at a shipment level using the same sort criteria to keep the custom picking list and picking screen synchronized.  This custom transaction performed call transactions to VL02 to update the picked quantity on the delivery items.  Designed the sort routine to use a custom configuration table so the sort criteria can be unique to each plant and use multiple characteristics.

Cawley Consulting Incorporated [Client: Executone]

 

August 1999 – November 1999
ABAP Consultant

Analyzed reporting requirements developed independent of SAP by a management consultant.  Mapped the requirements to SAP.  Developed prototype interactive ABAP reports to satisfy the management reporting needs.

Cawley Consulting Incorporated [Client: Lockheed Martin]

July 1999
ABAP Consultant

Modified Training & Event Management SAPScripts.  Configured Training & Event Management output control.  Added processing functionality to route output to either the printer or email based on the recipient’s personnel area.


Cawley Consulting Incorporated [Client: Radiant Infoschool]

December 1998 - July 1999
ABAP Instructor

Taught ABAP to programmers who wanted to transition into the SAP market. Developed own course outline, agendas and exercises.  Course covered topics including: SAP three tier architecture, ABAP Basics, SAPScript, Dialog Programming, Data Dictionary, Function Modules (including RFC), SAP EDI and IDOC concepts, batch interface processing, SAP record locking, change documents, number ranges and more.

 Cawley Consulting Incorporated [Client: PricewaterhouseCoopers]

November 1998 – July 1999
Senior Consultant

 Mentor junior ABAP developers at a remote development center. Serve as a senior reviewer in high-level design reviews and code walkthroughs. Assist in the analysis of functional specifications provided by the client and formulating questions necessary to clarify issues with these specifications. Explain SAP functionality to junior developers. Develop functional specifications for an internal training project necessary to expose developers to batch input development.

Aid in the development of multiple bolt-on subsystems to extend the functionality of SAP. Tasks included database design, dialog, reporting and batch programming.

Deloitte & Touche Consulting Group/ICS [Client: Owens Corning]

September 1997 – October 1998
Senior Consultant

Corrected and enhanced customizations to the sales order entry transactions that had been applied to standard SAP source code. These customizations involved checking warehouse and transportation capacity as well as customer allocation after the standard SAP ATP checking has completed. This was necessary because of restrictions in the loading areas at the plants (warehouse capacity) and the availability of trucks from trucking companies (transportation capacity).  These constraints limit the number of trucks that can depart from a plant.  The modification also allowed the user to specify a delivery time other than the opening hours on the ship-to master. The goods issue time necessary to meet the requested delivery date and time was also computed.  The modification changed the values in the schedule lines after standard ATP checking had created them.

Participated in the upgrade from 3.0d to 3.1h. Evaluated SAP notes and customizations and determined which notes were to be reapplied and how to reapply customizations. Reapplied these changes and tested them in version 3.1H.

Corrected and enhanced a variety of report and interface programs.

Mentored client ABAP programmers.

National Starch and Chemical Company

 

March 1997 - August 1997
Sr. Systems Analyst

Developed extracts of customer, material and pricing data to UNIX files for import into a Data Warehouse. Wrote related UNIX scripts to copy these files to the Warehouse server and execute the ORACLE load programs.

Analyzed user requirements and designed the technical customization strategy for implementation of SAP EDI for inbound sales orders, and outbound sales order acknowledgments and invoices.

Debugged and corrected a variety of interface, reporting, SAPScript and custom transaction problems. These included the redesign of the interface to a complaint tracking system, the correction of data on sales and inventory reports, resizing and adding fields to SAPScripts.

Analyzed and redesigned custom interface programs to improve their performance using a variety of techniques learned in ABAP/4 Performance Tuning class. Trained other team members and consultants in these methods. These methods shortened nighttime processing by 6 hours and shaved over an hour from noontime processing. Many online reports were significantly improved as well.

Designed and developed a condition type re-code program to copy all valid freight equalization condition records to a new condition type which was weight dependent rather than quantity dependent.


December 1995 - March 1997
Sr. Programmer/Analyst

Debugged and modified custom pricing record copy and delete transactions to alleviate problems with the related audit reports. Fixed record locking problems as well as problems with re-coding and copying percentage discount records.

Modified the sales order acknowledgment, packing list, bill of lading and invoice output programs to include gross and net weights in both pounds and kilograms. This was necessary to satisfy immediate customer demands for metric output.

Supported the customization of pricing functionality by developing and modifying custom requirement routines. These routines were necessary to eliminate mutually exclusive components of the unit price. The elimination of certain quantity discounts if the customer had received a group level special price was also enforced using requirements routines.

Analyzed and reported SAP system problems. Applied SAP Notes and re-tested system functionality to fix problems with both SAP delivered reports and SAP transactions which did not function as expected.

Enhanced custom code in Sales Order Processing User Exits.

Designed and developed an output processing ABAP to create a UNIX flat file with invoice information to be fed into to an EDI translator. This system was a quick-fix solution for required EDI functionality that could not wait for a full-scale implementation of SAP EDI. A new output type was created and added to customers who demanded EDI output. When this output was produced on SAP it appended to a flat file rather than creating printed output.

Modified an existing online report to automate multiple subsequent steps required of the user. These steps included the creation of a return sales order; delivery of the sales order and in some cases related material movements. This enhancement produced significant time savings at the plants when a shipment of returnable packaging was received.

PROFESSIONAL EXPERIENCE

National Starch and Chemical Company

May 1995 - December 1995
Programmer/Analyst

Supported and enhanced an Executive Information System using pcExpress/EIS. Created new drill-down hierarchies including a new classification of the business, the SBU. Enhanced online functionality to include dynamic graphing.

Used DDE to link screen notation and capture functionality with cc:Mail. This allowed users to add text and graphics on an application screen, capture the screen to a file and then automatically attach that file to a cc:Mail message from within the application.

Trained sales managers and executives in the use of EIS. This training was provided on an individual basis. During this training, feedback was elicited regarding desired capabilities of the system. Many ideas from these sessions were later added to the system as part of the continued enhancement of the system.


May 1994 - May 1995
Associate Programmer

Developed and implemented EDI/EFT for Computer Associates Accounts Payable System in an IBM/MVS environment using COBOL and JCL. Provided specifications to Sterling Software for the development of 2 translators. Participated in the testing and implementation of this system. Designed and documented pre-notification procedures for EDI customers.

CAXTON Corporation

May 1993 - January 1994
Programmer

Wrote COBOL reports for the Real World General Ledger System in a DEC/VAX environment. These reports were necessary to audit the accuracy of an interface from the outsourced trading system to the in-house general ledger.

Developed and implemented a real time investment position reporting system using COBOL and DCL. This system provided the traders and trading assistants with valid information about their open positions and with which brokers they were held. Given the volatility of the investments held in this fund, and the leveraged investment strategy, it was necessary that traders be able to react very quickly when information hit the market. This system greatly reduced their reaction time.

TRAINING

R/3 Courses Taken:

BC030

Data Dictionary

BC170

Introduction to ABAP/4

BC220

Introduction to Online Programming

BC620

EDI Configuration

JSL10

Logistics Introduction

WT520

ABAP/4 Performance Tuning

 

Other Courses:

Mercator for R/3

 

Introduction to Powerbuilder

 

pcExpress/EIS

 

 

EDUCATION

Rider University, Lawrenceville, NJ

B.S.B.A, Computer Information Systems/Finance, Summa Cum Laude
Rider Presidential Scholarship
Andrew J. Rider Scholar

LANGUAGE

English

CITIZENSHIP

United States