Description: CMS provides ACOs with monthly claims data for members, including their medical visits and ACO program eligibility. This data can be divided into Membership and Claims tables through the ETL process. However, when calculating PMPY at specific levels of detail using these tables, issues arise due to unrelated dimensions, leading to inaccurate and understated results. This article presents a solution to this problem by utilizing Tableau's data blending capabilities.

Description: An overview of the basic tooling and packages available for the Julia programming language, with a focus on why this is of interest to the actuarial profession. It covers some of the built-in language features as well parts of the Julia package ecosystem that make Julia ideal for modeling and data analysis. This is the second installment in a series of article aimed at actuaries. The first installment, Julia for Actuaries, was published in the October 2020 edition of Actuarial Technology Today, and covered the base language itself, its high-level, math-friendly syntax, and why the actuary of the future should consider its adoption.

Description: LDTI’s introduction has forced many insurers to examine their existing operations and technologies. They must determine how to optimize compliance efforts while balancing data, analytics and system modernization considerations to achieve maximum value. This article will examine the four key facets—the data, technology, processes, and people—essential to any successful LDTI exercise. It will also touch on the various approaches for tackling LDTI and how a modernization mindset can help insurers realize much greater transformation for the business.

Description: In this article, we talk to Lei Rao-Knight, FSA, Vice President and Actuary at Prudential Financial. Lei discusses her model development experience in the Modeling Center of Excellence.

Description: As the insurance industry continues to evolve due to a pandemic and rapidly changing economic and regulatory conditions, the role of data scientists and actuaries has become increasingly important. In an interview with the Atidot data science and actuarial team, we discuss what it is like to work at an InsurTech, how data scientists and actuaries can collaborate, and look at some concrete technical examples of where the innovation is having an impact. This article explores what collaboration can look like and how the role of data science and actuary may evolve in the InsurTech industry in the future.

Description: Recent and pending changes in financial reporting standards and regulations such as IFRS 17 and US GAAP Targeted Improvements are ramping up the performance pressures on actuarial models. New infrastructure technology in the cloud is driving modeling options that may well help actuaries successfully and economically meet these challenges and unlock even greater transformational change.

Description: This article introduces IT DevOps to actuaries and how it is applicable to them to improve their modeling efforts and make them more efficient.