Position: DB/BI/SQL Developer
Category: Data Engineer
English level: intermediate
Years of experience: 6

1 project with development of WEB-reporting platform(using SQL,HTML,CSS,Javascript) for quality control department of call-centre;

3 projects with DWH(design DB structure using T-SQL)+ MS SSIS(ETL-processing)+MS SSAS(OLAP-cubes with MOLAP storage) for sales department of fmcg-company.

1 project with development of system for calculation and analysis taxes for transactions with securities(stocks, bonds, options etc)(using SAP HANA) for One of Big Four.

Certifications:
Exam 70-461: Querying Microsoft SQL Server 2012/2014, Microsoft, March 2017 - current time.
MCP: Microsoft Certified Professional, Microsoft, March 2017 - current time.
• Strong skills in T-SQL development: queries, query optimization, dynamic queries, partitioned views, table partitioning, table and query hints, cursors, views, stored procedures, views, functions, triggers, jobs.
• MS SQL Server Stack: SSIS, SSAS(MOLAP storage, active usage of MDX), SSRS.
• Usage of SQL Database Projects in Visual Studio for db version control 
• SAP HANA(SQLScript development): queries, query optimization, catalog views, stored procedures, functions, information views
• Experience with MySQL 5.0+:queries, query optimization, views, stored procedures, functions, backups.
• Pivot tables, strong skills in applying of excel - functions in analysis of data;
• VBA development: macros and functions.