Redesigned an internal Excel tool for Optony, a consulting firm guiding public sector clients through renewable transitions.
Created a desktop and mobile web app that makes multi-million dollar fleet decisions easier to visualize, share, and act on.
Built a flexible design system, clarified data hierarchy, and created new flows for editing fleets, charger installs, and financial assumptions — all with a focus on accessibility and real-world clarity.
Designing clarity into complexity
This project was a two-week sprint transforming fleet data into intuitive tools. I overhauled the UX from an early prototype of spreadsheets and unclear interactions into a cohesive, visual system that lets users actually understand their EV transition — not just calculate it.
Turning Raw Tables into Actionable Insights
The original "Year Over Year" page was a dense wall of data — technically complete, but nearly impossible to parse quickly.
Key changes:
Grouped data into clear sections
Added sparklines to highlight trends over time
Included high/low values for quick scanning
Introduced filters and search for speed
Anchored a bar chart to give context beyond the spreadsheet
By thinking critically about what project managers need in the field, I was able to optimize a mobile interface showing the same information in a more compact form factor. At the same time, users familiar with the desktop orientation should feel right at home.
Early graphs required effort to find context.
The prior version forced users to go to a different page to adjust data controls preventing any real comparisons. By adding a new design pattern — a slide-out tray on the right side — users can make adjustments and immediately see the impact they have on their modeling.
Modernized data tables with intuitive sorting, filtering, and search.
Designed a custom mobile experience for on-the-go managers.
© 2025 All rights reserved