About Me

Data Connoisseur, SQL Extraordinaire, & Occasional Firefighter.
image

Hiya, I'm Ryan!

I bring more than 10 years of experience in technology, supporting, developing, and maintaining a diverse range of enterprise applications across industries and business domains, including Customer Relationship Management (CRM), Point of Sale (POS), Laboratory Information Management Systems (LIMS), Human Resources (HR), Computer-Aided Design and Geographic Information Systems (CAD/GIS), and Warehouse Management Systems (WMS). Throughout my career, I've developed a broad technical foundation and a practical understanding of how complex applications, databases, and business processes intersect.

I spent approximately three years working as a Database Administrator, where I provided Tier III technical support, investigated complex database issues, troubleshot performance bottlenecks, and helped maintain the integrity and reliability of critical data environments. That experience strengthened my understanding of database architecture, SQL, performance optimization, and the importance of building and maintaining dependable data infrastructure.

Today, my work is centered on data engineering, reporting, and analytics. I design and develop ETL pipelines, engineer complex SQL transformations, build data validation processes, and create reliable solutions that turn raw data into meaningful, actionable information. I enjoy working through challenging technical problems, improving existing processes, and developing solutions that make data more accessible, consistent, and useful to the people who depend on it.

My approach combines hands-on technical experience with a strong appreciation for data quality, system reliability, and thoughtful engineering. I believe effective technology solutions should do more than simply meet technical requirements; they should address real business needs, simplify complex processes, and provide a dependable foundation for informed decision-making. Whether I'm troubleshooting an application, optimizing a query, developing a data pipeline, or building reporting solutions, my goal is the same: to create technology that works efficiently, scales effectively, and delivers measurable value.

My Websites

Website Bakery
Insignym

Freelance Services

Responsive Design

Web Design

Dynamic web solutions for hobbyists, communities, and professionals.

E-Commerce

E-Commerce

Web shops and e-commerce websites that establish businesses online.

Branding

Brand Building

Brand identity kits that include custom logos and digital marketing content.

Digital Marketing

Graphical and video creatives for social media content and digital marketing.

Certificates

image
image
image

Resume

10+ Years in the Making. Still Optimizing.

Experience

2026 - 6 months (Contract)

Data Engineer

Elevance Health

▪ Engineered and optimized enterprise solutions, developing complex stored procedures, transformation and reconciliation logic, indexing strategies, and performance optimizations supporting high-volume pharmacy operations and post-merger integrations.
▪ Built Python, SQL, and Snowflake solutions for data quality, reconciliation, and automation, including validation checks, exception reporting, variance and missing data detection, and out-of-balance controls. Implemented Snowflake staging, loading, data modeling, and transformation patterns to support analytics and migration initiatives.
▪ Designed and supported production pipelines with scheduling, dependency management, recoverable processing, execution logging, audit controls, and data validation. Monitored runs, analyzed load failures, coordinated reprocessing, and documented incidents and corrective actions to support reliable data delivery.

2023 - 2026

Data Engineer

Archwell Health

▪ Developed Azure Data Factory pipelines to ingest and transform data from disparate healthcare systems, establishing repeatable integration workflows for centralized reporting and analytics.
▪ Standardized ingestion and loading patterns using T-SQL and configurable pipelines to support reliable movement of operational data into enterprise data warehouses.
▪ Engineered and tuned complex SQL transformations, validation frameworks, and load processes, improving query performance by approximately 25–35% and reducing latency across critical reporting workflows.
▪ Built Python utilities for data ingestion, transformation, reconciliation, and process automation; contributed to technical design reviews and maintained operational support documentation.

2022 - 2023

Data Engineer

Affinaquest

▪ Integrated Azure Data Factory orchestration with SQL development and stored procedures to coordinate end-to-end data workflows across hybrid architectures.
▪ Standardized source ingestion and applied schema enforcement and ETL design patterns to improve consistency and integrity in analytics-ready data models.
▪ Used Python for data manipulation, workflow automation, and ETL troubleshooting, supporting downstream reporting, APIs, and analytics services.
▪ Investigated dataflow and reporting issues across integrations, using SQL and Python to isolate processing defects and support resolution.

2022 - 3 months (Contract)

Data Engineer

Extractomatic

▪ Designed and implemented HIPAA-compliant ETL pipelines to transform and integrate healthcare datasets using Microsoft SQL Server and AWS infrastructure.
▪ Worked with stakeholders to connect distinct healthcare data sources, applying ETL architecture, security, and compliance practices in a regulated data environment.

2019 - 2022

SQL Server Developer

National Distribution & Contracting

▪ Developed complex SQL Server stored procedures and views, improving data retrieval efficiency by 40% and strengthening data integrity through validation within the first six months.
▪ Built set-based T-SQL transformations and data movement processes incorporating incremental loads, validation, error handling, and performance tuning for inbound and outbound integrations.
▪ Developed Azure Data Factory and Logic Apps integrations to orchestrate ingestion, transformation, and delivery of business-critical data.
▪ Translated stakeholder requirements into relational data models and ETL logic, supporting consistent, accurate, and usable downstream reporting and analytics.

2017 - 2019

SQL Server Administrator

Professional Educational Services Group

▪ Administered SQL Server 2012, 2014, and 2016 environments, synchronized legacy databases with the current environment, and automated vendor data imports through SSIS packages developed and deployed in Visual Studio.
▪ Analyzed execution plans and optimized queries across SQL Server instances to improve database performance and data retrieval.
▪ Diagnosed SQL Server performance and system-health issues using Activity Monitor, SQL Profiler, and dynamic management views (DMVs), resolving operational problems.
▪ Designed and deployed SQL workflows and data-processing logic, reducing deployment errors by approximately 20% through stronger validation and testing practices.

2015 - 2017

Application Support Analyst II

Common Cents Systems

▪ Fielded and resolved customers’ support tickets within the laboratory information management system, integrating with applications across ~50 InterSystem Cache and SQL Server environments.
▪ Gathered and analyzed customer reporting requirements to design and deliver tailored reports aligned with business needs.
▪ Captured and standardized issue resolution workflows in Knowledge Base articles, enabling faster incident resolution and improved team productivity.

2013 - 2015

Application Support Analyst

GeoConex Corporation

▪ Coordinated the implementation, upgrade, and support of client/server-based applications across 100+ instances of SQL Server 2008 and 2012.
▪ Installed, upgraded, and administered SQL Server 2008/2012 instances, managing database mirroring and automatic failover across clustered environments to ensure high availability and system reliability.
▪ Defined quality standards for upgrading software and managing database schema changes.
▪ Developed ad hoc reports using stored procedures and views in SQL Server 2008/2012, enabling flexible data analysis and supporting business reporting needs.

Education

2012

A.A.S., Computer Programming Technology

Meridian Community College

Portfolio

My Street Cred

Blog

Musings, Mistakes & Other Commitments.

Contact

Hello World

Get in Touch