www.easysqlwithryan.comAfter years of dreaming about it, I've finally started my own company offering SQL training using an all new method designed to save time and reduce complexity. I also offer freelance consulting services for SQL Server development and administration, training, and coaching.

• Maintained and enhanced custom C# application with database and SSIS backend to better manage thousands of SSIS packages, troubleshooting, and maintenance, achieving an 80% reduction in development time.• Created documentation and training courses to train others in use of proprietary SSIS package management application, duplicating 80% reduction in development time across multiple departments.• Provided code reviews and support assistance to other teams for ETL processes and SQL, increasing performance and easing development challenges for logging, orchestration, tracking, and scheduling.• Created and maintained stored procedures, tables, and other database objects by tracking updates, making changes, and performance tuning resulting in reduced server load and enabling simple ETL pipelines.• Provided code reviews of SQL, database objects, and SSIS package construction resulting in higher quality ETL pipelines, faster delivery, better performance, and ensured compliance with company standards.• Completely redesigned and implemented data quality processes using SSIS, C#, and database objects improving efficiency and consistency through heavy reuse of code, control over execution behavior, and elimination of hundreds of packages to only two.

• Supported various teams with performance tuning, alternative architectures, SQL scripting, processes and migrations resulting in greatly increased database stability and performance• Managed and supported over 20 large SQL Server instances hosting applications, data warehouse, and hundreds of data sources achieving efficient operation and reducing issues from multiple per day to once per week.• Administered over 400 instances of MySQL in large replication topologies, supporting OLTP systems and data sources, significantly reduced after-hours alerts to once per week. • Decreased problem incidents from multiple per day to one per month by implementing and tuning a large SSRS environment with hundreds of users, including scale-out and HA report server databases.

• Trained and coached SQL power users, report writers, business intelligence developers, and database administrators in using SQL more effectively, performance tuning, data retrieval techniques, and SQL scripting, increasing employee performance and promotions.• Managed all nine enterprise environments impacting data management by leveraging Microsoft tools and operating systems, SQL Server, SAP, and multiple data pipeline tools, providing the data and insight needed to drive business results to double digit growth multiple years in a row.• Designed and implemented a new data warehouse using SQL Server, several ETL tools, and Kimball data modeling concepts, achieving high adoption from marketing, accounting, revenue management, finance, and IT departments, eliminating countless hours of individual work to obtain data and reports.

• Trained and coached SQL power users, report writers, business intelligence developers, and database administrators in using SQL more effectively, performance tuning, data retrieval techniques, and SQL scripting, increasing employee performance and promotions.• Managed all nine enterprise environments impacting data management by leveraging Microsoft tools and operating systems, SQL Server, SAP, and multiple data pipeline tools, providing the data and insight needed to drive business results to double digit growth multiple years in a row.• Designed and implemented a new data warehouse using SQL Server, several ETL tools, and Kimball data modeling concepts, achieving high adoption from marketing, accounting, revenue management, finance, and IT departments, eliminating countless hours of individual work to obtain data and reports.

• Virtualized servers with VMware ESX Server and managed Citrix Presentation Server farm with 6 servers and 120 applications.• Monitored network services and performed backups for 18 TB of data every month which resulted in smooth operations.• Managed, created, and distributed disk images and software packages for 1200 computers.