Volodymyr Paiuk
Offer Volodymyr work on your next project.
Rating
Language proficiency level
Skills and abilities
Programming
Services
Mobile development
Portfolio
-
Dashboard for the enterprise
Enterprise Resource Planning (ERP)Data collection using #PowerQuery, linking tables with #PowerPivot, calculating indicators, and displaying them graphically and interactively in #Excel.
-
InformationFromCAO
Python#web scraping of the site, and matching data with database #sqlite3 (the database is formed by uploading #csv files). Displaying the result on a web page.
-
Movement of material in warehouses
PythonIdentification of problematic materials in warehouses based on material movements.
The program interface is made in Excel, and commands are transmitted to an exe written in Python, with the results exported back to the same Excel.
Working principle: uploading CSV files to a database, processing and identifying problematic materials based on defined criteria, exporting information to Excel in tables and charts.
-
Blind
Desktop AppsProgram for determining all possible options for plugging connectors based on the drawing. Upload a txt drawing and get all possible options for plugging each connector with information for further work and embedding into master data.
The images show a fragment of the input data and the result.
-
Efficiency
Web ProgrammingProgram for visualizing employee performance in the production segment.
Principles of the program: data collection from various sources (SQL, csv, txt), recording into a database, determining employee and team performance, and generating various reports for management.
-
AdminWPA
Web ProgrammingProgram for visualizing work on the production segment.
Created to prevent production downtime and enable quick response to problematic situations.
Working principles: collecting information from various data sources (SQL database, periodic reading of reports in csv format), processing information, matching with data from the admin panel, and recording into the database. Determining the amount of work in the system, identifying priority orders, overdue, double orders, and production metrics.
-
Better
Desktop AppsModeling the process of forming the order of production modules for the cable network according to the customer's order, and checking the master data for correctness of the order according to the drawing.
The main goal of the program is to verify the engineer's work based on real orders and information from the drawing and the engineer's matrix.
How the program works: we load csv files into the program: harnesses (information from the customer), Virtual (master data created by the engineer), Internal (master data created by the engineer), wirelist (information from the drawing), wires_in_prod_mod (information from the engineer's matrix). After that, the program processes the data and provides information about production modules for cable networks based on the engineer's master data, as well as matches data with the engineer's matrix and drawing, and checks for errors in the master data, as well as verifies the generation of production modules for errors.