SUMMARY OF QUALIFICATIONS

• 32 years computer industry experience
• Extensive background in the IBM mainframe with expertise in Sterling Commerce Gentran EDI for 11 years, DB2, SQL, COBOL, VSAM, CICS, RPG, Natural/Adabas.
• EDI experience using Inovis (Harbinger) TLE Trusted Link software on the mainframe, Windows NT, Unix, and iSeries/AS400.
• SAP IDOC’s
• Experience using MS Access and SQL server
• Duties included tasks throughout the entire life cycle including requirements definition, analysis, design, coding, testing, implementation, and support.

EXPERIENCE

Confidential, April 2010 – current Confidential, WI EDI Consultant

• Modify, test, and implement 130+ existing Inovis TLE maps to accommodate the GLN Global Location Number. The EDI transactions included are the 850/875 purchase order, 855 purchase order acknowledgment, 810/880 invoice, and the 856 advanced ship notice. The SAP Idoc’s included are the ORDERS, ORDERSP, INVOICE, DELVRY and the DESADV.
• Environment Unix, Inovis TLE, Word, Excel, Lotus Notes, FTP, MKS, UltraEdit

Confidential, June 2009 – April 2010 Confidential,Des Plaines, IL EDI Consultant

• Support and enhance the EDI applications including the 850 purchase order, 852 product activity data, 860 purchase order change, 861 receiving advice, and 867 product transfer. Support and enhance the handshake between EDI and the applications.
• Environment Mainframe, AS400, Gentran, Cobol, Easytrieve, VSAM, JCL, TSO/ISPF, Word, Excel, Visio, Lotus Notes, VSAM, FTP

Confidential, January 2009 – April 2009 Confidential,Edina, MN

EDI Specialist

• Created mapping design specifications for interfacing between the internal DB2/400 internal user files and the SPS Saint Paul Software SIP flat file format. Lead the testing with SPS Saint Paul Software. The transaction sets implemented include the 810, 812, 820, 824, 830, 850, 853, 855, 856, 860, 861, 862, 864, 870, DELFOR, DELJIT, RECADV, and DESADV for approximately 75 trading partners and 150 trading partner transactions.
• Environment iSeries/AS400, Trusted Link TLE/400, DB2/400, RPG400/ILE400, Word, Excel, Visio

Confidential, January 2006 – January 2009 Confidential,Edina, MN

EDI Analyst and Data Architect

• EDI analyst/developer within Finance IT for the Pharmacy A/R system. Performed the entire life cycle including analysis, design, coding, testing, and implementing the EDI 835 Health Care Payment transaction transitioning from a 3rd party.
• Data Modeler within Finance IT for the Vendor Income Processing system. Developed the data model for the re-engineering of the Automated Vendor Income system.
• Environment Mainframe, Cobol, DB2, Easytrieve, Erwin, JCL, TSO/ISPF, Access, Word, Excel, Outlook, Visio, Endevor, VSAM, FTP

Confidential, June 2005 – December 2005 Confidential,Minneapolis, MN

EDI Support

• EDI support for the PowerTrack system including the 110 air carrier freight details and invoice, 210 motor carrier freight details and invoice, 214 shipment status, 310 ocean invoice, 315 shipment status (ocean), 810 invoice, 850 purchase order, 858 shipping information, and 859 freight invoice,
• Certified EDI transaction sets including the 310 ocean invoice, 810 invoice, and 850 purchase order.
• Environment SQL Server, Mercator 6.7, Word, Excel, Lotus Notes

Confidential, February 2004 – June 2005 Confidential,Minneapolis, MN

EDI Developer

• Converted the EDI processing from the mainframe to the Unix.
• Designed, Implemented and supported transportation EDI transactions sets including 214 carrier shipment status, and warehouse transaction sets including the 940 warehouse order, 943 shipping advice, 945 ship confirmation, 944 receiving advice, 846 inventory inquiry, 947 inventory adjustment, and 812 credit/debit adjustment, 864 text message, along with other miscellaneous transaction sets.
• Environment Mainframe, Unix, Inovis (Harbinger) Trusted Link EDI software, SQL, Cobol, CICS, Easytrieve, VSAM, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes

Confidential, November 2003 – February 2004 Confidential,Bloomington , MN

EDI Developer

• Implemented claims insurance EDI transactions sets including 148 injury report, 837 health care claim, 835 healthcare payment, 272 loss notification, 811 consolidated invoice, 820 remittance advice, along with other miscellaneous transaction sets.
• Environment Mainframe, Gentran EDI software, JCL, TSO/ISPF, Word, Excel, Lotus Notes

Confidential, March 2003 – November 2003 Confidential,Minneapolis, MN

EDI Developer

