Brandon Collipi
Melbourne,FL
Summary
Results-driven Lead Benefits Data Analyst with expertise in predictive modeling and data interpretation. Successfully optimized medical insurance renewals, enhancing pricing accuracy by up to 10%. Proven ability to lead teams and communicate strategic insights, driving impactful business decisions through advanced data analysis and modeling techniques.
Overview
9
9
years of professional experience
Work History
Lead Benefits Data Analyst
TriNet USA
Bradenton, FL
04.2021 - Current
- Supervised teams of 3 to implement strategic quarterly medical insurance renewals, ensuring effective management of a $5 billion portfolio.
- Collaborated with senior team management to establish business continuity plans by strategically assigning resources for comprehensive business process backups.
- Engineered predictive models for client and workforce attrition, facilitating book-level medical insurance renewal optimization based on historical data and internal assumptions.
- Authored internal white paper for executive management to mathematically articulate the 'medical renewal pricing algorithm.'
- Performed detailed examination of medical plan choice elasticity, focusing on assessing total gains and losses associated with employee plan migration.
- Developed and implemented mathematical models to incorporate administration costs into client pricing algorithm, improving pricing accuracy by 8%-10%
- Developed actuarial pricing model to accurately assess large case pricing based on actuarial credibility.
- Collaborated with actuarial department to refine medical renewal pricing strategy.
- Directed and allocated monthly tasks to a 9-person team to ensure timely completion of all deliverables.
- Advised director on strategic planning initiatives while effectively communicating team concerns and feedback.
Sr. Benefits Data Analyst
TriNet USA
Bradenton, FL
08.2018 - 04.2021
- Designed and implemented an integrated pricing model that algebraically converts client pricing recommendations into precise discrete structures.
- Revamped pricing recommendations workflow to enhance efficiency, achieving a reduction in processing time from one month to one week.
- Developed and implemented an advanced repricing model, enabling precise book-level adjustments to recommendations for improved pricing strategies.
- Developed large-scale broker database to enhance accessibility of critical information for key stakeholders.
- Provided strategic training and integrated modeling to support leadership in the successful integration of 2 disparate medical exchanges
- Analyzed complex datasets to identify trends and provide actionable insights for business decisions.
Benefits Data Analyst
TriNet USA
Bradenton, FL
11.2016 - 08.2018
- Performed detailed monthly revisions of client medical re-pricing tool to maintain current insights and support informed decision-making.
- Engaged with team members to formulate strategic pricing recommendations for client medical renewals.
- Monitored and reconciled client medical renewal pricing recommendations for integration into internal pricing model.
- Leveraged advanced Excel spreadsheet capabilities to create accurate and insightful monthly reports.
- Developed monthly post-enrollment summary analysis to evaluate book-level financial performance.
- Conducted thorough audits of medical rate books to ensure accuracy and compliance with SOX regulations.
- Assisted with expansion of discreet rating structure to enhance pricing accuracy by 2.25%
Education
Bachelor of Science - Actuarial Science
Florida State University
Tallahassee, FL2016
Bachelor of Science - Economics
Florida State University
Tallahassee, FL2010
Skills
MS Excel
R Programming
Tableau software
Data modeling
Predictive modeling
Data interpretation
Timeline
Lead Benefits Data Analyst
TriNet USA
04.2021 - Current
Sr. Benefits Data Analyst
TriNet USA
08.2018 - 04.2021
Benefits Data Analyst
TriNet USA
11.2016 - 08.2018
Bachelor of Science - Actuarial Science
Florida State University
Bachelor of Science - Economics
Florida State University