Cambridge Health Care Limited

Background Cambridge HealthCare Limited is a large-scale business organization engaged in manufacturing and distribution of medicines related to skin deceases in UK and in India. The company has two manufacturing plants in India and one in UK. To markets its products the company has a vast distribution network managed through its divisional offices located across various cities in India and UK.   Business Requirements The company requirement was: “We want a enterprise wide resource planning system that is truly flexible, highly scalable and that can integrate our business activities with our operations and back office systems. The system should be truly flexible, scalable to meet future needs as well as deliver stable performance.” The company also wanted to have an e-business solution whereby they can automate its Distributors Management System. Distributors had to use Fax or file transfers for new supplies and sales status. This where then manually entered. This was cumbersome to both the company and its distributors. Both for its e-business solution as well as its enterprise wide resource planning system the company wanted to avoid re-writing applications and re-entering its stores of historical data. The company wanted a tool that could integrate with their legacy systems and entire infrastructure.   Results The e-Business Solution powered by Oracle 11i, helped company to stay competitive, automating its distributors providing online manageability. Concise, single point of entry delivered via reliable Internet service was the result. This provided additional revenues for the company via increased global visibility, an increase in new business, and time saved processing of data. For enterprise wide recourse planning system, the application developed comprises of well-integrated modules: Production and Planning, Sales, Distribution, Quality, Maintenance, Accounts and Finance, Human Resource, Research and Development. The application also addresses multiple needs, including back office operations and a powerful customer relationship management tool. The choice of an integrated solution using Oracle 11i server, Oracle JDeveloper streamlined the development process.   Benefits Gained Reduce Costs Leveraging JDeveloper code saved months of development effort Several full time employees are free to work on other projects Custom applications are built separately faster and are well-integrated Creating re-usable components saved approximately $150K in development costs Replaced costly and error-prone manual systems Decrease user-training time by developing user-specific interfaces Online reports saved printing, shipping, and handling dollars Competitive Agility Clean architecture and modular approach simplifies adding new applications Can issue updates quickly to distributor base without interruption in service Future technological development as a portal is built-in with Oracle 11i as the foundation Customer/Supplier Loyalty A single point of entry gives distributors easier and faster access. Distributors have immediate access to accurate information without needing to make phone calls or visit company offices International exposure is improved for anytime, anywhere access User interface for applications have a similar look and feel, making it easy for users to cross-train