iSeries AS400 RPG Developer

PHILIP SCHUYLER

● Nashville, IN ***** ● 812-***-**** ● *********@******.*** ● US CITIZEN

IT Application Developer / IT Business Analyst / Database Analyst

~ BUSINESS PROCESS IMPROVEMENT ~ APPLICATION INTEGRATION ~ CONVERSIONS ~

Highly accomplished IT Analyst / Application Developer with a proven record of completing hundreds of IT projects and exceeding expectations. Well-practiced in defining and understanding business requirements, and designing process and system improvements to increase productivity and reduce costs. Strong analytical skills with a documented ability to identify and satisfy system requirements. Great communication and interpersonal skills and highly adept at interacting with personnel and management. Trained and experienced in all phases of the software development life cycle and project management life cycle. Consistently deliver projects on time and within budget with little or no supervision. Highly experienced in all phases of project analysis, planning, development, management, testing, and implementation. Extensive experience in the development and implementation of Accounting, Financial, ERP, MRP, CRM, HR, Inventory, Logistics, Transportation and Distribution systems for all types of companies. Experienced at solving challenges with the tools at hand, and can bring unlimited expertise to bear if needed. Additional areas of expertise include:

● Process Analysis & Redesign ● Database Conversions/Migrations ● Package Implementations

● Interfaces to Third Party Apps ● Application Conversion/Re-writes ● Technical Design Specs

● Application Optimization ● Modification Removal ● Proposals and Presentations

SKILL SET:

Typical applications include complex RPG programming, SQL data manipulation, data mining, database analysis, on-demand reporting, user exit programming, stored procedures, API’s, CL/CLLE programming, XML data processing, IFS/QDLS processing, FTP data transfer, complex system to system communications, data triggers, EDI, B2B, etc.

Expert programming in RPG, CLLE, APIs on the AS/400 platform for over 20 years.

Expert in all AS/400, i5, iSeries, Power Systems programming and development utilities and change management systems.

Expert at developing and maintaining complex yet efficient database systems and services.

Trained in PC and server diagnostics/repair and setup, maintenance of desktops, laptops, servers, and rack systems.

Experienced in the installation and maintenance of many desktop, handheld and mobile devices and networking applications.

Programming Languages:

RPG (all versions), SQL, CL, JAVA, JSP, J2EE, XML, COBOL, and HTML.

Databases: DB2, Oracle, MS Access, MS SQL Server, MySQL, and Paradox.

Operating Systems: IBM i, i5/OS, OS/400, SSP, CPF, Win/NT/CE/Mobile, DOS, CPM, UNIX, Primos, PICK.

Protocols: TCP/IP, HTTP, SMTP, FTP, ANSI X.12-25, ITU/V-series, SOAP, ISDN, RS-232, SNA, and BSC.

Hardware: Power Systems, iPower, i5, iSeries, AS/400, Sys/38, Sys/36, Sys/34, x86, ARM, and PowerPC compatible devices. SatCom, RF devices, IR devices and PBX.

Enterprise Applications: InforXA/MAPICS, Infor LX-LN/BPCS, Infor S3/Lawson, Infor Infinium/S2K, Oracle/PeopleSoft/JD Edwards, Blue Yonder/JDA

Third Party Applications: Gentran, Premenos, Extol, FormSprint, TL Ashford, Hawkeye, X-Analysis, Turnover, Aldon, Robot, TAATool, Web Services, Wow (Web Object Wizard).

Business Applications: MS Office, MS Visual Studio, Eclipse, IBM WDS/Rational, MS Azure, MS Project, MS FrontPage, MS Visio, MS Access, MS Excel, Active Directory, Zoom, MS Teams, and WebEx.

Languages: English, Spanish.

EDUCATION

CompTIA/LinkedIn/Alison 2021/2022

Recent refresher courses in SQL, JSON, HTML, XML and Java. New training in Azure and Jira as well as Business Intelligence and Knowledge Management Systems.

Network Services Group Indianapolis, IN

MCSA, MCSE, MCDBA, MCP Training 2005

Indiana University/Purdue University Indianapolis, IN

Computer Science (Associates Degree), Electrical Engineering (No degree)

University of Texas Arlington, TX

Electrical Engineering (No degree) & Computer Science (No degree)

PROFESSIONAL EXPERIENCE

