We provide IT Staff Augmentation Services!

Edi Analyst/programmer Resume

Chicago, IL

SUMMARY Over 15 years of experience in the design and maintenance of business, manufacturing and E-commerce applications. Skills include analysis, design, development, implementation, migration, testing, documentation, training, and user support, software installation and upgrades.

HARDWARE IBM AS/400 (15+ yrs.), IBM Mainframe, IBM compatible PCs.

LANGUAGES RPG ILE, RPG Free, RPG/IV/400/III/II (15 + years), COBOL400.

SOFTWARE IBM AS/400: EDI Mapping and Translation: (Future 3/Infor Global, TrustedLink (Inovis), and GENTRAN. ERP/MRP: (JD Edwards, MAPICS, GEAC/JBA, BPICS). IBM UTILITIES (DBU, PDM, DFU, SDA, SEU, Query/400 and SQL). CHANGE MANAGEMENT (Hawkeye Pathfinder, Softlanding/Turnover). OPERATING SYSTEMS: (OS/400, Windows 2000, NT and XP). Micrsoft applications (Excel, Word, Exchange, Internet Explorer, Outlook and Access). Other PC applications (Visio, Lotus Notes).

APPLICATIONS Financial Accounts Payable, Accounts Receivable, General Ledger. Automotive/Manufacturing EDI, (X.12, EDIFACT, and ODETTE). Worked with numerous inbound/outbound transaction sets (856, 810, 820, 861, 862, DELFOR, DESADV, etc.) and numerous OEM's and trading partners. Automotive release accounting, Distribution Requirements Planning, Inventory. Medical: Billing, Pharmacy, On Line Patient Admissions, Clinical Functions, and Home Health Care.

EDUCATIONAssociate Degree, Data Processing Technology, University of Toledo Community Technical College.

PROFESSIONAL EXPERIENCE

09/2010 - 11/2010: EDI Analyst/Programmer (CONTRACT) Confidential. Chicago, IL

  • Completed project to create custom EDI monitoring reports (out bound document acknowledgement status, Inbound document exeptions, daily inbound document reports, trading partner activity reports, etc.).
  • Implemented the following transaction sets 812 (Debit/Credit memo), 820 (Remittance Advice), and 860 (Purchase Order Change request. Created custom RPG programs, reports and email functionality for each of the documents listed. Modified and/or created the TrustedLink EDI mapping and user file definitions for each. Document were implemented for the following RETAIL customers: SEARS, ACE Hardware, Hanover Direct and Dillard's Dept. Stores.
  • Completed modification of custom order processing programs, as well as modification of the main 'offline' (EDI) APLUS2 order processing program OE130.Creation of AS400 queries to list EDI statuses, EDI errors and other miscellaneous EDI related information.
  • Environment: AS400 RPG III and RPGILE (programming0, APLUS2 ERP/MRP Software, Trustedlink/Inovis (version 6.3.1) EDI mapping/communication/translation software, AS400 native job scheduler.

06/2010 - 08/2010: EDI Analyst/Programmer (CONTRACTConfidential, Detroit, MI

  • Completed project to implement Jaguar/Landrover EDI migration from Ford. Creation of TrustedLink (Inovis) maps, and user file definitions, and trading partner relationships. Creation of custom RPGLE and CLLE programs to interface with BPCS ECM and ECA modules. BPCS setup and configuration.
  • Environment: BPCS ERP/MRP (version 8.2.01), Trustedlink /Inovis(version 6.2.1) mapping/communication/translation software, Hawkeye change management software.

12/2006 - 07/2010: EDI Analyst/Developer, Confidential. South Bend, IN.

  • Administer, and maintain GENTRAN Server for the AS/400 EDI application software (version 3.3). Monitor daily EDI transactions involving 4 business divisions (warehouses) in the U.S. and Canada and over 100 Customer/Vendor trading partners. Resolution of issues related to EDI communications with numerous VAN networks and exchanges (COVISINT, ANX, Sterling, GXS, Advantis, iConnect, PARTnerShip Sever, AS2/EDIINT, etc.). Modify, maintain and create EDI maps and trading partner relationships as necessary.
  • Resolve issues related to interfaces from GENTRAN to J. D. Edwards Sales Order Processing/ERP software.
  • Modify and design RPG programs dealing with J. D. Edwards's files and processes. Modify and create J.D. Edwards DreamWriter versions (P42520, P47032. P47012 etc.). Modify JDE order creation pgm. (P47011), work with inventory processing programs. Modify JDE bill to, Shipto (customer) and Vendor address bookentries , resolution of ITEM X-reference and vendor/item relation ships issues, working with interfaces (RPG) between JDE Forecasting and custom written forecasting process , work on interfaces between EDI 820 files and JDE One World Financials.
  • Work with internal user departments and external customers (Advanced Auto, AutoZone, CARQUEST, Ford, Chrysler, GM, Toyota, HONDA, Wal-Mart, Lowe's, Sears, K-Mart, Amazon, etc.) as well as suppliers to investigate and resolve complex EDI issues.
  • EDI Specifications - Development and modification of Robert Bosch 's Aftermarket EDI specifications for vendors. Specs created using the EDISIM(r) spec creation application. Specific documents: 830 (planning schedule), 850 (P.O.) and 856 (ASN).
  • Automotive Release Processing and CUM base tracking system (custom written). Resolve discrepancies between custom Automotive release system and the ERP/Vendor release systems of external customers. Modify RPG programs and interfaces between this module and JD Edwards.
  • Environment: Aftermarket/Service automotive Supplier. IBM AS/400, RPG/400, and RPG ILE (programming languages). GENTRAN400 (EDI mapping/translation software package), DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). J.D. Edwards (World) Sale Order Processing/ERP application software (version 7.3). AXWAY AS2 Software (Internet EDI, EDIINT), Novell network, Microsoft Exchange mail server, ROBOT AS/400 job scheduler, Implementer change management software, FORESIGHT (EDISIM) for creation of EDI guidelines.

05/2005 - 12/2006: EDI Analyst/Programmer , Confidential, Rochester Hills, MI.

  • Administer, and maintain GENTRAN Server for the AS/400 EDI application software (version 3.0). Monitor daily transactions involving 7 business divisions (plants) in the U.S. and Canada and over 100 trading partners. Resolution of issues related to EDI communications with numerous VAN networks and exchanges (COVISINT, ANX, Sterling, GXS, Advantis, iConnect, PARTnerShip Sever, etc.).
  • Modify, maintain and create EDI maps and trading partner relationships as necessary.
  • Resolve issues related to interfaces from GENTRAN to the C.O.I.N. (Customer Ordering and Invoicing) custom written Sales Order Processing, ERP and MRP system.
  • Design , modify and create RPGIII, RPG ILE and RPG Free programs for the MRP, Sales Order Processing and EDI systems.
  • Work with internal users and departments, external customers (Ford, Daimler/Chrysler, GM, Toyota, HONDA, etc.) as well as suppliers to investigate and resolve complex EDI issues.
  • Environment: Automotive Supplier. IBM AS/400, RPG/400, and RPG ILE and RPG Free (programming languages). GENTRAN for the Iseries (EDI mapping/translation/communication software package), DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). TL Ashford barcode software, custom written MRP manufacturing application software. Novell network, Lotus Notes mail server, ROBOT AS/400 job scheduler, Aldon change management software, Broderick software (email, spoolfile control, etc.).

08/2004 - 05/2005: Contract EDI Analyst/Programmer , Confidential, Columbus, Ohio

  • Administer, and maintain TrustedLink/400 EDI application software (install PTF's, issue resolution, etc.). Monitor daily transactions involving 3 business divisions and over 100 trading partners. Resolution of issues related to EDI communications with numerous VAN networks (GEIS, Sterling, etc.).
  • Modify, maintain and create EDI maps and trading partner relationships as necessary.
  • Resolve issues related to interfaces from Trusted Link software to the following ERP packages: JD Edwards and SAP R/3. Interface programs are written in RPG on the AS/400.
  • Monitor and modify the interfaces to and from SAP system to the AS/400 (TL400 and custom written FTP programs) . Interfaces use the following IDOC types: SHPMNT03, DLVRY03 and ORDERS02.
  • Work with internal Customer Care department and external Customer EDI personnel to resolve issues relating to incoming EDI orders (850/875), and outgoing invoices, and shipping notices (810/856).
  • Troubleshoot issues relating to the JD Edwards order processing system. Modify JD Edwards invoicing and order processing RPG programs.
  • Work with and modify JDE dreamwriters (and world writers) related to invoice printing/processing.
  • Modify and create RPG and CL programs interfacing according to user requirements and technical specifications.
  • Environment: Manufacture of Consumer Adhesives (home improvement/DIY products and office supplies) and industrial adhesives (for the automotive industry). IBM AS/400, RPG/400, and RPG ILE (programming languages). TRUSTEDLINK 400 (EDI mapping/translation software package), and SAP IDOCS (EDI interface), DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). JD Edwards, v. 8.12 and SAP v. R/3, (ERP/MRP manufacturing application software). Novell network, Lotus Notes mail server, ROBOT (AS/400 job scheduler).

04/2004 - 08/2004: EDI Programmer/Analyst, Confidential.

  • Administer and maintain Future III EDI application software (install PTF's, issue resolution, etc.).
  • Write and modify custom software (RPG ILE) interfacing with MAPICS and Future III software.
  • Troubleshoot and resolve all technical and functional issues involving EDI interaction with a automotive trading partners (Honda, Toyota, Chrysler, Ford, etc.)
  • Troubleshoot and resolve all technical and functional issues involving interfaces between Future III software and MAPICS ERP/MRP software, including working with F3's Configurable Interface Tool.
  • Environment: Tier One Automotive supplier. IBM AS/400, RPG/400, RPG ILE and RPG Free (programming languages). FUTURE 3 (EDI mapping/translation/Automotive release accounting), DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). MAPICS/XA (ERP/MRP manufacturing application software). TrustedLink 400/Harbinger/Peregrine) EDI translation/mapping software. Novell network, Lotus Notes mail server, FTP ANX (communication with Mercedes Benz/Chrysler and Ford), EDS*Eilte (General Motors), Various vans (GEIS, Advantis, Toyota Direct). ROBOT job scheduler

08/2003 - 04/2004: EDI APPLICATION DEVELOPER, Confidential, Troy, MI.

  • Analyze, maintain and modify RPG III and RPG/ILE software programs within Future 3 EDI/Automotive Release Accounting Software package as well as custom programs interfacing to Future 3 and BPCS ERP software. Apply PTF's and upgrades to Future 3 software.
  • Troubleshoot and resolve all technical and functional issues involving EDI interaction with a automotive trading partners (Ford, Chrysler, GM, Honda, Toyota, etc.)
  • Resolve all technical issues involving EDI interaction with suppliers and financial institutions. using TrustedLink (Inovis/Agilisys) EDI mapping/Translation software. Install upgrades to TrustedLink software. Create and modify existing maps and trading partners.
  • Create, modify and monitor ROBOT scheduled jobs to perform automated EDI tasks.
  • Environment: Tier One Automotive supplier. IBM AS/400, RPG/400, and RPG ILE (programming languages). FUTURE 3/INFOR Global (EDI mapping/translation/Automotive release accounting), DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). BPCS (ERP/MRP manufacturing application software). TrustedLink 400/Harbinger/Peregrine) EDI translation/mapping software. Novell network, Lotus Notes mail server, FTP ANX (communication with Mercedes Benz/Chrysler and Ford), EDS*Eilte (General Motors), Various vans (GEIS, Advantis, Toyota Direct). ROBOT AS/400 job scheduler.

