Home » Case Study » Bespoke Web Application for Insurance Brokers
Web App Development
.Net 3.5
MS-SQL Server 2008
Visual Studio

About Client

The client is a renowned insurance brokers and agents group in Hamilton, Ontario. Established by the most respected people in the insurance industry, the company offers the best insurance and risk management services for betterment of the society. They are the licensed insurance professionals specializing in different types of insurances and help both individuals and businesses to identify and get the best cover insurance for their assets through personal, commercial and corporate insurance programs.

Business Challenges

The insurance broker group is responsible for helping its customers (individuals and companies) to find out relevant insurance policy which offers them with best value and protection, arrange claim settlements and adjustments for them, check out their eligibility for various insurance and various cover plans, carry out the insurance claim process on their behalf etc. Hence, the client wanted to develop a web application so that they can browse through the wide range of policies, calculate and check their customer premiums, track their claimant transactions, track their resources, employees, divisions and sub-divisions and also generate reports finally to gather a consolidated and customized output in PDF and Excel format.


Brainvire team developed an effective web application most suitable for client’s requirements. They developed an all-in- one solution for the client where they can manage and monitor every transaction of their business or business activity online, manage their website content with timely updates and changes and generate completely customized PDF or Excel reports based on selective parameters. The application helps the client to track the billing, divisions and sub-divisions, list of employees and resources of the customer company that has opted for any policy. It helps them to calculate interests of the agents based on the plans selected by them. The application also enables calculation of the adjustments against the companies who have missed or skipped their premiums in a year.


  • Implementation of the database application on the web
  • Developing JSON, Ajax driven site, with various features without compromising performance and execution level
  • Implemented WCF Service for easy communication and safe transfer of information over network
  • Generating customized PDF and Excel based reports based on selective parameters
  • Implementing encryption and decryption methods for securing data accessed from and to the application
  • Development of modules like Division, Policy, Premium calculation and Reporting in C#.net such that they can be executed right from the UI of the application


  • Successfully converting the database application into a reliable web application
  • Integration of reporting services with application so that reports get displayed as per the respective module
  • Ensuring that the website performs at its best in spite of the implementation of all the diverse features and functionalities in it


  • Quick and easy access to the details of the insurance products and various insurer firms for suggesting relevant insurance policies for the customers
  • Easy tracking of claimant transactions, resources, employees, divisions and sub-divisions
  • Easy and fast premium calculations using Premium Calculator