Business Intelligence Risk Management

Professional Summary

Senior SAS Solutions Architect with 25+ years of experience specializing in SAS enterprise analytics, cloud migration, and SAS business intelligence implementations.

Expert in designing and deploying scalable SAS platforms across Fortune 500 companies in healthcare, finance, banking, insurance, retail, and energy sectors

Technical Expertise

SAS Platform Architecture, Cloud Migration (AWS/GCP/Azure), Data Warehousing, Enterprise Analytics, Business Intelligence, Risk Management, Healthcare Analytics, ETL Development, Performance Optimization, Snowflake, Teradata

Quantifiable Achievements

Reduced data processing time by 40% through optimization initiatives

Improved data accuracy by 95% through automated quality controls

Decreased system failures by 60% through preventive measures

Reduced migration errors by 30% in cloud transitions

Industry Experience

Healthcare: Kaiser Permanente, CVS Health, BlueCross/BlueShield

Financial Services: Truist Bank, Discover Card, Capital One

Energy: Duke Energy Trading, Entergy Retail Solutions

Retail: The GAP, Macy's, CarMax

Technical Skills

SAS Viya Architecture

SAS Viya Deployment

SAS Viya Administration

SAS Data Migration to SAS Viya

SAS Grid Architecture

SAS Grid Administration

SAS Enterprise Business Intelligence

SAS Enterprise Business Intelligence Deployment

SAS Enterprise Business Intelligence Administration

SAS Business Visualization

SAS Risk Management Solutions

SAS Financial Management

DataFlux Data Management

Cloud Platforms (AWS, GCP, Azure)

Azure Cloud System Architecture

Snowflake Development

ETL Development

Databases SAS, Oracle, Teradata, DB2, Hadoop, Snowflake, BigQuery, Access

Windows

LINUX

UNIX

Microsoft Power BI Tools

DAX

Certifications

SAS Advanced Programmer

Microsoft Azure (2022)

Google Cloud (2023)

ISO 2000 Certified Quality Assurance Analyst

Companies:

Telecom (SBC/Sprint)

Insurance (BlueCross, United HealthCare)

Medicare (State of NC)

Retail Marketing (Macy’s/GAP, SBC)

Financial Risk Management (Barclays Bank in London)

Finance (Truist Bank)

Commodities Trading (Duke Energy)

Energy (Entergy Solutions)

Fraud Detection (CapitalOne)

Pharmacy Benefit Manager (CVS) Skills Matrix:

SAS Architecture

Design the customer’s SAS Business Intelligence Platform and provide the PLAN file required to implement the required SAS software.

SAS Viya on Azure and GCP

Deployment

Install and configure the SAS Business Intelligence Platform including SAS Tools according to the architecture plan.

Deploy SAS Viya 202x.x on Azure and GCP

Administration

Administrative SAS 9.

Administrative SAS Viya

Provide support services regarding users, services, security, and maintenance of the SAS environment.

SAS Grid

SAS Viya 202x.x on Azure and GCP (Grafana and Prometheus)

SAS Software Solution Customization

modify individual SAS Tools for independent or enterprise usage.

Development

Create custom ad-hoc code for ETL and processes according to the customer's needs and requirements.

Training

Instruct and train users and administrators in the usage of SAS by 5-minute videos.

Azure Skills

Architecture

Kubernetes (YAML, KUBECTL)

Admin

Security

IAM

Google Cloud Skills

Architecture

Kubernetes

Admin

AWS Cloud Skills

Architecture

Data Bricks

Analyst

Snowflake

Analyst

Data Warehousing

Moderate JAD sessions and design and instantiate database schemes for MS SQL, Oracle, and Teradata.

Python –

Basic level I used to translate SAS to Python

Infoworks

Developer SAS Professional V6 (Co-author): Advanced expertise in SAS V6, including co-authoring aspects of the certification program.

Certified SAS Advanced Programmer:

Proficiency in advanced SAS programming techniques and analytics.

Linux Essentials:

Fundamental knowledge and skills in Linux operating systems.

Certified Teradata Professional:

Expertise in Teradata database technology and applications.

Certified Teradata Implementation Specialist:

Specialization in the implementation of Teradata solutions.

Certified Teradata SQL Specialist:

In-depth knowledge and proficiency in Teradata SQL.

