Ryan Schraeder, Msc. Email & Phone Number

Colorado, United States

- Plan, design, and architect migration to Snowflake data lakehouse architecture for credit unions of over $27 billion AUM- Design, build, and scale data pipelines from source to presentation of data using Python, Snowflake, Snowpark (PySpark), dbt, Qlik, and MS SQL Server.- Build data models for analytics-ready data using dbt Cloud and facilitate proper CI / CD, Git, and data quality practices- Implement architectural migration from Altair Monarch to in-house Snowflake pipelines for ELT, attributing $1M+ savings YoY- Led, designed, and implemented a batch data pipeline from Snowflake to dbt Cloud for a credit application decision engine via LexisNexis, Scienaptic AI, and credit union member data

Led the data engineering initiatives toward Connectivity Insights in Charter’s internet service domain on Snowflake. Responsibilities ranged from business analysis to constructing end-to-end data pipelines to support scalable, hygienic datasets of volumes ranging from terabytes to petabytes toward my team’s support of over 7 PB of data and 275 Snowflake databases / Analytics Data Sets (ADSs). Formed cohesion as a leader between distributed data architectures and their teams:- Snowflake, Python, DBT, and Airflow as the data presentation or analytics layer- AWS EMR (Hadoop Ecosystem), Hive/Presto, AWS Lambda, and Apache Spark as the data infrastructure layer. The Full Stack:- Gitlab (CI/CD)- Jenkins (Container services via AWS ECS Fargate)- Apache Airflow (via AWS MWAA) - DBT project structures with embedded Python tooling- PySpark- Snowflake Data Warehouse - AWS S3, EMR, Spark, EC2, Lambda, Hive/Presto, Athena, Hadoop- CentOS Linux for local development

Practicum and Capstone requirement for Regis University Master of Science in Data Science. Contributed towards research in emergency medical response for Department of Defense and Public Health sectors for AI-powered solutions in medical procedure imagery.Practicum: Deep Learning and Transfer Learning Methods for Procedure Inference in Field Medical VideoData Science Practicum computer vision research project in partnership with SimWerx, BitSpace Development, Dr. Mike Busch of Regis University, and University of Washington for the United States Department of DefenseTechnologies: Tensorflow, Python, Keras, Matplotlib/Seaborn, OpenCV

Official title: Senior Full-Stack Software EngineerHired full time as senior engineer to focus on data engineering responsibilities within the COSMOS team. Eliminated technical debt in API requests with asynchronous code and tokens to lower cost and compute utilization, as well as refine and improve existing pipelines to handle scaled data and changing business requirements. Develop new pipelines with updated standards for new features and implement best practices in code quality. Aid the process of On-Call work with automated scripts to eliminate legwork for routine tasks.

Official Title: Data Engineer IIContracted to aid support and development of core data engineering for Dish Technologies within the COSMOS system. Developed a logging pipeline through all applications with custom logging to analyze bugs and weaknesses utilizing Python and an AWS Lambda script linking Cloudwatch and ELK stack to filter real-time log data into ElasticSearch. Output monitoring data reported via Kibana dashboards and internal applications.

- Deploy data migrations, definitions, and data warehouse construction with relational and non-relational techniques (PostgreSQL, DynamoDB, Python)- Improve and maintain data collection processes with backend automation (Python, SQL/NoSQL, Postgis) - Serve backend health monitoring through applications built on AWS using Python- Built internal Slack messaging tools with AWS State Machine (StepFunctions) and Lambda functions using Python

Denver, Colorado, United States

Drive the Data Analytics initiative for Product and Digital Marketing. Provide insights, deliverables, directives for impactful business decisions. Conduct experiments and build machine-learning models for customer segmentation, NLP sentiment analysis, and marketing retention (churn/cohort analysis). Utilize AWS Glue/Spark, Athena, and Quicksight to produce automated dashboards, build data sources, conduct analyses, and manage data. Investigate KPIs and define custom metrics for customer satisfaction and sales performance using Excel and AWS Quicksight / Presto.

Part-time internship while on a full-time contract with Spectrum and in my Master’s program part-time. Create reporting and dashboards with statistical modeling for the improvement of sales performance and advancement of fiber wavelength analytics. Utilize PowerBI, Python, MS SQL Server for ETL, automation, and building dashboards.

Highest tier for customer issues management. Resolved persistent customer issues of high business impact through exploratory data analysis to reduce churn and maintain 91% satisfaction score.- Execute Hadoop (HiveQL) and AWS Athena queries per ad-hoc, provide clean reporting for complex asks by Engineering and Product teams- Create data visualizations within the ELK stack (ElasticSearch, Kibana), Excel, and Tableau to present the deductive analysis of KPIs, quarterly goal progress, and quality metrics

Greater Denver Area

- Address use cases and troubleshooting for email communication using SendGrid's APIs and SMTP relay to technical andnon-technical customers- Troubleshoot complications with accounts, resellers, and provisioning and interface with product owners towardresolution- Troubleshoot deliverability of email in Splunk and generate detailed ad-hoc reports for partners and customers- Maintain 24-hour SLA with 95% CSAT personally and among team goals- Detect bad actors and hackers on the Twilio SendGrid platform and enforce compliance policy

-Provide technical education and network troubleshooting for business owners utilizing Trustwave's PCI DSS compliance portal.-Maintain exceptional performance for SLAs as brief as 1 hour.-Articulate PCI DSS and security industry compliance to non-technical customers.-Uphold exemplary account security protocol with understanding of physical security and security policies, cryptography, and current NIST National Vulnerability Database discoveries.

Greater Denver Area

- Organized and completed day-to-day tasks in assistance to artist manager Morgan Young and Adam Smith for artists The Revivalists and Opiuo- Updated booking (tour itinerary, announcements, updates).- Cleaned database assets.- QA'd creative content prior to launch.

Greater Denver Area

- Supervise a team of 6 Data Entry Specialists- Lead projects in auditing consumer data for predictive modeling and machine learning purposes- Maintain cleanliness of data within a vast database to provide clean campaign statistics- Maintain and improve internal data with Looker, Excel- Supervise a staff of well-versed Quality Representatives- Supervise CPG data entry

Master Of Science - Ms, Data Science, 3.9

Anderson College of Business and Computing Graduated with Honors Practicum: Deep Learning and Transfer Learning Methods for Procedure.

Data Analytics Bootcamp, Data Analytics, Visualization

24-week immersive program covering data analysis and visualization, web development, dashboard and advanced business intelligence.

Bachelor’S Degree (B.S.), Music Business & Audio Engineering

Activities and Societies: USMC Platoon Leader's Course ASME Volunteer (American Society of Mechanical Engineers) AES Student Member (Audio.