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: Learn more about the predictive modeling that was applied to industry data for the lapse and mortality experience in the post-level term period. Novel approaches were taken to model the shock lapse, subsequent lapse, and mortality experience. Observe a demonstration of the Tableau tool, which was built to allow users to analyze data on their own.

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: Since the international financial crisis, accounting standards have become an important part of financial supervision rules, which objectively requires us to study the reform and development of accounting standards from the perspective of financial stability. Since the release of IFRS17 in 2017, the research and discussion of IFRS17 in the insurance industry has focused on technical details and implementation, while the economic impact and pros and cons analysis of IFRS17 are few. As a result, the industry's understanding of IFRS17 is not comprehensive enough, and there are still many disputes, and no industry consensus has been formed. In the future, the insurance industry should strengthen the research and analysis of IFRS17 from the perspective of financial stability, deepen the understanding and cognition of IFRS17, and improve the ability to control and use IFRS17.

Description: Cluster modeling is emerging as a powerful technique to manage cloud costs and run time. It also enables quick responses to "what if" scenarios, and aids in attributing results between reporting cycles. In this webcast, we provide insight into cluster modeling, present case studies that focus on various key performance indicators and discuss the benefits and challenges to cluster modeling from an insurer’s perspective. We also discuss the considerations associated with moving from an on-prem based computing solution to a cloud-based approach.

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: 1993 SOA Meeting, Quebec. This session is about implementing new technology, choosing between competing technology, problems to watch out for, unexpected benefits, migrating from mainframe to client/server, automating the field force and large-scale networks.

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.