Elizabeth Wenegieme, Ph.D., OCP

AppsDBA

*** *. ******* ***

Aurora, CO 80017

Tel: 303-***-****

E-mail: adyn00@r.postjobfree.com

OBJECTIVES:

To secure a contract position as an Oracle Applications DBA.

Capabilities:

An Oracle 12c Certified Database Administrator.

An Oracle Applications 10.7, 11.0, 11i, 12.1 and 12.2 Database Specialist.

Development of projects from start to finish.

Oracle Applications DBA with over 19 years of experience implementing, developing and maintaining Oracle Databases v 7, 8, 8i, 9i, 10g, 11g and 12c and Oracle Applications Release 10.7(SC, NCA), 11, 11i and 12.1 and 12.2.

Background includes backup and recovery, database tuning, process monitoring, patch applications and overall database maintenance, creating tables, indexes, constraints, views, sequences, synonyms and privileges, database installations and upgrades, oracle applications install, maintenance and upgrades.

Strong communication skills and technical knowledge.

Unix shell scripting and PL/SQL

Oracle Applications customizations.

APEX.

Technical Skills:

Database

Oracle vs. 7, 8, 8i, 9i, 10g, 11g and 12c, RAC, ASM, RMAN

Oracle Applications

Release10.7 (SC, NCA), 11, 11i, 12.1.3 and 12.2.4

PA, AP, AR, GL, FA, PO, HR, Payroll, Self Service Web Applications, Self Service Human Resources, Oracle Applications Workflow, PIM(MDM), Manufacturing

Development Tools

Developer 2000 (Forms 4.5, 5.0, 6i, 10, Reports 2.5, 3.0, 6i,10), SQL*Reports, SQL*Plus, SQL*Loader, PL/SQL, SQL*NET, Enterprise Manager, C shell programming, Oracle Applications Fast Formulas, Oracle Discoverer, Crystal Reports, Oracle Workflow Builder, APEX.

Hardware/Operating System

UNIX (SUN/Solaris, IBM RS6000/AIX, HP-Unix), Windows NT, Redhat Linux, Oracle Linux, Oracle Database Appliance(ODA)

Professional Experience:

AppsDBA 01/11 - Present

Oracle Applications Database Administrator Consultant

Oracle EBS 12.1.3 to 12.2.6 upgrades

Oracle EBS 12.2.2 to 12.2.4 upgrade

Oracle EBS 11.5.10.2 to 12.2.3 upgrades

Oracle EBS 12.1.3 to 12.2.2 upgrades

Oracle EBS PIM implementation

Oracle EBS 11.5.10.2 to 12.1.3 upgrades

Oracle EBS 12.1.1 to 12.1.3 upgrades

Oracle Database 10.2.0.4 to 11.2.0.2 upgrades

Oracle database 11.1.0.7 to 11.2.0.2 upgrades

Oracle EBS and f5 load balancer implementation

Complete Day to day database administrations for clients

Complete Oracle Applications maintenance for clients

Oracle Applications patching

Oracle 12c Database upgrades

Oracle Discoverer install and Configuration

OBIEE Install and Configuration

EMGC install and configuration

Oracle EBS 12.2.3 maintenance

eSolutions 09/08 – 01/11

Oracle Applications Database Administrator

Complete Day to day database administrations for clients

Complete Oracle Applications maintenance for clients

Oracle Applications patching

Oracle Applications 12 installation and maintenance

Oracle 11g RAC installation

Oracle Applications cloning

Oracle OEM GRID Control EBS plugin installation and administration

Graebel companies 09/05 – 09/08

Lead Oracle Applications Database Administrator

Managing a team of 3 DBA’s

Oracle Applications 11i cloning and Oracle Applications 11i refreshes.

Oracle Applications 11i System Administration

Oracle Applications database maintenance

Oracle Applications Database Upgrades.

Oracle Applications upgrades and patches.

Oracle 10g iAS Installation and implementation.

Oracle Discoverer Administration.

Debugged and modifying UNIX shell scripts and PL/SQL triggers.

Oracle Applications 11.5.7 to 11.5.10.2 upgrade.

Oracle Database 10g upgrades.

Oracle Collaboration Suite Install and Management.

OID/AD managerial exposure.

BPEL managerial exposure.

