Zahar H.
Private message 
Offer work 
Dnepr,
Ukraine
very busy
Rating
Language proficiency level
Українська: fluent
Русский: fluent
English: pre-intermediate
Skills and abilities
Programming
- AI & Machine Learning
-
Bot Development
from 113 USD for project
- Data Parsing
- Databases & SQL
- Web Programming
Services
-
AI Consulting
from 11 USD for hour
- Content Management
- Customer Support
- Data Processing
- Enterprise Resource Planning (ERP)
Writing
Portfolio
-
282 USD AI call quality analysis system
AI & Machine Learning
Project Goal
Development of a comprehensive system for automating the collection, transcription, and AI analysis of calls from corporate PBXs and online channels. The system provides real-time monitoring of service quality, detection of critical errors, and generation of analytical reports for management.
Key Features
… • Automatic call collection from Binotel API — hourly synchronization of completed calls (incoming and outgoing) with filtering of internal numbers
• Uploading and transcription of audio via AssemblyAI — speech recognition with speaker separation (manager / client)
• AI assessment of call quality via OpenAI — three assessment schemes depending on the type of call (incoming, warm outgoing, cold outgoing)
• Three interactive dashboards in Metabase — call analytics, KPIs and performance, quality by ratings
• Admin panel for managing prompts — ability to edit assessment criteria without access to n8n
• Web view of call details — interactive interface with dialogue, rating, metadata, and audio
Technical Details
The system consists of 8 n8n workflows and is built on a microservices architecture:
• Collector (hourly) — request to Binotel API, normalization, and recording in call_queue
• Processor (every 10 minutes) — uploading audio, starting transcription in AssemblyAI
• Transcription (webhook) — receiving the completed transcript from AssemblyAI
• AI Agent (on schedule) — quality assessment via GPT with Structured Output Parsing
• Infrastructure: Docker (Hetzner), PostgreSQL, Qdrant, Metabase, Nginx Proxy Manager with automatic SSL
Advantages of the Solution
• Full automation — no manual processing, the pipeline operates 24/7
• Real-time quality control — instant detection of critical errors by managers
• Detailed analytics — dashboards with filtering by managers, dates, types of calls
• Flexibility of criteria — admin can change prompts and assessment schemes without a developer
• Scalability — architecture is ready for an increase in the number of calls and operations
Results
The system operates in automatic mode. In the first month, over 13,500 calls were analyzed (not including historical data which was also calculated). Dashboards show a clear correlation between service quality and sales results. Management received a tool for objective assessment of team performance.
The final cost of call assessment is $0.003 (approximately 15 kopecks).
#n8n #Binotel #AssemblyAI #OpenAI #Metabase #PostgreSQL #Automation #CallAnalytics #AI #Telephony #UkrainianRetail #Portfolio
-
34 USD Development of a Telegram bot for order automation
Project goal:
Creation of a Telegram bot for automating the order acceptance process from clients. The bot is designed to simplify order management, reduce time spent on manual recording, and increase work efficiency.
Main functions of the bot:
… Store selection:
The user selects a city and a store from the list.
The list of stores can be supplemented or changed.
Order formation:
The user adds products to the order via buttons: selects a category, a specific product, and enters the quantity.
The product price is automatically pulled from the database.
The total amount is calculated automatically (quantity × price).
Product exchange:
Ability to add products for exchange.
Products for exchange are not included in the total amount.
Statistics and reports:
Formation of a daily report: number of stores, total amount of invoices, number of sold products.
Data is automatically recorded in a Google spreadsheet for further analysis.
Order history:
The user can view recent orders for quick repetition.
Technical details:
Platform:
The bot is developed based on the Telegram Bot API.
Data is stored and synchronized with Google Sheets through the Google Sheets API.
Database:
The Google spreadsheet contains three main sheets:
Products — list of products and their prices.
Stores — list of stores distributed by cities.
Orders — history of all orders with dates and amounts.
Additional features:
Ability to edit orders during their creation.
Automatic data update in Google Sheets.
Command to restore data from the bot in case of accidental deletion of the spreadsheet.
Advantages of the solution:
Automation: Reduced time for manual order recording.
Convenience: Simple interface with buttons for quick product addition.
Accuracy: Automatic calculation of the order amount.
Flexibility: Ability to add new stores and products.
Statistics: Convenient report for sales analysis.
Client feedback:
"Working with Zakhar exceeded all my expectations! He is a professional in his field, diving into the project details from day one, understanding my needs, and offering the best solutions. The order automation he developed works flawlessly, significantly simplifying processes and saving my time. I recommend Zakhar as a top-notch specialist!"
Hashtags:
#TelegramBot #Automation #Orders #GoogleSheets #Freelance #Portfolio
-
95 USD Development of a multilingual chatbot on the Crisp platform
Content Management
Project goal:
Creation of a multifunctional chatbot on the Crisp platform for automating communication with clients. The bot was to include a multi-level menu, support for multiple languages, filters, and other features to enhance user interaction.
Main functions of the bot:
… Multi-level menu:
More than 10 submenu cards created for various interaction scenarios.
Each menu configured to perform specific tasks, such as answering frequently asked questions, providing information about services, etc.
Support for multiple languages:
Language switching configured in the bot for user convenience.
Each menu and message adapted to the selected language.
Filters and automation:
Filters added for automatic distribution of user requests.
Automatic responses configured based on keywords and other parameters.
Backup:
Project backup created to ensure data security.
Instructions for restoring the bot provided to the client in case of need.
Recommendations for improvement:
Weaknesses of the Crisp platform identified and recommendations provided for their elimination.
Advice given on connecting AI to enhance the bot's functionality.
Technical details:
Platform:
Crisp platform used for creating and configuring the bot.
Project complexity:
The project involved working with a large number of menus, filters, and multilingual support.
Deficiencies of the platform identified and corrected, allowing for improved bot performance.
Advantages of the solution:
Automation: Reduced workload on operators due to automatic responses and filters.
Flexibility: Multi-level menu and support for multiple languages provide convenience for users.
Security: Project backup created, allowing for quick restoration of the bot's operation in unforeseen situations.
Recommendations: Useful advice provided for further improvement of the bot, including connecting AI.
Client feedback:
"Excellent work! Everything is done. Explained even how my system works. Helped set up even what was not in the technical assignment! Highly recommend! A professional in their field!"
Hashtags:
#Crisp #ChatBot #Automation #MultilingualBot #Filters #Backup #Freelance #Portfolio
-
23 USD Automation of data collection and processing from Google Sheets
Data Parsing
Project goal:
Set up automatic data import from 25 Google Sheets into a single table with subsequent formatting to a unified format. The data is updated daily, so it is important to ensure stable system operation.
Main functions:
… Data import:
Data from 25+ sheets is automatically collected into a single table.
All sheets have a similar but not identical structure.
The tool has the ability to add sheets independently.
At the time of writing this text, the client already has more than 50 sheets.
Formatting to a unified format:
Product sizes in different formats (42 1/2, 42.2/3, 42 (2/3)) are converted to a unified format (for example, 42.5).
Extra spaces, indents, and line breaks are removed. There is also a sheet for filtering special characters or phrases. For example, products without packaging ("Without box") are excluded from processing.
Processing of deleted products:
If a product is removed from the supplier's sheet, the final table indicates 0 in the "Quantity" field instead of disappearing because the website needs to have accurate information in the database.
For suppliers who indicate a quantity of 0 for irrelevant products, this data is also transferred.
Automation of updates:
Data is automatically updated every 10 minutes.
The script checks for new data and updates the final table.
Technical details:
Structure of the tables:
Each supplier's table has a separate sheet in the final table.
Data is collected using formulas and scripts.
Filtering and processing:
Rules are used for size conversion, removal of extra characters, and ignoring unnecessary data.
Automatic removal of rows with incorrect data is set up.
Scripts:
The script transfers data from sheets to the final table, checking for new and deleted products.
If a product disappears from the supplier's table, the final table indicates 0 in the "Quantity" field.
Advantages of the solution:
Automation: Reduced time for manual data updates.
Flexibility: Ability to add new sheets and customize processing rules.
Accuracy: Data from different sources is formatted to a unified format, facilitating further work.
Client feedback:
"Thank you very much for the work! The project was completed efficiently, quickly, and with a clear guide on what works and how! Communication is easy, quick and clear responses, and problem-solving! I am very satisfied that I chose you, I recommend you to everyone!"
Hashtags:
#GoogleSheets #Automation #DataProcessing #Scripts #Freelance #Portfolio
-
56 USD Development of a Telegram bot for managing applications and services
Bot Development
Project goal:
Creation of a Telegram bot for automating the processing of applications, providing services, and communicating with users. The bot is developed for a company that provides services in the housing and communal services sector and additional services.
Main functions of the bot:
… Main menu: Emergency situations, Payment, Order a call, Additional services, Housing equipment.
Emergency situations: The user fills out a form with the following data: Full name, address, contract number, description of the problem. After submitting the form, the user receives a message: "Your request has been recorded and will be reviewed within the working day." The application is sent to the technical chat and to the email.
Order a call: The user fills out a form: subject of the request, message, contact number, preferred time for the call. The manager receives a message in Telegram and will call the client back.
Additional services: A list of services that can be offered to users.
Housing equipment: The user selects a housing complex from the list (for example, Tetris Hall, Faina Town, etc.). For each housing complex, there is a list of products that can be managed through Google Sheets. The ability to leave a request to order a product.
Payment: The user selects the type of payment: Individual entrepreneur to individual entrepreneur or from individual entrepreneur to individual entrepreneur. Receives payment details or a payment link.
Technical details:
Development platform: The bot is developed on the SendPulse platform, which allows for quick implementation of functionality and easy integration with other services.
Database: Google Sheets is used to store data about applications, products, and services.
Automation: Applications are automatically sent to the technical chat and to the email. Automatic removal of users from the system is set up after a certain period.
Advantages of the solution:
Speed of implementation: The bot was developed in 3 days.
Ease of management: Easy to edit functionality through the SendPulse platform.
Automation: Reduced workload on managers due to automatic processing of applications.
Flexibility: Ability to add new services and products through Google Sheets.
Client feedback:
"A specialist in their field. It was a pleasure to work with them!"
Hashtags:
#TelegramBot #SendPulse #Automation #ApplicationManagement #HousingAndCommunalServices #Freelance #Portfolio
-
23 USD Integration of Google Sheets with Google Calendar for automation
Bot Development
Project goal:
Creation of an automated system for synchronizing tasks from Google Sheets to Google Calendar with reminders sent to performers and management.
Main functions:
… Integration of Google Sheets with Google Calendar: each employee has a separate sheet in the table with tasks and deadlines. Tasks are automatically transferred to the calendar, where they are displayed as events.
Sending reminders: after adding a task, a message is sent to the performer and manager's email with a reminder about the deadline.
System flexibility: the ability to add new sheets for new employees. A checkbox to select whether to add tasks to the calendar. Automatic filling of the start date after entering the task description.
Automation: the script checks the table every minute (or another interval). After processing, the system reports successful event addition and message sending.
Technical details:
Table structure: columns "Short Name", "Description", "Start Date", "End Date", "Checkbox", "Trigger".
Calendar settings: a separate calendar is created for each employee. The manager has access to all calendars.
Script logic: the script checks the table, transfers tasks to the calendar, and sends messages.
Advantages of the solution:
Time savings through automation.
Convenience of tracking tasks through separate calendars.
Flexibility for adding new employees.
Transparency for management.
Client feedback:
The project has been successfully implemented. The system has automated task management, significantly easing the workload.
Hashtags:
#GoogleSheets #GoogleCalendar #Automation #TaskManagement #Scripts #Efficiency #Freelance #Portfolio
Reviews and compliments on completed projects 13 1
Everything is great. Zakhar is a mega professional specialist. I recommend him to everyone for collaboration. He did even more than planned. Many things have been improved. ONCE AGAIN, I RECOMMEND!!!
|
23 September 2025
68 USD
Telegram bot — Car parts ransom
Everything was done efficiently and on time!
22 September 2025
113 USD
Telegram bot for store inspectors
The deadlines have increased more than twice from what was agreed upon, while the date for the bot demonstration was changed several times, but the demonstration itself never took place. There are no results, just excuses that it will be ready soon, that the project took more time than the Contractor expected, despite the fact that we communicated online twice before the start to discuss the current functionality of our existing system and talked about what is lacking. I am very disappointed with this collaboration.
3 July 2025
113 USD
Telegram bot for ordering equipment repair services, stores, and restaurants
The task was too complex, even when drafting the technical specifications. Therefore, the deadline was extended during the work process. Zakhar provided support and even a video user manual.
28 May 2025
34 USD
Creating Google Sheets
Everything is great, Zakhar did even more than I expected, I will contact you again! Thank you
22 March 2025
23 USD
Finalization of the table
Excellent result. Everything was fast, clear, high-quality, without unnecessary questions. I recommend for collaboration!
12 March 2025
34 USD
Development of an Excel file for order automation
Collaboration with Zakhar exceeded all my expectations! He is a professional in his field, diving into the project details from the very first day, understanding my needs, and offering the best solutions. The order automation he developed works flawlessly, significantly simplifying processes and saving my time.
I would like to specifically highlight his responsibility and communication, always in touch, open to revisions, and doing everything possible for the best result. The project was completed even better than I expected.
I recommend Zakhar as a top-class specialist who approaches work with understanding and professionalism. If you are looking for a reliable developer, feel free to reach out to him!
17 December 2024
34 USD
Telegram bot
A quality and quickly made Telegram bot. I recommend.
4 December 2024
11 USD
Excel help
everything is great
thank you
everything is great
thank you
everything is great
thank you
4 November 2024
56 USD
Tables
Very diligent specialist, provided his recommendations and improved the original idea.
28 October 2024
23 USD
Automatic calculation of results in the sensory laboratory
Everything is great, I recommend it.
Everything is cool, we understood each other well, the task was done well.
25 October 2024
95 USD
Described in the correspondence
Great job! Everything is done.
He even explained how my system works 🙂
He helped set up even what was not in the technical assignment!
I highly recommend !!!!!
A professional in his field!
23 October 2024
23 USD
Formation of a single Google Sheets table
Thank you very much for the work! The project was completed with quality, quickly, and with a clear guide on what works and how! Communication is easy, quick and clear responses, and problem-solving! I am very pleased that I chose you, I recommend you to everyone!
26 September 2024
23 USD
Integration of information from Google Sheets into Google Calendar with email reminders
Quick response, project delivered on time, I recommend
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Set up a Telegram bot
23 USD
|
|||||
|
Creation of a Telegram bot
90 USD
|
|||||
|
Automation through n8n or a similar solution
180 USD
|
|||||
|
Development of an AI assistant for automated call monitoring and analytics
180 USD
|
|||||
|
Automation of the sales funnel in Telegram for a construction company
282 USD
|
|||||
|
AI bot for placing orders in remote 1C
180 USD
|
|||||
|
Automation of Google Sheets (processing reports from Rozetka + formulas)
135 USD
|
|||||
|
Development of a simple Telegram bot (1 button)
23 USD
|
|||||
|
Tarot reader
180 USD
|
|||||
|
AI Call Analyzer. Analysis of incoming and outgoing calls from sales department managers.
282 USD
|