oleksandr-data
From: Ukraine
Location: Kyiv, UA
On Useme since today
About me
Reports and dashboards on top of your accounting system, without replacing it.
I connect read-only to the database behind your ERP, pull the data out at night and build what management actually asks for: sales and margin by branch, customer and product group, stock, cash and bank balances. The ERP is not loaded during working hours. I have done this for 1C/BAS; Comarch Optima, Subiekt GT and enova365 run on the same MS SQL Server, so the approach carries over.
Also: Python scrapers and price monitoring, Telegram bots, API integrations, Excel/SQL automation.
Real projects: - 13-branch distributor: nightly ERP to PostgreSQL pipeline, sales and cash picture in seconds instead of minutes - audit of a 418 GB ERP database: 39% of space reclaimable, the new server purchase was cancelled - subscription audit on 674 records proved a 12.6% loss, the client stopped paying
Fixed scope and price, delivery in stages with proof: a real run, screenshots, logs.
Portfolio
Nightly read-only pipeline from a 1C ERP (MS SQL Server) to PostgreSQL with dashboards on top: sales and margin by branch, customer and product group, cash and bank balance next to sales. Branch comparison in seconds instead of minutes.
Car market monitoring bot: 2 cars vs 200
Telegram bot that checks a car marketplace every 30-60 minutes, filters by 10 criteria, rejects accident, flood and lease history automatically and never sends a listing twice. The client reviews 1-2 cars a day instead of 200+ listings.
ERP database audit: 39% space reclaimable
Read-only audit of a 418 GB production ERP on MS SQL Server, zero downtime. Found 165 GB (39%) reclaimable without losing any business document, plus a step-by-step cleanup plan. The planned new server purchase was cancelled.