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: 2022 Welcome and Strategic Themes for the Marketing and Distribution Section Council.

Description: Python has become the fastest-growing major programming language in the world. It has surged in popularity over the last decade, following the development of its industry-leading capabilities in data science, machine learning and artificial intelligence, and it is now one of the most globally popular and widely used languages. In this article, I discuss some of the reasons for its popularity and explain why many actuaries and insurers have started using Python.

Description: Best-in-class analytics allow companies to quickly understand results and dynamically manage their business. When enhancing analytics, we can learn from companies that have recently deployed new dashboards for Long Duration Targeted Improvements (LDTI), International Financial Reporting Standards 17 (IFRS17) and principle-based reserving (PBR). Data transformations and new software tools provide significant opportunities, but many companies are grappling with an actionable path forward to implementing new analytics.

Description: Hardly a day goes by without a feature story about the latest reverberation from the expanding use of Artificial Intelligence/Large Language Models (tools) in a variety of settings. The pace of use (and misuse) of these tools, such as ChatGPT and Bard, has been explosive and shows no sign of abating. Many experts would argue we are on the cusp of a permanent paradigm shift in teaching/academics and overall application of technology. With these issues in mind, the Society of Actuaries (SOA) Research Institute’s Aging and Retirement program is interested in an exploration of this topic from a variety of perspectives. The result of this effort is intended to provide a useful resource for readers to become well-grounded on the issues surrounding the impact of these tools in a retirement context and set the stage for future research.

Description: This session will be an “Ask The Expert” panel. Several actuaries who have been involved with major change initiatives as either vendors, consultants, or project leads will offer their perspectives on how to help others manage expectations, adapt as unknowns become known, and deliver new insights to their audiences. Topics will include leading multi-disciplinary teams, reacting to changes in project sponsors and project team members in your absence, and transitioning professionals very set in historical ways of work to new processes. Plus Q&A time from the audience. This session will give actuaries insight into how they can manage the “people parts” of large change projects efficiently and effectively so that they can meet objectives and ensure successful outcomes for their business units.

Description: This panel will take a holistic deep dive on the intersection of pending regulatory, actuarial, and technical developments in artificial intelligence (AI). Panelists will explore how AI and the diverse and evolving regulatory landscape surrounding this technology will impact actuaries' day-to-day jobs in managing risk, and what the (re)insurance industry is doing to leverage AI to streamline internal processes and simplify underwriting.