Position: Data Analyst
Category: Data Analyst
English level: intermediate
Years of experience: 1


The main specialist for the development of student works
2021 - 2023

In this experience, I worked with students and helped them with laboratory work. I worked in analytical direction, performed work with Python, SQL, PowerBI, Excel, PowerQuery and others. It was quite interesting, I performed various calculations in Excel using formulas, VLOOKUP, SUMIF, SUMIFS, IF, etc. As for PowerBI, it was the creation of interactive dashboards using external data connections, from MSSQL, documents, etc. I took additional students under my mentorship, helped them with their work, taught them something new, conducted mini-courses for them on Excel and more effective use of formulas, on PowerBI, and creating beautiful visualizations.

Analyst
2022-2023
Antiquary Ukraine
In this position, I was involved in creating reports in Excel and Google Sheet. Processed reports, created summary tables and charts that helped to see where the company was lagging behind, what needed to be updated, what products to add and how to change prices. I analyzed competitors, their products, what prices they set, what they focus on. Helping colleagues was also part of my duties.

Data analyst
2023 - NOW
SAT - Logistic Company
Now I work in this company, update reports daily and automate them using Excel or PowerBI. I developed 4 interactive dashboards in PowerBI that are used in the company. He added new ideas that had not been used before. I constantly work on projects that require knowledge of MS SQL. In this job, I had experience using AppSheet to create an app with some tracking and Appscript to create a form in Excel and then connect to PowerBI.