Feb. 27, 2011 note: This resumé is being updated... Stay tuned.
Experienced independent consultant specializing in data architecture and data warehousing. Broad experience in decision support system architecture, database administration, Unix system administration, application development and operating systems. A team player and leader with excellent written and verbal communication skills and outstanding interpersonal skills.
Technical Expertise: Data warehousing, modeling, decision support systems, web-based data solutions, Unix system administration, database system architecture and design, internet communications, user interface and ergonomics, multilingual application development, feasibility analysis (prototyping), application and query performance tuning.
Database Management Systems: Oracle, MySQL, Access, Btrieve, FoxPro, dBase.
OS Expertise: Unix (Sun Solaris, HP-UX, Mac/Darwin), Linux (Red Hat, Slackware, Yellow Dog Linux, LinuxPPC), Windows NT Server, Macintosh.
Data Architecture: 10+ years, including all phases of development, from gathering of business requirements to modeling of logical and physical database structure and design of user interface. (See 1, 2, 3, 4, 5, 6, 7, 8, 9, 11 below.)
Oracle Development / Oracle DBA: 8+ years, frequent project lead. (See 2, 3, 4, 7, 9 below.)
Unix Systems Administration: equivalent 5 years, tasks related to database and web site development and administration. (See 1, 2, 3, 4, 5, 7, 10 below.)
Microsoft Access: 9 years. (See 4, 7, 8, 9, 10 below.)
MySQL: 3 years. (See 1, 2, 5 below.)
Total DBMS Experience: 12+ years.
Worked as an independent or subcontracting consultant with various companies from 1993 to present. Significant projects (in reverse chronological order):
1. Apr. 2002 to present, ongoing: Dynamic Web Content Programmer, DBA
2. Sep. 2002 to present, ongoing: Oracle Database Programmer, DBA
Designed data structures and loading strategy for decision support system data warehousing component of automated passenger counting system used on buses in major transit systems throughout North America. Wrote Oracle 9iR2 SQL and ANSI-SQL scripts to load data; tested loading on Oracle 9i, MySQL and MS SQL-Server. [Client: Urban Transportation Associates, Cincinnati, OH.]
3. Sep. 2001 to Apr. 2002: Oracle Data Warehouse Architect, DBA
Gathered business requirements, designed and developed Oracle data warehouse to analyze huge amounts of transit data for decision support services and government reporting. Wrote Java, Perl, HP-Unix shell, and PL/SQL programs to gather data from various Unix, Mainframe and PC systems. Performed all DBA tasks. Worked closely with developers to design OLAP analysis system and web-based reports. [Client: Metropolitan Atlanta Rapid Transit Authority, Atlanta, GA.]
4. Mar. 2000 to Jun. 2001: Oracle Data Warehouse Architect, Developer, DBA
Designed, implemented and maintained very large Oracle 8i data warehouse providing order visibility information for order tracking and decision support. Designed parallel data-gathering techniques using Perl and Korn shell scripts, wrote PL/SQL programs to gather data from DB/2 system via ftp, tuned queries, performed all DBA tasks and supported end-user reporting tool using Microsoft Access. [Client: Lucent Technologies, Atlanta, GA.]
5. Jan. 2000 to present, ongoing: Web Database Architect, Developer, DBA
Designed logical and physical architecture and then implemented web-based decision making process for survey research company. Wrote PHP and Perl code using MySQL in a Linux environment. [Client: MetaLogic Research. Note: Jay Davis is part owner of this company.]
6. Oct. 1999 to Jan. 2000: Web Database Architect, Developer, DBA, System Administrator
Designed and implemented database back-end for an e-commerce web site using Lasso and Filemaker Pro in a Mac OS environment. Note: Site has been modified recently; however, basic programming code appears functional. [Client: Earthshaking Music.]
7. Jan. 1997 to Oct. 1999: Oracle Data Warehouse Architect, Developer Lead, DBA
Wrote business requirements, designed and then directed a team of four programmers to implement an Oracle 7 data warehouse and application front-end for use in management of large telephone network construction projects. Wrote PL/SQL programs, Shell scripts and Microsoft Access (VB 5) code to automate gathering of data from DB/2 via ftp. Performed various DBA tasks.
Analyzed existing Oracle 7 application and front-end, designed and created enhancements and tuned Oracle stored procedures to dramatically improve performance using VB 6.
Designed and implemented system procedures to transfer files across a WAN using NT Servers, Perl 5 and Windows NT command files. [Client: Lucent Technologies, Whippany, NJ.]
8. Aug. 1994 to Dec. 1996: Data Warehouse Architect, Developer and Development Manager
Created data warehouse and directed programming team in creation of front-end for system used to track installation costs for large construction projects. Wrote front-end using Visual Basic 4, Access 2 and Btrieve. [Client: AT&T Outside Plant Systems, Duluth, GA.]
9. Feb. 1994 to Aug. 1994: Oracle Database Architect, Developer, DBA
Created Oracle application used to define corporate business terms and processes using Access 2 and Oracle 7. Performed DBA tasks.
Designed and created database tool to track relationships among various corporate entities using Access 2. [Client: The Coca-Cola Company International, Atlanta, GA.]
10. Jan. 1993 to Feb. 1994: Database Developer
Created portions of multilingual point-of-sale (POS) system using VB, Access and HP Unix.
Maintained existing systems in FoxBase+/UNIX and FoxPro/Windows. [Client: WalMart Vision Centers, Atlanta, GA.]
11. Feb. 1990 to Jan. 1993: Manager of Information Systems [Full-Time Position]
Designed, created and maintained membership tracking and product sales DBMS using FoxBase+/Macintosh. [Employer: Center for Media Literacy, Los Angeles, CA.]
Bachelor of Arts in Communications, with honors. Minor in Physics. Auburn University, 1984.
Master of Divinity, with honors. Emory University, 1988.