John P. Email & Phone Number

Dublin, OH, US

• Infor M3 Upgrade/Migration o Led project to upgrade Aero-Med’s On-Premise Infor M3 (10.1) to a SaaS hosted solution of Infor M3 (13.3) in AWS. Components included EDI (Axway/Enterprise Collaborator), several Custom.
• Axway B2Bi Migrationo Led project to migrate Aero-Med’s On-Premise Axway B2Bi 1.5 to CAH’s Axway B2Bi 2.1 instance. o Coordinate efforts with Aero-Med EDI Analyst and CAH Axway Project Team for requirement gathering.
• Supplier Managed Inventory Program o Wrote ASP.NET/C# website used by ~10 White Glove drivers to enter transactions in the field via mobile devices.o Wrote WPF/C# application used by ~10 Hybrid Fields and Office/Remote.
• 3PL Interfaceo Led project for a hybrid 3PL interface between Aero-Med’s Infor M3 (ERP/WMS) and CAH SAP/AIMS for two locations.o Solution included, reviewing specifications, developing, and testing EDI documents for.

• Data conversion from Sage Pro ERP (FoxPro version) to Infor M3 (SQL Server version.) Data included Customer, Supplier and Item Master data.
• Oversaw Master Data Management for Material, Customer and Vendor data. Additionally, implemented a process to help expedite loading and enforce business logic.
• Recreated 50+ reports from Sage Add-on to Lawson Business Intelligence
• Created Shipping Interface database. Including integration efforts for FedEx Ship Manager and UPS World Ship. Averaging 4,300 packages daily, across 7 Facilities.
• Document creation/distribution through MOS (M3 Output Solution) which uses the StreamServe (Now OpenText) suite of products. Includes Pick List, Delivery Note/Packing Slip, Customer Invoice, Purchase Order, Package.
• Wrote parsing grid to support GS-1/HIBCC standards in regular expressions for Intermec CK71 handheld to be consumed by M3 Warehouse Mobility

• Evolved MS Access database into standalone WPF application to marshal FoxPro data into third-party shipping applications which eliminated data entry for 60 percent of all shipments.
• Rebuilt WinForms email marketing application in WPF to introduce a graphical user interface where XML editing was previously required.
• Responsible for Data Access Layer milestones in team conversion of VBScript website into C# ASP.NET application.
• Leveraged third-party graphing control to build key indicator reporting application for management to measure the error rate of the operations department.
• Delivered major components for E-Commerce site upgrade project.
• Advocated and helped implement new requirement gathering practices, coding standards, and testing methods for the IT department.