SUMMARY:

• 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.

TECHNICAL SKILLS:

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/ecommerce: Extol, Confidential (GXS) Trustedlink TLE/TLW/TLI, Gentran/400, Gentran Server/Director/Windows, Visual Mapper, Catalyst, STMap, Workbench, EZConnect, CLEO, BizManger, BizConnect, Trailblazer, LX/ECM, M3/MOVEX -MEC

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

PROFESSIONAL EXPERIENCE:

Sr. RPG/ILE/EDI Developer

Confidential, Chicago, IL

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

Responsibilities:

• Developed RPGLE programs and Gentian 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

Confidential, Oakbrook, IL

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

Responsibilities:

• 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 and SQL-DDL to create/alter/drop SQL database.
• Designed/Developed XML based shipments documents to support interfaces with Mercury GateTMS
• Utilized socket API’s to support warehouse automation interfaces - Sorters, scanners, labelers

EDI Consultant

Confidential, Milwaukee, WI

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, Confidential Fourth Shift ERP

Responsibilities:

• 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

Technical Consultant

Confidential, Chicago, IL

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

Responsibilities:

• Developed Functional and Confidential mapping specification to integrate SAP Point-of-Sale system to MOVEX/M3 ERP
• Developed Functional and Confidential 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 systems with M3
• Conducted Confidential at several Confidential Clients.
• Managed EDI outsourcing activity. Developed and certified standard XML based M3/MEC maps with SPS commerce (810,832,846, 850,855 and 856).

Sr. RPG/ILE Developer

Confidential, Westmont, IL

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

Responsibilities:

• 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

Confidential, Morton Grove, IL

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

Responsibilities:

• 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 and error resolution documentations.

Sr. System Analyst

Confidential, Northbrook, IL

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

Responsibilities:

• 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 Confidential, 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

Confidential, Downers Grove, IL

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

Responsibilities:

• 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

Confidential, Aurora, IL

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

Responsibilities:

• 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

Confidential, Oakbrook, IL

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

Responsibilities:

• 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

Confidential, Grand Rapids, MI

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

Responsibilities:

• 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 Consultant

Confidential

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

Responsibilities:

• 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.
• 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

Confidential, Vernon Hills, IL

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

Responsibilities:

• 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

Confidential, El Paso, Texas

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

Responsibilities:

• 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

Confidential, Tucker, Ga

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

Responsibilities:

• 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 Confidential 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

Confidential, Cincinnati, OH

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

Responsibilities:

• Utilized SQL/RPG/ILE/Free stored procedures, Programs/service programs, modules-sub procedures to integrate web-based and iSeries based applications.
• Designed and developed several enhancements for BPCS/LX (ORD, PUR, PRO, INV, GL)
• Integrated QuickTrac - Screen Integrated Handheld Data Collection tool with BPCS/LX
• Integrated Web Based Order Configurator (BuyDesign) with BPCS/LX.

EDI Developer

Confidential, Kansas City, Mo

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

Responsibilities:

• Responsible for mapping EDI X12/IDOC on TLI v3.2.(810/INVOIC, 850/ORDERS,855/ORDRSP, 856/SHPMNT)
• Input to outbound EDI maps-IDOCS are transferred from SAP to EDI system.Output from inbound EDI map-IDOCS are transferred from the EDI to SAP System.

EDI/BPCS Developer

Confidential, DuBois, PA

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

Responsibilities:

• Assist in client effort in Implementing EDI for the first time.
• Responsibilities includes installation of EZConnect EDI software, VAN communication, partner setup, design and development of all processes, mapping, FTP scripting, XML schema and integration programs with ERP BPCS/LX
• Responsible for mapping in EZConnect Documents- Inbound X12-850 to XML, and outbound XML .
• Support migration of PRMS and BPCS/CD to BPCS/LX and retrofit Vertex Tax System interface.
• Implemented FastFax BPCS/LX Integration module to automatically fax and/or email EDI report.

EDI Consultant

Confidential, Peoria, AZ

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

Responsibilities:

• Responsible for mapping X12 messages 810, 850 and 832.
• Reverse engineering of existing X12 maps(810, 850,832) and RPG/ILE programs and created mapping specifications for SAP EDI Team

EDI/BPCS Developer

Confidential, Des Plaines, Illinois

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

Responsibilities:

• Assist in client migration effort from EDI-TLI & ERP-BPCS systems to SAP.
• Extract; transform BPCS/LX Application Data based on SAP requirements. Upload to SAP staging tables
• Reverse engineered existing X12 maps (810,850,856,860,820,869,870,852) customizations. Created functional specifications for use in the migration effort from TLI to Seeburger EDI.
• Responsible for day-to-day support for ERP and EDI in Confidential multi-location environment,
• Developed custom forms using iSeries AFP and overlays.

EDI Developer

Confidential, Franklin Park, IL

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

Responsibilities:

• Assist in migration efforts from Gentran/S370 to iSeries Extol EDI software.
• Responsibilities includes installation of Extol, VAN communication, partner setup, design and development of all processes, mapping and FTP scripting
• Responsible for mapping EDI messages (810,850). Used existing Gentran/370 mapping as specification for new maps in Extol.
• Designed and developed programs and FTP scripts to exchange EDI data between iSeries and IBM-S370.

EDI Developer

Confidential, Lewis, KS

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

Responsibilities:

• Assist in client migration efforts from TLI V3.2.01 EDI migration to SAP/EDI software.
• Reverse engineered existing maps (810,850,856) and RPG/ILE customizations. Created technical specification for use by the SAP/EDI team.

EDI Developer

Confidential, Elk Grove Village, IL

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

Responsibilities:

