We needed a complete overhaul of the organization’s monthly billing cycle for 600+ agents, which had become unsustainably reliant on fragmented Google Sheets and YAMM. The legacy process was plagued by "spreadsheet bloat," where complex nested lookups and manual data entry led to frequent calculation errors and a significant loss of data integrity. Furthermore, due to the technical limitations of the mail-merge tool, agents received cluttered, non-dynamic invoices that failed to filter out irrelevant line items, resulting in a poor user experience and high inquiry volume. This manual workflow consumed three full business days per cycle, reaching a critical tipping point where the department either required an immediate headcount increase or a sophisticated, automated technological solution to maintain operational continuity.

Engineered a proprietary Salesforce Billing Engine that transitioned a 24-hour manual cycle into a streamlined, one-hour automated workflow. By architecting a "one-click" execution model, I successfully migrated complex fee calculations into a centralized app that automatically generates dynamic invoices and archives a digital audit trail directly to the agent’s record. This solution not only eliminated the need for additional administrative headcount but also de-risked the department by simplifying a once-convoluted process into a repeatable, user-agnostic system.