Віталій

Vitalii Makhaiev
​ Job position Data Scientist

Osijek, Croatia

(385) 998 511 378
[open contact info](look above in the "contact info" section) (WhatsApp, Viber)

[open contact info](look above in the "contact info" section)

Letter of recommendation bit.ly/44DY2tY
Total experience 10+ years in development, implementation, and technical support in the financial, insurance and banking areas. Expert knowledge in database design, development and optimization of data warehouses.
​ I have visas to visit the USA, Canada, United Kingdom.
Ready to relocate inside the EU.
Technical skills and technologies
Implementation and support for databases and warehouses - 15 yrs.
Development for Oracle databases, Microsoft SQL server - 10 yrs.
Reports and dashboards – 5 years
Informatica ETL - 7 yrs.
SQL Server Integration Service - 3 yrs.
Linux Systems (Red hat & Ubuntu) - 6 yrs.
Languages
Advanced level of English language. Native speaker of Ukrainian and Russian languages, Intermediate level of the German, Polish languages.
Study courses
Oracle 11 DBA (database administrator), Informatica Power Center
IT support specialist
Sep 2022 – Aug 2023
Freelance websites
Responsibilities:
On freelance sites, I find jobs to develop and maintain websites and databases. The most popular technologies in such projects are Python and Java, MySQL and Postgres databases. The main advantage of such projects is concrete and quick results. It is necessary to complete the task within a few days and correctly understand the requirements of the Customer.
Benefits: Freelance jobs can be carried out remotely, and I may choose my own working hours.
Skills: Database migration · Database Development · Python · Java · MySQL · Postgres
========================================================
ETL Database developer (remote)
Oct 2021 – Aug 2022.
Company Codegenix (USA, Texas). Outsource staff for company GlueUp.
Responsibilities:
Several heterogeneous databases of the company are in Production use (Oracle, MySQL, MongoDB). To create analytical and financial reports, it is necessary to expand DWH database and create several workflows for constant data transfer to the DWH storage. My responsibility was to create and implement ETL workflows. Some workflows were created using ETL Talend, as well as using Python scripts. After several months of implementation, the workflows were created and tested. They fulfill all the necessary requirements, and the leaders were satisfied with the work performed.
Benefits: Experience with NoSQL database (MongoDB, JSON structures).
Skills: Data Migration · Database Development · SQL Tuning · Mongo database · Business Intelligence (BI) · Python · Talend · Java · SQL · ETL
Recommendation letter: https://bit.ly/3ITcypl
Reason for leaving: War in Ukraine.
========================================================
BI analyst, DWH developer (remote)
April 2019 – March 2021.
Company Emergn (Ukraine). Outsource staff for company Mercer (USA).
Responsibilities:
The customer of the project is the insurance company Mercer, USA. Emergn is a consulting out staff company based in Ukraine. My responsibilities in the project - database developer and BI analyst. The goal of the project is the daily data workflows from the Oracle Premise database to the Azure cloud, the Microsoft SQL database. This database was a DWH, and analytical reports were run in it. Talend workflows were used to transfer data and generate reports. At the initial stages, SQL queries had problems with low SQL performance, they were successfully eliminated.
Skills: Microsoft Azure · MS SQL Server · Oracle · Talend
========================================================
Database developer
May 2018 – January 2019.
Company Mede Analytics (Ukraine)
Responsibilities:
Company Mede-Analytics develops software for US health insurance payments. The company's clients are MEDICARE, MEDICAID, about 200 companies in the USA. Health insurance documents go through a full financial cycle: uploading, checking, storing in a storage system, displaying financial documents and other reports on websites. This cycle is based on MS SQL, SSIS and OLAP Cube (MDX) technology. I was part of the development team. The team was engaged in DWH support, development of analytical reports.
Skills: Microsoft Azure · MS SQL Server · Oracle · Informatica Power Center
========================================================
IT Support Engineer (remote).
January 2016 – February 2018.
Company Jaspersoft (owned by Tibco USA).
Responsibilities:
Technical support for Jaspersoft Java applications - JasperReport Server and ETL Talend Studio. Jaspersoft servers can work with different databases with data sources from different databases - Postgres, Oracle, MS SQL and MySQL. My responsibility to assist users to install and configure Jaspersoft & Talend Java applications, assist to find and manage found errors.
Benefits: These Java applications work on all platforms (Windows, Unix, MacOS) and with different databases. I have gained hands-on experience with different OS as well as all relational databases.
Skills: Jasper Reports · Talend Studio · Oracle · MS SQL · MySQL · CentOS · Ubuntu · Bash scripts
========================================================
ETL database consultant
May 2013– April 2015
Company Miratech (Poland).
Responsibilities:
Development of ETL workflows for Lindorff (Sweden). Data migration project from Oracle DWH to Microsoft SQL. My responsibilities were to analyze, create and deploy the newest requirements for DWH by using Informatica Power Center.
Skills: Informatica Power Center · Microsoft SQL server · Visual Studio · SQL Management Studio.
========================================================
Oracle Database developer
May 2011– Mar 2013
Company Luxoft (Ukraine). Technical support for European bank.
Responsibilities:
Part of the Team for supporting the huge DWH at an investment bank, an Oracle database. The source code was written in Java and PL/SQL, and workflows use Informatica PC. Our team supported the daily runs for workflows, we supported the generation of reports for the external bank audit. The software in the banks must be free of errors and failures, and therefore the entire program code was checked several times, including QA automated tests.
Skills: Oracle · DWH · Database Development · SQL Tuning · Java · PL/SQL · Performance Tuning · Oracle SQL Developer · Informatica PowerCenter