Warren Thompson

• Designed, wrote, and maintained loan servicing, insurance, flood zone certifications, mobile home manufacturer/dealer/community financing applications, with programs, service programs, CL commands, SQL functions & stored procedures, and web applications in RPG-IV (free format), SQL, CL, RPGsp. Sole support for a Java SOAP web service interface to the primary insurance carrier
• Developed application architectural patterns for developers, including data queue services, transaction processing with bulk cursor fetching, and commitment control for improved application performance.
• Performed DBA responsibilities, setting DB standards, reviewing & optimizing SQL performance, mentoring developers
• Implemented and managed change management and delivery with Rocket RDOi (Aldon LMi, ACMS), customizing its processing to enhance workflow.
• Managed DevOps tools for IBMi team: VSCode, RDi, X-Analysis, ACS
• Championed use of git and Javascript across teams on multiple platforms, creating web socket listener for IBMi web applications to securely execute commands on users' PCs.
• Developed software and reporting to meet auditor requirements, including a highly optimized system to check for, and safely handle, SQL injection and other potentially hazardous content
• Configured Single Sign-On [SSO] on IBMi, using Network Authentication Service (Kerberos) and Enterprise Identity Management [EIM]
• Taught classes in SQL, RPG, RDi. Trained and mentored new developers.
• Designed & wrote a system in C# to dynamically replicate the structure & contents of MS SQL Server database for processing loan applications into DB2 for i tables
• Technologies: IBM i, ILE RPG-IV (fully /free), CL, DB2 for i, SQL (embedded, static, dynamic, stored), QMQuery, Sequel [tm], CoolSpools, Java, Javascript, REXX, ACS, RDi (Eclipse), X-Analysis, git, VSCode, SQL Visual Explain, Rocket RDOi (Aldon LMi, ACMS), Robot, Profound Logic RPGsp, ProfoundUI, ProfoundJS, Eradani, Apache, SSO (Kerberos, NAS,EIM), SSH, PASE, Putty, MS Office, MS Access, Visio, XMLpad, CoolSpools, Wireshark

Developed and maintained insurance and loan servicing software.

• Enhanced the automotive parts warehousing and distribution system in RPG-IV.

• Analyzed and designed application enhancements for PowerMHS health insurance claims engine to improve system functionality.
• Developed SQL data access methods and optimized performance for complex queries on tables with billions of rows, ensuring data accuracy.
• Designed database models to support application requirements, featuring stored procedures and SOA interfaces with MQBroker.
• Primary assignment on an accuracy project estimated to save $400M/year.
• Documented specifications and processes for large zSeries project to maintain project clarity and compliance.
• Technologies: IBM iSeries, i5/OS, ILE COBOL, ILE RPG-IV (/free), CL, DB2/UDB for i, SQL (embedded), QMQuery, REXX, PDM, WDSC/i, MQ Series, SQL Visual Explain, Aldon-CMS, Robot, MS Office, MS Access, Visio, zSeries, TSO, Test Director.

• Analyzed, designed, developed, and tested enhancements to multi-tier client-server customer service application for national cell phone company serving 55 million subscribers, improving user experience and service efficiency.
• Troubleshot and developed solutions for trouble tickets from IT control and production support, ensuring timely resolution of issues.
• Interfaced applications using XML-defined enterprise information bus, facilitating seamless data exchange across systems.
• Technologies: IBM iSeries, i5/OS, ILE RPG-IV (/free), SQL (including embedded), CL, REXX, PDM, OpsNav, MS Office, Visio, Turnover, Robot, XML.

• Converted supplemental insurance policy information database files, programs, screens, and reports to flexible database design, enhancing data management capabilities.
• Designed and wrote subfile data entry and maintenance program for tracking insurance loss control.
• Facilitated client transition to RPG-IV, enabling improved programming efficiency and system functionality.
• Technologies: IBM iSeries, i5/OS, RPG/400, ILE RPG-IV, SQL, CL, DDS, PDM, OpsNav.

• Provided programming, analysis, design, and consulting services to a diverse portfolio of clients:
• ITW Philadelphia Resins Corp. – Montgomeryville, PA: Delivered multiple projects for chemical manufacturing plant using MAPICS (ERP), including rewriting Bill of Lading and developing utility to redirect and reprocess spool files. Provided system administration support. Technologies: IBM iSeries, i5/OS, RPG/400, ILE RPG-IV, CL, DDS, PDM, OpsNav, MS-Office, Visio.
• MG Industries, Inc. – Malvern, PA: Added major enhancements to custom-made Client & Sales Prospect Tracking application for industrial and gas products using Lotus Notes/Domino. Completely revamped look and feel using new features of Notes version 6. Technologies: Lotus Notes/Domino, MS-Office, Visio, LotusScript.
• Xonex, Inc. – New Castle, DE: Designed and developed central data warehouse merging data from distinct business applications, integrating warehouse data to support Lotus Notes business integration system. Technologies: Lotus Notes/Domino, IBM iSeries, i5/OS, ILE RPG-IV, CL, SQL, MS-Office, Visio, LotusScript.
• Siemens Health Services, Inc. – Malvern, PA: Analyzed and designed interfaces for internal and external packages to mainframe for hospital-based physician billing. Led team of seven on Y2K project, analyzing, correcting, and testing over 300k lines of code in under two months. Served as System Administrator and coordinated operations staff; engaged multiple times for follow-on projects. Technologies: IBM iSeries, i5/OS, ILE COBOL, CL, DB2/UDB for i SQL, DDS, REXX, PDM, OpsNav, DSPF Subfiles, MS-Office, MS-Access, VBA, Visio, Perl, ROBOT.
• Continental Life Insurance Co. – Upper Darby, PA: Maintained and enhanced in-house insurance software system. Served as System Administrator for AS400, PCs, and local network. Technologies: IBM iSeries, i5/OS, ILE RPG-IV, RPG/400, CL, SQL, DDS, PDM, OpsNav, DSPF Subfiles, MS-Office.
• Cabrini College – Radnor, PA: Developed financial applications and provided systems administration support. Re-engaged multiple times for additional custom projects. Technologies: IBM iSeries, i5/OS, ILE RPG-IV, RPG/400, CL, DDS, PDM.
• Visiting Nurses Association – Runnemede, NJ: Assisted in retiring an AS/400 system by ensuring complete database conversions from AS400 DB2 to SQL Server. Technologies: IBM AS/400, OS/400, RPG/400, SQL, CL, DDS, PDM, SQL Server.

