Uploaded File
Mercedes
mercedesavery@yahoo.com
904-403-1577
Jacksonville, FL 32099
EDI Analyst/Programmer
29 years experience W2
0
Recommendations
Average rating
90
Profile views
Summary

Result-oriented system analyst/programmer with over 15 years of experience in Logistics, Transportation, Manufacturing, Finance, Customer Service, Sales, Order Entry, Inventory, and Returns system. Fluent in English and Spanish.

TECHNICAL SKILLS:

  • Platforms: OS/400, Unix, Windows NT
  • Programming Languages: RPG II-III-IV-ILE, CL, COBOL, Pascal, Fortran, Assembler, C++, MS Access.
  • EDI: Applications for EDI documents includes: 300, 301, 304, 315,310, 204, 214, 210, 601, 990, 997 and others. Other systems maintenance included: Order Entry, Accounts Receivable, and Puerto Rico ports authority.
  • Utilities: On the AS/400: Query, SAL, DFU, SDA, SEU, PDM
  • Third-Party: SEQUEL, EZ-View, Turnover, Trusted Link/400, GOANYWHERE/400

PROFESSIONAL DEVELOPMENT:

  • Trusted Link 400 – EDI software
  • UNISYSDATA S.A. – 4GL PROGRAMMING
  • IBM of Ecuador: AS/400 Operation, Data Base Management, SQL, SEQUEL, Query, COBOL, RPG II-III-IV, ILE, SYNON/2, PC Support/400, Control Language

Experience
EDI Analyst/Programmer
Retail
Mar 2018 - present
Jacksonville, FL
  • Performed Trusted Link Software Upgrade V.6.2.1. to V.6.4.1 on AS/400 and client version.
  • Assisted with install on new AS/2 Certificate on the AS/400.
  • Analyzed, Coded, Tested, Implemented and post-implemented Change on the EDI-810 Invoices received with negative or zero dollars quantity or total invoice amount.
  • Onboarded Process of new or Van/Interchange ID Change request of company's EDI trading Partner on Liaison Exchange Network VAN.
  • Researched errors on EDI documents (EDI-850 Purchase Order, EDI-810 Invoices, EDI-856 ASN, etc.) and requested business or trading partners to fix and retransmit the corrected document.
  • Researched data errors in EDI-850 Purchase Order files and EDI-860 Purchase Order Change files and requested the Data support team to fix errors.
  • Assisted with the Mercury Gate Transportation EDI application. Tasks included:
    • Setup new Carriers on EDI and worked as Liaison between business and 3rd party Mercury Gate support.
    • Verified EDI document flows as expected. Served as liaison between carrier and business and Mercury Gate support to solve errors in EDI documents, or missing EDI documents, or any business request.
  • Utilized Microsoft Server SQL to research data.
  • Utilized Microsoft Azure Storage software to update the company's tables that feeds Items information on Company's website.
  • Supported Testing Business to Business Setups.
  • Day to Day management of EDI transactions and processing.
  • Provided level 1 and 2 application support for AS400 applications.
  • Created documents for AS400 applications.
  • Utilized FileZilla to research on Mercury Gate/Transportation Management systems (TMS) EDI documents: 210-Invoices, 204-Load Tender, 214s Shipment Status).
  • Provided support with Mercury Gate Transportation Management systems (TMS), MercuryEdge/Mojo.
  • On-Boarded new EDI Carriers on TMS systems.
EDI EDI Analyst FileZilla MS Azure AS/400 Application Support
Remove Skill
EDI Analyst / Programmer
Transportation
Dec 2016 - Mar 2018
Jacksonville, FL
  • Automated the weekly Purge of Obsolete EDI transactions (older than 6 months) to keep EDI mailbox size under 50%.
  • Completed Implementation of new FORDS EDI system: EDI 304-XML - Shipping Instructions, EDI 310 XML - Ocean Invoices, and XML EDI 315 XML - Shipments Status.
  • Other Implementations completed:
    • EDI 315 (Shipment Status events) – Hanes Brands, Cardinal Health, Home Depot, etc.
    • EDI 310 (Ocean Invoices) – PEP BOYS / Acuity systems, Cardinal Health/Amber Road, Home Depot/Mercury systems, Walmart/Syncada/USBANK.
    • EDI 300 – Booking Reservation: Cardinal Health.
EDI EDI Analyst XML
Remove Skill
EDI Analyst / Programmer
Retail
Dec 2015 - Dec 2016
  • Utilized Crystal reporting to pull data and present reports to operations, IT managers, and other business partners. Reports like: Item Stock Status, List of all items sold to a Client, List of Orders with Items on Backorder, Assist reviewing Cash Flow reports, etc.
  • Responsible for daily and monthly Sales Forecast and upload forecast to Sage 100 ERP systems.
  • Analyzed and fixed data errors on EDI documents. EDI documents included 810- Commercial Invoices, 850-Purchase Orders, 856- Advance shipment notices, EDI 753 and 754 - Routing Request, etc.
  • Responsible for the conversion of EDI providers from True Commerce to SPS Commerce and verify data on EDI documents flow on MAS/SAGE system.
