Terrence M. Brannon

metaperl@urth.org

Phone: (803) 781-4191


Web: http://www.metaperl.com


713 Chadford Road, Irmo, SC 29063


Skills

Perl

Expert-level. 4 years of corporate-level experience. Software publications on CPAN.org (author id TBONE). Print publications on perl.com and The Perl Journal. Emphasizes using Perl as a community language and makes efforts to stay in close contact with all daily news sources on the language.Ranked as a saint (highest level) at perlmonks.org. Former webmaster of dbi.perl.org. Demonstrated strength in every area in which Perl sees wide usage, namely:


Object-Oriented Programming - the use of inheritance and polymorphism to simplify complex system development.

Database-Driven Applications - procedural Perl programs manipulating business objects modeled in database schemas (contrast with object persistence efforts such as Tangram, Class::DBI, SPOPS and Alzabo).

Data Munging - the reading, transformation and writing of data

Web Programming - Customized, dynamic website generation via mod_perl/CGI.

SQL/Databases

Competent. Work experience (schema creation, SQL and stored procedures) with Sybase, Informix, MySQL, Postgresql and Oracle. Both print publications were on Perl database usage.

Other

Competent in XML/HTML with a focus on dynamic generation of these via Perl. Fluent in C. 16 years of experience with various Unix types. Applicant has no interest in positions which have even marginal requirements for Java or C++ usage.

Publications

