Consulting Training Blog Careers About Us Contact Us

Case Study

  • Client: Springfield Armory
  • Project: Extracting More Value from Its Customer Data
  • Country/Region:

Springfield Armory, a North American manufacturing company based in Illinois, initially approached Intertech for assistance upgrading server performance. Their Microsoft SQL Server instances provide data for applications and reports used across the company’s business sectors and impacts the work of hundreds of employees. Slow server performance was causing a drag on company efficiency and making even routine tasks take longer than they should to collect and relay data.

Technologies Used

  • SQL Server
  • SSRS
  • SSAS
  • SSIS

Customer Quote

Intertech’s SQL expertise was invaluable in improving our database server performance. Thanks to the guidance and work from Intertech consultants, we’ve reduced runtime on common queries, modernized our technology stack, created a platform for real-time sales feedback, and enabled more comprehensive strategic planning for our company. We look forward to working with Intertech on future projects to drive even more value from our data.

Challenge

The client initially tried a server upgrade from Microsoft SQL Server 2002 to 2014, and they expected to see large performance gains. However, those gains didn’t materialize as expected from the upgrade, and Springfield called in Intertech’s expert consultants to diagnose and suggest remedies for the performance issues. Intertech’s consultants began work on the project in 2016.

Process

After meeting initially with project stakeholders to define the goals for the server optimization, Intertech’s consultants began a suite of diagnostic tests and queries to identify bottlenecks on server performance. Our consultants found various opportunities for improvement, from hardware upgrades to query optimization and restructuring data storage methods. The consultants worked with Springfield’s internal development and IT teams to provide training and resources for making the necessary changes. Over the course of the initial six month engagement, Intertech’s recommendations drove a significant improvement in server performance.

Thanks to the success of the server optimization project, the client requested recommendations for further projects to get value and insights from their proprietary data. As a manufacturer, Springfield Armory works with various end retailers and bulk purchasers to provide retail and specialty products. Intertech consultants recommended a sales management and strategic planning dashboard that enables real-time, granular sales data and budget forecasting.

Springfield retained Intertech to structure the data and build the sales dashboard using Intertech’s development expertise. Intertech developers took the client’s sales and orders database and created a data warehouse, atop which they built a reporting cube for SQL Server Reporting and Analysis Services. They then made the data available via a dashboard so that stakeholders have easy access to up-to-the-minute sales information and budget projections.

Development followed a hybrid agile-waterfall approach. Intertech initially pre-defined critical requirements with the client and built and delivered the core product. Over time, the client has requested additional functionality that Intertech has built in a series of agile sprints.

Learn More About Intertech Consulting

Result

As a result of the reporting optimizations, Springfield has seen a dramatic drop in runtime for SQL queries and reports. The upshot is greater employee efficiency, easier access to data, and cost savings on storage and computing resources.

The sales and forecasting dashboard brings the client’s data to life, allowing sales reps, managers, and executives to drill down into sales numbers based on product type and distribution chain. The client can quickly and easily add and modify the products they offer. In addition, the dashboard enables side-by-side comparisons of budget forecasts versus current sales, allowing the client to immediately pinpoint where the company is performing well and where there are challenges. The benefits in strategic planning and a shortened sales feedback loop allow the client to be more responsive to customers’ needs and capture more revenue from the market.

Our Story: Intertech

From the day it was founded in 1991 by local entrepreneur Tom Salonek, Intertech has been a company with an important difference: unwavering commitment to customers, employees and the broader community through excellent work, smart workplace and financial management, and creative philanthropic involvement.

Learn More About Intertech Consulting