PS Consulting Company Indianapolis, IN

iSeries AS400 Application Developer 01/91 to Current

Clients: Jack Henry & Associates, Inc. Lenexa, KS

Remote. Responsible for third shift nightly processes and support for the tech, testing, and customer education systems in addition to online banking support for over 1500 US Banks, Credit Unions, and other financial institutions and the Data Centers.

Towne Air Freight / Forward Air, Inc. South Bend, IN

Hybrid. Assisted in house staff with help desk support and project backlog. Created custom reports. Supported customized transportation applications, EDI, and third-party systems.

Dorel Industries / Ameriwood Industries Dowagiac, MI

Hybrid. Assisted in house staff with help desk support and project backlog. Created custom reports. Supported customized MAPICS ERP applications, EDI, in house modules, and third-party systems.

Engineered Controls International, LLC / Rego Products 2012 Elon, NC

Hybrid. Fixed complex programs and customized InforXA/MAPICS ERP applications. Assisted in house staff to reduce project backlog

FKI Logistex, Inc. / Intelligrated, Inc. Cincinnati, OH

Hybrid. Assisted in house staff with defining processes to reduce inefficiency and improve process flow. Created custom reporting to highlight process backlogs, data discrepancies, and other system anomalies. Supported heavily customized MAPICS ERP applications, COBOL in house modules, and third-party systems.

Biomet / EBI, L.P. 2008/2009 Union, NJ

Fixed complex programs and customized InforXA/MAPICS ERP applications. Assisted in house staff to reduce project backlog.

RCI 2006 Indianapolis, IN

Converted J.D. Edwards’s financial database to Oracle systems to reduce errors, improve management reporting, and refine analysis.

HP Products 2006 Indianapolis, IN

Documented legacy systems and defined current processes to enable system redesign and new development.

The LaPorte Savings Bank, Inc., 2005 LaPorte, IN

Audited the banks AS/400 system, security, and disaster recovery procedures and presented them with findings and recommendations per FDIC. Assisted with new server installations and setup.

MH Governmental Systems, 2004 Indianapolis, IN

Converted legacy programs to efficient native code, Y2K fixes, and made additional process improvements and modifications.

Data Processing Services, Inc., 1999 and 2001 Indianapolis, IN

Full lifecycle development of modifications and release updates to packages. Conversions of Sys/3x legacy applications to efficient native AS/400. Created data transfer communications systems for auto auctions. Performed Y2K modifications and fixes. Systems and languages used were AS/400’s, RPGII/III/400, OCL, and CL.

USPA/IRA, 1998 Fort Worth, TX

Full lifecycle development of data transfer and telecom project between AS/400 and PCs at field offices for insurance products. Systems and languages used were AS/400, CL, RPGIII/400, data triggers, C scripting.

JVC America, Inc., 1998 Tuscaloosa, AL

Added multi-warehouse capability to custom IBM software, modifications to bill of materials, materials requisition, shipping, bar codes, inventory management, and other manufacturing/distribution modules. Completed many extensive Y2K modifications.

Staples, Inc., 1997 Framingham, MA

Performed modifications to JDA Software to allow increased retail locations during proposed merger and developed Manhattan Associates Interface to Oracle database, and S2K modifications. Systems and languages used were AS/400’s, CL, RPGIII/400, DDM, SQL, and Oracle.

Melvin Simon & Associates, 1997 Indianapolis, IN

Modified systems used for lease tracking and property development to define profitability and target performance more accurately.

Woods Industries, Inc., 1996 Carmel, IN

Analyzed and converted databases from previous systems to JD Edwards, reducing errors and correcting anomalies. Performed custom modifications to enhance functionality, and assisted with Gentran EDI data mapping.

McCormick & Associates, Inc. /Qualcomm Inc., 1993/1996 Indianapolis, IN

Assisted in the design, development, and maintenance of Transportation and Logistics Industry Software. Converted S/36 legacy applications to AS/400 native. Developed interfaces to the PBX (Octel), satellite (Qualcomm) and EDI systems (Comdata, Gentran). Clients included APL, Roadway, Consolidated Freightways, CSX, Conrail, and many others. Systems and languages used were AS/400 with RPGIII/400

PROFESSIONAL EXPERIENCE (continued)

