SUMMARY:

• Confidential has extensive experience over the software development life cycle in managing, leading and executing deliveries and supporting global clients & customers. He has been extensively involved in requirements gathering, analysis / design (high level design, low level / detailed design, software requirements specifications & database design), systems development, testing (unit & system), data migration, data extraction, data load, reporting, and release management.
• His expertise lies in design and development using Oracle 11g/10g/9i, Forms & Reports 6i/9i/10g, PL/SQL and BANNER 7. Confidential has extensive experience in developing stored procedures, database triggers and packages using PL/SQL. Confidential also has experience in development DBA activities like Database Design (Tables, Views & Constraints), Performance Tuning (Using Explain Plans) and Data Migration. With BANNER he has been adapting the financial module for a Latin American University including accounting processes. His expertise also lies in the areas of project initiation, project planning, estimation, project scheduling & tracking, reporting, work allocation, managing escalations, data security & configuration. Guillero has excellent communication skills.

TECHNICAL SKILLS:

Languages: SQL / PLSQL.

GUI Tools: Developer Forms & Reports 6i/9i/10g.

RDBMS: ORACLE (9i, 10g, 11g).

Case Tool: Toad for Oracle 10.6, 11, Toad Data Modeler.

Project Management Tool: Microsoft Project, Microsoft Office.

Operating Systems: Windows, LINUX CentOS 6.4

Utility: Toad 10.6, 11, SQL Developer 3.2 BIArtus Administrator, Artus Designer

PROFESSIONAL EXPERIENCE:

Lead Prog. Analyst

Confidential

Responsibilities:

• Worked in the capacity of technical lead responsible for leading a team of 3 developers.
• Responsible for the complete design/implementation of the Oracle Database structure. Used Waterfall model for development purpose.
• Designed solutions to database level based on previous survey requirements. Defining and implementing the new database structure with the proposed solutions.
• Several meetings with users and the development team to make decisions and to negotiate the scope of the developments.
• Development of PL/SQL Procedures, Functions, Packages & Triggers. Several validations, log record, and massive information processes are entirely developed in PL/SQL using Toad 10.6.
• Designed the Forms and Reports using Developer 10g. Managed all the Forms with proper error handlers and user - friendly messages. Used Developer 10g to generate daily reports and perform complicated queries
• Wrote complex front end queries to display data on front end screens. Involved in database performance tuning using EXPLAIN PLAN.
• Created Rollback scripts in SQL*PLUS to restore the data and database objects in case of failure.
• Involved in the impact analysis of change requests raised by customers. Presentation of Oracle SQL tuning to various teams so that the developers can use those tips while developing new components.
• Also perform specific tasks of DBA for different systems under construction.
• Unit Tested the PL/SQL scripts. Prepared Unit Test Cases for the designed modules.

Environment: Oracle 11g, SQL, PL/SQL, Developer 10g (Forms and Reports), Toad 10.6, SQL*PLUS, Toad Data Modeler, LINUX CentOS 6.4.

Sr. Prog. Analyst

Confidential

Responsibilities:

• Requirements gathering, problem analysis, solution design, solution development, presentation to the user and production release of the solution generated.
• Development of PL/SQL Procedures, Functions, Packages & Triggers. Because the program is fully developed with Oracle Developer Forms, validations and transactions are developed in PL / SQL.
• Developing Forms: The user front end is developed with Oracle Forms 10g, therefore, the modification or creation of new screens to cover the requirements was with this tool.
• Analyze the performance of BANNER, because new implementations should be included in the normal flow of the application transparently to the user.
• Continuous contact with the end user to verify the level of satisfaction obtained by the proposed solutions developed and implemented.
• Did User Acceptance Testing, follow-up tests and production follow-up.

Environment: Oracle 10g, Oracle Developer Forms 10g, SQL, PL/SQL, Toad for Oracle 10.6, BANNER 7.4 & 8.5

Sr. Prog. Analyst

Confidential

Responsibilities:

• Update reports because change version of the development tool, from Oracle Reports 6i to Oracle Reports 9i.
• Implementation of improvements in reports based on requirements, and development of new reports required by the user.
• Tuning of query in order to improve the performance of the reports.
• Releasing reports to the production environment.
• Parameterized headers and pictures of the reports for use in other government agencies.

Environment: Oracle 10g, Oracle Developer Reports 6i & 9i, SQL, PL/SQL, HP Open View

Programmer Analyst

Confidential

Responsibilities:

• Analysis of previously developed code for the accounting process, implementation of improvements, bug fixes and new development requirements
• Development of the screen for user interaction in Oracle Forms 10g.
• Frequent conversations through conference calls with the systems team of MetLife U.S.A.
• Shell scripting for movement of text files between servers and several simple tasks.
• Coding of procedures grouped into packages, according to the purpose, using PL / SQL and Toad 9.
• Accountants Team in the use of the tool.

Environment: Oracle 10g, Oracle Developer Forms 10g, SQL, PL/SQL, FootPrints for Incidents, Shell.

Programmer Analyst

Confidential

Responsibilities:

• Main system analysis. Design the solution based in the current system.
• Development in Oracle Forms 10g. All the validations and business rules where coding in several forms, triggers.
• Testing of the contingency system.
• The modules within the scope were: bond issuance, renewal of bonds, bonds increased, generating of tax receipt.
• Ranking the order of the development based on the difficulty of the modules.

Environment: Oracle 10g, Oracle Developer Forms 10g, Oracle Developer Reports 10g, SQL, PL/SQL, Oracle Designer.

Lead Programmer Analyst

Confidential

Responsibilities:

• Developer Manager of the query and reports Module in Oracle 9i Forms and Reports Oracle 9i.
• He was responsible for leading 2 people.

Environment: Oracle 9i, Oracle Developer Forms 9i, Oracle Developer Reports 9i, SQL, PL/SQL.

Lead Programmer Analyst

Confidential

Responsibilities:

• Project Leader in creating the Global Database (BADAG) in SQL Server 2005 and data mining interface developed in Artus Designer.
• The Confidential had several databases created in different database managers, the objective of the project was create a unique Global Data Base with all the data with the purpose of generate an interface which helps in taking decisions.
• Responsible for leading 3 people.

Environment: SQL Server 2005, Artus Administrator, Artus Designer.