BI Publisher managerial exposure.

RMAN implementation.

Disaster Recovery implementation

OEM GRID Control.

Oracle APEX install and administration.

City Of Englewood 01/03 – 09/05

Oracle Applications Database Administrator

Oracle Applications 11i cloning and Oracle Applications 11i refreshes.

Oracle Applications 11i System Administration

Oracle Applications Database maintenance

City of Englewood Utility System Implementation.

City Of Englewood Oracle Applications Implementation.

Sql Server Database Administration.

Oracle Applications Database Upgrades.

Oracle Applications upgrades.

Oracle 10g iAS Installation and implementation.

Oracle Discoverer Administration.

Debugged and modifying UNIX shell scripts and PL/SQL triggers.

Oracle Applications Forms and Reports customizations.

Oracle Applications 11.5.7 to 11.5.8 upgrade.

Oracle Applications 11.5.6 to 11.5.9 upgrade.

Oracle Database 10g Install and Management.

Oracle Dataguard.

INTERACTIVE BUSINESS SYSTEMS 05/02 – 01/03

Oracle Applications Consultant/Database Administrator

City Of Englewood Oracle Applications Implementation.

Oracle Applications database maintenance

Oracle Applications database patching and upgrades

Oracle Applications Database Upgrades.

Oracle Applications 11i cloning and Oracle Applications 11i refreshes.

Oracle Applications 11i install and configuration.

Oracle Applications HR extracts creation.

Oracle Applications Custom Applications.

Oracle Applications 11.5.6 to 11.5.7 upgrades.

SofTec Solutions, Inc. 10/00 – 03/02

Oracle Applications Consultant/Database Administrator

Oracle Applications 10.7 (SC) to 11.5.4 upgrades.

Oracle Applications 11.5.3 to 11.5.6 upgrades.

Oracle Applications 11.5.1 to 11.5.3 upgrade.

Large database administration.

Performed Oracle Financial Applications upgrade from 11.5.2 to 11.5.4

Installed new Oracle Applications 11.5.3 instance and applied post 11.5.3 patches to PA, FA, GL, AR.

Oracle Applications DBA for backup and recovery, database tuning, process monitoring, patch applications and overall database maintenance.

Oracle Applications 11i cloning and Oracle Applications 11i refreshes.

Oracle Applications 11i System Administration, database maintenance and database redistribution to fit OFA standards.

Database Administration for Oracle Applications 11i implementation on UNIX Platform (SUN SOLARIS, HP UNIX) and Oracle 8i Database.

Responsible for Oracle Database migration from 7.3.4 to 8i.

Converted Oracle Applications 11i from WebDB to single Apache Listener.

Debugged and modifying UNIX shell scripts and PL/SQL triggers.

Migrated production, test and development databases.

Applied Oracle Applications patches to fix bugs.

Used Oracle Applications DBA tools on Forms Server and Database Server.

Managed NCA middle tier (Forms Server) processes for Applications.

Applications database – configured backups, implemented automatic email alert and wrote UNIX scripts.

Resolved space, rollback, security, locking and fragmentation issues with databases.

Set up DBA scripts for remote database administration.

Oracle Applications 10.7, 11 and 11i troubleshooting.

Sql Server to Oracle database conversion.

Immedient 9/00 – 10/00

Oracle Consultant/Database Administrator

In-house Oracle Database Administration v 7.3.4 and 8i for corporate clients.

Redesigned database, modified sequences, rebuilt indexes, ER diagrams and implementations of new business rules.

Fine tuned SQL statements to speed up returns.

CH2MHILL 6/99 – 8/00

Oracle Applications Developer

Maintained support for Oracle Applications 10.7 NCA (PA/AP/AR/GL/PO).

Included change requests on Oracle native forms and reports and Object Library.

Created new reports, forms and scripts to support application.

Created responsibilities, assigned roles and performed roles within concurrent manager.

Built scripts to bridge in-house applications into Oracle Application modules.

Used SQL*Loader to load flat files into Oracle.

CORTECK SYSTEMS, INC. 9/97 – 5/99

Oracle Database Administrator/Developer

Maintained Oracle 7.3 Database on Windows NT and Unix Platform.

Included backup and recovery procedures, tablespace management and Liaison to developers to fine tune SQL statements.

