Skills

  • HTML/CSS 
  • Разработка ПО
  • Linux
  • Oracle
    10
  • React/Redux
    1
  • Pl/SQL
    10
  • Javascript
    2
  • PostgreSql
    4
  • Git
    7

Experience

Роман Костенко

Work experience
  • Project: PostgreSQL on-prem migration to GCP
  • DevOps: 2 members, PM
  • Project Role: DB developer
  • Tasks performed:
  • • Created or altered DB objects (types, views, functions, tables, triggers, procedures);
  • • Migrated DB objects from Oracle DB to Postgresql what involved checks of scripts that were generated in automatic mode and requiered manual intervention and fix;
  • • Helped to set up database connection for teammates with the usage of Docker;
  • • Helped teammates with SQL related tasks;
  • • Dealt with the project documentation (processes description, technical requirements, etc.);
  • • Deep investigations for the PostgreSQL usage on Managed and not Manged instances on GCP;
  • Environment:
  • • PostgreSQL 11
  • • DBeaver - Jira - Bitbucket - Confluence - VisualStudio Code - Docker - Git - Oracle-Ora2PG
  • • - PostgreSQL - Oracle - GCP - CI/CD

Роман Костенко

Work experience
  • Project: Developing liquidity stress testing reporting system for Treasury
  • Project Role: project development tasks which are related to Oracle DB
  • Tasks performed:
  • • Data analysis, migration, validation, cleansing, and verification;
  • • Develop, and maintain Oracle databases;
  • • Query optimization and performance tuning;
  • • Provide support for product related issues in production with appropriate urgency;
  • • Map Import/Export Files to source system data. Map source data to data warehouse models;
  • • Integrating with CI/CD (Jenkins, TeamCity);
  • • Develop, test, and debug new functionality and maintain/enhance existing functionality in us-ing SQL, PL/SQL;
  • • Develop and maintain ETL scripts and workflows, SQL queries, Agent schedules, etc. using SVN or GIT for version control;
  • • Scrum methodology
  • Environment:
  • • Oracle DB 11.2g
  • • PL/SQL developer, Jira, Git, TeamCity, Bitbucket, Confluence, SQL Plus, Oracle BI, Informatica.
  • • - DWH - ETL - Oracle - PL/SQL - Oracle BI - Agile - Oracle partitioning - Datamart

Роман Костенко

Work experience
  • Project: Implementation DR(Data reconciliation) /DQ(Data quality) logic during data migartion
  • Project Role: DWH/ETL Oracle developer
  • Tasks performed:
  • • participation in development, integration and data processing;
  • • implementation DR(Data reconciliation) /DQ(Data quality) logic during data migartion;
  • • debug new functionality and maintain/enhance existing functionality in using SQL, PL/SQL;
  • • maintain database performanceby completing SQL/PL/sql performance;
  • Environment:
  • • Oracle 11.2G
  • • - Toad for Oracle - PL/SQL developer - Jira/Confluence - SVN Tortoise - SQL plus - SQL loader - Informatica PowerCenter
  • • - Oracle - PL/SQL - Data integration - ETL - DWH - Data quality/Data reconcilation

Роман Костенко

Work experience
  • Project: Banking Day Functionality development
  • Project Role: implementation business logic on Oracle side
  • Tasks performed:
  • • Development and optimization of queries;
  • • PL/SQL development (collections, types, packages, etc…);
  • • Development and implementation of a functional banking day:
  • • 1. cash management;
  • • 2. cash operations;
  • • 3. DAM (Dual account management);
  • • 4. letters of credit;
  • • Support and bug fixes;
  • • Optimization of existing code;
  • • Performance tuning;
  • Environment:
  • • Oracle DB 11.2g
  • • -Toad for Oracle - PL/SQL developer - Operday -own development is based on Delphi - Jira - Mantis (bug tracker)
  • • - Oracle - PL/SQL - OLTP

Роман Костенко

Work experience
  • Project: Creating management reports. Development of data quality management system using mathematical methods of processing and the forecasting
  • Project Role: responsible for the development of BI reporting and DQ managment system
  • Tasks performed:
  • • Management reporting development via SAP BO;
  • • Data modeling (tables, indexes, FK);
  • • Performance tuning and SQL queries optimization;
  • • PL/SQL development (collections, types, packages, etc…);
  • • Administration SAP BO (roles, privileges, users, data access);
  • • Support and development of Business Objects reports in DWH;
  • • Development of data quality management system
  • • using mathematical methods of processing and the forecasting;
  • Environment:
  • • Oracle DB 11g 2
  • • - PL/SQL developer - SAP BO - SQL plus/ SQL Loader - Oracle for Toad - Customized soft - Jira - Tortoise SVN
  • • - Oracle - BI - DWH/ETL - Oracle UTL_HTTP

Роман Костенко

Work experience
  • Full-stack developer  at   SDFMU
  • Project: implementation and support of technology to synchronize the visualization of Structured Information Systems of data sources (databases ORACLE) to ensure the efficient analysis of large amounts of data.
  • Project Role: product implementation in accordiance with requirements and prode release preparation
  • Tasks performed:
  • • develop modern application with high-quality UI and performance;
  • • development of web applications (JavaScript, AJAX, JQuery, HTML, CSS, ASP.NET,ADO.NET)
  • • creating database objects (tables, views, triggers, stored procedures, indexes);
  • • Development and optimization of queries;
  • • PL/SQL development (collections, types, packages, etc…);
  • • the creation and delivery roles and privileges for users to access data;
  • • support and development of MicroStrategy reports in the analytical data processing system;
  • • creating reports in Crystal Reports;
  • • software of database servers and application software
  • Environment:
  • • Oracle 11 g 2
  • • - Visual Studio+ Resharper - Tortoise SVN - Customized soft - Microstrategy BI - Specific Analytics tools - PL/SQL developer - Toad for Oracle
  • • - .NET - C# - ADO.NET - Oracle/PL/SQL - BI - JS+JQuery+AJAX - CSS+HTML

Роман Костенко

Work experience
  • Project: apps development for their own projects
  • Project Role: app development
  • Tasks performed:
  • • Delphi design, programming, testing
  • • development, maintainance and tuning on DB side
  • • data architecture
  • • SQL tuning
  • • business logic implementation
  • • after release support
  • Environment:
  • • InterBase FIREBIRD 8.0
  • • - Embarcadero Delphi - own soft - IBExpert
  • • - InterBase DBMS - Delphi - Fast Report - OLTP - RDBMS

Related persons

Valeriia KoretskayaTechnical Recruiter at artk.ai