Looking for a job

Ігор Цвігун

@0007594

Message

Senior PHP Developer at Yellow Stone, where I co-designed a Yii2 reporting backend for 100M+ events.

Poland

Message

At Yellow Stone, I co-designed and implemented a PHP/Yii2 reporting backend using ClickHouse and MySQL for 100M+ events. Background aggregation significantly improved critical API response times.

I built analytical reports over multi-million-row datasets, with complex filters, aggregations, backend APIs, dashboards, and CSV exports. I also developed denormalized data marts and background workers for incremental refresh.

At Yellow Stone, I made large data-mart refreshes more reliable by batching them and optimizing resource-intensive queries. I also extended production Python services for ML model outputs, including stateful processing, persistence, API integration, and automated tests.

Earlier, I developed PHP backend modules, REST APIs, and third-party integrations at Synergetica, and contributed to backend systems for a live-streaming platform at GeeksForLess. I also built a Symfony application backend from scratch for AcuteNet, including REST APIs, database schema design, and unit tests.

Experience

Work history, roles, and key accomplishments

Current

Senior Backend Engineer

Current

Yellow Stone

Mar 2021 - Present (5 years 7 months)

Co-designed and implemented a PHP/Yii2 reporting backend using ClickHouse and MySQL for 100M+ events, improving API response times through background aggregation. Built analytical reports, denormalized data marts, and background workers for continuous incremental refresh.

PHP 8+Yii 2 Symfony MySQL Percona Clickhouse Redis RabbitMQ REST APIs Background Workers ETL Python Docker GitLab CI CD Linux Git

Senior Software Engineer

Together Networks Limited

Nov 2020 - Feb 2021 (3 months)

Maintained core backend services before an internal transfer within the holding company to Yellow Stone.

Senior Software Engineer

Synergetica

Jun 2017 - Nov 2020 (3 years 5 months)

Developed PHP backend modules and third-party integrations for social-networking and collaborative product-management platforms using PostgreSQL and RabbitMQ. Built WebSocket-based real-time communication and REST APIs for team statistics, reporting, and operational workflows.

PHP PostgreSQL RabbitMQ WebSockets REST APIs Third Party Integrations

Software Engineer

GeeksForLess

Jul 2011 - Jun 2017 (5 years 11 months)

Helped design and build a PHP/Symfony application backend for a live-streaming platform supporting 30,000+ concurrent viewers. Developed backend services for video storage, advertising management, and real-time analytics, and built enterprise web applications from scratch.

PHP Symfony REST APIs Database Design Unit Testing Video Streaming Advertising Real Time Analytics