Senior Oracle Developer
Liberty
Total years of experience :17 years, 2 Months
Summary
Documented existing procedures/packages within the Lifestyle system in order to learn and to make maintenance more productive.
Member of the IRI (Insurance Risk Insights) Team which was a team who developed the IRI package of code. This code was for the Actuarial department which enabled them to gather more experience into past events to help predict the future. This was based on Movements/Alterations, Filters, Time Dependent Weightings, Decrements etc
Created Routines to extract the Demographic information as well as the Movements for a particular period in time for the Actuarial department.
Traced through procedures and packages in order to explain to Actuarial how certain packages derived certain values.
Updated packages by adding more validation.
Created Routines to match Movements to Claims Payments to Claim Accounts.
Packaged routines which mapped Claims Payments to transactions.
Maintained and modified existing packages within the Lifestyle system.
Liased with Actuarial to create new packages to deliver information to be imported into prophet.
Liased with Business Users to create System Specifications for changes required to the LifeStyle system.
Cardinal Insurance Management Systems (CIMS3) Senior Oracle Developer Aug 2011 - Dec 2011
Summary
• Liaised with the business in order to determine what their needs were for various parts of the system.
• Drew up System Specifications as per meetings with the End users.
• Created Batch routines which maintained the Policies.
• Continuous optimization of Batch routines as the database grew in size.
• Continuous optimization of the Database.
• Performed Minor DBA tasks such as table creations, user creation, triggers, user spaces, database owners and database creation.
• Maintained the New system.
• Continuous meetings to update system as the business changed which required New System Specifications to be drawn up.
• Liaised with BA's and end users to determine impact of updates and or changes as well as modifications to system.
• Performed updates to existing system.
• Was involved in end user testing, modifications and implementation.
Tial Technologies Senior Oracle Developer Feb 2008 - Jul 2011
Summary
• Attended Management meetings to discuss problem areas within the team and to communicate what the team's progress was on certain tasks. Objectives were set for the team in this meeting and daily progress updates were given to other Managers and Directors.
• Would attend meetings with Clients to discuss Outstanding Development tasks and prioritise outstanding issues.
• Implemented Buddy testing between developers prior to all new functionality being tested by the Business Analysts.
• Create Deployment Packages of the New Release for Various clients of the System. A new Release of the System would be made available each quarter which would then incorporate large development tasks as required by the various clients.
• Facilitated the testing and creating of 'hot fixes' for Clients who might receive Production Errors between Releases.
• Create Release Notes for the Release which went out each quarter. Created a General version of the Release notes which would be applicable to All Clients and then would pull reports based on work done for a particular client from the Change Request System.
• Log Client Requests on the Change Request System and assign a Developer and an appropriate due date to each task.
• Would assist each member of my Team wherever he needed help or guidance when working on particular tasks where their knowledge of the System was insufficient.
• Maintained and supported the Existing system.
• Maintained and supported Clients who had requested or received the quarterly releases.
• Managed the New Development as per the Client request logged on the Change Request System for the quarterly releases.
• Did large portions of development as well for the quarterly releases.
• Assisted with the Installation of the 'hot fixes' as well as the quarterly releases at clients to ensure transparency of upgrade.
• Created Source Backups for each new version for all of the controls in the System
• Liaised with BA's and end users to determine impact of updates and or changes as well as modifications to system.
• Was involved in end user testing, modifications and implementation.
Innovation Maven (Investec Insurance Brokers) Oracle Developer Oct 2007 - Feb 2008
Summary
• Liaised with the business in order to determine what their needs were for various parts of the system.
• Drew up System Specifications as per meetings with the End users.
• Created Batch routines which maintained the Policies.
• Continuous optimization of Batch routines as the database grew in size.
• Continuous optimization of the Database.
• Performed Minor DBA tasks such as table creations, user creation, triggers, user spaces, database owners and database creation.
• Maintained the New system.
• Continuous meetings to update system as the business changed which required New System Specifications to be drawn up.
• Liaised with BA's and end users to determine impact of updates and or changes as well as modifications to system.
• Performed updates to existing system.
• Was involved in end user testing, modifications and implementation.
Oracle Developer October 2005 - February 2006
Summary
• Was part of a team that developed a Short Term Insurance System (Insight Maven)
• Liaised with the business in order to determine what their needs were for various parts of the system.
• Drew up System Specifications as per meetings with the End users.
• Developed new reports using Crystal Reports.
• Created Batch routines which maintained the Policies.
• Continuous optimization of Batch routines as the database grew in size.
• Continuous optimization of the Database.
• Performed Minor DBA tasks such as table creations, user creation, triggers, user spaces, database owners and database creation.
• Maintained the New system.
• Continuous meetings to update system as the business changed which required New System Specifications to be drawn up.
• Liaised with BA's and end users to determine impact of updates and or changes as well as modifications to system.
• Performed updates to existing system.
• Was involved in end user testing, modifications and implementation.
Discovery Life Oracle Developer Mar 2006 - Aug 2007
Oracle Developer (Data Fix Team) May 2006 - August 2007
* Was Senior Developer in a team which maintained Discovery Life’s systems.
* Gave instructions through to the DBA with regards to table creation, index maintenance and triggers etc
* Wrote PL/SQL routines in order to create data history.
* Optimised existing PL/SQL routines in order to achieve better performance
* Wrote Packages in order to maintain data in the background.
* Wrote scripts, procedures, functions and packages to achieve data integrity.
* Wrote routines to check whether business rules were being maintained throughout the system.
* Wrote Oracle routines to call java classes in order to communicate between the Life and Health Databases with regards to Vitality etc
* Wrote specifications for new procedures within the system as per the BA requirements.
* Was involved with testing, implementation of work into the production environment.
* Wrote Data Conversion routines.
* Liaised with end users to determine functionality required and performed enhancements and or new functionality within the system.
EDS: Sage Life
Oracle Developer February 2005 - September 2006
Summary
• Maintaining existing systems.
• Perform reviews on new projects.
• Perform QA on new projects.
• Liaise with client in order to determine business needs and or requirements and turn those needs into System Specifications for the developer.
• Check that all new code conforms to Company Standards
• Perform System Demonstrations of new code to client/business.
• Take ownership of 5 Production Systems namely Production Life System, Workflow and new Business Workflow systems as well as the Internet and Intranet systems.
• Provide Technical Support to Junior Developers.
Commercial International Life Insurance (CIL - Cairo) (Maven) Oracle Developer Jan 1999 - Jul 2004
* Was Lead Developer of the development team to install a new Life Insurance Package.
* Was responsible for a team of 7 developers.
* Had to determine developers’ strengths and assign work to them in accordance with their strengths.
* Liaised with the business to determine their business flows and procedures.
* Liaised with end users to determine user requirements.
* Drew up System Specifications as per the user requirements.
* Customised the package specifically for the market and company required.
* Liaised with both the Operations Manager and the Managing Director to Design a new Employee Benefits System.
* Determined with the help of the Operations manager what the Business flows should be within the Employee Benefits System.
* Determined the various sections to be designed within the Employee Benefits System.
* Liaised with the various departmental heads within the company associated with the various identified sections within the Employee Benefits System.
* Drew up Systems Specifications to reflect the various sections.
* Lead (and was part of) the team that developed the various sections within the system as per the Systems Specifications.
* Identified various milestones within the various sections under development.
* After the completion of each milestone, organised a demonstration of that section of development to the
relevant departmental heads in order to obtain feedback.
* Documented the feedback obtained from each demonstration and relayed the information back to the relevant developer.
* Assisted the developer with the feedback.
* Drew up test cases for the functional testing which occurred after all development had been completed on the Employee Benefits system.
* Assisted in compiling a test plan for the Employee Benefits System.
* Fixed all errors, which had come up during the Functional Testing.
* Handed the Employee Benefits System over to the Business for User Testing.
* All documented bugs, which occurred during User Testing, were assigned to the relevant developer and the problems were resolved.
* The Employee Benefits System was then handed over to the business for Migration into Production.
* Liaised with the Business with regards to all new modifications and or enhancements to the Employee Benefits System.
* Drew up all Systems Specifications with regards to the new modifications and or enhancements.
* Developed the change required to the system or delegated it to the relevant developer.
* Liaised with the relevant Departmental Heads in the company in order to determine what kind of output they would expect from both the Employee Benefits System as well as the Individual Life Insurance System.
* Determined which were online reports and which were batch reports.
* Drew up Systems Specifications with regards to reporting required.
* Developed new and customized existing reports within the system as per the System Specifications.
* Documented parts of the system.
* Ongoing maintenance was performed on the existing system.
* Liaised with the finance department to obtain the Business flow and requirements for an improved Accounting Module as well as a Switching and Redirection Module.
* Drew up Systems Specifications with regards to the improved Account Module as well as the Switching & Redirection module.
* Developed both modules.
* Functional testing was performed on both modules.
* Both Modules were accepted and Migrated into Production.
Arab Insurance Group (ARIG - Bahrain) (Maven) Oracle Developer Apr 1998 - Dec 1998
* Was part of a team that developed a New Life Insurance System
* Liaised with the business in order to determine what their needs were for various parts of the system.
* Drew up System Specifications as per meetings with the End users.
* Developed new reports using Crystal Reports.
* Created Batch routines which maintained the Policies.
* Continuous optimization of Batch routines as the database grew in size.
* Continuous optimization of the Database.
* Performed Minor DBA tasks such as table creations, user creation, triggers, user spaces, database owners and database creation.
* Maintained the New system.
* Continuous meetings to update system as the business changed which required New System Specifications to be drawn up.
Metropolitan Life New Business Developer Jan 1996 - Mar 1998
* Working under a team leader and was responsible for developing and testing of modules which were then implemented as their New Business System. Also the maintenance of these modules.
* Liaised with the users in order to determine what the business requirements were for the system.
* Met with Senior Business and Systems Analysts who gave us System Specifications.
* Was part of a team who created a New Business System using Key Assemble.
* The New Business System was a Client/Server Application which made use of 3 Tiered approach.
* Converted the New Business System from Key Assemble into Visual Basic 5.0
* Created company specific Ocx’s for the system.
* Created adhoc reports using Crystal Reports.
* Created and was responsible for maintaining the Needs Analysis System.
* Maintained the New Business System.
Information Technology Cape Technikon 1993 - 1996
INSTITUTION DATE Matriculation Fairbairn High School, Cape Town • English • Afrikaans • Mathematics • Accountancy • Physics • Biology 1992