Andrew

Andrew Ketsko
Junior Backend / Full‑Stack Developer

Lviv, Ukraine | [open contact info](look above in the "contact info" section) | +380‑67‑7419766

GitHub:AndrewKetsko | LinkedIn:Andrew Ketsko

Professional Summary
Emerging backend engineer with a Master’s in Computer Science and hands‑on experience
designing and implementing distributed systems. Skilled in Node.js/NestJS ecosystems,
relational and non‑relational databases, and event‑driven microservice architectures.
Demonstrated ability to integrate external APIs, automate workflows, and build resilient systems
with CQRS and Pub/Sub patterns. Passionate about scalable design, developer tooling, and
leveraging AI APIs for innovative solutions.

Core Competencies
• Backend Engineering: Node.js, Express, NestJS, TypeScript
• Data Layer Expertise: PostgreSQL, MySQL, Redis, TypeORM, Prisma, Mongoose
• Architectural Patterns: Microservices, CQRS, Event‑Driven, Pub/Sub, Caching Strategies
• Integration & Automation: Google API, Puppeteer, Telegram API, AI APIs
• Frontend Exposure: React.js, Next.js, React Native
• Communication Protocols: REST, GraphQL, WebSockets
• DevOps & Infrastructure: Docker Compose, Redis transport, cloud storage APIs

Education
Lviv Polytechnic National University

• Master’s Degree, Computer Science & Information Technologies (2000–2006)
• Bachelor’s Degree, Tourism & Travel Services Management (1996–2000)

IT Skills Education Center – SQL / PL‑SQL Developer (2022–2023) GoIT School – Full‑Stack
Developer (2022–2023)

Languages
• Ukrainian: Native
• English: Intermediate
Soft Skills
• Analytical Problem Solving
• Creative System Design
• Effective Team Collaboration
• Time & Priority Management
• Clear Technical Communication

Selected Projects
AutoBrokerCRM

• Challenge: Automate complex car import workflows (purchase abroad → customs →
resale).
• Solution: Built a NestJS backend with PostgreSQL and TypeORM, integrated Google APIs
and Puppeteer for document automation.
• Impact: Reduced manual processing time, improved data consistency, and enabled
scalable lead management.

CreditAdminCRM

• Challenge: Aggregate leads from multiple sources while preventing duplication and
enforcing permissions.
• Solution: Designed a modular NestJS service with CQRS, PostgreSQL, and Redis caching.
• Impact: Increased lead quality, streamlined customer assignment, and improved
compliance.

Message Scheduler CRM (Telegram Clients CRM)

• Challenge: Businesses needed a way to automate Telegram communication — scheduling
posts, triggering responses, and moderating chats.
• Solution: Developed a microservice‑based platform with NestJS and Next.js, Redis for
caching and transport, and TypeORM for persistence. Built an admin dashboard for
scheduling, dialog posting, and permission management. Integrated event triggers to
auto‑respond to messages and enforce restrictions.
• Impact: Delivered a production‑ready CRM tool that improved customer engagement
efficiency, reduced manual moderation, and enabled scalable communication strategies
across multiple Telegram channels.

Crypto Checker Bot

• Challenge: Traders needed real‑time monitoring of Binance trading pairs with instant alerts.
• Solution: Architected three independent microservices — Telegram bot interface, core logic
engine, and Binance tracker — using NestJS, Redis transport, Redis caching, and
WebSockets for live updates.
 • Impact: Enabled users to track price changes, receive instant notifications when target
values were hit, and make faster trading decisions.

Moderation Bot (Telegram Chat Management)

• Challenge: Manual moderation of Telegram groups was inefficient and error‑prone.
• Solution: Built a NestJS‑based bot with TypeORM and PostgreSQL, leveraging Telegram
API/Telegraf to automate user permission enforcement, restriction handling, and
moderation workflows.
• Impact: Reduced administrative overhead, improved group security, and ensured consistent
enforcement of community rules.

Image Changer Bot

• Challenge: Provide users with AI‑powered photo editing directly in Telegram.
• Solution: Integrated NestJS backend with cloud image storage APIs, TypeORM, and AI APIs
for image manipulation.
• Impact: Delivered a lightweight, accessible photo editing tool for end‑users without
requiring external applications.

AI Voice CV Agent

• Challenge: Create an interactive bot that introduces developer profile and collects user info.
• Solution: Built with NestJS, PostgreSQL, Telegram API, and AI API integration.
• Impact: Demonstrated ability to merge conversational AI with backend systems for
recruitment and networking.

& other projects