Position: Database Analyst
Category: SQL
English level: upper
Years of experience: 2


Work experience :
I worked for two years as an engineer in an analytics companies. Developed ETL process, imported client files, worked with metrics and dimensions in OLAP cubes, fixed bugs, created calculations, solved various interesting tasks, building reports in SSRS

Skills:
- SSMS, SSAS, SSRS
- Building indexes (rowstore, columnstore); 
- Analysis of query execution plans; 
- Detecting and fixing unwanted results of calculations, bugs; 
- Building procedures; 
- Optimizing queries; 
- Creating OLAP cubes, metrics, dimensions;
- Writing MDX queries (basic);
- Building reports and dashboards based on aggregated data from OLAP;
- Working with configuration files;
- Usage of SVN, GIT;
- Creating an ETL process from the ground up
- Report Builder
- Work with JSON and XML files

Projects:
- The subordinate tracking system. 
Providing information about workers: how much time spent at work excluding rest, late arrivals, early leaves, etc.
Used technologies: MSSQL

- Barcode generation based on given characteristics of the object.
Used technologies: MySQL

- Automated tool for database migration
Reads table metadata in MySQL and creates a corresponding query in PostgreSQL to create an identical table model. Then the data itself is moved as well.
Used technologies: MySQL, PostgreSQL, C++, Qt

- Designing high-load storage systems (educational project)
In this project, a set of experiments were conducted to study important SQL language concepts such as database normalization, optimizing SQL queries, indexes, VIEWs, temporary tables, triggers, procedures, and transactions.
Used technologies: MySQL

DB management and data analytic tool
GUI DB management and data analytic program.
Used technologies: MySQL, C++, Qt
Expect to have the opportunity for career growth. Interesting and challenging tasks. New experience