Дмитро

Dmytro Liuklian
SUMMARY
Ivano-Frankivsk, Ukraine • [open contact info](look above in the "contact info" section) • [open contact info](look above in the "contact info" section) •
[open contact info](look above in the "contact info" section) • github.com/lyuklyan13
Junior Data Analyst with a background in Applied Mathematics. Proficient in SQL, Python,
Tableau to extract, cleanse, and visualize complex data sets. Knowledge of probability
theory, statistics, including mathematical statistics. Applied to projects including A/B testing,
predictive modeling. I strive to develop analytical skills and data presentation skills to
simplify reporting and help businesses make informed decisions.

DATA ANALYTICS PROJECTS
__________

Monthly Marketing Performance | Tableau

● Exploratory Data Analyses & SQL Data review, hypotheses regarding unusual
patterns in the data. Merging data tables.
● Tableau dashboard A dashboard has been created containing filters, BANs, and
charts.
● Questions Answers to key questions, assumptions regarding the dataset

Retail Banking Analytics | SQL, Python

● Applied advanced SQL queries (Window Functions) directly in PostgreSQL for
complex feature engineering, including calculating a 90-day moving average to
smooth noise in transactional data.
● Conducted A/B testing (Z-test), statistically proving that personalized email
campaigns yield a significantly higher conversion rate (13.4%) compared to
expensive telemarketing (5.2%).
● Built predictive models (Logistic Regression, Random Forest with AUC=0.70) to
forecast loan defaults, identifying the maximum number of days without activity as
the strongest risk factor.

Analysis in Sports | Python

● Hypothesis tested The main effect of different training regimens on the target
variable (800 m run time) was assessed using parametric statistical tests.
● Correlation analysis revealed a moderate negative relationship between distance
time and running technique assessment (r = -0.58), which emphasizes the
importance of technical training.
EDUCATION
__________
Vasyl Stefanyk Carpathian National University, Ivano-Frankivsk 2026
Bachelor of Applied Mathematics

CERTIFICATIONS
__________
● SKELAR IT Analytics Intensive
● DataCamp

SKILLS
__________
__________
● Programming & Databases: Python (Pandas, NumPy, Matplotlib,
Seaborn), PostgreSQL, BigQuery.
● Data Visualization & BI Tools: Tableau, Excel (Power Query, Power Pivot).
● Analytics & Methodology: Mathematical Statistics, Predictive
Modeling, A/B Testing, ETL/ELT Processes.
● Tools & Version Control: Git, GitHub, Jupyter Notebook, Visual
Studio code.
● AI & Prompt Engineering: Gemini/Claude (Prompting for
SQL optimization, etc. ), GitHub Copilot.