I’ve developed a bunch of ETL processes which helped the company improve data quality. In addition, it helped the business get fresh and valid data just in seconds.I closely worked with stored procedures that already exist, but also, I created my own ones. From time to time, I had to develop SSIS packet in Visual Studio to build ETL for DWH. I’ve created multiple reports using MSSQL and PostgreSQL for the business and the company. As a result of ETL analysis in the company I managed to decrease the time load of data and got rid of garbage data or data of low quality.I’ve created two Telegram bots using Python from scratch. The idea of these bots was to get access to our database, automate creation of tasks in Jira, gather statistics at the moment (to prevent some errors and to help BI developers create dashboards based on this data) and also push up notifications for errors.For the last 3 months I’ve been working with Numpy, Pandas, Matplotlib in the company because I’m really into this and I decided to ask my boss for new opportunities. As a result, I’ve created several dashboards in the company using this stack and worked together with my colleagues to analyze the data.Because of my good English I was one of the workers who can communicate with foreign partners. Besides, because the company didn’t have a good system of documentation for developers, I created several articles in Confluence to help to systematize all the data and information.

One of my main responsibilities was administration of databases. I delt with data migration, data replication, data analysis, writing profound SQL, stored procedures and so on.We didn’t have proper ETL processes, so I and my colleagues managed to create them from scratch.Also I had some tasks connected with JavaScript. They were not so complicated, most of them were aimed at some visual effects on the website.