Oasis Data Mining

1. Oasis Data Mining January 22, 2008 Presented by: Patrice Bleau Bombardier Aerospace

2. Mandate from Sept 18-19 2007; • Determine the data currently available and present potential report that can be extracted from download of the Oasis database.

3. AAQG RMC Sub-Team members; • Susie Neal, Goodrich Corp., • Carl Blazik, SAI Global, • Lori Scheid-Gillepsie ANAB, • Patrice Bleau, Bombardier Aerospace AAQG RMC Contributors; • Jay Myers, SAE • Tim Lee, Boeing

4. Reports identified to be generated from Oasis massive data download • 1) Analysis of Assessment Data: • Number of Major NC’s by clause of Standard 9100/9110; • Number of minor NC’s by clause of Standard 9100/9110.

5. Assessment Data

6. Assessment Data cont’d

7. Reports generate from Oasis massive data download • 2) Analysis / Oversight of CRB performance: • Average score given • Average MA's and mi's • Score per CRB,

8. CRB PERFORMANCE

9. Reports generate from Oasis massive data download • 3) Auditor Data: • Average score given; • Number of NC’s by AEA (Team leader) by clause of Standards and categorization, i.e., Majors and minors.OASIS currently does not capture who the lead auditor was it only captures who the AEAs were as listed by the CRBs. This data will not be available until completion of development project for Oasis database.

10. Reports generate from Oasis massive data download • 4) Feedback Process: • How can a report be generated if feedback consist of free text type of data? Some of the data about the feedback is textual (the actual feedback) while other is controlled (controlled list/dropdown). Other data are also captured (i.e., supplier and cert number) when the user selected to contact the CRB.

11. FEEDBACK PROCESS

12. FEEDBACK PROCESS

13. QUESTIONS?