Artem Bodnar

3. Exhibition's full cycle Management System (Oracle 12c):
• Migration of existing database from MYSQL Server to Oracle platform
• Working with PL/JSON and Oracle JSON technologies
• Writing instrumental code (functions, triggers, procedures, packages, views etc.)
• Planning of storage (tablespaces, segments, tables, partitioned tables etc.)
• Object-oriented programming of database
• Working with collections, writing packages, triggers, writing and debugging of SQL-queries
• Debugging of written code

1. FORIS System (Oracle 12c):
• Writing instrumental PL/SQL code (functions, triggers, procedures, packages, views etc)
• Writing and debugging of SQL-queries
• Loading/Uploading data using SQL-Loader/Data Pump
• Automation system development for big industrial processes control using PL/SQL packages and SQL-scripts

2. PLANET System (Oracle 11g):
• Migration of existing database from MS SQL Server to Oracle platform
• Migration and customization and functional extending of client GUI applications using Delphi
• Reports development and integration
• Writing instrumental code (functions, triggers, procedures, packages, views etc.)
• Client GUI applications development
• Planning of storage (tablespaces, segments, tables, partitioned tables etc.)
• Object-oriented programming of database
• Working with collections, writing packages, composite triggers, writing and debugging of SQL-queries
• Backup/restore data, loading/uploading data using SQL-Loader/Data Pump
• Debugging of written code
• Development of reporting tools using Fast Reports

DBMS Oracle:
- A writing of instrumental code (functions, triggers, procedures, packages, views etc),
- Planning of storage (tablespaces, segments, tables, partitioned tables, materialized views, etc.),
- Object-oriented programming of database,
The accounting system of prisoners (Oracle 11g):
• Front End development, Back End development
• Architecture and storage planned (tablespaces, segments, tables, partitioned tables, materialized views, etc.)
• Object-oriented programming of server side
• Worked with collections, wrote packages, composite triggers, wrote and debugged SQL-queries, processes of data backup / restore
• Developed a parser of XML large arrays using Oracle system packages, loaded/unloaded data using SQL-Loader/Data Pump
• Debugged written code, developed reporting tools using Oracle Reports, Fast Reports

• Design and manufacturing of telecommunication, payment and vending systems
• Management / direct involvement in the design, implementation and certification of products:
• Patient registration subsystem of the state clinics (Oracle 11g R2) - Front End development, Back End development
• Terminal for the sale of local rail tickets (fiscal Technology, Oracle 10g, Oracle 10 XE) - Front End development, Back End development, design development management
• Universal payment terminal (Oracle 10g) - Back End development
• Terminal for gas station - Front End development
• Internet service Terminal (VoIP-services, electronic payments, bank cards, RFID-cards, cash, fiscal Technology, Oracle 10g, Oracle 10 XE) - Front End development, Back End development, design development management
• Oracle based development of industrial management systems (Oracle 11g R2) - Front End development, Back End development.

• Design and manufacturing of telecommunication and payment systems
• Management / direct involvement in the design, implementation, certification and integration of the following products:
• Design and manufacturing of telecommunication and payment systems
• Management / direct involvement in the design, implementation, certification and integration of the following products:
• ROTOR 2000U Multi payment payphones, payphone network management system "Gamma" (Oracle 7, Oracle 8i). Front End development, Back End development, backup / restore data tools, loading/uploading data using SQL-Loader/Data Pump, debugging of written code, development of reporting tools using Oracle Reports, etc.
• HDSL, SHDSL equipment management system (Oracle 8i)
• The organization of remote monitoring and support of a network of Oracle servers