Order Entry Customer Service

SUMMARY

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

TECHNOLOGY

Platforms: OS/400 (iSeries or AS/400 or system-i), Unix, Windows NT

Programming Languages: RPG II-III-IV-ILE, CL, COBOL, Pascal, Fortran, Assembler, C++, MS Access.

EDI: Applications for EDI documents include: 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, SQL, DFU, SDA, SEU, PDM

Third Party: SEQUEL, EZ-View, Turnover, Trusted Link/400, GOANYWHERE/400

PROFESSIONAL EXPERIENCE

O’Reilly Auto Part 05/22/2023 – 04/2025

Software Developer / EDI support

Provide EDI support using Extol/Cleo EII in AS/400 (also known as iSeries or system-i).

Review EDI files ANSI X12 format received with errors including: EDI 850-Purchase Order, EDI-856 Advance Shipment Notice, EDI-846 Inventory Inquiry, 855 or 865 Purchase order Acknowledge and EDI-810 documents and contact customer EDI support team to assist making the corrections and re-transmitting the EDI document.

Assist on Migration of new EDI-856 TMS ANS map for all the company’s Vendors.

Assist On-boarding new EDI Vendors on the order-to-cash process. EDI documents include: EDI-850 Purchase Order, EDI-856 ASN and EDI-810 Invoices.

Assist Updating EDI/AS2 certificates on O’Reilly PartNet Ship Connectivity server application.

Migrating from EDI Extol EEI to Cleo in the Cloud/CIC EDI system/VAN.

Wells Fargo, Remote 07/01/2022 – 02/03/2023

Technical Data Specialist (EDI) - Contract

Technical Data support in Receivables Management department using AS/400 systems and EDI Sentinel/Axway software.

Assist onboarding customers to their Receivables Management system.

Assist with maintenance of the reporting files sent electronically to customers with list of Payment transactions received on their customers/trading partner account thru direct deposit or wire.

EDI software used Sentinel/Axway.

Systems use included: IBM mainframe, TPX tool, Connexion legacy system to setup or change current reporting file setup transmitted electronically to clients.

Files transmitted using EDI ANSI X12 (820 –payments and 823 – lockbox).

Other files format including Flat Files using BAI File layout format.

Worldwide Express, Remote 04/2022 - 07/01/2022

EDI Specialist

Assisted with EDI SalesForce Ticketing system to analyze requests coming from different business partners in regard to EDI ANSI X12 EDI documents documents that failed and address the error with the corresponding IT team.

TECH DATA/SYNNEX, Remote July 2021 - Jan 2022

EDI Analyst/Developer

Assisted with EDI migration project. The EDI department changed from Axway EDI systems to Web Methods EDI systems and using AS/400 mid-range platform.

Assisted creating EDI mapping (MRS – Mapping requirement specifications). Edi documents including: EDI-846 – Inventory Inquiry / Advise, EDI-830 – Planning Schedule, EDI-832 - Sales Price /Catalogue, EDI-850 – Purchase Orders, EDI-855 – Purchase Order acknowledgement, EDI-860 – Purchase Order Change request, EDI-856 – Advance Shipment Notifications, EDI-810 – Invoices, EDIFACT – DELFOR, DELJIT, DESADV, INVOIC, ORDERS, ORDRSP, ORDCHG

Gathered and provided testing files and provide them to the developer/mapper for testing. Verify testing comparison reports match MRS EDI specifications. If testing reports pass validations, then ticket is moved to “ready to production”. Testing included verifying EDI files match SAP (xml format) IDOC’s. Also use SAP customer inquiry to verify that account was active and customer had a purchase order with Tech Data in the past 6 months.

Assisted contacting Tech Data Sales team to request Customer/Trading Partners EDI Contact information when requested by Project Manager and/or Implementation team.

McKesson Corporation, Remote 11/2020 - June/2021

Remote EDI specialist

Assisted with McKesson IT business initiative to strengthen their EDI security on all customers currently using standard ftp (file-transfer protocol) to a secure ftp (sftp). Project involved over 10,000 customers including all pharmacies, clinics, hospitals, health care facilities that exchange data (orders, shipment status notifications, invoices) with McKesson EDI systems.

