PLSQL SQL Programmer

Skills: Advanced programming of SQL and PLSQL
CERTIFIED ORACLE: OCA: ORACLE CERTIFIED ASSOCIATE SQL-PLSQL
SQL Knowledge:

• Retrieve data using select statements.
• Restrict and sort data, conditionals of comparison, logical conditionals, clause ORDER BY.
• Using general and conversion functions, customizing output files.
• Character manipulation functions, functions with dates.
• Function conversions TO_CHAR, TO_NUMBER, TO_DATE, nested functions, and conditional expressions.
• Group functions, AVG, SUM, MAX, MIN, COUNT, DISTINCT keyword, GROUP BY and HAVING clauses.
• Retrieve data from multiple tables with NATURAL JOIN, EQUIJOIN, INNER JOIN (CLUES USING, ON), SELFJOIN, NONEQUI JOIN, OUTER JOIN, CARTESIAN JOIN.
• Creation of subqueries to solve queries, subqueries single rows and multiple rows, use of ALL and ANY in subqueries.
• Selection operators UNION, UNION ALL, INTERSECT, MINUS.
• Data manipulation, INSERT, UPDATE and DELETE statements, TRUNCATE statement.
• Control Transactions COMMIT, ROLLBACK, SAVEPOINT.
• DDL statements for creating and manage tables, CREATE TABLE statement.
• Limitations of NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK CONSTRAIN.
• Creating tables using subqueries, ALTER TABLE, DROP TABLE statements.
• Creating schema objects, TABLES, VIEW, SEQUENCE, INDEX, SYNONYMS.

PL/SQL Knowledge :

• Creating different PL / SQL blocks, block structures, PL / SQL output messages (DBMS_OUTPUT).
• Declaration of PL / SQL variables, use and handling of variables, declaring and initializing variables, literal STRING delimiters.
• Scalar variables,% TYPE attribute, Boolean variables, composite data types: Record and Collection, Host variables (BIND).
• Creation of executable statements, SQL functions in PL / SQL, use of sequences in PL / SQL expressions, data type conversión.
• Nested blocks, scope of variables and visibility, operators in PL / SQL, extract information with PL / SQL, SQL statements in PL / SQL.
• Data manipulation with PL / SQL, INSERT, UPDATE, DELETE, MERGE.
• Handling PL / SQL cursors, implicit and explicit, cursors attributes, Cursor FOR LOOPS, explicit cursor attributes (% ISOPEN,% NOTFOUND,% FOUND,% ROWCOUNT), cursors with parameters.
• LOOP (Basic, WHILE, FOR) control structures in PL / SQL, IF and CONTINUE statements, CASE expression.
• Composite data, RECORDS and COLLECTIONS,% ROWTYPE attribute, associative array structures.
• INDEX BY tables, table INDEX BY methods (EXITS, COUNT, FIRST, LAST, PRIOR, NEXT, DELETE) and records options.
• Handling and type of exceptions, exceptions capture, predefined, undefined and user-defined exceptions, RAISE_APPLICATION_ERROR procedure.
• STORED PROCEDURE creation, procedure, functions, positional notation, named or mixed, parameters and parameter modes, formal and real parameters, parameter types (IN, OUT, IN OUT).
• DBMS_OUTPUT.PUT_LINE subroutine, HOST variables, call, remove, and deploy procedure information.
• Create, invoke and remove stored functions, debug subprograms, mixed notation and named from SQL.
• Creating Package (Specification and Body), Components of a Package, Invoking and Removing Subprograms from a Package.
• Using cursors and associative arrays in Package.
• Use of packages supplied by oracle in the development of applications (DBMS_OUTPUT, UTL_FILE, UTL_MAIL, DBMS_ALERT, DBMS_LOCK).
• Using the UTL_FILE Package with its procedures and functions, UTL_FILE exceptions.
• Using Dynamic SQL, EXECUTE IMMEDIATE statement, Dynamic SQL methods, Dynamic SQL with DML and DDL.
• Execution of PL / SQL anonymous blocks dynamically, compilation of PL / SQL blocks, procedures, functions and Package with Dynamic SQL.
• Using the DBMS_SQL Package with DML and DDL Statements.
• Create standard constants and exceptions
• Perform autonomous transactions
• Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
• Use bulk binding and the RETURNING clause with DML
• Creating Triggers
• Create database triggers
• Manage triggers
• Create triggers on DDL statements
• Create triggers on system events
• Using the PL/SQL Compiler
• Describe the new PL/SQL compiler and features
• Use the new PL/SQL compiler initialization parameters
• Use the new PL/SQL compile time warnings
• Managing PL/SQL Code
• Describe and use conditional compilation
• Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
• Managing Dependencies

Systems general knowledge:

