DAVID
P. CAWLEY
2246
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:
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
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
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 recipients 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
B.S.B.A, Computer
Information Systems/Finance, Summa Cum Laude
Rider Presidential Scholarship
LANGUAGE
English