Guy L Henza

acqm4r@r.postjobfree.com

OBJECTIVE I am seeking a full time position as a PROGRAMMER/ANALYST, where I can use my ten plus years of experience to solve business problems.

Job Titles Senior Programmer/Analyst, Application Developer, Systems Coordinator, Operations Business Analyst, Consultant

SUMMARY I have over ten years of experience in the design and maintenance of business applications. My skills include analysis, design, development, implementation, migration, testing, documentation, training, and user support.

HARDWARE IBM AS400/iSeries (10+ yrs.), IBM Mainframe, IBM compatible PCs.

SOFTWARE IBM AS400/iSeries: IBM (RPG/IV/400/III/II, ILE, PDM, DFU, SDA, SEU, Query/400, SQL, M Q Series), INFOR (BPCS, AS/SET, PRMS), EDI (Future Three (ARS), Harbinger Trusted Link Enterprise, Sterling Commerce (Gentran)), Falk Technologies (dcServ), ProData (DBU), T.L.Ashford (Barcode printing), gba (FAMS), Lakeview Technologies (MIMIX, iTera), Help Systems (ROBOT, ALERT, CONSOLE), Turnover, Implementer, Alliance, TestBench.

PC: MSCP Windows NT server, workstation and TCP/IP, also knowledgeable in MS Excel, MS Word, MS Internet Explorer, MS Outlook, and IBM MQSeries.

APPLICATIONS Financial: Accounts Payable, Accounts Receivable, General Ledger, and Fixed Assets.

Distribution: Distribution Requirements Planning, Order Entry, Sales Order Analysis, and Shipping.

Manufacturing: Material Requirements Planning, Master Production Scheduling, Shop Floor Control, Bill of Materials, Inventory Management, Purchasing/Receiving.

Other: Automotive Release, EDI, CIGMA.

EDUCATION Bachelor of Science in Business Administration from Lawrence Technological University, Southfield MI.

WORK EXPERIENCE (10+ years)

05/15 – Present Consultant – NTT Data

Client company –Mohawk Ind, Calhoun GA

Environment: Two IBM AS400/iSeries, RPG/IV, RPG ILE, free format.

Responsible for iSeries RPG programming;

09/14 – 03/15 Consultant – EDI Specialists Inc, Raynham, MA

Client company –Anagram International, Eden Prairie, MN

Environment: Four IBM AS400/iSeries, RPG/IV, RPG ILE, free format, JBA, BPCS 5.3, S2K, IBM Rational Developer for i.

Responsible for iSeries RPG programming; new and maintain EDI programs, setup and maintain trading partners in Trusted Link. Implemented new programs and mappings for (X12(810, 850, 856, 860, 864), EDIFACT(ORDERS, DESADV, INVIOC), Tradacom(ORDFL, DELFL, INVFL)).

Created an RPG SQL program that creates XML on the IFS.

08/13 – 07/14 EDI Applications Developer – CSM Bakery Products, Tucker GA

Environment: Two IBM AS400/iSeries, RPG/IV, RPG ILE, free format, BPCS LX 8.3, Gentran Server For Windows 5.3.1.

Responsible for iSeries RPG programming; new and maintain EDI programs, setup and maintain trading partners in Gentran and VL Trader.

01/13 – 08/13 Consultant – ICONMA, Troy, MI

Client company – Oceanic Time Warner Cable, Mililani, Hawaii.

Environment: Single IBM AS400/iSeries/p550, RPG/IV, RPG ILE, free format.

Responsible for iSeries RPG programming; Promotion Automation project, Promotion: PPROPPV Missing records project.

01/12 – 01/13 Consultant – UST-Global – Systems Analyst

Client company – Bank of America – Addison TX – Case Management/L3 Production Support.

Environment: Multiple IBM AS400/iSeries, RPG/IV, RPG ILE, Turnover, DBU.

Responsible for Level 3 support ofiSeries, MST (Mortgage Servicing Technology), FTD (Flood Tracking System), ASIS (Account Status Information System), CMS (Customer Marketing Services), LOB (Line of Business) File processing, CSHB (Customer Service Home Base), HOD (Host on Demand), LACS (Loan Administration Chase Screen), LADI (Loan Administration Documentation Interface), LAFA (Loan Administration Follow up), LAS, LHIS (Loan History Information System), SRM (Service Request Manager), Maximo Change Management.

08/10 – 12/11 Consultant – Keane, an NTT DATA Company, Siler City, NC 27344

Client company – Blue Cross Blue Shield of Vermont – i5Systems Engineer.

