Oracle Project

PAUL FU

OBJECTIVES

To obtain a challenging position as a senior Oracle Applications DBA.

PRODUCT KNOWLEDGE AND SKILLS

Databases Oracle database 7.3/8i/9i/10g/11g, Oracle OEM10g Grid, RMAN, Real Application Clusters (RAC), High Availability (HA), Data Guard, MS SQL Server 7.0/2005, CASE tool (Oracle Designer, ErWin, Relational Rose), SQL, PL/SQL, TOAD, MS Access, Crystal Report.

Applications         Oracle ERP 10.7/11i/R12, Oracle 9iAS, 10gAS, Oracle Discoverer 4i/10g, Oracle Portal 10g, Oracle OBIEE, Oracle SOA, Oracle Workflow 2.5/2.6, Lawson ERP, PeopleSoft ERP

Application Servers Oracle Application Servers(Apache, WebLogic), Oracle SOA Suite, Oracle Warehouse Builder, Oracle iStore Server(9iAS), Oracle Portal 10g, EDI Server(GENTRAN), PVCS Server, Chainlink Server, Lawson Server, Advanced Replication Server.

Development Tools              Fusion Technology (BPEL, JDeveloper), Oracle Developer 9i, Forms 4.5/6.i, Reports 2.5/6i, Workflow Builder, SQL, PL/SQL, Informatica PowerCenter, JasperSoft ETL, Visual Basic (Enterprise Version), Visual C++, HTML, XML, Java, JavaScript, COBOL, Pascal, Microsoft Visual Modeler, Rational Rose, Unix/Linux shell scripts.

Storage/Backup  VERITAS, SAN, EMC

Hardware/OS       Sun Solaris, HP_UX, AIX, Linux, VMS, NT4.0, Win95/98/2000/XP/7.0, MAC.

Network              Window NT, Winframe/Citrix, LAN, TCP/IP, Client/Server, ODBC, OID, LDAP

PROFESSIONAL EXPERIENCE

01/2004 05/2010, Enpro Industries, Charlotte, North Carolina

DBA Lead – Project and Production Support

Technical lead for three major projects implementation of Oracle EBS 11i/R12 (upgrade from 10.7 or legacy systems) with platforms of AIX and Linux at different division companies. New models and technologies applied are OBIEE, Informatica, Discoverer, SOA, Portal, iStore, XML Publisher, RAC, Data Guard, RMAN, and OEM 10g Grid. Major Duties for each implementation include: analysis, strategic planning, installation, configurations, development, cloning, patching, performance tuning, backup and recovery, production support, mentoring, and AIM documentation.

10/2008 – 05/2010

Company Data Center, Charlotte, NC

Database/Software: Oracle 9i/10g/11g, 500+GB databases

Platform: AIX 5L, Linux Enterprise 5, VMS

Servers: Oracle EBS, Apache, Forms, Reports, Discoverer, iStore, Portal, OEM Responsibilities:

All divisions Oracle Production/Development Support

Production Support Related Projects -

· ADP Rollup Patch Upgrade & 10g Database Upgrade for 11i ERP

· Company Wide EMC Replication Project Involvement

· OEM 10g Grid Implementation for Production Monitoring

· Application of Oracle 11g upgrade for OEM Grid

o Oracle Enterprise 11g R1 installation and configuration in Linux E5

o Integrated 11g New Features for OEM Grid server

Oracle R12 EBS Financials Implementation in Quin Tech(China)

Responsibilities:

· Oracle EBS R12 (Chinese NLS) installation and configuration in Linux RAC;

· DBA support for Multi-Org, ADI, patching, cloning, go-live, troubleshooting, tuning

Oracle Fusion (SOA) Project for Warehouse Management in Stemco, TX

Responsibilities:

· Oracle Database upgrade from 9.2.0 to 10.2.0

· Oracle SOA Suite installation and configuration

· DBA Support for DPEL development and testing

10/2006 – 09/2008

Quincy Compressor, Quincy, IL

Database/Software: Oracle 9.0.2/10.2.0, 500+GB databases

