Alina Tkachenko Email & Phone Number

Victoria, Bc, Ca

Teaching Assistant for CSC 370: Databases

Odesa, Ukraine

Collaborated with a diverse clientele to diagnose and resolve data-related challenges.Delivered comprehensive data management strategies, enhanced by advanced database architecture expertise and effective query optimization techniques.

Odesa, Ukraine

Managed and optimized Data Warehousing: Took the lead in optimizing data warehousing processes, which involved handling large-scale datasets and ensuring quick and efficient data retrieval and analysis.Query optimization in Clickhouse: Delved deep into Clickhouse (OLAP) to optimize queries, significantly enhancing the efficiency and speed of data operations.Sentiment analysis: Spearheaded sentiment and semantic analysis tasks using cutting-edge NLP tools like spaCy and Gensim. Conducted user review sentiment analysis to guide marketing strategies and improve customer satisfaction.Marketing analysis: Applied machine learning methods for customer segmentation and clustering, which helped in targeted marketing and increased customer engagement.

Odesa, Ukraine

Product demand forecasting: Championed the forecasting division, where I developed and deployed machine learning models focusing on predicting product demands. This led to more accurate inventory management and reduced overhead costs.Data cleaning and preparation: Utilized a combination of SQL/T-SQL and R to clean, process, and prepare data for analysis, ensuring the highest quality of data input for forecasting models.Time Series Analysis: Leveraged advanced statistical techniques and NLP for an in-depth analysis of time series data, successfully predicting market trends and seasonality effects with high accuracy.Collaboration with Cross-Functional Teams: Worked closely with the marketing and sales teams to apply data-driven insights into practical business strategies, particularly in the areas of sales analytics and product demand.

Odessa

PostgreSQL Administration Training: Engaged in rigorous training focused on PostgreSQL administration, with an emphasis on database security and reliability.Database Architecture: Played a pivotal role in redefining the database architecture, ensuring it was scalable and efficient for future growth.Query Optimization: Specialized in optimizing SQL queries to expedite data operations, reducing server load and improving user experience.

Odesa, Ukraine

Data Processing: Entrusted with the task of processing large datasets, leveraging the capabilities of MS SQL and T-SQL for seamless database management.Python-Backed Solutions: Collaborated with a team of developers to integrate Python-backed solutions into the existing data pipeline, enhancing both accuracy and reliability.Cross-Functional Collaboration: Worked closely with academic researchers and faculty to ensure the data solutions met the specific needs of educational projects.

Master Of Science - Ms, Computer Science

Courses: • Data mining • Systems for massive datasets

Бакалавр, Компьютерные Технологии/Технологии Компьютерных Систем, 4.0

Diploma with honour

Education record