Web Software Engineer

Wm. Ruffin Bailey
rufwork@gmail.com
[spam filter enabled; please be as descriptive as possible]
Maintainable, modular, documented, high-quality code delivered in a timely, customer-oriented fashion.



OBJECTIVE:
To deliver high-quality, modular, maintainable code in a timely, customer-oriented fashion.
SUMMARY OF EXPERIENCE:
  • Expert with twelve years' professional experience with multiple relational database management systems.
    • Over six years' professional experience with Microsoft SQL Server (from version 6.5 forward)
    • Over three years' professional experience with MySQL 4.0-5.1.
    • Proficient with Oracle, Sybase, and PostgreSQL, each used on one or more live projects.
  • Expert at ANSI and Transact-SQL.
  • Expert with over ten years' experience with Java, including Tomcat administration and installation, web programming, application design and support.
  • Expert at ActiveX Data Objects (ADO) and ADO.NET, the Microsoft parallels for JDO and other relational-object oriented bridge technologies. Familiar with JDO and Apple WebObjects.
  • Expert at the creation and integration of server-side scripting languages with html-based web interfaces.
    • Over seven years' experience with ASP and ASP.NET.
    • Over three years' experience with PHP.
    • Expert at Crystal Reports and familiar with JSP.
  • Expert at dynamic html design, including AJAX, CSS, Javascript, and various browser Document Object Models. Technical site designed featured on USAToday.com.
  • Trusted with multi-million dollar fiscal project planning databases for NOAA line office and, with Blackbaud, university and other client fund-raising lists, including values given and donor home addresses.
  • Excellent composition and communication skills, with four semesters' teaching experience in technical and business composition at the University of South Carolina during graduate school.
