SUMMARY:

• Senior Oracle Certified Developer with more than 16 years of extensive experience in support, maintenance, testing and development of Oracle based information systems in client/server and web environments for financial, health, insurance, logistics, and government industries. - Database Architect.
• Extensive experience in all phases of SDLC. 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, Oracle RDBMS 7.3.4/8i/9i/10g/11g, HTML, Hyperion SQR Reports (PeopleSoft 8.4).
• Database Design and Modeling, Oracle applications tuning and UNIX shell scripting experience, Kettle 4.2/5 Pentaho Data Integration. SSIS - Microsoft Visual Studio 2010/2012, and Business Objects (SAP). Web Intelligence, Crystal Reports. Performance Tuning, Data Stage, Migration.
• Goal and team oriented with excellent interpersonal skills.
• Bachelor’s Degree in Computer Science and Postgraduate degree in Database Management, Data Warehousing and Business Intelligence.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, JavaScript, HTML.Database ArchitectDatabase Design and Modeling,Database Normalization.SecurityQuery performance (SQL Tuning)

Database: Oracle RDBMS 7.x/8i/9i/10g/11g/12c.

Development Platforms: Oracle Forms 4.5/6i/9i/10g, Oracle Reports 2.5/6i/9i/10g, SQL*Plus, TOAD

Operational Systems: Windows (NT/200x Server/XP/Vista), UNIX Solaris.

PROFESSIONAL EXPERIENCE:

Confidential - Dallas, TX

Senior Oracle Developer - Oracle Architect

Responsibilities:

• Database Architect.
• Database Design and Modeling,
• Create PLSQL objects
• Database Normalization
• Improve Reports performance using ETL process (Simplify tables using Data Staging). Performance Tuning.
• Development and implementation of SAP - Business Object Report Developer (Crystal Report XI). Web intelligence, Information Design Tool 4.1, Webi Reports.
• Building complex Oracle SQL queries including sub-queries, analytic and aggregate functions, minus/union, and inline queries.
• Development of Web Intelligence Reports (SAP).
• Data integration.
• Improve the performance of financial reports using Oracle tuning (hints, creating new indices, proposing new processes to be automated through processes ETL, Explain plan, statistics)
• Migration for Legacy Reports to SAP Business Objects Reports

Tools: and Environment: Oracle 11g/12c, PL/SQL, Toad 11, SQLTools 1.6, Explain plan, Crystal Reports, Business Objects (SAP), Web Intelligence 4.0, Information Design Tool, Actuate Reports, Agile methodology.

Confidential - Cambridge, MA

Senior Oracle Consultant

Responsibilities:

• ETL Process, using Kettle 5 Pentaho Data Integration / Spoon, and 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.
• Design complex report from School Admission System to Harvard Admission central.
• Modify Oracle data base objects to solve issues in Admission process in Graduate School .
• Development and enhancements of Crystal Reports for Registrar office.
• Database Architect
• Database Design and Modeling,
• Database normalization.
• Data integration.
• Generation of SQL scripts for database objects creation (tables, views, constraints, etc.) on production environment Oracle RDBMS 11g/12c.

Tools: and Environment: Oracle 11g/12c, Oracle Enterprise Manager, PL/SQL, Toad 11, Unix, WinSCP, SSH Secure transfer, Putty, Aventail, GIT, SQLTools 1.6, ExamDiff Prof, Crystal Reports, Jira, SSIS - Microsoft Visual Studio 10 /12. Agile Methodology.

Confidential - Austin, TX

Senior Oracle Developer - Database Architect

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.
• Database Design and Modeling,
• Data integration.
• ETL process using Kettle 4.2 (Pentaho Data Integration). Development, implementation and enhancement of Kettle scripts. Create of kettle job to Load and validate daily and monthly big files, using data staging 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 Data Integration), ExamDiff Prof, Lotus Notes. Scrum Methodology

Confidential - Baton Rouge, LA

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. Scrum Methodology.

Confidential

Senior Oracle Developer - Project Leader - Database Architect

Responsibilities:

• Development and implementation of ETL routines and UNIX shell scripts to populate temporary tables used for reporting purposes from the data warehouse.
• 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.
• CIS (Customer Information System),
• Use of Datastage for reporting purposes.
• Performance Tuning.
• Database architect
• Database Design and Modeling,
• Security.
• Database normalization.
• Testing before moving modules into production
• 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. Agile Methodology.

Confidential

Senior Oracle Developer - Project Leader - Database Architect

Responsibilities:

• Development and implementation of SGS distribution system.
• Planning phase and development for Confidential Workflow.
• Design, development and implementation of several end-user screens using Oracle Forms 9i and end-user reports using Oracle Reports 9i.
• Testing before moving modules into production
• Generation of Oracle Forms Menu 9i.
• Performance Tuning.
• Database Architect.
• Database Design and Modeling,
• Security
• Database normalization.
• 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. Scrum Methodology.

Confidential

Senior Oracle Developer - Database Architect

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.
• Database Design and Modeling,
• 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.
• Database Architecture.
• Security.
• Database Design and Modeling.
• Database normalization.
• 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. Scrum Methodology.

Confidential

Senior Oracle Developer - Database Architect

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.
• Database Architect.
• Database Design and Modeling,
• Database normalization.
• 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. Agile Methodology.

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.
• Database Design and Modeling,
• Performance Tuning.
• Database normalization.
• Security.
• 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. Scrum Methodology.

Confidential

Oracle Developer - Project Leader - Database Architect

Responsibilities:

• Design, development and implementation of a Salesforce Commissions 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.
• Design, development and implementation of Stored Procedures, Stored Functions, Stored Packages and Database Triggers.
• Use of SQL Navigator for database objects creation.
• Use of Oracle Designer for creation and maintenance of the ER Diagrams and scripts generation for the database model.
• Performance Tuning.
• Database Architect.
• Data Integration.
• Database Design and Modeling,
• Database Normalization.
• Security.
• 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. Agile Methodology.

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.
• Database Design and Modeling,
• Data integration.
• Database normalization.
• 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.

Confidential

Lead Oracle Developer - Database Architect

Responsibilities:

• Lead Oracle Developer responsible for a team of 4 Oracle developers.
• Design, development and implementation of new features using Oracle Forms 4.5, Oracle Reports 2.5, and Visual Basic on Windows NT and UNIX environment.
• Generation of SQL scripts for database objects creation (tables, views, constraints, etc.) on production environment Oracle RDBMS 8 and 8i.
• Use of Oracle Designer 6.0 to generate and maintain the database model.
• Development of Stored Procedures, Stored Functions and Stored Packages on PL/SQL.
• Use of PL/SQL Developer and SQL Navigator, for database objects creation and back-end programming.
• Performance Tuning.
• Database Architect.
• Database Design and Modeling,
• Database normalization.
• Design and implementation of HTML reports using Oracle SQL*Plus for accounting summary information according to monthly needs and requirements.
• Development of Unix Shell scripts.

Tools: and Environment: Oracle 8 and 8i, Oracle Enterprise Manager, PL/SQL, Oracle Forms 4.5, Oracle Reports 2.5, PL/SQL Developer, SQL Navigator, Toad, Q+E, SQL*Plus, WINSCP3, Putty, Unix (Solaris 7 SunOS 5.7 / Solaris 9 SunOS 5.9), HTML, Visual Basic 3.0 and Oracle Designer 6.0. Agile Methodology.

Confidential

Junior Developer

Responsibilities:

• Modeling, application development and implementation using Microsoft Access.
• Database Design and Modeling,
• Implementation of end-user manuals using HTML.

Tools: and Environment: Microsoft Access 2.0 UltraEdit text editor and HTML.