www.HowardPowers.com
Resume addendum: Paperless Invoice Processing System
Overview:
Primary (and only) baseline maintenance support for Mobil's Paperless Invoice Processing system (PIP). This mission critical system (IEF/DB2) processes 14 to 16 thousand incoming electronic invoices (EDI X12 - 810) per month with a total valuation of up to $70 million. The system automatically approves most of these invoices for payment with out human intervention. PIP protects 279 accounts payable users. It contains two business systems, a daily batch system for processing incoming invoices and an IMS on-line system for invoice review and table maintenance. My job is to insure that the system runs smoothly. I assumed this responsibility in March of 1997, prior to that (December 1996 through February 1997) I assisted in that task. The system has no corporate champion and competes with a Mobil system that has a strategically placed corporate champion.
Specific PIP responsibilities:
As model owner, my responsibilities include requirements definition, subset maintenance, downloads, coding changes, uploads, compiles, testing and migration through development, acceptance and production (TSO and IMS) environments. (Since I am solely responsible for the system, version control is not a problem.) I am also responsible for responding to user requests for logic clarification (i.e. How does PIP increment voucher numbers for Marketing) and user data requests (i.e. Can I have a list of active procurement cards for the Beaumont Refinery with the associated cost centers and tax treatments) More recently, I have been engaged in providing information, mostly in the form business rule extraction from the code (i.e. What verifications are performed for electronic travel and expense reimbursement requests) and in the form of ad-hoc QMF queries against multiple DB2 tables (i.e. Can you tell me how many invoices by vendor contain a 'C' in the two bite EDI invoice type field.) to the SAP team. I also monitor the batch audit routines daily to insure that (non abend) production problems are addressed quickly.
Major tasks:
- Developed test plan and script, conducted system test and coordinated acceptance testing on modifications (performed by my predecessor) which required re-testing of virtually all of the batch and on line systems
- Manually executed the appropriate batch routines daily in the acceptance test region for several weeks to provide parallel testing on live data for the above modifications
- Added active/inactive error checking for the account handles and vendors for incoming invoices.
- Corrected problems on transfers of credit invoices to the petro-chemicals division SAP. This fix required changes at both action diagram and external level.
- Extended the audit routines to include checks on transfers to the petro-chemicals division. This fix required new procs and externals.
- Modified the system to allow processing of very large credit card invoices under contract to Tenneco. The system was designed to allow this type of invoice but these invoices stressed the system beyond tested limits (including the only production abend I have had) Changes included modification of a data item used as a foreign key in all invoice related tables from pic 9(3) to pic 9(4). This resulted in regenerating all action diagrams using invoice related views. The effort also included spufi's to correct foreign keys in production data bases and new methods to load group views in the on line system. Error messages were modified to provide more useful information on very large invoices.
- Added data and process checks to prevent abends in downstream systems.
- Identified and partially fixed problems in the invoice archive routines.
- Documented the very complex table and foreign key structure required to store EDI - 810 invoices.
03/18/98 Howard Powers
Page hits since 12/05/2000