Senior Oracle Consultant
TRUST holding
Total years of experience :18 years, 5 Months
Analyze and debug code + Data migration.
➢ Create a Web services for Oracle Data base.
➢ Design and develop multi-threaded Oracle Form, Report, and PL/SQL database 10g, 11g, 12C.
➢ Writing multiple code and script and ensuring cross browser compliance.
➢ Providing aftercare support for clients on assessing the performance.
➢ Use Dynamic SQL and Execute_Immediate functionality to perform DDL in PL/SQL blocks and procedures
➢ Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
Create PL/SQL packages, standalone procedures, and standalone
functions.
➢ Write complex SQL queries with sub-queries, analytical functions, and
inline views
➢ Use Collections like variable arrays, nested tables
➢ Design and create entity relationship diagrams (ERD) for Oracle based
applications and interfaces.
➢ Manage User Acceptance Testing of new applications and new versions of
existing applications.
➢ Manage the packaging and release of applications to the training, UAT and
production environments
➢ Provide technical and functional direction to our customers in matters of
implementing technology within their business processes.
➢ Manage User Acceptance Testing of new applications and new versions of
existing applications.
➢ Manage the packaging and release of applications to the training, UAT and
production environments
➢ Analyzed, Maintained, performed, and debugged code of general insurance
system.
➢ Design and develop multi-threaded ORACLE database
➢ Provided aftercare support for clients on assessing the performance
Worked on Oracle SQL/PL-SQL 11G
➢ Maintained of existing Oracle registration school and ERP systems. ➢ Suggest improvements on design and functionality ➢ Responsibility of networking servers and help desk ➢ Providing aftercare support for clients on assessing the performance. ➢ Working on Oracle SQL/PL-SQL / Report / forms 10g
➢ Worked on ERP system (HRM, Financial, Sales and Marketing, SCM, Inventory and Purchasing).
➢ Worked on Oracle SQL/PL-SQL / Report / forms 6i AND 9i. ➢ Preparing presentations and keeping clients up to speed with the development process ➢ Developing web code. ➢ Providing aftercare support for clients on assessing the performance.
High School Degree in