William Steiner (AS/400 Consultant) - RESUME

2512 W. Sibley Street

Park Ridge, IL 60068

Phone: (847) 698-6513, Email: wmstein@usa.net, Web page: www.billsteiner.com

MBA/MIS from Illinois Benedictine College.

B.S. Business Administration from The Citadel - Military College of South Carolina.

Independent Consultant – EDI consulting/AS400 programming (GENTRAN, RPG IV) – 03/99 to current.

Wilson Sporting Goods - Corporate EDI Coordinator (GENTRAN, COBOL) - 01/95 to 03/99.

- Racquet Div. EDI Specialist (GENTRAN, COBOL) - 11/92 to 01/95.

Baxter Healthcare, Inc. - Project Leader (RPG) - 02/90 to 11/92.

- Senior Analyst (RPG) - 09/89 to 02/90.

New Resources/Independent - S/3X & AS400 Technical Consultant (RPG) - 11/88 to 9/89.

Interactive Software Services - S/38 Programmer Analyst (RPG) - 08/87 to 11/88.

First person to pilot and implement the EDI 215 transaction set with UPS. Implemented and supported 20 unique EDI transaction sets for over 60 Trading Partners at Wilson Sporting Goods (versions 3010 – 4010).

Member of the Baxter Quality Working Group to help implement the electronic transmission and payment of subsidiary invoices.

Member of the Baxter Global Network Project to define and implement corporate worldwide Network and EDI standards. Sysop in charge of the Baxter Export Corporation's Bulletin Board System (BBS).

Wrote an article on Technical Interviewing Techniques that appeared in the September 1989 issue of System/3X & ASWORLD magazine - a major publication in the 3X industry.

Created and programmed inbound documents: 856, 944, 864, 810, 816, 852, 830. Outbound documents: 944, 810, 850. Created an internal EDI infrastructure and VAN (value added network) to trade EDI documents within the internal companies. Continued developing EDI programs using SQL and RPGLE.

Created inbound 860 PO change, inbound and outbound 856 ASN, inbound 864, 942 and 810, and outbound 940 EDI maps and interface applications.

Designed and implemented a warehouse system to provide the ability to receive product, select orders for picking and shipping, print shipping labels and bar codes, and update ERP system. Applications will print pick ticket, adjust inventory, create an EDI 856 ASN, and print UCC128 bar codes via interface to the T.L. Ashford Bar Code software application. Application is Web browser capable and can be used via the internet with any Web browser or via a modem using IBM client access.

Designed and implemented EDI 823 Lock Box transaction map and RPGIV applications to pull electronic check receipts from the bank and apply to A/R.

Designed and implemented EDI 856 Advanced Ship Notices for all partners to include Kmart, Target, and Ace. All programming was performed in RPGIV interfacing to HFA and Gentran applications. Support, maintenance and redesign for other transaction sets include 810, 850, 864, 940, 942, and 996.

Re-wrote (RPGIV) the EDI PO process to use common transaction and application maps to save countless hours of maintenance of over 100 Partner specific maps. Generic maps allow one map to be used for each transaction set for all Partners instead of i.e. 100 maps for your 100 partners. New system utilized a generic EDI Business Rules methodology to replace all Trading Partner hard coded logic in GENTRAN maps, applications, tables, exit programs, and interface programs. Enhanced just-in-time 869/870 applications. Enhanced ASN application to accommodate a real-time ASN process.

Created RPGIV applications and utilities to support day-to-day EDI functions and operations. Maintained EDI RPGIII applications. Negotiated new EDI Vendor contract to cut EDI transmission costs by 50%, and consolidated EDI transmission data to increase volume cost savings. Extensive subfile programming was involved for all projects.

Designed and coded (COBOL) the AS400 interface to Wilson’s Internet Web based ordering system at www.wilsonsuperstore.com/cgi-bin/WilsonSuperStore.storefront.

Designed and coded the "Office Supply Inventory & Account Tracking System" for Office Services Dept. and the "Forecast Trend Analysis System" for Corp. using VISUAL BASIC 6.0.

The first person, globally, to pilot and implement the 215 (Motor Carrier Pick-up Manifest) for UPS. Designed, coded and implemented the following projects: a) JIT (Just in Time) with JCPenney, b) JIT with Woolworth (including Footlocker, Lady Footlocker, and Champs), c) UPC Catalog. Languages used: COBOL and RPG IV.

Designed, coded (COBOL), and implemented the following projects: a) AAFES VMI (vendor managed inventory), b) Consolidated invoice system for Spiegel c) Kmart KICS (Kmart Inventory Control System), d) Kmart JIT e) Implemented NetSoft for Windows95, f) RPS Ship Notices (204) and Invoice/Freight Details (210). In addition to bringing up multiple new EDI transaction sets, I negotiated a new VAN contract with Sterling Software to save Wilson almost $50,000 a year.

Took charge of EDI for all of Wilson at the corporate level. Designed, coded, and implemented an entire new EDI system utilizing COBOL to be extremely flexible and more modular. Due to efficiencies and lack of redundant coding at the divisional level, EDI inbound processing time decreased tenfold.

Designed and implemented the following COBOL projects: a) Kmart PIMF system (a vendor managed inventory system), b) Kmart PIN (Partner Information Network), c) Invoice archival to CD ROM, d) added the top 20 customers to the EDI system for Purchase Orders, Invoices, Advanced Ship notices, and over a dozen other transaction sets. Visual Basic Projects included: a) USPTA Tennis Questionnaire, b) GUI application to view AS/400 Fill Rate data via Windows95.

Designed and programmed interface to Federal Express to retrieve flight and status details for packages shipped overseas. IBM's EDI ExpEDIte software was used to access Fed Ex data on the IIN network. PC and AS400 RPG programs were written to retrieve and display the data via an inquiry screen for oversea users to access.

Designed, programmed, and implemented the first EDI document at Baxter Global Businesses utilizing RPG/400. Document received was the X12 856 Ship Notice. Implemented an outbound EDIFACT Invoice transaction set.

Created AS400 RPG and PC programs that would electronically transmit current month's account receivables to a major bank for funds processing. When the invoices matured and funds transferred, a file would be electronically received and processed on the AS400 to create transaction history records and update A/R files for invoices paid.

Created RFQ (Request for Quote) system in RPGIII. Sysop in charge a PC BBS (Bulletin Board System) to allow Baxter forwarders to dial in and download/upload data. Maintain and support Purchasing System. Programmed and assisted in the design of the "Global Data Exchange" project.

Technical Consultant involved in a COBOL conversion project from a Data General main frame to an IBM AS/400 (COBOL, and CL).

CONSULTING - Bruning - Graphics Products Manufacturing Firm (1989).

Technical Consultant involved in change control on Machine Tracking, Inventory Control, Accounts Receivables, Order Entry, and Product Maintenance (RPG III, CL, PC, and SEQUEL).

Angelfire - Easiest Free Home Pages