Senior SAS Developer - Data Engineering & Regulatory Analytics

ALEX (DAWEN) MIN

Senior SAS Developer Enterprise Data Engineering & Regulatory Analytics

Phone: 702-***-**** Email: ***********@*****.*** LinkedIn: https://www.linkedin.com/in/alex-m-82271288/

EXECUTIVE SUMMARY

Senior SAS Certified Professional with 10+ years of experience designing, optimizing, and supporting enterprise-scale ETL and analytics platforms across healthcare, banking, telecommunications, and retail industries. Proven expertise in SAS Base/Advanced, macro automation, SQL optimization, and large-volume data processing in regulatory and production environments.

Specialized in CCAR regulatory analytics, clinical data systems, marketing campaign data engineering, and automation of mission-critical batch workflows. Recognized for improving performance, strengthening data governance, and delivering scalable, reusable SAS frameworks in high-volume environments.

CORE COMPETENCIES

SAS Technologies

SAS Base, SAS Advance, SAS Macro, SAS/STAT, SAS/ACCESS, SAS EG, SAS Studio, SAS Viya, SAS Visual Analytics, SAS Management Console

Data Engineering & ETL

Enterprise ETL Development (Windows & Mainframe), Data Mart Design, Data Validation & Reconciliation, Performance Tuning, Production Support

Databases

Oracle, SQL Server, Teradata, DB2, MySQL

Regulatory & Risk

CCAR Reporting, Model Risk Management (MRM), Financial Data Validation

Healthcare Data

EHR/EMR, ICD-10, Claims Data, Epidemiological Reporting

Automation & Systems

UNIX/Linux Shell Scripting, Autosys, Crontab, Informatica

BI & Reporting

Power BI, Tableau

Programming

SQL, SAS Hash Object, Python (Pandas & NumPy), C#, ASP.NET MVC

PROFESSIONAL EXPERIENCE

Senior SAS Developer/Healthcare Data Analyst

Pennsylvania Department of Health

2019 – Present

Architect and maintain enterprise ETL pipelines processing multi-source clinical and surveillance datasets (SQL Server, Oracle, flat files) supporting statewide public health analytics.

Migrated legacy SAS 9 programs to SAS Viya, converting batch workflows into cloud-based, scalable processes using CAS (Cloud Analytic Services).

Developed and optimized ETL pipelines in SAS Viya, leveraging PROC CAS and PROC CASUTIL for in-memory data processing and improved performance.

Develop scalable SAS macro frameworks to automate ingestion, transformation, and reporting workflows, reducing manual processing effort.

Design and optimize SAS/SQL programs managing large-scale EHR/EMR, ICD-10, and claims datasets for disease trend and epidemiological analysis.

Lead development of curated data marts supplying analytics teams and Power BI dashboards.

Implement comprehensive data validation, reconciliation, and quality control procedures to ensure regulatory-grade reporting accuracy.

Tune SQL pass-through queries and SAS batch jobs to improve performance and production stability.

Migrated legacy SAS programs to Python (Pandas & NumPy) in a cloud-supported environment, improving processing efficiency and scalability to support cross-team collaboration, enabling seamless clinical data sharing and alignment of testing methodologies.

Produce technical documentation and support production deployments under SDLC governance standards.

Senior SAS Developer – CCAR / Risk Analytics

M&T Bank

2018 – 2019

Supported CCAR regulatory reporting initiatives through SAS-based data reconciliation and validation processes.

Utilized SAS Hash Object programming to reconcile high-volume financial datasets with improved memory efficiency.

Automated reporting workflows within SAS Model Risk Management (MRM) framework for model inventory and compliance tracking.

Assisted with SAS user/group administration and job scheduling using SAS Management Console.

Improved batch stability and reduced execution failures through query optimization and macro automation.

Assisted in ETL processes using Informatica to extract, transform, and load data into enterprise data warehouses.

Developed internal web applications (ASP.NET MVC) to capture and manage collateral information.

Senior SAS Developer / Marketing Data Analyst

The Walt Disney Company

2017 – 2018

Engineered large-scale data extraction and transformation workflows (Teradata/SAS) for multi-channel marketing campaigns.

Developed reusable SAS macro libraries to standardize campaign list generation and environment setup.

Conducted performance tuning and audit validation to ensure production file accuracy.

Delivered ad hoc analytics and reporting to support campaign strategy and post-campaign analysis.

Collaborated cross-functionally with marketing, project management, and analytics teams to translate business requirements into technical solutions.

Senior SAS Analyst / Marketing Data Analyst

Barclaycard

2015 – 2017

Extracted and transformed high-volume Oracle and SQL Server datasets for database marketing analytics and fraud risk support.

Automated batch reporting processes using SAS and UNIX shell scripting across development and production environments.

Designed reusable SAS macro frameworks to improve automation and code maintainability.

Conducted peer code reviews to enforce performance and governance standards.

Supported cross-functional data needs including Fraud & Financial Crime Risk teams.

SAS Developer / Marketing Data Analyst

Bell Mobility

2014 – 2015

Developed campaign targeting lists and analytical datasets using SAS/SQL across multiple internal and external data sources.

Automated recurring data ingestion and reporting processes using SAS macros.

Performed churn analysis, segmentation analysis, and sampling preparation.

Maintained large enterprise datasets using SAS/ACCESS with Oracle, SQL Server, and Teradata systems.

SAS Programmer / Data Analyst

MPR Consulting Inc.

2008 – 2014

Delivered enterprise data mining and database marketing solutions across banking, insurance, and retail sectors.

Designed end-to-end ETL workflows including extraction from flat files, legacy systems, and enterprise databases.

Leveraged SAS on Windows to interface with mainframe banking platforms, executing ETL workflows for transaction, loan, and customer data to support compliance, reporting, and risk management.

Leveraged SAS Hash Object and pass-through SQL for high-efficiency data merging and segmentation.

Built reusable SAS macro frameworks adopted across client projects.

Implemented comprehensive data cleansing, reconciliation, and QA processes.

Software / Database Programmer

Carelynx Corporation

2006 – 2008

Developed database and enterprise reporting systems for inventory and distribution platforms.

Designed web-based applications using C#, Java, PHP, Python and SQL.

Performed database configuration, migration, and server-side maintenance.

EDUCATION

Bachelor of Science, Electrical & Computer Engineering

McMaster University

CERTIFICATIONS

SAS Certified Professional: Advanced Programming Using SAS 9.4

SAS Certified Specialist: Base Programming Using SAS 9.4

Contact this candidate