Stanislav Kartavenko
Analyst & developer: SQL, Power BI, websites, CRM systems
New to Contra
Stanislav is ready for their next project!
Client: live streamer (yas_garbage)
Role: solo - analysis, architecture, development, delivery
The problem. The streamer collected video links from chat and tracked them by hand, which cost air time and left the audience with no idea what was queued or how long the session would run.
What I built. A local desktop tool with two surfaces: a control panel the streamer uses off-camera, and a transparent overlay embedded in OBS as a Browser Source. Adding a link pulls the title, thumbnail and duration from the YouTube Data API; the overlay updates instantly with the new queue and the remaining total runtime.
Engineering decisions worth naming. Everything runs on the streamer's own machine - no hosting, no accounts, no viewer data leaving the computer. The server listens on localhost only, validates request origin, and keeps the API key out of every page and message it sends. The overlay is strictly read-only and authenticated by a generated token, so a leaked URL cannot modify anything. State is broadcast as versioned full snapshots rather than diffs, which makes the on-air view self-healing after any disconnection.
Delivery. Packaged as a single Windows executable with tray control and optional autostart, covered by an automated smoke suite of ~1,500 checks run against both source and the built binary.
Stack: Node.js, WebSocket, YouTube Data API v3, obs-websocket, vanilla JS/CSS front end, Node SEA packaging.
2
50
Designed the missing domain model for a legacy learning platform by extending a small set of existing entities into a scalable architecture covering programs, sections, competencies, validations, progress tracking and role-based workflows without breaking backward compatibility.
0
56
Reverse-engineered a family of 11 undocumented learning workflows into explicit state machines, creating a shared process model that eliminated ambiguity and made future workflow extensions predictable.
0
77
The salon owner runs her whole day in Telegram, so I put the back office there instead of building another dashboard she'd never log into. An admin Mini App with a calendar view, lead filters, service catalog management, and the full lead lifecycle: new → confirmed → completed. Data layer on Cloudflare D1 (SQL), connected to the booking site through a REST API I designed and built myself.
0
96