Oracle APEX / Oracle Database Developer
Nearly 4 years of employment (employment contract)
currently cooperating on a B2B basis

Experience gained through the delivery of internal projects as well as solutions developed for external clients. The work covered the full application lifecycle — from requirements analysis, through database architecture design and implementation in Oracle APEX, to the maintenance and further development of existing systems.

The working environment was based on Oracle APEX, Oracle Database, SQL/PLSQLwith a strong emphasis on stability, scalability, and clear, well-structured business logic.

CRM System for a Ceramic Manufacturing Company

Delivery of the full CRM system development lifecycle – from requirements analysis, through implementation and deployment, to ongoing maintenance and application development.

Internal CRM system

Definition of business requirements, solution implementation, and coordination of the project team’s work.

Call Center Agent Support System (banking)

Design and implementation of an application supporting Call Center agents’ work, including process analysis and production deployment.

BI system for a ceramic industry manufacturer

Development and maintenance of an analytical system supporting business data reporting and analysis.

Customer Risk Assessment System (banking)

End-to-end delivery of a risk assessment system – from requirements analysis, through implementation, to ongoing solution maintenance.

Agreement Addendum (Settlement) Management Application – banking

Participation in system development through modifications of printouts and reports in the Oracle BI Publisher and Oracle APEX environment.

Application Processing and Asset Inventory System

Development and maintenance of an application supporting request handling and enterprise asset management.

Automation of Oracle database testing

Development of automated tests for PL/SQL procedures and functions to improve system quality and stability.

CRM

Customer Relationship Management (CRM) applications

A manufacturer in the ceramic industry required improvements in customer relationship management within an environment based on Oracle databases. Available off-the-shelf solutions did not provide the required level of integration with existing internal systems.

The scope of the application includes:

• management of the customer and contact database,
• lead management,
• document repository,
• internal calendar module (without integration with external systems).

My responsibilities included:

• participation in consultations and requirements definition,
• design of the database structure and application architecture,
• application implementation,
• solution development and maintenance.

BI System – Business Intelligence

A Business Intelligence system supporting the analysis of business data through the consolidation of data from the request handling and asset inventory applications and presenting it in user-defined reports.

The solution scope includes:

• retrieval of reporting data from other database systems using database links,
• creation of reports defined and configured by employees.

My responsibilities included:

• joining an existing project,
• providing support for bug fixes and minor application development tasks.

Customer Risk Assessment System

A system supporting customer risk assessment based on data from internal systems, used in compliance and regulatory risk management processes.

The solution scope includes:

• management of the customer database,
• creation and maintenance of customer profiles,
• calculation of risk levels based on data entered and retrieved from other internal systems,
• mechanism for periodic verification and updating of customer data,
• import of customer data from external files.

My responsibilities included:

• participation in consultations and definition of business requirements,
• implementation of risk assessment logic according to the provided requirements,
• preparation of mechanisms for periodic verification of customer data,
• implementation of customer data import,
• participation in further application development activities.
• preparation of printouts using Oracle BI Publisher.

Agreement Addendum (Settlement) Management Application

A system supporting employees in preparing and presenting agreement (settlement) addenda for clients, used in operational processes.

The solution scope includes:

• creation and editing of agreement addenda based on system data,
• generation of addendum documents in printed form.

My responsibilities included:

• preparation of print and document templates for addenda using Oracle BI Publisher.

Application Processing and Asset Inventory System

A system supporting request registration and processing, asset management, and inventory processes, integrated with other internal organizational systems and encompassing multiple functional modules.

The solution scope includes:

• request management,
• fixed asset management,
• inventory process management,
• budget management,
• integration of data with other internal systems.

My responsibilities included:

• joining an existing project,
• participation in consultations regarding further application development,
• implementing bug fixes and developing new functionalities based on provided requirements.

Automation of Oracle database testing

A solution supporting automated testing of database logic, encompassing stored procedures, PL/SQL packages, and functions used by the application.

The solution scope included:

• design and implementation of test procedures based on predefined test data,
• validation of the correctness of business logic executed on the database side,
• ensuring repeatability and consistency of regression tests.

My responsibilities included:

• design of test scenarios,
• implementation of test procedures in PL/SQL,
• preparation of test table structures in the database,
• preparation and maintenance of test data.