Віталій

VITALII HATALA
Data Analyst / Junior 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, Flask.
• Data Visualization: Power BI, Tableau, Matplotlib, Seaborn
• Machine Learning: Logistic Regression, Decision Trees, KNN, SVM, Feature Engineering, NLP.
• Data Engineering & Processing: Data Extraction, Cleaning, Transformation.
• Tools & Technologies: 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)

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