Rpg Iseries

Over twenty years of progressively responsible MIS experience in technical project management, design, programming and implementation of diverse applications on IBM Midrange Computers (AS/400.iSeries) utilizing RPG/ILE/Free, Embedded SQL and stored procedures.

Over fifteen years of experience in EDI/e-Commerce; Data Mapping, Trading Partner management. EDI Software Installation, implementation, migration and upgrades. Proficient with several EDI translators, VAN, AS2, FTP, ANSI X12/EFIDACT and XML standards.

Excellent business and analytical skills. Solid ERP experience; mission critical technical specialist role in several multi-site BPCS/LX ERP system implementations. Direct experience with BPCS/LX v4 through v84.

Excellent written and oral communication skills; liaison between all levels - management, users and technical staff.

Education/Training:

IBM: RPG/ILE/Free, Cobol/400, C, XML,

Sterling B2B Integrator Fundamentals v5.2.6 (60 Hours GPM, Mapping etc.) (12/2017)

Sterling Order Management System (OMS)

Microsoft: Visual Basic, .NET, Visual Studio, BIZTALK, SQL Server Manger and Management Studio

Infor: BPCS/LX – ECM/EDI, OLM, RMS M3, MEC, ION, BOD’s, API, Web Service

Misc.: C, XML, Java, Unix, AXWAY–B2BI.

University of Illinois at Chicago Industrial Engineering, 1976-1981

Technical Skills Summary

Hardware

AS/400, iSeries

Languages

RPG/400/IV/ILE/Free, CLP/400/ILE, SQL/400

Tools

AS/SET, AS/Vision, Query, SQL, Print, Designer, Formtastic, RPG2SQL, FTP, PDM, RLU, SDA, Crystal Reports, BIR, BBM, BEM, TURNOVER, Abstract/Probe (APLUS), THENON, MKS, WDS Client for iSeries

ERP Packages

BPCS/LX, PRMS, MAPICS, Metrix, Oracle, MAC PAC, Assist, JD Edwards, BuyDesign, JDA/MMS v5.0, M3/MOVEX

EDI/e-commerce

Extol, Inovis (GXS) Trusted link TLE/TLW/TLI, Gentran/400, Gentran Server/Director/Windows, Visual Mapper, Catalyst, STMapper, Workbench, EZConnect, CLEO, BizManger, BizConnect, Trailblazer, LX/ECM, M3-MEC, Sterling B2B Integrator

Database

DB2/400, SQL Tables, Triggers, Stored Procedures and Functions

Exposure to

CGI, CGIDEV2, Java, BIZTALK, ROBOT, HTML, XML, Visual Basic, MS-Access, TL Ashford., C, Cobol/400, SSIS, HP9000, RS6000, TOAD, XMLSpy, Alliance XML/400, JBA, PKMS

Misc.

OS/400, Windows, Unix, MS-Project, Outlook, Word, Excel, Visio, Tech scheduler, ARIBA, ODBC, SOX, SPS Commerce

Senior Consultant – Suncast Corporation (02/2020 – Present) Batavia, IL

Suncast Corporation provides wood structures and resin products.

Environment: iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, TLI/v64 Visual Mapper.

Develop, design, and deploy new applications and enhancements to existing applications.

Responsible for mapping, testing and implementation of EDI transactions (810,850,855,856,204,210,214).

EDI Consultant – Pylon Manufacturing (12/2019 – 02/2020) Deerfield Beach, FL

Manufactures, designs, and markets wiper blades for the automotive industry.

Environment: BPCS/ERPLX V834, iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, EXTOL, IBM Sterling B2B Integrator V6.02 and Map Editor V8.03, Infor Warehouse BOSS

Member of the project team responsible for the migration of EDI Tool EXTOL to IBM Sterling B2B Integrator

Project involves migrating 22 trading partners trading EDI documents 810, 812, 816, 820, 824, 830, 830, 850, 852, 856, 860, 861, 862, 862, 864, 940, 943, 944,945, 947, 947

Responsible for testing, mapping and business process (BP) development,

EDI Consultant – Atkore International (06/2019 – 12/2019) Harvey, IL

Manufactures and distributes electrical raceway and mechanical products and solutions

Environment: JDE E1/World V9.2, iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, MKS/Implementer, TLI/v64 Visual Mapper.

Coordinate and participate in the end to end implementation of JD Edwards EnterpriseOne EDI projects

Implement new EDI transactions with trading partners (810,850,855,856)

