Hi, my name is

Andrey Strelchenko

Middle System Analyst with 3 years in transportation IT. I work with requirements, database design, API integrations, aviation data, and secure transport workflows.

View projects
Recent technologies:
OpenAPI PlantUML YandexWiki OpenAPI REST Confluence OpenAPI PostgreSQL Kafka
01.

Experience

Middle System Analyst with 3 years of experience in transportation. I specialize in requirements gathering and analysis, database design, integrations, OpenAPI documentation, and aviation IT workflows. My work helps students buy subsidized tickets, aircraft take off safely, and trip data stay secure.

Main focus: transport IT infrastructure, API integrations, data design, documentation, and analytics for aviation workflows.

View projects
Andrey Strelchenko
02.

Skills

Backend and APIs

  • OpenAPI / Swagger
  • REST / SOAP / AsyncAPI
  • Python / Flask / SQLAlchemy
  • Kafka / RabbitMQ / Redis

Databases and DWH

  • PostgreSQL
  • MSSQL / MySQL
  • S3
  • DBeaver

Analysis tools

  • UML / BPMN / ERD
  • PlantUML / draw.io
  • Superset
  • Jira / Confluence

Infrastructure

  • Docker
  • Nginx
  • Linux
  • Cloudflare
03.

Projects

Systems and tools from transport IT: aviation tracking, security workflows, subsidized transport, and documentation.

Financial Monitoring Documentation

04.2023-05.2023
Technical and working documentation

Prepared complete technical and working documentation for a financial monitoring system after implementation, documented more than 50 API endpoints with PlantUML diagrams, and standardized documentation in YandexWiki.

OpenAPI PlantUML YandexWiki PostgreSQL

Subsidized Transport Portal

07.2023-Present
Requirements and booking system integrations

Systematized requirements for a new architecture in Confluence, prepared OpenAPI specifications for booking systems, and helped set up development processes in Jira and Confluence.

OpenAPI REST Confluence Jira PostgreSQL

Transport Security EGIS

07.2023-Present
PNR control service for transport companies

Designed a mobile web service for PNR control, optimized more than 15 subsystems and integrations, and documented architecture with PlantUML diagrams.

OpenAPI PostgreSQL Kafka PNRGOV PlantUML Jira Confluence
Documentation

Aviation Service Platform

07.2025-Present
Aircraft tracking and ACARS analytics

Feature-led aircraft tracking across the full lifecycle, reverse-engineered legacy SITA Aircom behavior, analyzed ACARS coverage with Python scripts and Superset dashboards, and launched the feature for an airline with thousands of records per day.

OpenAPI Python PostgreSQL S3 Kafka ACARS AsyncAPI Superset Jira Confluence