Experience

Rockford Ball Screw

• United States
• Machinery Manufacturing
• 1 - 100 Employee

• IT Manager

  • Nov 2017 - Present

  Designed & Implemented shop floor labor tracking using .NET and SQLRPGLE. Developed applications using system link to push and pull data from INFOR's XA (MAPICS) MRP system. Partitioned the IBMi to isolate the business system from developers and customers. Installed and configured iCluster DR software to update data in near real time on backup IBM i. Used TLAshford to design bar code labeling solutions and redesign stale canned XA reports. integrated multiple shop floor machines with IBM i to enable near real time data access to the complete manufacturing process. Moved Enterprise email solution to Office 365. Replaced existing Microsoft server hardware with VM's using CISCO servers and VMWARE. Installed and maintain CISCO firewall and FirePower to ensure secure and readily available remote access to the business system. Moved Enterprise documents from IBM i (AS/400) to Microsoft Windows 2016 file server. setup and maintain printer server and access to file server using Microsoft AD and group policies. Wrote multiple external procedures using RPGLE and/or SQLRPGLE to enable rapid deployment and standardization of enterprise applications. Show less



Code400.com

• On the web

• Code400 - The Support Alternative.

  • Jan 2003 - Jul 2020

  Website that offers code examples, system administrator tips, a forum and just good company for developers/admins on the system i. Website that offers code examples, system administrator tips, a forum and just good company for developers/admins on the system i.



MBL USA

• Ottawa, IL

• Team Lead Manager

  • Dec 2016 - Nov 2017

  Manufacturing environment using BPCS as the core MRP system. Linked ORACLE manufacturing software with IBM i DB2 database using SQL, RPGLE & JAVA. Designed and deployed various bar coding applications using TLAshford at it core. Implemented MRP process within the constraints of INFOR's BPCS software. Introduced procedures and modernized the development process. Designed & implemented PHP applications (BCD) to enter labor at facilities across the shop floor. Manufacturing environment using BPCS as the core MRP system. Linked ORACLE manufacturing software with IBM i DB2 database using SQL, RPGLE & JAVA. Designed and deployed various bar coding applications using TLAshford at it core. Implemented MRP process within the constraints of INFOR's BPCS software. Introduced procedures and modernized the development process. Designed & implemented PHP applications (BCD) to enter labor at facilities across the shop floor.



ABC Supply Co. Inc.

• United States
• Wholesale Building Materials
• 700 & Above Employee

• Lead Developer/Architect (Point of Sale)

  • Jun 2014 - Dec 2016

  • Interfaced with business, worked with business analysts to develop technical documents • Sending/receiving all pricing data from IBMi to Server based Vendavo pricing software, wrote IBMi triggers and batch processing • Wrote complex group of applications to attach triggers and call soft coded program • Loaded Scott Klement's httpapi and modified to post to secured website • Wrote custom applications on IBMi using FTP & SFTP and/or HTTP POST/GET in XML/JSON and CSV • Used SQLRPGLE, RPGLE, IBMi system API’s, system tables and IFS to write export programs, display applications and reports • Used ICLUSTER from Rocket software to sync data in real time from 3 point of sale boxes to centralized data store box • Identified commonly called programs and create external procedures to expedite creation of future applications • Used BCD software (PHP/Presto) to convert 5250 green screen to HTML/PHP applications • Installed BCD software (NEXUS PORTAL) to house html/php point of sale software as well as new application accessing/updating IBMi db2 tables • Used RPGLE and SQL to create applications that allowed development team to focus on programming and move common functions back to the user base • Worked with operations team to identify system issues and load correct IBM PTF's • Setup apache server on IBMi and wrote web services using RPGLE and SQL • Grew team of 3 RPG developers to 6 Local RPG developers, 1 remote and currently 2 remote PHP developers • Installed and wrote programs to print barcodes using RPGLE, SQL & TLASHFORD barcode software Show less



Liebovich Steel & Aluminum

• United States
• Warehousing and Storage
• 1 - 100 Employee

• programmer

  • Aug 2004 - Jun 2014