Manager Oracle

E lizabeth Robiskie Joseph

*** ************ ****

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

Overview

I have TOP SECRET Government Clearance

I am an IT Professional with extensive Information Technology experience in the

specialized field of Oracle Database and BI Application Administration. Relevant skills

i nclude data warehouse architecting, project management, requirements analysis, database

systems testing, system specifications development, mapping and schema development,

software installation and configuration, t raining and staff management.

Summary of Experience

Information Technology 31 years

Management 15 years

Database Administration 25 years

Data Architecture 10 years

Employment H istory

Title: Senior Systems Engineer IV

Company: Geocent

Location: National Finance Center, NASA M ichoud – US Department of Agriculture

Period: 2011 to Present

Key Responsibili ties:

• Architecture and Design of the Corporate Financial Management Systems for the following

applications.

[ Financial Data Warehouse (FDW ), the Automated Cash Reconciliation Worksheet System

(ACRWS), and the Corporate Property Automated Information System (CPAIS) ]

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Upgrade DB2 database to version 9.7 on Financial Data Warehouse QA, and Production

environment.

• Installed, configured and administered Oracle Fusion M iddleware Application

Server 11g.

• Upgraded, configured, implemented Oracle Business In telligence Enterprise Edition

(OBIEE) and Oracle Hyperion Application Server 9.3.3.

• Upgraded and applied patches on Oracle 10g, and 11g databases on IBM AIX, UN IX,

W indows NT and Red Hat L I NUX operation systems.

• Upgraded WebSphere to latest version to resolve vulnerabilit ies.

• Configured Secure Socket Layer (SSL), OpenSSL, OpenLDAP, Oracle Wallet Manager

(OWM).

• Install, configured Apache HTTP Server, WebSphere Server and Oracle WebLogic Server

and Oracle Single Sign On (SSO) and Oracle Access Manager (OAM)

• Create Oracle databases a Development, Unit Testing, System Testing, and Production

environment.

• Applied Fix Packs to DB2 databases Completed instructional documentations for step by

s tep fix pack installation.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Create / modify scripts to automate Oracle Forms and Reports migration.

• Database Administration using TOAD, OEM, and scripts; also, Extracting,

T ransforming, and Loading (ETL) data with SQLLoader and SQLDeveloper.

• Participate in the Assessment and documentation of the As-Is and To-Be; National Finance

Center (NFC) – Information Technology Services Division (ITSD) management

p resentation document.

Title: Senior Database Architect

Company: Applied Enterprise Solutions, Actionet, -- US Department of Transportation

Location: Stennis Space Center, MS and Washington DC

Period: 2006 to 2011

Key Responsibili ties:

• Managed the development for US Department of Transportation (DOT) Mari time

A dministration Marine Transportation System

• Configure and administer the Oracle Business In telligence Enterprise Edition

(OBIEE) and Hyperion Application Server

• Perform data warehouse architecting, administration and patching for DB2, Oracle,

10g, and 11g databases on AIX, NT, UN IX, and Red Hat L I N UX operation systems.

• Configured Secure Socket Layer (SSL), OpenSSL, OpenLDAP, Oracle Wallet

M anager (OWM).

• Install, configured Apache HTTP Server, WebSphere Server and Oracle WebLogic Server

and Oracle Single Sign On (SSO) and Oracle Access Manager (OAM)

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Install, configure and administer the Oracle Business In telligence Enterprise

E dition (OBIEE) application and Hyperion Application Server

•

• Create data warehouses and Data Mar ts in a Development, Unit Testing, System

Testing, and Production environment.

• Database Administration using TOAD, OEM, and scripts.

• Assist local users and remote users.

• Perform Data Mar t mapping, Star schema mapping, and ETL using Oracle

Warehouse Builder (OWB), Informatica, and SQLoader.

• Determine the database architecture and storage planning with System

A dministrators.

• Administrate the Oracle In ternet Directory (OID) (create users and groups; manage

security).

• Performance tuning for scheduled MarView data loads.

• Install, configure, and administer Oracle APEX

Title: Senior Data Warehouse Architect/DBA

Company: Diamond Data Systems, Inc., Lockheed Mar tin -- US Department of Defense

