Data Warehouse Oracle

Title:C RAJU

******@*******.***

Document

Source below

NAME: capers, clark

ADDRESS: po box 3010

ADDRESS2:

CITY: moss beach

STATE: CA

ZIP: 94038

CANDIDATE ID: 2256273

US CITIZENSHIP: US

Citizen

EDUCATION: Bachelor Degree

EXPERIENCE: 5

WILL RELOCATE: No -

JOB WANTED: Any

RATE NEEDED

: Open

TELEPHONE: 650-***-****

EMAIL: ******@*******.***

HOMEPAGE:

YOE: 5

Clark Capers

Capers Software Consulting, Inc.

Office 650-***-****

*******@******.***

RELEVANT EXPERIENCE EMPLOYMENT

11/1999

-PresentEpylon CorporationChief Database Administrator

Lead a top professional DBA team in a development and production environment for a B2B

marketplace company specializing in government and education sectors. Environment was high-

availability Oracle 8.i utilizing Ariba & ATG Dynamo application servers for Solaris & NT,

WebMethods B2Bi XML, Tibco and Oracle AQ.

RELEVANT EXPERIENCE - CONSULTING ENGAGEMENTS

11/1998

-11/1999 Organic Online /Oracle Database Administrator

Provided customized e-commerce web site development using Oracle 8, ATG Dynamo,

NetDynamics, and Apache web servers on Sun & NT boxes. Created databases & architected

environment for RX.COM, TEXTBOOKS.COM, and DIGITAL-DAYTIMER.COM.

7/1996

-11/1998Hewlett-Packard / Oracle Database Administrator, Data Warehouse Consultant

Created customer and competitive intelligence olap designs in Cognos. Provided Oracle DBA

support for financial data warehouse. Managed resources, and technology in 12 Oracle 7.3

thru 8.0.4 instances on HP 9000. Performed role of Oracle technical advisor and mentor to

employee group. Developed automated processes for updating operational data store & data

warehouse. Provided ERwin and ModelMart physical and logical model support. Installed,

updated, and tuned multiple Oracle instances. Provided COGNOS OLAP design and support.

Created scripts and used OEM to monitor multi-db environment. Provided sql & instance

level performance tuning.

02/1994

- 06/1996Household Credit Services / Oracle Database Administrator & DataWarehouse Consultant

Designed data warehouse models(star design) to support customer subject area for large

credit card company. Implemented 100G data warehouse design utilizing Oracle 7.1.3 on Dec

Alpha, VMS, and SUN servers. Provided on-going Oracle DBA maintenance support for a

marketing sponsored data warehouse. Installed NCSA web server and developed HTML for data

catalog using Oracle. Implemented databasemarketing processes utilizing SAS/Unix.

Architected multi-source data hub & repository used in filter, scrub, and editing of data.

10/1992

- 02/1994 IBM consultant to Household Credit Services / DB2 Database

Administrator

Integrated DB2 data warehouse and Oracle decision support databases. Provided ongoing

support and training for DB2 developers. Managed application developers in development of

warehouse for data mining. Designed and implemented data warehouse utilizing DB2/MVS 2.3.

8/1991

- 10/1992Syntex CorporationDB2 Consultant & IDMS DBA

Designed QMF reporting architecture. Developed QMF queries and converting these to COBOL

II static plans using Platinum conversion product. Support development database changes

8/1990

- 07/1991Apple Computer / Systems Consultant

Developed Macintosh 4-D upload process to DB2 mainframe database. Provided application

DB2 DBA support. Setup remote site network for connectivity to mainframe applications.

Created Mac communication programs for national access to DB2 data.

02/1990

- 07/1990Syntex CorporationDB2 Consultant

Developed QMF sql queries and reports to provide statistical reporting. Developed COBOL

II DB2 programs to provide special form printing utilizing XEROX 8700 technology and HP

Laserjet printing. Provided training and support for an emerging DB2 community.

01/1986

- 01/1990 Apple Computer / Systems Consultant

Provide IDMS DBA support to CAS programming group. Installed IDMS and CAS releases.

Modified and enhanced Cullinet 1.1 Purchasing and GL applications. Developed a project

reporting subsystem in COBOL and CULPRIT. Developed Macintosh-to-Mainframe file transfer

links between MS EXCEL and Client GL. Provided user requirement analysis and technical

design for Cullinet 1.1 Financial and Manufacturing. Installed Cullinet 1.3 financial

software. Modified CAS schemas to meet software enhancements. Provided DBA support for all

Cullinet applications and developers.

TECHNICAL SUMMARY

HARDWARE

HP 9000 - IBM/3090 -DEC Alpha - SUN Sparc - DEC/VAX MS NT/2000 Apple Macintosh

OPERATING SYSTEMS

HPUX 10.2,11.0 IBM MVS Digital Unix - Solaris 2.6, 2.7 - OPEN VMS

SOFTWARE

(MAINFRAME)

DB2 2.3

- IDMS 10.2 Total- VSAM Omeggamon REXX Bachman BMC CA/Platinum

SOFTWARE

(SERVER)

ORACLE 7.1 thru 8.1.7 - DB2 UDB6.1 MySQL SQLServer 7

ATG Dynamo 4.5 - Apache 1.3.9 - PERL 5.004 PL/SQL SQL*PLUS

Korn Shell Platinum Quest BMC - Awk

SOFTWARE (MACINTOSH)

Silverrun 4th Dimension Oracle 7 Filemaker Foxpro DynaComm - Hypercard

SOFTWARE (PC)

Oracle 7.1 thru 8.1.7 ERWin 3.5.2 -S Designor - Pablo DB2 UDB6.1

OS/2.1- WinNT/2000 Micro Focus SAS Visual Basic MS Office 2000

MS Project

EDUCATION

M.B.A

. University of South Carolina, Columbia, S.C.

B.S

. Lander College, Greenwood, S.C.

Contact this candidate