PORTFOLIO
PORTFOLIO
*This page is still being updated. Thank you for your patience.
Embedded Files
Explore the possibilities.
While most of my client work is private, each project solves real challenges with structure, automation, and thoughtful design. Some projects may fall under more than one category of design intention.
Academic and Club
Business, Organization, and Operational
Custom
Academic and Club
Academic and Club
__________
Business, Organization, and Operational
Business, Organization, and Operational
> BRUNOS HEALTH INSURANCE DATABASE
Built for a health insurance provider, this system turns dozens of scattered spreadsheets into one intuitive, automated hub. It tracks client plans, birthdays, dependents, policy expirations, provider info, referral sources, and more -- surfacing exactly what matters, when it matters. Automatic email reminders go out to both the provider and the clients, birthdays sync with Google Calendar, and upcoming renewals prompt action without a second thought.
Due to the sensitivity of the data, I can’t showcase the full system -- and without the inputted data, it wouldn’t tell the full story. But behind the scenes, it’s a carefully engineered dashboard designed to eliminate clutter, reduce oversight, and keep everything on track.
__________
Custom
Custom
> WAGE & HOUR TRACKING SPREADSHEET [TEMPLATE]
Whether you're in food service, retail, or any job with shifting hours, this wage tracker gives you a clear view of what you’ve earned -- before payday. Just log your hours and watch as it blocks out your calendar, calculates real-time earnings, tracks pay periods, and tallies your YTD totals automatically. Originally built while working restaurant shifts with fluctuating pay, it’s perfect for anyone who wants more clarity, less guesswork, and a smarter way to manage their income.
This was one of the first truly complex tools I ever built -- and after four years of refining it, I still use it every week. Originally made to track my ever-changing restaurant hours, it’s displayed some interesting and surprising logic puzzles. I've been able to include layered conditional formatting, and custom Apps Script features, leading to one of my msot usefuls builds.
Explore the Wage & Hour Tracking Template here
*Template is currently being upgraded.
> RATING SPREADSHEET [TEMPALTE]
This flexible scoring system helps you rank coffee shops, restaurants, libraries (or anything else) based on what actually matters to you. Customize your criteria, assign weights, and let the spreadsheet handle the math. Track top picks, jot down notes, and compare spots with clarity. Fun to use, surprisingly powerful -- and totally personal to how you explore.
Explore the Rating Spreadsheet Template here
Your top picks -- clearly ranked, all in one place
I originally built this to rate every coffee shop in Berkeley -- and yes, I’ve tried nearly all of them. My friends kept asking for their own, so I turned it into a template. Now it’s our go-to tool for picking the perfect study spot.
__________
Page updated
Google Sites
Report abuse