Project Portfolio

Architecture and administration of high-load Service Desk systems. Successfully processed 162,000+ tickets with zero system-induced downtime.

Design, implementation, and support of YSoft SafeQ 6 print management systems in the banking sector (major state and commercial banks in Ukraine).

A high-tech service designed to automatically solve the Vehicle Routing Problem (VRP) utilizing the mathematical Google OR-Tools routing solver. The system instantly calculates optimal delivery paths while respecting driver shift limits, delivery time windows, and ticket priorities. Fully integrated with Google Maps Platform and a local OpenRouteService instance with SQLite caching. The solution is available as a standalone web platform with an open API and as a native GLPI plugin that integrates into the ticketing system to automate route planning for field engineers.

High-load ecosystem of Python gateways to extend standard GLPI REST API capabilities. Automates data exchange, builds flexible integrations, and optimizes core business processes.

Creation and support of Telegram bots for GLPI automation. Provides instant notifications for new tickets, status changes, and seamless mobile interaction with the helpdesk.

A specialized integration module for the "Nova Poshta" logistics operator directly inside the GLPI ticketing system. Allows dispatchers to instantly generate express waybills (TTN) directly from ticket pages. Features include intelligent warehouse search (optimized with debouncing and query limits for high speed), an advanced volumetric weight calculator, support for individuals and corporate clients (with automated EDRPOU validation), and automated waybill print layout generation.

An automated solution for logistics status tracking driven by a background Python microservice (Worker). The program periodically queries the "Nova Poshta" API, automatically updates delivery statuses directly inside GLPI tickets, and triggers alerts to observers and requesters upon cargo checkpoints. This fully automates the lifecycle of logistics-related tickets.

A comprehensive billing and financial accounting system designed to automate contractor payments and track service delivery costs based on GLPI tickets. The module dynamically calculates total expenditures across customizable periods using individual price grids, delivering transparent reporting with clear financial metrics and key performance indicators.

Comprehensive system for managing the full lifecycle of printer cartridges and office consumables. Automates unique barcode generation, manages refilling and recovery cycles, and integrates with GLPI ticketing to track consumables and maintain stock levels.

A GLPI plugin designed for convenient printer cartridge and consumables tracking directly within ticket forms. Instead of entering data into separate individual fields, the module embeds an interactive table right into the ticket page. Dispatchers and engineers can easily select any number of cartridge models in one click, choose the service type (replacement, refill, recovery, or new issue), and enter quantities. This simplifies helpdesk operations and automatically gathers accurate metrics for consumption auditing and budget control.

A GLPI plugin designed to generate detailed reports on page counts across printing devices and locations. It supports automated counter synchronization via GLPI Inventory as well as manual metric entries, preserving a complete history of counters for past periods. The system automatically calculates page volume differences for reporting intervals and computes total expenditures based on the cost-per-page entered by the operator.

A Service Desk automation solution that aggregates all assigned assets of a user (computers, cloud environments, colocations, profile fields) into a unified "Technical Passport". The plugin dynamically enriches newly created tickets with applicant context (either as a private comment or directly in the description), enabling support engineers to instantly view the user's hardware and environment. Features an "Operator Mode" under the Assistance menu, allowing agents to search users, preview passports, copy them to clipboard, or generate pre-filled tickets in a single click.

Design and deployment of a resilient data integration pipeline powered by Apache NiFi and Python for automated processing and bi-directional synchronization of incident tickets between banking institutions and GLPI. The system ingests heterogeneous formats (JSON, XML, raw email payloads), extracts attachments, normalizes text encodings, and routes real-time status updates back to clients in their requested specifications, successfully eliminating manual data entry errors.

An automated data enrichment pipeline developed using Apache NiFi and Google Geocoding API to clean and normalize a high-volume client address database (20,000+ records) integrated with GLPI. The system extracts address strings, performs geocoding to retrieve precise coordinates (latitude/longitude), regional hierarchies, and zip codes, and updates the database. The enriched data fully automated transport route planning, optimized delivery logistics, and reduced manual verification efforts to zero.

A fault-tolerant, high-performance synchronization gateway built with FastAPI and Apache NiFi for bi-directional replication of tickets, comments, status changes, and file attachments between two isolated GLPI systems. Fully containerized with Docker, the architecture incorporates advanced back-pressure orchestration and retry logic to survive API failures. Centralized observability is established using Grafana, Loki, and Alloy for proactive logging, metrics, and incident troubleshooting. Processes over 1,000 tickets monthly.

Design and deployment of a cross-platform backup restoration pipeline using Jenkins and Proxmox Backup Server (PBS). The solution automates the recovery of file-based databases by extracting PXAR archives via proxmox-backup-client to Linux environments, followed by secure SCP transfer and automated unpacking on destination Windows servers. The pipeline is maintained as Infrastructure as Code (IaC) in GitHub, ensuring predictable, secure, and repeatable recovery in Disaster Recovery (DR) scenarios.

Implementation of a centralized log aggregation pipeline for a Mailcow Docker-based mail infrastructure. Utilized Grafana Alloy for dynamic container auto-discovery and log enrichment (Postfix, Dovecot, rspamd) using structured labels. The streams are shipped to Grafana Loki, providing a unified console for instant analysis of SMTP delivery logs, authorization anomalies, and spam filter behaviors, drastically reducing mean time to resolution (MTTR).

Deployment of HAProxy as a centralized reverse proxy and high-performance load balancer for multiple internal services (web endpoints, CI/CD, and monitoring). Configured secure SSL termination, complex cookie- and path-based ACL routing rules, and active security countermeasures against DoS and brute-force attempts using dynamic rate-limiting and HAProxy stick-tables. Fully integrated structured traffic logging to feed downstream observability pipelines.