SUMMARY:

• Confidential is a Senior Solutions Architect - Oracle Apps DBA with 18 years of IT Industry experience with strong emphasis in Oracle. Confidential has valuable expertise in planning and designing implementation strategy, upgrades, migration strategy, instance and integration strategy, and building robust systems on Premise and on Cloud Infrastructure (AWS). He has diverse skillsets and experience from various database technologies such as MySQL, MS-SQL, Sybase, Oracle and Exadata, as well as applications such as Remedy, Peoplesoft, Banner, Intergraph, Business Objects, Kofax Markview, Hyperion, Informatica, OBIEE and Oracle EBusiness Suite. He has very strong knowledge of database management/monitoring, performance tuning, and reorganization; cloning and migrating Oracle databases across different platforms, upgrades, patching, as well as installing and configuring Oracle EBS Applications (R12/11i) with Oracle Real Application Clusters 11gR2 and 10gRAC, as well as Fusion Middleware applications such as Oracle Identity Management (SSO/OID), SOA/BPEL, Webcenter Portal and Weblogic. He has vast programming experience with Oracle PL/SQL, Forms, Reports, Oracle ADF/Java Framework and XML Publisher. Confidential has extensive experience in High Availability (HA) with Oracle DataGuard and database replication with GoldenGate. Confidential also has experience with migration, maintenance and management with Oracle Exadata V2 running a BI/Datawarehouse environment, as well as OBIEE 10/11g, Informatica, DAC, OWB and OBIA, and also implementation of Oracle Enterprise Manager Cloud Control 12c.
• Oracle EBS Applications R12.2/12/11i/10.7
• Fusion Middleware (Oracle OIM/OID/SSO,Access Manager,Portal,WebLogic)
• Oracle OBIEE 10g/11g, Informatica Powercenter, DAC, Warehouse Builder, OBIA
• Oracle Database 12c/11G/10G/9i/8i/7.3 RAC High Availability with Data Guard
• Oracle Exadata V2 and Oracle Goldengate
• Oracle Enterprise Manager Cloud Control 12c
• Oracle Forms & Reports 11g/10g/9i/6i/6/5/4.5
• Oracle Financials (GL, AP, AR), Projects, iProcurement, WIP, OM and HCM
• Oracle Weblogic, Portal, ASP, Javascript, HTML
• Peoplesoft 9.1 HCM and Finance
• Kofax Markview, integration with Oracle Weblogic and R12
• Business Objects XI R2 / 6.5, Hyperion Analytic Services 9.1
• Remedy ARS ITSM /OS3, Intergraph G/Technology
• MS SQL Server 2012, 2008, Sybase
• Oracle VM, HP-UX, IBM AIX, SUN Solaris, Red Hat Linux, Oracle EL

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Lead Oracle Apps DBA/ Architect of EBS R12.2.6 implementation design, capacity planning and high availability requirements.
• Setup and configure EBS R12.2.6 DEV, CRP, UAT and Production environments
• Setup cloning procedures on EBS R12.2.6 environments.
• Performance tuning of batch program and long running reports.
• Apply patches and bug fixes on Oracle R12.2.6 Apps instances
• Installed and configured Oracle Weblogic 11g for SOA integration with Oracle EBS R12.2.6 instance for SOA/BPEL for interface program
• Integration with SOA/BPEL for interface program
• Integration with 3rd party ODBC connection with SQL Server database
• Maintained, managed and administration of Oracle R12 multi-node environment
• Management and monitoring Oracle R12 instance using Oracle Enterprise Manager Cloud Control 12c.

Environment: (Oracle EBS R12.2.6, Oracle Weblogic, Oracle SOA/BPEL, OEL 7.2, Oracle RDBMS 12c, Oracle Enterprise Manager Cloud Control 12c)

Confidential

Responsibilities:

• Plan and design the implementation of Oracle Single SignOn solution for Oracle EBS R12 environment
• Install and configure Oracle Single SignOn on CNV1 EBS instance and TMGT UAT instance.
• Apply patches Oracle EBS patches for OID integration.
• Install and configure OID in non-clustered and clustered environment for High Availability
• Install and configure Oracle Access Manager in a non-clustered and clustered environment.
• Install and configure AccessGate in non-clustered and clustered environment.
• Configure the OID and MS AD integration for SSO, provisioning and synchronization.
• Install and configure OHS WebTier and WebGate in a non-clustered and clustered environment for High Availability
• Integrate OHS WebTier, WebGate, Access Gate, Access Manager and OID in a non-clustered and clustered environment for High Availability

