What Our Customers Are Saying About Us
CASE STUDIES
Case Study 1 - Disaster Recovery
Problem to Solve:
A logistics company, whose IT department was based in Chicago, IL, found themselves in a situation where the primary production web & database server crashed. What was worse is that they thought they had lost 7 months of customer data, because their backups were on that same server. On top of that they had no standards or best practices in place, and their servers were in disparate locations. The crash resulted in them being down for over a week.
Solution Provided:
All servers were centralized to a local data center, the platform was standardized on VMWare, and hardware redundancies were added. The additional hardware was configured using active-active failover clustering, and a remote failover site was established as well. Additionally, all virtual machines were backed up offsite, and all databases were backed up nightly to cloud storage. Finally an IT disaster recovery plan was then drafted outlining the steps necessary in case of catastrophic failure, or in cases where automatic failover was not an option.
Result:
The solution provided ensured that standards & best practices were being used, all data was properly backed up and easy to restore, and downtime response latency was improved from over a week to 2 hours.
Case Study 2 - Inventory Management System
Problem to Solve:
A major automotive manufacturer, with parts facilities in Kentucky and California, needed a supply chain management system for tracking returnable inventory in its various conditions and locations. They were losing $5 Mil+ per year due to lost and damaged inventory, and they needed to know when and where those losses were primarily occurring, and be able to accurately budget for replacements each year.
Solution Provided:
A three-part solution was provided that streamlined route management, shipping & receiving, and inventory repair processes. First, a web application was developed for managing suppliers, routes, inventory item master, and shipping & receiving schedules. Second, a mobile application, running on a handheld scanner, was created to manage shipping & receiving inventory modules, moves within the warehouse, inventory status changes, and weekly cycle counts. Finally, a Windows application was created in order to manage repairs being made to inventory modules, and track performance of the workbench.
Result:
Complete visibility was gained within a couple months of going live, giving them the ability to identify problem suppliers in order to mitigate losses due to mishandling, and they were able to properly forecast their need for the upcoming year.
Case Study 3 - VOIP System
Problem to Solve:
A logistics company in Detroit had an aging analog phone system that needed to be rebooted several times each month; their original service provider was semi-retired, and only available half the year to resolve any issues; and, they were continuing to grow, but their phone was unable to scale with them.
Solution Provided:
A new on-premises VOIP solution was provided.
Result:
The solution provided reduced their overall phone bill by half, proved to be a more stable system, able to scale for years to come, and easy to maintain by their IT department.
Case Study 4 - Vanity Top Configurator
Problem to Solve:
A building materials manufacturer, located in Florence, KY needed a web based application for configuring custom bathroom vanity tops. Their business was starting to experience losses because they were still using a manual process, and it was easier for potential customers to use their competitor’s website.
Solution Provided:
A three-part application was created to handle the core functional components. First, a generic assembly was created to render CAD-like drawings based on a set of parameters that would be acquired through the web interface. Second, a web application was developed to acquire the necessary inputs for generating the drawing, and for displaying the rendered graphic. Finally, an ETL job was developed in order to interface customer orders with Microsoft Dynamics Great Plains.
Result:
The new application was quickly adopted by their customers, and they saw an immediate 20% increase in sales. Additionally, the application proved to be so robust that employees chose it over their antiquated Windows application, enabling them to realize a significant increase in productivity.
Case Study 5 - Custom ERP System
Problem to Solve:
A scrap metal brokerage company in Pittsburgh, PA needed a custom ERP system to manage the purchase & sale of raw materials, as well as track inventory levels and blend inventory lots to create custom assays. The application also needed to track payables, receivables, GL entries and integrate with Oracle financials. Their previous solution only had part of the required functionality, and took a very long time to complete a single transaction.
Solution Provided:
A modulized hybrid application was developed to manage all aspects of their business. The core features resided in several modules that were consumed by a Windows Forms application, while the report functionality was a Web application, which was being displayed in an embedded browser control within the main application.
Result:
The solution provided not only streamlined their entire business, enabling them to realize a 600% efficiency improvement, the reporting module provided the analytics necessary to change the way raw materials were being purchased, freeing up $10 million in capital.