Summary: Atlanta PHP Developer specializing in PHP, Perl and web-based solutions using MySQL, Linux and open-source flavors of Unix. Broad experience in database administration (Oracle DBA), Linux/Unix server administration, application development and operating systems. A team player and leader with excellent written and verbal communication skills and outstanding interpersonal skills.
Technical Expertise: Web applications, database system architecture and design, data warehousing, Unix system administration, internet communications, user interface and ergonomics, multilingual application development, feasibility analysis and prototyping, application and query performance tuning.
Languages: PHP, Perl (DBI), Korn/Bash Shell Scripting, SQL, HTML, Java (JDBC), JavaScript, XML, Oracle PL/SQL, Visual Basic, Lasso.
Database Management Systems: Oracle, Access, Btrieve, FoxPro, dBase.
OS Expertise: Unix (Sun Solaris, HP-UX, Mac/Darwin), Linux, Windows NT Server, Windows 2000, Macintosh.
PHP: 4 years. (See 2, 6 below.)
Perl: 6 years. (See 1, 2, 4, 5, 6, 8 below.)
MySQL: 4 years. (See 2, 3, 6 below.)
Data Architecture: 11+ years, including all phases of design process from gathering of business requirements to user interface design and logical and physical database design. (See 1, 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.)
Microsoft Access: 10 years. (See 1, 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. Oct. 2003 to Feb. 2004: Oracle Data Warehouse Architect, Developer, DBA [Atlanta, GA]
Reviewed, analyzed and updated very large Oracle data warehouse system providing order visibility information for order tracking and metrics (see 5 below). Updated data elements to synchronize with SAP conversion, including PL/SQL procedures, Korn Shell and Perl load scripts. Updated load procedures, perfomed all DBA tasks and updated Microsoft Access end-user reporting tool. [Client: Lucent Technologies]
2. Apr. 2002 to present, ongoing: PHP Developer [Atlanta, GA]
Designed MySQL data structures and wrote code for dynamic web site for custom hand-painted furniture company. Wrote PHP, Perl and JavaScript code to drive content then wrote Perl and Unix shell scripts to automate loading of order data from Windows 2000 Server accounting system so that clients can check current order status online. Currently continuing maintenance and improvement of system. [Client: Patina, Inc.]
3. Sep. 2002 to present, ongoing: Oracle Database Programmer, DBA
Designed data structures and loading strategy for 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 7. Currently continuing maintenance and rollout of system to major transit system in North America. [Client: Urban Transportation Associates, Cincinnati, OH.]
4. Sep. 2001 to Apr. 2002: Oracle Data Warehouse Architect, DBA [Atlanta, GA]
Gathered business requirements, designed and developed Oracle data warehouse to analyze huge amounts of transit data for metrics 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]
5. Mar. 2000 to Jun. 2001: Oracle Data Warehouse Architect, Developer, DBA [Atlanta, GA]
Designed, implemented and maintained very large Oracle 8i data warehouse providing order visibility information for order tracking and metrics. Designed parallel data-gathering techniques, wrote PL/SQL programs to gather data from DB/2 system, tuned queries, wrote Perl and Korn Shell scripts (Solaris), performed all DBA tasks and supported end-user reporting tool using Microsoft Access. [Client: Lucent Technologies]
6. Jan. 2000 to present, ongoing: PHP Developer [Atlanta, GA]
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 [Atlanta, GA]
Designed and implemented database back-end for an e-commerce web site using Lasso and Filemaker Pro in a Mac OS environment. Note: Site concept and basic programming code still appears to be similar to original design from 1999/2000. [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, Korn Shell scripts (Solaris) and Visual Basic 5 code to automate gathering of data from DB/2. 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 [Atlanta, GA]
Created data warehouse, directed team in creation of system used to track installation costs for large construction projects using VB 4, Access 2 and Btrieve. [Client: AT&T Outside Plant Systems]
10. Feb. 1994 to Aug. 1994: Oracle Database Architect, Developer, DBA [Atlanta, GA]
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]
11. Jan. 1993 to Feb. 1994: Database Developer [Atlanta, GA]
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]
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.