Platform: Unix AIX 5L, Linux E4

Servers: Oracle AS10g, OID, SSO, Portal, iStore, Discoverer, OEM Grid

Responsibilities:

DBA Lead for Oracle ERP 11.5.10.2 Implementation Project

· 11.5.10.2 ERP (All modules)

· OBIEE 10.1.3 project for high level reports for executives

· Portal 10g Applications for Warranty

· iStore 9iAS for Order Entry from public

· Discoverer 10g for customized Oracle Reports

10/2005 – 09/2006

Fairbanks Morse Engine, Beloit, WI

Database/Software: Oracle 8.1.7/9.02, 350+GB database, RAC, ASM

Platform: Linux E4, CRS, VMS

Servers: Oracle Applications R11i/9i, Apache, Forms, Reports, OEM, Load Balancing

Responsibilities:

DBA Lead for Oracle ERP 11.5.10.2 Implementation Project; And

· Discoverer 4i Embedded within ERP 11.5.10.2

· Linux RAC for production database

· RMAN with SAN/VERITAS

01/2004 – 09/2005

Garlock Sealing, Rochester, NY

Database/Software: Oracle 9.02, 450+GB database, Form 6i, Report 6i

Platform: Unix Sun Solaris 5.8, VMS

Servers: Oracle Applications R11i/9i, Apache, Forms, Reports, OEM, Load Balancing

Responsibilities:

DBA Lead for Oracle ERP 11.5.9 Implementation Project; And

· iStore (DMZ configuration)

· Discoverer 10g (separate server in Linux)

· 10gAS for Web Application project (Direct Connect)

· Data Guard implementation for production database in Atlanta, GA

· RMAN with SAN/VERITAS for backup and Recovery

06/2002 01/2004, CSX, Jacksonville, Florida

Senior Oracle Applications DBA Consultant

Lead DBA consultant for Oracle EBS 11i upgrade implementation; and data warehouse building for Oracle EBS history data. With platform of Sun Solaris, iProcurement, RingMaster, Workflow Builder, Erwin Modeling, and Warehouse Builder are also employed. Duties include providing Oracle environments for project stages (SAND, CRP1, CRP2, UAT, GOLD), participating Financial data warehouse modeling, Warehouse Builder installation, configuration, and ETL processes.

Database/Software: Oracle 8.1.7/9.02, 500+GB database, Form 6i, Report 6i, Designer 2000

Platform: Unix Sun Solaris 5.8, VMS

Servers: Oracle Applications R11i/9i, Apache, Forms, Reports, RingMaster, OEM

Responsibilities:

Lead DBA consultant for Oracle EBS 11i upgrade implementation; and data warehouse building for Oracle EBS history data.

Oracle Financials production, development and testing support

Oracle Application R11i Upgrade (11.5.5/11.5.8/9iAS)

Trouble shooting & customization development for Oracle Applications

(Financials, iProcurement, iExpenses, iSuppliers, iStore, INV, PO, Projects, etc)

Performance tuning and monitoring (Workflow, Advanced Queuing, StatsPack, etc)

Customization development with Forms, Reports, SQL, PL/SQL, shell scripts

Oracle Enterprise Manager (OEM 9i) installation, configuration and implementation

Oracle Discoverer 4i installation, configuration and administration

Oracle Business Intelligence System (BIS) setup

Oracle Applications R11i adcloning and patch application

Oracle Application R11I Load Balancing

Oracle Financial user and responsibility management

DBA procedure documentation and training

Financial data warehouse modeling

Warehouse Builder installation and configuration

ETL development and processes

06/2001 06/2002, Tracfone Wireless, Inc, Miami, Florida

Senior Oracle Financials DBA

Provided leadership, project management and solutions for Oracle 11i upgrade projects. Deliverd engagement services for strategic planning, business process change, database remodeling, technology integration, data quality management, and Oracle EBS assessments and optimization. Project Leader for implementation of Oracle EBS 11i, Advanced Replication, PVCS and EDI integration.

