Frankie – Data, Application and Mobile in the Cloud

The Plan

Make no mistake, comprehensive customized inventory management systems don’t build themselves and certainly don’t come with obvious designs. The design-planning phase is essential to craft the user experience, prepare the technical approach to suit the client’s needs and plan for broad and deep functionality. Planning steps taken for Frankie include wireframes, mock-ups, icon development, data planning and infrastructure.


Wireframes were created based on client feedback and refined throughout the project. One was made for each application page and section navigation.


The design was planned to be responsive early on in the design process. This was first implemented in a Sandbox design.

Big Data

Frankie’s data wasn’t to be taken lightly, which includes challenges of analysis, capture, curation, search, sharing, storage, transfer, visualization, and information privacy.

Cloud Deployment

Microsoft’s Azure Cloud was selected for utility and consumption of burstable computing resources. Frankie’s cloud deployment includes a variety of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) resources that provide centralized and scalable data storage and compute.

UI/UX Features

Once the plan is in place it’s time to start building. However, it’s often useful to test various elements outside of the actual project. This is where a Sandbox design comes into play. A Sandbox design allows for the creation of a skeleton of the site to create the initial coded structure, test the design elements and adjust accordingly, and create a test environment for any custom jQuery/JavaScript or any other interactive elements that may need to be developed/customized.

People, Properties, Activities and Companies

The cornerstone of every Franklin Street business process is the client – properly researching, engaging with, and 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.


"Mercury team members have the unique ability to blend forward looking thinking and innovative technology with pragmatic and practical ideas for implementing."
Darron Kattan
Managing Director

Built Using

C#, MVC, Entity Framework and the .NET Framework were used to implement all business logic, data marshaling and UI rendering for the Connection application.  Supporting use of modern CSS and JavaScript provided interaction and responsive display.

Provides a robust data storehouse and query platform to store course content, student data, resource library content and other business data.  In-cloud SQL Server was used to provide instant scalability and rapid querying.

Provides database storage, web app, authentication and web services. Azure provides an ideal solution for back end mobile applications with a multi-data center Platform as a Service (PaaS) cloud solution that requires extremely little oversight.

Online Listings

In addition to providing a scalable and collaborative information system for the company, Franklin Street’s website listings are powered by Frankie. As listings and other activities are entered and updated in Frankie, they are automatically added to (or removed from) the Franklin Street website. The commercial listings are quite rich and expose key listing details as well as multiple photos, videos, property documents and geographic maps and street views.

Advanced Search

Franklin Street website visitors can search for commercial lease and sale listings in a very granular manner; listing name, type of property, location, price and agent and are key options.

Detailed Results

Website listings include detailed property and listing agent details along with photo galleries, videos, geographic location and multiple listing-related PDF downloads including marketing packages.

Downtown Leads

As site visitors register to access Franklin Street’s website listings they are automatically connected with appropriate Franklin Street professionals based on their professional profile and interests.