Sign in

Sales Inventory Control

Barrington, Illinois, 60010, United States
February 22, 2018

Contact this candidate



Skilled IT Specialist with extensive experience improving functional business operations by evaluating, designing, developing, and optimizing software code; extensive experience in IBM AS/400 (iSeries) environments.

Expert ability to analyze existing programs and formulate improved processes through logic, coding, testing, and debugging.

Collaborate well with managers, colleagues, and end users; reputation for providing exceptional user training and support.


Software Development Life Cycle (SDLC) • Programming & Testing • Project Management • User Training

Agile Development • Troubleshooting • Technical Support • Documentation • Innovative Problem Solving


Languages: RPGIII • RPG400 • RPG IV • RPG ILE • RPG Free • SQL • CL • CLP • CLLE • DDS

Hardware: IBM iSeries (AS400) • PC • Zebra • Intermec

Software: OS400 • Subfiles • SDA • Bottomline Transform Designer • Optio • PTX • MRC • m-Power • EDI

Friedman Frontier ERP • DRV • RLU • Query/400 • Db2/400 • TL Ashford • Hawkeye • SEU • PDM • FTP

SQL • SQLRPG • Robot Schedule • Pro Tools • DBU • DFU • ERP • Rocket Aldon • Windows • MS-DOS


Programmer/Analyst, 10/2003 to 11/2017

ALP Lighting Components Inc., Niles, Illinois

Designed, developed, tested, implemented, and supported customized programming applications for in-house and client software programs. Built on AS400 platform with RPGIII, RPGIV, RPG ILE, RPG FREE, embedded SQL, CL, and CLLE. Troubleshot and debugged systems. Extensively used subfiles, physical and logical files, display and print files in a relational database management system.

Developed numerous reports and file maintenance applications. Provided production support, user training, and status updates. Partnered with development and business managers to determine priorities.

Selected Accomplishments:

Supported, customized, and troubleshot the ERP software package including applications such as order entry, shipping, inventory control, purchasing, accounts payable, and accounts receivable; analyzed package upgrades and programmed code to align with new releases.

Enhanced usability of company-wide documents, including invoices, work orders, and purchase orders, by converting AS400 spooled files to user-friendly graphical digital formats, allowing for automatic routing to a task destination as well as simplified emailing, printing, and archiving.

Reduced document handling costs by implementing a digital customer invoice process.

Expedited the shipping planning process by developing and maintaining an internal FTP that automatically sends order entry data to the logistics company for scheduling and cost inquiries.

Improved inventory control operations by designing barcoded labels and print label options embedded into RPG programs and AS400 menu options.

Programmer / Analyst, 4/1999 to 10/2002

Crescent Cardboard Co., Wheeling, Illinois

Led a team in developing and supporting company-wide applications for this leading manufacturer of custom framing matboard and art material papers. Provided programming, analysis, design, quality assurance, implementation, user training, troubleshooting, debugging, and production support.

Selected Accomplishments:

Streamlined sales order processing by creating an internal EDI system using RPGIII, RPGIV, CL, and Arpeggio utility to generate AS/400 forms from the customer Excel purchase document.

Increased operational efficiency by developing improved processes for EDI, BOM, sales analysis, accounts payable, accounts receivable, invoicing, purchasing, and bar-coded inventory control.

Provided senior-level managers with comprehensive sales analysis, production scheduling, financial, and statistical reports to aid in short- and long-term decision making; wrote programs using RPGIII, RPGIV, ILE, CL, open query file, and utilities.

Programmer / Analyst, 9/1997 to 4/1999

Friedman Corporation Software Company, Deerfield, Illinois

Designed and maintained applications for this provider of enterprise resource planning (ERP) software solutions. Analyzed industry-specific requirements as well as user feedback to design and implement revisions and upgrades.

Selected Accomplishments:

Designed AP, AR, inventory control, order processing, and manufacturing applications.

Developed a new release of the flagship HFA package and supported existing customers through creation and modification of RPGIII, RPGIV, ILE, and CL programs.

Programmer / Analyst, 1/1996 to 9/1997

Sportmart Inc., Wheeling, Illinois

Analyzed, designed, developed, and implemented a target marketing system for this retail chain of sporting goods superstores. Provided production support and user training. Coded, debugged, and tested primarily in an AS/400 environment.

Selected Accomplishment:

Developed and maintained interactive and batch programs for order entry, receiving, general ledger, frequent buyer system, and sales analysis.


MS in Mechanical Engineering / Minor in Computer Science

Donetsk State University, Donetsk, Ukraine

Contact this candidate