Ukraine's #1 job service
Personal information hidden
This job seeker has chosen to hide his personal information and contact info. You can contact him using this page: https://www.work.ua/resumes/19546179/
Senior Data Engineer
- City of residence:
- Lviv
- Ready to work:
- Lviv, Remote
Contact information
Name, contacts and photo are only available to registered employers. To access the candidates' personal information, log in as an employer or sign up.
Uploaded file
The file contains 6 more pages.
Quick view versionThis resume is posted as a file. The quick view option may be worse than the original resume.
Page 1 |
Yaroslav
Diachyshyn
Summary
Software Engineer with more than 32 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
▪ C
▪ Zig
▪ Rust
▪ Go
▪ T-SQL (PL/pgSQL)
▪ FoxPro
▪ HTML
▪ C#
▪ Java
▪ Python
▪ JavaScript
▪ Node
Clouds
▪ AWS
▪ Azure
▪ GCP
RDBMS / Database servers
▪ Oracle
▪ IBM Db2
▪ PostgreSQL
▪ MySQL
▪ MongoDB
▪ MariaDB
▪ MS SQL
▪ SQLite
Page 2 |
▪ Cassandra
▪ Clickhouse
▪ ScylaDB
▪ Redis, Valkey
Operating Systems
▪ Windows (7-11, Server 2008-2025)
▪ Linux (Debian, ArchLinux,Ubuntu,CentOS)
▪ FreeBSD
▪ Solaris, AIX
▪ IBM OS/2
▪ Mac OS
▪ VMware vSphere
Tools and Technologies
▪ Power Bi
▪ Odoo
▪ Microsoft Dynamics
▪ BAF/BAS/1C
▪ Banking, finance software
▪ Eclipse
▪ Tableau Desktop
▪ Crystal Report
▪ IntelliJ IDEA
▪ VMware vSphere
▪ Kafka
▪ Hadoop
▪ HDFS
▪ Hive
▪ Cassandra
▪ Azure Databricks
▪ Docker
▪ Spark
▪ Synapse Analytics
▪ Snowflake
▪ Airflow
▪ IDERA ER/Studio Data Architect
▪ Big Data
▪ Microsoft Visual Studio
▪ PgAdmin
▪ Dbeaver
Page 3 |
▪ Navicat
▪ Looker
▪ 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: 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/Data analyst
▪ Project Architect
▪ Administrated and developed Oracle 12c database
▪ Azure (ADF) ETL/ELT, Data Delta Lake
▪ Microsoft Fabric
▪ Synapse Analytics
▪ Databricks (fintech, retail)
▪ AWS Glue, QuickSight,Snowflake
▪ GCP : Pub/Sub, Dataproc:, Cloud Composer
▪ Tableau
▪ CD/CI
▪ Kafka, ksqlDB, Apache Flink, Apache Iceberg
▪ C#
▪ Python (pySpark, polars, dbt, pandas, Pydantic, Great Expectations,
dask)
▪ Redshift
▪ Microsoft Visual Studio
▪ JavaScript
▪ Looker
▪ Spark
▪ Airflow (DAG-python), ETL/ELT pipelines built
▪ Kubernetes, docker
▪ Google Analytics 4, A/B testing
▪ Administrated, installed.supported and developed PostgreSQL 16.1
(Maintenance plan backup restore databases, replications master-slave
streaming and logical ) on AWS EC2
Page 4 |
▪ MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb
Cluster, classic master-slave), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore
databases, migration databases
▪ MariaDB (10.3, 10.6) AWS RDS, AWS EC2,AWS Amazon Aurora
▪ 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
▪ Looker
▪ Administrate and developer, supported MS SQL 2012-2022
▪ Replication data between databases
▪ Administrate Linux Server based on Debian, CentOS,Oracle,
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
vSphere & ESX install Windows, Linux, Freebsd and administration, installation, configuration,
maintenance of relevant databases ms sql, mysql, postgresql (monitoring tools, problem solving, work
optimization performance, lag replication), writing backup scripts, writing server access rules and
opening relevant ports for databases (firewall), access via ssh protocol with keys. Access to the server
via a web browser and management using lilo.
▪ 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: 3years
Period: 2022-2025
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
Page 5 |
▪ 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
▪ 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
▪ 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
Page 6 |
▪ 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
▪ 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
▪ Odoo ERP
▪ 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
Page 7 |
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
▪ Odoo ERP
▪ 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.
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
Page 8 |
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
▪ Administrate DB2v8 on AIX
▪ 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
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
Page 9 |
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
▪ 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
Page 10 |
Education
M. Sc. in Mathematics
Lviv State University of Ivan Franko
Graduated in 1994
Languages
▪ English – Intermediate
▪ Ukrainian – Native
Contact Information
Email : [open contact info ](look above in the "contact info" section)
Mobile:[open contact info ](look above in the "contact info" section)
Linked: [open contact info ](look above in the "contact info" section)
Web : https://www.yasoft.in.ua/
Telegram : @djYarko
Yaroslav
Diachyshyn
Summary
Software Engineer with more than 32 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
▪ C
▪ Zig
▪ Rust
▪ Go
▪ T-SQL (PL/pgSQL)
▪ FoxPro
▪ HTML
▪ C#
▪ Java
▪ Python
▪ JavaScript
▪ Node
Clouds
▪ AWS
▪ Azure
▪ GCP
RDBMS / Database servers
▪ Oracle
▪ IBM Db2
▪ PostgreSQL
▪ MySQL
▪ MongoDB
▪ MariaDB
▪ MS SQL
▪ SQLite
Page 2 |
▪ Cassandra
▪ Clickhouse
▪ ScylaDB
▪ Redis, Valkey
Operating Systems
▪ Windows (7-11, Server 2008-2025)
▪ Linux (Debian, ArchLinux,Ubuntu,CentOS)
▪ FreeBSD
▪ Solaris, AIX
▪ IBM OS/2
▪ Mac OS
▪ VMware vSphere
Tools and Technologies
▪ Power Bi
▪ Odoo
▪ Microsoft Dynamics
▪ BAF/BAS/1C
▪ Banking, finance software
▪ Eclipse
▪ Tableau Desktop
▪ Crystal Report
▪ IntelliJ IDEA
▪ VMware vSphere
▪ Kafka
▪ Hadoop
▪ HDFS
▪ Hive
▪ Cassandra
▪ Azure Databricks
▪ Docker
▪ Spark
▪ Synapse Analytics
▪ Snowflake
▪ Airflow
▪ IDERA ER/Studio Data Architect
▪ Big Data
▪ Microsoft Visual Studio
▪ PgAdmin
▪ Dbeaver
Page 3 |
▪ Navicat
▪ Looker
▪ 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: 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/Data analyst
▪ Project Architect
▪ Administrated and developed Oracle 12c database
▪ Azure (ADF) ETL/ELT, Data Delta Lake
▪ Microsoft Fabric
▪ Synapse Analytics
▪ Databricks (fintech, retail)
▪ AWS Glue, QuickSight,Snowflake
▪ GCP : Pub/Sub, Dataproc:, Cloud Composer
▪ Tableau
▪ CD/CI
▪ Kafka, ksqlDB, Apache Flink, Apache Iceberg
▪ C#
▪ Python (pySpark, polars, dbt, pandas, Pydantic, Great Expectations,
dask)
▪ Redshift
▪ Microsoft Visual Studio
▪ JavaScript
▪ Looker
▪ Spark
▪ Airflow (DAG-python), ETL/ELT pipelines built
▪ Kubernetes, docker
▪ Google Analytics 4, A/B testing
▪ Administrated, installed.supported and developed PostgreSQL 16.1
(Maintenance plan backup restore databases, replications master-slave
streaming and logical ) on AWS EC2
Page 4 |
▪ MySQL (5.6, 5.7,8.0 ProxySQL,replications master-slave (Percona Xtradb
Cluster, classic master-slave), developed, modeled) AWS RDS and AWS EC2, Azure backup/restore
databases, migration databases
▪ MariaDB (10.3, 10.6) AWS RDS, AWS EC2,AWS Amazon Aurora
▪ 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
▪ Looker
▪ Administrate and developer, supported MS SQL 2012-2022
▪ Replication data between databases
▪ Administrate Linux Server based on Debian, CentOS,Oracle,
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
vSphere & ESX install Windows, Linux, Freebsd and administration, installation, configuration,
maintenance of relevant databases ms sql, mysql, postgresql (monitoring tools, problem solving, work
optimization performance, lag replication), writing backup scripts, writing server access rules and
opening relevant ports for databases (firewall), access via ssh protocol with keys. Access to the server
via a web browser and management using lilo.
▪ 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: 3years
Period: 2022-2025
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
Page 5 |
▪ 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
▪ 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
▪ 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
Page 6 |
▪ 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
▪ 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
▪ Odoo ERP
▪ 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
Page 7 |
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
▪ Odoo ERP
▪ 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.
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
Page 8 |
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
▪ Administrate DB2v8 on AIX
▪ 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
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
Page 9 |
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
▪ 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
Page 10 |
Education
M. Sc. in Mathematics
Lviv State University of Ivan Franko
Graduated in 1994
Languages
▪ English – Intermediate
▪ Ukrainian – Native
Contact Information
Email : [
Mobile:[
Linked: [
Web : https://www.yasoft.in.ua/
Telegram : @djYarko
Similar candidates
-
Mechanical engineer
Remote -
Data engineer
Remote -
Qt Software Engineer
Remote -
Python Backend Engineer
Remote -
Інженер технічної підтримки, Field Service Engineer
Remote -
Провідний інженер пож. систем
45000 UAH, Lviv, Stryi