Designed database, maintained physical data structure, database installation and conversion.

Determined and resolved data security, disaster recovery, performance monitoring and tuning.

SQL*PLUS: Created tables, indexes, constraints, views, sequences, synonyms and privileges. Wrote SQL queries using SELECT statement to join multiple tables to retrieve information from database. Used INSERT, UPDATE and DELETE to create, modify and delete records in table.

PL/SQL: Wrote several PL/SQL blocks, procedures, functions, packages and triggers to fine-tune basic SQL commands.

Forms: Developed Oracle Forms 4.5/5.0 GUI applications. Created text items, radio buttons, List of Values (LOV'S), Alert (dialog boxes), block level triggers, item level triggers and libraries.

Reports: Built Oracle reports using Reports 2.5/3.0. Included Master-Detail, Simple Matrix, Nested Matrix, Parameterized and Drill Down reports.

Oracle Database 9i installation and administration.

CLIENTS INCLUDE:

1.Department of Energy, Idaho Falls, Idaho.

Oracle Applications (Public Sector) implementation with HR/Payroll, Project Accounting, and Full Oracle Financials.

2.Boulder County, Boulder, Colorado.

Oracle Applications database 7.3.4 to 8.1.6 upgrade.

3.Denver Sheriff Department, Colorado.

Developed a mobile computing system for jacket information (Citizen servings), Oracle 8.1.6 database, Oracle Forms(6i) and Oracle Reports(6i).

4.Rock Bottom, Colorado

Oracle Applications 10.7 (SC) to 11.5.4 upgrade.

5.Republic Financials Corporation

Oracle Applications and Database maintenance, upgrades, cloning, troubleshooting issues

Oracle Applications 10.7 to 11.5.4 upgrade

6.Wellogix

Oracle Applications upgrade, Oracle Database upgrade, troubleshooting issues etc.

7.Digital Lighthouse

Oracle Applications and Database implementation and maintenance.

8.City Of Englewood

Oracle Applications and Database implementation and maintenance.

Oracle Applications and Database upgrade.

9.Burson Marsteller

Day to day database and Oracle Applications maintenance, cloning etc

10.Iron Mountain

Day to day database and Oracle Applications maintenance, cloning etc

11.Calix

Day to Day Oracle Database maintenance.

12.LexisNexis

Oracle Applications and Database implementation and maintenance.

13.Excel4apps

GLwand, Budget wand and Reports wand installation and implementation.

14.Blackwater IT

Oracle Applications and Database support.

Oracle Discoverer Install and Configuration

15.CH2MHILL

Oracle Applications and Database Upgrade

Oracle Applications instances consolidation

Oracle Applications and Database maintenance and Support.

16.GE Capital

Oracle Applications and Database Upgrade to 12.1.3

17.Synchrony Financials

Oracle Applications and Database upgrade to 12.2.3

18.EagleClaw

Oracle Applications and Database maintenance and support.

Oracle Applications and database upgrade to 12.2.3

19.University Of Alabama

Oracle Applications Upgrade to 12.1.3

20.Graebel Companies

Oracle Applications and Database maintenance and support.

21.Markwest

Oracle Applications and Database maintenance and support.

OBIEE Install and Configuration

Quorum Database administration and patching

Flowcal Database administration and upgrades

22.Graebel Moving Services

Oracle Applications and Database maintenance and support.

Oracle Database migration to sqlserver

Education:

Texas Christian University, Fort Worth TX - 1994

Ph.D. - Biochemistry

University of Maiduguri - 1987

B.S. - Biochemistry

Additional training:

Oracle Education – Oracle Database 10g: New Features for Administrators.

Oracle Education – 11i Oracle HRMS Technical Foundation Human Resources

Oracle Education – Oracle Application Server 10g: Administration I

Atlantech Computrain - Oracle8/8i DBA Certification May 2001

Oracle Education - Oracle Financials Payables Release 11

Corteck Systems INC. - Oracle 7.3 and Developer 2000 training

University Of Texas Southwestern Medical Center - Postdoctoral Fellowship

PERSONALITY:

Team Player, work well with people, good listener and learner, high self-motivation, always willing to learn.

AVAILABILITY:

As soon as possible.

REFERENCES:

Available upon request.

CITIZENSHIP:

United States of America.

Contact this candidate