Kan vara tillgänglig
(Uppdaterat 2020-04-20)Power BI / SQL developer
Białystok, Polen
Flytande English
- SQL databaser
- Power BI
- 7+ års erfaring med SQL/ETL
Kompetenser (14)
SQL Server
DATABASE MODELING
Data Analysis
DATABASE
MS SQL Server
DATA CONVERSION
DATA MAPPING
SQL
Data Migration
Microsoft SQL Server
Business Intelligence
MAPPING
BI
TECHNICAL DOCUMENTATION
Sammanfattning
• Very good knowledge of SQL and T-SQL languages
• Very good knowledge of Microsoft SQL Server Integration Services (development)
• Very good knowledge of ETL processes
• Very good knowledge of Microsoft SQL Server databases
• Good knowledge of C# and .NET
• Good knowledge of Power BI, Power Apps
• Familiar with XML
• Work with Microsoft Visual Studio 2008/2010/2013/2015, SQL Server
2008/2012/2014, SQL Server Management Studio
Professionell bakgrund
2020-04 - Pågående
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
Role & Team SQL Developer, 6 persons
size
Responsibilities • Data analysis
• Creating data mapping
• SSIS package creation
• Data conversion
• Data Marts creation
• Testing data
• Analysis of issues with data
• Creating reports in SSRS
• Creating technical documentation
Time frame July 2016 - October 2018
Project name Data migration for insurance company.
Project Creating process to migrate data from data warehouse to destination MS SQL
description Server database.
Technologies Microsoft SQL Server, SSIS, T-SQL
Role & Team SQL Developer, 2 persons
size
Responsibilities • Data analysis
• Creating data mapping
1
www.softwarehut.com
• SSIS package creation
• Data conversion
• Testing data
• Analysis of issues with data
• Creating technical documentation
Time frame December 2017 - April 2018
Project name Support for application for insurance company
Project C# application to daily print insurance data.
description
Technologies Microsoft SQL Server, T-SQL, Visual Studio, C#
Role & Team SQL Developer, C# Developer, I worked alone
size
Responsibilities • Issues investigation
• Optimization of existing solution (C#)
• Designing and implementing solutions in the application (C#)
• Mapping client's XMLs into ACORD (C#)
Time frame November 2014 - May 2015
Project name Support for data feeds for insurance company
Project Data feeds for insurance company.
description
Technologies Microsoft SQL Server, SSIS, T-SQL
Role & Team SQL Developer, I worked alone
size
Responsibilities • Analysis of issues with data
• Preparation of data corrections
• Monitoring and creation data feeds
• SQL scripts development
• Optimization of existing solutions
Time frame May 2014 - October 2014
Project name Data migration for insurance company.
Project Data migration for insurance company. Creating and supporting data
description warehouse and data mart. The process migrates data from source systems to
data warehouse and data mart.
Technologies Microsoft SQL Server, SSIS, T-SQL, Visio, Git
Role & Team SQL Developer, 12 persons
size
Responsibilities • Data analysis
• Creating data mapping
• SSIS package creation
2
www.softwarehut.com
• Data conversion
• Data Marts creation
• Testing data
• Analysis of issues with data
• Creating technical documentation
Time frame May 2012 - May 2014
Akademisk bakgrund
2007-01 - 2011-01