Patrick Cummings

• Performed complete manual rate study for Dental and Vision group insurance product
• Implemented new pricing factor tables from rate study across all quoting systems and SQL databases
• Created and submitted state fillings for approval of new manual rates
• Created A/E monitoring dashboards in Tableau to assist in pricing accuracy analysis
• Provided accurate and insightful reports in response to internal AD HOC actuarial analysis requests

Strategic Data Analyst III

• Collaborated with Modeling and Pricing teams to leverage new data variables that have improved pricing model
• Researched/Validated/Structured new data sources using SQL to fit business needs and aid price modeling team

Risk Analyst II:

• Created property acquisition dashboard to support managers decision to pursue acquisition loss avoidance strategy
• Taught entry level employees how to code in SAS, and provide effective reporting using Excel
• Coded and developed monthly and weekly dataset in SAS, housing all Radian claims information to provide one-stop solution to any claims reporting needs
• Collaborate with management and other risk analysts to improve data table structures
• Converted and automated reports from excel to Tableau

• Created Premium and Loss report monthly using SQL programming and Microsoft Excel
• Calculated rate change impacts for state filings, including proving why increasing/decreasing specific rates are necessary
• Assisted with variety of reports including loss triangles, rate indications, and product reviews