ISO 2000 Certified Analyst:

Expertise in IT service management in accordance with ISO/IEC 20000 standards.

Certified Quality Assurance:

Principles and practices of ensuring software quality and reliability.

US Navy Air Traffic Controller: Specialized training and experience in air traffic control from the US Navy.

Professional Experience:

Position: SAS VIYA Subject Matter Expert

Client: MayoInc

Duration: 06/1994 – Present

25 years of industry experience as an independent consultant and a SAS Partner of the Year award recipient,

specialize in SAS VIYA cloud analytics solutions across GCP and Azure.

My expertise includes leading the cloud migration of technology for analytics teams at CVS Healthcare and the financial organization Truist Bank.

I am committed to driving significant business outcomes by harnessing the power of analytics and cloud technologies.

Partnered effectively with stakeholders and leaders to plan and implement long-term strategies, aligning technology initiatives with business objectives.

Innovative and Effective Communication: Innovative leader with a successful track record in delivering objectives and visions to clients, effectively mitigating risks, resolving QA issues, and achieving objectives.

Problem Resolution: Proven ability to resolve complex issues in SAS Business Intelligence Systems, ensuring system integrity and efficiency.

Position: SAS VIYA Architect

Client: Truist Bank

Location: Remote

Duration: 06/2024 – 11/ 2024

Technical Architecture Design

Designed a robust technical architecture tailored to SAS Viya on AWS, leveraging Snowflake as the enterprise data source.

This architecture was aligned with complex business requirements to ensure scalability, reliability, and performance optimization.

Incorporated AWS-native services like Elastic Load Balancing and Auto Scaling to dynamically manage workloads and optimize resource utilization.

Migration and Optimization

Migrated analytics workflows from SAS 9.4 and SAS Enterprise Guide to SAS Viya on AWS, ensuring seamless integration with Snowflake. This transition enabled efficient data processing and improved system performance

Developed automated processes for migrating datasets from SAS to Snowflake, reducing migration errors by 30% and streamlining workflows.

Performance Tuning

Optimized server configurations for SAS Grid to handle increased workloads efficiently.

Tuning memory allocation, CPU usage, and storage I/O for high-performance analytics processing.

Utilized monitoring tools like Grafana and Prometheus to track system performance metrics in real-time, identifying bottlenecks and implementing corrective actions.

Integration Enhancements

Integrated SAS tools with Microsoft Office applications (e.g., Excel, Word) to enhance productivity and streamline reporting processes across teams.

Enabled seamless interaction between Snowflake and SAS Viya by optimizing data pipelines and ensuring compatibility with AWS storage solutions.

Collaboration and Documentation

Collaborated with cross-functional stakeholders to align cloud migration strategies with enterprise objectives, ensuring that the architecture met both technical and business needs.

Created comprehensive guidelines and reference documentation for migrating user-written code from PC SAS to SAS Viya managed services, enabling smooth transitions for users.

Security and Compliance

Implemented robust security measures using AWS Identity and Access Management (IAM) to control access to SAS resources.

Ensured compliance with organizational policies by configuring secure data connections between SAS Viya, AWS, and Snowflake.

Position: SAS VIYA Cloud Subject Matter Expert

Client: CVS health

Location: Northbrook, IL

Duration: 03/2020 – 03/ 2024

Cloud Migration Leadership:

Spearheaded the strategic migration of Business Technology and Analytics Teams to cloud platforms (GCP/Azure), ensuring seamless transitions and enhanced scalability.

SAS VIYA Deployment:

Engineered, configured, and implemented SAS VIYA 4.0 proof-of-concept (POC) environments, optimizing integration and performance.

Process Optimization:

Transformed ad-hoc PBM processes from PC SAS to an On-Demand SAS Grid environment using SAS Enterprise Guide and SAS Studio, improving efficiency and reducing manual intervention.

User Migration Strategy:

Developed and executed a comprehensive user migration plan from PC SAS to SAS Grid, optimizing server configurations to handle increased workloads effectively.

System Upgrades:

Championed the upgrade from SAS 9.4 to SAS VIYA 4.0, driving improvements in Visual Analytics and leading the architectural design of the new environment.

Cloud Integration:

