SUMMARY

• Technical Systems Engineering with over 25 years of experience. Talent to identify client’s needs and provide appropriate solutions. Proactive, dynamic and problem - solving oriented. Extensive project management skills. Results oriented, positive outlook, troubleshooter by nature.

TECHNICAL SKILLS

• Project Management
• Disaster Recovery Planning
• Business Continuity Planning
• Data Warehouse
• ETL
• SQL
• DML
• DDL
• PL/SQL
• ORACLE Form & Report Developer
• CISCO
• ORACLE DBA
• ORACLE RAC
• ORACLE SQL*Loader
• ODA
• Java
• TOAD
• SQL Developer
• APEX
• AGILE-SCRUM
• Splunk
• Unix Shell scripting
• AutoSys
• Jira
• Confluence
• CVS Tortoise

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

PL/SQL Developer

Responsibilities:

• Built complex queries in SQL, to be used into the application and packages using SQL-Plus, TOAD and SQL Developer over ORACLE DB 11g and 12c.
• Improved several SQL queries performance for access and large volumes data manipulation.
• Developed advance PL/SQL package, procedures, triggers, functions, indexes and collections to implement business logic using SQL Developer.
• Automate and provide improvement to several manual user processes and reporting using advance PL/SQL code and database JOBs.
• Designed, implemented and tuned interfaces and jobs using PL/SQL and Unix Shell Scripting.
• Understood business rules and necessities to propose accurate automation solution.
• Developed ETL process for data consolidation and BI solutions for Supply Chain Management team.
• Developed complex automation processes for the integration of multiple heterogeneous platforms based on PL/SQL and Microsoft SQL Server.

Confidential, Miami, FL

PL/SQL Developer

Responsibilities:

• Provide L2 support to Agents to solve complex application issues related with the business operation, data fix or errors in the application using PL/SQL (ORACLE 11g and 12c) and Java (Spring framework)
• Built complex queries in SQL, to be used into web portals and Java applications. Also complex packages and store procedures (ORACLE DB 11g and 12c) to interact with Web Portals and Web Applications.
• Developed advance PL/SQL package, procedures, triggers, functions, indexes and collections to implement business logic using SQL Developer, SQL Plus and TOAD.
• Analyze applications errors PL/SQL codes and Java interface to determine the problem root cause and propose solutions and improvements.
• Support for data fix and integration between business core CLARIFY platform and ORACLE BRM.
• Develop applications for internal support using ORACLE APEX 5.1
• Automate and provide improvement to several manual user processes and reporting using advance PL/SQL code and database JOBs.
• Involved in the continuous improvements and solutions of daily problems of the production platform.
• Designed, implemented and tuned interfaces and jobs using PL/SQL and Unix Shell Scripting.
• Participation in multidisciplinary teams for technology projects using AGILE methodology.
• Created Unix Shell Scripts for invoking SQL scripts and schedule JOBs using AutoSys.
• Provided advanced support to L1 offshore team in relation to production issues.
• Urgently resolved production issues by debugging and fixing PL/SQL code errors. Production issues resolution took 30% of time; creation of new code and development and enhancement of existing code took 70% of time.

Confidential, San Jose

Senior PL/SQL Developer

Responsibilities:

• Implemented CODISA NAF ERP in Costa Rica and many countries in Central America (Mexico, Honduras, Guatemala, El Salvador and Nicaragua). System configuration and parameters setting (Account receivables, Procurement to Pay, Financials, Warehouse, Sales, HR).
• Built complex queries in SQL, to be used in custom forms and reports using SQL-Plus, TOAD, SQL Developer or ORACLE Developer Tools over ORACLE 11g and 12c.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Built complex PL-SQL codes for packages, stored procedures, and functions to support company’s goals. Queries optimization to improve database performance.
• Develop data entry applications using ORACLE APEX 5.0 for Sales, Payroll and Maintenance.
• Participated Designed large Data Warehouses and optimized ETL processes from different data sources.
• Understood business rules and necessities to determine the best solution.
• Created and maintained JOBs in PL / SQL code and programmed their scheduling in AutoSys.
• Designed and developed new forms and reports from scratch to fulfill project requirements.
• Developed business analysis and reports using ORACLE Discoverer over ORACLE 10g.
• ORACLE database administration. Supported Engineered Systems - ORACLE Database Appliance.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Implemented CODISA NAF ERP 4.6.
• Designed and developed new forms and reports from scratch to fulfill project requirements.
• Built complex queries in SQL using SQL-Plus, TOAD and SQL Developer over ORACLE 10g.
• Supported the Data Warehouse and optimized the ETL processes.
• Involved in the continuous enhancements and fixing of production problems.
• Queries optimization to improve database performance using TOAD and SQL Developer.
• Developed entry data applications and processing with ORACLE APEX.
• ORACLE 10g basic database administration. Backup and recovery, tuning and support.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Provided technical support to users.

Confidential

Project Engineer

Responsibilities:

.

• Implemented CODISA NAF ERP 4.6 in many Corporation companies in Costa Rica.
• Built complex queries in SQL using SQL-Plus, TOAD and SQL Developer over ORACLE 9i and 10g.
• Designed and develop new forms and reports from scratch to fulfill project requirements using ORACLE Developer 6i Form and Report.
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Understood business rules and necessities to determine the best solution.
• Designed Data Warehouses and ETL processes according to the needs of each company.
• Built PL-SQL codes for packages, stored procedures, and functions to support company’s goals.
• Queries optimization to improve database performance using TOAD and ORACLE SQL Developer.
• Developed business analysis and reports using ORACLE Discoverer over ORACLE 9i.
• ORACLE 9i and 10g basic database administration.
• Provided technical support to users.

Confidential

Software Developer

Responsibilities:

• Participated in the evaluation and suggestion of the ERP to be implemented.
• Designed structure and assembled computer network and communications of the company.
• Analyzed, developed and implemented legacy information systems using FoxPro LAN.
• Automated main functions of the production process.
• Set-up and design of backup and recovery strategy for the production database and applications.
• Purchased electronic equipment (computation and communications).
• Provided technical support to users.