Huseyn Aslanli

Built a Python pipeline for Android APK analysis and a central database of APIs with functional validation results. Investigated exposed API credentials, validated affected APIs, and reported confirmed exposures to application developers.

Separated APK processing from result ingestion using SQLite checkpoints, an encrypted disk-backed outbox, and authenticated delivery into PostgreSQL. Retried interrupted submissions under stable IDs and retained durable receipts to prevent duplicate ingestion after connection loss or restarts. Tested recovery across process restarts, lost acknowledgments, and database outages.

Built an asynchronous Telegram application for image and video generation with OpenAI and Google APIs. Jobs, provider attempts, and artifacts are stored in SQLite through SQLAlchemy, with schema changes managed by Alembic.

Transactional queue admission and idempotent confirmation prevent concurrent requests from creating duplicate jobs or exceeding queue capacity. Restart recovery resumes accepted video operations and avoids resubmitting requests with uncertain outcomes.

Regression tests cover concurrent confirmation, queue limits, timeouts, restart recovery, and database migrations. The current application runs locally, with mocked providers and temporary databases used for these tests.

Patched existing WLED firmware for ESP32, replacing a fixed DDP frame delay with checks for bus readiness and correcting RGBWW output while preserving other protocol timing.

Validated color-channel behavior across 2.58 million input combinations in a host test harness using the actual C++ functions. Separate checks cover timing boundaries, a busy bus, and clock wraparound. Deployed the patched firmware through OTA updates.