Locations: New Orleans, LA, M illington, TN, and Washington DC

Period: 2003 to 2006

Key Responsibili ties:

• Performed Data Warehouse architecting for Oracle 9i and Oracle 10g databases on

N T and UN IX operation systems.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Created Data Warehouses and Data Mar ts in a Development, Unit Testing, System

Testing, and Production environment.

• Database Administration using TOAD, OEM, and scripts; also, Extracting,

T ransforming, and Loading (ETL) data with Business Objects Data Integrator (DI).

• Maintained communications with other Universal Services sites in the United

S tates.

• Assisted approximately 370 local users and unknown number of remote users.

• Performed Data Mart mapping, Star schema mapping, and ETL using Oracle

Warehouse Builder (OWB).

• Installed and configured Apache, Apache Tomcat 406, and Business Object

A pplication Foundation, Strategy Builder, and Balance Scorecard.

• Administrated the Business Object Supervisor (create users and groups; manage

security).

• Created Datamart Cubes for the use of OLAP reporting through Business Objects.

• Provided in-house Oracle and Business Object t raining.

Title: Senior Oracle DBA

Company: Fleetcor Technologies,

Location: Metair ie, LA

Period: 2000 to 2003

Key Responsibili ties:

• As Senior Data Architect/Data Administrator, facilitated the development and

i mplementation of database architecture and strategies working with the

I nformation Systems and Business teams to support a dynamic Internet services

business.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Data Architect activit ies included development support, which involved t ransforming

logical data models into physical designs and building physical databases, data

s tores, and data warehouses.

• Additional activities included the production support of the data environment

i nvolving development of procedures, monitoring of tuning options, and

recommending and implementing changes.

• Participated in the evaluation of software application to aid in the development,

administration, defining, and enhancing standards for the data environment.

• Created development, testing, t raining, and production databases.

• Created, maintained, tested, and executed the backup and restore process for the

D BMS.

• Executed full database exports and imports and hot backups for tablespaces.

• Documented and reviewed DBMS disaster recovery plan.

• Identified, maintained, and modified DBMS tablespace characteristics. Executed

command to linked raw operating slices and created tablespace and datafiles for

l arge databases.

• Allocated all disk space for production and development of database

i nstances/servers.

• Performed regular monitoring of system logs (for example, alert.log).

• Monitored DBMS performance for CPU and memory utilization.

• Tuned/Recommended changes for global DBMS parameters affecting CPU or

memory utilization.

• Monitored DBMS I/O performance.

• Tuned global DBMS parameters affecting I/O utilization.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Created scripts to create and rebuild tables, indexes, views, t r iggers, constraints,

and other schema objects.

• Created user IDs, roles, granting privileges, profiles, and tablespace quotas in

dedicated instances.

• Managed security, user roles, privileges, and profiles.

• Troubleshot and resolved DBMS system resource contention.

T itle: Senior Systems Analyst

Company: Kaiser Aluminum

Location: Gramercy, LA

Period: 1996 to 2000

Key Responsibili ties:

• Supervised the project efforts of the developers and was responsible for appropriate

development, testing, and production implementation of coding changes. The Oracle

F inancial modules supported include GL, AR, and AP and Oracle RDBMS.

• Managed contract personnel to ensure completion of a large complex project.

• Used Oracle’s ETL product, Oracle Warehouse Builder (OWB), to extract data from

d ifferent source databases (Oracle database, Excel, and so forth) and map it to target

databases such as another Oracle database or data warehouse.

• Developed logical and physical data model, design, development, implementation,

and tuning for Oracle 8i databases.

• Developed database procedures, database dictionary, and other related documents to

establish a CMM level 3 working environment for the OLTP and OLAP databases.

• Performed nightly backups using the EXABYTE backup tool.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Acted as Project Manager for System Development Life Cycle for the conversion of

AS400 data to Oracle databases for Gramercy, African, and two Jamaican plants,

w hich consisted of 50 to 100 gigs.

• Designed and maintained Oracle 7.x and 8.x database instances for both OLTP and

O LAP implementations.

• Developed interface, integration, and reporting tools for several Oracle 7 RDBMS.

