
Ryan R
Data Expert
Competenze

Consulta i miei servizi

Portfolio
Esperienza lavorativa
Principal Architect & Founder
RFA Consulting • Lavoratore autonomo
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.
VP of Technology Platforms
NSA Storage • Full time
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.
Senior Data Engineer/Architect
Duke Energy • Full time
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.