Ann Arbor · Alteryx ACE 2015 · application resumes

John P. Colgan

I optimize, automate, and model so C-level leaders can decide.

[email protected] linkedin.com/in/johnpcolgan Alteryx ACE

2015Alteryx ACE, now emeritus
26kFord analytic users on platforms I owned
$10.5Mannual energy savings at Walmart
3,000+utility companies worked with

Resume for this application

Each job gets its own page. Pick the one that matches the requisition.

KLA GWS — Facilities, Maintenance, EHS

Requisition 2639475 · Sr. IT Business System Analyst

Workplace, facilities, and EH&S systems of record. Snowflake, Power BI, UAT, integrations. Internal candidate, Ann Arbor.

This page — general

Default application resume

Optimize, automate, model, C-level decisions. KLA, Ford, Walmart, utilities. Use this when there is not a dedicated cut yet.

Purpose

Sit between business owners and IT. Make the system of record match what actually happened. Put a number in front of a leader who has to decide. I do not collect certificates. I ship.

Now

KLA

2023 – present · Ann Arbor, MI

Senior Data Analyst / Data Scientist, Global Operations

  • End-to-end data products: ingest, wrangle, model, operators.
  • Snowflake + Power BI action-request cycle (field return through logistics, factory, MRB, closure).
  • Third-party and internal integrations, UAT, documented architecture, Alteryx CoE.

Experience

Ford Motor Company

Feb 2016 – 2022 · Dearborn, MI

Manager, Analytic & Visualization Enablement Tools · Technical Expert · Data Scientist

  • Platform owner: Alteryx, Qlik (~3,300 dashboards), ~12,000 workflows, 85 SQL databases. ~5,000 developers, ~26,000 users globally.
  • Led 18. Governance, vendor contracts, UAT culture. Plant Safety & Ergonomics. Lightning Bolt complexity reduction.

Walmart

May 2004 – Dec 2015 · Bentonville, AR

Sr. Manager II — Energy, Realty, Supply Chain, Insurance, Finance

  • Internal consultant to C-level on realty. Energy ~$10.5M. Facilities, vendor scorecards, gap systems (Walmart’s books vs what vendors actually did).
  • RERAP, GNFR, ~$2.5B self-insured actuarial view, Sam’s Club push/pull, 30 Alteryx servers.

Cadence · AEP · independent consulting

1997 – 2003 and alongside

  • 3,000+ utility companies. Shared-savings contracts. Cadence Enterprise / B2B 3.0 (J2EE) later acquired — Avista / Advantage IQ. Independent work at $250/hour.
  • AEP rate design and Midwest ISO / RTO. Systems I built that later sold in the multi-million range.

Skills

SQLPythonAlteryx (ACE)SnowflakePower BIQlikJava / J2EEJavaScript / NodeAWSAzureServiceNowUATdata governance

B.Sc. Economics with Math Emphasis, University of Wisconsin–Madison, 1993. Alteryx ACE (2015). Ford Top Achiever (2018). Walton Institute (2007).