this is soon to be updated:
David McClanahan is a Data Architect who specializes in Enterprise Data Architecture, Data Warehouse design, ETL design and coding, Database modeling and programming and the development of Business Intelligence systems. He is also an instructor and one of the most widely published authors in his field.
David has written 7 books (including The Oracle Developer's Guide from
Oracle Press) and over 70 technical (data based) articles and served as columnist for DBMS Magazine,
eBusiness Advisor
and Databased Advisor Magazines, and was the technical reviewer for
The DBA Handbook from Oracle Press.
He has extensive experience as Enterprise Data Architect (served in that position for 5 years for General Electric), many years experience in Data Warehouse Design, ETL design and programming, Business Intelligence, Data Modeling, Oracle (Programming and DBA), Data Analysis. He has been Certified for Oracle, has been a Business Objects instructor. He has designed and lead the implementation of many data systems including the GE Quality Data Warehouse. He is fluent in Java (J2EE, Web), SQL, PL/SQL, C, C++, PowerBuilder and experienced with Data Integrator, Informatica and Business Objects (also Cognos, Erwin, PowerDesigner).
David has been involved with every phase of software development, including feasibility
studies, design, data modeling, coding, and project management for many large
projects. He also has extensive experience in Oracle database administration and
design including Data Warehousing and Operational Datastores . David is also one
of the most widely published experts in the field. Click Here for
a List of Publications
As a database specialist he has worked with all of the major database systems
including Oracle, Sybase, SQL Server, Informix, Ingres, Progress, Ontos, and
Versant. He has also developed with a wide range of front-end tools including
PowerBuilder, SQL Windows, Delphi, Visual Basic etc.. He also has extensive C
and C++ experience in the UNIX and Windows environments and experience with Windows Server administration.
David has had extensive experience architecting and developing
very large, multi-tier systems (typically with thousands of
clients and multiple servers). He has served as principal architect, project
leader, systems analyst and programmer. Most of these systems are Internet based
systems.
Much of his focus is in establishing enterprise methodology and driving
object-oriented design and development. Recent work has focused on developing
Business Intelligence Systems.
Planned is a new book on Data Architecture.
Modern Data Modeling () - is a complete guide to designed industry strength databases for OLTP, ODS, Data Warehousing and Data Marts. It is the only book to cover this range of possible designs. Best-practices, industry modeling standards, database optimization are all covered in detail. Metadata documentation and use is also featured.
*** Managing and Leading Software Development - For IT Managers and Technical Team Leaders. The elements, methods and processes that are necessary to insure the success of Information departments and projects into today's highly complex and result driven environment.
*** Metadata, ELT, and Data Quality - is a guide to data manipulation, covering data extraction, loading (transportation), transformation (cleansing) and data quality. With examples from currently widely-used ETL tools. Metadata development and Data Quality Assurance are featured.
**** Modern Data Modeling - is a complete guide to designed industry strength databases for OLTP, ODS, Data Warehousing and Data Marts. Best-practices, industry modeling standards, database optimization are all covered in detail. Metadata documentation and use is also featured.
David can be reached through email at dba2008@dmcclanahan.com
This is only a Brief Resume.. email me for a full resume
(if prompted for a password, click cancel)
Download David's Resume and Publication List (Word DOC)
Click Here for a List of Publications
Copyright 1997-2008 David McClanahan
email: dba2@dmcclanahan.com
Last modified:
September 03, 2007
Updated: January 17, 2008 12:18:11 AM