Verified Expert in Engineering
Database Optimization Developer
Zoran has more than 20 years of experience in Oracle database design and development, and expertise in PL/SQL programming, database design, data structure, and data manipulation. He's a strong team player with project experience in finance, manufacturing, government, and SME.
Oracle Application Express (APEX), Oracle SQL Developer, PL/SQL, SQL, Toad, Oracle DBA
The most amazing...
...thing I have developed is complete banking/microfinance system with 400,000 lines of PL/SQL code used for 12+years in production.
Senior Database Developer
- Designed and developed of loan tracking system (LTS) based on Oracle DB and Oracle Developer (forms, reports).
- Developed more than 400,000 lines of PL/SQL code for supporting business processes in loan management, accounting, and reporting.
- Designed and implemented PL/SQL code for billing and accounting system in a power distribution company.
- Developed Oracle APEX based reporting system for accounting and analysis from legacy data. Created replication of Oracle DB 11g to Oracle 12c.
- Performed optimization of the PostgreSQL agriculture traceability system and integrated it with Oracle 18C DB. Created analytical views and APEX application for analysis.
- Designed and developed a data collection and reporting module in Oracle APEX. Developed packages for integration with SAP. Developed web services in PL/SQL for publishing and consuming data.
- Designed a complete database model and structure for a flexible and manageable banking system for the Central Bank of BiH. Included database managed data entry and reporting.
- Designed and developed complete banking information systems for a local bank. Developed different modules using Oracle Developer and Designer. Installed Oracle database on a SUN server.
- Created and implemented an advanced human resource management system for Swiss company Humanfact AG. Developed highly sophisticated modules for 360-degree assessment and skills assessment using PL/SQL and Oracle Designer.
- Designed an automated system for garbage collection using Oracle Developer and PL/SQL for the Netherlands market, providing advanced schedulers and database models for communications.
Loan Tracking System for Microfinance Sector
The project duration was 2 years. The project was used in a production environment for more than ten years. The initial implementation was designed to work in a distributed environment with 8 Oracle DB and the next phase was to transition to a centralized environment with more than 400 users all over the country.
Oracle APEX Reporting System
Billing System for Power Distribution Company
Maintenance System in Powerplant
Implemented more than 300 Oracle forms and reports. Designed a data warehouse and implemented a reporting application based on Oracle APEX. Create web services in PL/SQL for integration with SAP.
Reporting System for Central Bank
Developed complete Technical documentation for the Core Banking system, cooperating with team leads and business analyst. Edited user manuals and help system.
Agriculture ERP System - Oracle and PostgreSQL
Designed and implemented system modules based on user requirements.
Developed PL/SQL code and APEX dashboards. Developed business logic in PL/SQL. Developed data migration routines and performed data quality assessment.
Import GIS Data for Agriculture
eLegislation Software - Technical Specification
Payroll System Documentation
Data Analysis in Loan Management
Analysis of Agricultural Data
Data Analysis in Marketing Agency
UNDP QA for Architecture and Implementation of eCitizen Systemhttp://www.ecitizen.ba
Architect and QA Lead for Payroll Software for Palestinian Government (World Bank Project)
Lead Architect and QA Lead in eGovernment Project in Moldova (EU Project)
CRM Oracle APEX
Oracle Application Express (APEX), Microsoft Power BI, Toad, Oracle Designer, Git, GitHub
Oracle Database Architecture
Oracle PL/SQL, Databases, Database Modeling, PL/SQL, Oracle DBA, Oracle SQL Developer, PostGIS
Architecture, Database Optimization, SQL Design & Reporting, Reporting, Functional Specifications, Requirements & Specifications, Writing & Editing, Documentation, System Architecture, Oracle Forms & Reports, Systems Analysis, Query Optimization
Master's Degree in Strategic Information Systems
University of Sarajevo, Faculty of Economy - Sarajevo, Bosna and Hercegovina
Bachelor's Degree in Information Systems
University of Sarajevo, Electrotechnical Faculty - Sarajevo, Bosna and Hercegovina
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.Start hiring