Pat G. Palmer
System
administrator/programmer with extensive experience using T-SQL, C#, Java,
ASP.NET and C. Experienced in all phases of the software development
life-cycle. Familiar with web design (ASP.NET, Javascript, CSS, Java
servlets, PHP and classic ASP) and database programming (SQL server or Oracle),
SOAP and REST type web services, Ajax and Javascript, and various assembler
languages. Experienced with Windows, Mac, Linux and Unix.
From
2002-2006, I taught the architecture track for the MCIT program in the
University of Pennsylvania’s CIS department, and through 2011, I remained at
Penn as
an occasional lecturer.
EDUCATION:
- Master
of Science degree, computer science, 1983, University of Tennessee.
- Master
of Arts degree,
public sector management, 1993, University of Pennsylvania, Fels Center.
- Bachelor
of Arts degree.,
German and linguistics, 1974, University of Tennessee, plus 2 years
graduate study in linguistics.
WORK EXPERIENCE:
10/07 to
present: Computer Applications Developer, Academy of Natural Sciences
Philadelphia (Patrick Center, Phycology Section) – http://diatom.ansp.org/
- Administer
a departmental SQL Server 2014 database server and a Microsoft IIS7 web
server.
- Write
web services and web applications exposing algae count, images and taxa
names on the web
- Develop
data models, implement databases, and write C# .NET desktop programs interacting
with databases.
- Write
stored procedures and views for data applications residing on SQL Server.
- Provide
desktop and computer support for a group of ~10 algae scientists.
- Install
and maintain various wikis for departmental documentation
- Develop
tables and queries, and modify forms and reports in Microsoft Access 2003
and 2007.
- Maintain
an existing large dynamic website with applications written in ASP.NET,
ASP and PHP
Publications/conferences:
-
Palmer, P.G.; , "Programming without code," Integrated
STEM Education Conference (ISEC), 2012 IEEE 2nd , vol., no., pp.1-4, 9-9
March 2012,
DOI
10.1109/ISECon.2012.6204177
Part-time
teaching:
9/02 to
9/06: Lecturer, Computer and Information Science department, University of Pennsylvania (MCIT Program) – http://harbormist.com/pgpalmer/
- Taught
software engineering with programming projects in C# for web services,
database, and graphical user interfaces. Taught programming in Java, C and
C#.
- Taught
a computer architecture course for the Master’s in Computer Information
Technology (MCIT) program and a digital design course for the MCIT
program. Projects include extensive C programming on UNIX, including
virtual machines.
- Supervised
independent studies and senior projects for undergraduates.
- From
2004-2006, organized the Xtreme .NET Challenge, a programming contest open
to Penn and Drexel students and sponsored by Microsoft.
- Served
as recruiting liaison for the MCIT program
(http://www.cis.upenn.edu/mcit/).
5/04 to
9/04: Software Developer, Software Engineering Dept., Siemens Corporate
Research in Princeton, NJ
- With
Dr. Andre Bondi, developed a C# application to model latency in the
control network of an automated conveyor belt system designed by
Siemens. This was a large numerical program with a graphical user
interface; it modeled the maximum packet traffic sent across various
configurations of the conveyor system. Latency statistics were
collected in .CVS files and later analyzed in Excel. Results were
used to design network configuration guidelines and limitations. See
http://ethernet.industrial-networking.com/ieb/articledisplay.asp?id=796
7/01 to
8/02: Software design and programming, Wyeth-Ayerst
- Wrote
requirements for additional data feeds of employee records into an Oracle
–based Learning Management System (Ingenium).
- Specified
how to migrate legacy training history data into the Ingenium
database. Manipulated large sets of employee data records in Excel to
match up values across databases and to clean and prepare data for import
into Oracle.
- Designed
new business processes for departments migrating to the learning
management system.
5/99 to
6/01: Technical project management and interface design for training
software, Pedagogue Solutions, Princeton, NJ
- Coordinated
installation of Ingenium (a learning management system) at Wyeth-Ayerst,
including an NT-based Oracle 8.x database, Microsoft IIS4 web server
software, and browser and Windows client tools.
- Wrote
requirements for a feed of employee records into Oracle and managed its
installation.
- Specified,
tested and installed customized reports developed in Crystal Reports.
- Specified
requirements for migration of legacy training history data into the
database, tested migration software, and managed data clean-up afterwards.
- Designed
business processes across 6 departments for use of the new database.
- Worked
with Visual Basic 6.0 and Javascript to enhance an in-house compilation
tool which creates hyperlinks to word definitions in browser-based manuals
based on a master word list.
- Developed
a file repository application and a work management application using
Lotus Domino 4.6a and administered the Notes 4.6a server.
7/96 to
4/99: Web and user interface development for internet telephony, Lucent
Technologies
- Administered
Windows NT development domains (for the ITS-E and VT teams) including
printers, shared drives, CD tower, and web servers (IIS4 and Domino 4.6a).
Provided desktop repair for software and hardware. Managed domain and web
server logins, trusts, server backups, system upgrades, and virus
protection. Assisted project members in setting up Win95/WinNT
dual-boot computers for development.
- Designed
and maintained development/test labs for the ITS-E and VT teams.
Assisted in upgrade to 100 Mb ethernet switches. Negotiated
with the IBM team supporting the Holmdel building to get IBM's building
printer domain to trust the ITS-E domain so that project members could
access all building printers.
- Developed
web-based Domino (Lotus Notes) databases for the ITS-E and VT projects,
including trouble tickets for the field support team, work item tracking,
QA process issues tracking, and departmental IP address allocation.
Administered security and performed backups. Developed
indexing and search pages.
- Developed
content for project web servers, updated daily. Recruited and
trained other project members to provide additional content to the project
web servers. .
- Attended
the 1998 VBITS Conference in Orlando, FL, in Oct. '98. Completed 4
days of training for Lotus Domino web admin and app. development in Jan.
and Feb. '98. Completed 2 days of training for Microsoft's
Visual Interdev web programming software in Nov. '97. Completed a
3-day course in programming for Windows NT, and a week-long course in
Microsoft Visual C++ v4.0.
- Installed
and administered Altavista Forum 2.0b (on Windows NT) for internet
collaboration for Lucent projects.
- Developed
a prototype graphical user interface for administering the ITS-E on
Windows NT using Visual Basic. The prototype was used to refine
requirements for the user interface, and then was later re-developed using
C++.
- Specified
and integrated CGI programs for HTTP file upload on Windows NT, session
management (using hidden fields and query strings), and database access.
3/96 to
6/96: Lotus Notes system administration, Oxford Health Plans
- Installed
two Windows NT 3.51 Server machines for use as Lotus Notes servers.
Installed Lotus Notes TCP/IP-based clients on Windows 95 and Mac's. While
continuing Lotus Notes V3 rollout, installed and evaluated a Lotus Notes
V4 server, including Lotus' Internotes Web Publisher and Navigator, and a
Netscape web server.
- Completed
courses in migrating Lotus Notes R3 to R4, and administering Lotus Notes
R4.
1/95 to
2/96: Integration, Network Notes project in AT&T Business Communications
Systems
- Administered
a departmental web server (O'Reilly's Website) on a Windows NT v3.51
server.
- Completed
courses in Windows NT system administration, Lotus Notes system
administration and Cisco router configuration.
- Integrated
and tested infrastructure for AT&T's Network Notes service, which
offloads Lotus Notes administration from its customers by placing Notes
servers in AT&T's network. Received software deliveries from AT&T
development organizations for installation on various machines which
included Lotus Notes servers on OS/2 and Windows NT, Lotus Notes clients
on all platforms, HP-UX systems with DNS, FTP and Oracle 7 servers and
clients, Cisco routers, SNMP clients and servers, SMTP gateways from Lotus
Notes to the Internet, and web servers on Windows NT 3.51.
- Developed
a Lotus Notes application for tracking testing of multiple software
releases on the AT&T Network Notes project. The database uses embedded
OLE programs developed in Visual Basic to enhance the performance of Notes
v3.3 macros.
- Planned
and deployed the ANN service infrastructure in the field. Received three
peer awards in August 1995 for having very quickly installed a complete
training lab (a small copy of the entire service infrastructure) at the
service site in the field in under three weeks.
4/85 to
12/94: Member of Technical Staff, Operations and Transmission Systems,
AT&T Network Systems, Holmdel, NJ
- Developed
a prototype in Visual Basic using ODBC and SQL*Net to transfer data from
transmission network elements into an Oracle 7 database.
- Developed
a PC prototype to illustrate localization techniques for user interfaces
developed in Visual Basic.
- Wrote
plans for domestic fiber operations and for PC hardware and software
utilization in-house.
- Specified
network management systems being developed for a large fiber-optic network
in Saudi Arabia; led technical integration for operations systems
offerings to three other large Network Systems customers.
- Developed
a UNIX-based graphical user interface prototype illustrating enhancements
in central office user interfaces which led to a new product development.
Active in selling AT&T-NS operations systems, performing demos and
visiting customer sites for technical briefings.
- Coded
a PC-based user interface (front end) in Microsoft C for a transmission
network element.
- Developed
firmware for a performance monitoring circuit pack in a digital
cross-connect system.
- Developed
software tools and manufacturing processes for customizable defaults in
network equipment.
2/84 - 3/85:
Member of Technical Staff, AT&T Consumer Products, Holmdel, NJ.
- Wrote
assembler code for a 4-bit microprocessor used in telephones, modems and
ISDN terminals.
PUBLICATIONS:
- Co-authored
a paper "Evolution of User Interfaces in the Telecommunications
Industry" with Nuray Aykin for the 1992 AT&T Behavioral Sciences
Symposium. Co-authored a follow-up paper, "Evolution of User
Interfaces in the Telecommunications Industry - '93 Update", for the
same symposium in 1993.
- Published
a market survey for use in AT&T Network Systems addressing global
fiber-optic deployment in December 1994, 60 pp., AT&T proprietary.
- Published
an analysis on fiber-in-the-loop work in AT&T Network Systems in April
1994, 75 pp., AT&T proprietary.
OTHER:
- Support
websites for non-profit groups in the Princeton, NJ area (Friends of
Woodfield Reservation, Princeton Country Dancers’ pickup band and MAD band).
- Fulbright
Scholar for linguistics study in Hamburg, Germany, 1976. National Merit
Scholar, 1971-74.
- Play
old-time, Irish and folk music on mandolin.
- Have
assembled several PC's from individual components in my spare time.
- FCC
First Class radio-telephone operator's license, 1975.
- Fluent
in German