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: Article discusses managing IT systems properly to avoid infrastructure problems by looking at alignment, user experience and technology.

Description: Discussion on the issue's contents.

Description: This article contains a brief synopsis and review of a book called APL The Language and Its Actuarial Applications which is an introduction to APL. Article from The Actuary, Volume 24, Issue 2

Description: Actuarial systems access and change controls are hot topics these days as modeling continues to increase in complexity and as new modeling regulations may begin to crest over the horizon. Many companies are currently in the process of either formalizing their actuarial system access and change control protocols, or are reevaluating and strengthening their existing control processes in response to identified deficiencies or in conjunction with new actuarial system implementations. With these undertakings in mind, this article discusses a number of valuable components commonly incorporated in formal systems access and change control protocols. Also discussed are leading practices identified in the SOA publication “Actuarial Modeling Controls: A Survey of Actuarial Modeling Controls in the Context of a Model-Based Valuation Framework (December 2012)”, and from the Institute and Faculty of Actuaries.