Bohdan Melnyk
Offer Bohdan work on your next project.
Private message 
Offer work 
Lvov,
Ukraine
currently online
available for hire
20 proposals made
on the service 10 years
Rating
Successful projects
Average rating
Language proficiency level
Українська: advanced
English: upper-intermediate
Skills and abilities
Portfolio
-
Automation of monthly reporting in Excel
The team used to manually compile data from several sources into one Excel file every month — this took half a day and often resulted in errors in the formulas. I created a script in Python (pandas + openpyxl) that automatically retrieves data from the database and exports, cleans it, calculates totals, and generates a ready Excel report with formatting, multiple sheets, and a pivot table. It can be run with a single command or on a schedule. The report that used to take half a day is now ready in a minute — and without calculation errors.
-
Firmware for STM32: sensors + data transmission via UART
The client needed to bring the STM32 board to life — read several sensors and reliably output the readings externally. I configured the peripherals (I2C, SPI, UART) in CubeMX, wrote C code with HAL for polling the sensors, processing the values, and outputting the data via UART in a convenient format. I added a watchdog timer so that the device would reboot itself in case of a hang. I tested everything on the hardware, delivered the finished firmware with comments in the code and a short instruction on how to reflash the board. The device operates autonomously, without manual intervention.
-
Competitor price parser for an online store
The store owner manually checked prices at several competitors every day — it took half a day, and something was still getting lost. I wrote a scraper in Python (requests + BeautifulSoup, and for dynamic pages — Playwright): it navigates the specified pages, retrieves the name, price, and availability, compiles everything into a Google Sheet, and highlights products where we are more expensive than the market. I set it on a daily schedule. Now prices update automatically, and the person reviews the ready report instead of clicking through dozens of pages manually.
-
Telegram bot for receiving and processing orders
Bot Development
I was approached with a small business in Telegram: orders were accepted manually in personal messages, some were lost, and there was no time to count the revenue.
I created a bot in Python (aiogram): a catalog with items, a cart, step-by-step order processing, confirmation, and automatic notification to the admin in a separate chat. I stored order data in a database and added a simple export to a table for reporting.
… Result: orders stopped getting lost, the person sees everything in one place, and the time to process a single order has decreased significantly. The bot can easily handle several dozen orders a day.
