JAMES L. SMITH

7421 Vista Pointe Trail

Stone Mountain, Georgia 30087

Pager/Voicemail (678) 481-4982

E-mail - gncsales@globolnet.com

www.globolnet.com/resumedba.html

 

CAREER Position as a Techical Lead in Data Warehousing environment with an

OBJECTIVE: opportunity to utilize my technical expertise. (Subcontract/1099 Opportunities Only)

 

COMPUTER Systems: Intel-Based (NT Server 4.0, MS-DOS & Windows 95)

EXPERIENCE: Compaq Syspro (SCO UNIX W/MPX & Netware 4.1)

Hewett Packet (HP/UX)

IBM SP (IBM AIX/UNIX 4.2.1)

IBM RISC 6000 (IBM AIX/UNIX 3.2.0)

Ultra Sparc (SUN Solaris 2.51)

NCR/Unix (AT&T Unix system V5.4)

Databases: Oracle v8.x & v7.x , Sybase v10, Informix, SQL Server v6.5.

DW-Tools: Erwin 3.51, Business Objects 4.12, Model Mart 3.0, & Informatica.

Languages: JavaScript, Java, PL/SQL, SQL, Shell Script, HTML, ProC, CGI, C.

 

EMPLOYMENT: Technical Lead/DBA Data Warehouse, Wilco Information Management, Roadway

Express, Akron, Ohio. Provide technical guidance for technical and management

staff on implementing a Data Warehouse and related infrastructure. Designed the

Shipment Data Warehouse using Erwin/Model Mart modeling tool. Informatica used

for data transformation and Business Objects used as the initial front-end query tool.

Oracle Parallel Server v8.x and v7.x environments running AIX 4.21 for the

database and operating system and IBM SP eight-way nodes for the platform.

October 1997 - Present

 

Oracle Data Warehouse DBA, Innovative Computer Solutions, Oracle Corporation,

Redwood Shores, California. Technical consulting and advise on implementing a

Financial Data Warehouse. Oracle 7.3 used for the Database and Solaris 2.51

for the operating system. Assisted with the Data Modelers on issues concerning

moving the logical model to the implemented database.

August 1997 - September 1997

 

Oracle Data Warehouse Lead/DBA, Innovative Computer Solutions, Delta

Airlines, Atlanta, Georgia. Designed and implemented a Data Repository

(Warehouse) of Network Traffic/Statistical via SMP(Simple Management Protocol),

Software/Hardware inventory via Tivoli, and WAN/LAN Traffic/Statistical via Contour

and Visual Networks. NetScape Enterprise Server/LiveWire 3.0 provides interface

for the Data Repository/Warehouse accessibility from internet/intranet browser.

Configuration of Parallel Server implemented on SUN Solaris clustering option using

three Ultra Servers, one with a dual processor. January 1997 - August 1997

 

Oracle Data Warehouse Lead/DBA, Innovative Computer Solutions, ViewCall

America - NetChannel, Norcross, Georgia. Created a Data Warehouse of Internet

Providers data for the customers access tracking. Designed and implemented

Oracle 7.3 Database from installation to production. Reporting using Crystal Reports

5.0 and Oracle stored procedures and triggers. August 1996 - Present

 

Oracle DBA/ SQLWindows Design/Developer, Innovative Computer Solutions,

Hill Phoenix, Conyers, Georgia. Database Design/Architect/Implement for the

Refrigeration Circuitry Design and Administration system. Database created using

S-Designer 5.0. Software developed via SQLWindows 5.01.

March 1996 - August 1996

 

Oracle/Unix Architect/Administrator, SysGen, AT&T, Atlanta,Georgia.

POS system using Oracle and Visual C++ replacing DOS and proprietary database

system. Consulted technical management and staff on database design and

development procedures. August 1995 - January 1996

 

Document Management/Oracle/Unix Architect/Administrator, CTG, TransQuest