Environment: Multiple IBM AS400/iSeries with multiple LPARs, iTera, RPG/IV, RPG ILE, Turnover, DBU, Alliance, TestBench.

Responsible for installing, configuring, and maintaining operating system workstations and servers, including web servers, in support of business processing requirements. Performs software installations and upgrades to operating systems and layered software packages. Schedules installations and upgrades and maintains them in accordance with established IT policies and procedures. Monitors and tunes the system to achieve optimum performance levels. Ensures workstation/server data integrity by evaluating, implementing, and managing appropriate software and hardware solutions. Ensures data/media recoverability by implementing a schedule of system backups and database archive operations. Supports media management through internal methods and procedures or through offsite storage and retrieval services. Develops and promotes standard operating procedures. Conducts routine hardware and software audits of workstations and servers to ensure compliance with established standards, policies, and configuration guidelines

Maintained production and development systems for over 500 users and programmers.

Maintained ROBOT Scheduler, CONSOLE, Replay, Reports and Network for production and development systems.

Wrote, maintained and reviewed CL’s for uses in ROBOT.

Upgraded software products as needed.

Converted fourteen programs to use IBM overlays *OVL.

Automated the coping of selected production data to development system.

06/10 – 07/10 Consultant – Quality Spring / Togo, Coldwater, MI

Environment: IBM AS400/iSeriess, Mapics, F3, Trusted Link

RPG programming, customer setup in F3 and Trusted Link.

05/10 – 06/10 Consultant – REMEDI Electronic Commerce Group, Columbus, OH

Client company – Lang Holdings, Wisconsin.

Environment: IBM AS400/iSeriess, J.D.Edwards,

Map 832 and 846 transactions from JDE to Gentran using SQL stored procedures.

06/09 – 12/09 Consultant – AAA Consulting, Farmington Hills, MI

Client company – Carhartt, Dearborn, Michigan.

Environment: IBM AS400/iSeriess with multiple LPARs, RPG/IV, RPG ILE, CMS, PkMS, SAP, Aldon Lifecycle Manager (CMS) and MS Project WEB Access

Wrote Conceptual Design Documents, Technical Design Documents, Unit Test Plans, RPG ILE programming, DDS screen designs with subfiles, PRTF printer files, and new PF physical and LF logical files

Projects included Consumer Product Safety Compliance, Sortation Bypass, and PKMS Integration into SAP

10/07 – 01/09 Consultant – CES, MI

Client company – Denso International, Southfield, Michigan.

Environment: Multiple IBM AS400/iSeries, RPG/IV, RPG ILE, Turnover, T.L.Ashford, CIGMA, J.D.Edwards, DBU, Gentran, Future Three

Wrote Chrysler 864, Honda 856 report and Ford Mixed-Master Load List with barcodes. Worked with users and Plant Controllers’ setting up customers on New CIGMA software converting them from Future Three to Gentran. Debugged and modified programs to fit users’ requirements.

10/06 – 09/07 Consultant – Capgemini/Kanbay/Adjoined

Client company – Belden Wire & Cable, Richmond, Indiana

Traveled to client sites in Montreal Canada, SC and IN to perform programming as needed. Converted literals to message file for multilingual support using AS/SET. Set up EDI trading partners and transaction sets 810, 846, 850, and 888 in Harbinger Trusted Link Enterprise using FTP for 3PL conversion. Wrote interface programs for 846 and 888 transactions in RPG ILE.

07/06 – 09/06 Consultant – SPSI, Inc.- System & Programming Solutions, Wauwatosa, WI

Client company – Promega, Fitchburg, Wisconsin

Wrote new security programs to satisfy auditor’s needs. Debugged allocation errors in BPCS SFC and ORD modules. Wrote new customer warehouse subsystem for BPCS.

05/06 – 07/06 Consultant – ESM Group LLC, Novi, MI

Client company – AISIN, Plymouth, Michigan.

Environment: Single AS400/iSeries, RPG/IV, RPG ILE, JBA, F3.

Modified F3 interface programs, wrote SQLRPGLE programs to FTP to client PC.

09/05 – 05/06 Tristate Hospital Supply, Howell, Michigan

Environment: Multiple IBM AS400/iSeriess, RPG/IV, RPG ILE.

Responsible for receiving EDI transmissions using Sterling Commerce (Gentran) software. Using EDI 850 PO, 856 ASN, 810 invoicing, 852 Product Activity Data, and 867 Product Transfer and Resale Report. Setup trading partners, debugged transmission problems.

