Customer Success Story – AmSafe

Cyberquery is integral to the running of Amsafe

by Tom Oldham

 

Joe McMahon of AmSafe, Inc. spoke with me about how they have benefitted from using Cyberquery and what their employees value most.

“Cyberquery adds value by allowing me to relate, connect and consolidate data within my ERP system that is ordinarily generated across multiple reports.”  Patrick Blackstock – Accountant

AmSafe is the global leader in aviation and defense restraints. They manufacture and service safety restraints in 2 factories and 6 services centers for 600 airlines and 40 aircraft manufacturers worldwide. They recently upgraded their ERP system from QAD 2007SE to 2022EE and needed a reporting and data analytics solution.

AmSafe selected Cyberquery for their Daily, Weekly, Period, Monthly Reporting as well as data mining solution. One of the main requirements from the executive team was that reports from QAD 2022EE must include prior history data from their QAD 2007SE database. The QAD2022EE financial module changed the schema completely from 2007SE requiring new mapping. Also, as with other ERP updates, prior history does not get imported into the new ERP system. The Cyberscience consultants were asked to do their magic and consolidate the two systems’ data and build out a financial, sales, and inventory data warehouse. Now the AmSafe teams can run one report instead of two to report across both systems and be able to compare results to prior periods.

Another important feature was the ability for Cyberquery to work with Excel. Many AmSafe employees felt most comfortable working in Excel. Cyberquery has the ability to run queries from Excel and refresh the spreadsheet with the data requested with a simple click.

Cyberquery makes it so I can get exactly the information I need, in the format I need, when I need it.”  Scott Shillito – Procurement Specialist 

Cyberquery’s Excel functionality is used throughout the organization. Excel workbooks have been built for department specific roles. The employee selects what parameters they need to review and Cyberquery imports the requested fields. This ability to build queries into Excel has made decision making much easier. Scott in procurement highlighted, “now I have reports that can be refreshed whenever I want, or need, to make a decision.”

As supplier to the aerospace and defense industries, AmSafe must comply with numerous codes and perform audits. They follow the highest standards and regulations in the aviation industry, such as AS9100, ISO 9001, and FAA Part 145. The team has automated a number of standard audit requests using Cyberquery and schedule the reports using QDirector.

AmSafe values the expertise of the Cyberscience Professional Services Group. The depth of knowledge of the ERP database and standard reporting requirements of a manufacturer exceeded their expectations. They were also impressed by the speed of response from the team. These qualities they said has made Cyberscience one of their best business partners.

Just like AmSafe, manufacturers should look to solutions that enable a comprehensive view – quote to cash – to give team members the information they need for better decision-making. By adopting a powerful BI solution like Cyberquery, your manufacturing and repair facilities can enter a new era of informed decisions.

About AmSafe, Inc.

AmSafe Inc. is the undisputed world leader in the design and manufacture of restraint systems for use in all fields of aviation and defense. The company has designed and manufactured millions of seatbelts, airbag systems, multipoint restraints and other products that help move millions of people safely and securely in the air.

If you have a need for a new business intelligence solution that provides benefits as Joe describes, contact Cyberscience for a demo or test drive.  – info@cyberscience.com

Author: Tom Oldham, Product Manager – Manufacturing Solutions