Experience:

As a consultant, I provided industry and government with Design and Quality Assurance Engineering. This included the introduction of ISO 9001 and AS9100 as well as tracking of the impact of AS9100C. This required strong analytical skills and the conceptual and analytical ability to define Quality requirements in design, product operations and processes.

As a recent example of providing an impact on the Quality for a manufacturer was; the review and updating of their Inspection Database and their Approved Supplier Database.  The system ( under review)  worked when the system was new but now with over 500 suppliers and more than 500,000,000 inspected lots over the past 3 years, the limited number and types of reports in place made it difficult to maintain effective control.  The installed system was on an Access Database that provided a large number of detailed reports to study and review.  The system was improved with the following features:

1.      A “Reporting Form” was created that provided a start date and end date to limit and control  the volume of data under review. It also included input fields like Supplier, Part Number, Inspector and the Inspection Area. The input fields have drop down lists to select from.

2.      The “Reporting Form” provides an easy to use interface that uses menu buttons that the user would point and click to generate a report or export a report to word.

3.      A summary report that will identify part number, lot size, number rejected, and % rejected for a given time.  This brings management attention to critical areas of concern.

4.      Knowing what part has a high % of rejection, a report of the failure history of a given part can be generated as well as a detailed report on the status of the supplier of the part.

5.      Reports on any one of the twelve inspection areas or any one of the inspectors can be presented. This makes possible to identify human errors or other factors to identify.

6.      A series of reports on supplier and pending surveys can be generated for any given time. This makes it easy to inform a supplier and plan for upcoming surveys. 

 This is just a few of the improvements  made.  It also demonstrates  the power and use of a database system to focus on the important aspects of a good Quality program.

This included but not limited to some of the following efforts: