Position: BI Engineer
Category: SQL
English level: upper
Years of experience: 3


Project: Healthcare Project (August 2019 – Present)

Developer

Provider of payment processing and information management services to the commercial and government vehicle fleet industry

Tasks and Accomplishments: 
•	Develop, implement and optimize stored procedures and functions using T-SQL
•	Review and interpret ongoing business report requirements
•	Research required data
•	Analyze existing SQL queries for performance improvements
•	Development the reports and dashboards by using SSRS
•	SSIS Packages development for Data Extracts
•	Bugs investigation and tracking.
•	Microsoft BizTalk Server 2010/2020, applications developing and administration
•	Biztalk: Experience creating message schemas and mapping message transformations

Tools, Environment, Languages and Technologies: Biztalk, TFS, SQL Server Management Studio, SSIS, SSRS


Training: BI\ETL (April 2019 – August 2019)

Trainee

Project overview:
The training includes a theoretical and practical parts. The main goals of the training are:
•	Acquaintance with BI\DWH\ETL processes; 
•	Acquisition of theoretical and practical knowledge in the creation of documentation for testing (STTs, Test Plan, Test Cases);
•	Development of test scripts and procedures for different types of ETL Testing;
•	Detailed exploration of the different approaches to the ETL testing;
•	Consideration of bug’s nature and behavior in the ETL process and ways for investigation and tracking it.

Responsibilities:
•	Designing of data model;
•	Designing of test plan / test strategy;
•	Creating Source to Target Mappings documents;
•	Load Data from Source to Target;
•	Development of test cases and test scripts, procedures for automated testing;
•	Development the reports and dashboards by using Power BI;
•	Bugs investigation and tracking.

Tools and environment: MS SQL Server, Visual Studio, Enterprise Architect, Microsoft Power BI
Languages and Technologies: Transact-SQL.

Project: Insurance Project (October 2018 – April 2019)

Software Quality Engineer

Professional insurance company providing specialist insurance services to businesses in all over the world. Worked as  RDBMS specialist on client’s  platform utilizing  SQL Server 2008/2012.
 
Tasks and Accomplishments: 
•	Helping with the validation of changes ensuring that the data remains intact 
•	Supporting development in testing a series of changes to deliver functional and performance improvements.
•	ETL testing
Иностранный гражданин. Проживаю и работаю в Варшаве. Есть украинское ИП. Могу работать удаленно, могу через офис в Польше