Below are presentations and talks I have given or am scheduled to give.
Migrating Legacy SAS Code to Databricks Lakehouse: What We Learned Along the Way
Event: Data + AI Summit 2025
Location: San Francisco + Virtual |
Date(s): June 9–12, 2025 |
Status: Completed
Speakers: Matt Adams (PacificSource Health Plans), Dmitriy Alergant (Tier One Analytics Inc.)
PacificSource Health Plans is on a successful multi-year journey to migrate our data and analytics ecosystem to the Databricks Lakehouse. A significant challenge was migrating a critical reporting data mart reliant on extensive legacy SAS code with sophisticated business logic for membership, claims, premiums, and reserves. This session explores the unique challenges faced in migrating this legacy SAS code, how our partner (T1A) used automation (Alchemist) to reverse engineer, translate, and validate the code, and the key lessons learned from this complex migration effort.
Conference link: Data AI Summit Session
Direct link: YouTube Video
Technologies: Apache Spark, Delta Lake, Unity Catalog, SAS Analytics, Migration