Yelyzaveta Vainahii

A motivated and detail-oriented recent graduate with a strong foundation in computer technology, programming, and data analysis. Proficient in statistical analysis, database management, and automation technologies, seeking to leverage technical and analytical skills as a Data Analyst.

Projects:

Database Design & SQL Query Projects:

- "Notebook" Database: Designed and developed a relational database for managing personal and professional contact information. Automated birthday reminders and contact sorting using SQL queries. (Course: Database Organization)
- "Railway Ticketing System" Database: Created UML diagrams (Use Case, Class, UI Logic,Database structure), an ER diagram in MySQL Workbench, and simulated SQL queries for data analysis. (Course: Complex Systems Programming)
- "Win" Online Store Database: Designed a database in Microsoft Azure, created tables in Azure Data Studio, and developed over 50 SQL queries for data analysis using aggregation functions, JOIN, CASE,UNION, IIF function, and other SQL operations.
- "Bookstore" Online Database: Worked with SQL queries in Azure Data Studio, using a simulated database for an online bookstore.

Power BI Project:

- Data Visualization & Filtering: Developed visualizations (Overview, District Monthly, Sales for New Stores) using simulated data in Power BI Desktop.
- DAX & Calculated Fields: Created DAX measures and calculated fields in Power BI Desktop, using data from the "Win" online store and simulated weather data for analysis.

Object-Oriented Programming (Java):

- Student Management System: Developed classes (Main, Person, Schoolchild, PeopleList) in Java, utilizing constructors, private fields, getters/setters, method overloading, and statistical fields. Worked with arrays and collections for efficient data management and analysis.

Human-Computer Interface Projects (Python):

- "TKinter GUI" Project: Created a Python program with a graphical interface using TKinter, featuring buttons and actions for user interaction.
- "Healthy Eating": Developed a program to track calories and provide nutritional information and images for fruits and vegetables, including a drop-down menu and calculation button.
- Program “Car”. Includes the use of widgets (slider, Listbox, Radiobutton, Checkbutton and combobox) describing the model, number of seats in the car, color, technical contents of the car, additional functions. When collecting the characteristic data of the car, the result is displayed in a separate window. The program is written in Python in Visual Studio Code
- "Nail Chill Studio" UX/UI Prototype: The site contains five pages (Home, Services, Price List, Reviews, Contact), each page is decorated with different photos, contains text, color scheme

Computer Programming Project:

- Mathematical Operations (C++): Developed a program for solving math problems using libraries (iostream, math.h), loops, and conditional statements to process user input and display results.
- Information System (C++): A system has been created that outputs information based on the user's choices, using a switch-case structure for clear and readable code. Each option has its own block of code that ensures the correct processing of input and output of the required information.
- Array Operations (C++): Built a program that performs mathematical operations on a one-dimensional array, including multiplying elements at even indices and calculating sums between specific values.

- Matrix Operations (C++): Developed a program to process a rectangular matrix, calculating column counts with zero elements and finding the row with the longest series of identical elements.
- "Internet Order" System (Python): Created a Python program to manage online orders, using a class to store customer data and display relevant information based on user input.