• Conducted business analysis, designed, and developed modifications to BPCS (ERP package) and related programs to enhance functionality.
• Implemented box-level inventory, integrating it into BPCS.
• Troubleshot FR WAN communications issues and acted as System Administrator.
• Technologies: IBM AS/400, OS/400, ILE RPG-IV, RPG/400, SQL, CL, DDS, PDM, REXX, MS Office, Visio, MS-Access, VBA Access/Excel, Hitsoft ODBC, BPCS, Notes/Domino.

• Modified BPCS and other internal programs to enhance functionality and address user needs.
• Distributed AS400 data using Access and VB, ensuring timely updates returned to AS/400.
• Recommended platform change from VB to Delphi, leading to improved workflow efficiency.
• Technologies: IBM AS/400, OS/400, RPG/400, SQL, CL, DDS, PDM, REXX, MS-Office, MS-Access, VBA Access/Excel, Data Junction, Hitsoft ODBC.

• Led a team as the Team Leader, Steering Committee member, and TQM trainer for a regional consulting firm that delivered programming and analysis services to regional enterprise clients.
• Arlon, Inc. – Bear, DE: Assisted in version upgrades of BPCS (ERP) and miscellaneous applications. Enhanced purchasing software for electronics division; recalled for multiple client assignments. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, MS-Excel, BPCS.
• American Travelers Life Insurance Co. – Bensalem, PA: Led consultant team performing business analysis, systems analysis, and development to customize the USSI insurance system. Embedded within user departments to identify operational improvement opportunities. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, ADM, MS-Excel, Questview.
• Pressman Toy Co. – North Brunswick, NJ: Gathered RFP requirements and conducted business analysis for ERP system implementation. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM.
• Environment Compliance Services, Inc. – Exton, PA: Developed enhancements and interfaces for WINS insurance package. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM.
• Tokai Financial Services, Inc. – Chesterbrook, PA: Developed financial leasing applications. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, MS-Office, Visio, OS/2.
• Amkor Electronics, Inc. – West Chester, PA: Developed enhancements to manufacturing package to report order supply chain status directly to customers. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, MS-Excel.
• Provident Indemnity Life Insurance Co. – Norristown, PA: Developed replacement module for claims adjudication in USSI health insurance package. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, MS-Excel.
• Elf Atochem North America, Inc. – Philadelphia, PA: Enhanced AS/400 manufacturing package, interfacing directly to DB2 on an IBM mainframe. Technologies: IBM AS/400, OS/400, RPG/400, CL, DDS, PDM, REXX, SQL, RJE.

• Managed all enhancements and ongoing support of Payroll/HR systems.
• Designed and built fully table-driven HR/Payroll interface to ADP payroll when in-house paychecks were phased out.
• Created comprehensive explanatory data dictionary for end users.
• Technologies: IBM System/38, AS/400 CPF, OS/400, RPG III, CL, DDS, OPNQRYF, ASC-Sequel.

• Designed and wrote system for maintaining customer securities holding accounts.
• Obtained SEC Series-6 license.
• Technologies: IBM System/38, CPF, RPG III, CL, DDS, OPNQRYF.

• Established software consulting company specializing in System/38 solutions, managing technical staff and client deliverables:
• Universal Health Services, Inc. (King of Prussia, PA): Developed 401(k) module for hospital payroll system.
• McCloskey Varnish, Inc. (Philadelphia, PA): Assisted conversion from Honeywell to IBM System/38; converted hundreds of batch programs and rewrote interactive applications.
• Advanced Cybernetics, Inc. (Wyomissing, PA): Developed new modules for PARIS retail store management package conversion from S/34.
• Geometric Data, Inc. / SmithKline (Devon, PA): Designed instrument configuration management system interfaced to MAPICS to comply with FDA requirements, tracking component revisions across planning, manufacturing, and hospital deployment.
• MAACO (King of Prussia, PA): Built entire General Ledger system; rewrote complex templates into PL/I and trained staff.
• V.I.Z. Manufacturing, Inc. (Philadelphia, PA): Redesigned and developed flexible benefits system to enhance payroll system.
• Betz Laboratories, Inc. (Trevose, PA): Managed System/38 maintenance programming during corporate conversion to HP3000 across customer service, accounting, distribution, sales, and commissions, using Cognos Powerhouse to deliver inquiries and reports.
• Technologies: IBM System/38, CPF, RPG III, COBOL, PL/I, CL, DDS, MAPICS, HP-3000, FORTRAN, Cognos Powerhouse.

• Customized and installed integrated manufacturing package, working with management to modify order entry, production, inventory control, and general ledger.
• Technologies: IBM System/38, CPF, RPG III, CL, DDS.

• Developed and maintained manufacturing and business software applications.
• Technologies: IBM System/370, DOS/VS, COBOL, RPG II, JCL.