Actuarial Analyst
Current•Developed, maintained, and enhanced monthly revenue accrual models for internal deliverables to finance department to project expected revenue payments using CMS risk adjustment models. •Assisted in the development of Medicare Part C and Part D risk score models for annual bid submissions in compliance with CMS methodology guidelines.•Performed Actual vs. Expected experience analysis for annual Medicare bid submissions.•Analyzed, reconciled, and summarized data for internal deliverables using Excel, Access, SAS and SQL.•Created a Revenue by Source Model using diagnosis submissions data from CMS to provide a breakdown of revenue by provider to operational departments/actuarial teams.•Reviewed technical work of analysts, actuaries, and senior actuaries to ensure the validity of spreadsheets and code.