Gath requirements, troubleshoot EDI related integration issues, reprocess failed transactions, and leverage the capabilities of EDI

Review, analyze, construct, and modify EDI maps including coding for complex incidents and configurations

Monitor and resolves issues with inbound and outbound transactions

Provide technical analysis and problem resolution to support requests received from internal and external customers

Translate business requirements into optimal business and technical solutions

Produce user documentation for applications developed.

Develop and maintain robust test plan and procedures

Manage multiple project timelines and resources and take ownership of EDI priorities and tasks assigned

Sr. RPG/ILE/EDI Developer – Pylon Manufacturing (09/2018 – 06/2019) Deerfield Beach, FL

Manufactures, designs, and markets wiper blades for the automotive industry.

Environment: BPCS/ERPLX V834, iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, EXTOL, Infor Warehouse BOSS

Work with executive team members, decision makers, and stakeholders to define business requirements - Develop, design, and deploy new applications and enhancements to existing applications.

Provide technical support to EDI Team,

Sr. RPG/ILE/EDI Developer – Newark Element14 (01/2018 – 08/2018) Chicago, IL

Electronic components distributor

Environment: BPCS/ERPLX V834, iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, IBM Sterling Gentran iSeries V3.5, Aldon Lifecycle Manager ISeries

Developed RPGLE programs and Gentran Map for EDI document 812

Develop, design, and deploy new applications and enhancements to existing applications.

Work with executive team members, decision makers, and stakeholders to define business requirements and systems goals

Sr. RPG/ILE/EDI Developer – ReaderLink Distribution Services (07/2016 – 12/2017) Oakbrook, IL

Largest distributor of books to mass merchandisers

Environment: RDS-ERP, iSeries, PKMS, SQL-DDL/Triggers, DRDA/SQL/RPG/ILE/Free, CLP/ILE, DB2/400, EDI Gentian iSeries V3.5

Utilized DRDA to execute SQL statements to support interface between PKMS and RDS-ERP

Developed RPGLE programs and Gentian Map for EDI document 812 - Credit/Debit Adjustment.

Developed SQL Triggers programs, used SQL-DDL to Create/Alter/Drop SQL database.

Designed/Developed XML based shipments documents to support interfaces with Mercury Gate TMS

Utilized socket APIs to support warehouse automation, developed interfaces – Sorters, scanners, labelers

EDI Developer – Badger Meter Corporation. (05/2015 – 07/2016) Milwaukee, WI

Manufacturer of products using flow measurement and control technologies.

Environment: BPCS/ERPLX V834, V6.1 iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, ACOM EZConnect EDI, IBM Sterling Gentran Director V5.5, Implementer, Infor Fourth Shift ERP

Responsible for migration of Fourth Shift ERP based EDI to BPCS/ERPLX. Migration duties include converting existing maps, building new maps and configuring trading partners (810,850,855,856,860 and 865).

Developed integration programs (RPGLE) to integrate Gentran and EZConnect EDI with BPCS/ERPLX ECM module.

Developed RPGLE programs to read, write and manipulate documents within the Integrated File System (IFS)

Utilized TNAPI – API to execute online RPGLE programs to run in batch.

Developed JSON for inbound EDI orders to support integration with Oracle CPQ (Configure, Price, Quote) module

Infor Technical Consultant – Infor. (10/2013 – 05/2015) Chicago, IL

Infor offers enterprising software solutions for customer relationship management, supply chain management, enterprise asset management and more.

Environment: MOVEX/M3 V10.1.2, Smart Office, iSeries, M3 Enterprise Collaborator (MEC), XML. SQL, Java.

Developed Functional and MEC mapping specification to integrate SAP Point-of-Sale system to MOVEX/M3 ERP

Developed Functional and MEC mapping specification to integrate Web based order processing with M3.

Developed functional and Technical Design documents for EDI Interfaces

Utilized M3 Enterprise Collaborator (MEC) API’s, Java functions, Flat File Definition, Partner Admin tool to Integrate external business documents with M3

Conducted MEC Training at several Infor Clients.

Managed EDI migration (LIASON to SPS Commerce). Developed and certified standard XML based M3/MEC maps with SPS commerce (810,832,846, 850,855 and 856).

Sr. RPG/ILE Developer - Follett Higher Education Group (02/2011-10/2013) Westmont, IL

Manages bookstores nationwide and provide management systems, support services.

Environment: iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, JDA-MMM, THENON, XML/400, APLUS

