Віталій

VITALII HATALA
Data Analyst / Data Scientist / IT Consultant
Location: Freiburg, Germany | Phone: [open contact info](look above in the "contact info" section) | Email: [open contact info](look above in the "contact info" section)
GitHub: github.com/VitaliyHatala

SUMMARY
Data Analyst and Data Scientist with expertise in SQL, Python, and data visualization tools (Power BI, Tableau). Skilled
in data analysis, project management, predictive modeling, and machine learning to generate actionable insights.
Experienced in developing interactive dashboards, supporting decision-making, and managing IT and data projects to
improve business performance.

EXPERIENCE
IT Consultant — Lubrich IT (September 2025 – Present | Freiburg, Germany)
• Collaborate with development teams and clients to define project goals and requirements.
• Manage project timelines and coordinate between departments to ensure deliverables meet quality
standards.
• Analyze business needs and propose data-driven solutions.
• Support decision-making through dashboards and performance tracking.
Sales & Financial Data Analyst (Project-based) — Freelance (June 2024 – September 2025 | Remote)
• Performed data extraction, cleaning, transformation, and validation on ~20k-row sales/financial datasets
using Python (Pandas) and SQL. Developed readable interactive dashboards in Power BI to track KPIs.
• Built machine learning models (Logistic Regression, Decision Trees, SVM) to predict customer churn with 91%
accuracy.
• Optimized SQL queries for faster data retrieval and reporting.

My Personal Projects
Financial Data Analysis
• Conducted financial analysis of major American banks from 'Yahoo' using Python (Pandas, NumPy,
Seaborn).
• Designed a Power BI dashboard to visualize stock performance trends.
• Integrated SQL queries to extract and clean data from relational databases.
Email Spam Classification & Sentiment Analysis (NLP)
• Built NLP pipeline to classify 40k–50k emails into spam/ham.
• Preprocessed text using NLTK (cleaning, tokenization, stopwords).
• Evaluated Logistic Regression, SVC, KNN, and Decision Tree. Due to class imbalance, SVC was selected as
the best-performing model, achieving the highest recall of 87%.
• Built reproducible text processing and models training for NLP classification in one place using sklearn
Pipeline.
Airbnb Berlin 2024 Data Analysis
• Conducted exploratory data analysis on Berlin Airbnb listings to uncover trends in pricing, location, and host
activity.
• Used Python (Pandas, GeoPandas, Matplotlib, Seaborn) to visualize geographical distribution, price
variations, and property availability.
• Derived insights into top-performing neighborhoods and property types to assist potential investors or
travelers.

TECHNICAL SKILLS
• Programming: Python, SQL(MySQL), Pandas, NumPy, Matplotlib, Seaborn, Scikit-Learn, TensorFlow, Flask.
• Data Visualization: Power BI, Tableau, Matplotlib, Seaborn
• Machine Learning: Logistic Regression, Decision Trees, KNN, SVM, Feature Engineering, NLP (BERT).
• Deep Learning: Neural Networks (LSTM, GRU, Conv1D, Dense, Dropout, ReLU, Softmax), Loss Functions,
Computer Vision (CV2, Convolution2D, MaxPooling2D, TensorFlow, Keras)
• Tools & Technologies: Docker, Jupyter Notebook, Git, Excel (Pivot Tables, VLOOKUP, HLOOKUP,
INDEX+MATCH).
EDUCATION
BSc Systems Analysis — Franko National University, Lviv (2023)
 Focus: Statistics, Probability Theory, Mathematical Modeling and Analysis, OOP (C++, Python).
 Hands-on Practice, Real Projects (Pathfinding algorithms in complex graphs, Flask Project), and Teamwork.

CERTIFICATIONS & COURSES
• SQL for Data Analysts — Udemy (2024)
• Python for Data Analytics — Udemy (2024)
• Data Science Real Projects in Python — Udemy (2024)
• Power BI & Tableau for Data Visualization — Udemy (2025)
• NLP with Python – Udemy (2025)

LANGUAGES
English (B2), German (B2), Ukrainian (Native)