Responsible for receiving and installing IBM PTFs and custom programming.

05/04 – 09/05 Consultant – Tech Serv, MI

Client company – Johnson Diversey, Southfield, Michigan.

Environment: Multiple IBM AS400/iSeriess with a VPN across North America and Canada, RPG/IV, RPG ILE, BPCS, PeopleSoft (J.D. Edwards), and Extol (Harbinger), Implementor.

Analyzed user request for software modifications and customization's.

Develop work plan and coordinated with other programmers to meet user’s request.

Performed application development, database enhancements and/or modifications, unit and system testing, implementation and support for identified projects.

Wrote the BPCS side of inventory transfer from BPCS to JDE.

Wrote sales analysis reports for commission processing.

Modified EDI programs for 810 Invoice, 850 PO and 867 Product Transfer transactions. Wrote new programs for 204 Motor Carrier Load Tender, 846 Inventory Inquiry, 940 Warehouse Shipping Order, 943 Warehouse Stock Transfer Shipment Advice, 944 Warehouse Stock Transfer Receipt Advice and 945 Warehouse Shipping Advice transactions. Worked with external partners; Aramark, DSSI, Molson, Nistevo, PFG (K.O.Lester), Premier, UTI, Velocity and Via Rail.

10/03 – 05/04 Consultant – Sapphire, Troy, MI

Client company – Denso International, Southfield, Michigan.

Environment: Multiple IBM AS400/iSeriess, RPG/IV, RPG ILE, BPCS, J.D.Edwards, DBU

I wrote a interactive program to read BPCS files and write JD Edwards customer order. It included multiple sub-files and security modules that insured the user only had access to the customers that they were assigned.

12/01 – 9/03 Operations Business Analyst, Archway Cookie Company/ Parmalat Bakery Group, N.A., Battle Creak Michigan.

Environment: IBM AS400/iSeriess, RPG/IV, RPG ILE, BPCS, DBU, Turnover.

Installed software package BPCS in Perry NY and Cincinnati OH offices.

Responsible for receiving and installing BPCS BMR’s and custom programming.

Responsible for the internal technical training, documentation and troubleshooting.

implemented BPCS at a newly acquired bakery in Perry NY. I trained users and wrote custom reports on Shop Floor, Inventory, Forecasting and order entry.

08/98 - 11/01 Senior Programmer/Analyst, Rieter Automotive North America, Farmington Hills, Michigan.

Environment: Multiple IBM AS400/iSeriess with a WAN across five states and Canada, RPG/IV, RPG ILE, BPCS, dcServ, Future Three, FAMS, EDI, T.L.Ashford, MIMIX, DBU and COGNOS.

Installed software packages gba (FAMS), Help Systems (ALERT and CONSOLE) and COGNOS.

Responsible for receiving and installing IBM PTF’s and version upgrades, BPCS BMR’s, Future Three updates and new OEM modules, dcServ updates and version upgrades, FAMS updates, ALERT and CONSOLE updates and version upgrades.

Researched, designed, developed, and maintained Future Three Interface ARUPDT and INVUPDT interfaces to BPCS correctly.

Setup and maintained security for AS400/iSeries, Future Three, BPCS, dcServ, FAMS, DBU and COGNOS.

9/97 - 08/98 Application Developer, Future Three, Northville, Michigan.

Environment: Multiple IBM AS400/iSeriess using RPG/IV/III, RPG ILE.

Researched, designed, developed, and maintained Future Three Interface Tool on an IBM AS400/iSeries using RPG/IV with RPG ILE.

Worked with various platforms and applications including J.D. Edwards, MAPICS, CA-PRMS, BPCS, and JBA to integrate them with Future Three using the Interface Tool.

Assisted the HelpLine in resolving customer problems involving the Interface Tool.

Visited customer sites to install software and resolve customer issues.

08/88 - 09/97 Systems Coordinator, Elopak, Inc., New Hudson, Michigan.

Environment: Single IBM AS400/iSeries using RPG/IV/III, RPG ILE, CA-PRMS, ROBOT, DBU.

Created new programs and modified CA-PRMS programs, such as Order Entry, Inventory, Product Structure, Accounts Payable, General Ledger and NAFTA tracking in RPG/400 and CL on an IBM AS400/iSeries using PDM and SDA.

Installed IBM AS400/iSeries PTFs and upgrades to the system.

Responsible for the user support for both software and hardware.

Created and maintained device descriptions.

Installed 5494 controllers, workstations, and printers converting from twinax cabling to twisted pair cabling.

Contact this candidate