Articles and Publications

Technical guides, tutorials, and insights on data science and engineering.

Below I share my publications, where I delve into technical solutions and step-by-step guides.

AI & Agents

Turned Telegram Into a Local AI Voice Studio

Voice generation, design, and cloning

Designed a Telegram assistant capable of voice generation, voice design, and multi-step voice cloning conversations using local inference.

Topics:

  • Local Models (Qwen3-TTS)
  • Python & FastAPI
  • Telegram Bot

Generative AI Python PyTorch

Read on Medium →

Build a Local AI Coding Agent with llama.cpp

Secure, local code assistance

Construct a coding assistant AI agent that runs entirely locally using llama.cpp, ensuring absolute source code privacy and zero recurring API costs.

Topics:

  • Local LLMs (llama.cpp)
  • AI Agents
  • Python Development

Generative AI Python Open Source

Read on Medium →

Telegram-to-Notion Expense Tracker with Python and LLMs

Conversational agent for expense management

Build a Telegram bot that understands natural language and executes CRUD operations on Notion automatically, using an LLM agent with tool-calling.

Topics:

  • Python & FastAPI
  • LLM Agents (Tool-Calling)
  • Notion API & Telegram

Generative AI Python Notion

Read on Medium →

Pocket AI: Telegram Bot with Python

LLM deployment in messaging apps

Implement a Python bot that queries a local LLM via Ollama: command handling, prompts, and a deployment ready for personal use.

Topics:

  • Python & Aiogram
  • Ollama (Local LLMs)
  • API Management

Generative AI Python Ollama

Read on Medium →

Data Engineering

Connecting Python to HFSQL on Windows (ODBC + ETL)

Data Engineering on Windows

Practical pipeline to read HFSQL on Windows with ODBC and prepare data for ETL in Python (driver tips, compatibility, and troubleshooting).

Topics:

  • ETL
  • Data Engineering
  • Legacy Systems

Data Engineering ETL HFSQL

Read on Medium →

Connecting Python to HFSQL on Linux (ODBC + Docker/Podman)

Data Engineering on Linux

Connect legacy HFSQL to modern Linux environments using containers and ODBC: setup, configuration, and connection testing with Python.

Topics:

  • Docker/Podman
  • Data Engineering
  • Legacy Systems

Data Engineering Docker HFSQL

Read on Medium →

Data & APIs

I Built a Telegram Bot That Tells Me When My Stocks Are “Cheap”

Market monitor with technical indicators

A walkthrough of building a personal market monitor using Bollinger Bands, RSI, and Python to notify you of state changes in your watchlist.

Topics:

  • Python & Telegram Bot
  • Technical Analysis
  • APIs (yfinance)

Data Analysis Python APIs

Read on Medium →

From Beats to Data: An Easy Guide to Spotify’s API

Step-by-step API tutorial

Learn authentication, key endpoints, and how to turn your playlists into a dataset for analysis and visualization in Python.

Topics:

  • Python
  • Data Visualization
  • API Management

Tutorial Python Spotify

Read on Medium →