Application resume · KLA requisition 2639475

John P. Colgan

Sr. IT / Business System Analyst — Facilities, Workplace, EHS

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

$10.5Mannual energy / facilities savings at Walmart
EHSFord plant safety & ergonomics; KLA action-request cycle
Snowflakeingest, model, Power BI — already at KLA
3,000+utility companies; maintenance economics

Purpose

Make workplace, facilities, and EHS run on truth. The system of record should match what actually happens on the floor, in the plant, and in the bill — and a leader should be able to decide from it. I sit between GWS business owners and IT: elicit the process, design the integration, put the data in Snowflake and Power BI, run UAT, and ship. I optimize, automate, and model. I do not collect vendor badges. I have been doing this kind of work since CUB and industrial energy. I want to do it next for KLA Global Workplace Services — 3 million square feet, 135 sites, facilities, maintenance, and EH&S as one system of work, not a pile of tools.

GWS loop from floor and plant through Snowflake to an operator who can decide
The loop those GWS tools exist to run. Not a Cority or Nuvolo admin badge.

Why this role

Mapped to Sr. IT Business System Analyst, GWS / Facilities / EHS — not a generalist dump. I do not claim day-to-day Cority, Nuvolo, or Procore. I claim the job those platforms exist to do.

  • Facilities and workplace. Walmart Realty: remodels, relocations, expansions, grounds, lighting, energy efficiency, GNFR in-stock for supplies and fixtures, vendor scorecards for architects and civil engineers. CAT and gap systems: what the company system said vs what actually happened.
  • EH&S-adjacent operations. Ford Plant Safety & Ergonomics dashboard. KLA action-request cycle: field return → logistics → factory → MRB → closure. That is process + data + operators, not a slide.
  • Maintenance and utility economics. Cadence (~$1B–$1.3B national-account utility spend). 3,000+ electric, gas, and water companies. Shared-savings contracts. AEP rate design. Schedin industrial energy benchmarking. Walmart Energy ~$10.5M annual savings.
  • IT system analyst core. Requirements, current- and future-state process, UAT, third-party and internal integrations, data quality, access, architecture, vendor and C-level stakeholders. Platform owner at Ford (~5,000 developers, ~26,000 users). Snowflake + Power BI already in production at KLA.
  • Already here. Internal. Ann Arbor. Global Operations. I know how KLA ships data products, how UAT actually closes, and how to sit between a business owner and IT without becoming a ticket clerk.

Now at KLA

KLA · Global Operations

2023 – present · Ann Arbor, MI

Senior Data Analyst / Data Scientist

  • End-to-end: ingest, wrangle, model, put outcomes in front of operators — the same loop GWS needs for facilities and EHS.
  • Shipped a Snowflake warehouse + Power BI product for the action-request cycle (field return through logistics, factory, MRB, closure). Coached IT through recode. Raised defects until they were prioritized.
  • Third-party and internal feeds into BI. Hardened job error-handling. Documented pipeline architecture.
  • Validation app: date-gap/overlap, stakeholder UAT, deploy. SPC (Nelson Rules) on a manufacturing line.
  • Alteryx CoE — train, scale, optimize. Snowflake and Power BI in daily use (preferred on this posting).

Experience that maps

Ford Motor Company · Global Data Insights & Analytics

Feb 2016 – 2022 · Dearborn, MI

Manager, then Technical Expert, then Data Scientist

  • Platform owner: Alteryx, Qlik (~3,300 dashboards), ~12,000 workflows, 85 SQL databases. ~5,000 developers, ~26,000 users. Governance, access, vendor contracts, design/code reviews, UAT culture.
  • Led 18. Front line took routine tickets; I took the problems nobody else could close.
  • Plant Safety & Ergonomics dashboard — EH&S for manufacturing, not a theory.
  • Requirements and KPIs with global functions. Taught office hours. Sessions up to ~1,300 live.
Ford analytic platform: developers, tools, and users
Ford platform scale. Governance and UAT, not a slide.

Walmart · Energy, Realty, Facilities, Supply Chain, Insurance, Finance

May 2004 – Dec 2015 · Bentonville, AR

Internal consultant to C-level on realty. Builder of systems, not a report factory.

  • Facilities / workplace / energy: CAT (Colgan Audit Tool) — mine utility opportunities, drill to bill images. ~$10.5M annual savings. LED, solar-wall, fuel-switch, lighting, grounds. Store and home-office utility budgets. Shared-savings structures.
  • Realty: remodels, relocations, expansions; site/size/format models for CEO, CFO, COO. RERAP full-stack. GNFR in-stock for supplies and fixtures. Vendor scorecards for architects and civil engineers.
  • Gap systems: Walmart’s system of record vs what really happened with vendors (ship/receive, in-stock, bills) — the GWS problem in retail language.
  • Finance / insurance: home-office FP&A; ~$2.5B self-insured P&C, workers’ comp, GL.
  • 30 Alteryx servers; trained incoming data scientists. SQL Server warehouse from internal and third-party sources.
Schematic of Walmart system of record versus what vendors actually did
Gap system schematic — the GWS problem in retail language. Not the confidential model.

Cadence · AEP · Schedin · CUB

1992 – 2003

  • Cadence: architected Enterprise / B2B 3.0 (J2EE, Oracle, WebLogic) for national-account utility bill pay, audit, and consulting. 3,000+ utilities. Later acquired (Avista / Advantage IQ) — one of several systems I built that sold in the multi-million range. Independent consulting at $250/hour; shared-savings contracts.
  • AEP: cost-of-service, class rates, IRP, transmission for Midwest ISO / RTO — the economics behind plant and facilities spend.
  • Schedin: industrial siting, energy benchmarking, rate-case support. CUB Wisconsin: nonprofit fighting for residential customers in utility rate cases.
Density schematic for 3,000-plus utility companies
3,000+ utilities — density, not a list of names. Maintenance economics for plant and facilities spend.

US industrial electricity

EIA monthly average retail price, industrial sector, United States. The same series Cadence, Walmart Energy, and 3,000 utilities sat on.

Skills vs this posting

What the requisition asks

Requirements elicitation · current/future-state process · KPIs and functional specs · reporting from design through deploy · UAT · cloud application config and user management · data integrations, security, access, architecture · API integrations · Snowflake ingest/model/performance · data quality and governance · AWS/Azure · Agile/Waterfall · business-facing deadlines

What I actually run

SnowflakePower BIAlteryx (ACE)SQLPythonServiceNowSharePointAWSAzureREST / file integrationsUATdata governancevendor + C-level

Preferred GWS apps on the posting (Cority, Nuvolo, Procore, BMS, Genetec, Everbridge, Primavera, ACC): I have not been the day-to-day admin of those named products. I have been the person who makes facilities, energy, safety, and vendor systems tell the truth, and who owns integrations and UAT when IT and the business disagree. That is the hire. The product names are learnable; the judgment is not.

Education & the one credential that matters

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

Application resume for this requisition only. Job 2639475.