SUMMARY:

• More than 20 years of experience working in IT projects.
• Experience as an Oracle Developer using SQL*Forms, SQL, PL/SQL, SQL*Reports and PRO*C.
• Experience as an Oracle DBA and spend a lot of years doing tuning of SQL, PL/SQL and Oracle Databases.
• Used exp/imp, datapump (expdp/impdp) since 10g, sql*loader, RMAN.
• Installation & patching of Oracle RAC, ASM, Standalone, Weblogic, Oracle SOA.
• Developed a lot with Forms Builder and Report Builder all kind of reports (Single Query, Master/Detail, Matrix).
• Experience with Agile/Sprint methodology, plans, schedules and work breakdown structures.
• Has experience as an Oracle DBA/Sysadmin for Oracle EBS 11x/12x recently made several queries using tables & views from Oracle EBS to published them in Oracle Apex as a new responsibility inside Oracle EBS as well as an Oracle APEX application.
• I have been in several managing positions doing coaching, supporting Oracle applications & Databases, training new employees.
• Experienced in QA writing and executing manual test cases for Siebel and Oracle OSB.
• Experience installing Oracle OSM, UIM, ASAP, IPSA, OCMC, ATG, Siebel, Sun Cluster, AIA PIPs, BPM 10g, Oracle Linux, RedHat.
• Information technology professional with a background in project management, business and systems analysis, installation and configuration.
• Skilled Systems Analyst with a proven track record of leading analysis and requirement - gathering efforts for application development projects. Additional background includes conducting joint and rapid application development sessions, service-oriented architecture and supervisory experience in functionality, usability, reliability, performance and regression testing. Expert Systems Administrator with broad knowledge of database analysis and management in an Oracle Server environment.

TECHNICAL SKILLS:

Languages: Oracle SQL, Oracle PL/SQL, XML, SOAP, C, Oracle PRO*C

Database: Oracle 8x-12x

Web Servers: Oracle iAS, Oracle Weblogic, Oracle OHS

Server OS (Setup): Oracle Linux, Red Har Linux, Solaris, SUSE

Development Tools/Environment: Oracle Forms, Oracle Reports

PROFESSIONAL EXPERIENCE:

Confidential, Dallas,TX

Senior Oracle DBA/ Developer

Responsibilities:

• Define general replication flows between Oracle Cloud applications and legacy systems.
• Deliver Use cases documents for SOA/ODI developments.
• Experience with Agile/Sprint methodology, plans, schedules and work breakdown structures.
• Develop BIP reports to extract data from Cloud Apps.
• Installation of SOA/ODI 12.2.1.2
• Configuration of RHEL 7.2
• RHEL NFSconfiguration
• Development of PL/SQL Packages to read KML files
• ERD definitions
• Create/Update Database Schemas

Environment: Oracle RAC 12, Oracle SOA/ADF/BAM/ODI Cluster 12.2.1.2, RHEL 7.2, Java SDK 8.

Oracle Technical Consultant

Responsibilities:

• Define infrastructure requirements: Number of Linux Servers, CPU, RAM, HD, IPs.
• Installation of OSB/WLS 12.1.3
• Installation of OHS 12.1.3
• Configuration of OHS Virtual Hosts
• Installation &Configuration of RHEL 7.2
• RHEL NFS configuration

Environment: Oracle RAC 12, Oracle OSB/WLS Cluster 12.1.3, Oracle OHS 12.1.3, RHEL 7.2, Java SDK 8.

Oracle Technical Consultant

Responsibilities:

• Writing and executing manual test cases for Siebel ecommunications, inbounds & outbounds
• Writing and executing manual test cases forOracle OSB Web Services using SOAP UI.
• Technical support to the OSB/SOA administration team.
• Join technical meetings with the Millicom regional leaders.

Environment: Oracle Siebel 8x, Oracle SOA 11g, Oracle ExaData 12, Oracle Server 12.

Oracle Technical Consultant/Support Manager

Responsibilities:

• In charge of the definition of the I.T. Service Desk using BMC FootPrints the goal is to use ITIL and evolve it to a High-Performance Service Desk. My first responsibility was to assemble a technical and functional support area for an Oracle EBS R12.1.3 & Oracle CRM On Demand. Initial task is to create a strategy to cover all current issues in both areas: technical & functional.
• Ongoing proposals for short term were: Hire local consultants with senior level to be able to give support for current operations as well to document all BR's and TE040 documents.
• Oracle DBA/SysAdmin Clone production environment.
• Level 1 support.
• Integrate Oracle APEX to Oracle EBS R12.1.3
• Modify Custom Reports using Oracle Report Builder.
• Use Oracle Forms Personalization.

