Ranjit Construction Company

Ranjit Construction Company is one of the largest civil infrastructure development firms in India and that has constructed some of the world’s largest projects like worlds biggest siphon, world’s biggest railway over bridge.   Business Requirements The firm has an average of more then $50 million worth of materials (with more then 5000 different items) and more then $20 million worth of equipments and machinery lying at different construction sites. The existing system consists of many excel spreadsheets and much of the redundant data. It was also difficult to manage transfer of equipments and materials from one site to another due to no such system available to readily update the records. As a result it happens that an item needed at one site and lying idle at other site escaped detection and results in necessary purchasing and increased inventory.   The Objective Three broad level objectives were identified: To control the inventory level across each of the sites so that inventory held up will be minimum permissible. To develop an integrated materials management and decision support system for efficient and smooth functioning of all the sites. The solution should be easy to maintain, secured and future upgrades should be quick..   JSCGroup Solution A virtual private networked system was developed wherein a inventory control software module runs at each of the sites stores and that through dial up internet connection connects under secured mode with the company web server located at its headquarters to update the data. At the headquarter an intranet system was developed to carry out functions of materials management. The choice of dial up internet connection was used at each of the sites as the use of internet lease line is costly as well as sites locations are work specific. An intranet system was used so that advantage of a web based application that can be expanded easily to accommodate other modules and provide better graphical user interface. On technology selection, Linux was used for its more secured then windows based server. Oracle database was the preferred choice of the client as the company already runs heterogeneous applications based on Oracle and any future integration will be fast and cost effective.   Results Facilitated automated scheduling and routing of materials, equipments from one site to another. More cost-effective workflow (Reduced acquisition cost i.e. cost associated with wages/department operating expenses, inspection costs, cost of services like telephone, fax, postage, electronic hardware’s etc). Increase in available equipment utilization up to 85%. Saved 30% of employee working hours.