Case Study Online Insurance Tracking System
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 1
Client
Requirement
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.
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.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 2
Technologies Used Operating System & Server Management
Development Tools & Environments
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 MS Visual Studio, C#, .Net, Microsoft Visio, Java Script, AJAX, CSS, HTML, JQuery, JSON, SVN, SQL Server Reporting Services etc. SQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups
Database
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.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 3
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.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4