James Clarke Shoffit
Irving, TX
| Objective | Seeking a challenging programming/analyst position specializing in SAP R/3 implementation or development, utilizing the diversity of my knowledge of various R/3 modules and ABAP/4. |
| Education | Bachelor of Science in Computer Science, Minor in Mathematics. Graduated Cum Laude, May 1990 (GPA 3.71/4.00) |
| Honors |
University of North Texas Dean's
List, 1986-1990. National Dean's List for Fall 1988 |
| Expertise | Coding, debugging, screen painting, CUA and menu painting, transaction and module pool creation and core modification; domain, data element, table, and index maintenance; performance tuning on high-volume applications; correction and transport utilities, user profile and authorization object maintenance; EDI, ALE, Workflow and IDOC experience; basis and system administration; extensive knowledge of internals of SAPMV45A, SAPMV60A, SAPMK23B, and others; HTML using tables, forms, cgi scripting, Java. |
| Experience |
January 1999 - August
2000. Contracted full-time to CompUSA, Inc., Dallas, TX. Led team
that developed Functional Specifications for interfaces and conversions.
Led ABAP development teams as well as doing ABAP development work for various
groups. 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. |
| Programming Languages | Fluency in ABAP/4, SQL, C, Pascal, DCL, DBASE III+ (Clipper or FoxPro), and 80x86 Assembler. |
| Environments | Microsoft Windows 3.1 and 95, Unix (many releases), MSDOS (through DOS 6.2), VAX/VMS. |
References Available Upon
Request