Environment: Oracle EBS 12x, Oracle Apex 12x, Oracle Server 12x.

Oracle Technical Consultant

Responsibilities:

• Project ETB Bogotá Colombia: Installation in Solaris SPARC 64 of: ASAP in Sun Cluster IPSA in Sun Cluster Metasolv in Cluster de WLS. OSM in Cluster de WLS 5 environments (Dev/QA/Training /PreProd/Prod) Oracle PL/SQL & SQL Tuning

Environment: SOLARIS LDOSM, Oracle RAC

Oracle Technical Consultant

Responsibilities:

• Project Azteca Communications from Colombia: Development Environment: Installation of: OVM Server 3.2 OVM Manager 3.2 Configure and VM (AMD Processors) creation for the following apps I also installed: Oracle Linux 6.1, Oracle Linux 5.5, Oracle UIM 7.2, Oracle AIA/PIPs 11.2, Oracle OSM 7.2, Oracle IPSA 7.2 In LDOMS (SPARC 64). I made the installation for: Oracle ASAP 7.2 Oracle BRM 7.4 Siebel 8.1.1.10
• Lead for the Oracle architecture solution for Azteca Communications from Colombia. My tasks as a leader were to supervise the physical HW (SPARC & INTEL) & SW (Solaris & Oracle Linux) installation and configuration. It was a mix architecture some servers remain without virtualization but most of them will contain VM & LDOMs I have to provide the HW & SW specifications that meet the applications certified version of O.S. I will have to install several Oracle RAC 11gR2 on VMs & LDOMs. Other installations I have to do are: Oracle UIM, Oracle SOA/AIA, Oracle IPSA, Oracle OCMC (OnLine), Oracle Sun Cluster, Oracle OSM.

Environment: RHEL, SOLARIS, Oracle RAC/StandAlone 11g, Oracle VM

Oracle Technical Consultant

Responsibilities:

• Project UNE Medellin Colombia: Lead of HP HW installation & configuration for GE GIS application. Other task where the installation/creation of several Oracle Database, installations of Oracle UIM. Installation & configuration of Linux Clusters.

Environment: RHEL, HPUX, Oracle Server 11g

Oracle Technical Consultant/Manager

Responsibilities:

• Lead for proposals for TI projects.
• Installation of Oracle Linux 6
• Installation of Oracle EBS R12 on Oracle Linux 6
• Project TIGO Santa Cruz Bolivia Dec 2011/Feb 2012 Integration Architect: Using OSM 7.3, OSB & SOA 11.1.1.4, Generate Technical Design for OSM & OSB.

Environment: Oracle EBS 12x, Oracle Linux. Oracle EBS 12x, Oracle SOA, Oracle RAC ONE, Oracle Linux

Oracle Technical Consultant/Manager

Responsibilities:

• Project: UNE Medellin Colombia Oct 2011/Nov 2011 Installation of Oracle RAC ONE Node. Generate Sun Hardening document establishing a security base line. Generate Oracle 11g security base line.

Environment: Oracle RAC ONE, Oracle Linux.

Oracle Technical Consultant/Manager

Responsibilities:

• Project: ASA Gathering information of the current operation to improve processes and propose improvements or implementation of Oracle EBS R12. Tool used BizAgi.
• Ongoing proposals for short term were: Hire local consultants with senior level to be able to give support for current operations as well to document all BR's and TE040 documents.

Environment: Oracle EBS 12x.

Oracle Technical Consultant/Manager

Responsibilities:

• As a manager, I was involved in building a team of 11 for SQL, PL/SQL, Oracle DB installation, Virtualization, OEL 5 installation. Also was counselor for these consultants and was responsible for their day to day activites and managed their performance. I was also part of Siebel training provided by Oracle University.
• Project Sky: Bring all the experiences tearn in project Katún/Cablemas related to infrastructure and installations. Release management. Oracle BI Apps 7.9.6.3 Installation & configuration.

Environment: Oracle Siebel 8x, Oracle SOA/AIA/BPM 10g/11g, Oracle Server, RHEL, AIX.

Oracle Technical Consultant/Manager

Responsibilities:

• Responsible for SOA 11g Cluster Installation & Configuration SOA 10g Cluster Installation & Configuration for AIA/PIPS 2.5 BPM 10g Cluster Installation & Configuration Siebel 8x Coordinate the installation for all the modules & components used in the project also coordinate testing for the Service Guard used for the Siebel Gateway.
• Gather the data necessary to fill the Sizing Questionnaires for Oracle SOA, Oracle BRM, Oracle Metasolv, Oracle Siebel, Oracle AIA & PIP's for Telco. Coordinate all task related to the infrastructure for 4 environments (Dev, Test, PreProd & Prod) as accounts, security, communication testing, DB & SO hardening. Also preview any future need in order to have it installed, configured, tested or acquired in time. Create detailed work plans for all task related to infrastructure. Oracle BPM 10g programming.

