Peut être disponible
(Mis à jour 2020-04-20)SQL / Power BI-udvikler
Białystok, Polen
Courant English
- SQL Server 2008/2012/2014
- SSIS / ETL processes
- SQL / T-SQL
Compétences (14)
SQL QUERIES
SQL SERVER 2012
MICROSOFT SQL SERVER 2008
DATABASE MODELING
Microsoft SQL Server
Data Migration
SQL Server
MICROSOFT SQL SERVER 2012
SQL SERVER 2008
SQL
MS SQL Server
DATABASE
Power BI
MAPPING
Résumé
• Very good knowledge of SQL and T-SQL languages
• Very good knowledge of ETL process
• Very good knowledge of Microsoft SQL Server 2008, 2012, 2014 database
(development and tuning) and Microsoft SQL Server Integration Services
(development)
• Good knowledge of C# language
• Good knowledge of WPF
• Good knowledge of Team Foundation Server
• Work with Microsoft Visual Studio 2008/2010/2013/2015, SQL Server
2008/2012/2014, SQL Server Management Studio
• UML
Expérience professionnelle
2020-04 - Actuel
Project Migrating data from data warehouse to data mart on MS SQL Server.
description
Technologies Microsoft SQL Server, SSIS, T-SQL, Visio
Role & Team Developer, 4 persons
size
Responsibilities • Implementing process to load data into SQL Server database by using SSIS
• Writing SQL queries
• Preparing documentation
Time frame 3 months
Project name Support for rating web application for insurance company
Project C# web application to rating insurance data.
description
Technologies Microsoft SQL Server, Visual Studio, C#
Role & Team Developer, 3 persons
size
Responsibilities • Analyzing and resolving of issues with database data
• Writing SQL queries
• Mapping XML files to ACORD standards
1
www.softwarehut.com
Time frame 9 months
Project name Support for data warehouse for insurance company
Project Creating and supporting data warehouse and data mart. The process migrates
description data from source systems to data warehouse and data mart. Creating SSRS
reports.
Technologies Microsoft SQL Server, SSIS, SSRS, T-SQL, Visio, VSTS
Role & Team Developer, 6 persons
size
Responsibilities • Writing SQL queries
• Writing T-SQL procedures
• Resolving issues with existing SSIS packages
• Preparing SSRS reports
• Preparing documentation
Time frame 1 year 3 months
Project name Data migration and serialization for insurance company
Project Creating process to migrate data from source systems to destination MS SQL
description Server database and creating XML files.
Technologies Microsoft SQL Server, Visual Studio, SSIS, T-SQL, Visio, Git, VSTS
Role & Team Developer, Team Leader, 2 persons
size
Responsibilities • Writing T-SQL procedures
• Writing SQL queries
• Preparing SSIS packages
• Preparing technical and deploying documentations
• SQL queries performance tuning
• Creating C# application to serialize data
• Creating batch files
• Creating SQL Agent jobs
Time frame 2 years 7 months
Project name Data migration for insurance company
Project Creating process to migrate data from source systems to the destination MS
description SQL Server databases.
Technologies Microsoft SQL Server, SSIS, T-SQL, Visio, Git
Role & Team Developer, 16 persons
size
2
www.softwarehut.com
Responsibilities • Writing T-SQL procedures
• Writing SQL queries
• Designing and Implementing ETL processes by using SSIS
• SQL queries performance tuning
• Preparing documentation
• Creating balance reports
Time frame 2 years
LECTURES (if you gave any)
Date Event Subject
Parcours scolaire
2007-01 - 2011-01