Anthem, Inc.Actuarial Analyst II
Aug. 2013 - Feb. 2015Chicago, ILI completed projects supporting a national actuarial team including: ad-hoc analysis; data extraction and processing; and development and implementation of decision-support applications. Achievements: - Within weeks of starting the position, I used Access to re-create an Excel tool the team was working on in order to take advantage of the many features of Access, including: streamlined user-interface; formatted report and output; and enhanced data integrity. - Used knowledge of ASP.Net, SQL and VBA technologies to transition an actuarial underwriting application from the web to an MS Access/SQL application in just six months, by myself, with no loss of functionality (and with added enhancements). This project had been attempted and abandoned many times prior to my involvement. The app now relies on SQL and VBA - technologies that many actuaries are familiar with - as opposed to the previous black-box ASP.net web application which required significant IT support. - Established best practices for application design and implementation and provided technical consultation on a number of projects as a result of my reputation for technical expertise. - Upon accepting responsibility for a critical model used in the company for years, I identified process and design improvements to provide added transparency, better support informed decisions, and improve usability and user value. - Worked with IT to set up a virtual machine for testing applications on older Windows versions as well as a SQL server database which our team uses to serve data to users.