Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Serhii D.

Offer Serhii work on your next project.

Ukraine Ukraine
5 days 16 hours back
Available for hire available for hire
39 Safes completed
7 months 18 days back
31 clients
on the service 3 years
  • DAX
  • PowerBI
  • Excel VBA
  • Excel Power Pivot
  • MS Power Apps
  • MS Power Query

Rating

Successful projects
100%
Average rating
10 out of 10
Rating
1231
Desktop Apps
22 place out of 498
Data Processing
53 place out of 1021
11 projects
Databases & SQL
7 projects
Data Processing
6 projects
Desktop Apps
5 projects
Data Parsing

Skills and abilities

Portfolio


  • FIFO

    Desktop Apps
    FIFO application in PowerApps
  • The Power BI Dashboard

    Data Processing
    Data analysis and the creation of a dashboard in Power BI. The data is uploaded through the API.
  • Graphics in Excel

    Data Processing
    Just different graphics in Excel made by me ever for different projects, dashboards or just for learning purposes.
  • Excel program for storage accounting

    Desktop Apps
    Excel-based program to account for the manual and electrical tools of a large construction company operating in the energy sector.
    The program allows you to track which tool, when and in what amount it was issued to the employee. Accounting of the written instrument. It allows you to quickly see where and what it is. Also, the program has the function of accounting certification and technical examination of special tools and informs the user of the approaching end date of the importance of such a certificate.
  • Excel Power Pivot data model

    Data Processing
    From the database, tables are uploaded completely different in terms of information and structure. Power Pivot has created a data model, and a number of measures have been written in the DAX language. This allows different data structures to create a single common summary table and have all the important information in one report.
  • Excel Program for Product Accounting

    Desktop Apps
    Excel-based program to account for the warehouse of a company that is engaged in making different types of wood packaging. Completed products are ordered in whole sets from the manufacturer (5 suppliers). Then in the warehouse everything is discompleted and different elements are sent to different contractors (about 15) for processing (sliping, painting, emblematization, etc.). Initially the report was in the register.

    The program allows you to account orders with the assignment of the party number. It then allows you to break the set into elements without losing the link to the party number. Watch what the contractor is and what is in the warehouse. Completion of delivery, complaint - all is also fixed in the program.

    All input data, as well as settings, are set by the user.
  • Excel program for painting

    Desktop Apps
    The Excel-based program for painting the interior details of the car. The operator on the drawing of the data from the painting camera introduces in the base all the variants of painted details as well as the number of details that the robot collapsed and married. This is the way to monitor and analyze evacuations. The program allows you to generate several types of reports. Also, each detail shows the barcode that the operator scans and the data is entered into SAP. For convenience, each detail is displayed visually, all data is also entered by the operator on the sensor monitor.
  • Excel to recognize details

    Desktop Apps
    In the manufacturing plant, the operator places the details for installation by scanning them in sequence in accordance with the customer's order. After scanning, the data is stored in the Excel file.

    The installation line operator, by extracting the details from the container, knows which components to be installed on that detail depending on the model.

    Due to the impossibility of hanging the monitor at the eye level in the app there is a voice recognition feature of the detail model. There is also the option of choosing the interface language.
  • Excel program for ordering materials from the warehouse

    Desktop Apps
    Excel-based program for ordering materials from the warehouse in the manufacturing plant.The program is installed on different workstations in the manufacturing plant creating a whole network of such files.If it is necessary to fill in the necessary materials for production, the order from the file is sent via WI-FI to the ZEBRA mobile printer, which is located in the cabin of the wire chargers or at the warehouse worker.The paid label shows the logistics staff where, what and in what amount to deliver.The logistics department has one main file in which it manages the data, i.e. the link numbers, the attachment of goods to the department, the attachment of goods to the printer (some of them) on which the label should be printed, etc.All files are connected with each other via Power Query.Thanks to this, the logistics department can connect to all files at any time and download the data about all orders.Production in turn, in this way, connects to the main file, and after pressing the button "Update logistics data" immediately updates all data from the warehouse.
  • Excel for storing palettes in storage

    Desktop Apps
    Excel-based program for a small palette storage. The program supports a screenshots scanner. When receiving the palette to the warehouse, it generates the palette number with a strip code with this number. Connect the palette to a specific location in the warehouse (automatically or manually). During the release of the palette from the warehouse removes it from the location. The receipt-transmission account of the European Palette. The stored data enables you at any time to withdraw any report, see the state of the stock and the status of all actions for the palettes that have been taken to the stock.