Performed Customer Research including: - Verifying in SAP Customer Inquiry if that account was “active”, Corroborate that customer placed last purchase order in less than 12 months period. Verify Customer contact information is current and accurate. If not, reach out to the corresponding sales team to request assistance with their customer EDI contact information.

Stein Mart Inc., Jacksonville, FL 03/2018 - 10/2020

EDI Analyst/Programmer (Retail / Apparel business)

Performed Trusted Link Software Upgrade V.6.2.1. to V.6.4.1 on AS/400 (also known as iSeries) IBM system and client version.

Assisted with installation of new AS/2 Certificate/ Nubridges/ on the iSeries.

On iSeries performed: Analysis, Coding, Testing, Implementation and post-implementation of changes on the ED ANSI X12 -810 Invoices. Current system allowed the EDI-810 Invoices to be received with negative or zero dollars quantity or total invoice amount and be posted on Stein Mart Finance systems. The request was to not allow EDI-810 Invoice document to flow into accounting system. This project included: Program changes using RPG programming, Creating Testing Plans - UAT (user acceptance testing). These testing plans included various testing scenarios of EDI-810 Invoices.

On AS/400 (iSeries systems) – monitor EDI 810 invoices posted successfully in EDI mailbox TrustedLink/400 and also posted successfully on company’s legacy system.

Assisted On-boarding of new EDI customers/trading partners to use OpenText Van/and TrialBlazer/Nubridges.

Performed research of errors on EDI ANSI X12 EDI documents (EDI-850 Purchase Order, EDI-855- Purchase order acknowledgement; EDI-860 Purchase Order Change, EDI-810 Invoices, EDI-856 ASN) and request business or trading partner to fix and retransmit corrected document.

Utilized Microsoft Server SQL to research data.

Utilized Microsoft Azure Storage software to update company’s tables that feeds Items information in Company’s Products Catalogue website.

Provided support on Stein Mart Transportation Management systems, MERCURY GATE (TMS) – EDI based software. EDI X12 EDI documents including: EDI documents: 210-Invoices, 204-Load Tender, 214s – Shipment Status).

Assisted with On-Boarding of new EDI Carriers (Swift, Old Dominion, JB Hunt, Schneider, and others) on Mercury Gate - TMS systems. Also, performed testing, Implementation and post-implementation of the new EDI documents with the new carrier.

TRAILER BRIDGE INC., Jacksonville, FL 12/2016 - 03/2018

EDI Analyst / Programmer

In iSeries, (AS/400 midrange systems), automate a 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 ANSI X12 EDI documents included:

oEDI 304-xml – Shipping Instructions; EDI 310 xml -Ocean Invoices; and XML EDI 315 xml – Shipments Status.

oEDI 315 (Shipment Status events) – Hanes Brands; Cardinal Health; Home Depot; etc.

oEDI 310 (Ocean Invoices) – PEP BOYS / Acuity systems; Cardinal Health/Amber Road; Home Depot/Mercury systems; Walmart/Syncada/USBANK

oEDI 300 – Booking Reservation: Cardinal Health

Project included the creation of UAT (user acceptance testing) that will be approved by IT manager and moved into production.

UST BRANDS (ULTIMATE SURVIVAL TECHNOLOGIES), Jacksonville, FL 12/2015 - 12/2016

EDI Analyst / Programmer

Utilize Crystal reporting to pull data and present reports to operations, IT manager 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.

Analyze and fix data errors on EDI documents. EDI documents include: 810- Commercial Invoices, 850-Purchase Orders, 855- Purchase Order acknowledgement, 860-Purchase order change, 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 SAGE/100 system.

CROWLEY MARITIME CORPORATION, Jacksonville, FL 08/2012 - 10/2015

EDI Analyst / Programmer

Conducted EDI modernization gap analysis and documented Transportation COBOL programs that reside in IBM mainframe to support EDI system. EDI system use Sterling Integrator to create, maintain and communication setup.

