I've built Snowflake data warehousing solutions for Carelon, CVS Health, Hong Leong Bank, and JH USA, integrating data for provider, pharmacy, claims, banking, and insurance operations.
At Carelon’s Total Provider View project, I developed ETL pipelines integrating provider data from more than five source systems, loaded data through Snowpipe and COPY INTO, and improved performance with clustering keys and query profiling. At CVS Health, I developed Snowflake pipelines and incremental DBT models for healthcare claims and member data, with validation, environment replication, and production deployment support.
I work across Snowflake, DBT, SQL, Python, and AWS S3 to transform, validate, reconcile, and optimize data. I’ve also automated ETL workflows with Streams and Tasks and migrated data from on-premises systems to Snowflake.