Environment: (Oracle EBS R12.1.3, Oracle 12c RDBMS, Oracle Fusion Middleware 11g, Oracle Weblogic 11g, Oracle Access Manager 11g, Oracle OID 11g, Red Hat Enterprise Linux 5.11 Tikanga)

Confidential

Responsibilities:

• Upgrade of Oracle EBS R11.5.10.2 to Oracle EBS R12.2.4 in Oracle Enterprise Linux 5.11 and 7.2 split tier environment for Loomis US
• Maintained and managed R12.2.4 CRP, UAT and Production instances in a shared appltop and multi-tiered environment
• OATM migration of Oracle EBS R11.5.10.2 environment running on 11gR2 RDBMS
• Installation and configuration of Oracle EBS R12.2.4 Vision instance.
• Setup cloning procedures on EBS R12.2.4 environments.
• Performance tuning of batch program and long running reports.
• Patching strategies using adop for Oracle EBS R12.2.4 environments.
• Upgrade Discoverer 4i to Discoverer 11g
• Upgrade of Oracle EBS R11.5.10.2 to Oracle EBS R12.2.4 On Oracle Enterprise Linux 7.2 environment for Nifco America
• Upgrade of Oracle database 11gR2 to 12.1.0.2 version.
• Maintained and managed DMZ for iStore and iSupplier EBS R12
• Implement and managed Oracle EBS VCP R12.2.4.1

Environment: (Oracle EBS R12.2.4, Oracle EBS 11.5.10.2, Oracle Weblogic, Oracle 11gR2 RDBMS, Oracle RDBMS 12c, Oracle Enterprise Cloud Control 12c, Oracle Discoverer 11g OEL 5.11 and OEL 7.2)

Confidential (Miami FL)

Responsibilities:

• Plan and design the implementation of Oracle Fusion Apps 11.1.8 on AWS Cloud environment
• Install and configure Oracle Fusion Applications 11.1.8 on AWS Cloud
• Maintained, managed and administration of Oracle Fusion Applications 11.1.8 on AWS Cloud environments.
• Apply patches and fixes on Oracle Fusion Applications 11.1.8 POC and Development instance
• Install and configure Oracle EBS 12.2.5 on AWS Cloud
• Install and configure Oracle RDBMS 12c RAC on AWS Cloud
• Plan and design the implementation of Oracle EBS R12.2.4 Supplier Data Hub.
• Provide lead role in designing system architecture for EBS R12.2.4
• Install and configure R12.2.4 in Dev, Test and Production.
• Implement instance strategy for R12.2.4 environments.
• Cloning and migration of Oracle R12.2.4 Apps instances across multiple environments.
• Maintained, managed and administration of Oracle R12.2.4 in multi-node environments.
• Apply patches and bug fixes on Oracle R12.2.4 Apps instances
• Establishment and documentation of cloning and refresh strategy of R12.2.4 instances.
• Create automated cloning and refresh scripts for R12 instances.
• Provide capacity planning strategy for EBS R12 Infrastructure.
• Provide analysis and support for the existing EBS R11i archiving strategy
• Provide management and support for Reusable SOA Framework project
• Migration of SOA Framework components to multiple environments
• Analysis and design for Fusion Middleware SOA Framework architecture
• Provide an architecture that will integrate with WFS’s existing SOA Development effort, but has the flexibility, capacity, and “future proofing” to perform integration with WFS Customer & Partners community if required.
• Implementation of Resuable SOA Framework that includes 2 Trading Partners, 2 Inbound SOA Transactions, EBS integration, and BAM Dashboards & OER setup

Environment: (Oracle EBS R12.2.4, Oracle 11gR2 RDBMS, Oracle10gAS, Oracle Fusion Middleware 11g, Oracle Weblogic 11g, Oracle Sun Solaris 11, Oracle Enterprise Linux 6, Oracle Enterprise Manager Grid Control 12c)

Senior Principal Consultant

Confidential (Houston TX)

Responsibilities:

