Данило

Yatsuk Danylo
Middle Python Developer (with Strong QA & Support Background)
Lutsk, Ukraine | [open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section) | [open contact info](look above in the "contact info" section) |
github.com/DanyloYatsuk

PROFESSIONAL SUMMARY
Experienced Middle Python Developer with in-depth expertise in test automation (QA Automation) and
technical support for complex systems (L3 Technical Support). With over 2 years of overall experience in
IT, working in QA and technical support allows me to view the product holistically: from writing clean,
optimized backend code (Django, PostgreSQL) to ensuring its stability, designing test architectures, and
effectively resolving critical incidents. I have a strong background in identifying and fixing architectural
flaws, optimizing complex SQL queries, and setting up CI/CD processes. I am looking for a role as a
Python Developer where I can apply my engineering skills to build reliable solutions.

TECHNICAL SKILLS

● Backend: Python, Django, Django REST Framework, Django ORM, Celery, Redis
● Databases: PostgreSQL, MySQL, SQL optimization, indexing, subqueries, aggregations, pgvector
● Integrations: REST APIs, Webhooks, OAuth 2.0, Firebase, Google Calendar, Calendly
● AI & Data Processing: Google Gemini API, LLMs, Sentence Transformers, vector embeddings, semantic
search
● DevOps & Tools: Docker, Docker Compose, Linux, Bash, Git, Grafana, Sentry, Postman
● Testing: Pytest, Playwright, Selenium WebDriver, API Testing, Regression Testing

PROFESSIONAL EXPERIENCE

Python Developer @ SP-LUTSK 05/2024 – 10/2026 (Lutsk,
Ukraine)
Developed backend solutions for warehouse management, inventory management, e-commerce order fulfillment,
and AI-powered email automation platforms.
● Designed and maintained scalable backend services using Python, Django, Django REST Framework,,
implementing modular architecture, reusable service layers, and clean business logic across multiple
domains.
● Designed and optimized complex PostgreSQL queries using Subqueries, Exists, annotations, aggregation
functions, indexes, and ORM optimization techniques, significantly improving API performance and
reducing database load.
● Developed integrations with multiple third-party services including payment providers, Firebase, LinkedIn
OAuth, external logistics platforms, and AI APIs, implementing reliable webhook handling and
fault-tolerant communication.
● Implemented asynchronous background processing using Celery and Redis for long-running operations,
notifications, scheduled jobs, document generation, and external service synchronization.
● Built automated document generation pipelines producing Excel, PDF, CSV, shipping labels, invoices,
packing lists, and barcode documents using Python libraries and custom formatting logic.
● Improved application performance by optimizing Django ORM queries through select_related(),
prefetch_related(), queryset optimization, indexing strategies, and query analysis, reducing unnecessary
database round trips.
● Containerized development and production environments using Docker and Docker Compose, simplifying
local development, dependency management, and deployment consistency.

● Worked extensively with PostgreSQL, Redis, Django Channels, and WebSockets, implementing real-time
notifications and scalable backend communication.
● Developed AI-powered features by integrating Google Gemini APIs, implementing intelligent content
parsing, automated text generation, structured JSON processing, and prompt engineering.
● Designed and developed an AI-powered email automation platform that analyzed incoming email
conversations, maintained conversational context, and generated intelligent responses using Large
Language Models (LLMs).
● Integrated scheduling services including Google Calendar and Calendly, enabling AI-generated emails to
automatically offer meeting availability and booking links.
● Implemented vector embeddings and semantic similarity search using pgvector, PostgreSQL, and
Sentence Transformers for product category unification and clustering.

QA Engineer @ SP-LUTSK 08/2024 – 6/2026
Hybrid engineering role focused on end-to-end automation testing frameworks, backend features development, and
system stability.
● Developed and maintained automated tests and regression suites; performed API, integration, functional,
and database testing.
● Validated REST APIs and business logic using Postman, Swagger/OpenAPI, PostgreSQL, and SQL.
● Implemented and customized Kiwi TCMS for centralized test management, test execution tracking, and
regression planning.
● Automated bug tracking and reporting workflows using Google Apps Script and Google Sheets.

Technical Support Engineer (L3) @ SP-LUTSK 03/2025 – 10/2026
Providing deep level-3 technical infrastructure support for enterprise clients and automating internal workflows.
● Investigated and resolved complex L3 production incidents, performing root cause analysis across
backend services, databases, and third-party integrations.
● Diagnosed and troubleshot issues within Python, Django, and PostgreSQL applications by analyzing logs,
SQL queries, API requests, and application behavior.
● Supported enterprise ERP, warehouse management, logistics, and e-commerce platforms, ensuring high
system availability and minimizing business impact during incidents.
● Monitored and validated integrations with external services, including payment providers, shipping
platforms, cloud services, and third-party REST APIs.

EDUCATION
B.S. in Computer Engineering
National Technical University | 2022 – 2026

LANGUAGES
Ukrainian: Native | English: Intermediate (B1)