About Me
Data Connoisseur, SQL Extraordinaire, & Occasional Firefighter.
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
Freelance Services
Web Design
Dynamic web solutions for hobbyists, communities, and professionals.
E-Commerce
Web shops and e-commerce websites that establish businesses online.
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
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.