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, RoadwayExpress, 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, DeltaAirlines, 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, ViewCallAmerica - 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, TransQuestSolutions/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.