---
layout: default
category: portfolio
modal-id 1
img: ifq.png
alt: Screenshot of application that quotes changes to existing policies
client: Cigna, Florida Blue, Blue Shield, Coventry, Aetna
application: Existing Policy Quoting
project-date: 2013 - 2016
languages:
- PHP
- SQL
- HTML
- jQuery
- CSS
- JavaScript
- XML
concepts:
- MVC
- AJAX
- OOP
- Web Services
tools:
- phpStorm
stack:
- Linux
- Apache
- PHP
- MySQL
- DB2
---

###Project Description
Cigna had four web applications with Healthplan Services:

- **Broker Portal** - Appointed brokers sell policies, run quotes, and view commissions data
- **Quoting Portal** - Individuals get quotes for health & dental plans for themselves or family
- **Enrollment Portal** - Individual and Appointed brokers enroll health & dental policies
- **Member Portal** - Members view benefits, make payments, and track reported claims

###Contributions
My work with Cigna's various portals spanned three years, driven largely by new feature requests, including:

- Supporting for quoting dental products across ten states
- Adding and terminating health products across ten states for both quoting and enrollment
- Overhauling the billing details calculations and layout for members
- Adding dynamic sorting and pagination for brokers' case listing & management
- Modifying PDF proposal mapping.

I also created a bulk premium rating tool that allows internal rate analysts to run large data sets of quotes through uploadable spreadsheets to test their own rating engines.

###Challenges Overcame
This period marked a lot of growth for me as a junior web developer coming from a startup company, with my first experience in enterprise-level web applications. The biggest challenges I faced were mostly enterprise firsts:

- Absorbing the vast business domain of health and related insurance
- Learning an in-house MVC framework
- Implementing advanced DB2 features, such as cursors, to facilitate pagination in result sets
- Integrating into in-house policy management software
- Writing design and test documents
- Collaborating on teams consisting of business analysts, project managers, and quality assurance testers
- Mapping values to PDFs proposals using complex XMLs
- Working with AJAX using Prototype
- Interacting with servers using tools such as vim, grep, and tail, through putty

###Accomplishments
Other than surpassing the huge learning curve of domain knowledge and enterprise exposure as a junior developer, one of my biggest contributions of this time period was successfully supporting one of the biggest clients, as well as raising the bar on design and test document writing and standards.

This bulk premium rating tool previously mentioned is still in use today and continues to save countless hours for an entire team of rate analysts.

Create initial version of ifq portfolio post with only header info
Create initial version of ifq portfolio post with only header info
