SDLC development using RPG Free for automation of:

• file updates of pallet locations for packaging components pull-downs;

• email alerts for: cubic volume and weight of new products;, and batches that are past ship date;

purchase orders where changes in expected date exceeds more than one week in the future, impacting scheduling of manufacturing, packaging and, order picking.

Maintained Company’s various menu systems.

Enhancement of existing applications utilizing RPG Free and Embedded SQL for:

• Warehouse automation status reporting;

• Vendor penalty chargebacks;

• recipe development revisions;

• international packaging specifications;

• revision of forms used in QA for: Manufacturing and packaging processes.

Maintained Company’s various menu systems.

Trained outsourcing firm on various applications, as an SME.

Completed Y2K mandated changes. Maintained existing applications for access to database for legal and governmental inquiries. Created interfaces to external A/R collection agency, and financial backer. Created new W2 process for ADP Printing services, using Lawson Payroll database.

Lead an eight member team thorough maintenance and life cycle development of applications in : Accounts Receivable; Accounts Payable; General ledger; management reporting systems; Payroll; customer service evaluation reporting system; interfacing between software packages, Re-engineered applications in the areas of: database redesign, year 2000 compliance, user-maintained control variables, multi-platform processing, on demand reporting. Completed Accounts Receivable reporting overhaul. Completed billing system overhaul involving a mixture of AS400, sequel server (outsourced) and imaging processing (outsourced) solutions, which is saving $ .5 million in operating costs. Designed data conversion process from in-house designed database files to McKesson Healthcare Application tables.