While there was already a diagnostic triangle tool in excel that was previously developed for worker's compensation, it was in need of debugging due to a change in the data format, as well as refreshing with quarter 2 data. During my internship, I successfully identified and fixed the diagnostic triangle tool using Excel and SAS, as well as refreshed the triangles with the new quarter data. I then analyzed and presented my analysis of the modified triangles to my team and management, and explained the assumptions made and determination of values as selected for the triangle.
To the right is an example of the triangles I worked with, without the color formatting to show whether the levels of losses were within the expected ranges.
My first project as an AIG intern was to create a choropleth to visualize premium, loss, and categorical data as well as historical data for the worker's compensation line as a distribution of percentages by state. This map showed the business side where the line was most concentrated, and in which states the company lost/gained business over time. This allowed the business to more accurately create a plan for places to focus more/less, as well as inform the actuarial modelling team if changes needed to be made to assumptions being used, as necessary by state. An example is shown of this is shown to the left. The skills used were Excel & VBA, SAS, and R.
Created a modified Elo ranking system (based on pairwise comparisons) using Google Sheets. This system was used to expand the number of competitions that could be counted towards national championships, as competitions with varying lineup sizes were not able to participate in the national ranking system. In addition, this accounted for decay based on number of interactions with other teams, instead of number of competitions, to account for per-competitive ranking instead of accumulating points by attending several competitions, while still needing a minimum number to be competitive. The concise explanation document is linked below with the spreadsheet (which compares the Elo rankings to the "ALOO" Rankings, which was our name for the modified Elo system), and both full documents are available for review if you are interested in viewing the formulae, math, or anything else. We used Google Sheets for ease of collaboration and transparency.
This system was created in collaboration with Raul Larsen.
Created and defended in part for the religious studies capstone requirement at the University of Pittsburgh in December 2017