Dmitriy Alergant

Activities

1

talks

Principal Architect Tier One Analytics Inc.

Dmitriy is a passionate Data and Analytics, BI, and Data Warehousing leader with nearly 20 years of experience in professional services as a Solution Architect and Tech Lead in Modern Enterprise Cloud Architecture and Data Integration. Dmitriy is a certified Databricks Partner Solutions Champion and Data Engineer Professional. Earlier in his career, Dmitriy used to be a SAS architect implementing and optimizing SAS solutions for clients, until this became a dead-end technology. Dmitriy and T1A then pivoted to helping former SAS clients get out of it to Databricks. As an expert and practitioner in both SAS and Databricks, Dmitriy helped shape the vision and design of T1A's "Alchemist" solution accelerator for SAS to Databricks migrations.

Bio from: Data + AI Summit 2025

Filter by Event / Source

Data + AI Summit 2025 1

Talks & appearances

1 activities · Newest first

Search activities →

Migrating Legacy SAS Code to Databricks Lakehouse: What We Learned Along the Way

2025-06-10 · Data + AI Summit 2025 Watch

talk

with Dmitriy Alergant (Tier One Analytics Inc.) , Matt Adams (PacificSource Health Plans)

Analytics Data Lakehouse Databricks DWH SAS

In PacificSource Health Plans, a health insurance company in the US, we are on a successful multi-year journey to migrate all of our data and analytics ecosystem to Databricks Enterprise Data Warehouse (lakehouse). A particular obstacle on this journey was a reporting data mart which relied on copious amounts of legacy SAS code that applied sophisticated business logic transformations for membership, claims, premiums and reserves. This core data mart was driving many of our critical reports and analytics. In this session we will share the unique and somewhat unexpected challenges and complexities we encountered in migrating this legacy SAS code. How our partner (T1A) leveraged automation technology (Alchemist) and some unique approaches to reverse engineer (analyze), instrument, translate, migrate, validate and reconcile these jobs; and what lessons we learned and carried from this migration effort.