Serhii

Serhii Kononenko
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
Professional Summary
To get for the PL/SQL position
Skills
18+ years of Professional and Commercial IT in Finance Sector, Bank Systems: NA, EU, Asia, Ukraine;
• Programming experience in developing cost-effective solutions as Senior Oracle Developer;
• 13+ years of experience in developing high - performance, highly- available and scalable systems of financial data processing based on Oracle stack technologies - Oracle Database, PostgreSQL, Warehouse Management System (WMS), EXADATA;
• Extensive experience in the data management - ETL processes, data migration, data validation, security policies;
• Knowledge in: Oracle 11g, Oracle 12c, Oracle 19c, Postgresql;
• Data Engineering, Data Analysis, Unit tests;
• RDBMS: SQL, PL/SQL, PostgreSQL, MSSQL, MySQL;
• Tools: Bitbucket, SVN, Git, JIRA, TOAD, SQL Developer, pgAdmin, IntelliJ IDEA, SQL Navigator, Selenium;
• Experience developing/enhancing batch jobs processing millions of transactions per hour;
• Excellent Performance tuning experience;
• Experience of query plan analysis & optimization using Oracle Enterprise Management;
• Experience designing, enhancing, and supporting large databases with terra bytes of data;
• JavaScript Object Notation (JSON);
• PL/SQL Objects : Create and maintain objects like procedures, functions, packages, types, triggers;
• Collection, Records, Objects : Ways of using collection and records in PL/SQL blocks;
• Strong communication, analytical and problem-solving skills;
• Ability to work well in a team environment;
• Web languages: HTML, PHP, CSS, JavaScript;
• Python scripting;

Work History
Database Administrator | PL/SQL Developer | Fintech | DWH
BizPozyka – St. John’s NL
PostgreSQL Database Development & Optimization:
- Architecting and validating robust Data Warehouses (DWH) using PostgreSQL for enhanced stability and efficiency.
- Utilizing "psql" for command-line database interactions and management in PostgreSQL.
- Establishing and managing dblink connections for integrated remote PostgreSQL database operations.
- Leveraging PostgreSQL Foreign Data Wrappers (FDW) to interface seamlessly with Oracle databases.
- Designing intricate PostgreSQL database tables, schemas, type functions, and collections.
- Crafting optimized SQL queries in PostgreSQL tailored for seamless application integration.

Python-based Programming & Automation:
- Utilizing Python for advanced database-related scripting, automation, and interaction with PostgreSQL collections and type functions.
- Developing and refining program views, functions, and stored procedures with a focus on type functions.
- Curating high-performance Python scripts, procedures, and triggers to augment PostgreSQL-based application development.
- Implementing and managing cron jobs using Python for scheduled database tasks.

Data Integrity, Backup & Security:
- Leveraging "pg_dump" for consistent database backups, ensuring data reliability.
- Ensuring impeccable data quality, collection integrity, and maintaining stringent PostgreSQL database security standards.

Assistant Manager Data, 09/2022 – 02/2023
HOLIDAY INN – St. John’s NL
Database Development & Management:
- Architecting and ensuring robust databases for maximum efficiency and reliability.
- Crafting programmatic views, functions, and advanced stored procedures.
- Designing strategic SQL queries optimized for seamless application integration.
- Structuring database tables and devising comprehensive dictionaries.

Scripting & Application Integration:
- Developing refined scripts, procedures, and triggers tailored for enhanced application functionality.

Data Integrity & Security:
• Upholding superior data quality standards, executing consistent backups, and enforcing robust database security protocols.

Senior PL/SQL Developer, 10/2020 to 11/2022
ALFA BANK (SENSE) – Kyiv, Ukraine
Main Achievements at Sense Bank:
• - Spearheaded the development and successful launch of a cutting-edge feature for buying and selling shares, investments, and bonds in the Ukrainian market, utilizing advanced Oracle queue mechanisms to streamline operations.
• - Pivotal in the initiation of the groundbreaking Investments project within the Sense application, marking a first in the Ukrainian market. This project extensively leveraged collections and functions using object types to optimize data handling and operations. This contribution was recognized with an award for the best IT project in the bank.
• - Received accolades in annual rankings, attributed to the exceptional quality of work and unparalleled success in startup launches.

