• Assisted with Month End, Quarter End, and Year End valuation processes for AARP and broad market products using Excel, Access, and SQL.• Improved reconciliation processes by updating file documentation, optimizing Excel functions/VBA macros, and implementing power queries from Oracle databases to reduce time spent on updating input data. • Developed and validated Prophet factors for new products using Excel, SQL, and VBA.• Tested modules and indicators from the US360 L&A library in Prophet Modeling Software to identify ways to reduce model runtime without causing significant variance in relation to the base model.• Analyzed module and indicator test results using Excel to quantify the impact of each model change.• Improved error flagging in DCS code so that errors can be identified and corrected more efficiently.• Added DCS code to create a report that summarizes the number of units and policies processed for each product when generating model point files.• Simplified VBA code for Actual to Expected Mortality Report to reduce runtime and error potential when reporting for future years.

• Assisted with the transition of medical claims exceeding $3 billion from WellCare to Centene’s adjudication platform.• Reconciled claims data through general ledger review, lag validation, and core analytics table comparison using PeopleSoft, Teradata SQL, and Excel to validate claim amounts for Medicaid policyholders.• Developed 20+ Teradata SQL queries using crosswalks and methodology from Milliman to recreate FFS data.• Reviewed and mapped platform logic for future developer implementation.• Analyzed variance using pivot tables to explore potential causes of disconnects for different FFS data categories.

• Audited 100+ federal/state sponsored projects and residual accounts in a portfolio exceeding $20 million using PeopleSoft and Excel.• Communicated with principal investigators to create purchase orders for research materials and paid invoices in a timely manner.• Streamlined the quarterly reporting process for FDACS pesticide exam counts and account balances for 67 Extension Offices using Excel pivot tables and federal databases.• Processed 30+ journal entries on a monthly basis to correct account codes and expense locations to ensure items were coded appropriately for each grant sponsor.

• Created a player strength scoring system to analyze and rank 10,000+ lines of soccer player data using Excel and SQL.• Researched and analyzed the distribution of professional soccer team salaries for player selection.• Utilized pandas and NumPy libraries in Python to create an optimized team lineup by bootstrapping with data frames.• Created a model in Excel to estimate the probability of success in a head-to-head tournament setting using the ranked player data for each respective team.• Worked alongside several other aspiring actuaries to generate an analytical report on our data findings.