Career Summary
Senior Oracle Developer
Wesbank (Pty) Ltd, South Africa 2008 – date
• Optimizing the performance of Oracle applications, using XMLDB to communicate between Java applications for the Credit Online system and the Oracle database
• Analyzing, designing, rewriting and implementing the Securities and Sureties system, including transforming it into an optimized standalone system
• Developing a range of enhancements for financial batch processing, as well as leading maintenance and optimization work
• Delivering a range of projects including interfaces with FNB Online, Wesbank Online, Collections and Third Party Financial Processing, consistently achieving timely and high quality delivery
• Providing strong leadership and direction to the Run The Bank team
Key achievements:
• Successfully redesigning and rewriting interface systems, thereby reducing run times from over an hour to just 11 minutes
• Reducing the run time of DA Extracts from 2 days to 1.5 hours following a rewrite
• Receiving recognition two years in a row as a top achiever countrywide
Database Administrator
Medscheme, South Africa 2000 – 2008
• Holding full responsibility for maintaining the production environment, including migrating databases to the latest versions and applying patch sets
• Consistently achieving demanding service level agreements by improving performance through optimization initiatives
• Proactively troubleshooting any issues within the shortest possible times to ensure system availability and reliability, demonstrating a thorough understanding of front end applications and business structure
• Liaising extensively with end users and developing positive professional relationships across the business
• Maximizing the use of Enterprise Grid Control to manage databases, in conjunction with in-house scripts as necessary, and also using SQLPlus, SQL and PL/SQL to identify and resolve problems
• Contributing significantly as an integral member of the DBA team, and also leading the QA and Training teams
• Developing QA, development and training databases, including implementation, maintenance and customization of all systems
Senior Oracle Developer
TIAA-CREF, USA 1999 – 2000
• Leading the analysis, design and development of a quarterly reporting system, including the generation, tuning and maintenance of the database
• Facilitating the production of statements reflecting investment results, which are both printed and uploaded to a website for user access
• Developing a system to incorporate data from various systems, uploading from flat files and writing to intermediate tables for transfer to the schema at transaction level and rolling up into summary tables
• Creating a monthly and quarterly process to extract data for dispatch to a central printing system, which formats data to produce a final statement
• Developing an exception handler to drive the creation of a parent cell structure to populate the database with new information, to enable the processing of new contracts
Senior Oracle Developer
Ambac Financial Group, USA 1998 – 1999
• Analyzing, testing and setting up an Oracle data warehousing environment for reporting purposes
• Rewriting the Earnings Package to calculate what the company earns based on client premiums
• Developing re-insurance reports using PL/SQL, and creating triggers to update tables automatically
Consultant
Medscheme Pty (Ltd), South Africa 1996 – 1998
• Analyzing, designing and implementing a Third Party Payment Order System and a Workflow Management System
• Developing reports for the membership and claims system, reflecting both financial and non-financial information
Early Career Summary
Software Consultant Standard Corporate and Merchant Bank, South Africa 1995 – 1996
Project Leader Rainbow Chicken Farms (Pty) Ltd, South Africa 1993 – 1995
Systems Analyst Bull Computers SA (Pty) Ltd, South Africa 1991 – 1992
Consultant Computer Software Solutions, South Africa 1990 – 1991
Consultant Titaco (Pty) Ltd, South Africa 1989 – 1990
DP Manager Protea Medical and Laboratory (Pty) Ltd, South Africa 1989
Software Consultant Mobius Group (Pty) Ltd, South Africa 1988 – 1989
Programmer Sasol Ltd, South Africa 1987 – 1988
CAD Drafter Leech Price Associates (Pty) Ltd 1983 – 1986
Qualifications
Certification: Oracle Database 11g: Administration Workshop 2011
Certification: Oracle Database 10g: Administration Workshop 2006
Key I.T. Skills
Hardware: IBM AIX, Hewlett Packard, IBM Mainframe, IBM PCs, OS390, ES7000, Sun Solaris 10
Software: Oracle Application Server 10g, Oracle 7 – 11, Oracle XML DB, Oracle Enterprise Manager, SQL Plus, PL/SQL, SQL Loader, SQL Navigator, Toad, Erwin, Open VMS, Forms and Reports 6.0 – 10g, Designer 2000, Developer 2000, Headstart, Jasper iReports, Progress, Unix, Linux, Windows (98, NT, XP), PowerHouse, MPEX, Cobol, Microsoft Office (Word, Excel, Access), Lotus 123, MSDOS, Wordstar, dBase III+, BASIC, Clipper, CAD
Personal Details
Languages: Fluent English and Afrikaans
