Engineer Quality
Resume:
Neil Allen
**** **. ****** **., ******, TX *****
*********@*****.***
Technical Skill Summary:
OS: Windows NT, 98, ME, 2000, XP, Vista, Windows 7 Professional, Windows 10, some UNIX experience.
Corporate Apps: Oracle 11g, 12c (PL/SQL, procedures, functions, etc., Discoverer and concurrent programs), Apex/Oracle Applications through version 4.1 (current), SQL Server 2008, 2012 (PL/SQL, procedures, functions, etc.), ETL, Crystal Reports (primarily using PL/SQL), Tableau (also primarily using PL/SQL), Teradata (same), Alteryx, PHP, MySQL (PL/SQL, procedures, functions, etc.), Peoplesoft, WinSCP, TOAD (PL/SQL), Oracle BI Publisher, Oracle EDQ (Enterprise Data Quality), VPN, Adobe Reader 7-11 and Adobe Acrobat, Maximo.
Office/Email: Microsoft Office 93-2013: Word, Excel, PowerPoint, Access, and Outlook, Lotus Notes 7.0, IE 5.0-10, Google Chrome, Firefox, FTP, Cisco network.
HTML: Javascript primarily for user interfaces on database front ends, CSS, XML
Work Experience
Nucor Steel/NextGen – PL/SQL Developer, Reports Developer
Dallas, TX 9/2017 - Present
Oracle PL/SQL Developer
Worked in an Agile environment on the successful data conversion and go-live at two separate steel mills being converted from Ross to Oracle.
Wrote/modified PL/SQL procedures to convert data from Ross into Oracle/EBS data. Used EDQ to push data to different environments/schemas for import into the new EBS system.
Wrote queries and procedures to provide validation information and reports for sales orders and other conversions.
Bluewater Learning – PL/SQL Developer, Reports Developer
Richardson, TX 8/2016- 4/2017
Oracle/MySQL/SQL Server programmer/maintenance, designing PL/SQL queries, procedures, and reports for clients’ LMS (Learning Management System) databases.
Worked with companies such as Medtronic, Papa John’s, Zales, Bankers Life, and others in the management and design of their LMS (Learning Management System) databases and custom reports.
Worked with Medtronic, American Airlines and others in the migration of their existing LMS databases into Cornerstone (LMS company, Bluewater’s major supplier of work).
Worked with web developers to implement reports on the customers’ web pages; verified data in stage and production.
Developed ad hoc reports for special situations with different customers.
Southwest Airlines – Reliability Analyst/Data Architect
Dallas, TX 10/2015- 5/2016
Oracle/MS Access applications programmer/maintenance, designing PL/SQL queries, procedures, and Tableau reports to assist the MX Reliability Group in their gathering and analysis of field and maintenance data.
Repaired/maintained existing Reliability applications in MS Access on the network. Replaced reporting applications with Tableau reports where necessary (using PL/SQL to query the Oracle datamart – Wizard, Trax, etc.).
Developed Tableau reports per internal requests.
Performed queries on Southwest’s Teradata database (mostly financial and purchasing) to look for trends that matched maintenance trends.
Interfaced with Boeing representatives in a Branding effort using SWA data; fleet data, component removals, delays and maintenance.
Answered special data gathering/analysis requests internal to SWA; programs, reliability, etc.
BAE Systems, Inc. Lead Programmer/Analyst
Binghamton, NY 03/2011- 10/2015
Oracle/Apex/Oracle Applications programmer, designing PL/SQL queries, procedures, packages, Crystal Reports, and web pages to answer internal eRequests and helpdesk tickets as necessary.
Accomplishments: 10 year service award
Designed/maintained Oracle/Apex applications internal to BAE Systems (see examples in next employment section); including web interfaces and database structures and definitions. Worked with other business areas at various plants across the nation to design applications per the internal customers’ requirements.
Answered helpdesk tickets related to Oracle/Apex applications, Oracle ERP, Discoverer reports.
Wrote PL/SQL queries, scripts, procedures and packages to gather/produce/evaluate data within the Apex applications and other areas.
Maintained and helped with any upgrades to the Business Analysis Reporting Tool (Crystal Reports) (see below)
Took training classes necessary (Javascript, PL/SQL,CSS) to accomplish any or all of the above tasks.
BAE Systems, Inc. Systems Eng II, Sr. Hardware Eng.
Binghamton, NY 08-2005 - 03/2011
Systems Engineer, Reliability Engineer, point of contact for different business areas in the design and implementation of various software tools in Apex and VB (see BART, below), Crystal Reports designer.
Accomplishments: Two bronze awards for Innovation (see BART, below), Implementation of engineering analysis/reporting tool across four business areas.
Supervised and helped in the design, implementation and maintenance of BART (Business Analysis Reporting Tool) in the HDA (Hardware Design Automation) a BAE designed, internal software suite.
BART is an engineering tool designed to help engineers analyze aftermarket data in Oracle. It has many functions:
oRetrieval of BAE Aftermarket repair and production data from the BAE Oracle database nightly, and stores it for analysis and reporting.
oManual import (via spreadsheet) capability of numerous types of data, including third party repair shop data, MTBUR (Mean Time Between Unscheduled Removals) data from Boeing, Inc., fleet hour data from GE, Inc., and others.
oSpecifically designed user interfaces allow the user to query for certain data, and then modify or add additional information to the already existing data.
oVia Crystal Reports, the user can analyze this data in a standardized format and export it to many different formats, including PDF and Excel. The reporting function of BART is customizable. Existing reports are modified via user requests, and any number of reports can be uploaded into the tool.
Responsible for customizing and creating reports in Crystal Reports for upload into BART, including dashboards and other reports that were presented to customers at reliability reviews on a regular basis.
Constantly interfaced with internal customers in the aftermarket and program management areas to implement and improve BART to suit their individual needs.
Responsible for aftermarket data submittal in XML format to Boeing via the ISDP (Internet Service Data Providers) contractual requirements on a monthly basis.
oAttended Boeing and ATA (Air Transport Association) conferences that dealt with changes and improvements to the ISDP.
oQueried Boeing’s Teradata database for trends and validation with BAE data.
Designed reports used in reliability reviews and monthly submittals to customers.
Responsible for ad hoc reporting outside the standard Crystal Report format by querying Oracle/BART database directly. Reports were usually in spreadsheet format.
Coordinated monthly reliability reviews for the Commercial Electronics (Boeing), Engine Controls (GE), and HEV business units.
Responsible for import of Boeing Commercial Electronics service center data (BAE service centers in Singapore and London) directly into Oracle twice a month.
Responsible for report distribution in various formats on a weekly, monthly, and quarterly basis for internal and external customer reviews (via BART and TOAD).
Developed and maintained Oracle/Apex Application databases and web interfaces for a variety of company functions, including HEV aftermarket service reports and in-house repairs and removals, Boeing EngSCAN (Supplier Corrective Action Notice) tracking, ELDP (Engineering Leadership Development Program) records and information, and ILS (Internal Logistics Support) Tasks and Deliverables tracking.
Universal Instruments Quality Assurance Engineer, Manufacturing Quality Engineer
Binghamton, NY 07/1997 – 08/2005
Support Manufacturing/Production with troubleshooting issues and developing plans for testing and qualification of both existing and new products; point of contact between manufacturing and engineering.
Accomplishments: Successful integration (with third party consultant) of SQL Server and Crystal Reports for trend analysis of machine performance, accuracy and quality. Completed Design for Six Sigma training 8/01. Gained Green Belt certification.
Maintained database records on quality acceptance criteria, and helped develop and suggest different methods of obtaining and storing data.
Developed/maintained qualification and test procedures and test products/patterns for the verification of GSM’s before shipment to customers. Also dispositioned/assisted in rework/repair for machines that failed quality acceptance criteria.
Monitored performance of GSM’s in manufacturing from a pick/place reliability and accuracy standpoint. Also used Six Sigma techniques to find solutions to barriers that arose in manufacturing area. Result was increased first pass yield and decreased cycle time.
Monitored and found solutions to out of box quality issues at customer sites, and reported monthly on first pass yield in that area.
Was lead quality engineer on two different products released into manufacturing (Advantis and HSC). Developed extended quality acceptance test plans on these products to ensure readiness for release into manufacturing.
Hercules Aerospace/Alliance Techsystems Quality Engineer/Systems Engineer
Rocket Center, WV, 10/1993 – 4/1997
Support Quality Engineering with data analysis, quality plans in accordance with mil-spec’s, point of contact with on-site inspectors, coordinate inspection of deliverables.
Accomplishments: Established an interactive database for quality data (reworks, losses, waivers, etc.).
Quality Assurance Engineer
Performed supplier surveys (in accordance with MIL-I-45208, MIL-Q-9858) and source inspections, participated in successful ISO 9000 audit.
Initiated/revised inspection plans and drawing requirements on both ABL manufactured and procured components.
Responsible for control of nonconforming product and implementation of corrective actions.
Technical Engineer
Involved in numerous development and production programs manufacturing rocket motors/assemblies for DoD contractors and the U. S. Govt., developed test plans, analyzed ballistic and structural data, took part in development/design of rocket motor assemblies (nozzles, motor cases, etc.).
Acquired Top Secret Clearance from 1992 until RIF in 1997.
Education
The University of Alabama
Tuscaloosa, Alabama, 1989-1992
Aerospace Engineering
Graduated with Bachelor of Science in Aerospace Engineering
GPA: 3.0 in major, 3.2 overall
Honors: Tau Beta Pi and The Capstone Engineering Honor Societies, Dean's List
The University of North Alabama
Florence, Alabama, 1987-1989
Engineering
GPA: 3.4
Honors: Alpha Lambda Delta and Phi Beta Sigma Freshman Honor Societies, Dean's List
Deshler High School, Tuscumbia, AL 1987
GPA 3.9
Honor Society
Who’s Who Among American High School Students
Awards/Honors:
Tau Beta Pi membership
Completion of numerous training classes on Apex, PL/SQL, Javascript programming, Crystal Reports
Two bronze awards for Innovation (BAE Systems)
Certificates of Accomplishment (BAE Systems)
Design for Six Sigma 8.0.1 Green Belt Certification
Contact this candidate