T.M. Brannon, "Beyond Hardcoded Database Applications with DBIx::Recordset" The Perl Journal. Issue 20 (http://www.tpj.com/archives/vol5_4)

T.M. Brannon "DBIx::Recordset - a DBI Extension for Application-Level Database Use", Perl.com, Feb. 27, 2001 (http://www.perl.com/pub/2001/02/dbix.html)

Poirazi, P, Brannon, T & Mel, B.W. (2003) Arithmetic of Subthreshold Synaptic Summation in a Model CA1 Pyramidal Cell. Neuron, 37, 977-987.

Poirazi, P, Brannon, T & Mel, B.W. (2003) Pyramidal Neuron as 2-Layer Neural Network. Neuron, 37, 989-999

Education


M.S. Computational Neuroscience, University of Southern California, May 1999. Thesis research: Non-linear synaptic integration in cortical pyramidal neurons.

M.S. Computer Science, Lehigh University, December 1993. Thesis title: "Chameleon: An Embedded Language Perspective for Programming in Multiple Computer Languages.”

B.A. Computer Science, Morehouse College, May 1987.

Employment

Perl Developer July 2003 - December 2003

Direct Synergy Westwood, CA

Tools used: Perl (DBI, Mail::Box, ParseExcel), SQL, Sybase, SQL Server 2000

Skills used: Excel processing, Database Processing, Data Munging, Unix shell scripting

This company was in the business of attracting, warehousing, and selling business leads for various target markets. My job was to use or design Perl-based technology on databases, data files, and Excel files related to their business process:





Perl-Interwoven Developer September 2002 - December 2002

City of New York Department of Information Technology NY, NY

Tools used: Perl (XML::TreeBuilder, Spreadsheet::ParseExcel, Spreadsheet::WriteExcel),

Skills used: XML processing, Data Munging, Text parsing (regular expressions)

Worked on the City of New York's 3-1-1 Call Center Application. This application did customer service via Siebel 7 using content from Interwoven Teamsite. My job was to populate and integrity-check the TeamSite repository. To do so, entailed writing several Perl programs:

xls-to-html: Take content developed in Excel spreadsheets and convert it to HTML. In the process, sanity check the Excel spreadsheet for unprintable characters and empty rows.

html-to-dcrs: Take the HTML and convert it to two target formats, one for digestion by Interwoven teamsite and another for use by Siebel 7. Creating the Interwoven content entailed the copying of presentation and data capture templates, making directories and creating a large number of small XML files called ``data content records''. To aid the creation of Siebel integration objects, the plain text was converted to a searchable XML database. The database had 3 levels:agency, division, and service.

agency-def-maint: This program did two things. It could create a TeamSite repository for a new agency based on an XML file. It could also ``synchronize'' a repository with an XML file, removing items from the repository which did not exist in the XML file.

rename-dcr: Changing the name of a data content record has ramifications in other parts of the TeamSite repository as well as in the XML database. This script did a ``smart rename'', by taking care of all dependencies implicit in the rename of a DCR as a function of the DCR's type.

Independent Consultant January 2002 - September 2002

Columbia, SC

Tools used: Perl (DBI, DBIx::AnyDBD, Net::FTP, HTML::Mason)

Skills used: mod_perl/CGI, Database-Driven Applications, SQL


Extended and promoted my module Net::FTP::Common. This is a module designed for application-level usage of Net::FTP. Developed Net::FTP::Backup as proof-of-concept for Net::FTP::Common's ease of use. Presented a talk on Net::FTP::Common at the New York PC User's Group. In the spirit of open source consulting, provided free help for an individual working on FTP-based transfer of trade files.

Developed the official website for the Perl Database Interface (http://dbi.perl.org). Used HTML::Mason to create dynamic content. Made use of autohandlers to give the site a consistent look and feel.

Developed PApp::Hinduism, an application for storage and retrieval of information about Hindu courses. Designed the database schemas and developed all Perl code to interface with the database.

Support work for the Cargotel.com website. Besides a number of small bugfixes, I developed a dynamically generated webpage which parsed Apache logfiles and displayed the frequency of website usage as a function of use.

Teamed with Knowmad.com consulting to produce training materials for validating web forms under Perl (Data::FormValidator::Tutorial). Also analyzed the current state of form validation under Perl and created suggestions for extending form validation to include taint checking in an orthogonal fashion.

Developed the domain registry web interface for the Foundation for Technology Innovation (http://www.fti.sc). Used HTML::Mason to general all dynamic content.

Senior Application Engineer (Permanent) February 2001 - October 2001

Oracle, Applications Integration Group Redwood Shores, CA

Tools used: Perl (DBI, Net::FTPServer, LWP), Oracle DBMS, PL/SQL, HTML

Skills used: mod_perl/CGI, Database-Driven Application, SQL


· Worked in the Applications Integration group. This group is responsible for releasing software patches and complete distributions via a database-driven mod_perl web site. Though the term "project" is used throughout this job description, the actual work varied in size from quick bug fixes to extensive solo development efforts.

Projects completed

· Project 8: Authored perltest.pl, which generated and formatted the questions for the Oracle India Perl Competency test. Also responsible for more than 50% of the actual questions used.

· Project 7: Sole developer of ARUFTPD, an virtual file-system FTP server. This server was derived from the CPAN Net::FTPServer to provide navigation and retrieval of files and directories on a remote file system with an FTP front end. Authentication and authorization were handled via SQL queries on an Oracle database.

· Project 6: Used libwww-perl to write a "web spider" to simulate browser navigation across multiple screens (including login and authentication) in order to allow command-line based download of patch files. My initial implementation visited several pages in succession, parsing each page for its action to decide on the next page to request. The redesigned version subclassed the existing download class with a batch derivation and the resulting LWP script made one page call and the derived class called all the screens by calling the Perl methods to generate each screen. In my eyes, my initial approach was better, but higher management preferred the latter. Wrote a regression test suite to ensure usage under normal and exceptional cases.

· Project 5: Developed a mod_perl handler, which allowed for partial-content (resumable) downloads.

· project 4: Wrote a PL/SQL program which scanned all Oracle product families for those with upload responsibilities and added these responsibilities to the appropriate administrators.

· Project 3: Used subqueries to update the comment field of all patches related to a particular patchset.

· Project 2: When our OraDB API was re-implemented using DBI instead of Oraperl, I wrote an evaluation of the code conversion. I also designed and implemented an API for calling stored functions and procedures that would add the ability to bind OUT parameters without breaking existing calls which only used IN parameters.

· Project 1: Developed a new dynamic HTML page and the corresponding SQL/PLSQL which would allow previously obsoleted patches to have their reasons for obsolescence edited and committed to the database. Program business logic was conditional to the mode of screen processing (obsolete versus re-obsolete). Diagrammed the process flow with Visio prior to making system changes.



Perl Programmer November 2000 – January 2001

Sapient/MCY.com Jersey City, NJ.

Tools used: Perl, Informix

Skills used: Data Munging, Parsing


Developed scripts and modules to parse and generate fixed-width text files for various EDI (electronic data interchange) feeds. Improved my CPAN module Parse::FixedLength. Extended Text::FixedLength with Text::FixedLength::Extra by creating a simpler API and adding support for leading zero and floating point formatting.


Perl Programmer May 2000 – November 2000

Instinet/Reuters Manhattan, NY.

Tools used: Perl (Net::FTP, Config::INIFiles)

Skills used: Object-oriented programming


Developed INETCROSSFTP, an FTP system with the following phases: drag and drop GUI interface, file conversion, FTP file upload/download/monitoring, and PGP-based file encryption. Behavior reuse, composition and configuration as a function of individual client requests, static configuration file and dynamically supplied command line options was achieved via a 3-level object-oriented hierarchy of iterable behaviors. The base class was HostCycle. All subclasses cycled across FTP servers performing their until() method until it returned true at which time they executed their then() method. Identification of common Net::FTP usages led to my development of Net::FTP::Common..

Also developed a smaller script which was responsible for monitoring FTP repositories for incom trade data and transferring it to a different machine via FTP.


Lead Developer January 2000 – May 2000

Angryman.com Queens, NY.

Tools used: Perl (DBI, CGI, DBIx::Recordset, Cache::Cache), MySQL, HTML

Skills used: mod_perl/CGI, Database-Driven Application, Object-Oriented Programming


Developed a persistent distributed framework in which Vote objects were committed to a File::Cache and then resurrected and committed to database via slave objects.


Used Date::Manip to develop Date::Horoscope, a module that determines Zodiac sign based on birth date (These days Date::Range might be more appropriate). Also used Date::Manip to determine a persons age bracket based on birthdate.


Used libwww-perl to convert slow-loading dynamically generated pages to static cached equivalents. Ultimately developed CGI::Cache (now maintained by David Coppit).


While consulting at a polling company, used HTML::Embperl to develop a multi-screen "Create-a-Poll wizard" Used DBIx::Recordset to commit the generated poll to database.


Perl Programmer June 1999 -December 1999

End70.com Irvine, CA.

Tools used: Perl (DBI, CGI), MySQL

Skills used: mod_perl/CGI, Database-Driven Application, SQL


Used Date::Manip to realistically populate a MySQL customer database with lease initiation and shipment dates. (lease-processing/random-init.pl).


Developed a CGI interface for SQL temporal queries of a database.


Wrote DBI scripts to randomly allocate client leads to salesmen based on various time criteria (ie, 100 oldest leads, all leads on a certain date, etc).


Perl Programmer August 1999 -November 1999

GemConnect.com Irvine, CA.

Tools used: Perl (DBI, HTML::Mason, mod_perl), MySQL

Skills used: mod_perl/CGI, Database-Driven Application, SQL


Responsible for the design and implementation of a prototype business-to-business commerce site. Implemented all of the following in HTML::Mason: a "My Trades" screen, a "Sell product wizard", product counter-offers wizard, and a "Browse Available Products" screen. Entire product was driven by 20 MySQL tables interfaced to Perl with DBIx::Recordset.


Perl Programmer August 1999 -September 1999

Hosting.com North Hollywood, CA.

Tools used: Perl (DBI, CGI), MySQL

Skills used: mod_perl/CGI, Database-Driven Application, SQL


Developed a set of Perl, CGI, and Javascript scripts as well as a MySQL database to collate and analyze flat file user execution logs from 300 web servers. The phases of the project were:


Designed a multi-table MySQL database in which to store log entries.

Wrote a Perl/DBI script to parse execution logs and store them in the created database.

Wrote a Perl/DBI script to query the database. Queries made of use table joins. Complex queries were handled by creating temporary tables.

Developed a web interface to the Perl/CGI query script.


Perl Programmer, Linux Technician (part-time) April 1998-August 1999

Cosmos Engineering Los Angeles, CA

Tools used: Perl (CGI), Linux

Skills used: Data Munging, mod_perl/CGI


Created imagemaps, developed a Perl/CGI interface to a flat-file database. Installed, tested, and configured Linux installations (Redhat and Debian).