Reviews and compliments on completed projects 38

Quality
Professionalism
Cost
Contactability
Deadlines

Great job on the assigned task. I recommend.

27 November 2024 48 USD
Optimization and functional improvement of the Excel spreadsheet

Quality
Professionalism
Cost
Contactability
Deadlines

Working with Sergey is always a pleasure! He not only completes tasks quickly and professionally but also suggests improvements that I hadn't even considered. This time, the result exceeded my expectations — everything was done clearly, conveniently, and with attention to all the details.

In the future, I plan to turn to Sergey for the refinement of other tables, as I am confident in his skills and attention to detail. Thank you very much for your help and quality work!

Quality
Professionalism
Cost
Contactability
Deadlines

Sergey did an excellent job! Communication was easy, and all my wishes were taken into account. I really appreciate your attention to detail and patience during the work process. I will definitely reach out again if needed!

12 June 2023 24 USD
The work done

Quality
Professionalism
Cost
Contactability
Deadlines

It’s good, I’ve got it, and I’ll be.

14 March 2023 14 USD
Additional file settings

Quality
Professionalism
Cost
Contactability
Deadlines

Everything works! I will turn again.

27 February 2023 91 USD
Create 4 files from the main file

Quality
Professionalism
Cost
Contactability
Deadlines

Sergey knows his thing. professionally performed,

10 January 2023 36 USD
Excel - Data analysis task solution

Quality
Professionalism
Cost
Contactability
Deadlines

Very positive experience! I can recommend Sergey as an excellent data processing specialist in Excel.
The task was not trivial, the data is loaded from external sources, with complex logic, but it all got five with a plus!

Quality
Professionalism
Cost
Contactability
Deadlines

Everything is fine, thank you very quickly.

Quality
Professionalism
Cost
Contactability
Deadlines

A great executive. Fast introduction of the right. Everything is fast and clear. thank you.
I recommend cooperation.

8 February 2022 5 USD
From PDF to Google tables

Quality
Professionalism
Cost
Contactability
Deadlines

Excellently performed work. The most important thing is the lightning time.

4 February 2022 72 USD
Based on Excel

Quality
Professionalism
Cost
Contactability
Deadlines

Sergey did everything well, the project required some improvements because. In the process of checking I had new tasks in my head, which Sergey treated greatly and fulfilled my wishes. I recommend Sergey to perform such tasks.

22 January 2022 84 USD
Настроитъ автоматический отчет для гугл страницы (dynamic dashboard)

Quality
Professionalism
Cost
Contactability
Deadlines

A great specialist with great patience.
Everything in time and more than expected.

21 January 2022 7 USD
Create a diagram in Excel

Quality
Professionalism
Cost
Contactability
Deadlines

Everything was great, Sergey studied all the nuances and quickly completed the work!

17 January 2022 19 USD
Парсинг файла PDF

Quality
Professionalism
Cost
Contactability
Deadlines

Thank you, you did everything clearly, I didn’t even give the TK correctly, but you did everything smoothly and cool. Thank you

9 January 2022 6 USD
Удалить строки по стоп словам из списка в Notepad++ 2

Quality
Professionalism
Cost
Contactability
Deadlines

Everything is perfectly done! Thank you !

Quality
Professionalism
Cost
Contactability
Deadlines

Very pleased with cooperation. Rapid contact and quick execution of work

31 December 2021 10 USD
Formule of Measure

Quality
Professionalism
Cost
Contactability
Deadlines

The project was done very well and timely.

Quality
Professionalism
Cost
Contactability
Deadlines

Everything was done clearly, quickly, professionally. I am very pleased that I received answers to all the questions in a kind form, and reasonable advice and their implementation gave a great result!

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

Everything went well, I'll be glad to work with Sergey.

14 December 2021 60 USD
Excel Project

Quality
Professionalism
Cost
Contactability
Deadlines

Great work!
He is a professional who knows his work 100%.
Thank you !

11 December 2021 10 USD
Conversion of Excel Document

Quality
Professionalism
Cost
Contactability
Deadlines

Qualitatively and in time.

Profile deleted | Safe Safe | Response review

