Контактна інформація

Шукач приховав свої особисті дані, але ви зможете надіслати йому повідомлення або запропонувати вакансію, якщо відкриєте контакти.

Досвід роботи

SENIOR DATABASE DEVELOPER

з 10.2018 по 02.2026 (7 років 5 місяців)
STATE STREET, Дистанційно (IT)

•Designed, developed, optimized and implemented complex database components (Packages, Procedures, Functions, Triggers, Views, Materialized Views, Ref Cursors, Collections, Types, Dynamic SQL and SQL Bulk Processing) supporting high-volume transactional systems in financial institutions.
•Worked with Oracle (PL/SQL), PostgreSQL (PL/pgSQL), Microsoft SQL Server (T-SQL) and MySQL environments.
•Led database performance tuning, query optimization and execution plan analysis, improving response times by up to 500%.
•Developed and optimized high-volume data processing and bulk-loading modules for mission-critical enterprise systems.
•Designed and implemented a bulk-load testing module to simulate high-volume workloads, validate performance and ensure scalability and stability.
•Created Application Recertification workflows to support compliance, security and auditing requirements.
•Worked with high-volume data feeds and large-scale enterprise data processing.
•Designed and maintained database links (DB Links) for cross-database communication and data integration.
•Led in database migration and modernization projects, including schema conversion, data migration, legacy code rewriting and adaptation, SQL query conversion, and cross-platform database optimization.
•Validated migrated database objects, data integrity and system performance through functional testing and benchmarking.
•Led and contributed across all SDLC phases, from requirements definition to production deployment, maintenance and release support.
•Tuned large-scale data warehouses, optimizing analytical queries, materialized views and database performance.
•Collaborated closely with cross-functional teams to integrate database APIs with Java and React applications.
•Designed and implemented custom business-driven reports based on stakeholder requirements.
•Worked in cross-functional Agile teams using Scrum and Kanban methodologies.
•Actively contributed to daily stand-ups, backlog refinement, sprint planning, sprint reviews, and retrospectives.
•Managed daily tasks and sprint progress using Jira dashboards and workflows.
•Collaborated with development teams, Product Owners and Scrum Masters to align sprint goals and delivery timelines.
•Maintained structured project documentation and knowledge bases in Confluence for efficient team access and onboarding.
•Conducted code reviews, used GitHub for version control, prepared DB builds (releases/hotfixes), and supported cloud deployments across DEV, UAT and PROD environments.

Головний інженер з комп'ютерних систем

з 04.2013 по 10.2018 (5 років 7 місяців)
QUANTUM INTERNATIONAL, Львів (IT)

•Developed, implemented and optimized complex backend/frontend components for automated logistic software systems:
-Qguar WMS (Warehouse Management System) such as ABC analysis to categorize inventory, load capacity, route efficiency, weight and dimension measurement etc.
-Qguar TMS (Transportation Management System) for route planning, cargo tracking modules etc.
•Designed and implemented a C# application to connect WMS with 3rd-party device for getting a weight and dimension measurement device for automated cargo data capture
•Worked closely with team and business analysts to translate logistics requirements into optimized database solutions
•Supported database environments across multiple logistics hubs and international branches
•Worked in a mixed Waterfall methodology, depending on project scope and client needs
•Managed code reviews, used SVN for version control and prepared builds for projects

Головний спеціаліст

з 01.2006 по 04.2013 (7 років 4 місяці)
KredoBank, Львів (Фінанси, банки, страхування)

•Led, developed data migration project across 25+ bank branches for modules: Loans, Overdrafts, Deposits, Cipher (Security cryptographic module). It was large enterprise project intended to optimize databases for “KREDOBANK”. The purpose of the project was consolidated data into central DB. Project duration 36 months.
•Led, designed and implemented two large and similar projects on staff motivation of MBO bank (Motivation of Bank Operations) and OCS (Operational and Cash Services). Projects duration is 24 months and consist of parts:
-a) collection and aggregation of various statistic data about users;
-b) data processing according to algorithms suggested by the customer;
-c) calculation and accrual of bonuses based on the fulfillment of certain operations;
-d) In the end, was transferred to Support Team
•Automated routine tasks using PL/SQL, Delphi/Pascal and Bash
•Delivered software solutions in a traditional Waterfall methodology, utilizing Jira for coordination and progress monitoring
•Supported Bank modules via CBS B2 (CS LTD): Accounts, Counterparties, Loans, Overdrafts, Deposits, Client Bank & IFOBS (Internet Financial Operations Business System) and Cipher (cryptographic security module)

Освіта

IVAN FRANKO LVIV NATIONAL UNIVERSITY

APPLIED MATHEMATICS AND INFORMATICS, Львів
Вища, з 2000 по 2005 (5 років)

MASTER’S DEGREE WITH HONORS

Знання і навички

• Oracle Database
• SQL
• PL/SQL
• PostgreSQL
• PL/pgSQL
• MS SQL Server
• T-SQL
• MySQL
• MS Visual basic
• Delphi
• Pascal
• C#
• Support of ABS B2
• Впровадження WMS
• Transportation Management System
• Git
• GitHub
• Jira
• Confluence
• TortoiseSVN
• Scrum
• Kanban
• Waterfall
• Database design
• Performance Tuning
• Data Modeling
• OLTP
• High Availability
• Analytical thinking
• Conflict settlement
• Teamwork
• Communicability
• Time management

Знання мов

• Українська — вільно
• Англійська — просунутий
• Польська — вище середнього