Implementation Of Loyalty Program For Real Estate Industry

Categories : All, Case Study, Retail / E-commerce

Client Requirement


The client is a leading construction company providing homes in the micro-markets and the
segments they operate in. The client’s main requirement was to develop a Loyalty Program website for their valued customers. The client brings with it a host of benefits and privileges by tying up with various brand across segments. The booklet explains the advantages with the details of offers across varied brands. Once the user have viewed the offers and saved the SMS number they just have to carry the relevant cards provided to avail the offers.

The client’s key requirements were:
  • To facilitate eligible users to view all the available offers on the website
  • Enable Multiple Offer Categories so that the user can browser all the offers through varied categories
  • The Offers and Offer Categories to be easily manage by the website administrator
  • Engage their existing customers and provide a loyalty rewards platform to strengthen elationship

Project Challenges

Team faced the following challenges:
  • Synchronizing and incorporating an extensive list of features designed for enhancing the user experience.
  • Incorporating web usability principles in the website design to ensure easy navigation for all types of users.
  • Developing a robust architecture capable of handling millions of users at the same time without slowing the site down.
  • Implementing stringent security measures that safely handle the vast transfer of data.
  • Responsive website layout that executes on multiple mobile devices.

Technologies Used

Operating System & Server Management Red Hat Linux OS, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance
Development Tools & Environments PHP5+, Symfony 1.4, HTML, Java Script, CSS, AJAX, SVN etc.
Database MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization,Scheduler for Backups


Project Leader 1
Developers 2
Designers 1
Quality Assurance Testers 1


The enormous structure of the website and the challenges involved necessitated the adoption of a four-tier approach that consisted of:
  • MYSQL Server Database, Tables, Stored Procedures etc… incorporated within the Database layer.
  • All the business logic procedures for various modules formed the Business Logic layer.
  • Conversion of data between incompatible type systems in databases and accessing data from the database for the Interface layer and Database Abstraction layer respectively.
  • The GUI of the website formed the User Interface layer.


Designed to be a powerful and robust loyalty program website the design approach was built around PHP and MYSQL server. Various modules were developed in PHP such that they can be executed directly from the UI layer. In order to most effectively access the database in an object-oriented context, an interface translating the object logic to the relational logic was used to communicate with the relational databases in an object-oriented manner. An intermediary abstraction layer was created for accessing data from the database. Stored procedures were used only for complex retrieval of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the website. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers.

Development Highlights

The site was equipped with a robust architecture for performing crucial operations. We used Symphony Framework to add interactivity to the website without the need of adding too much of code. The web usability guidelines were strictly followed during development. The interface was made easily navigable through judicious use of AJAX, CSS and HTML controls. The site was developed and fully functional within a span of 4 months.

[Total: 1    Average: 5/5]

Client Saying

One of my friend recommended me Brainvire. It was an immense pleasure to work with them. I found their team...
Mr. Umesh ranglani
Just wanted to say massive thanks for all the help from the Brainvire team. After years of having a website...
Mr. Rohit Singla
Brainvire completed the job professionally and with an interest to solve the actual root problem I was having. They demonstrated...
Mr. Timothy Drylie
I am truly happy with Brainvire’s exceptional service. Whenever I had a question they answered it without delay. With extreme...
Mr. Richard Desilva
BIG THANK YOU to Brainvire team for all their smart work and fantastic services. We are very pleased with the...
Mr. Greg Pietsch

Latest Happenings

  • 04 Oct 2016
    Brainvire Making great Strides with Symfony Development Services [ + ]
  • 29 Sep 2016
    Brainvire augments its List of Offerings with Magento Sears Integration Services [ + ]