Dot net based Online Insurance Comparision Custom Built Application

67 %
33 %
Information about Dot net based Online Insurance Comparision Custom Built Application

Published on March 18, 2014

Author: brainvireinfo



Premium Insurance Comparision Tool for home, automobile etc. This Online insurance comparison application was built in dot net, WCF, and MSSQL for insurance tracking. | © 2013 Brainvire Infotech Pvt. Ltd Page 1 of 1 Case Study Online Insurance Tracking System | © 2013 Brainvire Infotech Pvt. Ltd Page 2 of 2 This system provides an online web application allowing agencies, companies to browse wide range of policies available to check their premiums (Premium Calculator), Divisions and Sub Divisions, Employees, Billing and Reports to gather a consolidated and customized output in PDF and Excel format. Application has been designed in a very sophisticated and user-friendly manner for the companies and the visitors throughout the web. It gives access to the companies that are willing to keep track of their employments, resources, company’s claimant transactions and many more under one roof. Application also contains a feature named “Adjustments”. Adjustment has been introduced due to the employees and companies who have skipped their Premiums in a year due to a certain reason. MA does follow Adjustment against that agent in order to avoid any discrepancies in the calculation of every financial year annual report submissions. Depending on the policies, agents are gaining benefits (based on Plan Calculations) and simultaneously their interests vary depending on their selections. The application keeps track records of Company’s Billing, their Divisions and Sub Divisions (if any), Lists of Employees and Resources available in the company opting for any Policy etc. However, it has its own Admin section which manages and monitors every transaction of the business activities appearing on the website and depending on the needs website owner can do any certain or relevant content changes on the website. As far as report is concerned depending on the selective parameters customized reports can be generated and can be exported in PDF and Excel spreadsheet format. Client Requirement Project Challenges Team faced the following challenges: • Integrating multiple databases with an application. • Integrating Reporting Services with an application so that reports get displayed as per the respective module. • Allowing the site to handle millions of users at the same time without slowing down. • Converting as well as providing layout from Windows access application to Web-based application. • Developing JSON, Ajax driven site with various features without compromising the performance and execution level. • Allowing Application or UI access as per currently logged-in user. • Use of encryption and decryption for state management to secure data. • Implementing WCF Services to communicate with an application. | © 2013 Brainvire Infotech Pvt. Ltd Page 3 of 3 Technologies Used Manpower Project Leader 1 Developers 4 Designers 1 DBA 1 Quality Assurance Testers 2 Planning The following N-tier development approach was adopted to equip the site with numerous features and functionality mentioned below: • The Database layer containing SQL Server Database, Tables, Triggers and so on. • The Data Access layer containing the Data Access DLL responsible for accessing the data from database. • The Business layer DLL consisting of all the business logic procedures for modules like Premium Calculation, Policy, Division, Reporting etc. • Reporting server for keeping the report (rdl) and to show the report on UI layer. • The User Interface layer which forms the Graphical User Interface of the application. Operating System & Server Management Windows 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 MS Visual Studio, C#, .Net, Microsoft Visio, Java Script, AJAX, CSS, HTML, JQuery, JSON, SVN, SQL Server Reporting Services etc. Database SQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups | © 2013 Brainvire Infotech Pvt. Ltd Page 4 of 4 Architecture Development Highlights The design approach was built around Visual Studio .Net Framework (3.5) and SQL SERVER 2008 due to the insurance domain nature of the application. Modules like Division, Policy, Premium Calculation and Reporting were developed in C#.Net 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. Triggers were used only for complex updation and deletion of data from multiple tables and were entirely avoided with conditional syntax to ensure smooth performance of the application. The UI layer was kept free of any business logic with images, applications and data being called from their respective servers. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of JSON, AJAX, CSS, HTML and Web Server Controls. The site was developed and fully functional within a span of 12 months.

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Comparison of .NET Logging Frameworks and Tools

Please see below for the results of the comparison. ... Custom: Network Memory MSMQ ... There are some basic viewer applications available from third ...
Read more

PHP vs Performance Comparison - Comentum

PHP vs Comparison ... Based on my research on a few online stats, ... is built to run only on Windows platform.
Read more

ASP.NET Web Application Developer,Offshore Outsourcing ...

Custom software services in ASP.NET web application development using ... based online tax filing application. ... application that was custom built by ...
Read more

.NET Technology Guide for Business Applications

.NET Technology Guide for Business Applications // 2 Contents 1. Key takeaways ...
Read more

MCA, B.Tech live projects with source code

Learn .NET by practising our sample projects with source code. ... Online Mobile shop in ASP.NET: ... The project is a windows based application which ...
Read more

Compare Insurance Quotes Online: Life | Car | Health | Travel

Compare online insurance ... This comparison of insurance plans paves ... We have a strong technological edge which makes the insurance application ...
Read more

.NET - Powerful Open Source Cross Platform Development

.NET Core and ASP.NET Core give you a blazing fast and modular platform for creating server applications that run ... projects and help build the future of ...
Read more

CMS Solutions, Customer Engagement Solutions - DNN Software

Evoq enables you to build a robust online customer support community within your website. The results: stronger customer loyalty, ... DNN Corp. (DotNetNuke)
Read more


ASP.NET is a free web ... Build standards-based ... Sergio Sisternes walks through the process of deploying an ASP.NET Core application to ...
Read more