Environment: Oracle Siebel 8x, Oracle SOA/AIA/BPM 10g/11g, Oracle Server, RHEL.

Oracle Technical Consultant/Manager

Responsibilities:

• Oracle ACS support in the IMSS implementing Oracle best practices for 1.- Database management 2.-Database Security 3.- Database Storage 4.- Database Performance Also helping the IMSS to implement their own best practices, policies and naming conventions as well to ensure 3FN in the new systems by reviewing the ERD and data dictionary. Developing Forms & Reports with Oracle Forms builder and Report Builder.

Environment: Oracle Server 11g

Oracle Technical Consultant/Manager

Responsibilities:

• Project UNISYS: implement the best practices for the operation of ALEA, core business application. Also help to UNISYS dba to monitor, locate & resolve any performance issue. We have a great impact in the overall performance by detecting a bad OS configuration that was reflecting in the performance of the DB. By reconfiguring the AIX OS and the Oracle DB we solve the “slow application or system” issue that was merging the operation of RSA by years.

Environment: Oracle Server, AIX.

Oracle Technical Consultant/Manager

Responsibilities:

• Oracle SOA Suite Installation.
• Oracle BPEL 10g developing using iway adapter for SIEBEL 2K.
• Oracle DBA 7 to 10g
• Oracle PL/SQL Quest Software product installation such as Foglight, Database Performance Analyzer, Quest Central, Spotlight, TOAD, SQL Optimizer, Space Manager with Live Reorg.
• Oracle database optimization & tuning

Environment: Oracle Siebel, Oracle SOA/BPEL, Oracle EBS 11g, Oracle Server 10g.

Oracle Technical Consultant/Manager

Responsibilities:

• Oracle EBS migration from Windows 2003 to Linux RH AS 4.0
• Oracle EBS database migration from 9i to 10g
• Oracle EBS DBA & SYSADMIN

Environment: Oracle EBS 11g, Linux.

Oracle DBA/Manager

Responsibilities:

• Support Manager: Manage the effort of 5 persons to support the 24x7 operation for the modules: AR, CE, XTR, AP, GL (FSG, ADI), FA, EAM, iProcurement, iStore, iExpenses, iSupplier Portal, BOM, INV, WIP, QA, OM, SCM, ENG, OFA, Discoverer. TAR following & management. Coordination of the PMP & Critical patches activities scheduled by Oracle OnDemand through our SDM Elizabeth Juarez and our Production Manager.
• DBA: Administration of 3 instances (SALSEI, TALSEI & DALSEI) Hosted by Oracle OnDemand. Activities: Users creation, Responsibilities customization & creation, Menu customization, assign responsibilities to users, Definition of: Executables & Concurrent Programs, StartUp/Shutdown Services for the instances, Database & application performance monitoring, Improve the performance of the application, TAR/SR management with Oracle Support, Patch application, Build Datafixes, Build Data Loaders, Build SQL Queries.

Environment: Oracle Server 10g, Oracle EBS 11x, RHEL.

Oracle Principal Consultant

Responsibilities:

• I was participating in the Oracle Transportation 11.5.9 implementation.
• My activities were: Oracle XML Gateway configuration to support Oracle Transportation transactions DTD File definition.
• Definition of the mapping data files for the XML transactions vs Oracle Applications Open Interface.
• Customization of the standard Workflows so they can send the XML files to the distribution centers and to the transportations companies.

Environment: Oracle Server 10g, Oracle EBS 11x, Oracle Forms/Reports, UNIX,Oracle PL/SQL, Oracle Workflow, XML.

Oracle Principal Consultant

Responsibilities:

• Coordinate the updates of the systems MAV/HOST and OCO, the updates were delivered by Oracle eStudio in Argentina. .
• Design of replication and rollup of the Mexican IT systems to the US companies of the group. Help Desk Project.
• Monitoring & tuning of the Oracle Applications 11.5.8 Several Oracle Database tuning.

Environment: Oracle Server 10g, Oracle EBS 11x, Linux, Oracle Forms/Reports, UNIX, Oracle PL/SQL.

Oracle Principal Consultant

Responsibilities:

• Project Petrolatin: Installation, configuration and maintenance for the Oracle Exchange. (DeHosting from Oracle OnDemand)

