Rade Pobulic

I custom-developed the SQL, PL/SQL, BI Publisher, OAF, Forms, and Bash. I also implemented the SQL and database performance tuning (with more than ten terabytes and more than one billion rows of tables). In addition, I provided hardware optimization guidance.

I developed a mobile application for DHL Express workers, using Oracle PaaS. I was involved in requirements and gap analysis, testing, performance tuning and writing complex SQL queries for the Oracle Database.

I developed a custom eBusiness suite module for multi-user plan generation, modification, and analytics with custom version control on every field of every plan. I also created a custom Oracle EBS Web ADI integrators as the UI for the plans and developed extremely efficient complex views for real-time extraction and aggregation of all relevant EBS data. Lastly, I created an Oracle BI repository for plan analytics.

I developed custom BI Publisher Reports, Oracle Forms, and Web ADI integrators for the Oracle E-Business Suite 12.1 in a multiorganizational context, covering a broad range of financials and manufacturing modules.

I wrote Business Intelligence Publisher reports for the financial and inventory parts of the hospital's system as a member of an Oracle Consulting implementation team for Oracle eBusiness Suite. All my reports required writing very complex SQL for the Oracle Database.

I developed a data warehouse using Oracle Warehouse Builder for ETL, a custom PL/SQL for data matching, Oracle BI for analytics, and BI Publisher for reporting. Also resolved very demanding performance issues by optimizing SQL, database, and hardware configuration.

I designed and implemented the central Serbian social insurance Oracle database, then cleansed and migrated data from legacy PL/1 and COBOL applications. Configured and tuned the pilot Oracle Database.

I developed custom PL/SQL procedures for Oracle EBS for the migration of data from legacy applications. Also, I created the most demanding reports on the new database and performed performance tuning of other reports.

I imported and parsed one million very complex XML documents in a few minutes using BaseX and an Oracle SQL Loader data pump. I then analyzed the total Oracle database performance and resolved all critical performance issues.

I created a requirements analysis and EAM solution design for the municipality company maintaining 600.00 buildings in the Belgrade area, for implementing Oracle eBusiness Suite EAM, inventory and manufacturing modules.

I developed the real estate agent and customer facing application in Oracle Application Express. The application was highly optimized for efficient search and response times, while remaining very flexible.

I developed an Oracle Database and process design based on metadata and semantic web standards (UNIMARC, Spectrum, EAD, and CRM).

I worked on open-source data masking for PostgreSQL.

I developed SQL, PL/SQL, BI Publisher customizations, and high-performance complex database views for business analyses. I also performed demanding performance tuning of SQL, database, and hardware configuration.

I developed the most demanding Oracle Database SQL for the automotive software vendor AD-CS AG which was used by GM, Nissan, Emerson, and others. Anything SQL or PL/SQL that this vendor's development team was not able to make run efficiently, was forwarded to me.

As a general manager of Oracle Russia in 1995, I personally developed a custom CRM application using Oracle Designer, Forms, and Reports, which covered all aspects of sales, forecasting, delivery, collections, and support; it also successfully achieved exceptional sales and support force productivity and the best business results in EMEA. I used the beta version of Oracle Discoverer to build a BI system so good that I stopped preparing slides with business results for regional management reviews and used live Discoverer reports and ad hoc queries to answer immediately. This meant that the most complex questions were answered in seconds instead of days like my colleagues in other countries.

This system was in use for over 20 years by Oracle Russia.

I handled the Oracle Database, SQL, and PL/SQL performance tuning of the largest real estate data warehouse in the US for Smarter Agent. I also designed an optimal partitioning scheme for frequent data loading and online availability.

As a solution architect, I contributed to a custom mobile front end for Oracle HCM Cloud. I performed a gap analysis and proposed the solution and development framework (Oracle Visual Builder) and the PaaS platform (Oracle Integration Cloud), and designed and organized the testing.

This project involved an Oracle HCM Cloud localization and implementation for the Croatian Lottery. As a project manager and implementation consultant, I handled the complete implementation, localization, and data migration, as well as custom reports and BI.

A universal PHR and EHR platform using several innovative technologies, like:
Oracle Database 23ai JSON-relational duality views and database domains for 100% mapping of all FHIR 6 data types, resources, and terminologies;
Aries Verifiable Credentials.