Description: To enhance core business operations to include necessary and unique business functionality of remote sales and warehousing locations by integrating them into one system. The project team utilized the entire Artech life cycle from foundation through rollout. It:

• Improved air order management

• Improved warehousing and container management

• Permitted order change tracking

• Provided essential air bill information

• Addressed y2k compliance issue

Business Benefits:

• Integrated order processing, logistics and claims handling into the central system

• Integrated inventory management

• Reduced air freight costs by at least 10%

• Enhanced the production and distribution planning process

• Reduced manual processing

Technical Architecture:

• Multi-tier client/server solution, utilizing a GUI client interface and accessing an Oracle DB over a WAN. Also a web application utilizing Oracle Application Server (OAS)

• Dev Tools

• Oracle Designer

• Oracle Application Server (OAS)

• PL/SQL

• Oracle 8i

• Power Builder

• Microsoft Windows NT