Experienced independent consultant specializing in data integration for multiple purposes including data-driven web sites, data warehousing and decision support systems. Broad experience in data architecture, programming, database administration, 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, web application development, ETL, decision support systems, web site design, 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, Linux, Windows NT Server 4.0, 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 2, 3, 4, 5, 6, 7, 8, 9, 10, 12 below.)
Oracle Development / Oracle DBA: 8+ years, frequent project lead. (See 1, 3, 4, 5, 8, 10 below.)
MySQL Development: 3 years. (See 2, 3, 6 below.)
Microsoft Access Development: 9 years. (See 5, 8, 9, 10, 11 below.)
Unix Systems Administration: equivalent 5 years, tasks related to database and web site development and administration. (See 2, 3, 4, 5, 6, 8, 11 below.)
Perl: 6 years. (See 2, 3, 4, 5, 6, 8 below.)
PHP: 3 years. (See 2, 6 below.)
Visual Basic: 6 years. (See 8, 9, 10, 11 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. 2003 to Aug. 2003: Web Application Developer
Wrote Web Application to manage the degree program assessment process at Georgia Tech using Cold Fusion and Oracle 9i. Wrote dynamic web page code and associated Oracle PL/SQL scripts and queries. [Client: Georgia Institute of Technology, Atlanta, GA.]
2. Apr. 2002 to present, ongoing: Dynamic Web Content Programmer, DBA
3. Sep. 2002 to Aug. 2003, support & maintenance 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. Wrote cross-platform loading scripts using Perl DBI. [Client: Urban Transportation Associates, Cincinnati, OH.]
4. 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.]
5. 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.]
6. 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.]
7. 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.]
8. 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.]
9. 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.]
10. 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.]
11. 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.]
12. 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.