Brandon Collipi

Lead Benefits Data Analyst

Melbourne, Florida, United States

About

Experience

  • TriNet (9 yrs 9 mos)
    • Lead Benefits Data Analyst, OE Renewals
      Apr 2021 - Present · 5 yrs 4 mos

      - Led teams to implement strategic quarterly medical insurance renewals, ensuring effective management of a $5 billion portfolio. - Engineered scenario model to enhance development of bundled medical plan offerings. - 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 medical insurance renewal optimization based on historical data and internal assumptions. - Authored white paper for executive management to mathematically define the 'medical renewal pricing algorithm.' - Performed detailed examination of medical plan 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 10%. - Developed pricing model to accurately assess large case pricing based on actuarial credibility. - Participated in strategic planning with the actuarial department to refine medical renewal pricing methodology and algorithms. - Directed and allocated monthly tasks to a 9-person team to ensure timely completion of all deliverables. - Assisted director with strategic planning while effectively communicating team concerns and feedback.

    • Sr. Benefits Data Analyst
      Nov 2018 - Mar 2021 · 2 yrs 5 mos

      - Designed and implemented an integrated pricing algorithms 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. - Engineered automation solution for generating over 1,000 unique summary of benefit and coverage statements (SBCs), reducing reliance on external vendors. - 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 business divisions resulting in significant cost savings. - Analyzed complex datasets to identify trends and provide actionable insights for business decisions.

    • Benefits Data Analyst
      Nov 2016 - Oct 2018 · 2 yrs

      - 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. - 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 Sarbanes-Oxley Act of 2002 (SOX) regulations. - Assisted with expansion of discreet rating structure to enhance pricing accuracy by 2.25%

  • Deutsche Bank ()
    • Operations Analyst
      Aug 2010 - Aug 2013 · 3 yrs 1 mo

      GEDNY Contract Risk Management.

    • Contract Risk Management- Operations Analyst
      Aug 2010 - Aug 2013 · 3 yrs 1 mo

      •Maintained responsibility for the settlement of multi-million dollar transactions daily •Created and maintained execution instructions to ensure that booking orders can be settled efficiently •Facilitated offshoring of processes to Mumbai India through the creation and implementation of desktop procedures and remote training •Orchestrated the settlement of exotic equity trades through interaction with clients and bank employees around the world •Developed an extensive list of intercompany contacts to facilitate efficient solutions to bank wide issues •Employed complex back-to-back equities swap reconciliation process •Passed Securities and Exchange Commission (SEC) background check and received clearance to work in a financial institution •Assisted in the calculation of coupon payments on trigger dates for exotic equities