Konstantin Ognev

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

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

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

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

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

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

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

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.
Data Analysis;
Business Analysis;
Data handling (Oracle PL-SQL);
Reporting data (Oracle PL-SQL);
project documentation support.
data processing systems was created from the scratch and then deployed on customer's side;
experience of working with the project team;
the skill of quickly learning a new subject area, mastering new knowledge;
boosted skills in programming in PL-SQL.

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