r
rfa_ryan

Ryan R

@rfa_ryan

Data Expert

Estados Unidos
Inglés
Parte de la información aparece en idioma inglés.
Sobre mí
I am a data engineer and architect with over 20 years of experience building enterprise systems like data warehouses and enterprise platforms of all sorts from scratch. I have extensive SQL Server and Microsoft data stack experience as a database administrator and data engineer leveraging SQL Server Integration Services (SSIS) and Azure Data Factory (ADF).... Lee más

Habilidades

r
rfa_ryan
Ryan R
desconectado • 
Tiempo medio de respuesta: 49 horas

Revisa mis servicios

ETL de datos
I will troubleshoot and fix your azure data factory pipeline

Porfolio

Experiencia laboral

RFA_Consulting

Principal Architect & Founder

RFA Consulting • Trabajador autónomo

Dec 2019 - Present • 6 yrs 11 mos

I deliver data architecture and engineering projects end to end: requirements, design, and a working implementation. Every project includes documented trade-offs and runbooks so your own team can own it after handoff. Recent work includes a production Python application that standardizes retail catalog data. It uses LLMs to extract key attributes and score quality and match confidence, stores state in SQL Server, and runs on schedules and triggers with alerting. I also created “SQL Essentials for Anyone,” a Udemy course that takes semi-technical learners past the basics.

NSA_Storage

VP of Technology Platforms

NSA Storage • Tiempo completo

Aug 2022 - Jun 2025 • 2 yrs 10 mos

I built the technology department from a handful of people into data, web, infrastructure, and support teams, and managed outside vendors and contractors. I led the migration from a legacy SQL Server/SSRS warehouse to a governed medallion lakehouse on AWS, Snowflake, Databricks, and Power BI. The legacy system stayed fully running throughout, even during a major core-system migration. I created a single source of truth that cut development and planning effort by 80% and reduced data errors from daily to under one per month. I also unified AWS and Azure under one governance model built on the CIS security framework, and eliminated shadow IT.

Duke_Energy

Senior Data Engineer/Architect

Duke Energy • Tiempo completo

Jun 2018 - Jul 2022 • 4 yrs 1 mo

I was technical lead for SQL Server design, integration architecture, and performance tuning in a federally regulated environment. I built a pattern-based tool that generates SSIS packages from a simple Excel spec, which cut ETL development time by 80% or more. I overhauled a 500+ package ETL application with self-correcting features and data quality checks, and redesigned data quality processes to halve the application’s size. I added environment promotion and automated testing to move the team toward CI/CD, and I mentored engineers through code reviews and classes.