Database/Software: Oracle 8.1.6/8.1.7/9i, 350+GB database, RAC, Form 4.5/6i, Report 2.5/6i, Designer 2000

Platform: Unix HP_UX 11

Servers: Oracle Application R11.0.3/R11i/9iAS, EDI, Advanced Replication Sever Responsibilities:

Implementation and production support for Oracle Application 11i upgrade project

Oracle Financials/EDI production, development and testing support

Oracle Application R11.0.3 installation, configuration, and administration

Oracle Application R11i Upgrade (Apps 11.0.3 to 11.5.3/11.5.5/9iAS; Database 8.1.6 to 8.1.7/9i)

Oracle database 8.0.6 administration for EDI(GENTRAN) server

EDI(GENTRAN) server install, configuration and maintenance

Oracle database 9i creation and administration

Oracle ADI, Discoverer 3i & BIS installation and configuration

Setup for High Availability & Disaster Recovery Solution

Replication server Administration for Oracle and Clarify Applications

Oracle application printer installation and administration

Performance tuning and monitoring

Cloning Oracle database and application servers R11.0 and R11i

Oracle patches application for R11.03 and R11i

Trouble shooting for all Financials and EDI instances

Backup and recovery

Application customization development

Management of data, space, index, tables, triggers, stored procedures

User and security management

DBA procedure documentation

Project management

06/2000 06/2001, Fifth Third Financial Corporation, Grand Rapids, Michigan

Oracle DBA Lead

Oracle ERP Financials

Database/Software: Oracle 8.0.6/8.1.6; 200+GB database, RAC, Oracle Discoverer, Financials, Reports 6.0

Platform: Unix Sun Solaris 2.6, Unix AIX, VMS

Servers: Oracle Application R10.7/R11.0.3/R11i, EDI, Advanced Replication Server

Responsibilities:

Architect of Implementation of Oracle Financials 11.0 and 11i Upgrade project

Oracle server installation, configuration and migration

Oracle database logical and physical design and creation

Data loading with SQL Loader

Oracle Application R10.7 installation, configuration, and administration

Oracle Application R11.5.3 Upgrade (Apps 10.7 to 11.5.3; Database 8.0.6 to 8.1.6)

Oracle Discoverer 3i installation and configuration

Oracle application printer installation and administration

Performance tuning, monitoring, troubleshooting

Cloning and patching

Backup and recovery

Application customization development

Project management

PeopleSoft ERP Application

Database/Software: Oracle 8.1.6, 160GB+ database, Lawson2.2, COBOL, SQL

Platform: Unix Sun Solaris 2.6, VMS

Servers: Production, Testing, Web, Oracle Enterprise Manager2.1, Oracle Recovery Manager

Responsibilities:

Unix system setup and management (parameters, hard drives, backup, restoring)

Lawson Application setup, installation and configuration

Oracle server installation, configuration and migration

Oracle database logical and physical design and creation

Oracle Enterprise Manager installation and administration

Application system administration:

PeopleSoft environment setup and update

PeopleSoft product line copy, dictionary rebuild, and database reorganize

PeopleSoft system trouble shooting and performance tuning

Oracle database administration:

User and security management

Tablespace, rollback segment, patches

Data, index, tables, triggers, stored procedures

Backup and recovery, export and import

Monitoring and performance tuning (BMC SQL BackTrack, StatsPack, TOAD, OEM)

Direct Banking Center

Database/Software: Oracle 7.3.3; 50+GB for Production, Tuxcido, COBOL

Platform: Linux and NT4.0

Servers: Application, Database

Responsibilities:

Patches application

Performance Tuning and monitoring

Redesign and new development

Trouble Shooting

Update and Migration

06/1999 06/2000, Haworth Corporation, Holland, Michigan

Oracle ERP DBA

Oracle ERP Financials, HRMS, CRM and Manufacture

Database/Software: Oracle 7.3.4, 400+GB database, Form 4.5, Report 2.5, Designer 2000

Platform: Unix HP_UX 11, VMS