05/2002 - 8/2003: PROGRAMMER/EDI COORDINATOR, Confidential, Archbold, OH.

  • Analyze, maintain and modify RPG III and RPG/ILE software programs (both custom written applications and JBA/GEAC third party ERP/MRP software).
  • Troubleshoot and resolve all technical and functional issues involving EDI interaction with a trading partner base of over 100 customers. Resolve all technical issues involving the EDI translation software (Peregrine/Haribinger/TrustedLink400). Create and maintain software and database interfaces between EDI software and ERP/MRP/Order entry application. (JBA). Creation and maintenance of EDI maps for trading partners such as Wal-Mart, Kroger, Miejer, and Food Lion. Transaction sets used: 1) UCS standards 880 (invoice) and 875 (purchase order) 2) X.12 standards 850 (purchase order) and 810 (invoices). Resolve technical issues involving VAN communications with the following networks: Inovis/Harbinger and Wal-Mart Retail Link.
  • Converted EDI communications with Wal-Mart and Food Lion (and numerous other large, retail grocery organizations) from traditional Bi-synchronous VAN connection to EDI AS2 (EDI using secured internet communications). Performed all of the analysis, programming, and user training required to implement this functionality.
  • Analyze AS/400 database to create and maintain user requested ad-hoc queries and downloads to files for PC applications.
  • Environment: Frozen food manufacturing. IBM AS/400, RPG/400, and RPG ILE (programming languages). DBU, SEU, SDA, RLU and PDM and Query400 (AS/400 development tools). JBA/GEAC/System 21 (ERP/MRP manufacturing application software). TrustedLink 400/Harbinger/Peregrine) EDI translation/mapping software. Novell network, Exchange mail server, Citrix server. Inovis/Harbinger VAN network and Wal-Mart retail link direct network, AXWAY (Cyclone Commerce) AS2 Communication software.

02/1999 - 11/2001: ADVISORY APPLICATION DEVELOPER, Confidential, Northville, MI.

  • Researched, designed, developed, and maintained Future Three Automap EDI applications on an IBM AS/400 using RPG/IV with RPG ILE.
  • Worked extensively with various X.12 EDI transaction sets such as 810 (Invoices), 820 (Remittance Advices), 861 (Receiving Advices), 830 (Releases), 856 (ASNs), 862 (Daily Scheduling). Also worked with programs/functions used to create, receive, view and print the following EDIFACT message types: DESADV (Despatch Advice), DELFOR (Delivery Forecast) and DELJIT (Daily Schedule).
  • Performed analysis and program modification to implement new trading partners. Created new trading partner EDI maps within the package for trading partners such as Harley-Davidson, Ford, Daimler/Chrysler, GM, Toyota and others.
  • Modified Future Three applications to enhance communications capabilities with VANs such as Advantis and GEISCO and Sterling Commerce.
  • Environment: Development of integrated EDI/automotive manufacturing software. IBM AS/400, RPG III, RPG ILE, PDM, SEU, SDA, RLU, TurnOver, and Hawkeye.

REFERENCES: Furnished upon request.

Hire Now