Ms Sql Software Engineer
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 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 : *******@*****.***
Mobile:+380*********
Linked: https://www.linkedin.com/in/yaroslav-diachyshyn-74882637/ Skype : Yaroslav Diachyshyn
Contact this candidate