• Analysis and design of structured and object-oriented programming.
• Handling Excel spreadsheet, formulas, charts.
• Handling Office, word, Power Point, win XP, Win 7, Win 8, WIN 10.
• Knowledge of Unix operating system (Solaris, Ubuntu, Redhat), VI editor, DCL programming in VMS VAX system Oracle platform.
• Installing Operating Systems, Win XP, Win 7, Win 8, WIN 10, Unix (Ubuntu), operating systems configuration.
• Installation of Oracle 10i, 11g, 12c Software on Win 7 and 10 and Win XP operating systems.
• VMWare virtual machine installation.

Database knowledge:

• Management of Oracle Database 10g, 11g and 12c.
• Creating Users (Schemas) Oracle Database.
• Creating, Modifying, Deleting Database Objects (Sequences, Tables, Synonyms, Views)
• Permission assignment to System users.
• Development Environments: SQL Developer, SQL*Plus, TOAD.  

Experience:
Company                               BR&JC INTERNATIONAL N.V.
Start Date                              MAR-2014
End Date                               MAY-2018
Withdrawal Cause                Move To Argentina   
Country                                 Curacao         
Position                                 Senior Analyst-Programmer Oracle
Functions and Resposabilities:    

• Development of SQL Script for optimization of search processes, insertion, deletion and updating of data in the database.
• Creation of anonymous blocks, procedures, functions with PL / SQL for the execution of processes in the database.
• Handling of SQL Developer tools, TOAD and development under SQL * Plus environment.
• Review of documentation and information gathering procedures for the preparation of the different diagrams for the analysis and design of projects.
• Designing Entity - Logical and physical relationship.
• Execution of both individual and integral tests of the different developments and elaborated forms.

Company                               RBC Comunications Systems C.A
Assigned to Vice-Presidency of Sistemas Movistar.
Start Date                              FEB-2009
End Date                               ENE-2014
Withdrawal Cause                Move to Curacao
Country                                 Venezuela      
Position                                 Senior Analyst-Programmer Oracle
Functions and Resposabilities:    

• Design, Development and Programming of systems under ORACLE platform, SQL database manager, PL / SQL programming, SQL PLUS, package creation and improvements, procedures and PL / SQL functions, optimization Querys, PL / SQL, Suite 10g, TOAD tool management. Turning on and off triggers, contrainst, structure changes in triggers, creation and modification of tables, creation of synonyms, creation of indexes, handling of Oracle Suite Forms, creation and improvements of ways to update the Database through interfaces.
• Knowledge of UNIX, shell scripts (Basic), managing editor VI.
• Preparation of scripts (Windows, DOS Console (CMD)) for different Backups and Restores the Database with the PostgreSQL handler.
• Creation of the Database under PostgreSQL Version 9.0 environment.
• Improve and provide solutions for improvements in the different phases of the requirements and projects in execution and to execute for verification and compliance of its standards, complying with CMMI and COBIT methodology, allowing to carry out a better detailed control until its effective completion.
• Preparation of procedures and functions (Package) for the execution of processes in the project database CLUB MOVISTAR.
• Modifying the Database, modifying tables, adding and deleting fields, modifying records (INSERT, UPDATE, DELETE) and queries (SELECT). (DDL, DML)
• Elaboration of control instruments in the different stages of requirements and projects (Requirement, Design, development and control of change).
• Review of documentation and information gathering procedures for the preparation of the different diagrams for the analysis and design of the CASH FLOW project.
• Designing Entity - Logical and physical relationship with Visio and Oracle Data Modeler tools.
• Review of the development procedures and elaborated forms for the verification of standards and fulfillment of the request of the end users.
• Execution of the different tests both individual and integral of the different developments and elaborated forms.

Company                               OLTP, Voice Systems, C.A.
Start Date                              NOV-2005
End Date                               NOV-2008
Wihtdrawal Cause                End of Contract
Country                                 Venezuela      
Position                                 Oracle PL / SQL-SQL Programmer Analyst
Functions and Resposabilities:    

• Automation of all prepayment requirements and improvements to existing procedures, under Oracle platform and SQL and PL / SQL database manager.
• Programming PL / SQL, SQL PLUS, Package elaboration and procedure optimization (DML), Functions in PL / SQL, PL / SQL blocking (select, delete, update, insert). 

Company                               IST, Consultores C.A.
                                               Assigned to PDVSA Production, Caracas
Start Date                              ABR-2000
End Date                               DIC-2004
Withdrawal Cause                End of Contract
Country                                 Venezuela      
Position                                 Analyst Programmer / Technical Support
Functions and Resposabilities:    

• Update of the gas drilling database on Block E south of the lake. Improvements in the EPICS and TSO environment loading system VAXIE, ORACLE.
• Programming VAX and TSO system, Erosion configuration, design and programming of different types of drilling of different wells according to coordinates, configuration and scheduling of well diversion load, Oracle / EPICS environment.
• Digitalization of the different maps and locations of the different wells (Lagunillas), updating of the extracted data of the area in the system and elaboration of the drilling diagrams and their different advances. Loading and updating coordinates and progress of the SOUTH LAKE BLOCK gas project.
• SQL plus management, UNIX (Solaris), Excel, Word, Power Point, Macintosh Tools, Intergraph, Microstation digitizing tables, LANDMARK Seismic Stations.