Facilitated the successful transition of CVS Analytics clients to Google Cloud’s Vertex AI and BigQuery platforms, providing end-to-end support for analytics modernization.

Training Development:

Designed and delivered training programs in SAS and Python to enhance team capabilities, fostering continuous learning and upskilling across departments.

Automation & Standardization:

Automated and standardized SAS jobs for PBM processes, reducing onboarding time for new users while ensuring consistent operations.

Cross-System Integration:

Integrated SAS Grid with Power BI and Microsoft Outlook to streamline workflows, improve productivity, and enable seamless data sharing across tools.

Troubleshooting Expertise:

Provided technical expertise in troubleshooting SAS administration tasks for SAS Grid environments, ensuring system reliability and performance continuity.

Position: Senior SAS Consultant

Client: SAIF

Location: Salem, OR

Duration: 04/2019 – 11/2019

SAS Environment Evaluation & Optimization

Conducted a comprehensive review of existing SAS environments, providing actionable recommendations to enhance synchronization between production and development systems.

Identified and resolved system architecture deficiencies, focusing on scalability, user management, and backend integration with SAS Visual Analytics and Active Directory.

SAS Environment Management Implementation

Implemented the SAS Environment Management tool to streamline user access, improve reporting capabilities, and enhance system performance.

Reorganized user groups, roles, and access permissions to align with SAIF's operational needs while strengthening security protocols.

Security Model Redesign

Redesigned the security model to reflect SAIF’s current requirements and future growth plans, ensuring robust administrative strategies.

System Updates & Migration Path Development

Applied critical SAS hotfixes to maintain an updated and secure environment.

Developed strategic migration plans for implementing SAS Foundations, Enterprise Guide (EG), and Visual Analytics.

Change Management & Data Process Optimization

Introduced Change Management methodologies to facilitate seamless migrations between development and production environments.

Simplified processes for loading LASR tables from the data warehouse, improving efficiency and reducing manual effort.

Data Mart Strategy & Schema Enhancement

Defined a data mart strategy leveraging SAS Visual Analytics to reduce reliance on manual weekly data extracts.

Optimized schema definitions in SAS Visual Analytics to improve data accuracy and reliability.

Disaster Recovery & High-Availability Design

Formulated disaster recovery SOPs, including automating the re-initialization of SAS environments (Production & Development).

Designed a high-availability, multi-tier server model for SAS Visual Analytics in compliance with SAS standard operating procedures.

Key Achievements

1.Enhanced system scalability by resolving critical backend integration issues related to Active Directory.

2.Improved data accuracy through optimized schema definitions and streamlined LASR table loading processes.

3.Strengthened operational security by redesigning access permissions and implementing a future-proof security model.

Position: SAS Enterprise Architect

Client: Kaiser Permanente

Location: Oakland, CA

Duration: 11/2018 – 02/2019

Technical Leadership

Led enterprise-wide transformation from mainframe to modern SAS Business Intelligence Platform, architecting scalable solutions for one of America's largest healthcare providers.

Architecture & Migration Strategy

Architected comprehensive SAS BI Platform infrastructure, establishing foundational framework for enterprise-wide analytics modernization

Designed robust migration pathway from legacy mainframe systems to modern SAS BI environment, ensuring zero data loss and business continuity

Executed in-depth legacy code analysis and documentation of mission-critical mainframe applications to facilitate seamless transition

Platform Optimization

Engineered automated workflows for systematic data migration, significantly reducing manual intervention and migration timeframes

Implemented advanced SAS Management Console configurations for streamlined metadata management and enhanced system governance

Curated strategic selection of SAS tools and components to maximize platform capabilities and user adoption

Technical Expertise

SAS Enterprise BI Platform

Mainframe Systems

Data Migration

System Architecture

Metadata Management

Enterprise Workflows

Position: SAS Architect

Client: RedMane Technologies LLC,

Location: Chicago, IL

Duration: 07/2018 – 09 2018

SAS Platform Implementation & Administration

Architected and deployed multi-tier SAS 9.4 Business Intelligence infrastructure across Windows and Linux environments

Administered system performance, security protocols, and user access management for optimal platform operation

Implemented comprehensive data integrity measures and system monitoring protocols

Executed strategic deployment planning to ensure platform stability and scalability

Technical Solutions Configuration

