Summary
Overview
Work History
Education
Skills
Timeline
Generic
Darren McCroskey

Darren McCroskey

Vancouver,WA

Summary

Results-driven Microsoft Business Intelligence professional with over 10 years of experience designing and managing comprehensive BI solutions for manufacturing. Specializes in transforming flat files and production feeds into automated Power BI solutions and data pipelines, ensuring data accuracy and governance. Recognized trainer in BI solutions across a global workforce, effectively translating business needs into actionable analytics.

Overview

16
16
years of professional experience

Work History

QA Analyst

Tetra Pak USA
Vancouver, WA
05.2010 - 08.2026

Jun 2023 – Aug 2026 (Quality Assurance Analyst)

Jan 2019 – Jun 2023 (Quality Maintenance Lead)

May 2010 – Jan 2019 (QA Lead)

  • Validated and maintained 100% data integrity across large datasets; executed multi‑level validation and reconciliation on ~6 million rows from 30+ sources by creating several validation gates to remove any invalid data with built-in views to check and correct any invalid data.
  • Built secure data pipelines and semantic models (Power BI / Fabric / SSMS / Automate / Excel) to support daily management system DMS locally and monthly KPI/KAI reporting globally; implemented scheduled refreshes, incremental loads, and automated email distribution.
  • Developed automated calibration registry with weekly emails in Power BI, Excel, SharePoint, and Power Automate to centralize calibration schedules, status, and alerts, enhancing calibration oversight and minimizing missed calibrations.
  • Implemented governance and documentation control for ISO, SQF, FDA, USDA, Master Data, and other confidential documents; authored SOPs, QWIs, and QMS documents while ensuring ISO-compliant documentation as ISO-certified auditor.
  • Designed and delivered end-to-end Microsoft BI solutions from 30+ data sources to enterprise Power BI reports and dashboards for local managers and global executives.
  • Applied continuous improvement methodologies (Kaizen, Six Sigma, WCM) to run successful improvement teams; led root‑cause analyses and corrective actions that improved KPI reliability; skilled in SPC, Six Sigma green belt and Minitab
  • Delivered professional interactive operational dashboards with multi-level drill‑throughs, bookmarks, and row‑level security enabling faster production floor decisions and targeted corrective actions.
  • Collaborated with safety, quality, production, and finance teams to translate business requirements into data models, KPIs, and maintainable reports; trained end users and created maintenance and OCAP documentation.

Education

High School Diploma -

Prairie High School
Brush Prairie, WA
06-2002

Skills

  • BI and Reporting: Power BI Desktop; Power BI Service; Power BI Dataflows; semantic models; DAX; Power Query (M)
  • Cloud and Platform: Microsoft Fabric; Azure SQL; SSMS; Apps creation
  • ETL design
  • Query tuning; Pipeline management
  • Data governance; security
  • Power Platform: Power Automate; Power Apps integrations
  • Data validation
  • Project management
  • Tools: Excel (advanced), SharePoint, Teams, Minitab, Git (basic)
  • Six Sigma; Statistical Analysis

Timeline

QA Analyst

Tetra Pak USA
05.2010 - 08.2026

High School Diploma -

Prairie High School
Darren McCroskey