View PDF

Q3 builds an application which facilitates Insurance Underwriters to perform underwriting of health insurance policies.

Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.

Company Profile

The client is a leading health insurance provider.

Business Situation

The client had some existing applications which contain the proposer information for individual/family and group insurance. Client wanted to develop an Underwriting Management application which should import the proposer information from existing applications and send back the underwriting results to the existing system after processing. As a part of the proposed system, the client also required some background services to be developed which would perform certain automated time-based tasks.

• The client wanted to use entity framework with Oracle. The challenge was that Entity framework is not supported by Oracle implicitly, and required building of custom interfacing logic to make them work together.
• The timelines were very aggressive due to the client's business goals that depended on the completion of this product.
• Authentication was to implemented through Active directory.
• Data needs to be pulled and pushed from the existing application, which was a challenge as the external application provided prebuilt services, and our design was required to be molded according to those services.

Q3 came up with a dedicated team of Senior Developers and QA experts to provide a technical solution for Client's requirements. The team of Developers, along with the Architecture Team, analyzed the requirements, designed the application as per Client's requirements, and finally came up with a solution that ensured all needs and objectives were covered.

Q3 designed the application and database architecture. Q3 developed the interfacing component to use LINQ with Oracle. For Active directory authentication Q3 used LDAP and for query purpose LINQ was used. Q3 developed a windows web-service to pull the data from the existing system in XML format and a windows service to push the data in CSV format. The application is designed to support different browsers.

Technologies

• C#/.NET Framework 3.5
• ASP .Net
• Microsoft Enterprise Business Logic Components (Dependency Injection)
• ADO.Net
• LINQ (ORM)
• Oracle 10g
• MS Visual Studio Team Edition 2008
• SVN version control
• Windows Server 2003
• IIS 6.0

Benefits

• The application is designed to handle huge volumes of data and still providing excellent performance.
• The application is browser independent.
• The application sends alerts through SMS and email.
• Web service and windows service are implemented to pull and push data.
• Many algorithms are implemented to perform automated tasks in the background.
• Rich AJAX based user interface.
• The application provides multi-browser compatibility.
• Authentication using Active directory as well as normal login screen.