|
RESUME
of
JAMES L PINSON
|
|
I bring a diverse toolbox of skills, analytical ability, research,
and innovative approaches to the workplace. Proficiencies
include, but are not limited to: Database Administration (SQL
Server and Oracle), data management, ETL, Linux/UNIX System
administration, and technical writing.
In my various positions I have written programs using Perl, Python,
Java, C, shell scripts, T-SQL, and Ruby.
Lifetime learner, author, versatile and flexible.
|
Education
and
Training |
BS degree in Marine Biology, Auburn University.
Novell Certified Netware Engineer (inactive)
Oracle Certified Professional DBA 8i, 9i
FCC Amateur Radio License - N1HJ Extra Class (was KI4KPY)
IS-00100 Introduction to the Incident Command System (FEMA)
IS-00200.FW Basic Incident Command System for Federal Workers
(FEMA)
IS-00700 National Incident Management System (NIMS)
(FEMA)
IS-00800 National Response Plan, an Introduction (NRP) (FEMA)
EC-001 Amateur Radio Emergency Communications Level 1
(ARRL)
PADI Divemaster
NACD Certified Cave Diver
|
Publications |
Pinson, Jim 2005. See your files and descriptions with
"list". (a Perl program) Sys Admin 14(4):36-38
Pinson, Jim 1997. Vgen. (a JAVA web page generator) Sys Admin
6(12):23-36
Jim Pinson. 1995. Electronic mail comes to Galapagos. Notícias de Galápagos 55: 3-4
Pinson, James L. 1991. Designing Screen Interfaces in C.
Prentice-Hall, Englewood Cliffs, New Jersey. 267 pp.
Pinson, James L. 1987. Pull-down menus in 'C'. BYTE
12(5):108-112.
|
July 2006-
June 2010 |
Senior Court Analyst
Florida Supreme Court
Office of the State Courts Administrator (OSCA)
Tallahassee Florida
- Developed a Uniform Data Reporting application based on Table
Oriented Programming techniques where all source table information,
ETL functions, and much of the program logic was stored in a
single, self documenting database table.
- Created a new application logging system that stored
application name, log category, event level and other information
about scheduled jobs in a single database table. This allowed
fast access to log events and had provisions for generating missing
report notification.
- Developed applications to extract data from Excel sreadsheets
and load into database tables.
- Designed numerous reports for analysts using LaTex for PDF
generation, and Microsoft Access queries/reports.
- Converted SAS scripts to use SAS SQL and macros for readability
and portability.
- Created Perl and Python scripts to automatically search
existing log files for errors.
- Developed and tested software in VMWare virtual computer.
|
October 1999-
Ongoing
|
Consultant/Contractor
Work for Unisys, People Network, and my own company J & C
Research has included:
- Senior UNIX System Administrator for UnixWare and Linux servers
supporting a 24x7 system that tracks children and other at-risk
individuals served by Florida social services.
- Improved system reliability and team responsiveness by
developing custom C, Java, Perl and Ruby programs to:
- Monitor Weblogic processes and report problems to Operations
Command Center.
- Create GUI application to allow Operations to monitor and
restart HomeSafeNet servers.
- Monitor Oracle databases to report problems to Operations.
- Monitor Microsoft SQL server connections to backend servers, to
troubleshoot connectivity issues.
- Send alerts to Unisys Single Point Operations console.
- Send problem alerts to pagers of support personnel
- Tested new server configurations and upgrades on Vmware virtual
servers.
Genealogy Database Project:
Extracted data from standard GEDCOM genealogy datafile and
inserted it into MySQL and PostgreSQL databases.
Wrote Perl scripts to process, resize, frame and annotate historic
family photographs, and merged all source documents, database
tables, and images into one fully linked, data-rich web site.
Create PDF documents using LaTeX typesetting language.
|
July 1998-
September 1999
|
Systems Analyst
Department of Management Services
Tallahassee Florida
- Created online documentation systems, searchable knowledge
bases, and other tools to support the COPES system.
- Developed Web interface for problem tracking system running on
Oracle server.
- Developed web interface to the FSAG student loan database used
by Florida DOE.
|
May 1997-
July 1998
|
Systems Programmer III (January 1998- July 1998)
Systems Programmer II (May 1997- January 1998)
Agency for Health Care Administration
Tallahassee Florida
- UNIX system administrator, managed several SUN computers,
including a SUN 6000 with 14 CPU's and 2GB RAM
- Installed and managed the Cisco DNS, and wrote shell and Perl
scripts to process data files.
- Developed Java X-windows front-ends for print queue management
and for tape load scripts.
- Supervised one data center technician.
|
June 1992
February 1996
|
System Network Administrator
Charles Darwin Research Station,
Galapagos Islands, Ecuador
- Created the initial email system at Charles Darwin Research
Station, using KA9Q NOS, Linux and FreeBSD servers connected to
internet via spread-spectrum radio-modems supplied by a grant from
U.S. National Science Foundation and Banco del Pacifico-Ecuador.
Maintained the system via internet from the U.S., 1996-1998.
- Designed and implemented the Station's Ethernet network.
- Designed and set up the Station's first Web page, which was
selected as a valuable Internet resource for Discovery Channel
School's H2Oceans theme, Spring 1997.
- Developed software to parse accounting and scientific data for
conversion to database format.
Additional duties at the Station:
- Collected meteorological data.
- Assisted scientists as research diver, compressor operator, and
divemaster.
- Filmed important visitors and events.
- Advised on electrical and battery backup systems, computer
purchases, and refit of research boat.
|
April 1990 -
June 1992
|
Network Specialist
University Computing and Network Services (UCNS)
University of Georgia.
- Served as the campus-wide CNE (Certified Novell Engineer) and
assisted network managers with with installing and managing their
Novell networks.
- Helped network managers in solving hardware/software
problems.
- Wrote instructional material for in-house seminars.
- Trained and assisted users in the operation of TCP/IP
applications such as Telnet and FTP. Wrote TN3270 installation
programs and documentation.
- Installed and evaluated new Novell and TCP/IP products such as
e-mail packages, LPD and SMTP gateways.
- Listserver manager for the UGA Novell Users discussion
group.
|
September 1988-
March 1990
|
Work on my book "Designing Screen Interfaces in C"
for Yourdon Press/Prentice-Hall, and various programming projects.
Consulting.
|
October 1986-
September 1988
|
Network Manager
College of Business Administration Computer Center (CBACC)
University of Georgia.
- Installed, configured, and supported the CBACC Token Ring
network.
- Customized and installed network software. Wrote dBASE and 'C'
language applications for CBACC.
- Assisted faculty with microcomputer hardware/software
problems.
- Evaluated new microcomputer products and software. Wrote
computer information guides.
|
October 1985-
October 1986
|
Head of Operation Support
College of Business Administration Computer Center (CBACC)
University of Georgia
- Provided hardware and applications software support for the
CBACC.
- Managed computer labs with 40 IBM PC's, printers and modems,
IBM PagePrinter, IBM Color Plotter, Polaroid Palette; 2 AT&T
7300 Unix Minicomputers; RJE site (2 line printers, 12
terminals).
- Supervised 20 student workers and 1 computer operator.
- Author of "HELP-LINE" section of CBACC newsletter.
|
October 1984-
October 1985
|
Biological Technician
Georgia Sea Grant Program
University of Georgia
- Designed, built and evaluated eel trap designs for Georgia Sea
Grant program (funded for 1 year).
- Field test of trap designs with follow up statistical analysis
(S.A.S.).
- Study of eel behavior in north Florida underwater caves, by
direct observation and underwater video cameras.
- Supervision of field workers.
|
February 1977
October 1984
|
Biological Technician
Insects Affecting Man and Animals Research Lab
United States Department of Agriculture
Gainesville, Florida
- Developed testing techniques for evaluating insecticide residue
effectiveness against various species of medically important
insects.
- Established and maintained a colony of chigger mites (E.
alfreddugesia).
- Field test insecticides against chigger mites and ticks using
Koritz back pack at Camp Blanding and Camp LeJune.
- Wind Tunnel testing of insecticides against mosquitoes, house
flies, and sand flies.
- F.E.M.A designated employee with emergency
responsibilities.
|
Curious
Consulting
Projects
|
- Developed database management software and program protection
schemes for radial keratotomy and interocular lens implant patient
database, for Ophthalmic Prediction Software Inc.,Gainesville
Florida.
- Developed data base software to input data from Scantron Card
reader to PC, for grading student tests; Biology Program,
University of Georgia.
- Wrote 'C' language Data storage system and linked it with
assembly language video scanner software for LAR (Leaf Area
Removed) research project; Institute of Ecology/Dept. Of
Entomology, University of Georgia.
- Created OTP-PC, a One Time Pad encryption system and released
it under a concept I called "DonorWare, which asked users to send a
donation to organizations like the Charles Darwin
Research Station.
- Created an interface between Pegasus Mail program and the KA9Q
packet radio software. I called the interface "G-Mail"
(Galapagos-Mail) since it was designed for the Charles Darwin
Research Station.
- Created Bibliophile, a user friendly bibliographic data
manager. Bibliophile was a shareware product.
- Created Dbase III program for Computerized library Checkout
system. Integrated the program with barcode reader.
|
Contact:
|
James L. Pinson
jim_pinson@jc-research.com
|