Adaptive and Flexible Data Analyst
I’m a business and data analytics professional with 8+ years’ experience. Demonstrated skill in development of business analytics and intelligence tools and data infrastructure to support various platforms. Ability to draw on a breadth of experiences, such as a quality manager, engineering technician, production planner and US Army active duty service. Utilizing a wide range of experience to understand business needs at many levels; resulting in exceptional solutions to complex problems that provide performance gains and cost savings.
Areas of Expertise
| Systems | Technologies | Languages |
| • Microsoft AX • SAP • Deltek Costpoint • Oracle Database • Microsoft Power BI | • Oracle Database SQL Certified Associate • SAS Certified Specialist: • Base Programming • IIS/LAMP/WAMP • Data Warehousing | • T-SQL & P/L SQL • DAX • Power Query M Formula • PHP • Python • R • SAS |
Professional Experience
Data Analyst
Hexcel Corporation, Salt Lake City, Utah 2017 – 2020
- Developed forecasting data models and dashboards to identify trends in net requirements data – reducing forecasting errors from ±20% to ±5% for six plants representing ≈$600M revenue
- Developed Power BI reports used to manage quality assurance and control processes
- Conducted analytical study of forecast variability to improve safety stock set points – explored existing data, determined natural population segmentation, selected analytical methods and designed dashboards
- Deconstructed an existing Extraction, Transformation and Load (ETL) process – implemented process improvements reducing data process time from four days to 12 hours, thereby keeping ERP and forecast data synchronized
- Implemented advanced planning and scheduling system – designed web-based tool to manage master planning data and automated ETL and EDI
Business Operations Analyst II
Albany Engineered Composites, Salt Lake City, Utah 2012 – 2017
Data Warehouse Management and BI Development
- Designed, developed and implemented data warehouses to support descriptive, predictive and prescriptive analyses
- Designed and deployed ETL processes and change management – including automated ETL for an ERP implementation from Deltek Costpoint to SAP with zero migration errors
- Conducted ad hoc business intelligence and analytics projects, such as inventory turns and labor hours per unit by part and process
- Developed, implemented and managed an intranet Business Intelligence (BI) portal used by all corporate functions – including ad hoc BI development and analytics projects, such as inventory turns and labor hours per unit by part and process
- Engaged end-users to achieve BOM accuracy to greater than 99.99% in the MRP system
Divisional ERP Project Manager, Infor LN Implementation
- Coordinated divisional requirements with the corporate ERP implementation team ($3.3 billion in revenue)
- Developed common corporate processes and conducted functional gap analysis
- Recommended ERP and business organization structure
- Evaluated enterprise data hygiene and recommended actions to improve quality
Business Analysis
- Developed key performance metrics, both ad hoc and automated analyses
- Large data set analyses (~200 million records)
- Trends and predictive analyses for labor, equipment and facilities
Production Planner/Scheduler II
Albany Engineered Composites, Salt Lake City, Utah 2011 – 2012
- Drove on-time delivery of first seven shipsets (3 substructures of the System Demonstration Test Articles) of the US Marine Corps’ CH-53K, Heavy Lift Helicopter
- Developed scheduling and tracking system for the division’s most complex system
- Developed and implemented an Earned Value Management System (EVMS) to track progress and meet Department of Defense (DoD) project reporting requirements
Forward Observer
US Army, Ft. Lewis Washington, Germany, Bosnia-Herzegovina 1991 – 1997
- Good Conduct Ribbon
- NATO Medal for service in the former Yugoslavia
- Letter of Commendation, US Army Battle Simulation Center
Education
| Western Governors University Master of Science in Data Analytics | expected 2020 |
| University of Utah Graduate courses in Information Systems | 2016 |
| Western Governors University Bachelor of Science in Business Management | 2014 |