Position: Junior Data Engineer
Category: Data Engineer
English level: upper
Years of experience: 1

- Bachelor's degree on Computer Science
- Basic data engineering, data visualization skills.
- Well-acquainted with SQL, databases and DWH
- Basic knowledge of implementation of ETL solutions using on-premises
software (SSIS) and cloud-based services (AWS and GCP)
- Basic Python skills
Currently, I am studying for a master's degree at the Lviv Polytechnic at the Faculty of Computer Science.

Eleks
Juniour DB Developer
Tools: T-SQL,SVN, Postman

Epam Systems Trainee
This intership was divided into 2 parts: first,  theoretical, where I had BI basics, and second, where I use my gained knowledge to practice on Google Cloud Platform. 

Second part:
- Performed project requirements gathering and analysis
- Created a cloud function that runs when a CSV file is uploaded to the bucket and uploads the data to Google Cloud SQL
- Performed ETL process from Cloud SQL to BigQuery on Apache Airflow
- Performed data warehouse modeling
- Migrated data from SQL Server to MySQL
- Created file uploader app to GCP storage on Python
- Organized CI/CD processes

Team - 4 Developers

Database:
MySQL, MS SQL Server, BigQuery

Tools:
Cloud Storage, Cloud Function, Cloud SQL, Cloud Composer,
BigQuery, Apache Airflow, Tableu, MySQL Workbench, GitHub, Jira

Technologies:
Google Cloud Platform, Python, Pandas, SQL, Git, JSON


First part:
- Performed CRUD operations in on-premises database MS SQL Server
- Worked with different data sets using stored procedures and built-in functions.
- Carried out performance optimization: managing indexes, partitioning, execution plans analysis
- Explored different data warehouse design approaches
- Implemented ETL solutions with SSIS (building data flows using different transformations: derived column, lookup, merge)

Database:
MS SQL Server

Tools:
Microsoft SQL Server Management Studio 18, SQL Server Integration Services(SSIS), Visual Studio 2019, Jira

Technologies:
T-SQ, Python

LVIV POLYTECHNIC NATIONAL UNIVERSITY
Project:
Hospital Clinic Application

- Created client appointments application for a clinic as a degree work.
The application includes a relational database with the data of
clients and doctors, client's appointments and different
aggregated data from the application.
- Migrated specific data to an AWS Cloud. 
- Created dashboards both for individual departments and for
the entire clinic

Database:
SQLite, DynamoDB

Tools:
PyCharm, AWS Cloud (Lambda, SNS, S3, DynamoDB) , SQLlite Studio, Microsoft Power BI
Technologies	Python, SQL