Position: Python developer/Data Analyst
Category: Python
English level: pre
Years of experience: 5


Auchan Retail Ukraine (Warhouse) Kyiv, Ukraine. Sep 2019 – Feb 2021 
I developed a process for updating the logistic characteristics of products. Connecting via API to a partner company, comparing characteristics and updating data in our database if necessary. That process corrects the creation of pallets with incorrect dimensions, such as 5 meters in height or width (standard – 0.8х1.2x2 m.)

Synevo (Medecine) Kyiv, Ukraine. Feb 2021 –  Jul 2021
I developed a process for collection of current competitor prices and locations or branches.
Created database tables and relatives with product database to compare and analyze services and locations of our company with similar data of other companies. That was done manually by an employee only for the 10 most popular services and took almost 8 hours of working days before my development and 2-3 hours for all price lists (10+ companies, 50+ cities and 600+ services in each city) with automatic visualization of prices dynamic and opening/closing of branches after my development.

Fozzy Group (Logistic) Kyiv, Ukraine. Jul 2021 – Now
I developed a process of trucks auto planning for orders from 700+stores of the country.
1. Data collection of distance between all stores. 2.Programming logic for partition orders using trucks with optimal weight type (big/small truck) for stores and minimal distance between locations for delivery. Recalculation with different coefficients and choosing the best by certain parameters. 
This process did not start in a productive server for commercial planning, but we used it for prognostication ant calculation different cases to understand how much and which trucks company needs, calculation costs of rent trucks and fuel for the next year with plan orders of stores.

Other projects
 Data collection (trucks and cargoes) in a database from different logistic aggregators (5+) and sending to subscribers by interested parameters.
 I developed Telegram bot to publish and search real estate with different parameters and locations, regular mailing with posts for subscribers, collect and publish real estate from different websites.