 | | | Case Studies - Manufacturing
| | | Photo Studio - Inventory Maintenance System | | Client | Ethan Allen, USA | | Technology | MS SQL server 7.0, JavaScript, ASP, VB Script, HTML, Front Page, VB 6.0, Data Reports, Windows NT | | Description | Ethan Allan-Photo studio (EA-PS) is a part of corporate Ethan Allan, which is responsible for magazines, photo shoots, video production, PR events, projects and seminars. EA-PS maintain an inventory of case goods, upholstery, accessories and soft goods in the Photo Studio inventory and track their movement for various projects. They get an annual magazine schedule, which has details of the project start date, project end date, latest date of ordering and receiving date. | 
| Dealer Order Tracking System | | Client | AP Paper Mills, India | | Technology | Oracle 8i, JavaScript, ASP, VB Script, HTML, Front Page, Windows NT, Interfacing with existing system based on Sybase/Unix | | Description | AP Paper Mills is a leading manufacturer and supplier of quality paper in India with thousands of dealers nationwide. Dealer Order Tracking System is a web-enabled; order acceptance, approval, process and tracking system. This system integrates very well with the existing systems of the client supported by Sybase database. Status at every level of order processing like scheduling, processing, quality, packaging, dispatch is updated on to the system and by email to the client directly. The client maintains separate system on Intranet and once a day synchronizes the data with the system on Internet. |  | |