Bill Mastromarino
Sinking Spring, Pa. 19608
Email: abl4ez@r.postjobfree.com
Cell# 484-***-****
Technical Skills Summary
Platforms / OS: IBM iSeries (AS/400); RS/6000/ AIX (UNIX), Sun Microsystems
(UNIX), MS Windows Server (PC).
EDI Software: TrustedLink( iSeries, Gentran for UNIX, Gentran for Windows,
and EXTOL Integrator for i .
Other Software: Lexicom(by Cleo). Used Lexicom to send EDI data to from
TP's using various protocols.
Programming Languages: ILE RPG, Free-Form RPG, Embedded SQL, SQL, CL,
COBOL, and Perl Scripting.
IBM iSeries (AS/400) Software Utilities: Hawkeye and Help/Systems Robot
Professional Experience and Accomplishments
EDI Consultant
De Lage Landen, Wayne, PA
Feb. 2010 - May 2010
Hardware Platform - AS/400(iSeries) and Linux
Software - Programming (RPGILE, Free Form RPG, embedded SQL, SQL, CL) and
TrustedLink (EDI translation).
Acting in several capacities:
. EDI consultant for resurrecting a stalled EDI project.
. Transactions worked on - 810(in/outbound), 820 (out), 823 (in), 824
(in), 845 (in/out) ISO8583 (in/out).
. Trading Partners include: Ingram, Techdata, Synnex, Panasonic,
Samsung, Acer, PNC Bank, etc.
. Projects worked on:
1. Configure/Test Lexicom software to process ISO8583 approvals
in/out via secure FTP.
2. Work with PNC Bank to get 820(out) Direct Debit Transactions
working.
3. Work with PNC Bank to get 823(in) Lockbox transactions working.
4. Work with above Trading Partners to get inbound invoicing
processing.
Mastromarino
(Page 2)
EDI Consultant
Central Pa. Teamsters Pension Fund, Wyomissing, PA
April 2009 - Present (as needed)
Hardware Platform - AS/400 (iSeries) and Sun Microsystems (UNIX)
Software - Programming (RPGILE, Free Form RPG, embedded SQL, SQL, CL).
Unix/Perl scripting and Basys.
Acting in several capacities.
. EDI consultant for stream lining existing HIPAA EDI processing.
. Transactions worked on - 834(outbound) /837(inbound).
. Trading Partners include: Delta Dental and Coventry.
. Projects worked on:
1. Design/Code/Test/Implement 834/Outbound Benefit Enrollment and
Maintenance Transaction for above trading partners.
2. Create UNIX script to automate current manual processes.
3. Troubleshoot daily EDI issues data/mapping/communications.
4. Automate the file creation and (secure) SFTP send process.
Process previously was run in 3 manual steps.
EDI Consultant
Penske Truck Leasing, Green Hills (Reading), PA
Oct. 2008 - Jan. 2009(40 hrs/wk)
Hardware Platform - AS/400(iSeries)
Software - Inovis/TrustedLink(EDI), Hawkeye, Robot, Programming (RPGILE,
Free Form RPG, embedded SQL, SQL, CL).
Acting in several capacities.
. EDI consultant for utilizing Inovis/TrustedLink EDI software.
Translation of documents and addition/modification to new and existing
trading partner relationships.
. Penske Transactions worked on - (outbound) 810/824.
. Trading Partners include: AT&T, Cox Communications and McDonald Bros.
. Projects worked on:
1. Design/Code/Test/Implement 810/Outbound invoicing for above
trading partners.
2. Make modifications to Internal EDI Control maintenance subfile
program.
3. Troubleshoot daily EDI issues data/mapping/communications.
EDI Consultant
Baldwin Hardware Corp. (Division of Black & Decker), Reading, PA
03/01/1998 - 01/31/2010
Hardware Platform - AS/400(iSeries) and UNIX AIX (BDHHI)
Software - KBM (ERP), PKMS (WMS), Inovis/TrustedLink (Baldwin's
translator), Hawkeye, Robot, Programming (RPGILE, embedded SQL, SQL,
CL).
Gentran for UNIX (BDHHI's EDI translator)
Mastromarino (Page
3)
Acting in several capacities.
. EDI consultant in VAN migration from Inovis & Sterling to BDHHI's Van
GXS.
. Convert/analyze/migrate current outbound EDI data currently used in
Baldwin transactions being translated in TrustedLink to BDHHI's
Gentran Maps so when the migration is complete the change over will be
transparent to all trading partners.
. EDI consultant for utilizing Inovis/TrustedLink EDI software. All
translation of documents and addition/modification of trading partner
relationships.
. EDI Coordinator working with trading partners directly. Also work with
Baldwin's internal departments. Review all daily EDI processes such as
communications, translation and related programming.
. Project Lead/Programmer Analyst for the design, development and
rollout of EDI systems.
. Baldwin Transactions include - (outbound: 204, 810, 850, 855, 856, 870
and inbound: 812, 820, 824, 832, 850, 852, 860, 864, 869).
. Trading Partners include: Home Depot, Lowes, Bed Bath & Beyond, Sears,
JC Penney and more.
. Major projects completed:
1. Redesign/Code/Implement 810/Invoicing system.
2. Design/Code/Implement 856/ASN process. Interface with data
extracted from PKMS.
3. Design/Code/Implement 820 Interface and Advise Remit reporting
process.
4. Design/Code/Implement 852 Product Activity database to be used by
a data warehouse. Worked with internal IT member & Departments to
feed InfoManager data warehouse product. Allow Planning, Sales &
Marketing departments to view data as needed.
5. Design/Code/Implement/Interface software to work with external
supplier. Create an outbound 850 on Baldwin AS/400 and FTP it to
the Supplier to be processed into their shipping software. Baldwin
does a get via ftp on the shipment data, translate it and then
bill the EDI customers via 810 documents.
EDI Consultant
Morgan Corp. (Division of J.B.Poindexter), Morgantown, PA
2005 - Present (as needed)
Hardware Platform - AS/400(iSeries), PC
Software - KBM (ERP), JDE (ERP), Extol for AS/400 (EDI), Gentran (PC),
Robot, Programming (RPGILE, embedded SQL, SQL, CL, DOS).
Acting in several capacities.
. EDI consultant for utilizing Extol and Gentran EDI software. All
translation of documents and addition/modification of trading partner
relationships.
. EDI Coordinator working with trading partners directly. Also work with
Morgan's internal departments. Review all daily EDI processes such as
communications, translation and related programming.
. Project Lead/Programmer Analyst for the design, development and
rollout of EDI systems.
Mastromarino (Page
4)
. Morgan Transactions include - (outbound: 810, 846, 855, 865, 870 and
inbound: 850, 856, 860, 864, 869.
. Trading Partners include: Penske, Ryder, International, ARI and FedEx
. Major projects completed:
1 Design/Code/Implement 810/Invoicing system for Penske and ARI
interfacing with KBM.
2. Design/Code/Implement 860/865 PO change/PO change Ack. Process
with Penske.
3. Design/Code/Implement 860 PO change reporting process with Ryder
Truck.
4. Design/Code/Implement 810/Invoice process with FedEx interfacing
with JDE Z files.
5. Design/Code/Implement JDE to StoreFront (Website) send 846
Inventory data to website, website returns 850 PO's entered by
customers, a 855 PO ack is returned to the website, when the order
ships an 856 is sent to the website updating the order status.
EDI Consultant
Cott Beverage, Wyomissing, PA
1998 thru July 2005 (24hrs/wk)
Hardware Platform - RS6000/AIX, PC
Software - Innatrack by DBS (ERP), Gentran for Unix (EDI), Aplus (EDI
communications), UNIX and Cron scripting.
Acting in several capacities.
. EDI consultant for utilizing Gentran for Unix EDI software. All
translation of documents and addition/modification of trading partner
relationships.
. EDI Coordinator working with trading partners directly. Also work with
Cott's internal departments. Review all daily EDI processes such as
communications, translation and related programming.
. Project Lead/Programmer Analyst for the design, development and
rollout of EDI systems.
. Cott Transactions include - (outbound: 810, 880, 855 and inbound:
850, 864, 860, 875, 940, 941.
. Trading Partners include: McLane, Dollar General, Tropicana, Giant
Eagle, Piggly Wiggly and Walmart.
. Major projects completed:
1 Design/Code/Implement 810/880 Invoicing process for all TPs
interfacing with Innatrack.
2. Design/Code/Implement 875 PO(UCS) for UCS trading partners.
3. Design/Code/Implement 860 PO change reporting process with
Tropicana.
4. Design/Code/Implement 940 Tropicana using this document in place
of a 850 transaction. Return 941 Inventory Status Report.
Porter Instrument (Division of Parker Hannifin Corp), Hatfied, PA
2000 thru Present (As needed)
Hardware Platform - RS6000 (AIX), PC.
Software - Oracle database, Gentran for PC(EDI), Aplus (EDI
communications), and DOS/Aplus scripting.
Acting in several capacities.
. EDI consultant for utilizing Gentran EDI software. All translation of
documents and addition/modification of trading partner relationships.
Mastromarino (Page
5)
. EDI Coordinator working with trading partners directly. Also work with
Porters internal departments. Review all daily EDI processes such as
communications, translation and related programming.
. Project Lead/Programmer Analyst for the design, development and
rollout of EDI systems.
. Porter Transactions include - (outbound) 810 (inbound) 850.
. Trading Partners include: 3M, Henry Schein, Delta Dental, Benco
Dental.
. Major projects completed:
1. Design/Code/Implement 810 outbound Invoicing process.
2. Design/Code/Implement 850 inbound PO process.
3. Setup communication process for inbound & outbound documents.
Education
Attended Salem College and Albright College (Finance)
References
Available Upon Request
Mastromarino (Page
6)
Additional Experience
Company Name Title Hardware Software Projects worked on
General Battery Programmer/Programmer IBM 43xx and Wang Cobol and RPG MRP system for Industrial
Analyst VS80 Division. Warehouse locator
system.
Bachman Foods Programmer/Analyst AS/400 Cobol Production Planning system.
Drivers log tracking system.
Harley Davidson Senior Programmer NAS 4000 CICS macro Develop online programs for parts
level (on tracking
line)
Giorgio Foods Senior Programmer Wang VS80 Cobol Wrote ERP system...from order
Analyst entry through shipping...
Bollman Hat Asst DP Mgr Wang VS80 and AS/400 RPG Inventory tracking system
utilizing bar coding of finished
goods.
Bachman Foods Project Lead AS/400 and Norand RPG/PLN for Project Manage/Design/Code route
HHC's Premenos HHC's/MBP pc automation system. EDI with GSA
EDI based Cobol pricing Also do EDI via
Handheld unit direct to chain
stores.
Weidenhammer Project Lead Data AS400 and Intermec RPG/Cobol/Visu RR Donnelly-International link
Systems collection Systems HHC devices al Basic/C/IRL billing system Maca-VB touch
screen application to record
production information and create
pallet label for finished goods.