DETAILED EXPERIENCE:
(In-depth examples of past work: http://www.rufwork.com/resume/pastWork/ )
President, 10/2002-present, Rufwork Programming
Started software development and consulting company in October, 2002. Projects have included database design and maintenance, creation of web-based interfaces to those systems, GIS and geospatial database design, and custom, stand-alone application development.

Most web-based projects utilize AMP stacks (Apache Web Server, MySQL RDBMS, and PHP extensions). Geospatial work includes ArcIMS, ArcGIS Server, MapServer, and Google Maps. Stand-alone application design uses Java or Visual Basic (VB6 and VB.NET). Representative projects follow.
  • SpiderSavings.com (AMP): Mr. Bailey designed and built an online business directory and coupon management system for SpiderSavings.com, including an administration module, coupon provider module, and forward-facing search and display functions. This site also included allowing users to manipulate images on the server, geocode their business addresses, and used AJAX for several functions, including end a method allowing end users to send coupons to themselves via the site's SMS functions.
  • Cruise Services USA (Java): Work included a customized job application processing system, created in Java, for a cruise line employment service. The application retrieves emails created by a web form (part of the cilent's existing workflow), parsed their contents, and placed them into Excel files using automation. As of 2010, the application is still in use and maintained by rufwork programming.
  • NCSU/CRDM (AMP): rufwork programming database-enabled and solved accessibility concerns for North Carolina State University's Communication, Rhetoric, and Digital Media PhD program recruitment website.
  • NCSU/History Department (ArcGIS, Google Maps, AMP): This project, currently underway, comprises the creation of a visual database for presenting courses in history. It allows students to learn visually, providing them with a way to create visual narratives and maps as assignments and to review professors' lecture notes stored in the same manner.
  • Shareware (Visual Basic and Java): rufwork programming entered the Mac shareware market with The Digest Handler, a stand-alone application created in Java that pulls list-server digests off of a user's mail server and parses them into easy to read threads.
    The FAQMaker is rufwork programming's most popular Windows shareware, which helps those without html coding skills very quickly design, edit, reorder, and publish FAQ pages to their sites.
Core Technologies, Web: Apache, MySQL, PHP, SQL (T-SQL & ANSI), ADO.NET, MS-SQL Server, ASP/.NET, VB.NET, HTML 4.01, xhtml 1.0, Javascript, CSS, XML, AJAX
Typical Development Tools, Web: SQuirreL SQL (isql), MAMP (AMP), VIm (text editor), Versions (a subversion revision control client), Transmit (ftp client), Browsers galore

Core Technologies, Applications: VB.NET, C#, Java, JavaMail API, Kunststoff Look & Feel, ADO.NET, MS-SQL Server, Platform-specific delivery tools
Typical Development Tools, Applications: Eclipse (Windows), Netbeans (Macintosh), Visual Studio.NET, SharpDevelop, VS Express
Research Assistant, 1/2006-5/2006, Spenser Digitization and Collation Database Project, USC
Dr. David Miller is coordinating The Spenser Archive with the goal of locating and identifying every extant printed version of Spenser's works before bringing scans of as many of those copies as possible online. The project will utilize a web-enabled, relational database system that would allow worldwide access to critically edited texts based on this collection of scans. Scholars could search for textual variants online, for example, without having to travel to the libraries where the originals are located, and qualified editors could log into the system to add marginalia and new edits.

Mr. Bailey's role was as the de facto technical lead on the project, responsible for testing and recommending digital content management, database and plugin development, and server administration, until a full-time administrator was hired. Tasks involved moving the project's finding list from a legacy Access file to MySQL, installing and configuring Fedora (http://www.fedora.info), a digital content management system, and researching possible improvements to existing digital collation software.
Core Technologies: Mac OS X Server, Apache, MySQL, ANSI SQL, HTML 4.01, Javascript, CSS, XML
Typical Development Tools: VIm, SQuirreL SQL, Mac OS X Server configuration tools, bash
Lead Programmer, 9/2003-7/2004, Rok Technologies, Inc.
Prototyped a replacement system for a land records/tax parcel system for a county government in North Carolina, previously written using UNISYS EAE. Lead programmer responsible for new database schema design all the way through to GUI design and integration with the county's GIS information. Development work done in in VB.NET, using Windows.Forms for GUIs with some test work with Crystal Reports & html for reporting. Oracle 9i via ODP.NET was utilized for the creation of the data tier.

Was also responsible for web-enabling RDBMS systems that communicate with ArcIMS using JSP.
Core Technologies: VB.NET, Visual Basic 6.0, Java (J2EE), JDBC, JSP, Tomcat 4.x, ArcSDE (Spatial Database Engine), IIS, MS-SQL Server 2000, Oracle, ANSI SQL, HTML 4.01, xhtml 1.0, Javascript, CSS, XML
Typical Development Tools: Visual Studio.NET, Netbeans, VB6 IDE, VIm, ArcIMS Author and Adminstrator, MS-SQL Server administration tools
Custom Solutions Developer, 2/2003-8/2003, Blackbaud, Inc.
Customization responsibilities included extending Blackbaud's suite of products through VBA, creating customized Visual Basic 6 stand alone applications that interfaced with Blackbaud product's through COM or directly with the Blackbaud database in Sybase or Microsoft SQL Server, and creation of customized reports for Blackbaud products.

Was also responsible for the creation of a web-based online student application system, which interfaces with Blackbaud's Admissions Management application.
Core Technologies: Visual Basic 6, Blackbaud Raiser's Edge 7-7.61 COM objects, Sybase ASA 5 and 7, MS SQL Server, ANSI SQL, ADO, ADOX
Typical Development Tools: VB 6 IDE, VIm, SQL Server administration tools, SQuirreL SQL, jEdit
Database Administrator/Internet Mapping Specialist, 3/2001-10/2002,
Technology Planning & Management Corporation
Served as the NOAA Coastal Services Center's (CSC) lead Internet mapping server programmer as well as one of two database administrators. Database experience below builds on responsibilities listed in the Database Management Systems Specialist description, above.

Most mapping systems utilized a template for which Mr. Bailey was the lead prorgrammer. This code employed the Environmental Systems Research Institute, Inc. (ESRI) ArcIMS ActiveX connector (pdf), and provided functionality through dynamic html, cascading stylesheets, and javascript on the client side with Active Server Pages and Visual Basic Script on the server side. Designed and taught a one-day introduction to "The ArcIMS ActiveX Connector" for approximately ten employees at CSC. Received three TPMC President's Awards for project contributions, and had one site featured on USAToday.com.

Descriptions of Mr. Bailey's ArcIMS sites are listed at the following URL: http://www.rufwork.com/resume/pastWork/
Core Technologies: Visual Basic Script, ArcIMS ActiveX Connector, ArcIMS 3.0 through 4.0, ArcSDE (Spatial Database Engine), Tomcat 3.x-4.x, IIS, ASP, ADO, MS SQL Server 7.0 and 2000, SQL (T-SQL & ANSI), HTML 4.01, xhtml 1.0, Javascript, CSS, XML
Typical Development Tools: VIm, UltraEdit, HTML-Kit, ArcIMS Author and Adminstrator, SQL Server administration tools, Custom-built code manipulation tools
Led small programming team in the creation of the first stand-alone application released by CSC. The Build-A-PIVOT application helps National Estuary Program (NEP) and National Estuarine Research Reserve (NERR) offices build web sites interactively, without the need for an on-site html expert. Released to a small group of NEP leaders in Summer 2002, Build-A-PIVOT is scheduled to be available to the public on CD in December 2002.
Core Technologies: Visual Basic 6.0, Desaware ActiveX Gallimaufry, Windows APIs, Microsoft Internet Control
Typical Development Tools: Microsoft Visual Basic 6.0 IDE
Database Management Systems Specialist, 10/1998-3/2001, Technology Planning & Management Corporation
Served as one of two database administrators contracting for a NOAA office of over one hundred employees. Responsible for maintenance of all existing systems as well as the creation of new, non-spatial database systems. These systems included the following:
NOAA Coastal Services Center (CSC) Management Information System (MIS): The MIS assists CSC allot its fifteen-plus million dollar budget and nearly one hundred employees over scores of projects.
CSC Information and Request Tracking System (IRTS): CSC solicits online customer information on a voluntary basis and the IRTS collects and reports this information for internal use.
CSC Dynamic Product Pages (CSC home page): This system kept track of CSC products and descriptions, allowing employees to update the system with new products before in-system managerial review allowed their display in a standardized format on the home page.
Core Technologies: Visual Basic Script, Active Server Pages (ASP), Microsoft SQL Server 6.5-2000, ADO, Microsoft Internet Information Server (IIS), SQL (T-SQL & ANSI), HTML 3.2-4.01, Javascript, CSS
Typical Development Tools: Visual Interdev 6.0, UltraEdit, MS SQL Server administration tools
Experience outside of RDBMS during this time:
Dhtml additions to the ACE Basin Environmental Characterization CD-ROM (http://www.csc.noaa.gov/lcr/text/aceweb.html).
Designed and taught a one-day introduction to "advanced client-side web technologies" for approximately twenty employees at CSC.
EDUCATION:
* Bachelor's Degree, 12/1999 North Carolina State University, Bachelor of Arts in English Literature.
NCSU: Received the John T. Caldwell Alumni Merit Scholarship, the Pulp and Paper Foundation Merit Scholarship, and was an active member of the NCSU Fellows program.

Academic C.V. available here.
Field Researcher, Projet pour les chimpanzees naines, 7/1996 - 8/1996, Duke University
Assisted in establishing a two-person research project in the Lomako Forest of the former Zaire (now the Democratic Republic of Congo) to study the bonobo, or pygmy chimpanzee (Pan paniscus). This involved daily walking of miles of transects in an attempt to "tree" the chimpanzees each night, and taking notes on their actions when spotted in an observable state.
CERTIFICATIONS:
Advanced ArcObjects Component Development, 1/2002 ESRI - Charleston, SC
Introduction to ArcView & Intermediate Arcview GIS 3.2, 10/2000 NOAA/CSC - Charleston, SC
Microsoft Visual Basic 6.0 Fundamental - Advanced Seminars, 6/2000 AppDev - Charleston, SC
Microsoft SQL Server 7 Database Administration: Hands-On, 6/1999 Learning Tree - Boston, MA
REFERENCES: (contact information available on request)
David West, was TPMC Technical Program Manager

Gary Keull, Webmaster, NOAA Coastal Services Center -- Recently retired

John "Matt" Matthews, mathematics professor at University of TN, Chattanooga, and classmate at N.C. State University. Contributor to linuxgames.com and published in several Linux journals.