Aliaksei Surautsau

Constructing, maintaining and configuring schemas and processes in Informatica Master Data Management (mappings, cleansing, trust, etc.). Developing ETL processes in Informatica Cloud (Power Center). Designing and maintaining Oracle DB schemas. Administrating datasets and data qualities. Developing Oracle Apex Application for manual data quality validation and manual data merge as well as using it as a reporting tool

: Construct and maintain DWH schema for reporting and analytics purposes in MSSQL and Oracle databases. Developing ETL processes in MSSIS and Oracle (PL/SQL). Refactoring legacy code, optimizing SQL and PL/SQL code, configuring Oracle / MSSQL servers, developing and deploying SSIS packages and SSRS reports. Developing APEX application and Oracle web services using APEX listener and Oracle native webservices. Using: PL/SQL, SQL, hints, AWR, ADDM, SQL plus, TOAD, Linux, SSIS, SSRS, MSSQL, BIRT

Developing and maintaining ETL system on different platforms (Oracle and MSSIS / MSSQL); Oracle consulting (optimization, refactoring of sql statement, tuning Oracle); Developing of ETL function and architecture. Optimization / refactoring legacy SQL and PL/SQL; Tuning and performance optimization of Oracle's server (Oracle's parameters, checking of using memory / IO / parallelism by servers); Developing of reports (BIRT).

Developing and maintain ETL system, working with Oracle, SQL, PL/SQL, Reporting.

Developing the following modules: Warehouse accounting; Contract accounting; Docflow. Working with C++, MFC, STL, Oracle, SQL, PL/SQL. Refactoring legacy code.

Developing of program for calculating mechanical system's lifetime (auto, airplane, etc.). Working with Oracle, C++, STL, MFC, SQL, PL/SQL