SUMMARY:

• I have Over Sixteen Years of Hands - on experience in variety of Oracle Technologies as Sr. Oracle Fusion Middleware Administrator/Architect. I am a seasoned professional Oracle Middle-Tier/Oracle Application Server (OAS/9iAS/10gAS), WebLogic Administrator along with in depth Development/Administration experience in Oracle Database, Oracle Portal, Oracle Forms, Oracle Reports, Oracle Java, OC4J, SOA, and Oracle Discoverer. Experienced in process, UML and relational modeling; developing and defining architecture for Data Warehouse with OLAP and ROLAP models.
• Hands-on experience in implementation of web applications over Oracle Application Server 10gR2/9iAS (Portal, SSO, OID, OIM, Oracle Forms, Reports, BI Publisher, Oracle Java etc.). I have deep experience in the process of tuning of applications and databases using Oracle Technologies. I have worked in multiple projects as Oracle Fusion Middleware administrator configuring multi-tier architectures with infrastructure and middle tier components on Linux, Unix and Windows. I have worked, configure and tuning components such as SSO, OID, OC4J, Webcache and SOA (ESB/BPEL) components. My long experience has me allowed to develop different skills in the computing engineering area. I have also good experience and knowledge in develop and implementation of Software with Oracle Products as Oracle Forms & Reports, Oracle Designer, SQL Language, PL/SQL, SQL*Loader and Oracle Portal.

TECHNICAL SKILLS:

ORACLE WEB SOLUTIONS: Oracle Application Server (4.0.7, 4.0.8, 10g), (OC4J, Forms, Reports Services, Discoverer, Apache), Oracle BI Suite (Discoverer, Warehouse Builder), Oracle Portal (9i, 10g), Oracle SOA Suite (ESB, BPEL)

RDBMS ORACLE: Versions 6.0, 7.0 a 7.3.2, 8.0, 8i, 9i, 10g (Concepts of 11g).

WAREHOUSE / BI: Modeling ROLAP, Dimensional Data Model, Star Model, Showflake Model, staging area, ETL Proces integrating Oracle DB and external DB, Reading external sources as flat files, excel. Modeling fact tables, dimension tables, dimensions, hierarchies, Tuning ETL with tools such as Bitmap indexes, Modeling with Oracle Designer, Oracle Warehouse Builder, ETL with OWB, PL/SQL, Pro*C, SQL*Loader

DEVELOPMENT TOOLS: PL/SQL - Mod PL/SQL, SQL Plus, Toad, SQL Developer, PL/SQL Developer, SQL Loader, Pro*C, Oracle Ware House Builder 3i, 9i, 10g, Oracle Designer 6.0, 6i, 9i y 10g, Oracle Discoverer 4i, 9i, 10g, Oracle Workflow 9i, 10g, ORACLE Forms & Reports, (Releases 1.6, 2.1, 6.0, 6i, 9i, 10g and 11g), Oracle J-Developer (3.1, 9i, 10g, 10.1.3.1), Net Beans, Eclipse, Java Script, XML, HTML, UML.

LANGUAGE / SCRIPTING: Perl, AWK, Shell scripting, Dos Bat, Windows command scripting.

OPERATING SYSTEMS: Unix (AIX, SOLARIS, SCO, HPUX), Windows NT / / 2003 / XP, Linux Suse, Red Hat, OEL, Macintosh

LINUX OPERATING SYSTEM: (OEL 4 and 5, Suse, REDHAT AS 3, 4 AND 5) WITH TASKS SUCH AS: Groups and Users Creation, Administration of Files and Directories: Delete, rename, copy, chmod, etc., Review of File System (df - k, df - v, etc), Raw partitions definition for Oracle ASM, Shell scripting using grep, find, awk, do, if, env variables, crontab, etc., Shell type and Profile Configuration, Kernel parameters definition, Packages Installation, TCP/IP, configuration, management of hosts file, etc., Printing with lp, ssh, scp configuration

APPLICATIONS: Oracle e-Business Suite (10.7, 11.5.4 to 11.5.9), JDE, Khameleon, Mibas, Queryx, P oyer, StarTeam.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Fusion Middleware Architect

Responsibilities:

• Senior Oracle Application server architect to upgrade internal Oracle application to Oracle Fusion Middleware 11g under Weblogic architecture. Configure test and production environments on HA architecture with 2 nodes in test and 3 nodes in production. Design architecture and install Oracle products including WeblogicServer, OID, SSO, Portal, Forms, Reports, Discoverer, SOA suite and ADF for Custom Applications. Upgrade portal, forms and reports applications from Oracle AS 10g to Oracle Fusion Middleware 11g using RedHad Linux 5.
• Install and Upgrade OID included in 10.1.2 platform to OIM corresponding components at Oracle Fusion Middleware 11g.
• Install and Configure in HA architecture Oracle AS identity management 10g (10.1.4) with 11g fusion middleware to support Oracle portal on 11g.
• Upgrade Oracle portal content from 10g version to 11g.
• Install and configure in HA architecture Oracle SOA and ADF.
• Support and Develop of new functionalities of an Oracle forms and reports application, creating new stored procedures to be run in batch by Database Scheduler jobs and adjusting forms and reports based on new database model.

Confidential

Responsibilities:

