651.288.7000 info@intertech.com

Aerospace & Defense

Understanding the aerospace and defense industry is one thing. Understanding the technology you currently use and the updates you should consider is another.

Case Study: A North American firearms and defense manufacturer initially approached Intertech for assistance in upgrading their server’s performance. Their Microsoft SQL Server instances providing data for applications and reports 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.

Custom Application Development For The Aerospace and Defense Industries!

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.

At Intertech, we ask the right questions and tell you the correct answers. From design to rollout, Intertech takes the worry out of custom software development. Add the unique benefit of our field-driven education division, and you get a blend of exceptional knowledge that plugs in, does what you need, and leaves your business and employees more engaged and more potent as a team. 

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

Tell us how we can help!

Intertech takes the worry out of custom software development.
Featured Aerospace & Defense

Case-Study

Technology Used
SQL Server
SSRS
SSAS
SSIS

 

Methodology
Hybrid Agile-Waterfall

 

Additional Services
Legacy Modernizations
Pre-Project Diagnostics

Project

Implement Remedies To 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.

Result

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.

Overview

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.

More Case Studies…

CASE STUDY

Case Study Icon Style 1

World-Wide Reaching Diagnostics Application

CASE STUDY

Case Study Icon Style 2

Neural Network-Powered Computer Vision

CASE STUDY

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

GET TO KNOW US

Training Account Executive

James Gibbs

As an Account Executive, James Gibbs works closely with software development managers, engineers, and other IT professionals to deliver hands-on, instructor-led training. 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.”

Sideline

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

How Can We Help You?

We’ve been in business since 1991 because we listen to find out exactly what you need and then help take your project to the finish line the first time. Let us know what we can do for you!

5 + 6 =

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!