Crucially, all work described in this case study was performed within the existing production application without disrupting the day-to-day operations of the heavily used system. A continuous delivery strategy (Azure DevOps pipelines) that incorporates feature flags (Launch Darkly) allowed Mercury to perform new development without impacting current daily users.
Enterprise Data, Operations and Reporting in the Cloud
Founded in 2006, Franklin Street has become one of the fastest-growing full-service commercial real estate firms in the Southeast with a national reach. Through its multiple locations, Franklin Street provides a full complement of commercial real estate service lines including Investment Sales, Management Services, Tenant and Landlord Representation, Capital and Insurance services.
After several years of active growth, Franklin Street’s business line agents had adopted myriad real estate industry point solutions to run their day-to-day operations. This software included independent desktop-installed software packages and client-server systems running on premises. While agents were enabled in their individual work, the software sprawl introduced a lack of cohesion across the company and significant manual work to produce business reports. Franklin Street knew they needed to use technology to leverage its team’s extensive market intelligence and industry expertise and create a point of competitive advantage.
The Challenge – People, Properties and Activities
People and Companies
The cornerstone of every Franklin Street business process is the client – properly researching, engaging with, intuiting business needs and tracking interactions are key to forging a deep business relationship. The customer relationship management (CRM) aspects of Frankie enable Franklin Street professionals to do just that – associate all contacts with relevant properties and business activities, track all phone calls, emails and other touches and compile a detailed dossier of every partner.
Each deal that Franklin Street manages revolves around a piece of real estate property. The Frankie CRM provides long-term tracking and management of these properties including a wide array of property attribute data, historical ownership history, and detailed history of each transaction and service type associated with the property. This linkage allows visibility across business lines to facilitate cross-selling and proved the clients with a rich, unified experience.
Each deal that Franklin Street manages are complex, long-running transactions. Frankie allows agents to easily manage transaction by capturing all relevant data points, performing analytical computations and capturing all associated documentation so that Frankie becomes the single source of truth for that deal. Workflow management with progressive validation rules ensure data quality. These complex deals are managed by multiple internal agents collaborating with outside agents from other firms, and Frankie performs all the detailed commission calculations and splits to track every dollar from invoice to payment receipt to distribution.
Financials at Their Fingertips
Prior to expanding Frankie to accommodate detailed transaction tracking, the use of disparate and non-integrated systems required a significant amount of manual work to pull all the information together. By unifying these processes into a single enterprise system, agents manage the individual transactions and all financial data is derived from this data.
The manual process involved creating individual spreadsheets for each deal and manually transcribing transaction data from the various systems into the spreadsheet. In the new system commission calculations are performed in real time and each agent has immediate visibility to their distribution amounts. As the details of the transaction change the commissions are recomputed immediately. Once the deal is complete, an automated workflow allows each agent to perform a final review and approval of their commissions. Once finalized, Frankie generates a consolidated report for Accounting that documents exactly who needs to get paid what.
We developed Franklin Street’s Frankie using these core technologies: