Professional Summary:

• I am a Senior Oracle Certified Developer with more than 16 years of extensive experience in support, maintenance and development of Oracle based information systems client/server and web environments for financial, health, insurance, logistics, government and education industries.
• I have extensive experience in all phases of SDLC Software Development Life Cycle . Oracle RDBMS 7.3.4/8i/9i/10g/11g/12c, Advanced skills in Oracle Developer Tools such as SQL and PL/SQL, Forms Builder 4.5/2000/6i/9i/10g, Reports Builder 2000/6i/9i/10g, HTML and CSS. ETL process using Kettle 4.2 / 5 Pentaho , SSIS - Microsoft Visual Studio 2010/2012, and Business Objects. Crystal Reports.
• Oracle applications tuning and Unix shell scripting experience. Goal and team oriented with excellent interpersonal skills and a Bachelor's Degree in Computer Science and Postgraduate degree in Database Development, Data Warehousing and Business Intelligence.
• Please let me know if this position is available and contact me at your earliest convenience. Thanks. Nelson Rodriguez Senior Oracle Certified Developer PL/SQL Oracle Certified Associate

TECHNICAL SKILLS

• Languages: SQL, PL/SQL, JavaScript, CS, HTML.
• Database: Oracle RDBMS 7.x/8i/9i/10g/11g/12c SSIS.
• Development Platforms: Oracle Forms 4.5/6i/9i/10g, Oracle Reports 2.5/6i/9i/10g, SQL Plus, TOAD, JDeveloper, Oracle Designer 6.0/9, SQL Navigator, Oracle Enterprise Manager, SQL Loader, TOAD, SQLTools and Visual Basic 3.
• Application Servers: Oracle Application Server OAS 10g.
• Kettle 4.2/5 PDI Pentaho
• SSIS - Microsoft Visual Studio 2010/2012
• Crystal Reports.
• Operational Systems: Windows NT/200x Server/XP/Vista , Unix Solaris and Red Hat Linux.
• Java exposition
• Tortoise, Subversion, GIT, Jira
• Methodologies: CMMI 3.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Consultant

Responsibilities.

• ETL Process, using SSIS. Microsoft Visual Studio 2010/2012 .
• Development and implementation of ETL process for Web Redesign Drupal . Write DB applications in order to produce XML files from Oracle data sources. Cron jobs.
• Extraction and create report files for Campus Solution Peoplesoft .
• Modify Oracle data base objects to solve issues in Admission process in Graduate School Education. Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 11g/12c.
• Write reports for Admission Crystal Reports
• Tools and Environment: Oracle 11g/12c, Oracle Enterprise Manager, PL/SQL, Toad 11, Unix, WinSCP, Putty, Aventail, GIT, SQLTools 1.6, ExamDiff Prof, Crystal Reports, Jira, SSIS - Microsoft Visual Studio 10 /12

Confidential

Senior Oracle Developer

Responsibilities.

• Development and implementation of Oracle forms 10g for call center, enrollment broker, letter process, eligibility process, text message, medical, dental, and perinatal.
• Development and implementation scripts for evaluation rules enrollment broker process.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 11g.
• ETL process using Kettle 4.2 Pentaho PDI . Development, implementation and enhancement of Kettle scripts. Create of kettle job to Load and validate daily and monthly big files, for medical, dental, eligibility area.

Tools and Environment: Oracle 11g, PL/SQL, Oracle Forms 10g, PL Sql developer All Around , Unix, WinSCP, Putty, Aventail, SQLTools 1.6, Kettle 4.2. Pentaho PDI , ExamDiff Prof, Lotus Notes.

Confidential

Senior Oracle Developer

Responsibilities:

• Development and implementation of SQR 8.3 routines to populate tables used for reporting purposes.
• Development and implementation of SQR 8.3 Scripts to create multiples reports tabular, group above and matrix in PDF and Excel format, running in Batch mode or on-demand, using Hyperion SQR Developer 8.3.2.
• Setup SQR Reports to be launched by Appworx 6 - Batch Server.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 10g.
• Design, development and implementation of several screens using Oracle Forms 6i and reports using Oracle Reports 6i.
• SQL Tuning process on complex queries and translate into People Soft SQR 8.3 scripts
• End User support for applications developments.

Tools and Environment: Oracle 10g, Oracle Enterprise Manager, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, SQL Navigator 6.0, SQL Plus 10.2.0.1.0, Datastage, HTML, Unix, Red Hat Linux, FTP and SQLTools 1.6, People Soft SQR 8.3, Hyperion SQR Developer 8.3.2, Appworx 6, ExamDiff Prof and Toad Data Modeler 3.

Confidential

Senior Oracle Developer Project Leader

Responsibilities:

• Development and implementation of ETL routines and Unix shell scripts to populate temporary tables used for reporting purposes from the datawarehouse.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 10g.
• Design, development and implementation of several screens using Oracle Forms 6i.
• Design, development and implementation of several reports using Reports 6i, and iReports 4.0.
• Oracle back end programming in design, development and implementation of several Stored Procedures, Stored Functions, Stored Packages and Database Triggers using SQL and PL/SQL.
• Use of Datastage for reporting purposes.
• Design, development and implementation of HTML reports using Oracle SQL Plus.
• Implementation of reports delivery options via e mail using Oracle SMTP.

