Expertise Summary

10 years of experience in business requirements analysis, business process reengineering and improvement, software engineering, data and process modeling and development of system architectures. Extensive project management and team mentoring responsibilities. Acclaimed instructor for Oracle University and RTC clients. Excellent analytical and problem solving ability. Proven ability to meet deadlines, deliver high quality results, work with people, and handle stress.

Technical Summary

• Business process reengineering and improvement ; process mapping, modeling ; activity diagramming using Visio, Oracle Designer, using UML, Oracle Custom Development Method, and CASE*Method
• Relational modeling, analysis, design and programming.
• Object-oriented modeling (UML), analysis, design (OOA/OOD ), Rational Unified Process (RUP)
• Database architecture and design in both client/server & web environments
• Industry Experience: Manufacturing, Government, Education, Finance, Procurement, Commercial, Scientific, Ecological
• Platforms: Windows NT/2000/XP, UNIX, LINUX, Mac, IBM AT, ES200, DOS
• Programming Languages: Java, PL/SQL, SQL, SQL*Plus, XML, HTML, C, PASCAL, BASIC, FORTRAN
• Databases: Oracle RDBMS 9i/8i/8/7, MS Access
• Development Tools: Oracle Designer v9i, v6.0, v6i, v2.1.2 (formerly ?Designer/2000?), Oracle Developer v4.0, 5.0, 6.0, 6i and 9i (Forms, Reports, Graphics, formerly ?Developer/2000?), , Oracle Portal, Oracle JDeveloper, SQL Navigator, Toad, Matlab.
• Middle Tier Software: Oracle 9i Internet Directory, Oracle 9i Application Server
• Other Software: Visio, MS Suite: Project, Excel, Powerpoint, Word, Internet Explorer

  Expertise Summary

• Oracle Designer v9i, v6i, v6.0, Designer/2000 v2.1.2
• Oracle Forms v9i, v6i, v6.0 (and previous Developer/2000)
• Oracle9i JDeveloper
• Systems Modeling using Visio, Oracle Designer and Oracle Custom Development and RUP Deliverables
• Requirements/Analysis Methods (Data, Function and Activity/Process Modeling)
• Data Analysis and Relational Database Design
• Software Programming and Application Testing using PL/SQL, Java, XML, HTML
• Software Instruction and Mentoring (Developers and End Users)

  Experience

  Principal Technologist, Renee Taylor Consulting Inc., California 2000 - Present

  • California Water Resource Control Board (2001 to Present)
    Principal Consultant, December 2002-April 2003.

    Perform business requirements analysis, process modeling and systems evaluation and improvement, and writing results and recommendations for a Feasibility Study Report, as part of an enterprise-wide Business Process Improvement project for the California Dept. of Consumer Affairs involving reengineering of 42 Boards and Bureaus.

  • SAIC Contract Management Information System (CMIS) for Naval Weapons Defense Center
    Project Lead, March 2001-November 2002.
    Served as RTC team leader for this major MIS project to provide the Ridgecrest, CA Naval Center with HR/financial management information.
    This system involved over 300 screens, programs and reports and over 150 financial/HR database tables and views, developed using Oracle 8i, Designer, Developer and PL/SQL for web users. RTC custom-developed this system, releasing it successfully in 18 months, exceeding expectations.
    Responsibilities included team leadership, mentoring of SAIC staff, and planning and execution of software requirements and component design and build tasks:
    • Process reengineering and new process modeling
    • Data modeling for integrated data requirements
    • Enterprise data integration and conversion as part of the tasks of new database design
    • Application design, coding and testing
    • Managing user feedback sessions during analysis, design and testing phases.

    Key development processes included:

    • Interviewing users, developing requirements models; verifying system requirements
    • Developing and performing quality assurance on requirements models (entity-relationship models, process models, function hierarchies) and related documentation
    • Developing relational database designs, module designs
    • Generating DDL, forms and reports and PL/SQL packages
    • Testing and systems implementation.

  • Process analyst and systems consultant, State Water Resource Control Board (2001, RTC), including:
    • Systems modeling and requirements analysis using Oracle Designer (data, process models)
    • Application development using Oracle Forms for financial tracking and invoicing modules
    • Created database and application design specifications for software projects
    • Designed and developed databases and applications in an Oracle environment
    • Generated and tested system tables and module designs.

    
    

  • Oracle University Instructor, Jan.2000-May 2001, Oracle Corp. (RTC contract); nationwide
    Teach Oracle's own product classes for Oracle University clients (2000-2001), including:
    • Oracle Designer v6.0, 6i
    • Introduction to Oracle (SQL and PL/SQL)
    • Oracle Forms Builder (part of Oracle Developer suite)

  • Develop course materials and train clients in the following concepts and techniques (1998-present):
    • Oracle9i New Features for Developers
    • Oracle Internet Directory
    • Process Modeling and Process Reengineering (using Visio)
    • Oracle Designer 6i New Features and Custom Workshop courses
    • Oracle DBA and data administration/enterprise data modeling courses

  Senior Consultant, Integral Computer Company, St. Petersburg, Russia. 1993 - 1998

  • Conducted courses for clients of COTS software created for ecological monitoring of pollutants
  • Researched, analyzed requirements, and developed advanced database software displaying technological pollutants for different cities, and developed technical documentation for users. The software developed included GIS integrated within an Oracle database, including maps and diagrams, and mathematical models for data analysis
  • Designed and programmed an application package for researching databases of primary pollutant causes
  • Conducted technical seminars for clients

  Education

• Numerous classes at Oracle Corporation and RTC in Oracle software and requirements modeling, including Oracle9i Internet Directory, Oracle Jdeveloper, Oracle Designer advanced classes.
• M.S., Computer Science, Marine Technical University, St. Petersburg, Russia. Highest honors.
• B.S., Electro-mechanics, Marine Technical University, St. Petersburg, Russia.

  Awards

• Recognized for outstanding instruction at Oracle University with ?A? rating.
• Voted top instructor at Integral Computer Company, St. Petersburg, Russia.

  Presentations

• Presentation of COTS functionality for monitoring air quality in a large city, St. Petersburg International Ecology Conference 1997.
• Presentations of database design solutions for monitoring air quality in a large city, Moscow All Russian Ecology Conference 1997.

  Publications

• Author of ? Using COTS package ?ECOLOG?, Integral Ltd, St. Petersburg, April 1997.
• Co-author of ?INTEGRAL ECOLOG: Design of databases of primary pollutant causes in a large city?, CRI ?Atmosphera?, Integral, St Petersburg, October 1996.

  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.