ERP EDI EDI Analyst SPS
Remove Skill
EDI Analyst / Programmer
Transportation
Aug 2012 - Oct 2015
Jacksonville, FL
  • Conducted EDI modernization gap analysis and documented COBOL programs to support EDI.
  • Responsible for the EDI help desk mailbox. Researched, fixed, and resent missing EDI 315 and 310 documents. EDI clients included Military/SDDC, Hanes Brands, Target, JC Penny, P&G Johnson & Johnson, Under Armour, and others. Served as a business liaison between the different business partners of the corporation: Information technology, customers, business partners, users, 3rd. parties, etc.
  • Created Requirements and Testing documents that helped improved/optimize data quality and/or system processes. Worked closely with the development team on system changes, testing, implementation, and post-implementation.
  • Responsible for the testing and implementation of the file of the goods leaving Puerto Rico for Puerto Rico Ports Authority. Served as a business liaison between business partners, users, and clients for a better understanding and collaboration of the project requirements, testing, and implementation.
  • Used Sterling Integrator dashboard and mailbox to research documents and EDI documents that failed to process.
  • Utilized IBM Query utility to analyze data as part of the testing of the EDI documents changes. Other use queries as a mean to fix production data.
Cobol EDI EDI Analyst Sterling Analysis
Remove Skill
EDI Analyst / Programmer
Transportation
Apr 2007 - Aug 2012
Jacksonville, FL
  • Responsible for all new and existing EDI accounts with Trailer Bridge. Worked directly with clients, third-party providers/suppliers, and internal users in the United States, Puerto Rico, Dominican Republic, and other overseas locations to gather requirements, project specifications and conduct a gap analysis.
  • Completed programming, mapping, network interface setup, testing, and final implementation into production environments for all EDI transactions. Implemented SDLC process to assure accurate project results and a continue user satisfaction, and provided user training if required. Served as a liaison between company departmental areas, third-parties vendors, and suppliers, third-parties software systems, compiled and maintained all post-implementation documentation.
  • Clients included Sterling Commerce SI, GT Nexus, Ford, General Motors, Mazda, US Navy, the US Department of Defense, US Customs and Border Protection (AES), Baxter International, and others.

As a part of these responsibilities:

  • Utilized RPG ILE, CL programming language to develop and maintain EDI applications and software. EDI documents developed involved Ocean 300’s and Motor Carrier 200’s series, Payment remittance 820, US export shipment document 601, and others. Other systems maintenance included: Order Entry/Customer Service, Finance: Accounts Receivable, Rating and Billing, and Interface programs to the Puerto Rico port authority.
  • Changed bi-sync communication to direct FTP to the client.
  • Changed VAN FTP to direct FTP to the client and saved the company an average of five figures per month.
  • Utilized the Trusted Link (TLI/400) system to set up and maintain new EDI customers. Tasks in the Trusted link included:
    • Created and/or Maintained Trading Partners on the address book.
    • Created and/or maintained a new EDI document, mostly EDI documents X12 format.
    • Created or changed and compiled a map.
    • Created and/or maintained EDI communication setup including EDI envelope and FTP information.
    • Analyzed EDI communication sessions to verify and/or test data and ISA information was transmitted successfully. Also, used the Communication session to resend an EDI document(s).
    • Upgraded Trusted Link Systems to the latest version 6.2.
    • Upgraded MileMaker software.
    • Installed and applied PTF’s.
Cobol EDI EDI Analyst Sterling FTP Requirements Gathering RPG ILE RPG Documentation Customer Service CL Billing Analysis
Remove Skill
Programmer/Analyst
Professional/Consulting Services
Jan 2006 - Mar 2007
Palm Coast, FL
  • Utilized RPG ILE and CL programming to develop and maintain in-house application systems.
  • Applications developed and maintained were Warehouse, Inventory, Customer Service and Client Representative, Sales, and Accounts Receivables.
  • Sent and received sales promotion files to client via FTP.
ILE RPG CL Customer Service RPG
Remove Skill
Systems Analyst/Programmer
Information Technology
Jan 1992 - Jul 2005
  • 03/2005 - 07/2005: WMSI, INC., Jacksonville, FL - Programmer/Analyst
  • 1999 - 2005: VISTAKON, J & J VISION CARE, INC., Jacksonville, FL - Programmer/Analyst
  • 1997 - 1999: STEIN MART, Jacksonville, FL - Programmer/Analyst
  • 1996 - 1997: TREAT ENTERTAINMENT, Florence, AL - Programmer/Analyst
  • 1995 - 1996: JABONERIA NACIONAL S.A., Guayaquil, Ecuador, South America - Systems Analyst
  • 1992 - 1995: IBM OF ECUADOR S.A., Guayaquil, Ecuador, South America - Systems Analyst
System Analysis MS Visio
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Business Administration
Jacksonville University 2008
Bachelor's in Computer Engineer
Catholic University of Santiago de Guayaquil 1991
Related Courses
Visual Basic with .Net programming, 2017
Completed Project Management, 2010
Skills
EDI
2021
13
EDI Analyst
2021
13
MS Visio
2005
13
System Analysis
2005
13
Analysis
2015
8
Cobol
2015
8
Sterling
2015
8
CL
2012
6
Customer Service
2012
6
ILE RPG
2012
6
RPG
2012
6
Billing
2012
5
Documentation
2012
5
FTP
2012
5
Requirements Gathering
2012
5
Application Support
2021
2
AS/400
2021
2
FileZilla
2021
2
MS Azure
2021
2
ERP
2016
1
SPS
2016
1
XML
2018
1
SDLC
2007
1
MS Access
0
1
OS/400
0
1
SQL
0
1
UNIX
0
1
Windows
0
1
Languages
Spanish, Fluent/Bilingual