Senior SAS Programmer and Analytics Leader
Resume:
CARLTON COLBERT
Senior SAS Programmer
Lead Analytics Consultant
Bellevue, WA • 202-***-**** • ***************@*****.*** PROFESSIONAL SUMMARY
Senior SAS Programmer and Analytics Leader with 39+ years of enterprise-scale experience across financial services, healthcare, insurance, mortgage, telecommunications, and pharmaceuticals. Expert in advanced SAS programming, large-scale data engineering, regulatory reporting, workflow automation, and high-performance parallel processing. Proven track record modernizing legacy systems, architecting data warehouses, leading CCAR and AML initiatives, and delivering mission-critical analytics under aggressive timelines. Recognized for building SAS communities, training global teams, and driving enterprise-wide technical excellence across more than 30 organizations from 1987 to 2025.2
CORE COMPETENCIES
• Advanced SAS Programming: Data Step, Macros, PROC SQL, Grid, Connect, Parallel Processing
• UNIX Shell Scripting & Automation: CRON, JCL/CA7, MS Scheduler
• Data Engineering & ETL: Oracle, Teradata, DB2, SQL Server, SAS Datasets
• Regulatory & Risk Analytics: CCAR, Y14Q, AML, Fraud, CRV
• Workflow Design, Documentation & Process Optimization
• Technical Architecture & System Migrations
• Agile, Iterative & Waterfall SDLC
• Leadership, Mentorship & Community Development
SIGNATURE ACHIEVEMENTS
• Created Wells Fargo’s first SAS Certification Academy; trained 60+ programmers and supported 100+ with EEP setup and enrollment.
• Lead SAS Developer for Santander CCAR; executed SAT engines, introduced SQL parallel processing, and helped the bank pass CCAR for the first time in 2017.
• Authored a 1,000-page SAS SQL Server conversion guide for M&T Bank, saving six months of development time.
• First developer to migrate Fannie Mae’s Single-Family Portfolio from mainframe to client-server; designed and sourced the Oracle Data Warehouse.
• Built MCI’s first Measurement Revenue System (MRS) and created the NASPID corporate-subsidiary mapping system, now mandated by the FCC.
• Replicated a 310-file MS Access reporting system in SAS for Aetna, including ingestion, cleansing, derived tables, and ODS reporting.
• Led SAS 9.3 9.4 migration for E*Trade, including PII remediation, Subversion implementation, and validation of 52K+ files.
• Developed enterprise SAS applications integrating DB2, Oracle, SAS Grid, and desktop automation for multi-stage processing and reporting.
• Delivered SAS training, workflow documentation, and system modernization across 30+ companies from 1987–2025.
PROFESSIONAL EXPERIENCE
WELLS FARGO
Senior Lead Analytics Consultant
Wilmington, DE • Aug 2019 – Dec 2025
• Completed 16+ Customer Remediation Verification (CRV) projects with full audit readiness.
• Built SAS tools to scan and extract metadata from historical CRV codebases.
• Automated CRV PIW extraction and exclusion sampling methodology.
• Enhanced CRV documentation and folder structures to improve auditability.
• Produced Y14Q-aligned loan-level datasets and documentation.
• Replicated an entire Regulatory Reporting Access Database system in SAS, reducing runtime from 6 hours to 30 minutes.
• Led SAS Certification Academy; mentored 100+ analysts and facilitated instructor-led training for 60+ participants.
• Partnered with SAS Institute to expand enterprise SAS training programs.
• Served on SAS Steering Committee; hosted Wells Fargo Annual SAS Day. COLLABERA CONSULTING (Wells Fargo)
Senior Data Management Analyst
Fort Mill, SC • Mar 2019 – Aug 2019
• Lead SAS Developer for DMI/EDR/RRDR.
• Produced loan-level datasets for five targeted populations.
• Reduced regulatory reporting runtime from 6 hours to 30 minutes via SAS macro automation.
• Created PPRN triage, ASD, and DTP documentation.
• Delivered SAS brown-bag training and supported agile sprint cycles. M&T BANK
Senior SAS Programmer / Analyst
Buffalo, NY • Mar 2018 – Mar 2019
• Lead developer for SAS MRM upgrade (7.1 7.3).
• Enhanced Model Lifecycle Workflow using SAS Workflow Studio.
• Authored functional specifications and redesigned screen/server pages.
• Performed ad-hoc analysis on mainframe and tape datasets. SANTANDER HOLDINGS USA
Senior SAS Programmer / Analyst
Boston, MA • Feb 2016 – Feb 2018
• Lead developer for CCAR SAT Balance Walk Engine.
• Converted all CCAR engines from EG to UNIX batch.
• Introduced SQL parallel processing to improve scalability.
• Revised 8 of 11 CCAR technical documents for 2017.
• Executed and monitored CCAR cycles, including 70-hour execution weeks.
• Provided daily CCAR execution status to senior leadership. E*TRADE FINANCIAL
Senior SAS Programmer / Analyst
Arlington, VA • May 2015 – Feb 2016
• Led SAS 9.3 9.4 migration; validated 52K+ files and permissions.
• Converted CRON jobs to Control-M; implemented Subversion.
• Authored PII protection strategy and scanned entire UNIX environment.
• Developed shell wrappers and automation scripts for SAS execution.
• Coordinated Subversion training and change-management processes. M&T BANK
Senior SAS Programmer / Analyst
Buffalo, NY • Mar 2014 – Apr 2015
• Authored 1,000-page SAS system documentation for SQL Server migration.
• Automated Excel Investor Reporting using SAS DDE and 176 macro variables.
• Built AML Fraud Customer Profile using multi-source ETL.
• Delivered SAS training on macros, SQL, and efficiency techniques. CAPITAL ONE
Senior SAS Programmer / Analyst
Mettawa, IL • Aug 2012 – Mar 2014
• Lead programmer for HSBC credit card portfolio analytics.
• Delivered YESS HBUS campaign analytics for 2012 and 2013.
• Extracted and merged DB2 and UNIX datasets for portfolio analysis. AETNA
Senior SAS Programmer / Analyst
Remote • Feb 2011 – Aug 2012
• Rebuilt a 310-file MS Access system entirely in SAS.
• Automated ingestion, cleansing, derived tables, and ODS reporting.
• Reverse-engineered VBA logic and replicated all reporting capabilities.
• Designed SAS Data Warehouse and Visio process flows. ADDITIONAL ROLES (2010–1987)
Healthcare, Pharma & Life Sciences
• Amgen Pharmaceuticals
• Pfizer Pharmaceutical
• Abbott Laboratories
• Quintiles
• CareFirst, Inc. (BCBS)
• Anthem Insurance
Technology, Telecom & Consulting
• Collabera Consulting, LTD
• Vector Consulting / SAS Institute
• Computer Consultants of America (CCI)
• Decision Sciences Corp
• Computer Sciences Corporation (CSC)
• MCI Telecommunications
• Cellular One
• SBC SVC Inc. (listed twice consolidated)
Government & Public Sector
• U.S. Coast Guard
Insurance
• Anthem Insurance
• State Farm
Hospitality & Services
• Marriott International
(Full details available in extended version.)
EDUCATION
DeVry University — Electronics Engineering (Completed 3 years) HumRRO Technical Institute — Electronics Technology Certificate, GPA 4.5 CERTIFICATIONS
SAS 9.4 Base Programming — Performance-Based Credential TECHNOLOGIES
SAS 9.x, SAS EG, SAS Grid, SAS Connect, SAS DDE, ODS, SQL, Oracle, Teradata, DB2, SQL Server, UNIX/Linux, JCL, Syncsort, Visio, MS Project, Excel, PowerPoint, SAS Viya, Python, AI
LEADERSHIP & COMMUNITY
• Wells Fargo SAS Steering Committee Member
• Host, Wells Fargo Annual SAS Day (Wilmington, DE)
• Creator & Lead Instructor, WF SAS Certification Academy
• Mentor to 100+ SAS programmers across multiple organizations
Contact this candidate