Utilized SQL/RPG/ILE/Free stored procedures, Programs/service programs and modules-sub procedures to integrate web-based and iSeries-based applications. Enhanced JDA-MMM base programs

Enhanced Credit Card application to support multi-currency.

Developed application to upload real-time MMS inventory updates in XML format to Sterling Commerce.

Developed real-time application to create/upload “e-book” web access credentials (Pin, URL to download) for digital books sold/rented though eFollet.com.

Re-wrote JDA order return application- re-designed user interface and added enhancements to support eBook processing.

EDI Technical Lead - Xylem (09/2012-03/2013) Morton Grove, IL

Provider of fluid technology and equipment solutions for water issues

Environment: iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, MKS/Implementer, BPCS/LX v8.4/ECM, PRMS, TLI/v64 Visual Mapper, Robot/400.

Responsible for migrating Company’s ERP/PRMS based EDI trading partners, transaction sets (850, 855, 856, and 810) and all EDI business functions to new BPCS/LX ECM based EDI.

Analyzed and defined requirements, created detailed technical design, developed code and unit tested as per architecture and business requirements.

Responsible for Trading partners and Partner relationships setup (GXS Trustedlink), developed translation formats and user file definitions (Visual Mapper) and controls for secure transmissions. Created user training and error resolution documentations.

Sr. System Analyst – Shell Vacations Club (02/2012- 09/2012) Northbrook, IL

Shell Vacations Club (SVC) is a points-based timeshare vacation club, focused on resort accommodations.

Environment: iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, XML, MKS/Implementer, WinSQL

Utilized SQL/RPG/ILE/Free stored procedures, Programs/service programs and modules-sub procedures to integrate web-based reservation application.

Develop, design, and deploy new applications and enhancements to existing applications.

Collaborate with the AS/400 development team, business intelligence group, and network staff to ensure smooth and reliable operation of software and systems for fulfilling business objectives and processes.

Work with executive team members, decision makers, and stakeholders to define business requirements and systems goals

Sr. RPG/ILE Developer - Hub Group (11/2011- 02/2012) Downers Grove, IL

Hub Group is a provider of intermodal shipping, highway services, and transportation management.

Environment: iSeries, SQL/RPG/ILE/Free, CLP/ILE, DB2/400, XML, MKS/Implementer, WinSQL

Utilized SQL/RPG/ILE/Free stored procedures, Programs/service programs and modules-sub procedures to integrate web-based Order Upload and Rail Billing applications with iSeries-based ERP.

Developed and executed test plans.

EDI Analyst - Jarden Corporation (08/2011- 11/2011) Aurora, IL

Provider of global consumer products with a portfolio of over 100 branded products.

Environment: iSeries, RPG/Free//ILE, CLP/ILE, DB2/400, SQL, JBA. PKMS, FTP, Gentran Server v5.2.

Troubleshoot and resolve -Gentran communication, mapping and application (PKMS, JBA) errors.

Trading Partner On-boarding (Walgreens, HSN, Pep Boys, Amazon). Responsible for mapping, testing and implementation of EDI transaction 810,850.856.

EDI Analyst - Matson Integrated Logistics (04/2010-02/2011) Oakbrook, IL

Provider of multimodal transportation and distribution services.

Environment: iSeries, RPG/CLP/ILE, DB2/400, TOAD, Oracle, SQL, Smartrac, FTP, Gentran Server v5.2, XMLspy.

Assist in client effort in outsourcing of all EDI functions to GXS Managed Services.

Developed technical specifications to standardize all electronic traded documents formats (Oracle, DB2/400, CSV, X12) to XML format.

Reverse engineering existing Oracle and DB2/400 based Gentran maps (204,210,214,322,404,410,823,990), stored procedures and RPG/ILE program. Created EDI/XML mapping specifications for offshore mapping team.

Supported all testing activity with GXS Managed Services.

Sr. RPG/ILE Developer - Renaissance Recovery Solutions LLC (01/2010 – 04/2010) Grand Rapids, MI

Provides asset recovery services to Financial & Lending Institutions, Credit Unions, and Other Lenders

Environment: iSeries, SQL/RPG/ILE/Free, Java, DB2/400, CLP/ILE, JDE/World, Great Plains MS-SSIS/.NET

Assist client’s effort in migrating from JDE/World to Microsoft Great Plains ERP.

Reverse engineered JDE customizations and custom RPG/ILE and Java programs. Created technical specification for use in Great Plain customization.

