Data Engineer Software
Resume:
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 2008-2022. Used PostgreSQL, MS SQL, Oracle, MySQL, MariaDB,JavaScript, AWS, Azure,python in different projects.
Technical Skills
Programming Languages
FoxPro
HTML
C#
Java
Python
JavaScript
Node
C
Go
T-SQL (PL/pgSQL)
Clouds
AWS
Azure
RDBMS / Database servers
Oracle
PostgreSQL
MySQL
MongoDB
MariaDB
MS SQL
SQLite
Cassandra
Operating Systems
Windows (7-11, Server 2008-2022)
Linux (Debian, ArchLinux,Ubuntu,CentOS)
FreeBSD
Solaris
IBM OS/2
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
Airflow
IDERA ER/Studio Data Architect
Big Data
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
Page 2
Experience
Project name: Short temporary projects (6-9 months) in the financial field, insurance
( as freelancer and consultant )
Description: Development and maintenance of a working time accounting program Project responsibilities: Project Architect / Senior Data Developer /Senior Data Engineer/DBA
Project Architect
Administrated and developed Oracle 12c database
Azure (ADF) ETL/ELT, Data Delta Lake
AWS Glue, QuickSight
Tableau
C#
Python
Microsoft Visual Studio
JavaScript
Administrated, installed.supported and developed PostgreSQL 12.1
(Maintenance plan backup restore databases, replications master-slave streaming and logical ) on AWS EC2
MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb Cluster), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore databases, migration databases
MariaDB (10.3, 10.6) on AWS EC2
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using PostgreSQL, MySQL, MariaDB, MS SQL and other noSQL databases
MongoDB
Hadoop
Spark
Cassandra
Snowflake
Airflow
Vertica
Administrate and developer, supported MS SQL 2012-2022
Replication data between databases
Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2017,2019)
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 3
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: 2022-2024
Customer: USA, Israel,Ukraine, Greece, Turkey, Bulgaria, Romania, Kazakhstan, Georgia Project name: Set of projects social networks (israelit.pro) Description: Development and maintenance of a working time accounting program Project responsibilities: Project Architect / Senior Data Developer /Senior Data Engineer/DBA
Project Architect
Administrated and developed Oracle 12c database
Azure (ADF) ETL/ELT, Data Delta Lake
AWS Glue, QuickSight
Tableau
C#
Python
Microsoft Visual Studio
JavaScript
Administrated, installed.supported and developed PostgreSQL 12.1
(Maintenance plan backup restore databases, replications master-slave streaming and logical ) on AWS EC2
MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb Cluster), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore databases, migration databases
MariaDB (10.3, 10.6) on AWS EC2
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using PostgreSQL, MySQL, MariaDB, MS SQL and other noSQL databases
MongoDB
Hadoop
Spark
Cassandra
Snowflake
Airflow
Vertica
Administrate and developer, supported MS SQL 2012-2022
Replication data between databases
Administrate Linux Server based on Debian, CentOS, Ubuntu, MS SQL Server (2017,2019)
Creating and using SSIS packages, using SSRS, using SSAS
Finance report
Page 4
Solution current task
Maintenance plan backup restore databases, replications
Virtualization on Hyper-V, VirtualBox, VMware
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 Database Developer/Senior BI Engineer/DBA /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
Designed, modeled, created new databases, tables, indexes and relationships between tables, described business logic using stored procedures, functions, optimized queries, helped the team solve current bugs and problems using MS SQL and HANA. 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
Page 5
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: 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
Page 6
Project name: Set of projects distribution sphere of trade distribute company Description: Automation of financial transactions. Optimization of logistics operations.
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
Page 7
Administrate Linux Server, Mail Server IBM Lotus Domino, building 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 : *******@*****.***
Mobile:+380*********
Linked: https://www.linkedin.com/in/yaroslav-diachyshyn-74882637/ Skype : Yaroslav Diachyshyn
Contact this candidate