Deployed SAS Visual Analytics for advanced data visualization and business intelligence reporting

Implemented SAS Data Management Advanced for enterprise-wide data governance and quality control

Configured SAS Access to Hadoop integration for seamless big data processing

Installed and managed SAS Financial Management for financial analytics and reporting

Deployed SAS Data Flux for data quality management and workflow optimization

Implemented SAS Forecast Studio for predictive modeling and statistical analysis

Configured SAS Data Integration for ETL processes and data warehousing

Set up SAS Enterprise Guide for advanced analytics and reporting capabilities

Established SAS Web Tools for browser-based application access

Key Technical Skills

Business Intelligence Platform Administration

Multi-tier Architecture Design

System Security Management

Performance Optimization

Data Integration

Enterprise Analytics

Cross-platform Implementation

User Access Control

System Monitoring

Data Visualization

Position: Sr. SAS Software Consultant

Client: Wounded Warrior Project

Location: Jacksonville, FL

Duration: 01/2018 – 07/2018

SAS BI Platform Validation and Implementation

Designed and implemented the SAS Business Intelligence Platform, incorporating tools such as SAS Forecast Studio and SAS Financial Management Studio to meet state, federal, nonprofit operational, and reporting compliance requirements.

Applied SAS best practices to ensure platform scalability, security, and adherence to regulatory standards.

Delivered in-depth training sessions on the following SAS tools to enhance organizational capabilities:

SAS Enterprise Guide: Advanced data analysis and reporting.

SAS Visual Analytics Administration: Interactive data visualization and analytics.

SAS Information Maps: Data abstraction for streamlined reporting.

SAS OLAP Cube Studio: Multidimensional data analysis and management.

SAS Data Integration Studio: ETL processes for efficient data integration.

SAS Web Report Studio: Web-based reporting solutions.

SAS Management Console: Centralized resource management.

SAS BI Portal: Unified web interface for BI content delivery.

SAS Forecast Studio: Advanced forecasting capabilities.

SAS Financial Management Studio: Financial data analysis and reporting.

Training Material Development

Authored detailed training manuals and instructional materials for all SAS BI tools, facilitating user adoption and proficiency across teams.

Custom Reporting Solutions

Developed macro-driven custom reporting solutions tailored to the organization’s objectives, improving decision-making through actionable insights.

User Training on SAS Administration

Conducted targeted training programs for SAS administrators to enhance their expertise in managing the SAS environment, including user access, system performance optimization, and tool utilization.

Key Highlights:

Successfully validated the SAS BI Platform while ensuring compliance with operational and reporting requirements unique to nonprofit organizations.

Enhanced organizational efficiency by training users on advanced SAS tools, enabling data-driven decision-making.

Delivered tailored solutions that streamlined reporting processes and improved analytics capabilities.

Position: Sr. SAS BI Consultant

Client: IBM Truven Health Analytics

Location: Chicago, IL

Duration: 07/2017 – 09/2017

SAS BI Platform Validation:

Conducted a comprehensive evaluation of the SAS Business Intelligence Platform to ensure compliance with performance, accuracy, and regulatory requirements.

Test Case Development & Execution:

Designed and executed detailed test cases to validate the functionality of SAS EBI tools, analyzing results to identify gaps and implement corrective actions.

Troubleshooting & Configuration:

Diagnosed and resolved configuration issues within the SAS EBI environment, improving system performance and user satisfaction by 15%.

Optimization Recommendations:

Delivered actionable recommendations to enhance user experience and streamline production processes within the SAS environment.

Created comprehensive training materials

SAS BI tools, enabling end-users to maximize platform capabilities and improve operational efficiency.

Provided targeted training on SAS tools

SAS Enterprise Guide: Advanced data manipulation and analysis.

SAS Information Maps: Efficient data layer abstraction for reporting.

SAS OLAP Cube Studio: Multidimensional data analysis.

SAS Web Report Studio: Interactive web-based reporting solutions.

SAS Management Console: Centralized resource management.

SAS BI Portal: Unified interface for accessing SAS BI content.

SAS Forecast Studio: Predictive analytics and forecasting.

Position: Sr. SAS Consultant

Client: Bluestem Brands

Location: Minneapolis, MN

Duration: 01/2017 – 05/2017

Strategic Analytics Implementation