Environment: Oracle Server 10g, Oracle Exchange.

Oracle Principal Consultant

Responsibilities:

• Project PEMEX: Technical proposal for the Oracle server migration to a newer OS version in a NUMA server.

Environment: Oracle Forms/Reports, UNIX, Oracle PL/SQL.

Oracle Principal Consultant

Responsibilities:

• Project BBV: Development of the proposal for the migration of the ALEA system to a newer versions of Oracle Developer 6i y Oracle Server 8i.

Environment: Oracle Forms/Reports, Oracle Pl/SQL

Oracle Principal Consultant

Responsibilities:

• Project AHISA: Payment application tuning (SQL, PL/SQL, Oracle Forms, Oracle Reports) for the SEUS version of AHISA.

Environment: Oracle Forms/Reports, UNIX, Oracle PL/SQL.

Oracle Principal Consultant

Responsibilities:

• Project Universal Insurance Company (Guaynabo Puerto Rico) Installation & configuration of the SEUS application to be used in Web. I had to install Oracle Server, Oracle Forms & Oracle Reports.

Environment: Oracle Forms/Reports, Oracle Server.

Oracle Principal Consultant

Responsibilities:

• Project PEMEX: Technical proposal for the Oracle server migration to a newer OS version in a NUMA server.

Environment: OAS.

Oracle Principal Consultant

Responsibilities:

• Project B+B Tech of Mexico: Proposal for the infrastructure solution for the site Olojista.com. Other activities were the installation, configuration and tuning of the Oracle 8i DB and the Application Server O.A.S. 4.0.8.2.

Environment: Oracle 8i, OAS 4.0.8.2.

Oracle Technical Consultant

Responsibilities:

• Development of the technical proposal for the national RFP/RFQ No. “Development & Implementation for a system to manage all of the assured goods” We have the best proposal so we win the project.
• Development of the technical proposal for the international RFP/RFQ of the Tourism Secretary to build an Internet site. We have the best proposal so we win the project. At the beginning my activities were to define and recruit all the roles needed to build the site. Also, I was participating in the administration of the human & financial resources for the project.

Environment: Oracle Server 10g, Oracle Forms/Reports, UNIX.

Oracle DBA/Developer/Analyst

Responsibilities:

• Defined business goals to determine systems requirements.
• Provided client support on system operation and troubleshooting.
• Supported system developers by creating system models, diagrams, and charts.
• Performed system analysis, documentation, testing, implementation and user support for platform transitions.
• Established specifications and coordinated production with software programmers.
• Gathered requirements and performed gap analysis through design workshops with users.
• Monitoring and testing application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
• QA for Oracle Reports to verify standards for the OMD methodology were applied.
• Tuning applications developed in SQL, PL/SQL, Oracle Forms & Oracle Reports.
• Generate documents with performance recommendations.
• Assignments to several projects: Grupo Financiero Serfin, Serviware, PROSA, Kellogs de Mexico, BANCOMEXT S.N.C.

Environment: Oracle Server, Oracle Forms/Reports, UNIX, Oracle EBS, C, PRO*C, Oracle PL/SQL.

Oracle DBA/Developer/Analyst

Responsibilities:

• Built, tested and deployed scalable, highly available and modular software products.
• Strengthened developmental methodologies by introducing a code quality document.
• Designed and developed transactional and analytical data structures.
• Drafted comprehensive reports to document bugs and design flaws.
• Worked closely with clients to establish problem specifications and system designs.
• Performed regression and system-level testing to verify software quality and function before it was released.
• Defined business goals to determine systems requirements.
• Established specifications and coordinated production with software programmers.
• Provided client support on system operation and troubleshooting.
• Gathered requirements and performed gap analysis through design workshops with users.
• Tuning of SQL, Oracle Forms, database procedures, processes & Oracle Reports.
• Logical & Physical design for the DB.
• Oracle DataBase sizing.
• Data Loaders development.
• Training.
• Oracle DataBase administration.
• Use Oracle Methodology to develop information systems.
• Assignments in several projects: NAFIN, Oracle de México, IPN, Industrias del Agua, Grupo Financiero Serfin, Dirección General de Derechos de Autor, IFE.

Environment: Oracle Server, Oracle Forms/Reports, UNIX, C, PRO*C,Oracle PL/SQL.

Confidential

Oracle Developer

Responsibilities:

• Built, tested and deployed scalable, highly available and modular software products using Oracle PL/SQL, Oracle*Forms, Oracle*Reports.
• Performed regression and system-level testing to verify software quality and function before it was released.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Environment: Oracle Server, Oracle Forms/Reports, Oracle PL/SQL, UNIX.