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
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.
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.
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.
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.
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.
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.