Led strategic BI initiatives through advanced SAS analytics capabilities, driving data-driven decision making and operational excellence. Designed and executed experimental analyses to uncover actionable business insights and revenue opportunities.

Platform Administration & Development

Administered SAS Enterprise BI platform including implementation, configuration, upgrades, and maintenance

Orchestrated system performance monitoring, problem resolution, and infrastructure optimization

Managed user access controls and security protocols across the SAS environment

Cross-functional Leadership

Partnered with IT specialists to integrate SAS solutions within enterprise architecture, ensuring alignment with security standards and network infrastructure. Conducted comprehensive training programs and gathered business requirements to develop workflow solutions.

Key Technical Skills

SAS Enterprise BI Platform

Advanced Analytics & Experimental Design

Business Intelligence Solutions

System Performance Optimization

User Training & Requirements Gathering

IT Security & Integration

Cross-functional Collaboration

Core Achievements

Successfully implemented and managed enterprise-wide SAS BI platform

Developed multiple workflow solutions improving operational efficiency

Established robust monitoring and maintenance protocols

Delivered strategic insights through experimental analytics

Position: Sr. SAS Developer

Client: CVS/Caremark

Location: Northbrook, IL

Duration: 09/2015 – 02/2016

Legacy System Modernization

Led comprehensive SAS code modernization initiatives focusing on medial claims processing between SAS and Teradata.

Implemented performance optimization techniques resulting in enhanced data retrieval and transformation efficiency.

Technical Implementation

Engineered macro-driven architecture for scalable data processing workflows

Developed standardized SAS macro libraries to streamline cross-team operations

Optimized claims data extraction and transformation procedures

Executed systematic code refactoring to improve maintainability

Performed detailed requirements analysis for system enhancements

Key Achievements

Successfully modernized legacy data processing systems

Implemented standardized macro framework for enterprise-wide use

Enhanced data accuracy and processing efficiency through optimized code structure

Established consistent development practices across multiple project teams

Position: Senior SAS Developer

Client: BlueCross/Blue Shield

Location: Durham, NC

Duration: 05/2015 – 09/2015

Data Processing & Analytics

Developed and optimized SAS programs for Medicare and Medicaid claims processing, achieving significant improvements in data extraction efficiency from Teradata databases. Implemented automated quality control measures that enhanced data accuracy and reduced processing time.

Quality Assurance & Compliance

Executed comprehensive code reviews and quality assurance protocols

Developed standardized testing procedures for SAS applications

Implemented automated validation checks for data integrity

Documented quality control processes and compliance measures

Technical Leadership

Established SAS development standards and best practices, leading to a 30% reduction in code maintenance time.

Mentored junior developers in SAS programming techniques and system administration fundamentals.

Process Optimization

Conducted systematic analysis of existing SAS processes

Identified and resolved critical system bottlenecks

Implemented automated error detection and reporting

Created documentation for standard operating procedures

System Administration

Provided technical guidance on SAS platform administration, including user management, security protocols, and performance optimization.

Developed training materials and conducted workshops for team members on SAS administration best practices.

Position: Senior SAS Developer

Client: Discover Card

Location: Riverwoods, IL

Duration: 06/2014 – 05/2015

Performance Optimization

Enhanced financial reporting accuracy by optimizing SAS/Teradata code for refund calculations and payment matching exceptions.

Reduced processing time by 40% through improved code efficiency and SQL optimization techniques.

ETL Development

Engineered robust ETL solutions using SAS Enterprise Guide by:

Developing 25+ SAS stored processes for automated data handling

Creating 30+ parameterized macros for flexible data transformations

Implementing 15+ standardized programs for consistent data processing

Risk Control Implementation

Streamlined Marketing Risk Control operations by:

Establishing standardized reporting protocols across 5 business units

Reducing report generation time by 50% through process automation

Implementing quality control checks that improved data accuracy by 95%

Process Enhancement

Strengthened system reliability through:

Documenting 20+ process vulnerabilities and implementing solutions

Reducing system failures by 60% through preventive measures

Creating comprehensive documentation for 10+ critical processes

Data Integration

Designed enterprise-wide data transfer monitoring by:

Implementing automated validation for 100+ daily data transfers

Reducing data reconciliation errors by 75%

Creating real-time alerts for transfer failures

