Andrii Balakin

Rating
Language proficiency level
Skills and abilities
Programming
- Content Management Systems
-
Databases & SQL
from 18 USD for hour
- Desktop Apps
- Testing & QA
- Web Programming
Services
Administration
Outsourcing & consulting
- Accounting Services
-
Client Management & CRM
from 23 USD for hour
-
Consulting
from 18 USD for hour
-
Project Management
from 23 USD for hour
Portfolio
- All works 6
- Online Stores & E-commerce 1
- Databases & SQL 1
- Project Management 1
- Client Management & CRM 3
-
299 USD Integration of Business Management and Marketing on Prom.ua
Online Stores & E-commerceIntegration of Prom.ua and Dilovod.ua
Project Description
An automated integration has been developed and implemented between the marketplace Prom.ua and the accounting system Dilovod.ua, which simplifies the management of orders, customers, and products. This integration minimizes manual labor, reduces the risk of errors, and ensures timely data updates in the system.
… Main functionality of the integration
1. Product Creation
Upon the first launch of the integration, all products from Prom.ua are automatically created in Dilovod.ua.
Key attributes are transferred: name, article, price, stock, description, etc.
Subsequently, products are not duplicated – information is updated only as needed.
2. Order Synchronization by Status
Orders are not transferred immediately, but only when their status in Prom.ua changes to one of the specified ones (for example, "reserved" or "in assembly").
When the status changes – information about the order is automatically sent to Dilovod.ua.
The complete composition of the order is transferred, including products, their quantity, price, and other details.
3. Automatic Creation or Linking of Customers
Before transferring the order to Dilovod.ua, the system checks if the customer exists in the database.
If the customer does not exist – they are automatically created with all contact details.
If the customer already exists in the database – the order is linked to the existing record.
This helps avoid customer duplication and keeps the purchase history of each one.
4. Process Optimization and Error Control
The integration includes data verification mechanisms before transfer to avoid duplications and discrepancies.
If an error occurs (for example, missing product article or incorrect status) – the order is not transferred, and the administrator receives a notification about the issue.
Logging of all actions is provided to track transferred data and correct possible errors.
Implementation Results
*Automation of order processing between Prom.ua and Dilovod.ua.
*Minimization of manual work for managers.
*Reduction of the risk of errors in data and documents.
*Quick updates of information about orders and customers.
*Improvement of sales accounting and customer base control.
-
84 USD Setting up restaurant dashboards in Google Looker Studio
Databases & SQLIt is necessary to set up analytical reports for the restaurant. Taking into account: the number of visitors, total revenue for the restaurants, for each zone of the restaurant, in amounts in %, set the ability to select dates and periods, taking into account (men, women). Compare statistics by dates and periods. Transfer statistics to the MySQL database and connect Google Looker Studio to the database and configure reports.
-
Automation of the sales process implementation of SRM
Client Management & CRMThe school has 38 representations in several cities. Implementation of the CRM system, automation of the customer registration process to drive on requests. Automation of sales processes for affiliate administrators. Building a report for the company to account for the number of students’ trips and control of the money spent.
-
The network of children’s parks
Project Managementsystematization of business. Development of the company structure. Construction and automation of the sales department of 11 regional representations in Ukraine. Create a loyalty program for customers. Development of the hydrogenation system for the company. Developing and creating official instructions for the company. Development of a management reporting system.
-
Automation of CRM sales department
Client Management & CRMSet up and install the CRM system for the company for the manufacture of gloves. Creation and setting of sales bricks. Automation of the sales process.
-
Frontremont - the room repair company
Client Management & CRMTinking the hydrogenation system and building the sales department under a system with full automation (CRM system Bitrix 24)
Reviews and compliments on completed projects 8
31 May 2024
50 USD
Integration of the website with CRM
Great job, there were nuances from both sides, but they were successfully resolved, the task was completed. Happy with the productive cooperation. We will continue working.
26 April 2024
24 USD
Salesdrive and Dilovod integration
The project is completed within the agreed deadline. Thank you to the performer.
31 January 2024
24 USD
Data visualization in Google Looker Studio
Very fast, always in contact.
We will work further.
10 January 2024
17 USD
Choose a comprehensive SRM system
A very pleasant performant. Have access to some systems so that it was possible to look at the functional. I discussed all +/ on all. Everything was clearly explained. They picked up the system for intelligent money. Thank you ! The bonus was also advised on the PNL.
27 December 2023
12 USD
Simple CRM cannabis board (analogue Trello)
Everything went quickly and well. Help in choosing the SRM and re-inventing under our needs. The result is satisfied.
15 November 2023
12 USD
You need to use CRM.
A very pleasant performant! Thank you ! Everything told, explained, demonstrated several options of CRM systems for us. They spent more time than we expected, but everything as agreed on the cost of the work. We are planning to continue to work on implementation. I recommend professionalism and speed.
9 August 2023
33 USD
Bitrix 24 boxes. Get to the open line of telegram
Great, clear and quickly done work. I highly recommend professionalism.
12 April 2023
72 USD
We need a strong Google Sheets expert.
Clear, clear, quickly and well-known. thank you
Activity
Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
---|---|---|---|---|---|
Sales funnel setup in Perfectum CRM
24 USD
|
|||||
Bitrix 24 Data migration from Xero
100 USD
|
|||||
Integration of the CRM system and selection of the most suitable one
29 USD
|
|||||
Set up CRM Perfectum
22 USD
|
|||||
Bitrix settings
18 USD
|
|||||
Selection of a contractor - development of KPIs, metrics, and dashboards in BI Bitrix24
27 USD
|
|||||
Set up Bitrix24 for a detailing salon
120 USD
|
|||||
We are looking for a specialist in CRM Bitrix24 who is familiar with the European service.
23 USD
|
|||||
Consultation on analytics capabilities in Bitrix24 - built-in + BI
55 USD
|
|||||
Implementation of CRM system
24 USD
|