• Plan and design the implementation of Oracle EBS R12 iSupplier Portal.
• Install and configure iSupplier Portal in Dev, Test and Production.
• Configure iSupplier Portal on TPC DMZ environment.
• Troubleshoot iSupplier Portal to work with Barracuda reverse proxy
• Implement instance strategy for iSupplier Portal Dev and Test
• Cloning and refresh of iSupplier Portal Dev and Test environments from Production
• Provide guidance and strategy on how to setup a DMZ iSupplier Portal.
• Worked with Network and Sysadmins on firewall, DNS and reverse proxy configurations.
• Technical documentation and knowledge transfer of iSupplier Portal implementation to TPC IT resources.
• Performance tuning of custom Oracle forms, reports and batch programs.
• Performance tuning of TPC EBS R12 Production database.

Environment: (Oracle EBS R12.1.3, Oracle 11gR2 RDBMS, Oracle10gAS, Barracuda Reverse Proxy)

Senior Principal Consultant

Confidential (Houston TX)

Responsibilities:

• Plan and design the implementation of Oracle Webcenter Portal 11g and integration with Oracle IDM SSO with Access Manager
• Install and configure Fusion Middleware product Weblogic 10.3.6, database repository schemas, OIM, OID, WebTier, Webgate and Oracle Access Manager
• Upgrade Oracle Portal 10g to Oracle Webcenter Portal 11g.
• Lead role in designing and re-engineering of S&B’s current reporting strategy and as well integrating their existing custom Oracle forms and reports with Oracle Webcenter Portal
• Redeveloped and performance tuning of custom Oracle PL/SQL batch programs
• Remediate Oracle Forms and Reports 10g custom programs
• Implement instance strategy for Oracle R12 EBS upgrade environments
• Primary DBA responsible for building and managing Oracle EBS R12 and 11i Release 11g RDBMS.
• Oracle Database characterset conversion from US7ACII to UTF8.
• Installed, patched and upgrade databases from Oracle 11.2.0.3 to 11.2.0.4 DB versions.
• Lead DBA for the upgrade of Oracle EBS R11.5.10.2 to R12.1.3 for CRP1, CRP2 and UAT in Solaris 10 and 11 environments.
• Migrated R11i and R12 instance from Solaris 10 to Solaris 11.
• Installation and configuration of Oracle R12 and 11i Application and databases.
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
• Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.

Environment: (Oracle Fusion Middleware - Oracle Webcenter 11g, Oracle Weblogic, Oracle EBS R12.1.3, Oracle10gAS, Oracle Webcenter Portal 11g, Oracle 11gR2 RDBMS, Active Directory, Kerberos, Solaris 10/11)

Confidential

Responsibilities:

• Implement cloning strategy for Oracle R12 EBS environments
• Implement monitoring mechanism on Oracle EBS R12 environments
• Performance tuning of EBS long running programs
• Patching strategy for RUPs, minipacks, family packs and bug fixes on Oracle EBS R12.
• Implement OBIEE Maintenance Procedure.
• Implement OBIEE Purging and Caching mechanism.

Environment: (Oracle EBS R12.1.3, Oracle10gAS, Oracle 11gR2 RDBMS, OBIEE 11g, OBIA, Infromatica)

Confidential (Houston TX)

Responsibilities:

• Plan and design the implementation of Texas Children’s High Availability requirements with Oracle Dataguard 11g using Oracle Enterprise Manager Cloud Control 12c
• Setup and configure Oracle Enterprise Manager Cloud Control 12c for Enterprise database management, monitory and maintenance with Dataguard.
• Install and configure Oracle Weblogic 10.3.6 and repository database.
• Build HCMPRD (Peoplesoft 9.1) Primary Standby database (local in Datacenter) and Secondary Standby database in remote Datacenter using Oracle Dataguard 11gR2 with OEM 12c.
• Configure Fast Failover between Primary and Standby Oracle 11gR2 databases.
• Implement Oracle 11g Dataguard Observer for seamlessly and automatic failover to Standby database in case of failure or disaster with Dataguard broker.
• Configure Peoplesoft 9.1 HCM application for Transparent Application Failover to Primary Standby in case of Disaster, as well as to Secondary Standby in case of Disaster in Primary Datacenter.
• Managed and troubleshoot issues, and work closely with Oracle DBAs and client end-users to faster resolution and documentation.

Environment: (Peoplesoft 9.1 HCM, Oracle 10g RDBMS, Oracle 11gR2 RDBMS, Oracle Dataguard, IBM AIX 7.1, Oracle Weblogic, and Oracle Enterprise Manager Cloud Control 12c)

Senior Oracle DBA

Confidential

Responsibilities:

