Programmer Analyst RPG AS400 ISeries

RICH MARINELLI

* ****** **.

Suffern, NY *****

845-***-****

******@*******.***

Goal: I am seeking a remote part time position (10-25 hours) as an AS400 RPG programmer which may or may not involve EDI mapping.

Career experience: 35 years designing systems and programming in RPG on the AS400. 25 years creating and maintaining EDI maps using Trusted Link.

Clarins USA Inc. 1999 – 2021 : Senior Programmer Analyst / EDI Manager

2022 – Present : Part time AS400 RPG and EDI consultant

Programming on the AS400 using RPGLE, CLLE, SQL, SEQUEL 400

EDI mapping using the Trusted Link 400 EDI Translator (owned by OpenText),

APPLICATIONS

1.EDI

A.Inbound and outbound mapping to trading partner specifications

B.Documentation of mapping specifications for new trading partners

C.Programming reports and populating production files from inbound documents

D.Creating outbound documents from production files

E.Catalog management of GXS and Intertrade catalogs for 3 corporations

F.Manage timely flow of inbound and outbound documents

1.850 PO

2.860 PO Change

3.852 Sell Thru and Stock

4.820 Remittance Details

5.180 Destroyed in field

6.855 Reverse PO

7.855 PO Acknowledgement

8.810 Invoice

9.856 Advanced Ship Notice

10.215 UPS Manifest

2.Order Processing

A.Interpret and edit EDI orders

B.Integrate valid orders to data base

C.Integrate ecommerce orders from external OMS system

D.Order level editing of all EDI and manual orders

E.Order creation

F.Inventory reduction

G.Intelligent carton assignment

3.A/R

A.Created system to match payments from EDI 820 document to A/R balances to track payments

B.Created system to match destroyed in field EDI 180 documents and other credits taken on EDI 820 documents to A/R balances

C.Modified Aged Trial Balance reporting to include spreadsheets to aid A/R department in reconciliation

D.Created consolidated invoicing system for Nordstrom and Belk invoices and modified all systems including EDI to manage accordingly.

E.Separated entire A/R system for new business partners IPLB and Puig.

4.Sell Thru and Sell In reporting utilizing Crystal Reports software

A.Raw EDI reporting and feeding audited sales files

B.Audited sales entry and reporting

C.Sell In reporting

D.Category reporting based on corporate rules

E.Sequel based intranet

5.Warehouse applications

A.Receiving

B.Inventory movement

C.Picking accuracy management with electronic scale integration

D.Bill Of Lading and ASN creation

E.Fedex and UPS system integration

F.Electronic UPS AND Fedex manifests

Contact this candidate