EDI COORDINATOR

**** **** **** **** **

Email: ******@*********.**

Egbert, Ontario, L0L 1N0 Canada

Phone: 705-***-****

OBJECTIVE: EDI COORDINATOR at MAFCOTE

HIGHLIGHTS OF QUALIFICATIONS:

. Over 15 years of analysis and development experience in Distribution

and EDI.

. Perform the full EDI development cycle (850, 855, 856, 810) using

INVOVIS software, create documentation, maps, implement, test, debug,

and support the final EDI interface (ETL) between client and Trading

partners

. Create and set up mapping in both application and transaction

environments.

. Excellent written and verbal communication skills

. Continuous learner who welcomes new opportunities

CAREER HISTORY:

Kohl and Frisch (Wholesale Distribution) / (January to September 2014)

Applications Support Programmer

. User support for JBA, WMS/LogPro, data retrieval and Kohl & Frisch IBM-

i applications. Resolving IT requests from the internal user community

across Canada.

CANON Canada Inc. (Distribution) / (2011 - 2014)

Systems Developer

. I.T. Sarbanes-Oxley (SOX) Administration. Ensuring and providing

documentation for the authorization of objects, support audit requests

(IT, Tax, SOX, etc.).

. Worked on systems support team. Working with users to provide

programmed solutions with accuracy. Tasks included the split of a

service division and email report development.

. Worked on American Regional Consolidated System (ARCS) II AP team.

Moving Canadian AP accounting systems to U.S.A. Oracle system for

standardized Canon America's reporting. Programming data conversion

sent from Canada to the U.S.A.

. Worked on S21 team. Converting/mapping/testing data sent between

Canadian systems and the Canon U.S.A. S21 Parts Supply system.

GANZ / (Giftware - Distribution) / (2006-2010)

EDI Senior Programmer/Analyst

. Worked on the GANZ EDI IT team to implement trading partners through

the full EDI development cycle, create documentation, maps, implement,

test, debug, and support the final EDI interface to the (850-PO; 855-

POA; 856-ASN; 810-Invoice). Created and set up mapping using INOVIS-

Trusted Link. Allowing GANZ to accurately process and ship large

orders on time.

. Analysed vendor agreement changes for EDI implications/change

requirements.

. Created many inquiries, report and maintenance programs using RPG ILE,

as GANZ continually improved the existing systems. This gave users

more tools for proactive identification of ways to provide better

customer service; saving time and reducing costs.

CANON Canada Inc. / Contract Position / (Distribution) / (2005-2006)

Analyst/Programmer - Sarbanes-Oxley Project

DATABOROUGH / (2005)

Programmer/Analyst

JOHN WILEY & SONS, CANADA (Distribution) / (2002-2004)

Systems Analyst/Programmer

. Worked with customer purchasing to integrate EDI software into

existing workflow and computer systems. This project streamlined the

ordering process allowing John Wiley & Sons to realize cost savings

and improved accuracy in the ordering, receiving and accounts payable

process. EDI transaction types were 850, 855, 810 and 856 for multiple

trading partners.

CANPLAS INDUSTRIES LTD. (Manufacturing & Distribution) / (1998-2002)

Analyst/Programmer

. Supported CANPLAS users on the AS400/MAPICS systems. Taking calls and

emails, answering how-to questions, and debugging and resolving

program issues.

. Analysed and streamlined warehouse processes in all stages; including

order filling, order turnaround, skid loading and large orders, to

save pick and data entry time.

. Implemented (applied) CANPLAS custom RPG modifications made to MAPICS

software, to '2 upgrade' releases of MAPICS software installed.

. As a certified ISO 9001: 1994 Internal Auditor, I was on audit teams

at CANPLAS keeping manufacturing systems for the company up to ISO

standards.

. Specific EDI transaction types introduced/enhanced were 850, 855, 860,

856, & 810 using EDI Trusted Link software. The data flows in and out

of the MAPICS software package via custom RPG400 coded programs for

any specialty considerations CANPLAS customers required outside of the

normal mapping of data.

EDUCATION:

. HARDWARE: IBM I, IBM AS400, IBM S/38, ICL 2603

. SOFTWARE: EDI, Trusted Link, RPG Free, RPG ILE, RPG400, RPG III,

RPGII, CLP, Query/SQL, SYNON, OPTIO, TL ASHFORD, WORD, OUTLOOK, EXCEL,

POWER POINT, VISIO, LOTUS NOTES, Hawkeye, CYBRA MARK MAGIC Label

Software, SEQUEL Report Generator

SCHOOL

. Ryerson Polytechnic

. Georgian College RPG & Night School

PROFESSIONAL DEVELOPMENT

. EDI Implementation/Programming

. CYBRA MARK MAGIC

. ISO 9001 Internal Auditor Certification

. MAPICS

. SYNON (Case Tool)

. Oliver Wight, MRPII

. Data Base Essentials

. RPG Computer Programming

REFERENCES AVAILABLE UPON REQUEST

JOHN WILEY & SONS, CANADA (Publisher-Distribution) / (1996-1998)

Senior Programmer/Analyst

. Analysed, redesigned, programmed and implemented Physical Inventory

System. This new version reduced staffing requirements for

administration/data entry of count sheets by 4 to 5 people, speeding

up the overall process.

. Troubleshot and maintained existing Order Entry and Purchasing

systems, implementing improvements as required. Provided training to

other Programmer/Analysts as well as users on the system.

SUPERIOR PROPANE INC. (Distribution) / (1994-1996)

Systems Analyst

. Served on a development team for an Equal Payment Plan system in SYNON

that estimated the next season's delivery volume and distributed

payments over 11 installments. The system also checked midseason, the

actual consumption against the estimate, allowing adjustments to the

remaining payments. Thus finishing the heating season as close to a

zero balance as possible.

. Served on a development team for the Propane Receipt and Transfer

system written in SYNON. This system controls the movement of propane

receipts and transfers between branches.

. Served on a team developing reports and inquiry programs to analyse

business efficiencies: propane levels and demands, displayed volumes

sold and forecasted order requirements. Delivery efficiency report

showed the worst 5 deliveries and indicated where improvements in a

scheduled customer routing could be made. Daily sales report inquiry

for specific day or month.

SANYO CANADA INC. (Electronic-Distribution) / (1992-1994)

Senior Programmer/Analyst

. Developed a contribution analysis system that allows management to

assess sales and profits at several levels (customer, product group,

product class and item number), and tracks customer programs affecting

contribution offered by the sales group.

. Coordinated and maintained Sanyo's EDI systems using the Premenos-

TrustedLink package. This included setup of trading partners,

translation formats and the maintenance of the RPGIII conversion

program placing orders into order entry.

. Worked on a 3 person team to develop an automatic pricing system

working with order entry, that significantly reduced the manual effort

from the order desk by pricing all orders regardless of whether the

customer had contract prices or a promo was in effect.

CCL CUSTOM MANUFACTURING (Manufacturing & Distribution) / (1985-1992)

Information System Developer

. Worked with users at 5 different plants to identify requirements and

design, develop and implement a second generation purchasing system.

. Actively participated on a continuous improvement team that examined

existing procedures with recommendations for streamlining; reducing

stock picking time by 30%.

Contact this candidate