SUMMARY:

• Decisive leader with over 33 years IT and EDI experience in manufacturing and distribution environments.
• Proven organizational, analytical and research skills.
• Thrive in providing excellent customer service to external and internal clients and developing a friendly work environment.

TECHNICAL SKILLS:

Operating Systems: OS/400(I Series), OS/36, OS/34

Languages: RPGII, RPGIII, RPG IV, ILE, DB2, SQL, CL, CLLE, FTP,AS2 Sub file processing

Software: PKMS, TL Ashford, GSX (Harbinger, Peregrine, Inovis) Hawkeye/Pathfinder, Crystal Reports, DBU, Query 400.

Microsoft Office Products: (Word, Excel, Power Point)

Tools: SDA, SEU, WSU, DFU, DBU, AS/400 Journaling, Query 400, XML

Full - cycle Application Development of ERP Systems: WMS Inventory Control, Forecasting, Production Planning, Purchasing OE, EDI, GL, Cost Accounting, A/P, A/R, Bar Coding, Data Synch, BOM, BOL, Imports

Project Management: Departmental Employee Selection, Hiring, and Performance Management, Program Standards

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Programmer Analyst

• Rewrote order processing application to support influx of EDI data.
• Multiple Sub file processes with prompt lookups
• Inter active feed of data to inventory management/Forecast system and third party shipping software (PkMS)
• Charge card processing for consumer based orders
• Project Manager for Y2K data conversion and application enhancements
• Project Manager for Implementation of Manhattans warehouse management software (outbound module)
• Created returns authorization application to track product returns and condition of product
• Automation of Production Work order for inventory management. Includes bar coding of production information that can be scanned when product is move to warehouse location to increase quantity availability and usage for raw materials.
• Developed Physical inventory system for yearly reconciliation of inventory
• Automated Payroll download from ADP data to companies General Ledger System
• Maintained and supported current General Ledger Application
• Automated journal entry transactions from Accounts Payables
• Modified System to be able to re - open and close the period for audit adjustments
• Accounts Receivable rewrite from Systems 34 environment to RPGLE in DB2
• Integrated EDI documents to accounts receivable (820 Remit advice documents)
• Accounts Payable modifications - integrated 210 Freight invoice for automatic post to payables if passed processing checks, if not transaction was suspended
• Implemented TL Ashford Bar Code software to support UPC, GTIN, SSCC18, MH10 barcode labeling
• Series of operating systems upgrade on the I Series
• Included third party software upgrades to comply with new operating system
• Conversions from Systems 34 to System 36 to AS400 (I Series )
• Managed Setup of newly acquired Companies
• Set up new company in current system
• Data migration from multiple sources

Confidential

EDI Manager

• Installed EDI Translator Software - Harbinger (bought by several companies, INOVIS, GXS) Product on the I Series is the Biz Manager 400 Trusted Link product line (Gentran competitor)
• Designed database to map EDI transactions in DB2 Database setup/Maintain Trading Partners relationships
• Communications profile, Document profile setup
• Map EDI transactions to EDI database both inbound and outbound transactions
• Developed processing rules for the EDI transaction to create records into ERP systems (i.e. Order Entry(850,860,865, 885 documents), Accounts Receivable(820, 810 documents), Accounts Payable (210 document)
• Implemented Advanced Ship Notice (856 documents) for Brinkman to meet compliancy requirements for Major Retailers (Home Depot, Walmart, Costco) to name just a few.
• Consumer Based Order processing from Sequel Server Database to the above database to the, I series (AS400). The data was then processed via the above EDI processing for the 850 document.
• Created processing functions and database for Home Depot consumer based order processing using XML documents which was then funneled through EDI process.
• Work with companies departmental representatives to ensure EDI documents process successfully and to identify any new transaction requirements
• Performed several migrations for the above software
• From server based communications to I Series
• Communications protocols AS2, FTP, VAN Services Secure AS2 (SSL)
• Performed several migrations to support newest version for above software package currently on version 6.3
• Performed migration of green screen mapper to GUI Visual mapper
• Flow charted and documented EDI Process flow as well as any technical requirements needed
• Implemented Shipping Warehouse Management software PKMS (Manhattan Assoc.)
• Included implementation of bar coding and generation of 856 ASN data to EDI system
• Order processing data bridge to and from PKMS
• Cubing for Freight Routing
• Integrated 940 Warehouse order document from order entry to Freight Forwarder (Expeditors) for processing shipping an 850 on behalf of our company which generated an 856 document.
• Created process to send the 856 document from the Freight Forwarder to our trading partner then relieve inventory and bill order automatically.
• Implemented TL Ashford Bar Code software to support UPC, GTIN, SSCC18, MH10 etc.. bar code labeling
• Series of operating systems upgrade on the I Series
• Included third party software upgrades to comply with new operating system
• Conversions from Systems 34 to System 36 to AS400 (I series )
• Managed Setup of newly acquired Companies
• Set up new company in current system
• Data migration from multiple sources

Confidential, Carrollton, Texas

Sr. Programmer Analyst/EDI Specialist

• Installation of EDI software package - Harbinger Product

Confidential, Arlington, Texas

Contract Assignment

• Intergraded and automate the 850 document into order entry and generate the 810 documentMap documents into EDI