SUMMARY:

Over thirty years of information technology experience primarily in distribution, financial, retail, manufacturing, and warehouse management systems. Experience includes project management, systems analysis, software design and development, coding, testing, documentation, and both user and technical training.

TECHNICAL SKILLS:

Operating Systems: OS/400, CPF, SSP, Windows

Programming Languages: RPG ILE, RPG Free, RPG III, RPG II, Java, X++

Hardware: IBM i, System i, iSeries, AS/400, System 38, System 36

Packages: PRMS, BPCS, Renaissance Software, J.D. Edwards, JDA, Infinium, Ross, DMS, MS Dynamics AX

Miscellaneous Utilities: SQL, SDA, DBU, RDA, SEQUEL, NewVersion, Menu Master, Lotus Notes, Maximizer, Aldon CMSCompareSource, Abstract/Probe, MS Word, MS Excel, MS SQL Server, MS Teams, MS OneNote

PROFESSIONAL EXPERIENCE:

Senior Programmer/Analyst

Confidential, Phoenix, Arizona

Responsibilities:

• Primary technical application support for migrating the on - premises Dairy iSeries systems (Ross and DMS) to the cloud.
• Provided iSeries technical support for the conversion of Shamrock’s financial systems from iSeries Infinium to MS Dynamics AX, and also for the Dairy business software from iSeries Ross to MS Dynamics AX.
• Business analyst support for fixed asset purchase requisitions on MS Dynamics AX 2009.
• Provide technical support for Microsoft Dynamics AX 2012 ERP software (AR, AP, Logistics, GL, Cash and Bank Management modules) using MS SQL Server, the AOT, X++, Report Builder, Atlas (which is a reporting/upload tool for Dynamics AX), and Global Spreadsheet Server.

Senior Programmer/Analyst

Confidential, Phoenix, Arizona

Responsibilities:

• Managed a major product returns project that tracked returned items from the stores to the various returns warehouses, and then the shipment of returned items to the vendors.
• Designed, coded, and implemented file controls for Sarbanes-Oxley requirements.
• Created various reporting functions to track quantity and cost of warehouse inventory.
• Coded a Java web app to track all warehouse items by vendor and buyer.

Senior Programmer/Analyst

Confidential, Phoenix, Arizona

Responsibilities:

• Maintained/enhanced/customized the Power Warehouse package servicing wholesale food distributors. Applications included routing, cubing, picking, shipping, receiving, put-away, and replenishment.
• Performed major enhancements to the shipping and receiving labels.
• Developed the interactive Route Progress Summary application.
• Coded a custom application to perform a parent/child translation for Replenishments and track the adjustment history.
• Corrected weight discrepancies in the Power Warehouse/Enterprise interface for Receipt Check-In.
• For Selection Zones flagged for automatic assignment, added automatic check-out of the next UOW for the selector.
• Added kit component processing for Customer Returns.
• Created custom modification for Shipment Verification.
• Customized bulk-pull creation to pull from the pick slot depending on the selection zone threshold.
• In corporate company and warehouse into the check for Power Enterprise integration.
• Created a subfile display to allow bulk pull selection if multiple bulk pulls existed for the same pallet.
• Corrected quantity error in Inventory Adjustment History when two shipping lines combined into a bulk pull.
• Corrected a quantity reduction error from the reserve slot after a replenishment request had the system-selected pallet overridden to another pallet.
• Changed an application to time-stamp the last quantity placement to a pick slot for Power Voice.
• Changed cost extension of catch-weighted items to be by weight instead of case for the Aging Report.
• Added a function to the receipt manifest that prompts the user to edit all random weight items.
• Changed shipping weight validation to correctly update weights to inventory.
• Added Warehouse Maintenance shipping options for Performance Calculation Method, Allow UOW Check-out Across Selection Zones, Allow Employee Review of Performance Data, and an integration edit for Cycle Count Reason Code.

Software developer and consultant, AS/400

Confidential, Cleveland, Ohio and Phoenix, Arizona

Responsibilities:

• Project leader for a mainframe to iSeries conversion for a store billing system for a major retailer.
• Performed a Y2K conversion for an auto parts retailer using JDA Software.
• Primarily responsible for interactive applications on a retail sales audit project.
• Provided enhancements to Order Entry/Billing, Purchasing, G/L Interface, and Physical Inventory programs as part of a WANG to IBM CA-PRMS conversion.
• Responsible for all phases of three major upgrades to CA-PRMS for a lighting manufacturer/distributor.
• Developed Location Management, Revenue Collection, and Insurance Claims Management applications for a parking lot management corporation using Infinium.
• Performed analysis and programming for executive management reports interfacing with J.D. Edwards.
• Created order allocation, pick list, and packing list applications for a tape manufacturer using Renaissance Software.
• Responsible for all phases of an enhancement to physical inventory applications to include lot tracking using CA-PRMS software. Modified the Order Entry module to discount orders based on the categories of product found on the order. Created applications allowing field sales reps to view orders, shipments, and invoices.

Senior programmer/analyst

Confidential, Cleveland, Ohio

Responsibilities:

• Assisted in a Burroughs to IBM CA-PRMS conversion with emphasis in Order Entry, A/R, Inventory Control, Shop Floor, and General Ledger modules.
• Created a product returns entry application interfacing with CA-PRMS software that allowed bar code scanning.
• Heavily involved in training an IT department in operating system concepts and RPG programming.