• Designed, Implemented and supported warehouse EDI transactions sets including 940 warehouse order, 943 shipping advice, 945 ship confirmation, 944 receiving advice, 846 inventory inquiry, along with other miscellaneous transaction sets.
• Implemented and supported EDI auction transaction sets including the 850 purchase order, 860 purchase order change, 855 purchase order acknowledgment, 861 receipt, and 810 invoice.
• Environment Mainframe, Unix, Inovis (Harbinger) EDI software, SQL, Cobol, VSAM, Easytrieve, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes

Confidential, 1994-2003 Confidential,Edina, MN

EDI and Mainframe Developer

• Designed, Implemented and supported EDI transactions sets including 850/875 purchase orders, 810/880 invoices, 820 remittance advice, 856 advanced ship notices, vendor managed inventory and point of sale transactions including the 852 product activity data, 830 planning schedule, and 867 product transfer and sales report, along with other miscellaneous transaction sets including 824 application advice, and 864 text messages.
• Designed, developed and maintained departmental Microsoft Access databases including status reporting for project tracking, time reporting, and recharge, EDI gateway metrics, incident reporting, advance ship notice reporting, and purchase order metrics, and survey databases.
• Environment Mainframe, Sterling Commerce Gentran, DB2, Cobol, VSAM, MS Access, SQL, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes, VSAM, FTP

Confidential, 1990-1994

Confidential,Minneapolis, MN Mainframe Developer

• Designed and developed an event driven EDI system for Matsushita, on-line pharmaceutical subsystem for UHC, membership system for CSAA, country profile system for UPS, and a fixed asset accounting system for NSP.
• Environment Mainframe, DB2, Cobol, CICS, VSAM, SQL, Natural/Adabas, Easytrieve, JCL, TSO/ISPF, Word, Excel, Lotus Notes

Confidential,Eden Prairie, MN 1986-1990 and 1984

Senior Programmer Analyst

• Designed, developed, and maintained subsystems including accounting, order entry, production control, purchasing, and engineering.
• Environment Mainframe, Natural/Adabas, JCL, TSO/ISPF, Word, Excel

Confidential,Minneapolis, MN 1985

Systems Analyst

• Developed an apparel business system and converted from the mainframe to the AS400.
• Environment Mainframe, AS400, Cobol, VSAM, Natural/Adabas, RPG, JCL, TSO/ISPF

Confidential,Eden Prairie, MN 1980-1984

Programmer/Analyst

• Converted from the IBM System 3 to the mainframe.
• Designed and developed manufacturing subsystems for accounting, production control, engineering, and order entry.
• Environment Mainframe, CICS, Cobol, VSAM, RPG, JCL, TSO/ISPF

Confidential,St. Paul, MN 1978-1980

Programmer/Analyst

• Modified Cobol applications for the maintenance team.
• Environment Mainframe, Cobol, JCL
• EDUCATION
• Bachelor of Science degree in computer science and mathematics.

SKILLSET SUMMARY

Mainframe 25 years
TSO/ISPF 25 years
JCL 25 years
Word 15 years
Excel 15 years
Gentran EDI 11 years
Lotus Notes 10 years
Cobol 9 years
Natural/Adabas 8 years
DB2 6 years
SQL 6 years
VSAM 6 years
CICS 5 years
AS400 5 years
RPG2 5 years
Visio 4 years
Trusted Link EDI 3 years
Access 3 years
Outlook 3 years
Unix 2 years
EDISIM 2 years
Easytrieve 2 years
FTP 2 years
Endevor 2 years
RPG400 1 year
Erwin 1 year
iSeries 1 year

EDI TRANSACTION SETS

148 Injury Report
110 Air Carrier Freight Details and Invoice
210 Motor Carrier Freight Details and Invoice
214 Carrier Shipment Status
272 Lost Notification
310 Ocean Invoice
315 Shipment Status (Ocean)
810/880 Invoice
811 Consolidated Invoice
812 Credit / Debit Adjustment
820 Remittance Advice
823 Lockbox
824 Application Advice
830 Planning Schedule
835 Healthcare Payment
837 Healthcare Claim
846 Inventory Inquiry
850/875 Purchase Order
852 Product Activity Data
853 Routing and Carrier Instructions
855 Purchase Order Acknowledgment
856 ASN
858 Shipping Information
859 Freight Invoice
860 Purchase Order Change
861 Receipt
862 Shipping Schedule
864 Text Message
867 Product Transfer Report
870 Order Status Report
940 Warehouse Order
943 Shipping Advice
944 Receiving Advice
945 Ship Confirmation
947 Inventory Adjustment
DELFOR Delivery Forecast
DELJIT Delivery Just-In-Time
DESADV Despatch Advice
RECADV Receiving Advice

SAP IDOC’S

ORDERS
ORDERSP
INVOICE
DELVRY
DESADV