CAROL MCCULLOUGH-DIETER
Oracle Database Administrator / Consultant
http://www.geocities.com/carolmdieter/index.html
[email protected]

Honors/Publications

• Oracle9i Certified Database Associate
• Listed in Who's Who in America, 2000-2006
• Listed in Who's Who in American Women, 2000-2006
• Author of 11 books on Oracle database technology:

  	Oracle9i SQL Unveiled", self published, 2003		"Oracle9i Database Administrator: Implementation and Administration", Published by Course Technologies in 2003. This college textbook covers one of the Oracle Certification exam.
  	"Oracle9i for Dummies", newest edition of the Oracle.. for Dummies series. Published in 2002. The series includes four other editions published between 1996 and 2000: "Oracle8i for Dummies, Second Edition" "Oracle8i for Dummies" "Oracle8 for Dummies" "Oracle7 for Dummies".		"Oracle8i DBA Bible", originally published in 1999, second edition published April 2000.
  	"Oracle8 Developer's Guide", published in 1998.		"Creating Cool Web Databases", published 1996 by IDG Books Worldwide.

• Course designer and author of Oracle8i New Features for Database Administration, a set of web-based tutorials on Oracle8i DBA Certification for DigitalThink.com
• Speaker at Oracle OpenWorld Conference, 1998, 2000.

Education

1982, Bachelor of Business Administration, majoring in Information Systems Analysis Design, University of Wisconsin- Madison.

Experience

1/01- 6/03: Database Consultant and writer, Portland, Oregon

Specializes in Oracle8i and Oracle9i databases including PL/SQL, replication, and object-relational database design . Works with existing staff to trouble-shoot and tune database designs. Writes technical system documentation. Works in all phases of development, design, and implementation of database system projects including cost-analysis, estimating, program specifications, business-wide database design, user meetings, and so on. Helps design and build web-enabled database systems. Software includes Oracle9i,  Oracle8i, SQL, PL/SQL, ERWin, MS Access, Oracle Enterprise Manager, Oracle Replication, HTML, Microsoft Office Suite. Hardware experience includes UNIX, NT, Solaris.

Ongoing: Computer Trainer (previous employers, and freelance)

Developed and taught these courses in hands-on classroom environments:

• Introduction to Database
• Web Design and Marketing
• Introduction to SQL
• Advanced SQL
• Tuning Database Applications
• Beginning and Advanced SQL*Forms
• Introduction to SQL*Report, SQL*Plus, and SQL*Net
• Numerous special user-training classes for custom software applications

10/96-1/01: Database Administrator, ACS Defense Corporation, Pacific Disaster Center, Maui, Hawaii

Managed Oracle database for two sites; designed and installed database applications; designed and programed Web-database integration; designed and maintained business wide data dictionary and data sources inventory including data security. Supervised interns and additional consultants. Wrote specifications and time estimates for project tasks. Participated in testing of all database-related software including COTS packages and custom code. Hardware platforms running Oracle were NT version 4.0 and Sun Solaris version 2.6. Application were developed using Oracle version 7 and 8, Oracle Enterprise Manager, Logicworks Erwin (Database diagrammer), and NetDynamics Studio and Server (Java Application designer and server).

10/97-6/99: Carol McCullough Consulting

Consulted with people venturing into cyberspace on the Internet. Through consulting and education, helped individuals and small businesses make contact with the global community of the World Wide Web.

10/89-10/95: Computer Consultant, Omni Resources, Inc., Madison, WI

Project leader, systems analyst and designer, programmer, trainer. Leader of all phases of project development from initial study through implementation for major development projects. Team leader for staff of 4 programmers. Projects for State of Wisconsin: Tracking system for conservation and environmental improvement grants administered by State Dept. of Nat. Resources. Tracks 32 separate grant programs in consolidated tracking system. Oracle RDBMS on VAX/VMS. Recycling project tracking system for state wide recycling efforts by towns and private businesses; Recycling Markets cross reference directory distributed to businesses and governmental units. Oracle RDBMS on VAX/VMS. Purchase Order tracking system for all government purchases over $500. SQL/DS on IBM mainframe.

10/83-10/86: Database Administrator, Telephone Data Systems/Computer Services, Madison, WI

Responsible for Database Administration of distributed network of Oracle databases across the US. Reviewed database designs for all projects. BETA tester for Oracle Database and Oracle Application software. Developed and conducted in-house trainng for more than 70 programmers on SQL, application tuning, and database design. Supervised team of 9 programmers. Developed and enforced data naming standards, design guidelines, and on-line screen layouts.