John Skrainka

Background

About John Skrainka

I'm a data solutions architect that greatly values a devops philosophy. Cloud infrastructure is designed to be versatile and simple and so should be a modern data stack. Therefore, I have a lot of experience integrating Terraform into a variety of complex backend platforms in order to simplify and automate pain points related to getting software to hardware. Data projects (Python, SQL, GCP, AWS)- Built an EKS cluster using Terraform to host a Redshift cluster as well as enable CI/CD via AWS build/deploy, Docker, and Github actions- Developed asynchronous and multi-threaded ETLs in python for rapid extract and load of millions of records- Developed Python API employing the principles of functional and object oriented programming for internal usage of data catalog acting as an abstraction layer on top of REST endpoints- Thoroughly knowledgeable on consumer data privacy laws (GDPR and CCPA) and common governance frameworks such as masking, redaction, and PI classification - Modeled star schemas in Snowflake for consumer product data - Snowflake stored procedures for data privacy ETLs (JavaScript)- Designed a custom Terraform plugin (Go)- Designed and maintained repository for generation of chemical reaction data for use in training ML models. Includes reporting and validation of technical data for clarity into ML classifications- Built a series of data validation APIs used to identify thousands of false regulatory records. Core competencies- Terraform - Python (object-oriented + functional programming)- SQL (Postgres and Snowflake primarily. SQLite, Oracle, Redshift less so)- ETL/ELT - Design and scale of client-server applications and documentation of requirements using Python (pandas, numpy, sklearn along with chemistry packages RMG, rdkit, OpenEye)- Data modeling/visualization (seaborn, matplotlib)- ETL tools and processes from web scraping (scrapy/selenium) to data validation and improvement (pandas)- Experience with automated ETL tool Hevo - MS Office/Excel jjskrainka@gmail.com Link to undergraduate (3rd author) publication below: