IntelliTech Systems, Inc.

Project Title: Oracle Database Specialist, On-Site Support Personnel	Keywords: Network Support, Oracle Database Development
Client: Air Force Materiel Command (AFMC/A7C)	Location: WPAFB, OH
Description: IntelliTech has placed an Oracle Database specialist on-site to provide the following technical support for the USAF EOSH/ACES program. Database administration (Oracle 8.0.5 server on Windows NT; Oracle 8.0.5 and 8.1.6 clients on Win NT, 95, 98, 2000) • Installation and configuration of new database servers • Creation of new databases and schemas • Administration of legacy databases • Packaging, documentation, and help desk phone support for client installations • Alterations to schema and corresponding code • Backup/restore • Version control, patching, and upgrading • Replication techniques to synchronize database with larger external database • Connectivity troubleshooting for clients (Net8 troubles, etc.) Database programming • PL/SQL procedures • Enable convenient management of users and security by non-technical managers • Web-enabled Oracle Forms for three-tier database implementation

Project Title: Electronic Data Interchange (EDI) System Integration	Keywords: eCommerce/eBusiness, Electronic Data Interchange (EDI), Data Integration
Client: JTM Foods	Location: Cincinnati, OH
Description: IntelliTech provided custom programming to allow JTM Provisions, Inc. to receive Electronic Data Interchange (EDI) purchase orders from their largest customer, Kroger, and integrate that data with JTM’s internal system. EDI is a method of communicating business documents meant for computer-to-computer interpretation, using a standardized format. IntelliTech developed an automated application that converts inbound EDI purchase orders into a file format required to import into JTM's proprietary system. This streamlined process eliminated the need for JTM to re-key purchase orders that arrive via EDI. This reduces data entry errors, inventory levels, and invoice turn-around time. IntelliTech has also been contracted to integrate the invoice portion of the EDI process and provide similar services for other customers.