Position: Data Engineer
Category: Data Engineer
English level: intermediate
Years of experience: 2


I have experience:
• deep understanding of business processes in a wide range of industries (Oil and Gas, Pharmaceutical market, Retail, Logistics, Human Resources, Tourism);
• creating data pipelines as base for solving problems with right data;
• outstanding problem solving, analytical and self-management skills, ability to work in a team as well as independently;
• strong understanding of Agile methodologies (Scrum and Kanban).

Python 3:
- Creating ETL pipelines with Prefect workflow management system;
- Pandas, Dask: dataframes manipulating, load data from/to csv, json, sql; pivot and  unpivot tables;
- Matplotlib and Plotly: analyzing data with different types of charts.
- SQLAlchemy (for PostgreSQL), SQLite3: select, update, create tables and views;
- RegEx: applying regex for find patterns and clearing raw data with drugs names.
- Atoti: used multi-dimensional analysis with OLAP cubes and created dashboards.

GIT Bash: creating and maintaining git-repositories for all my ETL projects.

Jupyter Lab (Notebooks): writing draft versions of ETL pipelines. 

DBeaver: DDL, DML, DQL.

CI/CD: Jira, GitHub.

PowerBI: creating dashboards.

Microsoft SSMS 18, T-SQL:
- studied SQL Query, DDL/DML/DQL;
- creating and filling the tables;
- creating views;
- constructing triggers and creating store procedures;
- working with XML, JSON ans CSV data-types;
- got practice with SQL partitions in database.
Introduction to Business Intelligence and Data Warehouse:
- Created Date Dimension table (Python, SQL).

SSIS:
- studied ETL Processing with SSIS;
- created solution with few packages for ETL data from/to database, flat files, Excel file.
Studied basic course about Shell, Spark, Hadoop and Hive intro:
- developed few scripts for simple ETL pipeline;
- practiced using Databricks Platform.
Key facts about me:
• have solid math and computer science background;
• take motivational, performance driven attitude;
• focus on creating state-of-the-art ways to connect businesses with customers, easily and with outstanding results;
• keep up-to-date with the latest trends in computer science;
• constantly learn how to use advanced technologies at their best.

I want to work in the team, where my computer skill, analytical and presentation skills will be useful and that my knowledge and experience in the enterprise projects will bring a great benefit to the company.