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

Oleg Dubetsky

Offer Oleg work on your next project.

Ukraine Chervonograd, Ukraine
1 month back
Available for hire available for hire
age 40 years
on the service 2 years
  • macros
  • pandas
  • Business analysis
  • python scripts
  • Excel
  • python
  • Google Sheets
  • E-commerce
  • Data Analysis
  • Automation
  • SQL
  • Rozetka
  • prom.ua
Freelancer Oleg D. — Ukraine, Chervonograd. Core skill — Python, Data Processing

Rating

Successful projects
No data
Average rating
No data
Rating
227
Python
1015 place out of 4457
Data Processing
270 place out of 1474

Language proficiency level

Українська Українська: fluent
Русский Русский: advanced
English English: elementary

Skills and abilities

Programming

Services

Portfolio


  • 7 USD

    Automated financial report for the Prom.ua store (Python)

    Data Processing
    Automated financial report for the Prom.ua store (Python) — example of freelancer's portfolio work in category Data Processing
    The store owner spent 3 hours a week manually reconciling sales from Prom and the Excel cost price. There was a problem understanding the actual net profit due to returns and commissions.

    Solution: A script was developed in Python (Pandas) that:

    … Automatically merges the order statement and the purchase price list.

    Filters out canceled orders.

    Calculates Net Profit and margin for each product.

    Generates a PDF dashboard with customer activity graphs.

    Result: Processing time was reduced to 1 minute. 15% of unprofitable products were identified. Stack: Python, Pandas, Matplotlib, FPDF.