Current loctn: about > employment > math stat data admin

Mathematical Statistician / Data Administrator

1989 to 2001

Responsible for guiding the use of computer technology in support of long-term monitoring of forest resources on U.S. west coast.

Leader of system retooling project

Project applied modified Oracle CASE*Method/CADM system development methods

• organized staff for system design efforts
• facilitated system/data modeling meetings
• established standard application development and documentation systems based on synthesis of Oracle CASE*Method and ISO-9001 quality assurance guidelines
• established code formatting standards for applications developed by team
• designed metadata system for staff Oracle databases and data processing system
• developed data models for staff databases

Oracle database administration

(database consisting of 10 data stores with 15-30 tables and 200-600 columns each)

• cleaned up and moved badly mismanaged Oracle database
• moved database from DG Oracle V6 to AIX Oracle V7
• assisted system administration staff with hardware acquisitions, system updates, planning for and installation of corporate applications, etc. related to operation of Oracle database
• developed library of SQL, PL/SQL and Korn shell scripts to automate database and file management tasks
• implemented indexing required for performance requirements
• tuned database for optimal reliability and performance (table and tablespace defragmentation)
• developed physical mapping of database to hardware
• implementation of security guidelines

Programming

• wrote applications using SAS, PL/SQL, Perl
• developed library of SAS macros to standardize routine tasks performed by staff analysts
• wrote EMACS extensions and modes using LISP

Staff information management

• established filing structure and security guidelines for staff files
• moved staff from terminal/server to PC/server computing model
• organized staff file cleanup and migration from Data General to IBM AIX server
• moved staff from terminal/server to PC/server computing model
• established regular backup of PC hard disks using Windows NT server on local area network
• established use of Oracle database as shared data source, reduced use of data copies
• served as staff representative in national meetings of information managers from Forest Service inventory groups
• served as Program representative in national meetings concerned with national standardization of documentation and statistical estimation procedures
• developed Microsoft Access applications for data entry, client request tracking, tracking of equipment inventory

Statistical support

• provided general statistical support to staff
• statistical review of manuscripts and study plans
• data analysis
• served as Program representative on national statistical standards committee

Team leadership

• developed team evaluation/planning process applied at 6 month intervals to track job requests and team performance
• responsible for final approval of training, submitted timesheets, expenditures

Training

• trained new staff in SAS, SQL, PL/SQL, RCS

Last modified: 12:31:08 23-Jan-2009