Knechtel, Charles Douglas

Mathematical modeling, statistical analysis, computerized simulation. Fisheries, environmental, other problems.

CHARLES DOUGLAS KNECHTEL                  TELEPHONE (206)362-4024
   14349 - 36th Avenue NE; Seattle, Washington 98125   U.S.A.
 
_________________________________________________________________
 
QUALIFICATIONS:
 
1) More than thirteen years intensive education and experience as
   a professional Operations Research Analyst, Statistician, and
   Computer Programmer.  One emphasis has been numerical modeling
   and computerized simulation of fisheries processes for
   purposes of analysis and optimization.  I have applied these
   skills to other problems as well.
2) Training in software engineering, C++, Object-Oriented
   Programming (OOP), Object-Oriented Design (OOD), and C
   programming.  I would be glad to furnish samples of my work.
3) Frequently programmed using FORTRAN IV for eleven years.
   Trained and experienced in good programming practices useful
   for programming in a variety of computer languages, such as
   top-down structured programming.  Successfully designed large
   computer programs and planned solution of large problems.
   Some ALGOL and Pascal programming.
4) User of Microsoft (MS) Excel and Windows for more than six
   years; MS DOS for ten years; WordPerfect and Burroughs CANDE &
   WFL for nine years.  I began using MS Windows 95 in 6/95.
   Eleven years experience frequently using MINITAB, SPSS, BMDP,
   IMSL.  Some Lotus 123; Quicken, TurboTax; MS Publisher, Word,
   Office; WordStar; Procomm, Internet; relational database
   design.  Introductory PC-to-host connections, UNIX, VAX VMS;
   MS Mail & Fax, WinFax Lite, Wang Imaging; World Wide Web
   (WWW), Lynx, MS Internet Explorer; HyperText Markup Language
   (HTML) using MS Word Internet Assistant.
5) More than two years professional experience testing computer
   programs using code analysis and sets of test data; especially
   scientific, mathematical, and statistical applications.
6) Author of more than 800 pages of technical memoranda and
   reports; also experienced in editing.  Have given 13 major
   formal oral presentations.  Volunteer teacher of English as a
   Second Language for one year (part-time).  Background in
   fisheries, ecology, physics, chemistry, biology, geology;
   music; also Russian, German, French languages.
_________________________________________________________________
 
 
EDUCATION (major programs completed):
 
CERTIFICATE IN SOFTWARE ENGINEERING, 1992 (one year program),
  University of Washington.  Studied computer program design
  methodology including specification; object-oriented design;
  technical documentation; systematic software testing; some data
  base design, data modeling, SQL; and a practice project.
 
M.S. BIOMATHEMATICS, Quantitative Ecology & Resource Management
  Option, 3.35 gpa, 1983, University of Washington.  Emphasized
  design and computer programming of simulations, also
  statistical analysis and fisheries applications.  My thesis was
  titled "A numerical simulation model of the population dynamics
  of Walleye Pollock, Theragra chalcogramma (Pallas 1811), in a
  simplified ecosystem."
 
B.S. WITH COLLEGE HONORS IN MATHEMATICS, 3.38 gpa, 1972,
  University of Washington.
 
 
MEMBER of Pacific Northwest PC Users Group,
REFERENCES furnished upon request.
 
 
EXAMPLES OF WORK EXPERIENCE:
 
APTLOGIC COMPUTER PROGRAMMING AND STATISTICAL ANALYSIS: 11/88-
  present (part-time), Seattle, WA; (206)784-7424.  I am the
  owner.  I consult regarding statistical analysis, mathematics,
  computer programming, and numerical modeling.  I've organized
  as a small business: obtained licenses, marketed services.
    Projects performed include
 
  SOFTWARE REVIEWS:  User tested three software packages being
prepared for commercial distribution, and made verbal and written
suggestions for improvement.
  COMPUTER UPGRADE:  Purchased, installed, upgraded, and
configured software & hardware.  Software examples: DOS, Windows,
Windows 95, Office (incl. Excel, Word), C/C++ compilers, Internet
Explorer, Procomm, WordPerfect, TurboTax, Quicken, WinFax Lite,
virus checkers.  Hardware examples: hard drives & controllers, CD-
ROM drive & interface card, floppy disk drive, SIMM memory,
numeric coprocessor, monitor, fax modems, batteries.
  TUTORED STUDENTS in statistical analysis and algebra.
  ACCOUNTING SPREADSHEETS:  Designed, tested, and then used Excel
for Windows spreadsheets for payroll, taxes, and reporting as
volunteer treasurer for a church with 3 to 4 paid staff (approx.
4 hour/week for 3 years).
  FISHING VESSEL COURT CASE:  Performed statistical significance
tests of whether proportion of illegal undersized crab in sampled
commercial catches exceeded tolerable limits; calculated power
functions for associated binomial and negative binomial sampling.
Also calculated significance levels using the negative
hypergeometric distribution in order to measure the effect of
sampling from a finite population on negative binomial sampling -
this technique had apparently never been used before in
fisheries. Programmed Excel spreadsheets to perform all
calculations and graphics.  Wrote report of implications.
  TRAWL NET DRAG:  Explicitly determined and wrote report
