Experience

ATACO Steel Products

• United States
• Industrial Machinery Manufacturing
• 1 - 100 Employee

• IT Manager

  • Jul 2021 - Present



SPX Hydraulic Technologies

• United States
• Machinery Manufacturing
• 1 - 100 Employee

• Senior Business Systems Analyst

  • Sep 2013 - May 2021

  -Infor Syteline ERP development, administration, and support. Form customization to match business process improvement projects using Infor Mongoose IDE and SQL Server technologies. -Developed Infor Syteline custom E Kanban system for machinists to easily move parts through operations and provide a real time production status visibility in ERP resulting in increased manufacturing productivity. -Upgraded ERP from Infor Syteline 7 to Syteline 9 providing system performance improvements as well as new and improved feature access. Ported all customized Infor Syteline 7 forms, reports and associated SQL Server DB tables and procedures to Syteline 9. -Developed InSync Anywhere Mobile Data Collection forms for mobile RF devices for plant floor real time data capture and control into Infor Syteline providing more accurate transactions, immediate inventory impact and eliminating the need for delayed data entry. -SAP ECC 6 - Migrated business ERP from Infor Syteline to SAP ECC 6 -Extracted, Transformed and Loaded (ETL) data from Infor Syteline SQL Server DB to SAP ECC 6 DB to enable transition from Syteline to SAP ECC 6. -Migrated Mobile Data Collection to RFgen which provided real time data management for plant floor operations and increased accuracy and efficiency. -Expanded use of RFgen Mobile Data Collection SAP transaction management from Rockford plant to 6 additional plants, including Poland, Belgium and the Netherlands -IT Operations Administration and Support for 200,000 sq ft facility and 200 employees. -Managed the upgrade of 100+ Factory PCs to windows 10. Many with special applications. -Managed the upgrade of 10 servers from Server 2008 to 2016. Many with special applications. -Supported other applications including Sirius Pro rental, Loftware, Syspro ERP and AS400. -Supported SPX Flow EDI, worked with SPS Commerce to expand use of EDI at SPX Flow. Show less



PBC Linear (A Pacific Bearing Company)

• Roscoe, IL

• Senior Business Analyst and Software Developer

  • Aug 2007 - Sep 2013

  -Analyzed the company’s business processes and design and develop changes to make them more efficient. -Developed, modified and supported Infor Syteline ERP processes for use by Sales and Customer Service, Production Control, Manufacturing, Engineering, Inventory, Shipping, and Accounting. Modified Infor Syteline forms, associated Visual Basic code and SQL Server DB procedures improving the company’s productivity. -Maintained the PBC Linear.com web site. Reworked the company’s web site to meet the Marketing Departments desire for a web site that helps engineers and attracts more potential customers. Integrated the web site with Part Solutions 3D CAD so potential customers could spec out how parts could fit into their applications. -PBC Linear’s Salesforce.com CRM administrator, developer, and trainer. Developed Web to Lead interface between PBC Linear’s web site and Salesforce.com CRM system providing Sales Reps immediate notification when a potential customer requested more information. Show less



Avent America Inc. (Philips Inc.)

• Bensenville, IL

• System Analyst and Software Developer

  • Aug 2004 - Aug 2007

  -Developed and supported the Syspro ERP processes for use by Accounting, Sales, Order Fulfillment, Customer Service, and Warehouse and Distribution. -Maintained and administered the back-end MS SQL Server databases, including the tables, views, stored procedures, user defined functions, data transformation services and replication. -Managed the Data Warehouse, which was the basis for the Sales Analysis and Reporting platform. -Developed and maintained various MS Access tools for reporting and specialized operations. -Customized and launched the new Customer Service database which was done with OmniNet’s OmniTracker. -Developed a web application using ASP.NET and VB.NET to input customer survey data and store it in MS SQL Server DB. This made it easy to collect, and manager Show less