• Implementation and upgrade strategy for Oracle 10g SSO to Oracle 11g IDM SSO with Access Manager, and integration with Active Directory
• Lead the team in building new environments and coordination with offshore team
• Install and configure Single Sign-On using Oracle Identity Management (Oracle Access Manager, Oracle WebGate and Oracle Internet Directory) release 11g.
• Migrated Oracle EBS R12 from Oracle OOD to client datacenter.
• Integrate Oracle Internet Directory with Oracle E-Business Application R12.1.3 instance.
• Integrate Oracle Access Manager with Oracle OID and define policies.
• Integrate Oracle Access Manager with Oracle E-Business Suite Application 12.1.3.
• Integrate LDAP MS Active Directory with Oracle Internet Directory.
• Migration strategy for Oracle R12 EBS Production environment from Oracle On-Demand Datacenter to ITC Managed Datacenter
• Migrate EBS R12 instance from Oracle On-Demand Datacenter to ITC Datacenter.

Environment: (Oracle Fusion Middleware - Oracle Identity Management (Oracle Access Manager, WebGate, SSO/OID, Weglogic, Oracle EBS R12.1.3, Oracle 10g RDBMS, Oracle 11gR2 RDBMS, Oracle Dataguard, Active Directory, Kerberos, Oracle Linux)

Confidential

Oracle Apps DBA

Responsibilities:

• POC for EBS 11.5.10.2 to R12.2.3 upgrade
• Plan and design integration strategy of Oracle EBS instances.
• Worked with Functional and Development resources in reviewing and fixing various application and database issues/bugs.
• Lead the team in managing critical issues, and coordinating with client management with action plans to address critical issues and resolutions.
• Managing tasks between offshore and US resources for timely and crystal clear handover to ensure 24/7 operation.
• Migration of Oracle EBS 11i instance from OOD (Oracle On Demand) environment to ITC Managed Services.
• Maintained, managed and administration of Oracle R12 multi-node environment and 11i environment integrated with various applications such as KofaxMarkView, GRC, SOA/BPEL, Vertex and Hyperion.
• Installed and configured Fusion Middleware Weblogic with SOA/BPEL and Markview.
• Upgrade of Oracle database 10g RAC to 11gR2 RAC
• Managed and troubleshoot issues, and work closely with client end-users to faster resolution and documentation.
• Manitowoc was founded in the lakeshore community of Manitowoc, Wisconsin, in 1902 as a shipbuilding and ship-repair organization, and currently have operations in 26 countries around the world.
• Plan and design implementation strategy for Oracle EBS 11i upgrade to R12
• Upgrade of Oracle EBS R11.5.10.2 to R12.1.3 on DEV, TST and PROD instances for The Room Place.
• Upgrade of Oracle EBS R11.5.10.2 to R12.1.3 on DMWACI, TMWACI and PMWACI instances for Manitowoc.
• Primary DBA responsible for building and managing Oracle EBS R12 and 11i Release 10g RDBMS and 11gRAC databases.
• Installed, patched and upgrade databases from Oracle 11.1.0.7 to 11.2.0.2 DB versions.
• Installation and configuration of Oracle R12 and 11i Application and databases.
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
• Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.
• Install, configure and managed Oracle R12 MWA / WMS.

Environment: (Oracle EBS R12 (12.1.3) Application, Oracle EBS 11.5.10.2, Oracle Fusion Middleware (Oracle Identity Management, SOA/BPEL and Weblogic), Oracle GRC, Markview, Vertex O’ Series, Oracle 10g RAC, Oracle 11gR2 RDBMS, Oracle VM, Oracle Enterprise Linux)

Confidential

Responsibilities:

• Provide leadership in designing system architecture for PCI Compliance implementation
• Lead role in RAC database design, capacity planning, database tuning and system architecture
• Lead role in designing system architecture for EBS R12 implementation for North America, Canada, EMEA and South America.
• Provide and mentoring for client DBA staff in management of R12 databases
• Conducted Oracle 11g Performance Tuning for application developers
• Developed coding standards, documented cloning process and database design procedures
• Installed and configured Oracle Weblogic 11g for SOA integration with Oracle EBS R12 instance.
• Responsible for building and managing Oracle R12 11gRAC ASM databases
• Oracle11g RAC ASM Database monitoring, performance, tuning and reorganization
• Installed, patched and upgrade databases from Oracle 11.1.0.7 to 11.2.0.1 DB versions
• Installation and configuration of Oracle R12 Application and databases
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle R12 Apps instances
• Cloning and migration of Oracle R12 Apps instances across multiple environments
• RAC to RAC, RAC to non-RAC and non-RAC to RAC cloning of Oracle R12 environments
• Setup and configure multi-node Oracle R12 environment in Dev and Test
• Configure Oracle EBS R12 environment for PCI Compliance
• Install, configure and managed Oracle R12 MWA / WMS.
• Maintained, managed and administration of Oracle R12 multi-node environment
• Management and monitoring Oracle R12 instance using Oracle 11G Enterprise Manager Grid Control.
• Migrate Oracle EBS R12.1.3 from 11gR2 RAC to Oracle Exadata V2.
• Install and configure Oracle GoldenGate for data replication.
• Configure data replication between Oracle Datawarehouse database and EBS
• Management of Oracle Exadata running a BI/Datawarehouse environment
• Prepare the R12 environment for PCI Compliance

Environment: (Oracle ERP R12 (12.1.3) Application, Oracle 11gR2 RAC ASM, Oracle Exadata V2, Oracle 11G Enterprise Manager Grid Control, Oracle Enterprise Linux, IBM AIX)

Confidential

Responsibilities:

• Provided the lead role in performance tuning of existing OBIEE Datawarehouse database.
• Generate AWR reports to monitor performance of OBIEE database.
• Generate trace files and tkprof output to further analyze poor SQL statement performance.
• Create materialized views to fine tune OBIEE reports.
• Modify init.ora parameters to further fine tune the database.
• Propagate performance tuning changes in DEV, TEST and Production environment.

Confidential

Responsibilities:

• Provide the lead role in the technical upgrade of existing R11i to R12.
• Conducted testing and dry run to upgrade existing R11.5.10 instance to R12.0.4
• Developed and revised custom programs i.e check printing reports
• Upgrade Database 10.1.5 to 10.2.0.4
• Upgrade Oracle Applications EBS 11i to R12.0.6
• Oracle Forms and Reports 10g
• Upgrade of Oracle Discoverer 4i to Oracle Discoverer 10g
• Upgrade Oracle 9i to 10g database for Banner application
• Support user testing for Banner applications 8.2

Confidential

Responsibilities:

• Re-implement the existing Oracle Enterprise Manager 10g Grid Control to allow monitoring and spanning of Applications, middleware and database management.
• Cleanup the existing Notification Rules configuration and implement Database Monitoring standards as per AvivaUSA requirement.
• Perform diagnostic, application and database health check on the current OEM Grid Control environment
• Create test planet and conduct testing in Dev, Test and Production environment.

Confidential

Responsibilities:

• The Apollo short-term engagement involves migration of the current Oracle 11i EBS environment to OATM.
• Provided the lead role in OATM database migration
• Migration of 2.3 terabyte Oracle 10G database to OATM
• Fine tune OATM migration
• Dry run and testing in Development environment to accommodate the 3 days windows allowed for the activity to complete.

Confidential

Responsibilities:

• Oracle Applications environment health check
• JVM settings, Purging and archiving analysis
• Concurrent request management
• 11i Patchsets, Auditing and Security
• Log Analysis
• Oracle Database Health check
• Database I/O contention, Shared pool contention and utilization, latch contention, undo utilization, instance parameters
• Security evaluation
• Backup and Recovery and Performance and Scalability
• Identify resource intensive SQL statements

Confidential

Responsibilities:

• Lead role in designing system architecture for EBS R12 implementation
• Responsible for building and managing Oracle R12 instances
• Database monitoring, performance, tuning and reorganization
• Installed, patched and upgrade databases from Oracle 10.2.0.3 to 11.1.0.6 versions
• Installation and configuration of Oracle R12 Application and databases
• Maintenance and management of OracleR12 Dev, Test, UAT and production DBs
• Applied patches minipacks, family packs and bug fixes on Oracle R12 Apps instances
• Cloning and migration of Oracle R12 Apps instances across multiple environments
• Setup and configure multi-node Oracle R12 ERP environment in Production and UAT
• Maintained, managed and administration of Oracle R12 ERP multi-node environment
• Management and monitoring Oracle R12 instance using Oracle 10G Enterprise Manager Grid Control
• Configured and managed Oracle R12 Workflow

Environment: (Oracle ERP R12 (12.0.5) Application, Oracle 10G Enterprise Manager Grid Control, Oracle 10G/11G Database, Red Hat Linux)

Oracle 11i Apps DBA / Oracle DBA

Confidential

Responsibilities:

• Responsible for building and managing Oracle databases for the following applications: Oracle 11i ERP, Oracle IM/OID/SSO, MDSI Advantex, Remedy, Intergraph, Metasolv, Oracle Communications ASAP, Business Objects XI R2, Hyperion, Geneysis, Siebel 7.8, Informatica PowerCenter 8.11, Comverse Kenan/BP, NetCool/Proviso
• Configured, installed, managed and administer Business Objects XI application and DB
• Configured, installed, managed and administer Remedy ARS 7 and DB, High Availability and Load Balancing
• Database monitoring, performance, tuning and reorganization
• Cloning and migrating Oracle databases across different platforms
• Installed, patched and upgrade databases to Oracle 10.2.0.3, 10.2.0.2 versions
• Installation and configuration of Oracle 11i Application and databases
• Maintenance and management of Oracle11i dev, test, UAT and production DBs
• Applied patches minipacks, family packs and bug fixes on Oracle 11i Apps instances
• Cloning and migration of Oracle11i Apps instances across multiple environments
• Configured Oracle Database DataGuard environment for Oracle 11i database
• Maintained, managed and administration of Oracle11i ERP multi-node environment
• Configured and managed Parallel Concurrent Processing on Oracle 11i environment
• Configured and managed Oracle 11i Workflow and Oracle Discoverer 10g
• Configured and Managed Oracle Identity Management (SSO/OID)
• Integrated Oracle 11i ERP with Oracle Internet Directory and Single Sign-On (SSO)

Environment: (Oracle 11i (11.5.10.2) Application, MDSI Advantex, Intergraph, Hyperion, Metasolv, Oracle Communications ASAP, Remedy, Business Objects XI R2, Siebel 7.8, Informatica, Comverse Kenan/BP, NetCool/Proviso, Oracle 10G/9i Database, HP-UX11 Unix, Windows 2003 Server, Sun Solaris 9)

Confidential

Oracle Apps DBA / DBA (Remote DBA)

Responsibilities:

• Provided technical support to the developers and users regarding database problems, bugs and patches
• Provided technical support to ERP, Clarify and JAVA developers in tuning SQL statements and batch programs
• Developed PL/SQL batch programs for uploading data from OLTP databases to Data Warehouse database
• Assisted developers in Oracle Forms and Reports programming
• Migrated existing Oracle9i databases to Oracle10g RAC database
• Database and schema creation; and Database backup and recovery
• Database monitoring, tuning and reorganization
• Moving forms, reports, and database objects into production
• Database tuning using Oracle Trace event 10046
• Cloning Oracle Apps instances
• Systems Admin for Oracle Applications
• Deployment BO universe files and LOVs to BOPROD repository database
• Maintenance and management of Business Objects (BO) repository database
• Maintain, manage and administer Clarify CRM and Broadvision application

Environment: (Oracle Applications 10.7SC, Business Objects, Oracle 10G RAC Database, Oracle 9i Database, Oracle 8i Database, Clarify Applications, Broadvision, AppWorx, HP-UX11 Unix, Windows 2000 Server, Red Hat Linux 8.0)

Confidential

Oracle DBA/Technical Consultant/Trainer

Responsibilities:

• Provided technical support to the developers and users regarding database problems, bugs and patches.
• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Migrated client database into off-site database in Manila.
• Setup SYMBOLS 8.2 environment for developers.
• Backup and restore of databases.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of Ceska databases.

Confidential

Responsibilities:

• Migrated client database into off-site database in Manila.
• Backup and restore of database.
• Setup and configuration of SYMBOLS 8.2 version application
• Maintenance and management of the different versions of EBH databases.

Confidential

Responsibilities:

• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Provided technical support to the developers and users regarding database problems, bugs and patches.
• Setup and configuration of SYMBOLS 8.3 version application.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of MCB databases.

Confidential

Responsibilities:

• Provided technical support to the developers and users regarding database problems, bugs and patches.
• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Setup and configuration of SYMBOLS 8.3 version application.
• Performance tuning of application and database.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of CDB databases.
• Environment (SUN Solaris 8, Red Hat Linux Advanced Server 2.1, Windows 2000 Server, Windows 2003 Server, Oracle 9i Database, Oracle 9i Application Server Rel2, Oracle 9i Developer Suite, Oracle 8i Database, Oracle Forms 6i, Oracle Reports 6i, Oracle 7.3.4 Database)

Confidential

Oracle DBA/Team Leader and Technical Consultant

Responsibilities:

• Online Registration and Database Migration
• Conducted Oracle 9i on PL/SQL, Forms and Reports and Database Administration
• Developed coding standards and naming conventions to be used in all the systems of PEZA including table names, sequence names, index names, constraints names, stored procedure, function names and program names.
• Supervised and led the team in the development of the eRegistration System including the Functional Analysis, System Analysis and Design and the integration of the eRegistration System into the existing PEZA website using Oracle Forms9i and Oracle Reports9i
• Installation and configuration of the Oracle 9i database, Oracle 9i Application Server, as well as the Linux Advance Server to be used for the development and production.
• Installation and configuration of Linux Advanced Server and Oracle 9i Backup database.
• Migrated existing Oracle 8i database to Oracle 9i database. This task includes the migration of the existing PEZA Registration System into the Oracle 9i production database.

Environment: (Red Hat Linux Advanced Server 2.1, Oracle 9i Database, Oracle 9i Application Server Rel2, Oracle 9i Developer Suite)

Technical Consultant

Confidential

Responsibilities:

• and Technical Consultant
• Provided technical support to developers on Oracle11i (Order Management reports customization.
• Prepared exercises for the topics discussed.
• Conducted remote sessions on Oracle SQL/PLSQL, Oracle Forms 6i and Reports 6i.
• Conducted remote and on-site sessions on Advance Oracle Forms 6i and Reports 6i.
• Conducted remote and on-site sessions on Oracle8i DBA Fundamentals I.
• Conducted remote and on-site sessions on Oracle8i DBA Fundamentals II.
• Conducted remote and on-site sessions on Oracle8i DBA Performance Tuning
• Made sure that each topic discussed is well understood by the trainees.
• Installed and configure Oracle9i Database on Red Hat Linux Advanced Server 2.1.

Environment: (Red Hat Linux Advanced Server 2.1, Oracle Financials 11i, Oracle 8i Database, Oracle 9i Database, Oracle Forms 6i, Oracle Reports 6i)

Confidential

Oracle DBA/Systems Analyst

Responsibilities:

• Implemented information systems for the financial and project management application requirements of the project. The project involved the development of a Project Financial Information System for the Highlands Road Maintenance Group of the Department of Works, Papua New Guinea (DOW), using Oracle’s development tools and Oracle database, and upgrading of DOW IT staff technical skills through Oracle Program.
• Instructor on Oracle Database Administration and Oracle
• PL/SQL, Forms and Reports programming
• System analysis and design; development and database design of PFIS from an Oracle Application 10.7 (GL, AP and AR) modules.
• Program and debug screen and report modules needed by the system.
• Conducted client presentations to senior management levels of the department.
• Maintained and managed PFIS Database.
• Conducted technical on Oracle PL/SQL, Forms and Reports
• Conducted technical on Oracle Database Administration particularly installation on SCO UNIX platform, creation and database management, backup and recovery, and troubleshooting database problems.
• Conduction technical on SCO UNIX including installing, configuration, backup and recovery procedures.

Environment: (SCO Unixware 7.01, Developer 2000 Forms and Reports, Oracle 7.3.4 Database, Oracle Financials 10.7)

IT Specialist

Confidential

Responsibilities:

• Survey Program and DTS which has the main objective of developing a flexible and sustainable system for the road traffic data collection and monitoring in the Vietnam Road Authority.
• System Analysis and Design for the application.
• Developed programs using Oracle Forms and Reports.
• Conducted Oracle (SQL/PLSQL, Forms/Reports and DBA)
• Developed programs using Visual Basic 6, Map Object and ESRI GIS
• Prepared the Acceptance Test Plan and User Manual.

Environment: (Oracle RDBMS 9i, Oracle Forms/Reports 9i, Visual Basic 6, Sybase ASE 12, GIS Arcview3.2, MapObjects 2, Win2k Server)

Confidential

Responsibilities:

• System analysis and design; development and database design.
• Managed client deliverables, meetings and presentations.
• Maintained and managed PSIS Database.
• Developed programs using Oracle Forms 6i and Reports 6i.
• Prepared the Acceptance Test Plan and User Manual.

Environment: (Win2k Server, Oracle 8i Database, Oracle Forms and Reports 6i,TOAD)

Confidential

Oracle DBA/Systems Analyst/Programmer

Responsibilities:

• Created temp tables to handle Data Conversion.
• Created stored procedures and data scripts for data validation using Oracle PL/SQL.
• Load data from Legacy system to Oracle database.
• Maintained and managed Oracle database by doing cold backup and creating UNIX scripts for backup procedures.
• Environment (SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server)

Confidential

Oracle DBA/Senior Oracle Programmer

Responsibilities:

• Developed programs for screens and reports modules needed by the system.
• Impact analysis for clients change requests.
• Performance tuning for batch programs, screens and reports.
• Maintained and managed HKMS database.
• Created batch processing programs (stored procedures, functions and packages).

Environment: (HP-UX Unix, Win98, Oracle 8i database, Oracle Designer 6, Oracle Developer Forms 6.0 and Reports 6.0)

Project: DOTC

Responsibilities:

• Maintained and managed Oracle database includes cloning and creating new DB.
• Developed programs for screen and report modules (General Ledger, Accounts Payable and Accounts Receivable).
• Customization of reports in Oracle Payables, Oracle Receivables and GL.
• Impact analysis for clients change requests.
• Performance tuning of reports.

Environment: (NCR Unix, Win98, Oracle Financials 10.7, Oracle 7.3.4 database, Oracle Developer 2000 Forms and Reports)

Confidential

Oracle DBA/Senior Oracle Programmer

Responsibilities:

• Implementation of Web-based Application Systems, Database Migration, and and Transfer of Skills for the Department of Budget and Management.
• The project involved the creation of a prototype Corporate Portal for the
• Philippine Government’s Department of Budget and Management (DBM) thru the web-deployment of four key application systems using Oracle’s WebDb tool and Oracle 8i database.
• Budget Preparation and Management System (BPMS)
• Government Manpower Information System (GMIS)
• Manpower Management Information System (MMIS)
• Document Tracking System (DTS)
• DECS - School Building Information System
• Developed a web-based HWI/SRP Monitoring System, Accounts Payable, LGU AIP Monitoring System and SEMP LOAN Monitoring System.
• Creation and maintenance of Oracle database.
• Migrated table and data from Sybase to Oracle 8i.
• Maintained and managed BPMS, GMIS, and MMIS databases.
• Developed a database design; create tables, constraints and indexes.
• Developed programs for the system (SCREENS, REPORTS & CHARTS).
• Performance tuning for batch programs, screens and reports.

Environment: (Win NT4, Oracle8i database, Oracle WebDB, Oracle Designer 6,Oracle Forms 6.0 Reports 6.0, Oracle Reports Server)

Confidential

Responsibilities:

• A client/server application designed to monitor the attendance of employees of SUN Microsystems Philippines. It includes filing of leave; overtime and generation of leave credits.
• System analysis and design which includes ERD and Dataflow Diagrams.
• Maintained and managed AMS database.
• Development of screens and reports needed by the system.

Environment: (SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server)

Confidential

Responsibilities:

• System analysis and design; which includes ERD and Dataflow Diagrams.
• Maintained and managed CAS database.
• Development of the system screens and reports

Environment: (SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server)

Confidential

Responsibilities:

• Performed system investigation and conduct interviews with the users.
• Developed database design; create tables, constraints and indexes.
• Maintained and manage TLMS database.
• Developed programs for screen and report modules needed by the system.
• Performance tuning for batch programs, screens and reports.

Environment: (Win95, Oracle 7.3.4 database, Oracle Designer2000, Oracle Developer 2000 Forms and Reports 4.5/2.5)

Confidential

Responsibilities:

• Developed programs for the Prototype (SCREENS and REPORTS)

Environment: (Win95, Oracle 7.3.4 database, Oracle Developer 2000 Forms and Reports 4.5/2.5)

Confidential

Responsibilities:

• Creation and maintenance of Oracle database.
• Developed database designed; create tables, constraints and indexes.
• Developed programs for screen and report modules needed by the system.

Environment: (Win95, Oracle 7.3.4 Database, Oracle Designer2000, Oracle Developer 2000 Forms and Reports 4.5/2.5)

Confidential

Responsibilities:

• Billing System, Payroll System and Inventory System
• Revised programs of screen and report modules to become Y2k Compliant

Environment: (Win95, Oracle 7.3.4 Database, Oracle Developer 2000 Forms and Reports 4.5/2.5)