Position: BI Engineer
Category: SQL
English level: upper
Years of experience: 3


03.2021 – present (BI Engineer)
The goal is to develop and support ETL core scripts for dataloading data into clients’s databases on Vertica, create and support OLAP data cubes in custom online software. Developing and customising dimensions, metrics, measures for
showing reports, creating new reports for analysis and data on the website.
Technologies: Vertica 9.x, DBeaver, MDX Studio, Custom online software

06.2021 – 09.2021 (Trainee)
The purpose of learning was:
• What is Big Data and Data Engineering and the corresponding areas of development;
• Available tools and scenarios for its use;
• Some of the most popular technologies in this area are Spark and SQL;
• How an ETL training project can be developed;
During school, I learned how to create ETL projects using Python and Spark / SQL 
technologies. I studied is illustrated with numerous examples and reinforced by the 
implementation of practical tasks, where we created the part of ETL process in several 
technologies:
- Pure Python. 
- Python as thin client and MySQL database as back end. 
- Pure python as Spark map-reduce pattern.
- Spark Core. 
- Spark Dataframe. 
- Spark SQL
Technologies: cluster of 1 NameNode and 4 DataNode on the Google Cloud Platform
(Ubuntu 18.04 LTS, Hadoop 2.10, Spark 2.4, Zeppelin Notebook)

12.2019 – 03.2021 (BI Engineer)
The goal is to develop and support ETL scripts for dataload to clients databases on Vertica, MS SQL Server, create and support OLAP data cubes in custom online
software and Visual Studio SSDT. Develop and edit dimensions, 
metrics, measures, *.xml configurations to view reports, build new reports for analysis and data on the website.
Technologies: Vertica 9.x, MS SQL Server 2016, VS SSDT 2016, DBeaver, MDX 
Studio, Custom online software