Darko Jelisavcic

dataglob@sezampro.rs  /  www.data-glob.com

Oracle Certified Professional

PROFILE

Senior Oracle specialist with experience in designing and implementing Oracle database systems, robust and scalable applications on UNIX (Linux, Sun Solaris, HP-UX) and Windows computer platforms. Application and database expertise includes strategy, analysis, design, implementation and production.

Oracle Cloud Infrastructure 2023 Certified Foundations Associate Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning Oracle Enterprise Manager 12c Cert. Implemenation Specialist Oracle RAC 12c Cert. Implemenation Specialist Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional Oracle9i Database Administrator Certified Professional Oracle Database 12c Sales Specialist Oracle Exadata Database Machine Support Specialist OPN Oracle Database 11g Sales Specialist Assessment OPN Oracle Public Sector Specialist Assessment etc.

Nov. 2002 – Current

Senior Systems Engineer / Technology Solutions Architect

Saga d.o.o.

-Implementations and upgrades - Oracle Databases and Oracle Real Application Clusters on various hardvare platforms such as Oracle ExaData Database Machine, HP-UX, Linux etc , client Telekom Serbia a.d. , NIS ad Novi Sad etc.

-Change Data Capture ETL design and implementation, PL/SQL design and implementation for VLDB data environment, compression procedures, Central Registry of Compulsory Social Insurance

-Oracle Auditing solutions,  Oracle Identity Management, Oracle ETPM, Oracle WebLogic, Oracle Data Guard, Oracle WebCenter, Oracle RAC on Oracle Linux, client Central Registry of Compulsory Social Insurance, Oracle Streams partial design and implementation

-Fraud Management System FMSR implementing: partitioning, exchanging partitions, massive daily processing, process monitoring and control, Telekom Serbia

-Oracle Web logic 10.3 and Oracle Fusion Middleware 11.1.1.2, Oracle database Installation, configuration, setup, support, DCV

-Oracle Application Server 10G and Oracle database Installation, Setup, Support, Development, Ministry of Labour, Employment and Social policy SCG

-Oracle Oracle Database 11g release 2 (11.2) with Oracle Real Application Clusters (Oracle RAC) Installation on HP-UX B.11.31, Telekom Serbia a.d.

-Oracle eBS Applications installation, maintenance - National Bank of Serbia, Air Serbia

-Backup Recovery Project, Central Registry of Compulsory Social Insurance, Serbian bank AD., Airport Belgrade, Ministry of Internal Affairs

-DataGuard implementation - Creating Physical & Logical Database DDOR Novi Sad, Central Registry of Compulsory Social Insurance

-Oracle Fail Safe installation, Telekom Serbia a.d.

-Real Application Cluster Installation, Support, Panonska Bank, Ministry of IE, etc.

-Teach Oracle My Way - Oracle Administration Fundamentals, MOF Serbia, Ministry of IE

-Teach Oracle My Way - RMAN Backup & Recovery, JAT Airways

-Assistance and consulting - Application & database upgrade - migration project, NIS Energogas, etc.

-Avizo - E-Business Subsystem, development : Portal of Employee - Sun Solaris UNIX, Red Hat Linux, Win

-Avizo - E-Business Subsystem, application and infrastructure setup and installation in 3 tier architecture

Jun 2000–Apr. 2002

Database Systems

VCMG

-Data mining - building data mart blocks for portal users using local and distributed databases. Loading data from various sources such as database backup files, MS SQL Server, MS Access, MS Excel, ASCII text, etc. Customized PL/SQL parser development combined with the SQL*Loader direct path procedures. During the proof of the concept phase with the Bruno's Grocery Stores data mining suite block contained around 12.000.000 line item transactions for 41 store during one week of activity. Application contained summarized, detailed and administrative portals and was able to provide various analyses based on dimensions such as time, customer tender types, UPC codes/groups, transaction ranges, stores etc. Most of the report analysis have related chart for better visualization of the results. Application had option for dynamic look & feel change option.

-Load XML data using XML supplied parser and generated XML files from the database. 

-Remote and local Installations / Upgrades / Setup / Backup / Database and System Monitoring / Tuning: Oracle RDBMS, Oracle Internet Application Server,  Forms Developer, Oracle Reports, Forms Server, Report Server, WebDB/Oracle Portal on production and development sites. Physical database design, building recovery and backup procedures, loading data on high availability production co-location sites, schema and site  transfers. Software: Oracle Enterprise Manager, MS Terminal Services Client, TVNC. OS/Hardware: SUN Solaris 2.8, Linux Intel-RedHat 6.2, Windows 2000/NT. Software: Oracle RDBMS Version 8.1.7.4. Oracle iAS mod_plsql v3.0.0.8.0 / Apache 1.3.12   ApacheJServ/1.1, WebDB 2.2.0.0.5, Forms/Reports/Graphics 6.0.8.13.1.

-Incorporating Oracle iAS file manipulation capabilities in Portals for file upload and download.

- HTML / JavaScript design was performed using application templates standardized by the external style sheet .CSS / .js files. This methodology provides seamless  integration of the modules and graphical  design. Software used: Microsoft FrontPage and Macromedia Dreamweaver UltraDev.

- Database modeling, design, and reverse engineering using Oracle Designer. Source extraction using Quest Software Toad.

-Portal design for efficient, organized and secure ways to access information. Build interfaces for various client types, from  self-enabled Internet Client to Application administrator using Oracle Products. Built text search, sort engines for real time queries and reports (html, pdf, direct MS Excel output).

-Users / connections auditing. Providing secure options for web (ssl/https) and SQL*Net services (ssh). mod_ssl/2.6.4, OpenSSL/0.9.5a.

-Solutions design for automated on-line client support. Submitting Request for Information (RFI), Request for Proposal (RFP), Request for Resolution (RFR). Designed request - resolution queues subject to priority, category and acknowledgement /  closing process.

-Develop interfaces with mail systems, external sites including PCS phone messaging and mapquest.com.

-Changing SQLJ code used by the JSP application.

-Work on managing images, video files, documents; building locator functions. Loading images into a database as binary large objects ("BLOBs") and retrieving those from application. Testing of the RealVideo content using RealServer and files stored in Oracle8i with InterMedia.

Aug. 1998–Jun 2000

Consultant

Stone & Webster Canada Ltd.

-Cable & Wire management Application: analysis, design, development and maintenance of Cable & Wire management Application using Oracle Developer.

-PL/SQL code design and implementation.

-Installation and maintenance of the Web enabled environment using Oracle Application Server. Local and remote application on call support.

-Testing web Application performance and complete cycle of customization and application installation including installation of the Database, Oracle Web/Application Server, Oracle Developer, WebDB and related products setup.

- Database modeling, design, module generation using Oracle Designer.

-Security procedures installation and maintenance: Installed SSL security ant other security options on Oracle Application server. Application and html text integration.

-Product Data integration / loading procedures by developing utilities with ODBC drivers using Access data files.

-Performing database installations and administration in multiple instance environment. Database backup and migrations of 7.x databases to 8.0x or 8i database. Administration work for development and production environment.

Sep. 1997–Aug. 1998

Consultant

Northern Telecom

-Oracle Financials General Ledger Utilities development related with the Migration of the Oracle Applications from version 10.5 to 10.7.

-Design of the PL/SQL Application and Database administration scripts.

-GL Utilities Oracle Applications Administration and Output Distribution setup.

-Y2K Related problem resolutions.

Jun. 1996–Sep. 1997

Consultant

Oasis Technology Ltd.

-Credit Card Application Development using Developer 2000 (Forms 4.5, Reports 2.5 and Procedure Builder)

-Designer 2000 Development, Repository Management

-Oracle database and Tools installation and administration on SCO, Sun Solaris, Windows 95 , NT

-Create dynamic model for the Security administration of the application.

-Reverse engineering existing application and enhancing the design with the new functionality.

-Application Installation script design using the CD-ROM media type.

-Pro*C programs analysis and modification using dbx debugger.

-Procedural objects development.

-Oracle Translation Manager installation and management for the multi-language application support.

Sep. 1994-Jun. 1996

Consultant

City of Toronto

Maintenance Management System Development

-Maintenance Management System analysis and development.

-Development using Designer 2000 for the design and first cut generation.

-Oracle Reports and Oracle Forms development.

-Integrate in house application with the third party faxing application and added system security and error checking mechanisms.

-Provided shell scripts as the part of integration tool.

-Tuned the application and the database.

-Development using procedural objects (database triggers, store procedures, packages, libraries).

Feb.1994-Sep. 1994

Database Administrator

Dow Jones Telerate

Database Administration

-Oracle RDBMS installation and upgrades on different HP UNIX platforms.

-SQL*Net setup and installation for the Client and Server.

-Managed the physical storage space in a database.

-Managed users (created new user names, provided access to database, and supported creating their own objects).

-Monitored the database (sessions, rollback segments, locks) and backup the data.

-Performed database auditing.

-Controlled accessibility of the database, analyzed trace files.

-Provided access to all Oracle tools (Forms, Reports dictionary tables, Oracle supplied Packages).

-Tested and monitored system performance.

-Database tuning.

Application Development

-Developed International News Research Real Time System application using the Oracle Procedural Option and Pro*C.

-Designed Forms Package using Oracle Forms for database search and on-line displaying data.

-Provided dynamic query search, data refresh, and direct accesses to Oracle Book document as on-line help.

Jan.1989-Sep.1993

Oracle Specialist

Yugoslav Chamber of Commerce and Industry

System analysis and development

-Coordinate an ongoing program designed to provide continuous improvements in efficiency and user friendly on line database research. Databases incorporate data of more than 200.000 national firms (general company information, individual and summary product information, classifications, used technology and energy, sales inventory etc.).

-Revised and developed forms (using SQL*Forms and triggers with PL/SQL language, calling one form from other, pop-up windows, using all kind of variables, host call functions...) and reports (using SQL*ReportWriter) on different computer platforms.

-Provided user support at local and one remote location.

Database administration

-Provided database Administration - monitored system performance (rules for speeding queries, create indexes, clusters, calculated values of table spaces for different tables, changed init.ora files, used tables and views in Oracle Data Dictionary).

-Used data transfer operations such as SQL*Loader, Export and Import.

Communication and system support

-Installed and administrate LAN network (create users, network printers, enable file transfer).

-Installed backup system for host - PC under UNIX operating system: create system users, Oracle group and db users, transferred all data and programs from Oracle database and made it ready in the case of accident on main host.

-Transfer of data through EARN/BITNET European Academic and Research Network).

PROFESSIONAL DEVELOPMENT

ExaData Database Machine Administration

Oracle Database 12c: Fundamentals for Devs and SysAdmins

Oracle Access Manager 11g Adminstration

Oracle E-Businsess Suite 11i System administration

Oracle SCG: Oracle 9i

Ryerson University : OO Modeling and Design using Java

Oracle Corporation Canada: Develop Applications with the Procedural Option

Oracle Corporation Canada: Oracle Designer

HN-Bull Training Center: SQL*Plus, Oracle*Forms, Oracle*Reports, DB Administration, Pro*C.

Telemecanique, Paris,CITEF Training Center: PLC programming

EDUCATION

B.Sc.E.E Dipl.Eng – University of Belgrade