• Assisted test team with applications for the computerized maintenance management

system.

Title: M IS Manager

Company: Universal Services

Location: Harahan, LA

Period: 1993 to 1996

Key Responsibili ties:

• Converted the aS400 cabling to Cat5 with Cisco hub, switches and routers,

configured the AS400 for SNA connection.

• Installed Perl controllers to establish WAN connection (128K lines from the Harahan

to Belle Chase office).

• Researched and developed methods of accessing legacy data using new technology.

• Assisted users and performed t roubleshooting of problems.

• Administered IBM AS400 and Windows NT servers.

• Administered workstations including Windows 3.1, Windows95, and WindowsNT.

• Configured Windows NT networking, TCP/IP, DHCP, WINS, L M HOSTS.

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• In tegrated network systems and components.

• Implemented t raining courses and wri t ten procedures for users.

Title: IT Procurement Specialist

Company: Entergy Operations Waterford 3

Location: Taft, LA

Period: 1978 to 1993

Key Responsibili ties:

• Planned projects and purchased computer equipment and software for installation.

• Managed Novell installation, configuration, and user setups on Compaq servers.

• Administered the Nuclear Spare Parts Information System (NSPIS).

• Served as Team Leaders for data conversion and implementation of new Material

M anagement Information System (MM IS).

• Administered the several M M IS (OLTP) production, test, and t raining databases.

• Served as the end-user consultant and end-user t rainer.

Special Skills

Database

• Oracle 7, 8, 8i, 9i, 10g, 11g

• DB2

• Oracle Parallel Server (OPS)

• Real Application Clustering (RAC)

• Microsoft SQL/Server 2005, 2008

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• MS Analysis Server

• Microsoft OLAP Oracle SQL *Net

• Oracle DBA Studio

• Enterprise Manager

• DBAr tisan

• Oracle ETL Oracle Warehouse builder (OWB)

• Business Objects (BO) ETL Data In tegrator

• Application Foundation

• InfoViewe

• WebIntelligence

• Rapid Mar t

• Cognos

• Informatica Quest Tools – Toad, Spotlight, Schema Manager, Space Manager, SqlLab

Xpert, Spot L ight on Oracle Fog Light for Oracle

Application

• Oracle 9ias, 10gias, Fussion M iddleware, Weblogic

• Form60 Server, Report60 Server

• Oracle Financials 11I Analyzer

• Oracle Portal

• Oracle Forms

• Oracle Developer 3I/2000

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• Oracle Designer 2000

• Oracle Discoverer

• Oracle APEX

• Oracle In ternet Directory, Oracle Access Manager

• Oracle Single Sign On

• Oracle Apache HTTP

• Apache Tomcat406

• Peoplesoft HR

• ADP Payroll

• Wonderware Avantis CMMS

• Business Objects Administration

• Designer

• Supervisor

Reporting Tools

• Seagate Crystal Report/Info

• Microsoft Access

• Oracle Reporting

• Business Objects Reporting

• Oracle Discoverer

Operating Systems

• IBM AS400, z/OS

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• UN IX Sun Solaris SPARC OS 5.8, 6.1

• Windows 3.1, 95, NT

• Red Hat L I N UX

• IBM AIX

• MS-DOS

• Novell NetWare

• IBM OS390

Programming

• SQL, PL/SQL

• Visual Basic

• XML

• JAVA

• C/C++

• UN IX Shell Scripts

• SAP ABAP

• SQL *Plus

• SQL * Loader

Methods

• PVCS Version Manager/CM Configuration Management

• E-R Data Modeling

• Business Rules Development

E lizabeth Robiskie Joseph

137 Lapeyrolerie Lane

P.O. Box 175

Edgard, Louisiana 70059

Mobile: 985-***-****

• System Analysis, SDLC

• Project Management

• Oracle Custom Development Methodology

• Applications Implementation, Application

Education

Nicholls State University, Thibodaux, LA

• BS, Business Administration, 1979

Tulane University, New Orleans, LA

• BS, Computer Information System (CIS)

Certifications

Information Technology Infrastructure Library (ITI L)

Oracle Certified Associate (OCA)

Oracle Certified Professional (OCP)

Contact this candidate