DAVID CLEMENT
Home 206-933-0625 - Cell 425-466-7412
E-mail dclement@davidclement.org - Web site www.davidclement.org

Objectives

Continuing achievement in database development, architecture, and administration
The challenge of learning new technology
The chance to build new systems that will drive a business enterprise forward

Outstanding Technical Skills

Recent Employment History

SUM Global Technology, Inc., Atlanta, GA

Senior Software Engineer Jan 2006-Present For client Cellnet+Hunt: Senior developer and DBA on the port of the Command Center application from SQL Server to Oracle, scaling up by an order of magnitude. Implemented solutions for case-insensitive string comparisons, function-based indexing, replacement of global temporary tables with associative arrays. Documented Oracle development standards and methods for a team trained in SQL Server. Acted as DBA for the development team. For client ACLARA: Database optimization engineer and data modeler on TWACS TNG, with Oracle version 10g, in an HP-UX 11.23/Windows XP environment supporting a Weblogic-hosted Java application developed in-house. Used ClearCase, ClearQuest, XML, TOAD 8.6, JDeveloper 10.3 in development environment. Used Oracle 10gR1-10gR2 AWR and ADDM reports, OEM 10g with grid control, event 10046 and 10053 trace files, TOAD 8.6, Dan Tow's SQL diagramming and costing, Cary Millsap's "Method R" to describe and improve database and application performance. Recommended, designed, implemented scalable solutions for continued increase in performance, such as table partitioning for large tables, bulk DML with error logging for frequently executed processes, PL/SQL stored procedures incorporating advanced language features. Designed and created performance-supporting indexes for TNG versions 1.0, 1.5, 1.6, as user requirements increased from 35K to 5M end devices. Mentored Java and SQL developers in best SQL and PL/SQL practices with standards documents, demos, and presentations. Added and revised data models for new features such as Load Control, SuperRouter, AOP; reviewed existing data model for quality and proposed revisions for performance, query simplification, correct normalization. Supported other DBAs in production-system defect resolution for Fortune 500 clients.

QPASS Inc., Seattle, Washington

Senior Database Engineer Aug 2004-Dec 2005 Server-side developer, ETL developer, optimization engineer on the team building the data warehouse to support sales, productivity, and profitability analysis for major customers, using Informatica PowerCenter 7.1.2, Oracle 9i and 10g, Perl 5.8.0, XML, RUP development methodology, in a Linux RHEL 3.0, HP-UX 11.11, Windows XP environment. Built new Perl program to extract reports, improving processing time from many hours, with a high rate of failures and restarts, to a reliable 20 minutes. Designed and developed ETL for data warehouse, using Informatica PowerCenter 7.1.2, UML, QDesigner 11, Rational Rose 8.2, Oracle tools, Korn shell scripting. Main focus on overall ETL design, customer management system, and revenue distribution system. Maintained all source and target definitions for team in Informatica repository. Developed 75 Informatica mappings and workflows, numerous views, queries, packages, procedures, scripts.

SUM Global Technology, Inc., Atlanta, GA

Self-Employed Consultant Jan 2004-Aug 2004 Database optimization engineer on the TWACS TNS team, with Oracle versions from 7.3.4 to 9i under Windows NT/2000/XP, Linux, HP-UX. Increased throughput of application from 58K to 1.3M hourly meter reads for a major client. Used M/M/m queue modeling and Cary Millsap's Method R for predictable results. First recommendation provided a 25% increase in throughput on metering response. Used STATSPACK, autotrace, 'explain plan', level 10046 trace files, other Oracle utilities to improve database and application performance and correct installation and administration defects for several major clients. Analyzed performance issues in Oracle Pro*C/C++ message-queue handlers; in 3 weeks, documented 65 significant code improvements. Reverse-engineered server, RDBMS, and software architecture from C, C++, SQL, PL/SQL source code files, Oracle data dictionary fixed views, and related sources as part of the TNS Process Refinement project. Developed Oracle database triggers, stored procedures, packages, SQL*Plus scripts, SQL*Loader control files, Access forms and reports for code instrumentation, database validation and restructuring, application logic, dataset population.

Webterrier

Self-Employed Consultant Sep 2002-Dec 2003 Provider of technical advice, computer and office services to small businesses in the Seattle area.

ALSTOM, Bellevue, Washington

Principal Software Engineer Oct 2001-Sep 2002 Database architect on the team developing the multimillion-dollar software for energy market management for a state government.

HIH Insurance, San Francisco, California

Database Architect Dec 1996-Jan 2001 Technical leader, in charge of database design. Supervised data migrations from third party to data warehouse, saving $500K a year.  Architect, business logic programmer, and interface programmer of an e-commerce Web site that pioneered a market segment and produced more than 400 policies in the first month.

Progressively responsible positions in information technology at companies including Lawrence Livermore National Laboratories, Pacific Telesis, Arthur Andersen  — 1996 and before

Recent Publications

Summer 2008 Northwest Oracle Users' Group Journal (forthcoming) CBO Cost Estimation
March 2008 Northwest Oracle Users' Group Journal Introductory SQL Diagramming
26 March 2008 An Introduction to the Data Dictionary Model for Storage Management
4 March 2008 Tricks with Analytic Functions
8 January 2008 The Old Switcheroo
6 November 2007 Static SQL with Dynamic Parameters
and other articles at www.davidclement.org under Oracle Tips & Tricks, Oracle Scripts, Other Source Code

Professional Affiliations

NWOUG (Northwest Oracle Users Group); PSOUG (Puget Sound Oracle Users Group)

2008 Training

September 2008, Jay Nance, "JBoss Hibernate Essentials"

February 2008, Cary Millsap with Karen Morton, "Oracle Performance Management Using Response Time Profiling"

Education

Columbia University , New York City, M.Phil., linguistics and comparative literature
Columbia University , M.A., linguistics and English
St. John’s College , Annapolis, Maryland, B.A., mathematics and philosophy