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: