Yaroslav Diachyshyn

Summary

Software Engineer with more than 25 years of experience in the IT field. Interested work with Database, Datawarehouse, ERP, CRM system, Big Data. All time dedicated to constantly improving tools and infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business. Last 2 years have focused more on Administrate role and Data Engineer, supporting database server PostgreSQL on Linux Server in AWS, MS SQL Server on Windows 2019-2022. Used PostgreSQL, MS SQL, Oracle, MySQL, JavaScript, AWS, Azure,python in different projects. Technical Skills

Programming Languages

FoxPro

HTML

C#

Java

Python

JavaScript

Node

C

Clouds

AWS

Azure

RDBMS / Database servers

Oracle

PostgreSQL

MySQL

MongoDB

MariaDB

MS SQL

Debian

Arch Linux

SQL Query

Big Data

Operating Systems

Windows

Linux

Android

VMware vSphere

Tools and Technologies

Power Bi

Pentaho Data Integration

1C

Banking, finance software

Eclipse

Tableau Desktop

Crystal Report

IntelliJ IDEA

VMware vSphere

Kafka

Hadoop

HDFS

Hive

Cassandra

Azure Databricks

Docker

Spark

Vertica

Snowflake

IDERA ER/Studio Data Architect

Page 2

Microsoft Visual Studio

PgAdmin

Dbeaver

Navicat

Jupyter Notebooks

Docker on Ubuntu and Windows 10,11

Hyper V

Active Directory

Microsoft Management Studio

Azure Data Studio

Microsoft Integration Runtime

Linux bash command line

Experience

Project name: Set of projects social networks (israelit.pro) Description: Development and maintenance of a working time accounting program Project responsibilities: Senior BI Engineer/Administrator/Data Engineer/DBA

Administrated and developed Oracle 12c database

Azure (ADF) ETL/ELT, Data Delta Lake

AWS Glue, QuickSight

Tableau

C#

Python

Microsoft Visual Studio

JavaScript

Administrated, supported and developed PostgreSQL 12.1 (Maintenance plan backup restore databases, replications master-slave)

MySQL

MongoDB

Hadoop

Spark

Cassandra

Snowflake

Vertica

Administrate and developer, supported MS SQL 2012-2019

Replication data between databases

Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2012,2016)

Creating and using SSIS packages, using SSRS, using SSAS

Finance report

Solution current task

Maintenance plan backup restore databases, replications

Virtualization on Hyper-V, VirtualBox, VMware

Page 4

Installing Windows Server, Desktop operation system and MS Office

Data Modelling tools (Studio Data Architect)

Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio, Azure Data Studio, Microsoft Integration Runtime Duration: 2 years

Period: 2020-2022

Customer: USA, Philippines, Israel,Ukraine,Armenia Project name: Set of projects fintech (www.infopulse.com) Description: Development and maintenance of a working time accounting program Project responsibilities: Senior BI Engineer/Administrator/Data Engineer

Administrated and developed Oracle 12c database

Azure (ADF) ETL/ELT

Microsoft Visual Studio

C#

Administrated, supported and developed PostgreSQL 10.1

Administrate and developer MS SQL 2012-2019

Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2012,2016)

Creating and using SSIS packages, using SSRS, using SSAS

1C Platform ERP, Trade, E-commerce

Finance report

Solution current task

Maintenance plan backup restore databases

Virtualization on Hyper-V, VirtualBox, VMware

Installing Windows Server, Desktop operation system and MS Office

Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio

Duration: 1 years

Period: 2019-2020

Customer: USA, India, Argentina, Ukraine

Project name: Set of projects construction and e-commerce sphere Description: Development and maintenance of a working time accounting program Project responsibilities: Senior BI Engineer/Administrator

Administrated and developed Oracle 12c database

Administrated, supported and developed PostgreSQL 10.1

Administrate and developer MS SQL 2012-2019

Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2012,2016)

Page 5

Creating and using SSIS packages, using SSRS, using SSAS

1C Platform ERP, Trade, E-commerce

Finance report

Solution current task

Maintenance plan backup restore databases

Virtualization on Hyper-V, VirtualBox, VMware

Installing Windows Server, Desktop operation system and MS Office

Installing Active Directory, Microsoft SQL Server, Microsoft Visual Studio

Duration: 2 years

Period: 2017-2019

Customer: UA

Project name: Distribution sphere

Description: Development of a program for accounting of working time and payment Project responsibilities: Senior BI Engineer

Administrate MS SQL 2012, 2016,Oracle 11g, PostgreSQL 9

Administrate Windows, Linux Server

Development on MS SQL 2012, 2016,Oracle 11g, PostgreSQL 9

Optimize SQL Query

Duration: 5 months

Period: 2017-2017

Customer: UA

Project name: Construction sphere of trade company Description: Development of a program for accounting of working time and payment Project responsibilities: Senior BI Engineer

Administrated,supported Windows Server 2008

Administrate CRM system of construction, Oracle 11g database

Administrate PostgreSQL 8

Write report and optimize SQL Query

Configuration on 1C based ERP system

Calculate of salary

Procurement planning

Sales proceeds

Duration: 9 months

Period: 2016-2017

Customer: UA

Project name: Set of projects distribution sphere of trade distribute company Description: Automation of financial transactions. Optimization of logistics operations.

Page 6

Project responsibilities: Senior Software Engineer

Developed module of trade and logistic

Oracle 11g database developer

Projected database table structure relation between them

Build plane optimal path shipping of goods and calculate time and viewed result on "open street" analog Google map

Depreciation calculation

Duration: 2 year

Period: 2015-2016

Customer: UA

Project name: Set of projects automotive, distribution sphere of Trade company Description: Accounting and automation of business processes. Automation of financial transactions.

Project responsibilities: BI Engineer/Administrator

Administered Linux Server, Windows Server 2008, 2012, Oracle 11g, Sybase 9.x,MS SQL 2000-2008

Maintenance plan backup restore databases

1C platform ERP system

Created reports for clients

Optimized sales

Installing Windows Desktop system and MS Office

Planned purchases

Report about work time of Employees

Duration: 8 year

Period: 2007-2015

Customer: UA

Project name: FinTech Domain of Procredit bank (https://www.procreditbank.com.ua) Description: Practical development and support ODB (operational day of bank) and the statistical reporting of National Bank of Ukraine Project responsibilities: IT System Administrator

Administrate Oracle 11g, FoxPro

Administrate MS SQL 2000

Create an application for resolved local problem

Administrate Windows 2003 Server

Manage Active Directory of Bank

Administrate Linux Server, Mail Server IBM Lotus Domino, building Page 7

network infrastructure

Training users

Maintenance plan backup restore databases

Hot swap hardware on server

Supported accounting system of Bank, installing client – banking software, Loan software CRM system, Cisco hardware, lawyers software

Configure Mini ATC

Report of deposit, credit

Installing Windows Desktop system and MS Office

Handle statistic information

Write reporting and finance economic calculation of effective loan Duration: 5 year

Period: 2002-2007

Customer: UA

Project name: FinTech Domain of Universal bank (www.universalbank.com) Description: Automation and optimization of banking operations Project responsibilities: BI Engineer/Administrator

Create on FoxPro application for resolved local problem

Administrate Novell OS

Create application for Borland Delphi to calculate Salary of Employees

Training users

Supported Database Oracle 11g

Administrate Linux Server

Supported of Bank Accounting system

Configure Client-bank system

Report of deposit, credit

Installing Windows Desktop system and MS Office

Handle statistic information

Installing supported Sybase Database

Installing Windows Desktop system and MS Office

Duration: 4 year

Period: 1998-2002

Customer: UA

Project name: Lviv railway (www.uz.gov.ua)

Description: Network projects on the Lviv railway on FoxPro 2.6, Visual FoxPro 3.0

Project responsibilities: Senior Software Engineer Page 8

Development and introduction of network projects on FoxPro 2.6, Visual FoxPro 3.0

Installing supported Sybase Database

Installing Windows Desktop system and MS Office

Installing OS/2

Create Accounting System

Training users

Finance report

Work with database FoxPro, Oracle

Resolved local task

Duration: 4 year

Period: 1994-1998

Customer: UA

Education

M. Sc. in Mathematics

Lviv State University of Ivan Franko

Graduated in 1994

Languages

English – Intermediate

Ukrainian – Native

Contact Information

Email : adz1sn@r.postjobfree.com

Mobile:+380*********

Linked: https://www.linkedin.com/in/yaroslav-diachyshyn-74882637/ Skype : Yaroslav Diachyshyn

Contact this candidate