Solutions/Delta Airlines, Atlanta, Georgia. Architect/Implement the Document

Management technology for Delta Airlines. Consulted technical management and

staff on platform sizing, development environment, development procedures. Tools

used for Delta’s first DMS were Solaris 2.3, Oracle 7.1, Documentum 2.12, C, and

Visual Basic 3.0. Migrated server environment from Solaris to NT Server 3.51.

March 1995 - November 1995

 

Oracle/Unix Database Administrator, Romac, Kinetic International,

Atlanta, Georgia. Installation and administration of SCO Unix and Oracle 7.0.

Database design and implementation via a case tool. Client/Server environment

configuration from servers to clients. October 1994 - March 1995

Client/Server Architect/Database Administration, Romac, Equifax, Atlanta,

Georgia. Advised technical management with Client/Server and Network

architect. Re-engineering of the Credit Marketing System (CMS) from Main-

frame to Client/Server via Oracle 7.0 on HP/UX using a Microsoft Windows

front-end. Database design and implementation via SQL*Forms.

July 1994 - January 1995

 

Client/Server Architect/Lead, Comsys Technical Services,

Systematics Telecommunication Services, Atlanta, Georgia.

Design/Develop/Implement Virtuoso II. Develop architect components

to be used by the development team. Architect components developed in

UNIX/C/Sybase/JAM/Windows Case Tool. Also used as a technical interface

to management concerning the project architecture. October 1993 - June 1994

 

 

Software Developer, HNS Software, Atlanta, Georgia. Implementing, at

Bell South Mobility, enhancements for the Order Activation System (OASYS).

OASYS used to activate Cellular phone for Bell South in the southeast.

Client/Server system using Sun/OS Unix, C/JAM, and RPC via NetISAM.

July 1993 - October 1993

 

Contract Programmer, New Boston Systems, Inc., Woburn, Massachusetts.

Duties included, at Digital Communication Associates (DCA), developing

a character and MS-Windows-based versions of a diagnostic network

monitoring software tool. Written in MS Quick ‘C’ for Windows, MS Macro

Assembler, and Borland C++ for network protocols Novell’s IPX, TCP/IP, and

NetBIOS. Compatibility testing on Windows NT. November 1992 - June 1993

Contract Programmer, Structured Logic Systems, New York, New York.

Advise Delta Airlines Technical Management and Computer Analyst about

methods and issues of developing Client/Server applications written in C

language. System Administration on IBM RS 6000 and Oracle RDMS.

Installation and data design of the Oracle database. April 1992 - May 1993

 

Information Systems Analyst II, Southern Company Services, Atlanta,

Georgia. Set strategic direction in the Client/Server environment for the

corporation. Implementing Windows front-end using TCP/IP, IPX, and

NetBIOS network protocols connecting an Oracle, SQLServer, Sybase, or

DB2 back-end on SCO UNIX, Netware, AIX/UNIX and OS/2. Installation and

data design for Oracle, SQLServer, and Sybase. February 1990 - April 1992

 

Communication Programmer, NCR, Columbia, South Carolina. Developing

IBM Token-Ring (LAN) software in "C" language for various Unix based

computers. Development included: NetBIOS Library, Makefiles, Shell scripts,

Login Server, and other Network Utilities Applications.

August 1988 - February 1990

 

IBM, Charlotte, North Carolina.

Maintenance Programmer. Corrected and generated reports on the Mainframe

system using PL/1 and SAS in a JCL environment. May -August 1987

Programmer Engineer. Set-up a LAN to test the compatibility of LANs and

PS/2s. Microcode test case writing for a new product. August 1986 - January 1987

 

TRAINING: Oracle Parallel Server - Oracle Education 1/98

Erwin/Model Mart - Logic Works 12/97

IOUG Member - Seminar Training 5/98

 

EDUCATION: Bachelor Degree - Computer Science

Minor - Business Administration

University of North Carolina

 

REFERENCES: Available upon request.