Harold H Hawken
**.******@*****.*** 206-***-****
https://www.linkedin.com/in/harold-h-hawken-83095615
Summary of Qualifications
10+ years providing data analysis – proven analytical and quantitative skills
Highly proficient in needs-analysis, technical problem-solving, and trouble-shooting skills
Distinctive data-modeling, customer support and presentation skills
Skilled use of analytical tools – SQL and Excel functions, pivot tables, BI, VBA, and automation – to improve report flexibility and accuracy, reduce costs and turnaround time
Proven record providing business solutions – seamless database connectivity and standardized reports
Proficient ad-hoc reporting using structured or unstructured data
Demonstrated capability with program/project management processes
Current with design/manufacture/test process tracking and analysis
Strong interpersonal and communication skills with team members and customers
Knowledgeable with all phases of lifecycle project management – functional analysis to documentation
Major Accomplishments
Implemented business solutions for reliability enhancement programs
93% turnaround time reduction 60% cost decline $225,000 annual savings
Headed all-inclusive data analysis of radar repair history directly leading to a billion-dollar decision to purchase next-generation radar upgrade
Organized a cost study of the repair/replace history of all aircraft composites resulting in a lifetime in-house manufacturing decision
Design/build/test metrics – reports tripled, turnaround time down 87%, overhead down 50%, zero errors
Project Management
Managed evolution of change requests from concept through approval, impact, affordability, design, contract, implementation, manufacture, quality control, test and retrofit
Tracked failure and repair of training devices – identified cause, turnaround time, inventory management, availability and usability. Documented lessons learned and failure trends.
Coordinated schedules for on-time delivery of parts, sub-assemblies, and invoices
60% cost reduction resulting from efficient business solutions
Efficiency Improvement – better, faster, less expensive, accurate
93% report time reduction – merged multiple database reports to project retrofit cost summary
99% turnaround reduction – database failure/repair metrics improved from 3 days to 5 minutes
90% improvement – manufacture/test weekly report for budget/cost compliance
6,000 hours annual savings – automated reporting processes – sales forecasts, sales orders, actual sales, cash flow summaries; quarterly report turnaround reduced from 3 weeks to 30 minutes
Continuous Quality Improvement –Process Improvement –Quality Assurance
Coordinated training on behalf of the Institute of Configuration Management for the Puget Sound region
Directed standardized processes to reduce re-work/downtime over 50% by enhanced database connectivity
Four LEAN awards for process improvement; changes implemented to multiple reporting systems
Certifications and Information Technology skills
MCSE – Microsoft Certified System Engineer MCP – Microsoft Certified Professional
Washington State Standard Teaching Certificate Mass Shelter – American Red Cross
VBA, SQL, Excel, Access, PowerPoint, ODBC/OLE, SQL Server, Visio, COBOL, FORTRAN
Education
University of Washington Double major: BA Mathematics, BA Chemistry
United States Army Top graduate: Computer Science Institute
Military Service
United States Army Veteran Deployed/redeployed soldiers to/from the theater of operation
Honorable discharge ReForGer, Bright Star, Desert Shield, Desert Storm
Employment History .
Boeing Defense and Space Senior Staff/IT Analyst
Production Test Program Integration; USAF KC-46 Tanker; Boeing Test & Evaluation; Boeing Defense, Space & Security; Boeing Commercial Airplanes
All projects incorporate: 1– Functional analysis 2– Capture database analytics via SQL
3– Summarize metrics in MS Excel 4– Update/format all charts/reports with VBA
5– MS PowerPoint automation for director presentations 6– Documentation 7– User training
Reporting analysis and automation for offload manufacture/test
95% turnaround improved: new report process implemented to all programs
Administered database access – analytics, metrics and reporting. Shadowed approved offloads moving to manufacture, test and production, improving current status view
Created automated reports to ensure accuracy, faster turnaround, and process improvement and visibility
Responsible for multiple weekly reports to the Program Director detailing all program labor costs for improved business decisions
Created/maintained reports showing concurrency, failure summaries, availability, parts inventory, and process management for USAF trainers
Tracked failure and repair of training devices used by pilots and crew; created trend report to show downtime for each device and highlight repair cycle
Turnaround reduced: 4+ days to 20 minutes – streamlined aircraft trainer availability report
Improved compliance with the USAF
Streamlined daily standard reports – maintained configuration management documentation, improved reliability, maintainability, and dependability of business processes
Created rapid turnaround tools for multiple Change Boards, quarterly reports – better response time
Managed evolution of change requests from concept through approval, impact, affordability, design, contract, implementation, manufacture, quality control, test and retrofit – smoother process flow
Created estimating models and learning curve studies for para-estimators
Established a company-wide, centralized library indexing database for parametric estimators providing a more efficient transfer of common information
Facilitated a new process (Total Cost Management) as a blueprint for business restructuring
Analyzed commitments/costs between lifetime parts manufacture versus future contracted production, providing improved information for million dollar decisions
London Fog Pacific Trail Business Integration
Sustained company-wide standard reports and developed automation to decrease turnaround time and detect accounting errors. Web-ready reporting services implemented for multiple reports.
Teaching
Kent School District Substitute teacher, football/wrestling coach
Thomas Jefferson High School Teacher, football coach
Renton School District Teacher, football/wrestling coach
Math/chemistry/science teacher; after-school learning programs; fund raising; service groups; Project Business; private tutor
Burlington Northern Santa Fe Precision Execution Director
Directed the “Precision Execution in the Pacific Northwest” program
Tracked all trains for on-time operation and identified delay causes. Results prompted operational changes that culminated in improved on-time departures and arrivals.