Servers: Application R10.7/11.0 (Financials, HRMS, Manufacturing, CRM), EDI

Responsibilities:

Oracle Application 10.7 Server installation, configuration and administration

Oracle Web Server 3.0 installation, configuration and administration

Change Management Server (Chainlink) installation, configuration and migration

Oracle application DBA routines:

DBA procedure documentation

User and security

Application customization development

Data conversion

Performance tuning and monitoring

Oracle patches application for 11.0.3 Upgrade

Cloning Oracle database and application

Backup and recovery

07/1996 05/1999, Oakland University, Rochester, Michigan

Instructor of MIS & Computer Center Director

Renovated and managed the school computer lab servers with Win NT and Winframe1.7

Managed the Macintosh computer lab of the school (LAN, Apple Either Net)

Developed Maintenance and Service Database with ErWin2.0, Oracle 7.3, SQL, Forms 4.5(1995)

Developed application software of Instructional System with VB 5.0 and Access(1994)

Built School Records Management System with Access 95 for Michigan School of Troy (1996)

Taught Courses of:

Web Site Design & Development (Front Page, HTML, JavaScript)

Database Development with Access

Management Information System

07/1995 05/1996 Barry University, North Miami Beach, Florida

Assistant Professor – Programming & Multimedia Development

Developed CBT software of Learning Authorware for Barry University with Authorware 4.0 (1993)

Developed multimedia information kiosk of Florida Touring Guide for Barry University with

Multimedia Toolbook II (1993)

Computer Education Instructor, Taught Courses of:

Visual Basic 3.0

Computer Programming in Education (Logo)

CBT Authoring Systems (HyperStudio, Authorware)

07/1994 05/1995 Piedmont College, Demorest, Georgia

Assistant Professor & Distance Learning Center Director

Developed CBT software of Learning Authorware for Barry University with Authorware 4.0 (1993)

Developed multimedia information kiosk of Florida Touring Guide for Barry University with

Multimedia Toolbook II (1993)

Computer Education Instructor, Taught Courses of:

Visual Basic 3.0

Computer Programming in Education (Logo)

CBT Authoring Systems (HyperStudio, Authorware)

09/1989-05/1993 Ohio University, Athens, Ohio

Worked as a computer lab technician for both Mac and PC computers (Apple Either Net, Window NT)

EDUCATION/CERTIFICATION

Oracle Certified Professional (OCP) Database Administrator (DBA 7.3, 9i) 1999

Oracle Master of Application DBA 2000

Oracle and ERP Application Training 1995 – 2010:

(Oracle University, Linux Red Hat, PeopleSoft)

· Oracle 11g New Features for Administrators

· Oracle 10g New Features for Administrators

· Oracle 9i New Features for Administrators

· Oracle 8i New Features for Administrators

· Oracle 10g Real Application Cluster for DBA (RAC)

· Oracle OBIEE Architecture and Administration (on-site)

· Linux Red Hat Enterprise 4 Administration Advanced

· Oracle DBA Administration (I,II)

· Oracle Backup and Recover

· SQL and PL SQL Programming

· Oracle Performance Tuning

· Advanced Oracle Tuning on Unix

· Oracle Web Server Administration

· Oracle Work Flow 2.5

· Oracle DBA for Lawson Application

· PeopleSoft Technical Foundation

· PeopleSoft System Administration

College Computer Course Credits Ohio University, Oakland University 1989 - 1998

· Database Systems (Oracle, SQL)

· Rapid Prototyping Methodologies – Rational Rose (VB 5.0)

· COBOL Programming (I, II)

· Pascal Computer Programming (I, II)

· Web Page Publishing (HTML, JavaScript)

· Systematic Software Design

· Web Programming with Java

· Information System Management

· Multimedia Development

· Network System Administration

M.A, Computer Education Shenyang T. College, Shenyang, P.R.C 1985

B.S, Computer Application Shenyang T. College, Shenyang, P.R.C 1982

VISA STATUS U.S. Citizen

REFERENCES Available upon request

TRAVELING Up to 100%

RELOCATION YES

Contact this candidate