Information Systems Pl/Sql Developer

Essau Kapfunde, Applications Developer Analyst (PL/SQL)

BSc Information Systems (Computer Science and Information Systems)

Crewe, CW1 4AR, Tel: +440********** Email: ********.*@*****.***

Professional Summary

Expert in application support analysis with more than fifteen years of experience in the field. Experienced Oracle PL/SQL Developer with strong database management, query optimisation, data modelling and ETL data retrieval query writing skills. Committed to providing a pleasant experience for business application users. Excel at working with PL/SQL and Oracle and MySql databases on Windows OS. Able to keep a level head even when a problem or user is more difficult than initially expected. Patient with my users. Critical and analytical thinking skills. Excellent communication and interpersonal skills. Dedicated team player willing to collaborate with co-workers to fix problems and complete projects in a timely manner. Willing to learn new technologies required in my role.

Skills

Expert in PL/SQL, queries, procedures, triggers, functions, packages and Oracle forms and reports.

Ability to design, develop and administer Oracle and other relational database structures.

Creating database objects, and in data loading and ensuring data integrity and performance.

Excel at solving complex problems by identifying the issue and developing and implementing a solution.

Able to identify and resolve errors and issues in the PL/SQL back-end and database processes.

Strong in optimizing SQL queries and writing SQL scripts to enhance database performance and efficiency.

Ability to create data models to support application development and database design.

Experience in identifying and resolving performance issues, such as indexing and partitioning.

Strong communication and inter-personal skills allow me to discuss complex issues with co-workers and explain technical jargon in an easy-to-understand way for customers.

Change management and version control to manage application and script releases.

Creative and analytical thinker able to come up with a wide variety of solutions to the same problem.

Good time management ensures I finish projects by associated deadlines even if I have multiple tasks going on at the same time.

Business systems analysis and requirements gathering (User interviews and workshops).

Data migrations from legacy systems to new application databases.

Writing applications integration and ETL scripts for data analytics.

Applications configuration, implementation and daily user support

Work Experience

Group Systems Analyst and Development Officer, Imara Capital - April 2008 to May 2023

Systems analysis and user requirements gathering translating to efficient business solutions.

Documenting technical specifications, data models and specifications.

Designing and implementing database structures such as tables, views and indexes.

Developing data manipulation, validation and reporting scripts using PL/SQL.

Troubleshoot software and applications for all customers to better understand how to help them use the programs efficiently.

Performance monitoring and develop scripts to optimise databases performance.

Troubleshoot, identifying and resolving database performance issues and solutions.

Conducting unit testing and debugging to ensure functionality and accuracy of PL/SQL code.

Writing ETL PL/SQL scripts for data analytics using Oracle discoverer.

Implement improvements to reduce the bugs and common problems had by users.

Participating in database reviews and maintenance and recommend improvements.

Configuration, implementation and support of applications.

Design software applications training programs, procedure and technical manuals for employees so they will be better equipped to help the end users.

Systems Analyst Developer (Systems and Databases),Zimpapers Group - April 2004 to March 2008

Design software applications training programs for employees so they will be better equipped to help the end users.

Systems analysis and user requirements gathering.

Logical and physical database designs and Oracle database administration.

Applications developments using Oracle forms, reports and PL/SQL.

Troubleshoot software and applications for all customers to better understand how to help them use the programs efficiently.

Applications testing and implement effective change management.

Lead teams of three developers to develop and test business applications.

Configuration, implementation and support of applications.

Train users on the applications, upgrades and produce technical and user manuals.

Systems Analyst Programmer, Reliant Computers - 2000 to March 2004

Systems analysis and user requirements gathering.

Applications development using Oracle forms, reports and PL/SQL.

Applications testing.

Additional Skills

Management and leadership, high level communication and interpersonal skills. Team player. Analytical thinking and problem solver. User management at all levels. General IT support Microsoft Exchange, LAN. Domain management. Project management. User training. Microsoft Excel and word. I take time to learn other programming languages like C#, python and tableau. I am developing a lot of interest in data analytics especially Power BI which I take time to learn, understand practice now and again.

Hobbies and interests

During my spare time you might find me doing oil change on my car as I like it DIY on small issues even repairing electricals at home. Doing gardening, trimming my lawn and hedges. I am involved in community development projects where I double as secretary and treasurer. Recycling IT equipment for the under privileged.

Contact this candidate