Commercial and Residential Oil Company in Pennsylvania
Problem –The president of an oil company had recieved a quote for $56,000 to upgrade his in-house server infrastructure in order to support a web-based software product that ran the operations, customer management, dispatch and billing tasks for their company. He was concerned that the hardware he was about to buy would be obsolete and in 5 years and in that short amount of time he would be paying the same if not more to upgrade again.
Solved – The Keeling Group configured a cloud-based solution utilizing Microsoft Azure. Instead of paying $56,000 for an industrial strength server infrastructure that would become obsolete in 5 years, they now pay a reasonable monthly fee for only the processing power and services they use on a daily basis. They now have the ability to scale whenever they want and both the in-house employees as well as the field employees enjoy the same reliable and efficient access to the system.
Large manufacturing company needed Intranet site for 5,000 employees
Problem – A manufacturing company in Indiana has employees and sites all over the world. Keeping track of those employees was difficult with multiple databases and systems with different administrators all over the country. They wanted to know, how do we keep track of our employees while giving them a common, consistent message to all sites in all departments of the company?
Solved – The Keeling Group decided that Microsoft Sharepoint was the perfect solution. Keeling added the Intranet server and services to the existing Infrastructure. Keeling also customized an aesthetically pleasing and interactive experience for the users. The Intranet was designed so all the employees see a common theme and Corporate was able to portray the exact message they wanted to all employees across the company. Built into Sharepoint is the ability to create tools such as document repositories, blogs, calendars and discussion groups that could be utilized separately by each department. This solution is scalable with minimal cost.
Storage Company in Kentucky
Problem – A dry storage company in Kentucky provides safe, secure inventory storage and shipping services for a large food vendor who shipped all over the regional area. Every day inventory was delivered and shipped in and out of the warehouse provided by the dry storage company. While this company had local knowledge of the inventory through a SQL database system that the Keeling Group had already created, the food vendor who contributed to about 30% of the inventory that the company stored wanted to have insight into the local status of their inventory.
Solved– The Keeling Group provided a web-based portal to the storage company, so that the food client could access their data. The portal is a web-based system. Keeling created the system so the food vendor can log into the storage company’s system without the need for a new client application on the food vendor’s machines. It also gave the food vendor real-time insight into the storage company’s data since the data was coming directly from the storage company’s database. This Solution has proven successful and the storage company is now moving toward providing this portal as a service to the rest of their customers.
World-wide Chemical Company with a large Excel spreadsheet
Problem – For years an engineering team at a large Chemical Company had utilized a large spreadsheet with thousands of rows and columns
of data with complicated pivot tables and calculations. Microsoft Excel is a well-known and important tool to business users all over the world, but the data can sometimes get so complicated, and the Excel Sheets so large that a more sophisticated database application might be required. The Chemical Company needed an easier way to extract data from this sheet and they asked the Keeling Group for help with a solution.
Solved – The Keeling Group provided a database that would extract all Excel spreadsheet data after the field had completed their data input and calculations. Keeling then provided a portal where teams from all departments could log in and upload that data. Additionally, management could then log into that portal as well and run reports against the database.