• Responsible for mapping, testing and implementation of EDI transactions (810,850,855,856).
• Developed BPCS/LX-EDI integration programs. Educated and trained staff of assigned business areas on EDI applications and TLi /v54.

EDI Developer

Confidential, Grand Rapids, MI

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

Responsibilities:

• Assist in client migration efforts from Gentran/400 to Extol EDI software.
• Responsible for mapping EDI messages (810,850,856). Used existing Gentran/400 mapping as specification for new maps in Extol. Assist in migration from BPCS V6.1 to BPCS V8.2. Retrofit BPCSv61 customization in v8.2.

Sr. RPG/ILE Developer

Confidential, Elgin, IL

Environment: JD EDWARDS One World, Quadrant FastFax

Responsibilities:

• Integrated Quadrant FastFax software with JDE/OneWorld to support auto faxing and emailing of JDE purchase orders, acknowledgements and invoices to suppliers and vendors.

EDI Developer

Confidential, Saint Charles, IL

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

Responsibilities:

• Assist in client efforts in supporting consignment inventory processing with suppliers via EDI transactions - 861 (Receiving Advice), 867 (Consumption), 820 (Payment Order / Remittance Advice), 846 (Inventory Inquiry / Advice) and 856 (ASN) EDI transactions.
• Responsible for mapping (861,867,820,846,856). Design and development of integration programming in RPG/ILE/Free.

Sr. RPG/ILE Developer

Confidential, Lisle, IL

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

Responsibilities:

• Utilized SQL/RPG/ILE/Free and RPG2SQL integrate iSeries, Sun based applications.
• Re-design and build six (6) interfaces between BPCS/LX and Metrix. Metrix is Confidential field service and repair software application running on Confidential SUN computer using the Oracle database. The existing interfaces were with Oracle ERP applications running on the same SUN computer. All Oracle ERP applications were migrated to BPCS, hence the requirement to re-design and build the interfaces.

Sr. RPG/ILE Developer

Confidential, Shelby Township, MI

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

Responsibilities:

• Utilized SQL/RPG/ILE/Free to integrate QuickTrack, TL Ashford and iSeries based applications
• Designed and Developed production reporting application, Integrated QuickTrac Screen Integrated Handheld Data Collection tool with BPCS/LX.
• Designed and developed enhancements for BPCS/LX (ORD,INV)
• Utilized T.L. Ashford for label generation during production reporting

EDI Developer

Confidential, Northbrook, IL

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

Responsibilities:

• Designed and developed BPCS/CD integration with EDI TLi/v32
• Responsible for mapping, testing and implementation of EDI transactions (810,850,856)

Sr. RPG/ILE Developer

Confidential, Lincolnshire,IL

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

Responsibilities:

• Utilized SQL/RPG/ILE/Free for BPCS/LX Enhancements
• Designed and developed enhancements for BPCS/LX (RMS, OLM, PUR,ORD,INV)

EDI Developer

Confidential, Ann Arbor, Mi

Environment: TLE/Windows and STmap

Responsibilities:

• Responsible for installation of TLE/Windows, VAN communication and partner setup
• Responsible for mapping, testing and implementation of EDI transactions (810,850)
• Educated company’s staff in EDI software TLE/STMAP and TLE for windows.

EDI Developer

Confidential, Milwaukee, WI

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

Responsibilities:

• Assist in client effort in Implementing EDI for the first time.
• Responsibilities includes installation of TLi/v50 EDI software, configuration, VAN communication, partner setup, design and development of all processes, mapping, FTP scripting and integration programs with CA-PRMS
• Developed questionnaire and survey forms to initiate EDI with suppliers and vendors.
• Educated company’s staff in TLi/v50

EDI/BPCS Developer

Confidential

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

Responsibilities:

• Assist client efforts in upgrading ERP from BPCS/CD to BPCS/v61, EDI migration from Gentran/400 to TLE/ NT.
• Responsible for installation of TLE/ NT, Mapping, AS2, FTP scripting, VAN communication and Partner setup.
• Responsible for mapping, testing and implementation of EDI transactions (810,830,850,856,862). Used existing Gentran/400 mapping as specification for new maps in TLE/Workbench
• Retrofit BPCS/CD customization into BPCS/LX, designed and developed forms and labels in EZ/Print.
• Designed and developed programs to create and distribute EDI reports via email.

EDI/BPCS Developer

Confidential, Carol Stream, IL

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

Responsibilities:

• Assist in client efforts in upgrading ERP from BPCS/CD to BPCS/v61, EDI software from TLi/v32 to v61 and Implementation of new Inventory Management system.
• Responsible for mapping EDI messages (810,850,856).
• Designed and developed BPCS/LX integration with EDI TLi/v61 and Inventory Management System (eKanban).
• Retrofit BPCS/CD customization into BPCS/LX
• Prototyped BIZTALK and EXTOL EDI Software

Project Manager

Confidential, Chicago, IL

Responsibilities:

• Performed Project Management, Recruiting, Job Estimation and Technical Consultant Functions.
• Developed BPCS/LX Millennium Toolkit Kit
• Developed RPG/400 and AS/SET tool kit for BPCS/CD

Senior Software Engineer

Confidential, Chicago, IL

Responsibilities:

• Participated in development of AS/SET ADK product (iSeries based CASE Tool)
• Participated in development of AS/SET REV products.(RPG/400 Reverse Engineering Tool)
• Participated in development of BBM (iSeries based Spreadsheet - Business and Financial Modeler).
• Participated in development of BIR (iSeries based BPCS Report Writer).
• Participated in development of BEM (iSeries based BPCS Electronic Mail)

IT Manager

Confidential, Houston, TX

Responsibilities:

• Responsible for operational and programming functions of MIS department.
• Purchased, installed and migrated S/34 to S/36.
• Designed and developed on-line rental information management system.