Hcm Nell

Senior Oracle analyst-developer with 30+ years' experience across Oracle Database (8i through 19c) in large enterprise environments, spanning healthcare, telecommunications, financial services (investments and vehicle/asset finance), insurance, education, and manufacturing, in both private and public sectors. Strong PL/SQL and SQL skills, with a track record of writing and optimising complex queries, functions, stored procedures, and triggers, and of tuning application performance. Expert in Oracle Forms, with working knowledge of Oracle APEX.

Extensive background in CRM, loan management, financial, and healthcare systems, including replacement of end-of-life systems and ongoing enhancement of production platforms to meet business and regulatory requirements. Strong track record of working directly with business users and management, translating requirements into practical technical solutions, supporting business-critical production systems, improving performance and data quality, and delivering changes through the full development lifecycle.

Core Competencies

Application and systems analysis, design, and development Business requirements gathering and stakeholder management across all levels of an organisation Data modelling, database design, and data quality / data migration (ETL) Complex PL/SQL and SQL development, code optimisation, and performance tuning IT service delivery: change management, incident management, release management, risk management Agile SDLC delivery, from design through testing, implementation, and production support Mentoring and knowledge-sharing within project teams Key Attributes Result-oriented self-starter who works well independently or within project teams of any size. Strong analytical, problem-solving, system-analysis and technical-design capability. Methodical, detail-focused problem solver with strong organisational and communication skills, able to manage multiple priorities under pressure and adapt quickly to new requirements and technologies.

Proactive focus on process improvement, automation, operational efficiency and sustainable solutions. Excellent verbal and written communication, reporting, documentation and presentation skills.

Senior Oracle Developer at Afrocentric Technologies (Medscheme) (2018-10 – Present)

Health administration, managed care & disease management

• Responsible for the full development and production lifecycle for Oracle Forms / SQL / PL/SQL solutions supporting health administration and managed care systems
• Assess technical feasibility and data quality, business and system impact, architect new applications, interfaces, and data entities; produce technical designs and implementation plans
• Develop reusable Forms, SQL, and PL/SQL Package modules, minimising procedural code
• Participate in system and integration testing, code reviews and implementation activities.
• Optimise applications for availability, performance and security and identify automation and business-process improvement opportunities.
• Provide 2nd-level production support: problem resolution, performance/availability/security optimisation, and incident/problem management

Oracle Developer at Western Cape Government — Mobility Department (2024-07 – 2026-07)

Contractor, part-time. Part-time consulting engagement on the Fleetman system, carried out alongside the full-time Afrocentric Technologies role (with Afrocentric's knowledge).

• Designed, developed, and tested Fleetman system changes and enhancements, including BI modelling and ETL for Auctions and Risk Management (Incidents/Events)
• Integrated Fleetman with external systems: Nedfleet, MILES, TMT and TCS (traffic violations), and RTMC (vehicle/driver information)
• Performance-tuned Fleetman.
• Investigated and resolved incidents, performed troubleshooting and supported ongoing system maintenance.
• Assisted with migration of Oracle Forms applications to APEX

Oracle Developer at Taulite (2017-04 – 2018-10)

Contractor (Telecommunications)

• Designed and developed real-time data interfaces between Oracle ERP and BMC Remedy
• Built a data integration application using Oracle APEX
• Evaluated Oracle OBIEE and BI Publisher for dashboards and BI reporting
• Created operational data extracts to monitor real-time and historic mobile network equipment alarms

Senior Oracle Developer at Silica (2016-01 – 2017-03)

Contractor (Financial / Investments)

• Performance tuning and optimization of Oracle SQL/PL/SQL for ad-hoc and scheduled data extracts and reports via SSRS and SAP Business Objects Crystal Reports
• Converted SSRS extracts to Oracle PL/SQL procedures and helped build an improved Oracle/SSIS/SSRS integration framework
• Converted SAP Business Objects Crystal Reports to SSRS
• Maintained and enhanced a custom correspondence management system

Senior Oracle Developer at Wesbank (2002-04 – 2015-12)

Contractor (Banking / Vehicle & Asset Finance). Employment periods: Dec 2012 – Dec 2015 and Apr 2002 – Sep 2011.

• Core member of team that replaced end-of-life COBOL mainframe vehicle finance system with Oracle, optimizing availability and performance
• Redesigned the business and data model
• Responsible for data migration/ETL (design, extraction, validation, load, and verification)
• Redesigned user interfaces and reports
• Owned end-to-end delivery of Oracle Designer / Oracle Forms / SQL / PL-SQL solutions.
• Production support including after-hours/weekend batch support.
• Integrated systems using Web Services and WebMethods
• Contributed to internal and external audits
• Delivered functional/technical training and 1st/2nd-level post-implementation support

Senior Data Analyst at RGA (2012-02 – 2012-11)

Reinsurance — Life

• Extracted, transformed, and loaded data from multiple sources/formats;
• Responsible for creating and maintenance of data loading and transformation templates
• Produced pre/post load summary reports and post-load extracts used for financial modelling
• Made extensive use of Oracle External Tables and Analytical Functions for ETL and data extraction
• Optimized extract queries and adapted processes to changes in input data and regulatory requirements.

Senior Oracle Developer at Telkom (2000-10 – 2002-04)

Telecommunications

• Built a field system to capture and maintain equipment detail against international codes, with periodic data exchange with the USA
• Developed Oracle web functionality using Web PL/SQL and HTML; authored detail and technical design documents

Senior Oracle Developer at Integrated Tertiary Software (1997-10 – 2000-10)

Tertiary education administration software

• Responsible the Finance team's systems and integration with systems outside the team's scope.
• Gathered requirements, scoped and quoted custom/standard software development, and delivered design, programming, and installation for systems in scope
• Responsible for Y2K system changes
• Participated in technical standards and code reviews

Programmer / Systems Analyst at Mittal Steel (1992-01 – 1997-10)

Manufacturing

• Started career on COBOL mainframe systems for production planning, scheduling, and reporting; developed MIS/EIS modules (Pilot Lightship)
• Moved to a production plant to build Oracle-based production support systems, including after-hours standby support
• Converted forms from Oracle Forms 3 to 4.5

Web Development at Private (2004-04 – 2006-07)

Web Development

• Built websites using HTML, JavaScript, and ASP; maintained web databases on MS SQL Server

MBA – North-West University (2001)

B.Sc. – North-West University (1995)

National Diploma – Vaal University of Technology (1991)