Vyacheslav Lunov
Offer Vyacheslav work on your next project.
Private message
Offer work
available for hire
Rating
Successful projects
Average rating
Skills and abilities
Programming
-
Bot Development
from 9 USD for hour
Translation
Portfolio
-
271 USD Checklist for the chain of stores
Hybrid Mobile Apps
Developed a multifunctional Telegram chatbot for automating internal processes of the Delicat store chain. The main task of the project was to create a digital system of checklists and automated tracking of employees' working hours distributed across the company's individual stores.
The bot implemented a complex multi-level funnel structure for each store in the chain separately. The first stage of interaction includes automated registration of employees followed by distribution into the corresponding funnel of their store. The system collects and processes key employee data: first name, last name, phone number, and store number. After completing the registration, the user automatically gains access to a personalized main menu.
… The main menu of the chatbot includes functions:
• Start work
• End work
• Night end of work
• View worked hours for the month
• Contact technical support
The "Start work" functionality automatically records the start time of the employee's shift and launches a system of algorithms for further calculation of working hours. During the development process, complex logical scenarios, variables, and automated actions were used for accurate calculation of working time depending on the type of shift. A separate calculation formula is applied for day workers, while a more complex algorithm with an additional automatic 25% accrual to the total worked time is implemented for night shifts.
After the shift ends, all data is automatically transferred to Google Sheets, allowing centralized storage and processing of information about employees' working hours. Additionally, integration of Telegram with Google Sheets was implemented through a system of formulas and automatic data exchange. Employees can obtain information about the total number of worked hours for the month directly in Telegram at any time. Four separate formulas are used for this, which automatically process information in the tables and send the result to the chatbot.
Particular attention was paid to automating the control of work processes. The bot has implemented a reminder system for employees who forgot to end their work shift or "log out" of the system. Separate scenarios were created for both day and night workers, which minimized data loss and increased the accuracy of working time accounting.
The project also introduced a communication system with technical support. Employees can quickly seek help directly through the chatbot, significantly simplifying the completion of checklists and resolving technical issues without involving third-party services.
During the project implementation, skills in chatbot architecture design, business process automation, integration with Google Sheets, building complex logic scenarios, and working with variables and algorithms were actively utilized. Special attention was given to system stability, user convenience, and scalability of the solution for the entire store chain.
As a result, an effective tool was created for automating the company's internal processes, controlling staff working hours, optimizing communication, and simplifying employee management in a large retail chain.
The entire technical structure was developed exclusively for the work process, so there are no sales photos, etc., in the chatbot.
When creating the project, only the calculation of time was discussed, but during the subsequent work with the chatbot, the need for increased data collection from users grew, namely:
• Technical breaks of 15 minutes - 2 pcs.
• Lunch 30 minutes - 1 pc.
• The ability for managers to see their employees when they go to other stores additionally involved.
That is why the project is completed but is in the stage of refinement and requires further processing.
If readers need verification, then when entering data, please enter store number 1001.
-
23 USD Coffee shop, coffee coin + increasing sales
Hybrid Mobile Apps
During the development of this chatbot for the café, a full-fledged accounting and automation system for customer interaction was implemented. The main task of the bot was to track the number of coffee drinks consumed by each user and to create a loyalty program that motivates customers to return to the establishment. The system operates on a points accumulation principle: after each purchased coffee, the user receives one conditional "star," and after accumulating five stars, they receive the sixth coffee for free. After using the bonus, the cycle automatically starts again.
In the process of creating the bot, the logic for calculations was implemented. The system not only tracks the number of coffees to the free drink but also maintains overall statistics of all purchased drinks, including bonus coffees. This allows café owners to obtain detailed analytics regarding customer activity, the popularity of the loyalty program, and the total number of bonuses issued. A separate mechanism for automatically resetting the intermediate counter after every fifth purchase was implemented while simultaneously preserving the user's overall statistics.
… An important part of the order was the implementation of a system of variables and personalized data for each customer. For each user, the bot stores information about the number of coffees consumed, the number of bonus drinks received, and other auxiliary parameters. This enabled the implementation of automatic reminders and the creation of mass mailings to increase sales. For example, the bot can send messages to users who have not visited the café for a long time or remind the customer that only one, two, or three purchases remain until the free coffee. Such mechanisms positively impact customer engagement and stimulate repeat sales.
This project became an example of combining business process automation, marketing tools, and software logic. The chatbot not only simplifies the accounting of sales and the bonus system but also helps the establishment maintain constant contact with customers through personalized messages and advertising campaigns. As a result, a modern digital tool was created to enhance customer loyalty, automate staff work, and increase repeat sales in the café.