• Senior Oracle DB and Application server administrator to migrate Paoyer applications to Oracle Database and Oracle Fusion Middleware 11g. Install and patch Oracle 11g release 1 on Windows 2003 for development and test servers. Upgrade Paoyer application including Oracle Forms, Reports, Discoverer, portal components from Oracle Application Server 10.1.2.3 to Oracle fusion middleware 11g. Upgrade Java application supported on OC4J at Oracle application server 10g to Weblogic server 11g. Update Oracle Leading test and adjustments of Paoyer applications to run properly on Oracle fusion middleware 11g under last patches 11.1.1.3.
• Install and Upgrade OID included in 10.1.2 platform to OIM corresponding components at Oracle Fusion Middleware 11g.

Confidential

Sr. Oracle Developer/Architect

Responsibilities:

• Senior Developer architect for CCR-R (Common Customer Repository - Relational) group. Design, develop and tuning of PL/SQL Stored procedures and Oracle database model versions 10g and 11g, to provide data to client applications, integrating database with webservices. Using Dynamic SQL sentences, ref cursors, XML functions to return XML output from a single SQL Sentence. Extract and Load (ETL) of QA Database environments using Database routines with DB Link. Tuning SQL and PL/SQL code with advance techniques and data modeling of new tables related with AT&T products. Create massive test scripts using Perl for PL/SQL API.

Confidential

Sr. Oracle DBA/Architect

Responsibilities:

• Develop a new automatic installer for Khameleon Applications over Oracle AS 10gR2 in windows. Using shell and bat scripting, awk, and oracle tools for Oracle Portal, Discoverer, Forms & Reports. Support in administration tasks such as install, upgrade, configure, tuning, administer and maintenance for internal consultants and external clients in Oracle platform including Oracle Database 9i, 10g and 11g, and Oracle Application Server 10g Release 2 with components such as: SSO, Oracle Portal, Discoverer, PL/SQL, Warehouse Builder, OC4J, Forms & Reports. Configure Oracle backups, problem resolutions, configuration, tuning and administration of Oracle DB 10g and 11g and Oracle AS. Install, upgrade, patch Oracle products. Support internal Developers in advanced options of SQL Language, PL/SQL, XML, Portal, Java Script, Discoverer, Forms and Reports.

Confidential

Sr. Oracle Consultant

Responsibilities:

• Oracle Senior Leader in project “ Oracle Maintenance Cost Reduction” to collect, gather and evaluate the Oracle products purchased, installed and licensed, compiling detailed information about users, DB options, versions, editions and platforms of Oracle Databases. I created an automatic process to gather DB options usage reading database dictionary tables and design of an web application in Java to register information about Oracle products licensed and installed. The process include Analysis of Oracle Database, Oracle application Server.

Confidential

Sr. Oracle WH/BI Architect

Responsibilities:

• Modeling a start model for a Data Mart of purchasing applications. Develop and implementation of BI reports with Oracle Discoverer over Oracle Portal including configuration of SSO, OID synchronization with AD using Oracle AS 10g R2. Configure, Administer and patches apply on Oracle DB 10gR2 and Oracle AS 10gR2. Create and administer ETL process using Warehouse Builder, Materialized Views and PL/SQL.

Confidential

Sr. Oracle Developer/Administrator

Responsibilities:

• Support in Oracle Database and development of adjustments of ERP application using Oracle Forms & Reports 6i, PL/SQL and SQL. Install, upgrade and creating backup and recovery procedure for Oracle Database 10g.

Confidential

Oracle Senior Application Server Architecture / Administrator

Responsibilities:

Responsibilities:

• Installation and configuration of Oracle Database 10g and Oracle Application Server 10g for OC4F and PLSQL application. Configuration of Oracle RAC using ASM over Linux Redhat Advanced Server. Configuration of data replication for “Bonos Pensionales” application. Configuration of database jobs for replication of files tasks using operating system shells and utilities as scp or ftp.
• Support and administration of Oracle Database 9i and 10g, using OEM. Configuration and administration of Oracle Dataguard environment with physical standby option.
• Configuration of Dataguard in Oracle 9i Database. Installation and support in Oracle Portal 9i for PLSQL developed application. Tuning of Oracle database and PL/SQL application.
• Installation, migration, administration and support of Oracle Database 10g and Oracle Application Server standard edition 10g using Oracle portal, mode PL/SQL and OC4J. Tuning of Oracle database and application. Configuration of backup and recovery policies using RMAN in a 7*24 environment. Migration of data from Oracle 8i to 10g and migration of PLSQL application.
• Workshop for in Administration of Oracle Database 9i, SQL and PLSQL.
• Consulting and support on configuration of Oracle Database 10g and Oracle Application Server. Definition of backup and recovery policies, administration of space in SAM storage, configuration of archivelog mode, tuning of Database and OC4J.
• Tuning of Oracle Database, Oracle Application Server for e-Business Suite and OC4J applications. Support in configuration of Oracle Database 9i advanced options, configuration and administration of tablespaces, datafiles, redolog files, archive log files and control files..
• Installation and configuration of Oracle Database 9i in HPUX and migration of Database and Pro*C programs from Oracle 7 and 8i over Solaris; support and administration of Oracle Database 9i using OEM. Installation configuration and support of Oracle database 10g, migration of data and Pro*C programs from 9i. Configuration and administration of Oracle database 10g using OEM database control. Configuration of RMAN repository and services to management of backup and recovery policies of Oracle Databases version 9i and 10g.