Альона

Alona Tsapenko
DATA ENGINEER
[open contact info](look above in the "contact info" section) [open contact info](look above in the "contact info" section) Germany, Leipzig GitHub LinkedIn

Telegram WhatsApp

SUMMARY
Data Engineer with strong Python and SQL skills and hands-on experience building ETL and data
processing pipelines. Experienced in web scraping, API data extraction, and transforming raw data into
structured datasets for analysis. Skilled in working with relational and NoSQL databases, writing complex
SQL queries, and building automated data workflows. Passionate about developing reliable data pipelines
and scalable data processing solutions.

SKILLS
Python Web Scraping & Data Object-Oriented Programming
Python 3.10+, Advanced Python Processing (OOP)
(Decorators, Iterators, BeautifulSoup, Scrapy, Selenium, SOLID principles, Design
Generators), Pandas; data cleaning, patterns
Asynchronous Python (asyncio, transformation, and automation
Concurrency, Parallelism), pipelines Algorithms and Data Structures
scripting for APIs, data Algorithm complexity, Arrays,
automation Development & DevOps Tools Linked Lists, Stacks, Queues,
Docker, Bash /​Shell scripting, CI/​ Hash Maps, Hash Sets
Databases CD basics, debugging
PostgreSQL, MySQL, Cybersecurity & Security
SQLiteRedis, MongoDB (basic) Version Control & Collaboration Practices
Git, GitHub; repository Secure coding principles, Basic
SQL management, code review, cryptography, Network
SQL (Joins, Aggregations, collaborative development fundamentals (TCP/​IP/​HTTP),
Window Functions) Linux and Windows system
Machine Learning/ AI (small security basics, Vulnerability
Languages projects only) awareness /​threat detection
English – Intermediate Neural Networks, Classification,
German – Intermediate Data preprocessing, AI tools
(OpenAI API)

Portfolio
Vendr Scraper⁠
Python script for collecting product data from three categories (DevOps, IT Infrastructure, Data Analytics)
and storing it in a PostgreSQL database. Implements OOP principles (SOLID, DRY, KISS), multithreading
with queues for efficient scraping, and configurable settings via .env. Demonstrates data extraction,
transformation, and storage pipelines for structured business data.
Books Scraper⁠
Python script using Playwright and multiprocessing to collect and structure book data (title, category, price,
stock, rating, image, description) from the “Books to Scrape” website. Supports configurable settings via .env
and saves results in JSON, demonstrating automated data pipelines and efficient data collection.

ArcGIS Automation⁠
Python automation project that extracts tabular data from Google Sheets, transforms it, and uploads it to
ArcGIS Online as a Hosted Feature Layer. Uses Pandas, ArcGIS API for Python, and REST API to process
attributes and coordinates, ensuring accurate mapping and deduplication. Demonstrates data
transformation, geospatial data handling, and automated pipelines.

EXPERIENCE
12/2025 – 2026 DataForest
Python Developer (Scraping) Python Developer
Technologies: Python, Async Web Scraping, lxml, asyncio, aiohttp, PostgreSQL,Git
•Developed asynchronous web scrapers for high-performance data extraction.
•Parsed and processed HTML/XML data using lxml.
•Implemented parallel data fetching to improve scraping speed and efficiency.
•Cleaned, validated, and stored scraped data in PostgreSQL databases.
•Maintained and updated scrapers in response to website structure changes.
•Collaborated with the team using Git and Agile/Scrum workflows.

EDUCATION
2022 – Present Bachelor's Degree in Cybersecurity
National University of Trade and Economics

Achievements
Winners of regional checkers and chess tournaments

Active swimmer and multiple-time competition finalist

Participant and prize-winner of Physics and Mathematics Olympiads

Consistently recognized for academic excellence

ADDITIONAL EDUCATION
Python course at Mate academy (OOP, Python, Django)⁠

Certificate Data Sience⁠

Cybersecurity course⁠

Python course at Codeacademy
CodeWars
[206 Kata Completed ]

SQL course at w3schools