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: The winner of the “most unique use of technology” prize of the 14th Speculative (and Inspiring) Fiction Contest.

Description: Information technology may change the very concept on which the actuarial profession is based. The result could be the reduction of all risk categories to a category of one.” John Diebold, chairman of the Diebold Group of management consultants, told a luncheon audience at the Centennial Celebration.

Description: Actuarial Process Optimization is a framework for using technology to support the actuary of the future. In this article, we discuss the capabilities of new technologies and explore examples where they can be used to aid with providing strategic business direction, optimizing skillsets and use of technology, and maintaining governance, control, and risk frameworks.

Description: To complement the limitations posed by the static nature of current survey papers in cyber risk literature and to facilitate cyber risk research, this project features a Natural Language Processing (NLP)-powered repository and search tool “CyLit” built by the authors.

Description: This note presents a review of calculator financial functions for the Texas Instruments BA-35 calculator. A number of the examples used as illustrations are from the 3rd edition of the book Mathematics of Investment and Credit, by S. Broverman.

Description: This article explains the importance of centralizing modeling departments. It goes further and explains the importance of making all aspects of modeling reusable. It explains the consequences of decentralization.

Description: This paper stresses the importance and value of information databases. From Actuarial Research Clearing House 1993, VOL. 3.

Description: Inspired by the Wall Street Bets / GameStop stock episode in January 2021, this article outlines the market mechanics and risk considerations that lead to market failure. The consequences of unfilled buy orders, unfilled short sell orders, and more short shares than long shares are all explained. Also, some steps to protect a financial institution that has been caught shorting a popular company are explored.