RPG Developer / Business Analyst

ANDREW JOSHUA HAY

**** ****** ***** ● Castle Rock, CO 80104 ● (678) 575–5133

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

KNOWLEDGE

TECHNICAL

AS/400 (IBM iSeries) database server, RPG and CL programming language, EDI standards, UPC/EAN hierarchy and NRF standards, TrustedLink EDI mapping software, BizManager AS2 communication software, Loftware label design software, SAP SD/FSCM modules

BUSINESS

Project management, Supply chain management, AR/AP functionality, UPC management, Apparel manufacturing, Diverse retail logistics requirements

EXPERIENCE

Summer 2010 OXFORD INDUSTRIES ATLANTA, GA

Project Manager

-Wrote technical specifications for incoming application and reporting requests.

-Increased efficiency of daily report monitoring by 25% through enhancement or elimination of existing messages.

-Assigned new programming and EDI set up tasks to three direct reports.

-Renegotiated UPC catalog contract to save 15% on annual costs.

-Acted as liaison between credit department and outside consultants during final stages of company’s conversion to SAP.

2000 – 2010 OXFORD INDUSTRIES ATLANTA, GA

Senior Programmer

-Gathered business requirements for ERP programming requests in areas including order management, inventory management, sales -analysis, billing, shipping and logistics.

-Created over 100 new applications and reports using RPG in an AS/400 environment.

-Debugged or enhanced over 500 existing ERP programs.

-Worked with over 50 internal customer service representatives to develop application or reporting solutions to meet new business requirements.

-Converted all credit screening functions initiated from existing ERP to interface with SAP.

-Wrote and executed detailed test plans per Sarbanes-Oxley guidelines.

EDI Business Analyst

-Analyzed specifications for over 100 active customers including major retailers such as WalMart, Target, Macy’s, Nordstrom, and Sears.

-Utilized TrustedLink mapping software and supported over two dozen document types ranging from purchase orders and point of sale data to invoicing and advanced ship notices.

-Saved the company nearly $20,000 in customer chargebacks through data analysis in regards to erroneous claims or compilation of best business practice documentation.

-Reviewed packaging guidelines and created or customized over 50 customer-specific shipping labels via Loftware label designer using Intermec series printers.

-Monitored helpdesk and acted as second-level support for all technical questions.

UPC Manager

-Managed selection code and NRF color/size code master tables for over 1 million active UPCs and lowered number of data discrepancies by 75%.

-Automated UPC updates to INOVIS/QRS, GXS, InterTrade, and 1SYNC data catalogs.

-Served as lead analyst for WalMart Global Data Synchronization and RFID initiative.

Summer 2000 NETWORKONE TELECOMMUNICATIONS MARIETTA, GA

Lead Programmer

-Modified existing Visual C++ code to interface Remedy Help Desk software with new billing system within two month contract period.

EDUCATION

BERRY COLLEGE ROME, GA

Bachelor of Science, Computer Science, April 2000

Berry College and Georgia HOPE Academic Scholarship

Bonner Community Service Scholarship

Major GPA: 3.8, Minor: Creative Writing

Programming Languages

Java / Visual J++, C++, HTML, Pascal, COBOL, Assembly Language

Contact this candidate