Support migration of all electronic traded documents to Microsoft SSIS Tool. Reverse engineered currently traded documents (txt, dta, pgp, eml, cvs, xml, mt, and dl) and exchange protocols (FTP, SMTP, Sockets, Fax, Email, HTTP, and HTTPS). Created technical specification and field mapping templates for use in Microsoft SSIS mapping.

EDI Technical Consultant – Inovis (now Opentext) (12/2009-12/2009)

EDI/B2B e-commerce company

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/ILE, Invois TLI/v63, VAN-Inovisworks, bTrade, Cleo, GXS Workbench

Assist Invois client in migrating from EDI GXS/Workbench to TLI/v63

Installed, configured and tested TLI/v63 EDI software.

Migrated EDI X12 maps (810,850,880) from GXS Workbench to TLi/Visual Mapper.

Developed FTP Scripts to exchange EDI Documents between TLI/v63 and AS2 software- Cleo and bTrade.

Training - EDI Best Practices, TLI Administration overview, TLI Scheduling and Job setup using API’s.

Responsible for product installation, configuration and testing – TLW and Expedite Base for Windows, GXS

Responsible for mapping, testing and implementation of EDI transaction 810.

EDI Developer - Daigger & Company, Inc. (09/2009-12/2009) Vernon Hills, IL

Distributor of laboratory equipment and supplies

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/ILE, BPCS/LX/ECM, TLI V5.4, BizManger, Ariba

Responsible for mapping EDI X12 messages (810,850,855). Performed partner setup and testing with ARIBA supplier network. Developed RPG/ILE programs to integrate EDI with ERP Package

EDI Developer - Handgards (05/2009-09/2010) El Paso, Texas.

Manufacturer/Marketer of disposable polyethylene gloves for foodservice industry to prevent food contamination.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, BPCS/LX/ECM, TLi/v3.2, TLi/v5.4, BizConnect

Responsible for EDI software upgrade - TLIv32 to TLIv54

Responsible for mapping, testing and implementation of EDI transactions (810,850,855,856,204,210,214).

Designed and developed integration programs in RPG/ILE.

EDI/BPCS Developer - CSM Bakery Supplies (11/2007-05/2009) Tucker, Ga

Manufacturer/Supplier of bakery products and lactic acid and lactic acid derivatives

Environment: iSeries, RPG/CLP/ILE, DB2/400, SQL, BPCS/LX/ECM v8.3, FTP, CIMPRO, Gentran Director/Server v5.1, Robot, Formtastic, AS2-CLEO, Turnover

Migrated from Gentran Director to Gentran Server. Responsibilities includes everything from installation, development of all process flows for EDI data, partner setups (80+), recreating/merging all maps and developing of all external scripting programs.

Deigned and developed interfaces between EDI and BPCS/LX. Installed CLEO AS2 software, created FTP, Secure FTP w/SSL and direct connections. Also used PGP encryption.

Migrated translation maps (810,812,820,824,850,855,856,864,867,875,880.940, 945).

Created Robot/400 and Gentran Process Schedulers for automated EDI processing.

Developed programs to create and distribute all EDI reports via email attachments.

Developed a set of tools to automate translation of EDI flat files to/from BPCS/LX ECM tables.

Support upgrade BPCS/LX v61 and CIMPRO to BPCS/LX v83.

Designed and developed labels and forms in Formtastic.

Sr. RPG/ILE Developer - Robbins Sport Surfaces (09/2007-11/2007) Cincinnati, OH

Manufactures and distributes maple, synthetic and specialty indoor sports flooring.

Environment: iSeries, SQL/RPG/ILE/Free, DB2/400, CLP/LE, BPCS/LX 8.2, AS/SET, QuickTrac, BuyDesign

EDI Developer - DE Laval Services LLC (06/2007-09/2007) Kansas City, Mo

Provide solution, knowledge, service and experience for http://www.delaval.com/the dairy (milk) industry.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, BPCS/LX, TLI v3.2, SAP-IDOC

EDI/BPCS Developer -Sensus Metering Systems (09/2006-06/2007) DuBois, PA

Manufacturer/Supplier of domestic, commercial water and gas meters.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, XML, BPCS/LX (405CD v6.1), ECM, AS/SET, PRMS, Vertex, EDI-EZConnect v84 and VAN-Easylink

EDI Consultant -The Antigua Group, Inc. (08/2006-09/2006) Peoria, AZ

Designer/Marketer of men’s, women’s and children’s lifestyle apparel.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, BPCS/LX, TLI v3.2

