Position: System Analyst
Category: Business Analyst
English level: fluent
Years of experience: 1

Working as a system analyst, I have already created some complex designs of the back-end Happy Day Scenarios and front-end visual components. I have gained a lot of experience in web-development and I am looking forward to develop my skills even more.
I’m currently working as a system analyst: I design API, database schemas, relations between them, back-end Happy Day Scenarios and alternative flows, front-end visual components.
I also already have three pet-projects: Credit Card Churn Prediction Exploratory Analysis (Excel), COVID19 Data Analysis (SQL) and COVID19 Data Analysis (Tableau). 
In the first project I used a dataset "Credit Card Churn Prediction" from Kaggle to perform Exploratory Data Analysis. I created some new columns with the use of Excel functions to bin age data and to change "M" and "F" letters to "Male" and "Female" respectively in the column with the gender data. After that I put the data into pivot tables and created some charts and graphs with the use of these pivot tables. After that I created a dashboard, where I put all of the created earlier charts and graphs. I also added slicers to the dashboard, so that you could gain even better insights into the data.
Second project is my SQL portfolio project. I used the data on COVID19 from "Our world in data" website. The DBMS I used for
the project is Microsoft SQL Server. In the project I performed data analysis using simple SQL statements (SELECT, GROUP BY, WHERE etc.) as well as more advanced techniques such as subqueries, joins, window functions, CTE and temporary tables. I have put a lot of the explanatory comments in the file with all the
queries, so that anyone could walk through with deeper understanding what I am doing in a particular query. I have also
created some views that I am going to use in another project for my portfolio, where I am going to create some visualizations with Tableau. I have also made my code as clean as possible, so that anyone could read it easily.
In the third project I used some of the views that I create in the second project to make some visualizations on the COVID19 data and combine this visualizations into a dashboard.