Position: Bi developer/ Sql developer
Category: Data Engineer
English level: upper
Years of experience: 10


Dates of employment:
Dec2021- April 2023
Job title: Etl developer
 - Sql Server, Azure Sql , ADF
- autotests  .Net ,VS/Rider

 Dec 2020 - Nov 2021
Job Title: SQL \ BI developer 
Project/Role description: Projects: 
DB Support for web application :
- tracing and turning Db requests and procedures 
- creating / optimizing reports in SSRS 
- ETL and DW support and optimization 
Stack: MSSQL 2012-2016 / Azure Sql /SSIS /SSRS 

 june 2020 - Nov 2020
Job Title: Sql developer 
Project/Role description: Projects:
all-around DB Support of application 
- Tsql stored procedures writing and performance tuning 
- Replication jobs 
- Enhancing application flow 
- maintenance jobs 
Stack MSSQL 

 Jan 2012 - 2020
Job title: Bi developer
Project/Role description: Projects:
1 BI applications related to Insurance area
. The projects based on MS SQL DW and multidimensional SSAS cubes. 
	Data analysis and reverse engineering. 
	Developing ETL using SQL and SSIS packages in Visual Studio and SSMS. Designing DW objects and Cube structure. Developing cubes and dimensions using SSAS and VS.               Custom MDX members and calculations.
       Organizing and scheduling Sql agent jobs. 
	Automation of extracts to Csv or plain text files. Creating simple reports in SSRS. Creating pivots and reports in Excel.
	Writing autotests (Sql+C#)

	2. Developing new Generic BI solution.
	Developing close to real -time BI solution on .Net framework (later migrated to . Net core). The solution consumes data from Json (stored in a DB) extracts attributes and creates needed dimensions and facts automatically. 
	The solution included:
     ETL module  - Running Sql Stored procedures to update facts and dimensions.  
	 Configuration – json based configurations allow to run several pipelines in parallel, scheduling and other options
Find some inspiration to learn new and grow, exchange experience to be not bored doing usual routine