PHP MySQL Filemaker XML SQL Perl resumes Boston MA Worcester MA Worcestor MA Springfield MA Amherst MA Northampton MA Hartford CT NY NYC Brattleboro VT ASP.net PHP MySQL Filemaker Access SQL small-business non-profit family-foundation family-foundations organizations email e-mail home-page website web-site fastmail gmail zoneedit zone-edit DNS SMTP POP IMAP J2EE navicat zend development environment contract consultant contracts consultants green eco
Erik Haugsjaa > Resume (http://weblogz.org/ehaugsjaa/resume.html)


                        ERIK P. HAUGSJAA

                        U.S. Citizen
                        ehaugsjaa@weblogz.org

                        147 N Shore Dr
                        Stow, MA 01775
                        (413) 461-2119

-------------
VALUE OFFERED
-------------

 - I specialize in retooling administrative workflow processes through the
   creation of administrative web/database applications, custom e-Commerce
   solutions, and content-management systems -- for large & small-businesses,
   universities, non-profits, and museums.  This is sometimes referred to as
   Enterprise Content Management (ECM) or Collaborative software or "Groupware".
 - I have a broad base of experience in database and web application
   analysis, design and development.
 - I am a technical lead who is also a people-person with excellent
   project-management and writing skills.
 - I am well-versed in explaining technical issues to non-technical
   collaborators.
 - I have a proven record of on-time project completion.

---------
LOCATIONS
---------

 - Hartford Connecticut (Western CT, New Haven, Yale), New York City
   (3-hrs to NYC) and Springfield, Worcester, and Boston Massachusetts
   (1.5-hr). Very close to Southern Vermont (Brattleboro, Montpelier VT),
   Nashua, Salem, New Hampshire (NH), and Providence, Rhode Island (RI).

------------------------
RELEVANT WORK EXPERIENCE
------------------------

Database and Web Consultant - Amherst, MA (Since 2000)

  I am often responsible for the full life-cycle of the design & development
  process -- from workflow modelling, use-case gathering, and requirements
  analysis -- to site architecture, database design, and rapid prototyping.
  I manage other developers and coordinate with graphic design teams as needed.

  Client List:

    HARVARD UNIVERSITY, Harvard Forest, Petersham, MA, 2008-2010
        Internal webapps used by staff to manage site-visit applications, scheduling,
        billing, invoicing, etc.
        http://harvardforest.fas.harvard.edu/

    PATRICK-MURRAY INAUGURAL COMMITTEE, Boston MA, 2007
        Online application and review system managed 1500+ online applications and
        300+ reviewers for $500,000+ of donations to Massachusetts non-profits using
        excess funds from excess inaugural funds.
        http://www.jan4th.org/

    SCHNITZER STEEL NORTHEAST, Everett MA, 2006
        Marketplace database extranet for scrap-steel buyers using supplier
        and scrap scale data and intgrated with geographical database using
        Google Maps API.
        Windows Server 2003: PHP, MySQL, Windows VPN, Windows IIS
        http://www.schnitzersteel.com/

    INSIGHT MEDITATION SOCIETY, Barre MA, 2006
        Reworked their registration and donation website.
        Unix: PHP, MySQL, Javascript, SVN, Flyspray
        http://www.dharma.org/ims/

    HARMAN FAMILY FOUNDATION, Washington DC, 2006
        Database, website, and mail merge tools for managing their grant request process.
        PHP, MySQL, Ajax/Javascript, Navicat/Excel
        http://www.harman-foundation.org

    BRIGHTPATH, Cambridge MA, 2006
        Extranet and customer database for a small business of "learning difficulty"
        specialists from Harvard and MIT.
        PHP, MySQL, PayPal Virtual Terminal
        http://www.mybrightpath.com/

    PAN-ORTHODOX SOCIETY FOR THE ADVANCEMENT OF LITURGICAL MUSIC,
    San Diego CA, 2006
        Mac OSX: Filemaker, Lasso, PHP, Javascript, Paypal IPN integration
        http://www.orthdoxpsalm.org/

    SAN DIEGO STATE UNIVERSITY, FIELD STATION PROGRAMS, San Diego CA, 2005
        Upgrades to their intranet & extranet for real-time ecological
        information-sharing in Southern California.
        PHP, MySQL, Ecoinformatics, Subversion version control, SSH tunneling
        http://fs.sdsu.edu/

    UNIVERSITY of MASSACHUSETTS, Natural Resources Conservation Dept, 2005
        Created a database and web-app for marbled salamander tracking/matching.
        PHP, MySQL, Eco-informatics
        http://www.mandermatcher.com/

    MUSICA RUSSICA Inc, Guilford CT, 2005
        Russian choral music e-commerce site.
        Mac OS X: Lasso & Filemaker upgrade, email migration
        http://www.musicarussica.com/

    LOTSA HELPING HANDS Inc, Sudbury Mass, 2004
        A web-based group-calendar specifically designed for organizing helpers.
        Linux: PHP, MySQL, Javascript
        http://www.lotsahelpinghands.com/

    ALLIANCE for the PRUDENT USE of ANTIBIOTICS, Tufts University,
    Medford MA, 2004
        Built a web-based databases and curation and annotation tools for their
        bioinformatics and literature databases.
        Linux: PHP, MySQL, MS Access, Bio-informatics
        http://www.tufts.edu/med/apua/

    STUDYINBRITAIN.com, Belchertown MA, 2004
        Helped small site that was getting bigger.
        Windows: ASP.net, SQL Server, templates
        http://www.studyinbritain.com/

    VINYL.com, Boston MA, 2002
        Built custom e-commerce web-site for re-issue LPs. Linux: PHP, MySQL
        http://www.vinyl.com/

    ENTREMATE.com, Acton MA, 2002
        Built version 1.0 of their entrepreneur matchmaking website
        Linux: PHP, MySQL
        http://www.entremate.com/

    CATALOGUE for PHILANTHROPY, Boston MA & Washington DC, 2001
        Built site backend - a giving database of peer-reviewed charitable
           organizations.  I take the graphical design from the designer in
           Photoshop and make the site happen.
        Built intranet for managing catalog production work-flow including:
         - Bulk "marge-merge" email system
         - Automated review process (70 reviewers, 500 applications per year)
        Linux & Mac OSX: PHP, MySQL, Filemaker, Javascript, AJAX
        http://www.catalogueforphilanthropy.org/

    ELLIS L. PHILLIPS FOUNDATION, Boston MA, 2001
        Small website for a family foundation. Custom CMS allows director to update
        site without technical assistance.
        Linux: PHP, MySQL
        http://www.ellislphillipsfndn.org/

    DISABILITY HISTORY MUSEUM, Conway MA, 2000
        Built site and custom collection-management system for their virtual museum
        Linux: PHP, MySQL, Filemaker Pro, ImageMagick, Amazon S3 media hosting
        http://www.disabilitymuseum.org/

  Some technologies, tools & APIs I use:
    Access, Ajax (DHTML + XMLHTTP), Amazon S3, Apache, ASP.net, callbacks,
    cookies, cron, CSS, cURL, CVS (Tortoise CVS), DHTML, Drupal, Exchange Server,
    Filemaker Pro (and CDML), Gallery 2, Google Apps, HTML, ImageMagick, IMAP, Javascript, JQuery,
    Lasso (LDML), Linux, MS SQL Server, MySQL, passwords, PHP,
    phpBB, sessions, shopping carts, SMTP, SSH, Subversion (Tortoise SVN),
    VDS/VPS systems (e.g. Sphera, Webmin, cPanel),
    VC++, WebEx, XHTML, XML, XMLHTTPRequest, YUI

  Some of my specific database and eCommerce experience:
    - Small-business workflow restructuring or support using webware app's
      on intranet or extranet
    - Credit cards: Linkpoint, Skipjack, Paypal IPN, eBay Turbo Lister/TurboLister
    - Filemaker to MySQL conversions
    - Lasso to PHP conversions
    - Filemaker Pro 6, 7, 8 upgrades (from .FP3 to .FP5 to .FP7)
    - ASP/VBA and Access to MySQL conversions
    - Excel conversions and custom Excel VBA scripting
    - Amazon Associates
    - Google Adwords, Google AdSense, Google Analytics
    - Custom website log-file traffic-analysis tools using customlog,
      rotatelogs, logrotate, and PHP.

--------

University of Massachusetts - Amherst, MA (2002-2004) 
Natural Resources Conservation Department

  RMLANDS Project - Rocky Mountain Landscape Simulator
  Spatial modelling of forest ecology over 800-year timeframes for two
  US National Forests located in Colorado.  C++ simulation includes fire,
  insects, pathogens, logging, etc. based on satellite imagery, empirical
  data and expert opinion from forest-ecology researchers and managers.
  (Think "Sim-Forest", but this is for real and used by forest managers.)
  http://www.umass.edu/landeco/research/rmlands/rmlands.html

  Technologies and tools: ArcGIS, CVS, PHP, VBA/Excel, Visual C++, VNC,
                          Window 2003, Rack-mounted Dell PowerEdge Servers

--------

International Telecommunication Union - Geneva, Switzerland (2001) 

    HEAD - Information Systems Support, Telecommunication Development Dept

    Design, development, and maintenance of custom administrative and
    financial database applications for a 120-person department.
    Gathering and analysis of user requirements.  Database design and
    interface development in Access.  Manager of 3 technical staff members.
    http://www.itu.int/ITU-D/

    Technologies and tools: VBA, Access 2000, ASP, French

--------

marchFIRST - Geneva, Switzerland (2000) 

    SENIOR CONSULTANT
    Technical team lead and integration expert.  marchFIRST's clients
    were large international corporations with large-scale eCommerce or
    website needs.  Some projects:

    - Reuters       - Created Reuters Markets Monitor, www.reuters.com/rmmi
    - Philip Morris - Architect & technical lead: Human Resources intranet
    - trader.com    - Javascript and Perl "guru" for 3 of classified-ad sites:
                      cars, jobs, heavy farm & construction equipment
    - Serono        - Corporate website redesign: www.serono.com
    - advalvas.be   - Most popular Belgian web portal, HTML template design

    Technologies and tools: ASP/Access/IIS, Javascript/HTML/DHTML/CSS,
                            Perl, PHP, Photoshop, Dreamweaver
--------

Kent State University, Distance Learning Department (1998-1999)

    TECHNICAL TEAM LEAD
    Designed and lead the development of web-applications used for the
    creation, teaching and management of university courses in classroom,
    web-based, and conference-based settings.  Iterative development given
    changing requirements of faculty.  Tools integrated with the university
    student information system for class registration and with online library
    resources.   Managed team of 5 staff programmers and graduate students.
    http://www.kent.edu/dl/

    Modules developed:
    - online course-catalog and syllabi for university courses
    - online testing (similar to the UMass OWL project)
    - online web-course development and management tool (similar to WebCT)

    Technologies and tools: ASP/IIS/Access, RealAudio RealServer

--------

University of Massachusetts - Computer Science Dept. (1996-1998)
STAFF PROGRAMMER, Center for Computer-Based Instructional Technology (CCBIT)
http://ccbit.cs.umass.edu/ccbit/

    Worked on four projects over three years:

    OWL -- TECHNICAL TEAM LEAD
    Directed the original design and development team for "OWL", the web-
    based quiz and homework system currently in use at the University of
    Massachusetts.  OWL is used by more than 2-dozen UMass departments as
    well as other universities.  Implemented student tracking & grading;
    web-based authoring; parameterized questions; embedded Java simulations
    and exercises.  Managed 3 staff programmers and 3 graduate students.
    http://owl.cs.umass.edu/owl/
    Development tools: CGI, C++, Perl, SQL Server, Cold Fusion, Windows NT

    BEYOND AFFLICATION -- TECHNICAL CONSULTANT (Site Architect, Perl guru)
    Brought in to help meet a tight production deadline for the
    companion website to an NPR radio program: "Beyond Affliction -
    The Disability History Project".  Site contained several hundred
    images and related text and RealAudio interviews.  Managed workflow
    for development team of 5 (producers, editors, webmasters).
    Originally hosted at: http://www.npr.org/programs/disability/
    Now at: http://www.straightaheadpictures.org/beyond-affliction/

    METALINKS -- TECHNICAL TEAM LEAD
    Co-designed and developed "MetaLinks", a general authoring & delivery
    system for inquiry-indexed, adaptive hypermedia.  A "next-generation"
    Geology textbook about Plate Tectonics.  Managed 2 graduate students.
    http://ddc.hampshire.edu/metalinks/
    Technologies and tools: FileMaker Pro, Lasso, Javascript, and DHTML

    LIZZIE BORDEN -- SYSTEM ARCHITECT
    Protoyped the course website for "Inductive Approaches to History",
    a course in historical research using primary-source instruction based
    on web-based guided discovery.   http://ccbit.cs.umass.edu/lizzie/

--------

MITRE Corporation, Bedford, Massachusetts (Summer 1993)
Technical Staff, Advanced Information Systems Technology Group
http://www.mitre.org/tech/itc/

    Modified the source-code of the first release of the NCSA Mosaic
    web-browser (in Unix) to create an enhanced, adaptive-hypertext
    prototype for exploring HCI issues.  

    Technologies and tools: Unix, C, X-Windows, HTML, WAIS, gopher

--------

Multiple Sclerosis Society, Waltham, MA (Summer 1986, Summer 1987)
Database Application Consultant

    Designed, implemented, tested and supported MSR, a custom administrative
    database application which managed the MS Read-A-Thon program for all of
    Massachusetts.  Versions for Commodore 64 and Macintosh

---------------------------
OTHER TECHNICAL EXPERIENCE
--------------------------

Center for Knowledge Communication, Computer Science, UMass (1994-1996)
Research and Development Projects with Dr. Beverly Woolf
http://www.cs.umass.edu/~ckc/

    "EON". Developed authoring tool components for a proof-of-concept,
    object-oriented authoring tool for knowledge-based tutors.
    (Domains: Chemistry, Physics, Keigo-Japanese Honorifics)
    http://helios.hampshire.edu/~tjmCCS/eon_www/eon.html

    "IMT" - Injection Molding Computer-Based Tutor. Design & development.
    (Domain: Engineering Design for Manufacturing)
    http://www.ecs.umass.edu/mie/labs/dfm/imm.html

    Technologies and tools: Apple SK8 ("skate") - a now defunct OO-language
                 for multimedia which hoped to compete with Java & Director
--------

MIT Lincoln Laboratory, MA (Summer 1991, Summer 1992)
Technical Staff, Surveillance Systems Group
http://www.ll.mit.edu/

    Adapted the control software (Fortran & C) of a wideband synthetic
    aperture radar system for use with new antenna types and converted
    radar data into needed image-processing format.  Calibrated a DC
    stepper motor used in controlling antenna position along SAR rail.

--------

Lotus Corporation, Cambridge, MA (Summer 1991)
Technical Staff, Lotus 1-2-3 Group

    Worked with staff programmers from Tokyo in software localization
    tasks for the Japanese version of Lotus 1-2-3. Worked independently
    to run weekly system builds and debug C code to fix build errors.

-------------------
TECHNICAL EXPERTISE
-------------------

Web/database integration using the following technologies & techniques:

  DATABASES --
    SQL expert using: Access/Jet/VBA, SQL Server, MySQL, ODBC, FileMaker 7

  WEB --
    Expertise:
      Database-driven websites with administrative back-end for owner
      editing, using... Regular expressions, regexp, site security, eCommerce
      (skipjack,linkpoint,ebay turbolister,paypal ipn), Google visibility
      tweaking

    Languages:
      PHP, ASP, C++, Perl, HTML, Javascript, DHTML, CSS, XML-RPC

    Web Servers & Application Servers:
      Apache, IIS, Cold Fusion, Filemaker Web Companion (CDML), Lasso (LDML)

    Development Applications:
      Interdev, Dreamweaver, Homesite, Photoshop, Imageready, Sourcesafe

  OTHER --
    Operating Systems: Windows,Macintosh,unix/linux,VMS
    Languages: Visual Basic,Ada,Fortran,Lisp,Pascal,Postscript,SK8 (Apple)

---------
LANGUAGES
---------

    English native, proficient in Spanish,
    Beginning French (certified ILO level 2, Geneva Switzerland, 2002)

------------
PUBLICATIONS
------------

    McGarigal, K., Romme, W.H., Goodwin, D., Haugsjaa, E. (2003)
    "Simulating the dynamics in landscape structure and wildlife
    habitat in Rocky Mountain landscapes: The Rocky Mountain Landscape
    Simulator (RMLANDS) and associated models", Final Report On File at
    DNRC, University of Massachusetts, Box 34210, Amherst, MA 01003,
    Department of Natural Resources Conservation.

    Murray, T. and C. Condit, E. Haugsjaa (1998). "MetaLinks:
    Preliminary Framework for Concept-Based Adaptive Hypermedia." In
    workshop proceedings for ITS-98 workshop on WWW-Based Tutoring.
    San Antonio, Aug 1998.

    Haugsjaa, E. (1996) "Collaborative learning through a
    knowledge-based WWW authoring tool", Full paper: Proceedings of
    WebNet'96, San Francisco, CA, Oct 1996.

    Haugsjaa, E. and B. Woolf (1996) "3D Visualization Tools in a
    Design for Manufacture Tutor", Full paper: Proceedings of
    EdMedia'96, Boston, MA, June 1996.

    Beck, J. and M. Stern, E. Haugsjaa (1996) "Applications of AI in
    Education", ACM Crossroads 3.1: Special Issue on AI, Sept 1996.

    Woolf, B. and C. Poli, I. Grosse, E. Haugsjaa, B. Riggs (1996)
    "Multimedia Tutors for Design for Manufacturing, Proceedings of
    Frontiers in Education Conference (FIE'96), Salt Lake City, Nov 1996.

---------
EDUCATION
---------

    Ph.D. candidate in Computer Science (1994-1996)
    University of Massachusetts at Amherst
      Notable: Research with Dr. Tom Murray and Dr. Beverly Woolf:
      - Adaptive Hypertext
      - Authoring Tools for "Intelligent Tutoring Systems"
      - Collaborative Knowledge Construction and Management

    M.S. Electrical and Computer Engineering (1994)
    University of Massachusetts at Amherst
      Notable: 3.8 GPA, Concentration in Wireless Communication Networks

    B.S. Electrical Engineering (1992)
    University of Massachusetts at Amherst
      Notable: 3.5 GPA, Mass State Honor Scholarship (free 4-year tuition)

-----------------------
PROFESSIONAL REFERENCES
-----------------------

    Available Upon Request