Sample Projects Developed for CompUSA :

Created Inbound and Outbound IDOC userexits to support extended fields on sales orders and confirmations and to handle serial number updates from EDI vendors

Cross-Dock Allocation Application - When a large batch of product was received at a central receiving dock, it would determine the sell-through percentage and on-hand quantities of each store, and based on rules, distribute the product appropriately between the 220 stores

Developed matchcodes for Training and Events Management to decrease lookup times from many minutes to a few seconds

Led development team that created interfaces between SAP and various legacy systems

Created userexit-based (real-time) module that would create a Contract for Training Classes when certain types of Sales Orders were entered

Created transaction wrappers for Build To Order PC line to allow the line workers to use their barcode scanners to enter the data into SAP.

Sample Projects Developed for GTE :

Designed and created a generic table upload and download ABAP that will allow any table regardless of structure to be downloaded to the user's PC, and then allow an upload back to the database. This saved hundreds of man-hours of coding time for the 160+ tables that needed to be downloaded, modified, and uploaded.

Designed and created a Mass Change/Copy/Delete program for tables. Written using open SQL commands in ABAP, it allows the modification (Change, Copy, Delete) functionality for any table, selecting by key and non-key fields.

Copied FI transactions KB11 through KB31 for posting to CCA and modified them to allow multiple rates per activity based on PA characteristics derived from a customer table. Required extensive knowledge of SAPMK23B.

Designed and created a suite of transactions to hold files to be posted to PA using KE1X or KE4X. Using two tables, the files could be kept, summarized and viewed, reversed, and even re-posted. The transactions would also allow batch-processing of these files, something not possible with core functionality.

Used CMOD to create a customer exit on the Accounting drop-down menu (from the main S000 area menu) as well as to add a new screen to the login process warning that unauthorized access would be prosecuted.

Created a generic set of forms to be used by any programs created for customer table maintenance to allow quick coding for new tables as they are created. Using table controls and enhanced row-level security, these programs allowed secure table maintenance to be provided in a minimum of coding time.

September 1994 - October 1996. Contracted full-time to FoxMeyer, Inc., Carrollton, TX. Began as integral part of SD implementation team, worked on FI/MM production support team, and later on the Split SD implementation team. Extensive use of ABAP coding including screen painter, menu creation, transaction creation, core modifications and drill-down reporting. Utilized standard interface loads to bring in material movements from other systems and wrote custom loads for EDI incoming invoices and EDI auto-replenishment purchase orders. Gained in-depth knowledge of SD, MM, and FI modules as well as interfacing between SAP and other systems such as Unisys, WMS, and IBM.

Sample Projects Developed for FoxMeyer :

Analyzed and designed full EDI implementation of inbound Sales Orders and outbound Sales Order Confirmations according to FoxMeyer requirements.

EDI Incoming Invoice Interface : wrote code and BDC sessions to decode incoming vendor invoices and call transactions to create SAP Vendor Invoices. Handled 3000 transactions (around $20 million) daily.

Created upload program from Microsoft Excel for Windows to SAP general ledger. Created Excel macro and button so that the user could load in a spreadsheet of charges for closing and with the press of a button export that data to a text file. In SAP, created a transaction that would read that data in and using a standard load, generate the desired G/L entries. Saved 5000 manually posted transactions per month.

Created price sticker print routines called by output condition types of created customer invoices. Created table-driven routines to allow customer-defined price sticker layouts. (Each customer could design their own price sticker using full-screen layout and preview transaction).

Stock Status Report for Transfer Order In-Transit Stock. Gave values of transfer order stock in transit between warehouses showing differences in departure and arrival prices.

Created Vendor Replenishment Purchase Order number range screens for EDI auto-replenishment purchase orders.

Modified core Spool Output Controller transaction to allow mass selection of documents to print based on paper types.

Critical team member on upgrade from Release 2.1G to 2.1J. Many re-applications of core modifications required across all modules.

Coded AutoSubstitution logic added to release 2.1J SD Sales Order processing to allow a customer to receive alternate products if their chosen product was out of stock, or if a more preferred product had been established based on rule tables.

Integral part of Split SD team, which split the SD functionality of SAP onto a separate machine from the MM/FI functionality. Designed and coded RFC interfaces for tables that had to be remotely accessed across instances. Also responsible for migrations and transports between environments.

July 1992 - September 1994. Information Systems Coordinator, ICI Explosives. Modified, debugged, and created new ABAP/4 reports to satisfy a wide range of user needs. Acted as a primary contact for SAP R/2 technical problems. Responsible for all DB2 reporting on SAP databases using SQL, Administered Novell Netware 3.11 file server and acted as project manager for implementing 2 additional local area networks to be interconnected into their North American network. Responsible for all PC hardware and software maintenance, evaluation and recommendation of software upgrades and enhancements.

May 1990 - July 1992. Systems Administrator, ICI Explosives USA, Inc. (formerly Atlas Powder Company). Duties included VAX System programming in DCL and VAX Pascal, telecommunication troubleshooting and repair of Codex 6745-series multiplexers with 800 service rotored phone lines and leased lines to remote sites, VAX system security and ALLIN1 maintenance.

November 1986 - May 1990. Lead VAX Programmer/System Analyst, UNT Computing Center. Duties included systems management, overseeing three VAX programmer/operators, performance monitoring, and scheduling.

October 1987 - April 1988. Co-owner of MicroProfessionals, a contract programming and consulting company. Projects included database management systems, inventory control systems, and shipping and billing systems.