Project Management Services
eBusiness Services E-Business enterprise architecture solutions Business process mapping Project Management Services
Donald McAbney

Expertise

  • Oracle instructor (courseware developer, author, instructor)
  • Oracle developer: Forms and Reports
  • Oracle Designer Generation: Analysis and design of databases and application modules using Designer, from ERD and function models to database design and module definition, generating tables, API, and Forms/Reports/Web modules
  • Customization of Designer-generated modules, using Oracle Developer tools
  • PL/SQL Packages, Triggers, Oracle 8i Object & Ref Tables, DB Links
  • Strong familiarity with DBA tasks
  • Data analysis and reporting using dynamic SQL, PL/SQL, Views Ad-hoc reporting with SQL/PLUS, Discoverer, and Oracle Reports

Technical Summary

  • Oracle Developer: Forms 6i, 6.0, 5.x, 4.x, Reports 6i, 6.0, v3.x, v2.x, Procedure Builder, Project Builder
  • Oracle Discoverer
  • Oracle Designer 6i, 6.0, 2.x, earlier versions
  • Oracle Webserver /OAS/IAS, PowerObjects
  • Utilities: Import/Export/SQLLoader
  • OS: Windows NT/98/2000

Professional Summary

Donald McAbney worked for four years at Oracle Corporation as a staff instructor and later as a technical consultant for Oracle’s Development tools (Designer2000, Developer2000, Discoverer and Data Warehousing solutions). Becoming an independent consultant, he has specialized in the development of highly efficient, integrated Oracle Forms and Reports applications, including Web deployment; analysis, design and generation using Oracle Designer; and Oracle Forms/Reports conversion projects and data migration. As an instructor, he has created and delivered courses on Oracle Developer, Designer, SQL and PL/SQL, and advanced SQL to a broad range of corporate clients.

Recent State of California Consulting Engagements

  • Science Applied International Corporation (SAIC) (May 2001 to present)
    For a redesign of SAIC’s contract management system for the Naval Weapons Defense Center, analyzed, designed and implemented SAIC contract and client management system using Oracle Designer. Designed module definitions for Forms and Web generation. Customized generated applications using Form Builder and Report Builder, adding specific PL/SQL triggers and standards not generated by Designer.

  • California Department of Justice
    Responsible for analyzing, designing, and creating synchronized views on Oracle of legacy data from NCIC (national criminal database), using SQL/LOADER, packaged procedures, and NT Scheduler to launch batch procedures. Generated Forms and Reports for viewing same, using Oracle Designer and Developer. Assisted in the creation and modification of all database tables and procedures related to the criminal record imaging system, reconstructed schemas using Oracle Designer, and generated Forms for viewing/modifying same.

RENEE TAYLOR CONSULTING, INC.
 TEL. 1 (530) 692 2000
FAX. 1 (530) 692 2011
expert@rt-consulting.com
http://www.rt-consulting.com/



Copyright ©2001 Renée Taylor Consulting. All rights reserved.
Web Site Design: Volo Studios, Inc.