1. Programs to convert legacy data to JD Edwards (Address book, Inventory, Sales History & Open Sales orders, Open Accounts Receivable transactions, and Open Payable transactions.
2. Programs to load the Transportation Management System (TMS).
3. Recursive programs to read Bill of Materials.
4. Programs that generate As-400 Sql inserts on-the-fly.
5. Programs that generate oracle dB type update Sql.
6. Programs to 1) convert open PO and sales orders via 47 series process, 2) converted direct orders (SD/OD) using 47 and 43 z processes.
7. Programs to generate Oracle Sql scripts (insert statements).  Used for company consolidation processes and conversion.
8. Programs to generate Oracle Sql scripts to bump non-stock lines to invoicing status.
9. Programs to read Sterling In-flight PO’s to validate inbound EDI data vs processed EDI transactions.  Used on the World platform.
10. Programs to load inbound / outbound EDI tables and process those transactions.  Example: worked with DHL in Asia Pacific to trade EDI documents with third party DHL warehouse. Performed Setup in E1 generating outbound 850 and outbound 856 documents to 3rd party warehouse located in Asia Pacific. Performed setup for batch ship-confirm with all shipments leaving Asia Pacific; this was achieved through an inbound EDI ship confirmation document from DHL. Since DHL had limited expertise in trading x12 documents in Asia Pacific, csv files were traded instead. Developed software in .Net to manage backend process of document delivery (FTP) and translation into JD Edwards.  Developed automated checks on FTP mailboxes for new documents for purposes of automatically downloading any new transaction directly into JD Edwards.  System also monitors JD Edwards for new EDI documents headed to Asia. When new EDI transactions are encountered, system creates outbound CSV files which encapsulate the new EDI documents and bumps the EDSP flag in JD Edwards. The system then updates E1 and sends file to FTP location. Any errors encountered along the way will rollback changes to data and send automatic email to administrator(s). Customizations were made to existing proprietary .Net EDI software originally developed by Bluelotus Technologies, Inc.