About Me
Making SQL Server Go VROOM Since 2012
Hiya, I'm Ryan!
I bring 10+ years of experience supporting a wide range of applications across domains like CRM, POS, LIMS, HR, CAD/GIS, and WMS. I spent about three years working as a Database Administrator, handling Tier III support and digging into the more complex issues. These days, I’m focused on reporting and analytics as a Data Engineer, building ETL pipelines and putting together solid, reliable data solutions.
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 of Experience
Experience
2023 - Present
Data Engineer
Archwell Health▪ Utilized Azure Data Factory to automate the ingestion and transformation of data extracted from disparate healthcare systems, establishing repeatable integration procedures for centralized reporting and analytics.▪ Standardized ingestion and loading processes via T-SQL and configurable data pipelines, supporting high-reliability transfers between operational systems and enterprise data warehouses.▪ Engineered and optimized complex SQL transformations, validation frameworks, and load processes, improving query performance by ~25–35% and reducing data processing latency across critical reporting workflows.▪ Developed Python-based ETL utilities and scripts for data ingestion, transformation, reconciliation, and process automation, while contributing to technical design reviews and producing operational and support documentation.
2022 - 2023
Data Engineer
Affinaquest▪ Streamlined end-to-end data workflows through integration of Azure Data Factory orchestration, optimal SQL development, and efficient stored procedure implementations, ensuring high-quality data transfers across hybrid architectures.▪ Refined and standardized input pipelines, applying ETL design patterns and schema enforcement to maintain consistency and integrity within analytic-ready data models.▪ Utilized Python libraries for data manipulation, automation, and troubleshooting ETL processes, while supporting downstream reporting solutions, APIs, and analytics services through performant SQL design and data modeling.▪ Supported API integration and reporting solution troubleshooting by analyzing data flows and resolving process issues using SQL and Python.
2022 - 3 months (Contract)
Data Engineer
Extractomatic▪ Led the design and implementation of HIPAA-compliant ETL pipelines for healthcare data, transforming and integrating sensitive datasets using Microsoft SQL Server and AWS-based infrastructure.▪ Collaborated with stakeholders to integrate distinct healthcare data sources, applying best practices in ETL architecture, security, and compliance within regulated environments.
2019 - 2022
SQL Server Developer
National Distribution & Contracting▪ Engineered complex SQL stored procedures and views, improving data retrieval efficiency by 40% and ensuring data integrity through rigorous validation processes within my first 6 months.▪ Built and optimized set-based T-SQL transformations, implementing incremental loads, data validation, error handling, and performance tuning to ensure reliable and scalable data movement across both inbound and outbound integrations.▪ Developed cloud-based data integrations using Azure Data Factory and Logic Apps, orchestrating end-to-end workflows for ingestion, transformation, and delivery of business-critical data.▪ Partnered with business stakeholders to translate requirements into relational data models and ETL logic, ensuring data consistency, accuracy, and usability across downstream reporting and analytics.
2017 - 2019
SQL Server Administrator
Professional Educational Services Group▪ Administered SQL Server 2012, 2014, and 2016, syncing legacy databases with the current environment and automating the process for importing vendors’ data using SSIS packages created and deployed from Visual Studio.▪ Enhanced query performance across multiple instances of SQL Server through detailed execution plan analysis and targeted optimizations.▪ Triaged critical SQL Server issues using Activity Monitor, SQL Profiler, and dynamic management views (DMVs) to diagnose and resolve performance and system health problems.▪ Designed and deployed SQL workflows and data processing logic, streamlining release cycles and reducing deployment errors by ~20% through improved 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.
