Matthew
Collard
Business Intelligence Analyst
Results-driven analyst with 4+ years of experience in healthcare and financial services. I specialize in data quality, pipeline automation, and turning messy enterprise data into trusted, consistent solutions.
01 Areas of Expertise
Data Engineering
Python-driven pipeline development, automated validation, source-to-target mapping, ETL workflows, and SQL-based reconciliation across systems with differing primary keys.
Business Analysis
Requirements elicitation, gap analysis, current/future-state process mapping, UAT coordination, and stakeholder sign-off for enterprise-level implementations.
Business Intelligence
Building dashboards and reports in Tableau and Power BI; advanced Excel automation (VBA, Power Query, Pivot Tables) to surface insights for decision-makers.
Process Optimisation
Six Sigma Black Belt methodology applied to continuous improvement initiatives — root cause analysis, lean waste elimination, and capacity planning.
02 Professional Experience
Business Analyst
ICCULed end-to-end evaluation and implementation planning for the NICE/Actimize Xceed fraud prevention platform, producing business requirements that enabled real-time fraud detection across ACH, wires, checks, and RTP payment channels. Defined source-to-target data mapping and SFTP ingestion specs for auditable cross-system data transfer.
- Elicited and documented functional & technical requirements from multiple frontline business units
- Conducted gap analysis and process mapping for STIP reconciliation workflows
- Identified automation opportunities reducing manual processing time
Business Analyst
Blue Cross of IdahoBuilt automated data ingestion and reporting pipelines in Python to standardise non-uniform membership data, enforce quality rules, and surface discrepancies across 76 sub-groups — eliminating 100+ hours/month of FTE manual effort.
- Automated validation pipeline for 76-sub-group enrollment dataset — eliminated 100+ FTE hours/month
- SQL monitoring of enrollment workflows across systems with differing primary keys
- Led team of 6 analysts in organisation-wide capacity analysis delivering year-long improvement roadmap
- Reduced full-time processing hours by 2% monthly through targeted workflow improvements
Area Manager
Amazon Fulfillment CenterCoordinated shift planning for daily production goals exceeding 300,000 units. Applied advanced Excel analysis of associate production data to develop coaching strategies for 80+ hourly associates.
- Set building and regional shift records of 475,000 units via cross-department labor coordination
- Increased process headcount by 80% through strategic staffing
Assistant Operations NCO
United States ArmyNine years of progressively responsible leadership — supervising soldiers, managing high-value equipment, and leading small teams through 700+ combat missions. Conducted high-level command briefings and collaborated on long-term unit strategy.
- Led 700+ combat missions across multiple deployments
- Earned Drivers Badge for sustained accident-free record
03 Technical Competencies
Languages
BI & Visualisation
Cloud & Platforms
Methodologies
Certifications
04 Education
B.S. Business — Operations Management
University of Idaho, Moscow ID
A.A. Business
College of Western Idaho, Nampa ID
Selected Work
See What I've Built
A collection of data projects, automation pipelines, and analytics work.
Browse Projects →