Oleg Andriyanchenko

• Refactored critical legacy code using design patterns and TDD • Reduced regression bugs and increased deployment confidence in production • Maintained and optimized DBT data pipelines • Migrated custom ETL scripts to DLT • Built a working MVP to subscribe to Salesforce events via gRPC, laying the groundwork for real-time integration between sales and internal systems Stack: Python3, asyncio, Clickhouse, Apache Superset, Data Build Tool (DBT), Salesforce, Kubernetes

• Developed and maintained a reliable microservices system with 1000s of clients • Integrated multiple third-party API services for ad data fetching • Led cross-functional team initiatives • Directed a team through the execution of complex quarterly epic projects • Provided mentorship to new team members • Successfully executed resharding of 140+ TB distributed PostgreSQL database Stack: Python3, asyncio, PostgreSQL, asyncpg, RQ, Redis, Kafka, Docker, Ansible, Pandas, FastAPI, Grafana

• Developed and maintained backend API for online educational service using Django and GraphQL frameworks • Designed robust and scalable PostgreSQL database architecture • Established and maintained CI/CD pipeline using Gitlab CI/CD, Docker and Yandex Cloud Stack: Python, Django, GraphQL, PostgreSQL, Celery, Redis, Docker, Amazon S3, Yandex Cloud, Pytest

• Developed and maintained back-end solutions for warehouses based on REST and MQ • Implemented REST-ful API for front-end communication using DjangoREST framework • Integrated third-party API to automate SKU determination • Optimized the performance of db operations through DjangoORM Stack: Python, Django, DjangoREST, PostgreSQL, Celery, RabbitMQ, Redis, Docker, Heroku, Unittest

• Developed and enhanced machine learning models for an international driver’s license recognition project using PyTorch framework • Analyzed and curated data for training datasets • Conducted experiments and tested networks to evaluate performance and quality metrics • Developed and implemented tests for validating data pipeline integrity Stack: Python, PyTorch, OpenCV, C++