Александр

CV
PERSONAL INFORMATION

First and last name Mortikov Oleksandr
Address Kyiv
Postal code, city 02095
E-mail [відкрити контакти](див. вище в блоці «контактна інформація»)
Telephone number [відкрити контакти](див. вище в блоці «контактна інформація») (WhatsApp, Telegram)
Date of birth July 12, 1982
Marital status divorced

EXPERIENCE
SQL programmer, PL/SQL developer (Oracle)
Important information:
• More than 10 years of experience as an SQL developer in the banking sector (Oracle)
• PL/SQL developer (database Oracle 10g, Oracle 11g, Oracle 12с, Oracle 19с)
• Database architect:
- Understanding of the relational data model, normal forms, transactions
- Parallelization of queries, development and optimization of complex SQL queries
- XML, json, etc.
• Experience with PL/SQL Developer, TOAD, SQL*Plus, SVN, MSAccess, ErWin, Jira
• Professional knowledge of SQL Standard (analytic functions, etc.)

03.2023 - 07.2023
Manager in the Credit Risk Department in the area of risk calculation using the software; Universalbank PJSC (Kyiv, Ukraine)
09.2020 - 12.2021
Manager in the Software Development Department at Bank Pivdenny PJSC (Odesa, Ukraine)
02.2020 - 09.2020
Manager in the Business Applications Development Department in the Information Technology Department at INGO Insurance JSC (Kyiv, Ukraine). As an Oracle developer, I created packages and tables and programmed business logic. I also performed data downloads and SQL queries. PL/SQL Developer was used in the work. I performed a number of tasks in MS SQL Server - creating tables, functions and procedures, creating SSRS reports, integration packages with SSIS, and also using Teradata DBMS (as a solution for Oracle BI), creating reports using the tool.
03.2018 - 01.2020
Remote work for Multipanel Co UK (Dover) based in Great Britain. My tasks were related to SAP queries (I worked in MS Access).
11.2017 - 03.2018, 02.2019 – 07.2019
Work in Ukrainian banks in the field of IT and credit risk. Main tasks: working with databases (Oracle), data download, SQL queries.
04.2016 - 07.2017
PL/SQL programmer at TM Soft LLC (https://www.tmsoft-ltd.com) Main responsibilities: Correcting errors in the code and completing tasks according to the technical specifications, compiling versions (knowledge and skills of PL/SQL, SVN).
10.2012 - 04.2016
Manager of the back office for problem loans in Rodovid Bank PJSC (Kyiv, Ukraine). Also in the analytics department with the position of deputy head of the department. Area of responsibility: Further development and maintenance of modules of the analytical system used in the bank under the Oracle DBMS for lawyers and enforcement proceedings.
10.2005 - 05.2012
Oracle - developer in the information technologies department / Since 2007 Head of the analytical systems development department in the IT department of Rodovid Bank PJSC (Kyiv); I was engaged in the development of bank analytical systems in the IT department of Rodovid Bank PJSC (Kyiv, Ukraine). Main tasks - Development of modules for the bank's internal analytical system using data storage and card system (in DBMS Oracle 10g, then Oracle 11g) - Optimization of queries, procedures and reports (using SQL, PL/SQL) - Development of architecture, database and support of automated systems - Code review and SQL optimization, PL/SQL code refactoring - Creation of OLAP reports - Participation in implementation
EDUCATION
Master's degree in the specialty "Information Management Systems and Technologies".
09.1999 - 06.2005
Studied at the National Technical University of Ukraine "Kyiv Polytechnic Institute" at the Faculty of Informatics and Computer Engineering.

LANGUAGES
German - while studying at the university I attended a language course at the Goethe Institute for 2 years (level B1). Confident knowledge of spoken and written language.
English - very good knowledge of spoken/written language, upper intermediate level (at the level of reading technical documentation and free interpersonal communication). There are no certificates, I can pass the interview and also use it at work (level B2).
Russian - native speaker
Ukrainian - fluent

SKILLS
Flexibility, ability to work in a team, resistance to stress, commitment, analytical thinking;
Communication skills, leadership qualities, creativity, politeness, kindness, ability to learn new things.

HOBBY
Listening to music, reading, hiking