Maleka Sipho

I have strong knowledge of Java, Oracle SQL, XML, JSON, Oracle APEX, Oracle ADF and Oracle PL/SQL. I have worked on web development using HTML, CSS, JavaScript, PHP, Bootstrap and jQuery and mobile development using Eclipse and Android Studio for android applications. I also have knowledge of C and C++. I have both experience in OLTP and OLAP environments in retail and insurance as well as experience in both Linux and windows operating systems.

TIA Oracle Developer - Old Mutual Insure

(2023-10 - 2024-09)

• PL/SQL, Oracle Forms, Oracle DB (on AWS), SVN,
• Control J, and WinSCP
• Supporting the TIA environment
• Adding new fields and functionality to the forms
• Creating new customer forms
• Fixing bugs on the existing Oracle dB objects and
• Creating new Oracle DB objects
• Working on Agile environment

PL/SQL Developer - Zensar (client Liberty)

(2021-12 - 2023-05)

• Operational support
• Doing morning checks on the DB
• Fixing clients' documents
• Investigating the root cause of errors.
• Designing client’s documents using ISIS Papyrus designer
• Doing morning checks on the staging tables to check if the data is correct.
• Writing queries to extract data for the documents.
• Working in an Agile environment.
• Fine tuning the queries for better performance.
• Unix
• Putty.

Developer - Pepkor IT

(2021-07 - 2021-11)

• Operational support
• Handling day to day queries from the business
• Fixing production errors
• Investigating the root cause of errors.
• Do the necessary code changes.

Analyst Programmer II - Woolworths

(2019-03 - 2021-06)

• Oracle SQL
• Oracle PL\SQL
• Oracle APEX
• Automic automation
• Unix
• Team Foundation Server (Version Control)
• Developing stored procedures, functions, triggers, cursors, packages, and types.
• Creating dynamic SQL queries for extracts and reports.
• Maintaining, enhancing, and supporting Production and UAT environment.
• Fine tuning SQL queries on procedures and reports for better performance.
• Makes programming changes, within technical level of competence, to correct bugs ensuring high levels of quality are maintained.
• Writing PL/SQL scripts for debugging and improving business processes.
• Adding missing indexes on tables for better performance.
• Delivering technology solutions that meet business requirements.
• Assisting junior programmers
• ETL process, getting data from other system, transform it and load it to other systems.

Oracle PL/SQL Developer I - Pepkor IT

(2017-01 - 2019-02)

• Developing stored procedures, functions, triggers, cursors, packages, and types.
• Creating dynamic SQL queries for extracts and reports.
• Maintaining, enhancing, and supporting the Production and QA environment.
• Fine tuning SQL queries on procedures and reports for better performance.
• Creating and designing Jasper Reports.
• Generating XML and JSON data using SQL and PL/SQL for integration.
• Creating XSLT for transforming XML data to meet requirements of other systems.
• Creating APIs for Near Real Time integration for WS02 integrator.
• Makes programming changes, within technical level of competence, to correct bugs ensuring high levels of quality are maintained.
• Writing PL/SQL scripts for debugging and improving business processes.
• Designing data models on SQL Developer.
• Adding missing indexes on tables for better performance.
• Delivering technology solutions that meet business requirements.
• Using JDeveloper (Oracle ADF) to investigate front end production issues.

Software Developer Intern - Pepkor IT

(2016-01 - 2016-12)

• Learning retail processes and merchandise systems.
• Manual testing and automation Testing using Oracle Application Testing Suite (uses Java).
• Creating jasper reports on iReport and Jaspersoft using SQL queries.
• Developing stored procedures, packages, triggers, and types on SQL Developer using PL/SQL.
• Working on Oracle database 11g. Creating and maintaining Autosys jobs using Putty terminal (uses Unix commands).

PG Diploma - Software Development - University of the Western Cape (2015 - 2015)

BSc - Computer Science - University of Limpopo (2011 - 2014)