Tools and Environment: Oracle 10g, Oracle Enterprise Manager, PL/SQL, Oracle Forms 6i, Reports 6i, SQL Navigator, SQL Plus, Datastage, HTML, Unix, Red Hat Linux, FTP and SQLTools.

Confidential

Senior Oracle Developer Project Leader

Responsibilities:

• Development and implementation of SGS distribution system.
• Planning phase and development for SAYCO Workflow.
• Design, development and implementation of several end-user screens using Oracle Forms 9i and end-user reports using Oracle Reports 9i.
• Generation of Oracle Forms Menu 9i.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 10.

Tools and Environment: Oracle 10g, Oracle Enterprise Manager, PL/SQL, Oracle Forms 9i, Reports 9i, SQL Navigator, SQL Plus, Unix, FTP and SQLTools.

Confidential

Senior Oracle Developer

Responsibilities:

• Development and implementation of enhancements and new features, testing before moving modules into production using Visual Basic 3 for front-end development.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 9.
• Use of PL/SQL Developer and SQL Navigator, for database objects creation and back-end programming implementing stored procedures, stored packages, stored functions and database triggers.
• Design, development and implementation of HTML reports using Oracle SQL Plus.
• End-user support.

Tools and Environment: Oracle 9i, Oracle Enterprise Manager, PL/SQL, Oracle Forms 9i, Reports 9i, Visual Basic 3, SQL Navigator, SQL PLUS, HTML, Unix, FTP and SQLTools.

Confidential

Senior Oracle Developer

Responsibilities:

• Development and implementation of Phase 2 of a Treasury Management System called MASTER.
• Development and implementation of enhancements and new features and testing before moving modules into production.
• Design, development and implementation of several forms and reports using Oracle Forms 9i and Oracle Reports 9i.
• Generation of SQL scripts for database objects creation tables, views, constraints, etc. on production environment Oracle RDBMS 10.
• Use of Oracle Designer to define and maintain all database objects and to generate SQL scripts for its creation and updates.
• Creation of HTML reports using Oracle SQL Plus to display money transaction records and tracking of money transfer transactions entered through thin clients.
• Use of CMMI methodology.

Tools and Environment: Oracle 10g, Oracle Enterprise Manager, PL/SQL, Oracle Forms 9i, Reports 9i, Oracle Designer 9i, SQL Navigator, SQL PLUS, Oracle Developer, HTML, Unix and FTP.

Confidential

Senior Oracle Developer

Responsibilities:

• Income Stabilization team consisting of 6 engineers to launch the second phase of ACSELX/9i.
• Software customization according to the end client needs using Oracle tools including SQL, PL/SQL, Oracle Forms 9i and Oracle Reports 9i.
• Development and implementation of enhancements and new features using Oracle Forms 9i and Oracle Reports 9i.
• Version control system using CVS.

Tools and Environment: Oracle RDBMS 8i and 9i, Oracle Enterprise Manager, PL/SQL, Oracle Forms 9i, Oracle Reports 9i, SQL Navigator, SQL Plus and SQL Loader.

Confidential

Oracle Developer - Project Leader

Responsibilities:

• Design, development and implementation of a Salesforce Commisions system to be integrated with Payroll, Sales, Capitalization and Third Parties.
• Development and implementation of enhancements and new features using Oracle Forms 9i, Oracle Reports 9i and HTML.
• Use of Oracle Designer for creation and maintenance of the ER Diagrams and scripts generation for the database model.
• Use of SQL Navigator for database objects creation.
• Design, development and implementation of Stored Procedures, Stored Functions, Stored Packages and Database Triggers.
• Design, development and implementation of HTML reports through Oracle SQL Plus summarizing sales information according to several time-periods criteria.

Tools and Environment: Oracle 8i and 9i, Oracle Enterprise Manager, PL/SQL, Oracle Forms 6i, SQL Navigator, HTML, Oracle Designer 9i, SQL Plus and Oracle SQL Loader.

Confidential

Oracle Developer

Responsibilities:

• System support for the launch of SIT 2 Tax Information System and Current Account Taxpayer system.
• Data migration of System Phase I to System Phase II Using of Oracle SQL Loader.
• Development and implementation of Enhancements with Java and Oracle Forms 9i and Oracle Reports 9i.
• Implementation of all business logic using SQL and PL/SQL through Stored Procedures, Stored Functions, Stored Packages and Database Triggers.
• Use of SQL Navigator for database objects creation and back-end programming implementing stored procedures, stored packages, stored functions and database triggers.
• Implementation of HTML reports using SQL Plus and displaying statistical information as a result for migration routines.

Tools and Environment: Oracle 8i and 9i, Oracle Enterprise Manager, PL/SQL, Oracle Forms 9i, Oracle Reports 9i, SQL Navigator, SQL Plus, HTML and Oracle SQL Loader.