Віолетта

Violetta Tsyrkot
DB/BI developer
Phone: [відкрити контакти](див. вище в блоці «контактна інформація»)
Email: [відкрити контакти](див. вище в блоці «контактна інформація»)
https://bit.ly/itagrad LinkedIn LinkedIN

Summary of • I am highly motivated to learn, grow and succeed in the company;
Qualifications • I consider myself a team player who takes responsibility when
necessary.

Skills
Programming Languages Development Tools
- SQL/TSQL - SSMS
- Python - PyCharm
RDBMS - MySQL Workbench
- MSSQL - Visual Studio
- MySQL - PostgreSQL
- PostgreSQL Data visualization Tools
Methodologies - Power BI
- Scrum, Agile Soft Skills
Tracking Tools - Honest
- Jira - Team Player
- Confluence - Responsible
Version Control System
- Git

Experience / IT
January 2023 – present
related Eleks - Product implementation analyst (DB Developer)
educational • Worked with Microsoft SQL Server: creating database objects, modifying
practice data structures, and maintaining data integrity
• Actively applied hands-on SQL skills to build reports and optimize queries
for performance and readability
• Investigated and resolved issues related to changes in code or system
behavior
 • For generating a large number of reports, worked with various types of
JOINs (INNER, LEFT, RIGHT, FULL), understanding their differences and the
order of SQL query execution, as well as separating filtering logic between
WHERE and HAVING. Also applied window functions such as
ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG() for analytics and
data processing by groups, and aggregate functions like COUNT(), SUM(),
AVG(), MAX(), MIN() for calculating statistical data
• Created nested queries to combine data from multiple tables, using foreign
keys and complex relationships
• Analyzed incoming requests from users and formulated optimal, reasoned
solutions based on data
• Supported the implementation of changes to the system, ensuring
maintenance and documentation

September 2025 – October 2025
• PROMETHEUS certificate “Програмування для всіх: основи Python”

March 2022 - July 2022 SoftServe
• SoftServe IT Academy (LV-686DB) – certificate
Project Description: Created and populated the database for online “AppleStore”
that allows customers to buy all main categories of Apple products. Project role:
Trainee DB\BI developer. Responsibilities: -Scrum Master; - Relational database
design; -Data generation; -Creating stored procedures (Get, Upsert, with JSON and
Dynamic sql), triggers, views, functions; - development testing; -ETL process; -SSIS
package; -Power BI Reports. Project Team Size: 12 team members

January 2022 - February 2022 SoftServe
Database club (DB club Lv2)
September 2021 – November 2021 ITVDN
https://itvdn.com/ru/video/ssms_tsql
• video course Transact SQL
June 2021 EDERA_BBF
Основи веб-розробки (HTML, CSS, JavaScript) | EdEra (ed-era.com)
• Basics of web development (HTML, CSS, JavaScript) – certificate

Languages English (Intermediate)
Polish (Upper Intermediate)
Ukrainian (Native)

Education 2010-2015 Ivan Franko National University of L’viv
• International economics and international law faculty
(Specialist of international law)
2
Additional
education December 2021 – January 2022 SoftServe
(courses, • English Online Marathon - certificate
trainings)

Hobbies
Recreation: board games, festivals, travels, quests, trips to the
Carpathian Mountains, my children))
Reading: economic, legal, psychological literature, fiction in English

3