• Additional Contributions:
• - Played a crucial role in the development and optimization of the "Back Loan Manager System" (previously known as ABS B2), streamlining various financial projects. The architecture was bolstered by an extensive use of Oracle collections, ensuring efficient data manipulation and retrieval.
• - Collaborated actively with other developers, ensuring seamless system support and continuous development, with a special emphasis on harnessing functions that utilized object types for enhanced operational precision.
• - Addressed and resolved a multitude of requests, incidents, and challenges while maintaining a strong rapport with the front-office system development team, ensuring efficient support and integration with the back-office framework.

Senior PL/SQL Developer, 02/2016 to 10/2020
MDFINANCE – Ukraine, EU, Asia (Fintech)
• Participation in the setup and support of the back-office application (ABS "B2" and others) for accounting transactions and products, the implementation of financial products, the performance of regulatory and other maintenance operations, interaction with the developer in matters of support and development of the system, processing requests and solving incidents and problems, as well as the same interaction with the development team of the front office system on support and integration with the back office system. Created optimal technical solutions to user needs with in-depth system analysis
Head of Sector, 09/2010 to 02/2016
FORWARD BANK – Kyiv, Ukraine
• Main responsibilities: Processing of external data with import to ABS "B2"
• Administration of ABS "B2"
• Granting of rights to the ABS users
• Introducing products in ABS
• Carrying out routine maintenance and closing / opening of OD
• Administration and management of the SEP Monitor
• Interaction with NBU services for data exchange (mail, files, etc.)
• IFOBS support
• Support for the reporting module to the NBU (reserves)
• Module support (loans+, deposits, A&C)
• Writing scripts in SQL
• Building reports on FastReport
• Development in PL/SQL
• Trained, mentored and developed new cashiers with positive and encouraging techniques to maximize performance and team contributions
Specialist of Support and Testing, 07/2007 to 09/2010
RUSSIAN STANDARD BANK – Kyiv, Ukraine
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork
• Devoted special emphasis to punctuality and worked to maintain outstanding attendance record
• Actively listened to customers, handled concerns quickly and escalated major issues to supervisor
• Increased customer satisfaction by resolving issues
• Used coordination and planning skills to achieve results according to schedule
• Identified issues, analyzed information and provided solutions to problems
• Developed and implemented performance improvement strategies and plans to promote continuous improvement
• Resolved conflicts and negotiated mutually beneficial agreements between parties
• Worked to maintain outstanding attendance record, consistently arriving to work ready to start immediately
• Demonstrated respect, friendliness and willingness to help wherever needed
• Led projects and analyzed data to identify opportunities for improvement

Processing Center Operations Administrator, 01/2005 – 07/2007
UKRCARD – Kyiv, Ukraine
• Development and implementation of new banking technological processes, functional and technological documentation for newly implemented projects, monitoring and optimization of existing technological processes, optimization of functional and technological documentation for existing projects, testing of new software improvements in the implementation of bank projects for the introduction of new banking products, monitoring existing banking technologies and development/implementation of proposals for optimization of existing technologies
• Main responsibilities: settlements in the interbank payment system
• Servicing of processing operations using cards of payment systems UkrCard, Mastercard Int., Visa Int
• Both on the territory of Ukraine and abroad
• Monitoring of the payment system MasterCard, Visa
• Remote support ATM
• BCZ and BCZCard+ server administration
Education
M.D.: Computer/Information Technology Administration and Management 2003 - 2009
National Aviation University - Kyiv UKRAINE

Certificate of achievement
Operation Support and Analysis:
ITIL OSA1V.3: Service Support 2016
ITIL OSA2V.3: Workshop 2016

Oracle OpenWorld 2017 San Francisco
Banking, Corporate, Finance, and Securities Law

Oracle OpenWorld 2018 San Francisco
Banking, Corporate, Finance, and Securities Law