Andrii

Andrii Mamchych | [відкрити контакти](див. вище в блоці «контактна інформація») | [відкрити контакти](див. вище в блоці «контактна інформація»)

SUMMARY
Software Engineering Student at LNTU specializing in Data Analysis, SQL Database
Architecture, and Data Processing with Python. Experienced in building end-to-end
data pipelines: automating web and social media data extraction (Telegram API, Web
Scraping), cleaning raw datasets using Pandas/NumPy, and modeling product,
financial, and marketing metrics. Proficient in PostgreSQL, MySQL, and exploratory
data visualization. Fluent in English (B2).

PRACTICAL EXPERIENCE
Freelance Data & Web Analyst | Self-Employed | Dec 2024 – Present
Data Pipeline & Scraping Automation: Built Python scripts (Telegram API,
BeautifulSoup) to automate data extraction from 20+ websites and Telegram
channels, processing structured datasets (10k+ records) for engagement
analytics.
Product Metrics & Funnel Analysis: Modeled core Unit Economics indicators
(CAC, LTV, Retention Rate, Churn Rate) and analyzed user conversion funnels to
identify drop-off points in user acquisition.
Database Management & SQL Querying: Designed relational database
schemas (PostgreSQL, MySQL); wrote SQL queries using JOINs, window
functions, and CTEs to aggregate dynamic analytical data.
Data Processing & Visualization: Performed data cleaning, missing value
handling, and Exploratory Data Analysis (EDA) on raw datasets using Pandas
and NumPy; created visual dashboards in Matplotlib and MS Excel.
Web & API Integration: Connected analytical Python modules with web
services via REST APIs and managed project codebases using Git/GitHub.

EDUCATION & ACADEMIC BACKGROUND
Bachelor in Software Engineering | Lutsk National Technical University | (Ukraine,
Sep 2024 – Expected 2028)
Applied Projects: Developed algorithmic scripts for automated web scraping
and designed normalized PostgreSQL databases for analytical data storage.

SKILLS & COMPETENCIES
Product & SaaS Economics: Unit Metrics, LTV, CAC, Retention Rate, Churn
Rate, ARPU, MRR, ARR.
Marketing & Media Analytics: Conversion Funnels, ROI, ROMI, CTR, CPM, ER,
ERR (Engagement Rate by Reach), Google Analytics (GA4), TGStat.
Databases & SQL: PostgreSQL, MySQL, Relational Database Design, SQL Query
Optimization, Data Modeling.
Programming & Tools: Python (Pandas, NumPy, Matplotlib, BeautifulSoup),
Git/GitHub, REST APIs, MS Excel (Pivot Tables, Advanced Formulas).
Languages: English — Upper-Intermediate (B2), Ukrainian — Native.