Looking for a job

Artem Melnychuk

@artemmelnychuk

Data analyst at MEGOGO who improved subscription reporting and uncovered payment failures, audience insights, and sales issues.

France

Message

At MEGOGO, I maintained core reporting tables and replaced manual copying with SQL exports, templates, and formulas, cutting update time by 2.5x. I analyzed subscription KPIs and viewing patterns, helping identify family audiences for new ad campaigns.

As an independent crypto markets analyst, I analyze NFT and DeFi data and build Python scripts to process on-chain and market information. I also created personal data pipelines for job postings and local events, using analysis to surface skill gaps and improve event-price coverage.

Experience

Work history, roles, and key accomplishments

Current

Independent Crypto Markets Analyst

Current

Self-employed

Jan 2021 - Present (5 years 9 months)

Analyzed NFT market data and researched DeFi protocols across Ethereum, Arbitrum, and Optimism. Built Python scripts to collect and process on-chain data, and used SQL and Excel to track portfolio performance.

Python SQL Excel NFT DeFi Ethereum Arbitrum Optimism On chain Data Market Analysis

Data analyst (project consulting)

Confidential Client

Jan 2018 - Dec 2020 (2 years 11 months)

Supported a company in digital transformation by automating 7 recurring reports from Excel/CRM/ERP, reducing manual reporting effort by 75%. Transformed raw data into strategic insights to optimize commercial and operational performance.

Excel CRM ERP Data Analysis Reporting Automation

Data analyst

MEGOGO

Nov 2016 - Aug 2017 (9 months)

Maintained core Excel reporting tables and replaced manual copying with SQL exports, cutting update time 2.5x. Used SQL to calculate subscription KPIs and built dashboards that identified family audiences, leading to new ad campaigns.

SQL Excel Google Analytics Data Analysis Dashboarding KPIs Subscription Analytics

Technical Support Specialist

RTB-system

Apr 2015 - Sep 2016 (1 year 5 months)

Analyzed traffic and ad performance data for 10+ publishers and ad networks, investigating discrepancies and fraud. Screened new websites and found bot traffic on ~30-35% of them, leading to hundreds of fraudulent placements being blocked.

Google Analytics Yandex Metrica LiveInternet Kibana Fraud Detection Data Analysis

Nice Events Tracker - personal project

Personal Project

Jan 2026 - Present (9 months)

Built a pipeline aggregating events from 7 sources, merging duplicate listings into a single dataset. Analyzed event ratings and improved price data coverage from ~9% to ~35% by adding new sources.

Python Playwright BeautifulSoup Pandas Claude Code Data Pipelines Web Scraping

Job Collector - personal project

Personal Project

Jan 2026 - Present (9 months)

Built a data pipeline collecting job postings from 5 sources with deduplication and a continuously updated dataset, cutting collection time from 3 hours to 15 minutes. Developed a rule-based text analyzer and integrated an LLM workflow for CV-to-posting fit scoring.

Python Playwright Pandas Anthropic API Claude Code Data Pipelines Web Scraping LLM