Case Study for the Prospect, Customer, & Broker SQL Server 2005 Database

Send a Message


 

 

 


 
  

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 16 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

Project Profile for the Prospect, Customer, & Broker Database

Customer Profile

Sector: Real Estate
Industry: Developer
Revenue: $3 million

The developer is an urban real estate development company. They strive to develop distinctive commercial and residential properties in Chicago and its surrounding suburbs. Their goal is to maximize purchaser value by developing distinctive properties that bring well-designed space, quality construction, architectural integrity and modern building technology to the urban marketplace.

Business Situation

The developer had a variety of residential housing development projects in various stages and needed a centralized system to track contact information. A Customer Relationship Management (CRM) system was the best solution. They required a CRM system that would track prospects, customers, and real estate brokers in a centralized database. It was important that the system be internet based so that their staff could access the information from anywhere at anytime.

Solution

Prospect, Customer, & Broker Database

The web based solution created by SQL Server Programmers enables the company to easily manage their prospects, customers, and brokers. Company staff can access the system anywhere an internet connection is available, thus enabling them to better and more quickly serve their customers.

The following information is also captured within the CRM to provide management with the tools to make informed decisions:

  • Contacts can be assigned to development projects, enabling the measurement of traffic for each of their projects.
  • The method that brought the prospects to a project is captured, enabling the developer to measure the performance of different advertising methods.
  • Prospects and customers are assigned to brokers, enabling the company to measure the traffic brokers and their brokerages are bringing.
  

Executive Summary

Company

The developer has almost 30 years of experience in developing properties in the Chicagoland area.

Solution Description

The web based CRM application provides the company with a method to efficiently manage prospects, customers, and real estate brokers.

Software and Services

  • ASP.NET
  • SQL Server 2005
  • Microsoft Windows XP