WorkSelected 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 · DAXPick 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
ExcelSelect 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 · VBAMacros, 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.jsA 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