Overview
Monthly Rate Adjustment is one of the most critical systems in the company. It governs how rates are created, updated, and maintained for every client, across every service we offer. Rates change constantly, contracts are amended, promotions are applied, and compliance status shifts, while making precision and speed essential.
This project involved designing a new internal application to replace a legacy process that had become a significant operational bottleneck.
The Problem
The existing system technically functioned, but only through workarounds and institutional knowledge.
Key limitations included:
No way to edit existing rate tables
No support for bundled services or promotional pricing
Thousands of rate tables with no sorting or filtering
Manual handling of client compliance states
Simple updates required deleting and recreating entire tables, forcing users to sift through more than 10,000 records to make minor changes. The result was days of avoidable work each month and increased risk in a highly sensitive process.
Goals & Requirements
The objective was to design a system that allowed specialized users to confidently manage thousands of rate tables without friction.
Primary requirements:
Add, edit, and refine rates without rework
Powerful search, filtering, and sorting
Support for bundled pricing and promotions
Clear handling of compliance-based pricing logic
Real-time updates with immediate database insertion
With each client averaging four to five rate tables, even small usability gains would compound into significant time savings.
Discovery & Research
I spent time shadowing internal users and gathering direct feedback through surveys and working sessions. This revealed not only pain points, but also how users mentally grouped rates, services, and compliance rules while working.
These insights informed both the workflow and the information hierarchy, ensuring the system aligned with real usage rather than legacy data structures.
This project focused on practical improvements that compounded quickly for a highly specialized team.
A streamlined workflow that reflects how rate updates are performed in practice.
Final designs emphasizing hierarchy, orientation, and repeatable patterns.
Final Takeaways
Designing systems that support critical business operations requires more than clean interfaces; it demands a deep understanding of how work actually gets done. This project reinforced the importance of grounding design decisions in real user behavior, especially when complexity and scale are unavoidable. The strongest outcomes came from simplifying workflows without oversimplifying the problem, allowing the system to remain flexible while protecting its most sensitive data.
Design Considerations
Default state for creating a new rate table, designed to clearly communicate next steps before any data is added.
Early synthesis work used to align on key problems, constraints, and functional requirements before design execution.
A consolidated review screen allowing users to verify rate details before committing changes.
A snapshot of qualitative feedback highlighting efficiency gains, reduced manual effort, and confidence in the new system.








