Case Studies

Client Overview

About Client:Client is a California based Software-as-a-Service (SaaS) provider for stock room management solutions. Company was founded in 1994, has hundreds of satisfied customers in industries where it is critical to have good inventory management at the last step of the supply chain: the point-of-use (POU). While items at the POU may be inexpensive or commodity products, the cost of a production line shutting down from a stock out or an inoperable machine is prohibitive. Client’s service productively and cost effectively optimizes inventory while maximizing service levels at the remote stockroom, store, or service van.

No matter what their client’s approach is to inventor y ownership, inventory location or inventory replenishment, they can accommodate their client’s method and automate the process of tracking and replenishing their client’s inventory at the POU. Industries that can benefit most from their service include: manufacturers; suppliers and wholesale distributors of commodity but critical parts (electrical, electronic, fasteners, wire, industrial, MRO/spare parts, etc ) ; food service; and fleet maintenance.

Proposed Solution:

• Considering client’s requirement Silver Touch proposed and developed stock room management inventory system in ASP.NET (Web Application) and Windows 6/6.5 (PDA (POU) Application) with Agile Methodology.
• Web Application was developed with MVC 4 which has many advantages that helps to develop great applications.
• As client was planning to sell this product to their end clients giving them facilities to manage their individual inventory, we have developed SaaS based application
• PDA devices were suggested by the client who was having scanning facility which was used to develop barcode scanning functionality for quick and easy stock management.
• Unique offline functionalities was developed for PDA so user can use PDA Application where internet connectivity is not available, so data can be stored locally on the device and whenever internet connectivity is available these data can be synchronized with the central database.
• 3rd Party Control (jQuery Data Tables) and 3rd Party equipments (Sensors) were implemented and integrated with this application for fast and accurate data management

Requirement Overview:

Client required a Web Based Application in place of their current Client-Server Based Desktop Appl icat ion running on a Windows Server for Inventory Management.

They also wanted a Mobile Application for Mobile POU with scanning and high performance features. With this new Web and PDA based applications; client had also planned many new features and functionalities which were not available or not feasible in their current application.

Below is the list of major features & functionalities which were required by the client:

• Facility to manage inventory of multiple enterprises with the help of enterprise level administrator
• Total control with Super Administrator and can manage each and every functionalities in absence of enterprise level administrator
• Enterprise can create multiple companies under them
• Enterprise level users can only see information for their enterprise
• Enterprise-wise and Company-wise Inventory Management
• Role based access for different level of users
• Log to be maintained for all transactions for Audit Trail purpose
• Local storage for PDA device when network connectivity is not available and sync with the database when connectivity is resumed
• Sensor based automated stock taking process

Benefits

1. Web application instead of desktop application so it eliminates manual work
2. Users can manage inventory using virtual inventory system
3. Users will be able to manage their tools and assets as well as their maintenance on timely basis
4. Users can build and break kit of items as per their requirement
5. Users will be able to make quick list of items for quick orders of frequently used items and save lots of time
6. Users can keep track on inventory using remote sensors and Poll functionality
7. User can know about most selling items and total inventory value using dashboard
8. Users can get details of to be ordered items using replenish cart
9. Customized barcode with PDF format can be generated dynamically for items and orders
10. Users can reflect offline changes using sync data with PDA
11. Users will be able to filter, sort, re-order, multi delete grid view data
12. Users can get mail for tools and asset maintenance, order sending and receiving etc.
13. User defined fields with dynamic dropdown are available in each module for additional information

Project Approaches / Activities

1. Phase I:As per Agile Methodology gather information for one module
2. Phase II:Analyze the system flow and database design for this module
3. Phase III:Designing
4. Phase IV:Development
5. Phase V:Testing as per client’s requirement
6. Phase VI:Go Live