Konstantin Ognev

<p>Participation as Data Engineer in different types of projects.<br>
Cloud DWH support (GCP)<br>
data Import&Analysis (Google BigQuery)<br>
ELT-pipelines creation\support.<br>
boosted skills in GCP, MS PowerApps, Python, PySpark, Azure Databricks</p>

<p>Participation as Data Engineer\DWH Developer in different types of projects:<br>
DWH creation\support (including "from the scratch" DWH projects)<br>
data migration projects between one DWH to another (including stand alone --> cloud migration)<br>
ELT-pipelines creation\support.<br>
ETL-pipelines creation and support (Informatica, SSIS, Matillion, AWS, Apache AirFlow, Data Building Tool (DBT), Azure Data Factory);<br>
Implementation of calculation and data extraction mechanisms (Matillion, AWS);<br>
DWH objects creation (Oracle 11g, MS SQL Server, Snowflake);<br>
Data Analysis (Oracle 11g, MS SQL Server, Snowflake);<br>
CI\CD process;<br>
Bug fixing.<br>
work in different international multi-culture teams and projects;<br>
successfully mastered the skills of the Data Engineer role;<br>
boosted skills in English Informatica, Apache AirFlow, Data Vault, Matillion, Azure Cloud, Snowflake, Power Bl.</p>

<p>Participation as DWH-developer in a project of a new corporative DWH creations and support.<br>
import data pipelines creation and support (Oracle 11g, Informatica, AirFlow);<br>
DWH objects creation (Oracle 11g);<br>
imported data analysis (Oracle 11g).<br>
more than 60% of tables was successfully created in new DWH, and data was migrated to new objects;<br>
boosted skills in Informatica, Apache AirFlow, Data Vault.</p>

<p>Participation as DWH-developer in two types of projects:<br>
development and support the existing and new ELT-functionality DWH (Oracle+Informatica);<br>
creation, development and support of DDL\DML synchronization tools between three DB’s (based on Informatica);<br>
Input data analysis also included in working with DWH.<br>
Participation in framework design;<br>
DWH development and support;<br>
SQL performance tuning;<br>
ETL mappings development (Informatica);<br>
Reverse engineering;<br>
Builds preparation;<br>
Data Analysis (Informatica TDM);<br>
Bug fixing;<br>
Code review and refactoring.<br>
there was created a new DDL\DML synchronization system from the scratch<br>
boosted skills in Informatica</p>

<p>Participation as DWH-developer in project developing and supporting existing and new functionality of new risky DWH (Oracle) according to business requirements.<br>
The data in the warehouse was loaded from different sources (RDBMS, flat files).<br>
Full circle of DWH data transferring:<br>
ETL-upload data buffer data layer<br>
loading to operation data storage (ODS)<br>
loading to detailed data layer (DDS)<br>
updating data in data marts<br>
dashboard data visualisation (Power BI).<br>
DWH framework design;<br>
DWH development and support;<br>
SQL performance tuning;<br>
ETL mappings development (SAS DI, SAS EG);<br>
Reverse engineering;<br>
CI-CD;<br>
Data analysis;<br>
Bug fixing;<br>
Code review and refactoring.<br>
a new risky DWH was started;<br>
successfully founded risky reporting system based on Power BI;<br>
boosted skills in SAS, MS Power BI.</p>

<p>Participation as DWH System analyst in DWH development project.<br>
business customer's requirements analysis and decomposition into technical tasks;<br>
Data Analysis of current system in order to describe the processes and their subsequent implementation on the new platform;<br>
data processing development and support (MS SQL SERVER (T-SQL), SSIS, ORACLE 11g (PL-SQL));<br>
business logic development (packages, stored procedures, triggers, views, functions);<br>
DWH documentation support.<br>
boosted skills in System Analysis,Analysis of business requirements.</p>

<p>Participation as DWH Developer in design, development and support of data processing systems (collection, updating, verification and structuring of information received from the customer) based on the Oracle 10g.<br>
The project aimed to support the existing and implement new DWH functionality.<br>
The data in the warehouse was loaded from different sources (different RDBMS-sources, flat-files from FTP).<br>
DWH data processing consisted of:<br>
ETL-upload data buffer data layer;<br>
loading to operation data storage (ODS);<br>
loading to detailed data layer (DDS);<br>
updating data in data marts;<br>
reporting data visualisation (SAP Business Objects).<br>
DWH development and support;<br>
SQL performance tuning;<br>
Creating data migration tools;<br>
ETL mappings development (SSIS, SQL Loader);<br>
ETL process maintenance;<br>
Creating ETL jobs to load data between Oracle DBs and between Oracle and MS SQL Server DBs;<br>
Reverse engineering;<br>
Builds preparation;<br>
Source systems data analysis;<br>
Bug fixing;<br>
Code review and refactoring;<br>
Participating in 24/7 production systems support.<br>
successfully completed 2-year data migration project from old corporate DWH to a new;<br>
boosted skills in PL-SQL, T-SQL, ETL Development, DWH Development, Data Visualisation, data migration;<br>
creating of of self-updated "from the scratch" (Oracle 10g).</p>

<p>Participation as PL-SQL Developer in the project of design, development and support of data processing systems (collection, updating, verification and structuring of information received from the customer) based on the Oracle 10g.<br>
Data Analysis;<br>
Business Analysis;<br>
Data handling (Oracle PL-SQL);<br>
Reporting data (Oracle PL-SQL);<br>
project documentation support.<br>
data processing systems was created from the scratch and then deployed on customer's side;<br>
experience of working with the project team;<br>
the skill of quickly learning a new subject area, mastering new knowledge;<br>
boosted skills in programming in PL-SQL.</p>

<p>DB administration:<br>
installation and configuration of SQL servers<br>
work with files and filegroups (DB up to 2 TB)<br>
backup/restore system configuration<br>
user access rights to the database (NT + SQL autentification)<br>
SQL-scripting<br>
ETL-tools development (SSIS)<br>
monitoring the current activity of users and processes<br>
the ability to understand someone else's code<br>
LAN administration:<br>
domain controllers configuration (user rights, data replication, group security policies, user profiles)<br>
Citrix-servers support (installation and configuration of the server and client parts)<br>
Anykey support:<br>
configuration of WS, OS and software installation<br>
network configuration of workstations,<br>
software configuration,<br>
configuration of peripheral equipment (printers, scanners, streamers).<br>
boosted skills in DB administration, SQL Server administration, T-SQL, Windows domain administration, IT support, customer support.</p>