print
· APPLICATIONS ·
· Service Support
· Vehicle Pricing & Inventory
· HR Time Reporting
· Shipment Tracking
· Field Engineer Reporting
· Container Mgt. and Tracking
· Inventory & Warehouse
· Product Return & Refurb
· Product Exchange
· Product Repair
· Call Center 
· Medical Forms
Product Return & Refurbishment System

Replace paper-based systems and Excel files used to manage product returns and repairs with a LAN-based application.

The Product Return & Refurbishment System is used to control the product re-manufacturing process of receiving, RA posting, inspection, repair, quality control, packaging, and transfer to re-salable inventory. The system is highly integrated with the Part Inventory, Customer, and Model tables.

The system includes "inspection procedures" that limit the time technicians use to search for model-specific instructions and ensure compliance to established policies. Quality information is captured, i.e., problem, solution, and parts used. Reports and inquiries are available to show daily production, technician productivity, repair status, inventory status, and provide trend analysis on returns and defective reasons. Information is also used to determine parts purchase and unit disposal based on the cost of fixing the unit vs. resale value. Units inspected but found not to have a problem are noted. Units on hold for lack of part or accessory inventory are tracked until missing components become available.

Barcode technology is used to track each unit through the workflow process, eliminate human error, and speed refurbishment. An interface with the host (mainframe) was developed to eliminate duplication of data entry on the LAN and host inventory control systems. Receipts against RAs are also reported to the host via a daily upload file.


· Business process and technology consulting
· Integration to 3rd party applications
· GUI and database design
· Data conversion from legacy system
· Programming, testing, implementation

Windows NT, FoxPro