Ryan Bierschenk
About Ryan Bierschenk
Ryan Bierschenk is an AWS Cloud Data Engineer and Lead SQL Server BI Developer at FLEETCOR in Norcross, Georgia, with over eight years of experience in data engineering and business intelligence. He has previously held positions at various companies, including Avast Software and MIDFLORIDA Credit Union, and has a strong background in designing data architectures and migrating data solutions.
Work at FLEETCOR
Ryan Bierschenk has been employed at FLEETCOR since 2016, where he serves as an AWS Cloud Data Engineer and Lead SQL Server BI Developer. His role involves designing and developing data solutions utilizing AWS technologies. He has contributed significantly to the company's data architecture and analytics capabilities over his eight years of service in Norcross, Georgia.
Previous Experience in Business Intelligence
Before joining FLEETCOR, Ryan held various positions in the field of Business Intelligence. He worked as a BI Developer at Bunch CareSolutions, a Xerox Company, from 2011 to 2012. Prior to that, he served as AVP Business Intelligence Manager at MIDFLORIDA Credit Union from 2007 to 2014. Additionally, he was a Lead BI Data Analyst at Avast Software from 2014 to 2016. These roles provided him with extensive experience in data analysis and management.
Technical Expertise and Projects
Ryan has demonstrated technical expertise in cloud data engineering and business intelligence. He designed and developed the technical architecture of a Data Lake in AWS Redshift, utilizing AWS services such as S3, Lambda, Glue, SNS, SQS, CloudWatch, and CloudFormation. He also played a key role in transitioning an Oracle Enterprise Data Warehouse from Day-2 reporting to Day-1 reporting and managed the migration of over 75 SSIS packages from a legacy DB2 connection.
Education and Qualifications
Ryan Bierschenk studied at Polk State College, where he earned an Associate's degree in Liberal Arts and Sciences from 2001 to 2006. He furthered his education at the University of South Florida, obtaining a Bachelor of Science in Information Technology from 2007 to 2009. His educational background has provided him with a solid foundation in technology and data management.
Achievements in Data Management
Throughout his career, Ryan has achieved significant improvements in data management processes. He led the migration of a legacy ParAccel application database to AWS Redshift and reduced support and maintenance time from 80% to 20% through automation. He also served as the primary SQL Server Database and SSIS/SSRS Developer on a BI team supporting a 10TB high availability MS SQL Cluster, implementing documentation standards across the MS SQL platform.