Responsible for the EDI X12 documents help desk mailbox. Research, fix and resend missing EDI 315- Shipment Status and 310-Invoices documents. EDI clients/trading partners include Military/SDDC, Hanes Brands, Target, JC Penny, P&G Johns & Johnson, Under Armor and other customers. Serve as business liaison between the different business partners of the corporation: Information technology, customers, business partners, users, 3rd. parties, etc.… Create Requirement and Testing documents that help improved/optimize data quality and/or system processes. Work closely with 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. Serve as business liaison between business partners, users and clients for a better understanding and collaboration of the project requirements, testing and implementation.

Extensive use of Sterling Integrator dashboard and mailbox to research documents and EDI documents that failed to process.

Utilize 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.

TRAILER BRIDGE INC., Jacksonville, FL 04/2007 - 08/2012

EDI Analyst / Programmer

Legacy system use IBM iSeries (also known as AS/400 midrange system or system-i).

Responsible for all new and existing EDI accounts with Trailer Bridge. In this role I 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 gap analysis.

Utilize RPG ILE, CL programming language to develop and maintain EDI applications and software. EDI ANSI X12 documents developed involve 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.

EDI system uses TrustedLink/400 in iSeries systems.

Complete programming, mapping, network interface setup, testing and final implementation into production environments for all EDI transactions. Understand and implement SDLC process to assure accurate project results and a continue user satisfaction and provide user training if required. Serve as a liaison between company departmental areas, third parties’ vendors and suppliers, third parties software system and compile and maintain all post-implementation documentation.

Clients include GT Nexus, Ford, General Motors, Mazda, US Navy, the US Department of Defense, US Customs and Border Protection (AES), Baxter International and others.

Change VAN FTP to direct FTP to client and save the company an average of five figures per month.

•Utilize Trusted Link (TLI/400) system to setup and maintain new EDI customers. Tasks in Trusted link included:

•Create and/or Maintain Trading Partners on the address book.

•Create and/or maintain new EDI document, mostly EDI documents X12 format.

•Create or/change and compile map.

•Create and/or maintain EDI communication setup including EDI envelope and FTP information.

•Analyze EDI communication sessions to verify and/or test data and ISA information is transmitted successfully. Also, use the Communication session to resend an EDI document(s).

PALM COAST DATA, Palm Coast, FL 01/2006 - 03/2007

EDI Analyst / Programmer

Perform maintenance on company’s legacy system in the order to cash process in the iSeries (AS/400 midrange systems).

Utilize 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.

Send and receive sales promotion files to client via FTP.

WMSI, INC., Jacksonville, FL 03/2005 - 07/2005

Analyst / Programmer

Programming and Maintenance of company in-house Warehouse systems in iSeries, (known also as “AS/400” midrange or system-i) systems.

Customize in-house warehouse management system programs for WMSI clients.

Develop test plan, setup test environment and execute testing.

Utilize RPGILE, CL, SCREEN design and Report Layout Utility

VISTAKON, J & J VISION CARE, Inc., Jacksonville, FL 1999 - 2005

Programmer/Analyst

Re-Engineer system applications and processes for the United States and Canada. Applications in the iSeries (also known as AS/400 midrange systems). Other projects in the iSeries included:

Provide full life cycle development, which includes meeting with the users to gather specifications, design, coding, testing, and implementation.

Maintenance and enhancements of Accounts Receivable Infinium System, Vertex Sales and Use tax systems. Applications developed were Order Entry, Taxes Accounts Receivable, Sales and Inventory.

Conduct and develop conversion programs from AS/400 to the new SAP system.

Conduct and develop archiving programs for Accounts Receivables and Tax department.

Utilize RPGILE, SQLRPGILE, OPNQRYF, CL, SCREEN design and Report Layout Utility.

CERTIFICATIONS

Extol/Cleo EII EDI basics. 02/2024.

Visual Basic with dot net programming - Florida State College

Completed Project Management - Florida State College

PROFESSIONAL DEVELOPMENT

Trusted Link 400 - EDI software/ iSeries (also known as AS/400)

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

EDUCATION

Master Business Administration – April 2008 - Jacksonville University

Degree of Computer Engineer - Catholic University of Santiago de Guayaquil

Contact this candidate