Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Lina Maria Carollo

Marlton,NJ

Summary

Flexible and highly qualified data analyst with an extensive background in pharmacy claims/programs and contract analysis in addition to technical skills that make the analysis easily repeatable, usable, and adaptable.

Overview

26
26
years of professional experience

Work History

Actuarial Associate

October Three Consulting
03.2012 - Current



3 Years Managed Care Pharmacy Analyst

  • Calculated and summarized savings impact of current pharmacy programs on Trustmark's block of business
  • Researched and determined positive and negative effects of savings programs proposed by contracted Pharmacy Benefit Manager
  • Worked closely with Trustmark upper management to develop position as an actuarial role, often presenting results and findings in monthly business review meetings

4 Years Managed Care Network Analyst

  • Interpret and utilize contracted rate and demographic data provided by PPO networks to determine discount percentages and access scores to be used by the pricing actuaries
  • Developed a model that is used to compare discounts and access levels of different national dental networks in order to determine the optimal network for the Trustmark block of business
  • Created/documented processes and guidelines for updating internal benchmark data used in various department models and projects
  • Complete a wide range of ad-hoc requests, many with time sensitive deadlines

Financial Analyst-Actuarial Analyst

ONE EXCHANGE WILLIS TOWERS WATSON
05.1998 - 03.2012
  • Streamlined an existing process using Excel and Access to create interactive forecasting reports to exhibit and compare credit and life insurance sales results
  • Implemented new process that ran, analyzed and distributed weekly and monthly reports to different divisions for review
  • Automated and centralized data points of many reports, turning a week long process into a two day process
  • Monitored industry trends to proactively identify changes impacting business performance, enabling swift adaptation strategies.
  • Facilitated smooth month-end close processes by efficiently reconciling accounts and addressing discrepancies promptly.
  • Streamlined financial reporting for better decision-making with clear, concise analysis and presentation.
  • Provided vital insights for business development initiatives through diligent market research and competitive analysis.
  • Initiated process improvements that increased the efficiency of budgeting cycles while maintaining accuracy standards.
  • Increased stakeholder satisfaction by delivering timely, accurate financial information tailored to their specific needs.
  • Analyzed and processed project specifics before capital deployments.
  • Assisted in preparation of presentations, data tables and other documents for investor meetings.
  • Tracked prices, yields and other trends to correctly interpret impacts on investment programs.
  • Participated in client meetings to discuss financial analysis and investment strategies.

Education

Master of Science - Economics

Princeton University
Princeton, United States
05.2000

Associate of Science - Business Administration And Management

Boston University
Boston, MA
05.1998

Skills

  • Proficient in Microsoft Excel and Access
  • Experience with Microsoft Word and PowerPoint
  • Experience with Visual Basic in writing Excel macros
  • Experience with analyzing/summarizing datasets using SAS/SQL
  • 12 years experience analyzing, summarizing, and presenting data/results
  • 3 years experience managing summer interns and one full time employee
  • Extensive exposure to handling/combining data from different sources and different formats

Accomplishments

Completed the following requirements towards becoming an Associate of the Society of Actuaries:

Exams - P, FM, MFE, & MLC

Validated by Educational Experience - Economics, Corporate Finance, & Applied Statistics

Fundamentals of Actuarial Practice - Modules 1-8, Interim Assessment, & Final Assessment

Associateship Professionalism Course

Timeline

Actuarial Associate

October Three Consulting
03.2012 - Current

Financial Analyst-Actuarial Analyst

ONE EXCHANGE WILLIS TOWERS WATSON
05.1998 - 03.2012

Master of Science - Economics

Princeton University

Associate of Science - Business Administration And Management

Boston University
Lina Maria Carollo