Alexey Tyshchenko

Designed and owned backend architecture for a high-load file upload service, handling files up to 100 MB and sustaining 1200 RPS with consistently low latency (≤350 ms).

Implemented scalable backend services integrated with AWS S3, ensuring reliability through rigorous load testing and peak traffic validation.

Optimized search functionality by combining quick and custom filters, reducing response time from 2.1 seconds to 320 milliseconds (6.6x faster).

Improved p95 latency from 1480 ms to 210 ms and decreased database CPU usage by 40% for 10K active users.

Architected a reactive REST API using Spring WebFlux, effectively preventing thread exhaustion during long-running Trino queries under high concurrency.

Developed a federated analytics layer over PostgreSQL and S3 with Trino, eliminating redundant ETL processes and maintaining low-latency data access.

Integrated an LLM-driven natural language to SQL interface, implementing schema-aware prompt engineering and robust query sandboxing to enhance data accessibility.

Owned end-to-end integration of an ML recommendation engine, designing efficient feature store access and inference APIs for real-time insights.

Optimized Java collection joins, reducing reward calculation time by 70% (from 1 minute to 20 seconds) and achieving $5K/year in CPU cost savings.

Implemented a boolean-expression-based filtering engine, improving system performance by 23% and significantly reducing operational costs.

Built large-scale ETL pipelines using Apache Spark, processing over 100 TB per job and reducing infrastructure costs by $8K/year.

Designed a generic calculation schema service, which cut schema development time by 50% and streamlined data processing workflows.

Led comprehensive code reviews and provided technical mentorship, fostering best practices and enhancing team capabilities.

Developed and integrated critical components for a virtualized firewall (VFW) emulator, enabling comprehensive support for complex north-south and east-west traffic scenarios in network security testing.

Designed and implemented a customizable TCP/UDP packet forwarding module, ensuring high reliability with 90% unit test coverage and successful deployment to production environments.

Contributed to the full development lifecycle, from initial design to successful deployment, collaborating with cross-functional teams to integrate network solutions seamlessly.

Engineered flexible and modular solutions for packet handling, enhancing system adaptability and future scalability for evolving network requirements.