Work, people and the path between

John P. Colgan

Data and systems leadership. Hands-on delivery.

I turn operational questions into working systems—and help teams build the skills to use them.

Now: Sr. Data Analyst, Global Operations at KLA. Previously Ford, Walmart and enterprise utility systems.

Email JohnLinkedInCurrent workExplore the evidence

Choose a place or read the work below.
Career locations from Chippewa Falls to Ann Arbor
All career stations
    About the map

    These are career and project locations, not a literal travel itinerary. Geography is one way to explore; every role is also available as text.

    How I work

    I have led the team and been the person building the system. I combine analytical judgment with implementation: understand the question, connect the data, build the model or application, validate it with the people using it, and teach the work so others can maintain and extend it.

    Selected work

    Problems I have helped solve, systems I have built, and teams I have enabled.

    Manufacturing signals that operators can act on

    Bring manufacturing data, statistical signals and operational reporting into one notification platform.

    • Product owner and solution architect for a near-real-time manufacturing notification and analytics platform using Snowflake, Power BI, statistical process control and Nelson-rule signals.
    • The manufacturing notification platform has a requirement for operator feedback within five minutes; this is not a measured production-latency claim.
    • Delivered a validation application with date-gap and overlap logic, stakeholder user-acceptance testing and deployment; also hardened job error handling and documented data-pipeline architecture.

    Snowflake · Power BI · SPC · UAT

    Read the supporting work

    Help analysts build production-ready work

    Turn useful local ideas into governed, supported data products while developing the people who build them.

    • Led delivery of the approved analytics democratization program at KLA, enabling analysts to develop dashboards and data models with corporate-approved tools, security controls, automation and production IT support.
    • Led analytics democratization at Ford, helping local models become governed, IT-supported assets through approved tools, access controls, design reviews and code reviews.
    • Supported developers through office hours, lunch-and-learns, third-level technical support and live training sessions with as many as 1,300 attendees.

    Alteryx · Power BI · data governance · teaching

    Read the supporting work

    Lead the team and the platform

    Combine people leadership with responsibility for a large analytics environment.

    • Rebuilt and led an 18-person analytics enablement team of product designers, data scientists, data engineers and software engineers.
    • As platform owner, managed the Alteryx and Qlik environment serving approximately 9,000 developer licenses and 26,000 end users, with 85 SQL databases on more than 100 application servers.

    Alteryx · Qlik · SQL Server · platform governance

    Read the supporting work

    Test the growth plan against the market

    Use customer, geospatial and financial models to inform consequential planning decisions.

    • Used geospatial and financial analytics, including cannibalization and customer models, to support executive review and an approximately 50% reduction in Walmart's planned ten-year square-footage growth.
    • Built the full-stack Real Estate Research and Planning application. A real estate manager used to spend 6–8 hours entering a project. RERAP needed a latitude and longitude and the facility type. That was a Walmart Supercenter with its square-footage category, a Sam's Club with its square-footage category, or a Neighborhood Market. The manager then entered only what Walmart did not already store, such as the project tax, how the parcels were aggregated, and the resale of those parcels. A Walmart brings traffic, so those parcels often resold at a higher rate. Cities often gave the land to bring in a Supercenter. The system earned monetary reward and recognition. Walmart later paid millions to replace it with a New York City company's live Excel solution. That tool could re-run every project on the current financial model, including projects approved under an older model version. The team was already doing that. The handoff was clunky, and the replacement was not smooth.

    Geospatial analysis · financial modeling · Alteryx

    Read the supporting work

    Connect utility economics to action

    Combine rates expertise, negotiation and audit software to identify and deliver savings.

    • Contributed approximately $10.5M in annual Walmart energy savings through rate negotiation, tariff analysis, bill audits and shared-savings work. Many stores were on the wrong rate and were being overcharged. One of many such deals treated the Walmart locations in Fayetteville, North Carolina, as one customer, billed on coincident demand instead of non-coincident demand. Walmart did not want the accounting allocation. The allocation was small, automated, and simple enough for an entry-level person to run, and the financial benefit carried the decision.
    • Negotiated a ten-year Walmart energy contract at $0.03 per kWh.
    • Built the Colgan Audit Tool so others could identify Walmart stores, Sam's Clubs, and Neighborhood Markets on the wrong rate or with a billing error, and drill from the finding to the bill.

    Tariff analysis · negotiation · audit automation

    Read the supporting work

    Build enterprise utility software

    Translate utility-domain expertise into implemented software and reporting capabilities.

    • Architected Cadence Enterprise / B2B 3.0 using J2EE, Oracle, SQL Server and BEA WebLogic, including reporting, dynamic grouping and Site at a Glance capabilities.
    • Worked on national-account utility bill payment, audit and consulting representing approximately $1B–$1.3B in annual utility spend across thousands of utility companies. The same wrong-rate and billing-error work covered accounts including Blockbuster, Winn-Dixie, Service Merchandise, Barnes & Noble, and Circuit City, and produced over $3 million in savings for national-account customers.

    Java / J2EE · Oracle · SQL Server · WebLogic

    Read the supporting work

    Keep building and operating software

    Independent applications demonstrate hands-on engineering alongside the corporate career.

    • Design, build and operate Push Pull Survival, a production web game using Node, Express, MongoDB and Valkey, with Stripe, OAuth, PWA support and an iOS shell.
    • Build Hark the Herald, a Swift macOS application with separate operator and congregation displays for lyrics and scripture, plus a Node-based collaboration helper and timing-data services.
    • Rebuilt The Dog Track software across Delphi, Java and Node.js generations; the current application includes payments, authentication, databases and multiplayer capabilities.
    • Built a social work exam practice app. New questions come first, and missed answers return until the bank has been seen.
    • Built Origin, shift playbooks for the checks, lots, and purchase orders a small shop runs before it opens and after it closes, plus a private workspace that files a problem as a causal case.
    • Built Barkstone, a CoffeeMUD world with seasons, a watched roster, and characters born from an approved list of races and classes.
    • Maintain a Zangband fork with a macOS app and its own autoplayers. Character birth can roll millions of stat lines and keep the best.
    • Built recovery and control apps for an older iFit treadmill console, and a private course host the console loads.
    • Built Colgan Capital, a rules-based desk for a capped long-only book of stocks and crypto. The owner places every order. Balances and broker details stay off the public page.

    JavaScript / Node · Swift · MongoDB · cloud operations

    Read the supporting work

    Current work

    KLA

    Apr 2023 – present · Hybrid · Global Operations

    Sr. Data Analyst

    • Manufacturing notifications. Product owner and solution architect for a near-real-time notification and analytics platform using Snowflake, Power BI, statistical process control and Nelson-rule signals. Operator feedback within five minutes is a requirement, not a measured latency result.
    • Analytics democratization. Led delivery of an approved program helping analysts turn local models into governed, production-IT-supported dashboards and data products. Previously led this kind of enablement at Ford.
    • Operational visibility. Built ServiceNow API-based reporting across onboarded Global Operations departments for leadership review of tickets, status and bottlenecks.
    More delivery and technical scope
    • Led self-service intake from requirements and process design through IT/business coordination and deployment.
    • Delivered an action-request cycle warehouse and Power BI product spanning field return, logistics, factory review and closure.
    • Delivered validation-app date-gap/overlap logic and stakeholder UAT; hardened job error handling and documented pipeline architecture.
    • Work spans manufacturing, logistics, service, warranty, quality, suppliers and HR. Alteryx Center of Excellence training and optimization.

    Experience

    Career experience

    KLA · Sr. Data Analyst, Global Operations · Apr 2023 – present

    Ford Motor Company · Manager, Analytic & Visualization Enablement Tools · May 2021 – Jul 2022

    Ford Motor Company · Technical Expert, Alteryx · Aug 2019 – May 2021

    Ford Motor Company · Data Scientist, Manufacturing Descriptive Analytics · Jan 2016 – Aug 2019

    Walmart · Sr. Manager II, Strategic Analytics & Business Intelligence · 2014 – 2015

    Walmart · Sr. Manager II, Risks & Benefits FP&A · 2011 – 2014

    Walmart · Project Manager III, Supply Chain Innovations · 2009 – 2010

    Walmart · Sr. Manager, Real Estate Research & Planning · 2006 – 2009

    Walmart · Manager, Energy · 2004 – 2006

    Cadence Network · Rates Analyst & Senior Software Engineer · May 1998 – Dec 2003

    American Electric Power · Utilities Rate Consultant · Mar 1997 – May 1998

    Schedin and Associates · Utility Rates Analyst · Fall 1993 – 1996

    Ford Motor Company

    Jan 2016 – Jul 2022 · Dearborn, MI

    Manager, Analytic & Visualization Enablement Tools · May 2021 – Jul 2022

    • Rebuilt and led an 18-person team of designers, data scientists, data engineers and software engineers.
    • Owned the Alteryx/Qlik platform serving approximately 9,000 developer licenses and 26,000 end users, with 85 SQL databases on 100+ application servers. Led vendor coordination, access, governance, design and code reviews.
    • Led analytics democratization: a governed path from a local model to a supported production asset. Product owner of analytic-object governance and platform-relevancy reporting.

    Technical Expert, Alteryx · Aug 2019 – May 2021

    Office hours, lunch-and-learns, third-level technical support and live training with as many as 1,300 attendees. Helped developers build and sustain their own analytical work.

    Data Scientist, Manufacturing Descriptive Analytics · Jan 2016 – Aug 2019

    Worked with engineering and manufacturing leaders on the Plant Safety & Ergonomics dashboard, jobs-per-hour KPIs, and models for vehicle-complexity reduction. Tools included Alteryx, DataRobot, QlikView, Java, D3.js, HPC, Hadoop and SQL Server.

    Independent consulting

    March 2021 – January 2022 · during Ford

    Casey Roberts (StatRecover.com), a person I had worked with at Walmart, recommended me. The Retail Firm in Bentonville, Arkansas, Joshua Breeden, hired me. From March 2021 through January 2022 I programmed the vendor-audit automation in the Alteryx software on evenings and weekends, while still at Ford. This engagement was separate from the earlier Cadence role. The Stable acquired the firm in 2021. The January 31, 2022 meeting with Breeden was at The Stable. Accenture acquired The Stable later in 2022.

    Walmart

    May 2004 – Dec 2015 · Bentonville, AR

    Eleven years across energy, real estate research and planning, supply chain, finance, insurance and business intelligence.

    Sr. Manager II, Strategic Analytics & Business Intelligence (Realty) · 2014–2015

    Vendor scorecards, goods-not-for-resale reporting and reconciliation between company records and vendor activity. Built out reporting data sources and 30 Alteryx servers; trained incoming data scientists.

    Sr. Manager II, Risks & Benefits FP&A · 2011–2014

    Budgets, forecasts, accruals and reserves, including the annual actuarial view of an approximately $2.5B self-insured book covering property, casualty, workers’ compensation and general liability.

    Project Manager III, Supply Chain Innovations · 2009–2010

    Modeled vendor-to-distribution-center-to-store flow and replenishment. Moved a flow-path simulator from Excel into a web application. Built a shelf out-of-stock model from stocking frequency, shelf size, demand, back-room space, and case-pack size. Sam’s Club laptop analysis supported a push/pull/push flow.

    Sr. Manager, Real Estate Research & Planning · 2006–2009

    Used geospatial and financial analytics—including cannibalization, customer behavior and growth models—to evaluate concerns about overbuilding. The analysis supported executive review and an approximately 50% reduction in the planned ten-year square-footage growth. The work included an effective population index, a cost-of-living adjustment, trade-area methods, store-sizing guidance, and sister-store clustering. I sat on the Real Estate Executive Committee. Built the full-stack Real Estate Research and Planning application and trained domestic and international teams. A real estate manager used to spend 6–8 hours entering a project. RERAP needed a latitude and longitude and the facility: a Walmart Supercenter with its square-footage category, a Sam’s Club with its square-footage category, or a Neighborhood Market. The manager then entered only what Walmart did not already store, such as the project tax, how the parcels were aggregated, and the resale of those parcels. A Walmart brings traffic, so those parcels often resold at a higher rate. Cities often gave the land to bring in a Supercenter. The system earned monetary reward and recognition. Walmart later paid millions to replace it with a New York City company’s live Excel solution. That tool could re-run every project on the current financial model, including projects approved under an older model version. We were already doing that. The handoff was clunky, and the replacement was not smooth.

    Manager, Energy · 2004–2006

    Negotiated a $0.03/kWh ten-year contract. Contributed approximately $10.5M in annual energy savings through rates, tariffs, bill audits and shared-savings work. Many stores were on the wrong rate and were being overcharged. One of many such deals treated the Walmart locations in Fayetteville, North Carolina, as one customer and billed them on coincident demand instead of the previous non-coincident billing. That deal was a major savings. Walmart did not want to do it. It required an accounting allocation, and people were afraid of that even though the allocation was small. The financial benefit carried the decision. The allocation was automated and simple enough for an entry-level person to run. Built the Colgan Audit Tool so others could find Walmart stores, Sam’s Clubs, and Neighborhood Markets on the wrong rate or with a billing error, and drill from the finding to the bill.

    Cadence Network

    May 1998 – Dec 2003 · Cincinnati, OH

    Rates Analyst & Senior Software Engineer

    Architected Cadence Enterprise / B2B 3.0 using J2EE, Oracle, SQL Server and BEA WebLogic, including reporting, dynamic grouping and Site at a Glance. National-account utility work represented approximately $1B–$1.3B in annual spend across thousands of utilities. The same wrong-rate and billing-error work covered accounts including Blockbuster, Winn-Dixie, Service Merchandise, Barnes & Noble, and Circuit City, and produced over $3 million in savings for those customers. Cadence Network was later acquired by Advantage IQ in 2008.

    American Electric Power

    Mar 1997 – May 1998 · Columbus, OH

    Utilities Rate Consultant, Energy Pricing and Contracts

    Cost-of-service and class rates, resource-planning forecasts, transmission cost functionalization and special-contract bill verification, including a 100+ MW real-time-pricing industrial account.

    Schedin and Associates

    Fall 1993 – 1996 · Minneapolis

    Utility Rates Analyst

    Industrial siting, benchmarking, rates and rate-case support. Wrote testimony, rebuttals, and rate impacts for an expert witness, and did analysis for the Chicago Area Energy Users. Built energy-retrofit data and utility-allocation software for facilities, including a mall and office tower.

    A lesson about helping the next person succeed

    An early mentor’s lesson stayed with me: the work should continue when one person moves on. That is why I spend time teaching, documenting and helping others take responsibility for a system.

    Utility consulting

    Rate analysis, audit and decision support, including shared-savings agreements tied to verified savings.

    Earlier work, entrepreneurship and life beyond the office

    Norwest Bank

    Fall 1993 · Minneapolis

    Data entry and loan processing.

    High Shores Haus

    1986–1993 · Chippewa Falls / Lake Wissota, Wisconsin

    Worked through school, progressing from grounds and dishwashing to bar support, preparation and cooking. Learned the responsibility behind keeping service running, from weekend ribs and prime rib to the Monday-night kitchen.

    Through school

    In Chippewa Falls, night manager and grocery work at Gordy’s IGA, and shift leader at Super America. A summer job at St. Croix Meadows in Hudson. Student jobs at UW–Madison were food service and construction while the economics degree was in progress.

    Colgan Renewables, LLC

    2003–2004 · Ohio company; Minnesota wind project

    Developed a proposed 12 MW wind project at Luverne on Buffalo Ridge. The project did not proceed after financing was lost. The experience added an owner’s perspective on planning, capital and execution risk.

    Rogers, alongside Walmart

    Owned commercial real estate and an antique store in Rogers, Arkansas during the Walmart years.

    Colgan Farmstead, LLC

    2023–present · Ypsilanti, MI

    Hands-on work beyond software: crop rotation, a pond, gardening, firewood and chickens. I value the physical work and the responsibility of maintaining something over time.

    Independent systems

    Current software that I design, build and operate. Explore the technical designs.

    Push Pull Survival

    A tactical game for browser and mobile play. Hands-on application design, state management, backend services, accounts and payments.

    Node · Express · MongoDB · Valkey · Stripe · OAuth · PWA · iOS shell

    The Dog Track

    An independent racing-software project rebuilt across Delphi, Java and Node.js generations, now including multiplayer, authentication and payments.

    Delphi · Java · Node.js · cloud operations

    Hark the Herald

    A native macOS application helping operators present synchronized lyrics and scripture, with separate operator and congregation displays.

    Swift · Node helper · timing data · MongoDB

    Explore the collaboration helper

    Social Work Exam practice

    A practice app for the social work exam. New questions come first, and missed answers return until the bank has been seen.

    Node · MongoDB · Valkey · DigitalOcean

    Origin

    Shift playbooks for the work a small shop does before it opens and after it closes: ordered checks, material lots, and purchase orders. A separate private workspace files a problem as a causal case.

    Next.js · recipes · purchase orders

    Barkstone

    A CoffeeMUD world with seasons, a watched roster, and characters born from an approved list of races and classes.

    Java · CoffeeMUD

    Zangband

    A maintained fork with its own macOS app and autoplayers. Character birth can roll millions of stat lines and keep the best.

    C · Cocoa

    iFit Offline

    Recovery and control apps for an older iFit treadmill console, and a private course host the console loads.

    Android 2.2 · Node

    Colgan Capital

    A rules-based desk for a capped long-only book of stocks and crypto. It watches more names than a person can mark by hand. The owner places every order.

    Python · long-only rules

    Capabilities

    Languages

    SQLPythonJava / J2EEJavaScript / NodeCObject Pascal / DelphiSwiftVBAPL/SQLregular expressionsshell

    Analytics

    Alteryx (ACE)Alteryx BIDataRobotSnowflakePower BIQlikView / Qlik SenseTableauD3.jsSPSSExcelneural networks

    Data

    OracleSQL ServerTeradataPostgreSQLMySQLDB2 / InformixMongoDBHadoopEssbase

    Platforms

    AWSAzureDigitalOceanServiceNowSharePointBEA WebLogicREST and file integrations

    Methods

    requirementsprocess mappingKPI designUATdata governanceSPCgeospatialoptimizationdiscrete optimizationHPCautomationbig datacustomer segmentationutility rate analysismodelingbusiness intelligencevendor & executive stakeholders

    Community and service

    Main Street Rogers

    Board member · Jan 2012 – Jan 2015

    Helped sustain and promote the historic downtown. Chaired the 2012 Frisco Festival, a community event of about 30,000 people. I kicked it off and recognized the sponsors and other significant contributors.

    A moment from the festivalJohn Colgan on stage kicking off the 2012 Frisco Festival and recognizing sponsors and contributors.

    Citizens Utility Board of Wisconsin

    Volunteer · Mar 1992 – Aug 1993 · Madison

    Researched power-plant emissions for residential utility customers while at UW–Madison—the beginning of my utility-economics career.

    Education

    University of Wisconsin–Madison

    B.Sc. Economics with a Math Emphasis · August 1993

    Coursework in electrical and computer engineering and advanced data structures alongside the economics major.

    In 2015, keynote speaker for the Economics Student Association at the university.

    Recognition

    Alteryx ACE, 2015; ACE Emeritus, 2019. Ford Top Achiever, 2018. Walmart Top Performer. Walton Institute, 2007.

    Additional development and recognition

    Walmart Store Planning Associate of the Month, 2004; Vendor Software Best Practices award, 2009; ALPFA Institute Certificate of Leadership in Board Service, 2012; Dale Carnegie course, 1999.

    Career at a glance

    School and service work → Citizens Utility Board and Schedin → American Electric Power → Cadence → Walmart → Ford, including The Retail Firm consulting → KLA, alongside independent software and community work.

    Explore the fit for a role

    Paste a job description to select relevant work from this record. The result is a draft for review—not an application submitted on your behalf.

    Your description may be sent to the AI provider. Do not include confidential information. It is not published as a page or saved by this matching feature.