For the last 20 years, Data Warehousing, ETL and Business Intelligence have been my primary focus. I have experience with all the major RDBMS systems; 18 years experience with Oracle, SQL, PL/SQL, SQL Server. Also many years experience with Business Objects, Informatica, DWB, Cognos, Java, UML, C, C++, PowerBuilder, XML.
I am available now and most interested in contracts for remote data modeling with ERwin (or PowerDesigner) , Oracle and SQL Server.
I am currently doing database and application development for the stock market. Using C# (.NET), Interactive Brokers TWS API , Oracle and SQL Server. I am interested in remote C# programming jobs.
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,
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).
Resume (Word DOC) in a zip file
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.
See below for a list of my pubications.
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.
David can be reached through email at firstname.lastname@example.org
This is only a Brief Resume.. email me for a full resume
(if prompted for a password, click cancel)
Return to David's Home Page
Brief Resume and Publication List
I am a Data Modeler, Enterprise Data Warehouse Architect and Programmer with extensive experience working for world-class IT departments. Data Modeling, Data Warehouse Design, ETL Programming and Business Intelligence have been my primary focus.
I have excellent communications skills and work well with end users and management. I also have extensive experience as a technical team leader and as a project manager. High points are:
§ Author of the Oracle Developer’s Guide (Oracle Press), Technical Reviewer for The Oracle DBA Handbook
§ BusinessObjects, Data Integrator (DataServices), Informatica, Oracle DWB, Cognos
§ SQL, PL/SQL, Java, C, C++, C#, Internet/Web Programming; ERwin, PowerDesigner, TOAD
I’m interested only in remote data modeling contracts . This is an outline of my skills and experience working for world-class IT departments for 20 years.
Enterprise Data Modeler and Data Architect
· Data Modeling (Erwin, PowerDesigner, TOAD) - Relational, 3NF, Dimensional, multi-dimensional, BI.
· Design, Team-Lead and Implementation of many very large systems. (Transactional, ODS, Data Warehouse, Dimensional Reporting Systems)
· Consolidations, large terabyte systems, Oracle OLAP, SQL Server
· Database tuning and optimization for large systems.
Business Intelligence – Reporting and Decision Support and BI Administration.
· BusinessObjects (WEBI, Crystal Reports, Xcelcius), Cognos, MicroStrategy, Oracle, SQL Server.
Database specialist - experience with all the major RDBMS.
· Oracle, SQL Server, Teradata¸ EssBase, IBM DB2, many others
· DBA – Completed full Oracle DBA training (Oracle Press author) Certified. Sybase training.
Team Leader – and project manager, Microsoft Project.
· Lead many projects through the complete Software Development Life Cycle (SDLC)
· Microsoft Project and various methodologies. Metrics based on Six-Sigma Quality methodologies.
Senior-Level Programmer – Application, System, Web and ETL programming.
· Application – Java (J2EE), C, C++, C# (and MS .NET)
· Database and ETL – SQL, PL/SQL, T-SQL, Data Integrator (DS), Cognos, Informatica, Oracle DWB, Essbase
· Client/Server and Multi-tier systems, Internet development and Dynamic Web pages, HTML, JSP etc.
Author, Technical Writer – author of seven technical books including The Oracle Developer’s Guide (Oracle Press) and 80 technical articles for the leading magazines (including DBMS Magazine, Oracle Magazine, Databased-Advisor).
I was a Technical Reviewer for the Oracle, including the Oracle DBA Handbook.
"Relational Database Design (Relational Theory)", DBMS Magazine, October 1991
"Relational Database Normalization", DBMS Magazine, November 1991
"Relational Database Operations", DBMS Magazine, December 1991
"Conceptual Database Design", DBMS Magazine, January 1992
"RDB: E/R Modeling", DBMS Magazine, February 1992
"Logical Database Design", DBMS Magazine, March 1992
"Physical Database Design", DBMS Magazine, April 1992
"Relational Programming", FoxUser Journal, April 1992
"SQL Server and Netware" DBMS Magazine, October 1992
"Preparing Your Network for Client/Server" DBMS Magazine, November 1992
Review of Oracle Developer Data Based Advisor, November 1992
Review of Level5 Object Knowledge-based System DBMS Magazine, February 1993
"Inside SQLWindows 4.0” DBMS Magazine, September 1993
“PowerBuilder 3.0: A Tutorial", DBMS Magazine, October 1993
"Object-Oriented Database Development", DBMS Magazine, November 1993
"PowerBuilder 3.0 vs. SQL Windows 4.0", DBMS Magazine, December 1993
"Interoperability and Distributed Systems", Network Computing, January 1994
"Client/Server Development With Uniface", DBMS Magazine, January 1994
"Q+E Database Library (for C++ Client/Server Development)", DBMS Magazine, February 1994
"Client/Server Development With Unify Vision", DBMS Magazine, March 1994
"Implementing Distributed Databases with Oracle V7", DBMS Magazine, April 1994
"SQLWindows 5.0", DBMS Magazine, January 1995
"PowerBuilder 4.0 Gets Upgraded", DBMS Magazine, June 1995
"Multi-tier Development” Edge Magazine, Oct. 1995
“Object-Oriented Analysis for C/S Design”, Data Based Advisor, January 1996
“Oracle7: A Review”, Data Based Advisor, February 1996
“Object-Oriented Design with Object Modeling Technique”, Data Based Advisor, March 1996
“MS SQL Server 6.5” Comments on the new version Data Based Advisor, April 1996
“The Complete Multi-tier Developer”, Data Based Advisor
“Functional Database Access: Oracle API Part I” ORACLE Informant, October 1996
“Functional Database Access: Oracle API Part II”, ORACLE Informat, November 1996
“Data Warehousing: Making Sense of
“Modeling OLAP Systems” Data Based Advisor
“Data Modeling for OLAP: Star-Schema Modeling” Data Based Advisor, March 1997
“Publish Dynamic: CGI the Gateway to Interactive Web Pages” Databased Web Advisor, April 1997
“Build Dynamic Web Pages: Beyond CGI (ISAPI and NSAPI alternatives)” Databased Web Advisor, September 1997
“Using Java to Build Dynamic Web Pages” Databased Web Advisor, November 1997
“Inside The Windows Registry” PowerBuilder Developer's Journal, November 1997
“Displaying the Windows Registry: TreeViews and ListViews” PowerBuilder Developer's Journal, December 1997
“Distributed PowerBuilder6: Building Multi-tier Applications: A Demonstration of All the New Features” PowerBuilder Developer's Journal, January 1998
“Distributed PowerBuilder6: Understanding Shared Objects” PowerBuilder Developer's Journal, February 1998
“Distributed PowerBuilder 6: Managing Connections and DataWindow Synchronization” PowerBuilder Developer's Journal, March 1998
"Web Development: The Future is here: SilverStream the Next Generation” Databased Web Advisor, March 1998
"Inside the SilverStream Application Server" e-Business Advisor, April 1998
“Distributed PowerBuilder 6” PowerBuilder Developer's Journal, April 1998
“Inside PowerBuilder: Internal Details” PowerTimes, 1998
“Distributed PowerBuilder 6” PowerBuilder Developer's Journal, May 1998
"PowerBuilder 6: A Review" e-Business Advisor, May, 1998
“DLLs and PowerBuilder” PowerBuilder Developer's Journal, June 1998
“Editorial: The Future of PowerBuilder” PowerBuilder Developer's Journal, July 1998
“DLLs and PowerBuilder: Part 2” PowerBuilder Developer's Journal, August 1998
“Using the Advanced Windows Controls” PowerBuilder Developer's Journal, September 1998
“Understanding Object References in PowerBuilder” PowerBuilder Developer's Journal, October 1998
“Editorial: A View of the Future” PowerBuilder Developer's Journal, October 1998
“Multi-Processing in PowerBuilder 6: A New Technique Utilizes Local Shared Objects” PowerBuilder Developer's Journal, 1998
“Data and the Web" e-Business Advisor, 1999
“Beyond CGI: DBMS Alternatives to Push Data to the Web" e-Business Advisor, 1999
The Oracle Developer’s Guide Oracle Press, 1995
The Oracle7 DBA Handbook (I was the technical reviewer for this and other books by Oracle Press)
PowerBuilder 6: A Developer’s Guide: Revised Edition, IDG (M&T) Books, January 1998.
Developing Client/Server Applications, Henry Holt Inc., January 1997.
PowerBuilder 5: A Developer’s Guide, M&T Books, 1996.
Teach Yourself PowerBuilder 5: MIS Press, 1996.
Database Developer’s Guide, M&T Books, 1994.
FoxPro 2: A Developer's Guide, M&T Books, 1991.
FoxPro 2: The Complete Reference, Sybex 1992