describing functions & parameters used by a foreign researcher to
estimate drag of trawl nets, so that the functions could be used
to design actual fishing nets with reduced drag.  Programmed
Excel spreadsheets to use the functions.
  EFFECTIVENESS OF AREA CLOSURE:  Estimated statistical
significance of differences between catch rates of crabs inside &
outside a closed area; wrote report of implications.
  BULL TROUT ABUNDANCE ANALYSIS:  Performed frequency table
analysis of counts by a researcher of bull trout in a stream.
Designed & used Excel spreadsheets to perform these analyses
utilizing a method thought robust for small expected counts.
  INFECTION RATE COMPARISONS:  Designed and used Excel
spreadsheets to generate graphs and calculate Peto-Prentice tests
of the statistical significance of differences in infection rates
of human patients.
  TESTS OF DIETING EFFECTIVENESS:  Designed and used Excel
spreadsheets to generate graphs, perform linear regressions, and
calculate tests of statistical significance of weight reduction
of humans while dieting.  Wrote report of results.
  SEWAGE FLOW RATES:  Implemented equations in a MS Works
spreadsheet which predicted sewage flow rates in pipes.
  MOTOR OIL COSTS:  Set up equations describing various costs of
using different kinds of engine motor oil in various vehicles,
for the purpose of selecting the most economical motor oil.
Implemented equations in Excel spreadsheets.
 
 
SCHOOL BUS DRIVER, 10/91-1/96 (approx. half-time).  Safely
  transport and supervise 12 to 60 children on schedule.  Perform
  operator inspections of vehicle twice daily.
 
 
ASSEMBLY LINE TEAM MEMBER, 7/93-12/95 (school vacations & some
  Saturdays).  Assembly line worker helping manufacture packaged
  software, luggage, flower arrangements, printed circuit boards,
  packaging, recycled paper.  Some quality assurance/quality
  control (QA/QC).  Some shipping & receiving microcomputers, and
  checking for missing parts.  Introductory training in
  electronic assembly (soldering & component id).
 
 
TELEPHONE SALES REPRESENTATIVE, 7/9/91-8/16/91 (26 hour/week
  average).  Voicelink Data Services, Redmond, WA.  Sold
  enrollments in a mortgage repayment plan which slashed
  cumulative interest.  Entered information using computerized
  data entry screens.
 
 
TELEPHONE INTERVIEWER, 5/90-5/91 (35 hour/week average).  M/A/R/C
  Inc., Seattle, WA.  Interviewed consumers over the telephone to
  survey their satisfaction with certain services & products.
  Used computerized data entry screens to enter collected data &
  comments.
 
 
NATIONAL MARINE FISHERIES SERVICE, Seattle, WA.
  OPERATIONS RESEARCH ANALYST, 3/80-10/88.  Conducted complex
fisheries scientific research under limited supervision; eligible
for rehire.  Always rated fully successful or better for all
performance elements; e.g., planning, execution of plans,
communication of findings.  Researched, designed, wrote, tested,
used, & analyzed complex computer programs & simulations: for
example, Monte Carlo simulations; numerical integration of
multiple differential equations; statistical analyses, analysis
of variance (ANOVA). Participated in at-sea fishery surveys.
Solved three major problems attempted but unsolved by Ph.D.'s for
fishery trawl surveys costing thousands of dollars per day: i.e.,
1) a method to calculate the statistical significance of
comparisons of trawl survey abundance estimates between two or
more years, 2) an upper bound for the statistical significance of
these comparisons for a given sample size, and 3) an optimal
compromise allocation of sampling effort for surveys of bivariate
populations (easily extendible to multivariate).  Wrote technical
memoranda and reports of results and implications.  Frequently
asked to review (i.e., critique) the papers and work of other
persons.
  MATHEMATICAL STATISTICIAN, 9/78-12/79 (functioned as an
Operations Research Analyst, 12/79-3/80).  Performed statistical
data analysis and interpretation.  Utilized, developed, and
tested computer programs; wrote documentation.  Prepared,
checked, and corrected data for analysis.  Organized, designed,
and programmed a computerized relational database recording
instances of diseased salmonids using SIR (Scientific Information
Retrieval).  Checked appropriateness and accuracy of statistical
methods used in field or laboratory tests.  Gave advice on data
collection and formats for data records. One major project was
statistical supervision of collection of data regarding
comparative effectiveness of two types of screens used to guide
various species of salmon smolts around turbine inlets of dams on
the Columbia River.
  STUDENT HELPER, 11/77-9/78 (paid by University of Washington).
Analyzed code, corrected, and optimized the FORTRAN program for
the complex computer simulation of a sockeye salmon population
migrating in the Bering Sea; also coded, checked, and corrected
data for the simulations.  Prepared overlays for computer
printouts; drew contour maps using computer printouts of data.