10 December 2021 24 USD
PC Generator from Exel (Macros)

Quality
Professionalism
Cost
Contactability
Deadlines

Thank you ! satisfied with work. The project is carried out in accordance with our deadlines and all our wishes.

29 November 2021 12 USD
The PowerBI Project

Quality
Professionalism
Cost
Contactability
Deadlines

Everything is done quickly and quality. Sergey was able to do what other performers could not do. Thank you greatly! I recommend !

15 November 2021 14 USD
Автоматизация Ексель

Quality
Professionalism
Cost
Contactability
Deadlines

Задание выполнено в сроки согласно требований. Исполнитель предложил дополнительные варианты решения задачи. Рекомендую к сотрудничеству.

11 November 2021 7 USD
Optimization of Google Sheets Excel

Quality
Professionalism
Cost
Contactability
Deadlines

The task is performed in time and in accordance with the TZ. I recommend cooperation!

4 November 2021 6 USD
Task by Excel

Quality
Professionalism
Cost
Contactability
Deadlines

Excellent performers, they did everything quickly and very well! Just about Excel! I recommend it!!The !

Profile deleted | Safe Safe | Response review

14 October 2021 5 USD
Написать 3 формулы ВПР Excel — персональный проект для Сергія Дрюкова

Quality
Professionalism
Cost
Contactability
Deadlines

Самый быстро выполненный проект на фрилансханте) Рекомендую исполнителя: шарит

30 September 2021 5 USD
Create a drop-down list of Excel

Quality
Professionalism
Cost
Contactability
Deadlines

I am very pleased with the result of Sergey’s work in Excel.
This specialist took for a complex work that is solved by macros, which was not suitable for me as the document was planned to be used in the browser version.
In general, Sergey decided this with the help of multi-page formulas, all this time he carefully explained his steps and was really involved in the process with interest.

I recommend Sergey as a responsible executive!

27 September 2021 7 USD
Excel specialist for macro writing

Quality
Professionalism
Cost
Contactability
Deadlines

Switch and good. Pleased with the work and the result.

Quality
Professionalism
Cost
Contactability
Deadlines

I am pleased with the cooperation, of course.

11 September 2021 7 USD
Модифицировать формулу EXEL

Quality
Professionalism
Cost
Contactability
Deadlines

Оперативность выполнения заказа, отзывчивость и понимание ситуации, однозначно рекомендую к работе!

Profile deleted | Personal | Response review

9 September 2021 24 USD
Города превратить в район и просклонять (510 строк)

Quality
Professionalism
Cost
Contactability
Deadlines

Класс!! Большое спасибо за работу. Очень быстро и, что главное, качественно выполнено задание. Рекомендую.

8 September 2021 7 USD
Нужно просклонять 50 названий районов по трём падежам (на ру языке) — персональный проект для Сергія Дрюкова

Quality
Professionalism
Cost
Contactability
Deadlines

Все четко и быстро. Большое спасибо.

8 September 2021 6 USD
Selection of data from Excel

Quality
Professionalism
Cost
Contactability
Deadlines

Operational execution of the order, a literary approach, clarification of things not described in the TZ, I recommend to work!

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

Everything is done quickly and efficiently, I recommend!!The !

3 September 2021 31 USD
Converter of Excel to VBA code

Quality
Professionalism
Cost
Contactability
Deadlines

Speed of performance and professionalism at a high level + responsibility, adequacy. I hope for further cooperation. A good evening. A great human thanks. Before the meeting.

Profile deleted | Safe Safe | Response review

Quality
Professionalism
Cost
Contactability
Deadlines

greatly ! Quick and quality written very necessary macros - now I'm happy!

Quality
Professionalism
Cost
Contactability
Deadlines

The project is done in time and satisfied with the work.

Activity

  Latest proposals 10
Universal Excel file for task planning and control. Personal project
Power apps aplication
272 USD
Table for production and procurement planning.
48 USD
Sign
23 USD
Work with Excel. Excel Macro
24 USD
Create a template for inventory accounting in Excel
72 USD
Creating a Google or Excel spreadsheet
119 USD
Google Sheets (add additional formulas and edits to the table) so that the indicators are summarized correctly.
84 USD
Excel spreadsheet
23 USD
Creating a Google Sheets table with formulas for row calculations and output to the dashboard
119 USD