651.288.7000 info@intertech.com

Server Modernization & Proprietary Data Valuation Dashboard

Case Study: A North American firearms and defense manufacturer initially approached Intertech for assistance in upgrading their server’s performance. Their Microsoft SQL Server that was used across the company was slow and causing a drag on company efficiency, making even routine tasks take longer than they should. Once Intertech resolved that problem, the company expanded the project to create a way to provide their team further value and insights from their massive collection of proprietary data.

Featured Aerospace & Defense


Technology Used
SQL Server


Hybrid Agile-Waterfall


Additional Services
Legacy Modernizations
Pre-Project Diagnostics


Improve System Performance and Provide Value and Insights From Their Proprietary Data To Include New Sales Dashboard


Project Requirements

The client initially tried an internal server upgrade from Microsoft SQL Server 2002 to 2014, expecting to see significant performance gains. However, those gains didn’t materialize as expected, and so they called in Intertech’s expert consultants to diagnose and suggest remedies for the performance issues.


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

In addition, the new sales and forecasting dashboard that went along with the upgrade, now 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, displaying side-by-side comparisons of budget forecasts versus current sales and 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.


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. Finding multiple opportunities for improvement, from hardware upgrades to query optimization and restructuring data storage methods, Intertech presented optional pathways and, once approved, worked with the client’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 gain value and insights from their proprietary data. As a manufacturer, they work with various end retailers and bulk purchasers to provide retail and specialty products. Intertech consultants recommended a sales management and strategic planning dashboard that would enable real-time, granular sales data, and budget forecasting.

Once reviewed and approved, the client 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 would 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, becoming a trusted partner.

Intertech has been in business for nearly 30 years. Many of our projects are considered confidential by our clients. For this reason, and out of respect for our customer’s privacy, we do not mention companies by name regarding specific projects, with the clear understanding that the project outlined and presented is actual work Intertech and their consultants have completed successfully.

The Fastest Way To Build Software Is “Right” The First Time!


Intertech Logo


Understanding your industry is one thing. Understanding the technology you are using is another. When you read studies that tell you that 75% of projects are doomed from the beginning, it has to make you pause before signing your name to the outcome.

Consider letting our proven professionals take a look at your project. They’ve seen what can go wrong and know how to avoid costly errors.

We build custom software from start to finish. We plug into your environment with the proven expertise you need for us to work independently or in co-development. And, we bring the soft-skills that make the task enjoyable, and the experience to leave your team stronger and ready to take over.

We Bring You…

Team-Complete™ Development

Intertech’s Team-Complete™ development means we make sure all the right people are seated at the table to assure success the first time. At Intertech, you always get the best of the best! Proven consultants dive deep into your project, analyze your objectives, and lead your project to success with the expertise and the soft-skills you expect from a leader.

Soft-Skills For A Winning Experience

Sometimes the most critical person in the room is the one with a calm voice and the knowledge to select the right words. Bringing a development team together or presenting a clear concept for stakeholders can make all the difference between success or failure. Intertech consultants are at the top of their field. They navigate challenging decisions, guide with a confident voice, and know when to get out of the way.

Turn to Intertech when you need it done right!

Intertech takes the worry out of custom software development.

Three Great Reasons To Let Intertech Build Your Software Independently Or In Co-Development With Your Team!

To understand why so many companies rely on Intertech for their software consulting and software education needs, you must understand the importance we place on staying up-to-date with the most current technologies and methodologies.

“When an outside firm asked over 4000 of our customers these questions, we immediately understood why they trusted Intertech!”

Say “Yes” To Intertech!

  • Would you use Intertech again? 99.55% 99.55%

99.55% of customers answered YES!

  • Are you happy with Intertech? 99.55% 99.55%

99.55% of customers answered YES!

  • Would you refer Intertech to others? 99.70% 99.70%

99.70% of customers answered YES!

More Case Studies…


Case Study Icon Style 1

World-Wide Reaching Diagnostics Application


Case Study Icon Style 2

Neural Network-Powered Computer Vision


Case Study Icon Style 3

Interactive Application That Measures The Financial Risk

"Intertech’s SQL expertise was invaluable in improving our database server performance."

“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.”

– Client

"Working with Intertech allowed us to modernize the user interface of the equipment we produce."

“Working with Intertech allowed us to modernize the user interface of the equipment we produce. The consultants they provided were clearly experts in their field and brought the necessary knowledge to our team to update our application. But working with Intertech also helped us move toward a faster development and deployment cycle for our new features moving forward. This new user interface will provide a better user experience for our customers, and our new deployment pipeline will enable us to continue improving that user experience over the months and years to come.”

– Client

"Thanks to everybody for the efforts over the last 18 months!"

“It’s with mixed feelings that this day has arrived. I’m sad to see this collaborative effort come to an end; but I’m excited with what we have accomplished. Tom & Scott had a lot of patience with me through the process and were able to teach me a lot of good stuff. For me, one of the big benefits of the Intertech/[client] relationship was it helped me demonstrate the value of software to the company which led to my getting approval to hire two software folks. Even though this particular project/phase is at an end, I’m hoping we have the opportunity to work together again. Once again, Thanks to everybody for the efforts over the last 18 months.”

– Client Supervisor


Client Relationship Manager

James Gibbs

As an Account Executive, James Gibbs works closely with software development managers, engineers, and other IT professionals to deliver select development resource teams to fit your requirements. He has worked with a broad range of clients, including Fortune 500 corporations, state and federal entities, and the U.S. military. James completed his undergraduate degree at the University of St. Thomas and served internships at Minnestay.com and AscensionPoint Recovery Services.


“Nothing will work unless you do,” says James. “I remind myself of this every day. As continually evolving technology makes learning for IT professionals more important than ever, I do my best every day to help meet the need.”


What Intertech?

Working closely with technology and people is something I am passionate about. Intertech training and consulting provides a great balance of both.”


James enjoys coaching Andover boy’s youth hockey in the winter (AA PeeWee), golfing in the summer and spending weekends with family up north.

Discover All That Intertech Can Do For You!

Let’s Build Something Great!

Tell us what you need and we’ll get back with you ASAP!
Consider Intertech…

Tell us about your project and we’ll gather the right people, discuss your request, clarify any questions, and provide a price estimate that you can use to decide if Intertech is a good fit for you!

“We Take The Worry Out Of Custom Software Development!”

Turn-Key Custom Application Development Solutions Since 1991

Independent & Co-Development

Tom Salonek Founder & CEO