Résumé

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

SystemsTechnologiesLanguages
• 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

Leave a Reply

%d bloggers like this: