Gert Mccarthy Email & Phone Number

Johannesburg, Gp, Za

Florida, Johannesburg

Part of Oracle forms to Java conversion team for the NEXUS / GEXUS Systems at Medscheme.Medscheme administer various Medical fund schemes.Below were some of my main responsibilities:• Analyse the existing forms and assist the Java team with layout and functionality.• Create new tables and change various table to add new columns, triggers, sequences, etc.• Create various PL/SQL packages, procedures and functions to move the code from Oracle forms to the database. Procedures… Show more Part of Oracle forms to Java conversion team for the NEXUS / GEXUS Systems at Medscheme.Medscheme administer various Medical fund schemes.Below were some of my main responsibilities:• Analyse the existing forms and assist the Java team with layout and functionality.• Create new tables and change various table to add new columns, triggers, sequences, etc.• Create various PL/SQL packages, procedures and functions to move the code from Oracle forms to the database. Procedures were also created for shortcoming in the Java environment.• Assist in design architecture for data and security.• Develop the new Application using Angular/Spring to an Oracle database.Currently part of the Enterprise Data Exchange (EDx) team.This is a new Application responsible for all Medical interface files as well as maintainting Provider information. The system comprise of a Security, File transfer, Provider and Clinical module.Below are some of my main responsibilities:• Assist in creating new Oracle database tables.• Writing various business logic in the Oracle database using PL/SQL.• Develop the new EDx Applications using Angular/Spring to an Oracle database.Full Stack Development.All new development mentioned above are done in the latest versions of the following technologies :• Angular (UI)• Spring Boot (Service Layer)• Oracle Database version is 19C Show less

Fairland,Johannesburg

Part of design, development and maintenance team for the SPIF (System for Processing Instalment Finance) System at WesBank. The System was migrated from various mainframe Systems to Oracle on Sun Solaris initially and later migrated to IBM IAX.Below were some of my main responsibilities:• Design, develop and manage all the reporting and interfaces to and from the SPIF system.• Design, develop and manage batch process reporting.• Interfaces: To name a few, processing of financial… Show more Part of design, development and maintenance team for the SPIF (System for Processing Instalment Finance) System at WesBank. The System was migrated from various mainframe Systems to Oracle on Sun Solaris initially and later migrated to IBM IAX.Below were some of my main responsibilities:• Design, develop and manage all the reporting and interfaces to and from the SPIF system.• Design, develop and manage batch process reporting.• Interfaces: To name a few, processing of financial payments from FNB and Hyphen, M&M vehicle pricing updates, debit orders, General Ledger, external Insurance suppliers, other WesBank internal Systems (BI, Collections), Credit Bureaus, HPI, RMB, FNB customer database, various document image stores, etc.• Manage File transfers: All file distributions in and out from SPIF were automated using secure FTP. Also worked on the migration from an in-house SFTP solution to Globalscape running on a clustered Microsoft Server environment.• Design and develop new changes to the batch code for financial and insurance processing.• Design, develop and maintain housekeeping utilities to delete files produced on the Unix database server as well as report and interface data stored in Oracle tables. • Design, develop and maintain customer statements and letters.• Support the daily SPIF batch run.• PDF generation and distribution of statements and letters by eHub. Show less

Selby, Johannesburg

Part of design, development and maintenance team to develop a new EFT (Electronic Funds Transfer) System for BankServ, to migrate their mainframe environment to Oracle 8i on Unix.Below were some of my main responsibilities:• All Oracle Forms, store procedures and triggers.• Use of Oracle Designer to generate and keep configuration control of all Database objects.• Assist in Database Administration and Performance tuning.• Tuning of SQL statements for daily transaction… Show more Part of design, development and maintenance team to develop a new EFT (Electronic Funds Transfer) System for BankServ, to migrate their mainframe environment to Oracle 8i on Unix.Below were some of my main responsibilities:• All Oracle Forms, store procedures and triggers.• Use of Oracle Designer to generate and keep configuration control of all Database objects.• Assist in Database Administration and Performance tuning.• Tuning of SQL statements for daily transaction volumes of plus minus 12 million transactions.• Use of PL/SQL to generate various reports for line printers.• Ensure security and auditing by using Database roles, Forms security and Database triggers.• Establishment of a BI environment using Oracle Discoverer. Show less

Pretoria

Project Management, Design, build and support various solutions for small and medium businesses to simplify administration tasks, serve as point of sale and manage daily activities. I was involved in the following Information Systems:• Configuration management• Maintenance management• Logistic management• Inventory management• Security systemsWas also involved in the migration of the following databases to an Oracle database:• MS Access• C-Tree• D Base

Centurion, Pretoria

Part of analysis, design, development and maintenance team to develop an Integrated Logistic Information System.The System consisted of the following main modules:• Configuration Management• Document Management• Materials Management• Maintenance Management• Inventory Management• LogisticsLater be the project leader for the Logistic Information System above.• The initial project was started using the first Windows environment of Oracle Forms and… Show more Part of analysis, design, development and maintenance team to develop an Integrated Logistic Information System.The System consisted of the following main modules:• Configuration Management• Document Management• Materials Management• Maintenance Management• Inventory Management• LogisticsLater be the project leader for the Logistic Information System above.• The initial project was started using the first Windows environment of Oracle Forms and Reports.• The project later progressed to the latest Developer release available at that time.• Oracle Designer was used as a CASE tool, to model and generate database objects (tables, users, roles, etc). Show less

Pretoria, Gauteng, South Africa

1982 - 1984Qualified as a Radar Technician1985 - 1988Start 5 Air Depot for installing and maintaining advance EW Equipment on Mirage 3, Mirage F1 and Cheetah fighter aircraft.The EW Equipment include:• Radar warning and jamming• Flare and Chaff dispensingI gained experience in the following software due to the testing and maintaining of the various EW Equipment: • Basic• Fortran• Imbedded PL• Pascal• C• Programing of various logic… Show more 1982 - 1984Qualified as a Radar Technician1985 - 1988Start 5 Air Depot for installing and maintaining advance EW Equipment on Mirage 3, Mirage F1 and Cheetah fighter aircraft.The EW Equipment include:• Radar warning and jamming• Flare and Chaff dispensingI gained experience in the following software due to the testing and maintaining of the various EW Equipment: • Basic• Fortran• Imbedded PL• Pascal• C• Programing of various logic arrays.1989 - 1991Assisted in the rollout and maintenance of the Logistical Information System which the Air Force had bought from Paradigm Systems. With the Logistic System I gained experience in C-Tree and Oracle. The Logistic System was first rolled out in C-Tree but converted shortly after to Oracle due to volume in data. Show less

Diploma Datametrics, Information Technology

Ntd Electronics, Radar Technolgy

Matric