Establishing end-to-end data lineage tracking

Position: Sr. SAS Developer

Client: Highmark -Blue Cross/Blue Shield

Location: Pittsburgh, PA

Duration: 06/2013 -12/2013

Technical Delivery

Healthcare Analytics Platform Development

Engineered and deployed a comprehensive graphical interface system for healthcare sales data distribution and analytics.

Implemented interactive dashboards for real-time sales performance monitoring and healthcare metrics visualization.

ETL Architecture & Development

Designed and implemented complex ETL workflows using SAS Enterprise Guide, integrating Oracle and Teradata data sources.

Created parameterized stored processes and reusable macro libraries for standardized data processing and transformation routines.

Data Management & Governance

Administered SAS table registration and metadata management through SAS Management Console.

Implemented data governance protocols and established metadata standards for enterprise-wide consistency

Business Intelligence Solutions

Architected multidimensional OLAP cubes using SAS OLAP Cube Studio for advanced analytics and reporting capabilities.

Developed dynamic reports through SAS Web Reports Studio and Information Delivery Portal, delivering actionable insights to stakeholders.

Process Automation

Engineered automated workflows using SAS Enterprise Guide stored processes, implementing scheduled report generation and data refresh mechanisms.

Established monitoring protocols for process execution and performance optimization.

Position: Sr. SAS BI Developer

Client: State of NC Medicaid Medicare

Location: Dunham, NC

Duration: 03/2013 – 07/2013

Healthcare Analytics Implementation

Led development of Medicare/Medicaid claims analysis platform for North Carolina state healthcare system.

Engineered interactive reporting solutions for comprehensive claims monitoring and analysis

Data Integration Architecture

Developed robust ETL framework using SAS Data Integration Studio for processing healthcare claims data.

Implemented Oracle table registration and optimized view creation for enhanced data accessibility and performance

Environment Management

Orchestrated systematic code deployment across development, testing, and production environments.

Established version control protocols and maintained deployment documentation for seamless transitions.

Business Intelligence Solutions

Designed multidimensional OLAP cube structures for complex healthcare data analysis.

Created dynamic reports using SAS Web Reports Studio and Information Delivery Portal, enabling real-time claims monitoring and trend analysis.

Technical Proficiencies

SAS Data Integration Studio

Oracle database integration

OLAP cube development

SAS Web Reports Studio

Information Delivery Portal

ETL process optimization

Healthcare claims processing

Multi-environment deployment

Position: SAS Developer

Client: Gallup

Location: Remote

Duration: 01/2012 – 06/2012

Program Development and Maintenance

Engineered and maintained mission-critical SAS production programs while performing comprehensive analysis and documentation of legacy SAS code for enhanced system clarity

Process Documentation and Quality Assurance

Established detailed process documentation and executed systematic troubleshooting protocols across development and production environments to ensure optimal system performance

Data Integration

Implemented robust ETL processes for data transformation, utilizing standard SAS methodologies and best practices for data integration

Technical Skills Applied

SAS Programming

ETL Development

Production Support

Technical Documentation

Process Optimization

Quality Assurance

Production Architecture

Created and validated prototype ETL workflows and Information Maps for production deployment.

Established standardized processes for data integration and reporting, ensuring consistent delivery of healthcare analytics solutions.

Reporting Solutions

Engineered custom healthcare reports using SAS Information Maps and Information Delivery Portal.

Developed interactive dashboards for patient metrics and provider performance analysis, incorporating drill-down capabilities and dynamic filtering options.

Key Deliverables

Automated medical data extraction processes

Standardized healthcare reporting templates

Interactive provider performance dashboards

Streamlined patient data analytics workflows

Position: SAS Web Report Studio Consultant

Client: Sun Life of Canada

Location: Boston, MA

Duration: 02/2011 – 06/2011

Data Warehouse Implementation

Engineered an Activity-Based Management (ABM) data warehouse using SAS Data Integration Studio, implementing robust ETL processes and data quality controls

Developed enterprise Business Intelligence Solutions for reporting using SAS 9.2 EBI platform producing

Interactive reporting marts

OLAP cube structures

Secure report distribution systems

Technical Architecture Designed and implemented scalable reporting frameworks incorporating:

Automated data extraction processes

Standardized

Contact this candidate