Heath Ponder
Work

Selected work

Reporting tools, data cleanup and web builds from Murphy USA, Whole Foods Market and Wymzy. Full write-ups are on the way; employer work will be shown with sample numbers and rebuilt screenshots.

Murphy USACase study coming soon

Change-in-performance tool

Power BI · DAX

Pick any two periods and get the change and percent change across fuel gallons, CPG, merchandise sales and other operating metrics. The team’s standard tool on each quarterly data release.

  • Power BI
  • DAX
  • Data model
  • Variance analysis
Murphy USACase study coming soon

One-click state reporting packet

Excel

Select a state and export the quarterly pipeline-and-portfolio packet to PDF, for every state, each growth market and the whole company.

  • Excel
  • Automated PDF export
  • Reporting
Whole Foods MarketCase study coming soon

Pricebook cleanup macros

Excel · VBA

Macros, recorded and then edited and debugged in the VBA editor, that merged and formatted files, matched cost files to find mismatches and cleaned supplier files for upload.

  • Excel
  • VBA editor
  • Data quality
  • Reconciliation
WymzyCase study coming soon

Client portal and custom sites

React · Next.js

A client portal where owners edit their own site content, receive customer messages and manage files, plus seven custom websites built end to end.

  • React
  • Next.js
  • TypeScript
  • UI/UX