Michael Sello Mapela
Senior Database Developer - Oracle & PostgreSQL Technical Consultant - BI Reporting Specialist
Akasia,Gauteng
Summary
Technical Consultant supporting the Debt Manager collections platform across technical diagnostics, custom ETL design, and reporting delivery. Builds and maintains operational and analytical outputs in MS SSRS and AWS QuickSight, while leading data migration and system debugging work. Partners directly with clients to translate technical requirements into stable finance-system solutions.
Overview
2
2
Languages
1
1
Certification
25
25
years of professional experience
Work History
Technical Consultant
C&R Software
03.2018 - Current
- Resolve System issues through diagnostics and application troubleshooting.
- Design and build Pentaho ETL workflows for data migration, profiling, cleansing, and integration.
- Develop operational and analytical reports in MS SSRS and AWS QuickSight for client reporting needs.
- Lead data migration and system debugging across Debt Manager releases and production support activities.
- Partner with clients on technical requirements, solution design, and specifications for custom enhancements.
- Support integration testing, user acceptance testing, and system configuration for delivered changes.
Oracle Technical Consultant
EQPlus Technologies
07.2017 - 12.2017
- Resolved data issues per sprint across Oracle migration and integration activities.
- Managed full data lifecycle work, including profiling, analysis, mapping, migration, and integration for Oracle systems.
- Automated data loading through SQL*Loader and concurrent programs to support repeatable Oracle batch processing.
- Customized Oracle Contracting and eSourcing workflows, and migrated contract layouts, sections, and clauses through Oracle APIs.
- Delivered XSLT customizations to company specifications, aligning outputs with Oracle interface requirements.
- Produced technical documentation under Oracle AIM methodology, covering CV10, CV20, CV40, and MD70 deliverables.
Senior Applications Developer / Data Analyst
State Information Technology Agency (SITA)
02.2011 - 02.2017
- Maintained System uptime for reporting and ERP support services as per service level agreements through responsive issue handling and release oversight.
- Reduced incident resolution time by 80% by triaging ERP technical calls and coordinating change requests before production.
- Built Oracle ERP ETL pipelines into the Oracle Data Warehouse, designed star schemas, and delivered Pentaho dashboards and reports.
- Led the Oracle EBS Procurement Management Module implementation at National Treasury.
- Developed migration scripts with Oracle APIs to extract, cleanse, and load data from diverse source systems.
- Supported the internet-based iSupplier Registration Portal in Oracle ADF, handled data cleansing, developed reports, and investigated system errors.
Oracle Technical Consultant
BPLC Management Consultants (Pty) Ltd
01.2008 - 10.2010
- Maintained/maximized system uptime across Oracle EBS environments through proactive administration and backups.
- Installed Oracle EBS using RapidWiz 11.5.10.2 and configured core environment components for delivery.
- Managed system and application administration, backups, and instance cloning for Oracle EBS support.
- Monitored Unix performance and applied AD tools for configuration and patching activities.
- Transformed and loaded legacy data into Oracle EBS Install Base through interfacing and SQL*Loader.
- Integrated GIS and other systems with Oracle Advanced Queues and APIs, and supported a CRM implementation for Ekurhuleni Municipality.
Senior Oracle Developer
Discovery Health
04.2007 - 12.2007
- Reduce incident resolution time through targeted fixes, interface support, and production follow-up.
- Resolve identified bugs per sprint in Oracle application changes while maintaining stable delivery for downstream users.
- Developed Oracle system modifications to meet changing business requirements and improve application functionality.
- Maintained the in-house application interface with LOA systems, supporting reliable data exchange and ongoing compatibility.
- Performed data fixing and extraction for management reporting, improving the accuracy and availability of reporting inputs.
- Wrote technical specifications and clarified requirements for Oracle modifications before development and deployment.
- Supported data movement and system configuration tasks to keep Oracle processes aligned with reporting and interface needs.
Database Specialist
Waymark Infotech
03.2006 - 03.2007
- Performed data profiling and normalisation for the Firearms Register system to improve record consistency.
- Modelled interface systems in Oracle Designer to support data migration and integration design.
- Configured Oracle Streams Advanced Queues for data migration and transformation workflows.
- Built a data transformation engine on Oracle 10g using PL/SQL and XML/XSLT.
- Compiled process flow and data transformation documentation to support implementation handoff.
Oracle Developer
Arivia
10.2005 - 03.2006
- Developed Oracle back-end objects, including triggers, procedures, and functions, to extend application behavior.
- Maintained Eskom's fleet management system by fixing Oracle Forms defects and supporting ongoing user issues.
- Drafted enhancement notes from gap analysis to support requirements gathering, solution design, and technical specification writing.
IT Developer
Fintech
12.2004 - 09.2005
- Supported uptime for Oracle Forms & Reports 6i screens and reports through timely fixes and validation.
- Built new Oracle Forms & Reports screens and reports to extend finance workflows and improve user access to data.
- Developed and maintained stored database objects, including types, procedures, and triggers, using PL/SQL and SQL.
- Documented system behavior and error patterns to support troubleshooting, knowledge transfer, and cleaner technical analysis.
- Part of standby to attend to urgencies during system and application deployments
Oracle Programmer
SITA
06.2001 - 11.2004
- Build web page reports using PL/SQL data cartridges for the BI website.
- Develop PL/SQL initial load programs to populate database tables from diverse mainframe systems.
- Create PL/SQL reports for the South African Police Service criminal administration system.
- Develop PL/SQL data cleansing routines and apply performance tuning to improve database processing.
- Perform quality assurance across PL/SQL deliverables to support reliable data processing and reporting.
Education
National Diploma - Mechanical Engineering
Tshwane University of Technology(Technikon Northern Gauteng)
12-1998
Matric - Afrikaans, English, Mathematics, Physical Science, Geography, Biology, Tswana
Mabopane High School
Mabopane01-1993
Skills
Oracle (PL/SQL development, administration, performance tuning)
PostgreSQL
MS SQL Server
Oracle Forms & Reports
Oracle Application Development Framework (ADF)
MS SSRS
SQL*Loader
Oracle APIs
Advanced Queues
XML/XSLT
Pentaho (data modelling, ETL, dashboards)
Oracle E-Business Suite (EBS) technical administration & customisation
Data migration, profiling, mapping, cleansing & integration
Data modelling (star schemas, ERDs)
ETL design and implementation
Interface design and implementation
Requirements gathering
Technical specification writing
Solution design
Integration testing
User acceptance testing
Production support
System configuration
Git version control
Accomplishments
- Successful Debt Manager application deployment for various clients(Entercard, Nedbank, Lloyds)
- Core team member on the successful Customer Relationship Management module implementation at Ekurhuleni Municipality
- Core team member on the successful Procurement Management module implementation at National Treasury
- Awarded a merit award and certificate in the Youth Business Education Programme as a top achiever
Certification
Oracle Certified Associate (OCA)
Timeline
Technical Consultant
C&R Software
03.2018 - Current
Oracle Technical Consultant
EQPlus Technologies
07.2017 - 12.2017
Senior Applications Developer / Data Analyst
State Information Technology Agency (SITA)
02.2011 - 02.2017
Oracle Technical Consultant
BPLC Management Consultants (Pty) Ltd
01.2008 - 10.2010
Senior Oracle Developer
Discovery Health
04.2007 - 12.2007
Database Specialist
Waymark Infotech
03.2006 - 03.2007
Oracle Developer
Arivia
10.2005 - 03.2006
IT Developer
Fintech
12.2004 - 09.2005
Oracle Programmer
SITA
06.2001 - 11.2004
Matric - Afrikaans, English, Mathematics, Physical Science, Geography, Biology, Tswana
Mabopane High School
National Diploma - Mechanical Engineering
Tshwane University of Technology(Technikon Northern Gauteng)
Key Achievements
Awarded a merit award and certificate in the Youth Business Education Programme as a top achiever
Education & Certification
- Oracle BI 11g R1: Building Repositories Ed 2
- Introduction to Java