Michael Dragotta, Asa Email & Phone Number

Minneapolis, MN, US

Minneapolis, MN

Minneapolis, MN

Minneapolis, MN

Brookfield, Wisconsin, US

• Wrote a Macro using VBA to increase efficiency of a project assessing effect of loss development factors on pure premium
• Performed multiple actuarial analyses in Excel model using loss data and exposures to find an estimated ultimate IBNR figure for the projected policy period
• Organized numerous loss runs, in which through pivot tables losses and large losses were manipulated and summarized to be used in the actuarial analyses
• Constructed loss triangles using accounting data aiding in a profitability study on company rates

Brookfield, Wisconsin, US

• Analyzed how claims develop over time using triangles in Excel, allowing claim specialists to set the most accurate reserves
• Led another intern through an “over 200k” project in which loss runs were analyzed and losses over 50% of insureds retention were communicated to the claim specialists
• Researched various losses to get a better understanding of what an appropriate initial reserve should look like and how the loss will develop over time
• Billed reinsurers for claims within their layer of liability improving time of receiving reimbursements and kept outgoing invoices and incoming reimbursements filed

• Oversaw 3-4 crew members maintaining good work behavior and efficiently completing work orders
• Illustrated a positive work ethic in community projects such as local baseball tournaments maintaining good public perception
• Executed daily work and large-scale projects using valuable machinery on a time constraint

• Greeted customers in a positive manner and efficiently processed their purchases at a cash register reducing customer wait time
• Reported to supervisors every shift to communicate the goals for the day establishing accountability for the workload
• Engaged with head supervisor once per semester to discuss how work has a positive impact, to set goals as a student, and to receive feedback