Barry Wehmiller Design Group Indianapolis, IN

Solution Consultant 09/22 to 08/25

Remote. Installed and upgraded InforXA/MAPICS ERP solutions for various customers. Supported InforOS, Net-Link, Power-Link, and System-Link applications. Completed multiple projects interfacing with InforXA to third party applications for various clients. Used RPG Free/ILE, i5/iSeries, SQL, XML, EDI, Stored Procedures, etc.

Nasco Healthcare Inc. Saugerties, NY

Infor XA ERP Systems Lead 06/22 to 09/22

Remote. Responsible for daily system and hardware monitoring and Jira tickets for printer and user profile support.

Used RPG Free/SQLRPGLE, i5/iSeries, SQL, etc.

Jack Henry & Associates, Inc. Lenexa, KS

Senior Programmer, Advanced 04/16 to 11/21

Remote. Responsible for third shift nightly processes and support for the tech, testing, and customer education systems in addition to online banking support for over 1500 US Banks, Credit Unions, and other financial institutions and the Data Centers. Used RPG Free/ILE, i5/iSeries, SQL, Stored Procedures, etc.

Aurora Parts & Accessories, LLC., Lebanon, IN

Programmer/Analyst 04/11 to 10/11

Assisted in the development of the graphical bill of materials (GBOM) application using WOW (Web Object Wizard). Used RPG Free/ILE, i5/iSeries, SQL, XML, Java, Stored Procedures, etc.

Guide Technologies, LLC. Indianapolis, IN

Senior IT Consultant / IT Business Analyst / Application Developer 02/09 to 01/11

Hybrid. Installed and upgraded InforXA/MAPICS ERP solutions for various customers. Developed and supported Net-Link, Power-Link, and System-Link applications. Completed multiple projects interfacing with InforXA to third party applications for various clients. Used RPG Free/ILE, i5/iSeries, SQL, XML, EDI, Java, COBOL, Stored Procedures, etc.

Vitran Express, Inc., Indianapolis, IN

Application Developer / IT Business Analyst 02/07 to 07/08

File conversions. Also converted and modified custom applications to new software packages. Systems and languages used were iSeries/i5, CL, RPGIII/IV/ILE, SQL, XML, EDI, and FTP.

Biomet, Inc. Warsaw, IN

Senior Programmer / IT Business Analyst 04/01 to 07/04

Duties include removal of prior release modifications and enhancements to MAPICS modules, restoring functionality, adding offline loads, and automated processing capabilities. Programming modifications for BOSS, Infineon, TL Ashford, and created custom applications, redesigned practices, and processes, and streamlined applications for multi-company processing. Provided support for EBI, L.P., Arthrotek, Inc., Implant Innovations, Inc., Walter Lorenz Surgical, Inc. and additional Biomet, Inc. subsidiaries. Systems and languages used were iSeries, CL, SQL, RPGIV, and RPG ILE.

Ambassador Consulting, Indianapolis, IN

IT Consultant / IT Business Analyst / Application Developer 07/92 to 8/93

Performed custom programming for various clients to reduce input errors and improve process efficiency. Used RPGIV/ILE, i5/iSeries, SQL, CL, etc.

Christian Church Services, Inc. / DOC, Indianapolis, IN

Senior programmer / Analyst 04/91 to 06/92

Designed and developed an AS/400 database and fund accounting software system. Completed the conversion of System 34 remittance and redistribution package to Native AS/400. Designed and implemented Software 2000 modifications. Installed and maintained token ring LAN. System and languages used were the 3X/400, RPGII/III, OCL and CL.

Computer Generated Solutions, Inc. New York, NY

Analyst / Project Leader 01/88 to 08/89

Project lead for the special projects department responsible for full lifecycle development of custom software from presentation to installation and maintenance. Industries included manufacturing, distribution, and service. Also created programs to initiate and map PC to AS/400 ASYNC data transfer to retail locations from distributors. Created retail applications using dBase and other tools and perform system/3x to AS/400 conversions. Developed customizations for Lawson, JD Edwards, and BPCS software. Clients included WNET 13 New York, KNOGO Corporation, Liz Claiborne Inc., Estee Lauder Inc., E. J. Gitano Inc., Izod Lacoste, and Drexel Burnham Lambert. All projects included full lifecycle responsibility.

Contact this candidate