Used statistical model results to assist clients with the designing and pricing of insurance policiesProcessed daily policy transaction changes related to new or existing policies.Worked collaboratively with other teams to solicit information and ensure smooth transitions of information between departments.Ensured 100% accuracy and completion of policy transaction changes and outgoing correspondences.Developed and maintained up-to-date policy or procedural documentation.

Produced quarterly gross premium reserve (GPR) memos, including subsequent policy and claim status movement and cash flow testing, using the GGY AXIS software to determine necessary funds for a closed block of businessProduced quarterly statutory reserve memos, including ceded reserve amounts, detailed analytics for reserve amounts, creation and termination rates, and reserve audits for both policies and claims using MS Office, MG ALFA, VBA, SAS, & SQL for long term care, accident, cancer, long term disability, indemnity, major medical, post-acute recovery (PAR) and safe driver policies. This information was also used in annual statement filingsProvided monthly collected premium forecasts to financial reporting from a model using SQL, MS Excel, and VBA for use in budgetingSimplified the department’s data integrity process using SAS and SQL to allow it to be run monthly rather than annuallyCreated a tool to estimate true cost savings from detection of fraudulent claims, which were typically am much as 4 times that of the reserve for the hypothetical claim, using SAS and GGY AXISRan monthly reconciliations of count totals, using SAS, for active life policyholders and open & pending claims.Oversaw updating of and transition for updated premium and claim filesServed as primary contact for all communication with internal departments and external actuaries including the supervision, workload management, and evaluation of contracted actuaries

Analyzed end of month of secondary collection agency payments using MS ExcelCreated daily reports to organize payments by payer to determine revenue levels from each payor.Provided detailed analysis of records for over 100 visiting residents using MS ExcelCreated a report to measure vendors in terms of hourly rates using MS excelUpdated monthly iterations of revenue databases, stat reports, and cash posting discrepancies using MS AccessUpdated quarterly iterations of payment percentages using MS AccessValidated 4 iterations of monthly projections for both bad debt and charity reserves using MS Excel

Assisted underwriters with rate renewals by filing industry and age/gender factors based on relative experience using MS Excel to allow rates to better match Geisinger’s experienceComputed quarterly estimates of Medicare premiums using Microsoft Excel to be charged to policyholders using CMS payment rates, available risk scores, and trended claim amounts by category for each county. This information was ultimately used to set rates for and file the annual Medicare Advantage bids, which resulted in annual profits of approximately $40 millionCreated a database using MS Access with rate ranges of competitors from published weekly filings to provide relevant market information to the sales and marketing department.Assisted with Rx utilization analysis using MS Excel to offer members different copay levels Created monthly lists of most and least profitable commercial groups to assist underwriters in prioritizing renewals