Oleksandr Ivanchuk
Offer Oleksandr work on your next project.
Rating
Language proficiency level
Skills and abilities
Programming
Administration
Portfolio
-
Automated currency exchange management system
Enterprise Resource Planning (ERP)It was necessary to create a reliable and fast system for an online exchange that would automatically monitor and set competitive currency rates. Manual updates of rates were slow, inaccurate, and did not allow for prompt responses to market changes.
An automatic parser was created that regularly (at certain intervals) retrieves current rates from BestChange via API.
… Based on the obtained rates and the specified position (or position based on the required rate), final rates for each pair are automatically calculated and updated in the SQL database, and an XML file with the data is generated, which is used on the website.
An interactive Telegram bot (aiogram) was developed that allows operators to:
Quickly change the "position" (relative rate) for individual pairs.
Use group mode for simultaneous setting of positions or positions based on the required rate for several currency groups.
Create and edit groups directly through the bot interface.
The system is deployed on a Linux server via Docker using CI/CD to ensure constant availability and seamless updates.
Automatic updates of rates based on the position have been provided, allowing the exchange to quickly adapt to market changes and maintain competitiveness.
The system operates on a continuous basis, automatically generating the necessary XML file with rates for integration with the main exchange platforms.
The Telegram bot provided operators with a convenient mobile tool for managing critical parameters (position, groups) without the need for access to the admin panel.
-
Monitoring of progress and task analytics
Data ParsingA quick, automated way to monitor the status of work and the number of uploaded files across all active ("In Progress") tasks on the platform for certain companies was needed.
An autonomous Python script was developed that uses Selenium and Beautiful Soup for:
… Navigating a complex tabular structure.
Identifying and filtering only those cells (Cell) that have the status "In Progress" for certain companies.
Clicking into each found cell for in-depth parsing of information using bs4 about the number of uploaded photos for each issue.
Generating a detailed report that contains the exact number of uploaded photos for each task, as well as complete contextual information (block, floor, side, etc.) for accurate identification of issues.
As a result, daily, automated reporting on work progress was provided. The client received clear data on the current status of task execution without the need for manual checks, allowing for immediate identification of "bottlenecks" and resource management.
-
Automated photo upload system
Enterprise Resource Planning (ERP)An autonomous Python system has been developed, designed to completely replace the user's routine work during bulk content uploads to the website.
Key issue: High time consumption and frequent human errors due to the need for manual navigation through the complex site structure and file uploads.
… The script provides reliable, step-by-step automation. The script receives input data (for searching and identifying tasks) from a local source (e.g., TXT) and forms navigation logic based on it.
Selenium is used for:
Reliable authorization.
Navigating to the required pages.
Interacting with dynamic content and complex interface elements (which often cause problems for simple scripts).
Task execution: The script sequentially performs all necessary actions to upload photos for each task.
Using this script has led to significant improvements.
The time required to complete the work has been significantly reduced.
The frequency of human errors, which was previously a common issue, has been completely eliminated thanks to the automated process.
After the work is completed, a detailed report on the number of uploaded photos and the associated input data is automatically generated, ensuring 100% control over the process.
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Python developer for ongoing collaboration
25 USD
|
|||||
|
Python Website Automation Data Entry and Extraction with Playwright
582 USD
|
|||||
|
Website parsing
23 USD
|
|||||
|
Need a Python developer to create a Telegram bot with simple functionality.
79 USD
|
|||||
|
Telegram bot for administering a TG group and analytics
181 USD
|
|||||
|
Telegram bot
50 USD
|
|||||
|
TG bot
113 USD
|
|||||
|
Website parsing and notification in the TG channel
113 USD
|
|||||
|
Parsing the website conrad.pl into xml on a schedule
41 USD
|
|||||
|
Make minor edits to the bot
23 USD
|