EDI/BPCS Developer -Danaher (03/2005-08/2006) Des Plaines, Illinois

Research development, production and distribution of imaging equipment for the dental market.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, BPCS/LX v6.04, ECM and TLI V3.2, Robot, MS Access, SAP.

EDI Developer - A.M Castle Metal (01/2005-03/2005) Franklin Park, IL

Provider of specialty products in bar, tube, plate and sheet to metal users.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, IBM S370, Gentran/370, Extol/400.

EDI Developer - Cross Manufacturing (12/2004-01/2005) Lewis, KS

Manufacturer of welded and tie rod cylinders, directional flow and pressure control valves

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, BPCS/LX, TLI/v32, SAP.

EDI Developer - Lawrence Foods (10/2004-12/2004) Elk Grove Village, IL

Manufacturer and supplier of bakery ingredients.

Environment: iSeries, RPG/CLP/ILE, DB2/SQL/400, BPCS/LX, TLi/v5.4, AS2-BizManger

EDI Developer - Hart and Cooley (03/2004-10/2004) Grand Rapids, MI

Manufacturer of HVAC products for commercial and residential markets.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, BPCS/LX, ECM, Gentran/400. EXTOL

Sr. RPG/ILE Developer - Continental Data Labels (02/2004-02/2004) Elgin, IL

Manufacturer of labels

Environment: JD EDWARDS One World, Quadrant FastFax

EDI Developer - System Sensor (11/2003-02/2004) Saint Charles, IL

Manufactures commercial fire detection and prevention equipment.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, BPCS/LX, ECM, TLi/V32

Sr. RPG/ILE Developer - Talaris (01/2003-11/2003) Lisle, IL

Provides accurate, efficient and secure cash handling solutions to financial institutions, commerce and government.

Environment: iSeries, Sun Server, SQL/RPG/ILE/Free, DB2/400, CLP/ILE, BPCS/LX, ECM, Oracle ERP/DB, Metrix-Uptime, Crystal Reports, RJS-RPG2SQL,

Sr. RPG/ILE Developer - American Molded Products (09/2002-01/2003) Shelby Township, MI

Manufactures a diverse array of injection molded parts and assemblies.

Environment: iSeries, SQL/RPG/ILE/Free, DB2/400, CLP/ILE, BPCS/LX v8, QuickTrac, TL Ashford

EDI Developer - Daniel Woodhead (05/2002-09/2002) Northbrook, IL

Manufacturer of devices for the control and distribution of electrical power for industry.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, BPCS/LX, EDI TLIv3.2.and TLIv5.4

Sr. RPG/ILE Developer - PURAC (07/2001-05/2002) Lincolnshire, IL

Manufactures natural lactic acid, lactates, lactitol, lactides and polylactides.

Environment: iSeries, SQL/RPG/ILE/Free, DB2/400, CLP/ILE, BPCS/LX, AS/SET

EDI Developer - Gast Manufacturing, Inc (03/2001-07/2001) Ann Arbor, Mi

Manufactures air-moving products - vacuum pumps, compressors, air motors, and gear motors.

Environment: TLE/Windows and STmap

EDI Developer - Milwaukee Valve Company (01/2001-03/2001) Milwaukee, WI

Manufacturer of valves and actuated controls

Environment: iSeries, RPG/ILE, DB2/400, EDI Inovis TLI/400-GUI eV5.0, CA-PRMS

EDI/BPCS Developer - International Wire (12/1998-01/2001) Fort Wayne, IN/Cebu, Philippines

Manufactures bare, insulated and tin-plated copper wire used in the automotive and appliance industries.

Environment: iSeries, RPG/CLP/ILE/, DB2/SQL/400, FTP, BPCS/LX, ECM, Gentran/400, TLE/NT, MS SQL Server.

EDI/BPCS Developer - Invensys Appliance Controls (07/1997-12/1998) Carol Stream, IL

Provider of components, systems, and services used in the appliance, heating and refrigeration systems.

Environment: iSeries, RPG/ILE, DB2/400, SQL, CLP/LE, FTP, BPCS/LX, ECM, AS/SET, TLi/v32, TLi/v61 eKanban

Project Manager - Pacific Systems International, Inc. (08/1994-07/1997) Chicago, IL

Technology services company delivering business solutions to its clients.

Senior Software Engineer - Infor (Formerly SSA) (06/1985-08/1994) Chicago, IL

Offers a full range of enterprise business software

Contact this candidate