Andrew Clarke

systems architecture, e-commerce & database consultant

Andrew Clarke

Résumé

You can download my résumé in PDF or Microsoft Word formats.

What I do:

I architect and create secure, scalable and useful internet applications.  I make business decisions, manage projects, develop databases and write code.

Qualifications:

  • 15 years experience: internet & e-commerce development, project management,
  • Site & systems architecture,
  • Database design, development & maintenance: MS SQL, MySQL, Sybase, Oracle
  • Team leadership, personnel management, hiring, mentoring, playing nicely with others,
  • UNIX, Linux, Solaris, Mac OS X, Windows
  • Open source creator (CFScaffold, Amazon Route 53 components) and committer,
  • ColdFusion, JavaScript, JQuery, CSS, DHTML, Perl, XML, Java, C, IIS, HTTP, DNS, Apache, Tomcat, Railo, Amazon EC2 cloud, etc.

Selected Systems Architecture Experience

City of Guelph

  • Senior technical/web architect for the City of Guelph, ON Canada.
  • Developed geographically redundant, high-availability web server architecture and implementation plan for the City.
  • Provided cost/benefit and risk analyses of in-house (VMware) vs. cloud-based hosting for City sites.

Visa

  • Architected and developed a power forms generator used by Visa for PCI compliance of member banks.

Floorshop.com

  • Developed Floorshop.com from the founder's idea into a successful, high-volumr e-commerce site, over six years.
  • Scaled successfully from a startup to 8 figures in annual sales without a significant rewrite.
  • Managed most technical aspects of the site until it was acquired in 2004.

Bullhive

  • Conceptualized, designed and built a product which uses Amazon's Cloud (EC2 and Route 53) to provide on-demand processing power to financial markets.

TELUS Security Solutions

  • Provide and manage a team supporting 24x7x365 uptime to TELUS security products,
  • Support complex PCI-compliant web systems architectures.

The Marco Corporation

  • Providing ongoing senior-level strategic guidance across many aspects of IT.
  • Architect and developed improved software development lifecycle.
  • Provided recommendations on hardware, software, network redundancy, software design and development.
  • Security audit of web systems.
  • Trained staff on object oriented development, 3-tier systems, and other subjects.
  • Identified an opportunity and implemented a project using an open source application server stack to save tens of thousands of dollars in license fees.

Igloo Software

  • I was brought in to solve a specific uptime issue.  I resolved the problem in under 45 minutes and worked with them for another year.
  • I kept an outdated, inherited, undocumented web system, relied upon by over 100,000 worldwide users, running until we could migrate it to its new owner.

Others

  • Designed, architected, project managed and/or developed many other e-commerce systems with up to millions of products (e.g. entire ISBN, CD, and movie catalogues).
  • Created open source dynamic ORM (object relationship mapping) CRUD (create/read/update/delete) scaffolding tool for ColdFusion/Railo.
  • Wrote ColdFusion's open source implementation for Amazon's Route 53 DNS provider, recognized by Amazon.

Selected Work Experience

Independent e-commerce, database & security consultant

October 2005 - Present

  • Bullhive: Founder and developer of Bullhive, a service providing computing resources for financial modelling.
  • TELUS Security Solutions: Assembled and manage a team providing 24x7x365 uptime support for two TELUS security products. Development and maintenance of credit card security software.
  • Policy Medical: Maintaining ColdFusion-based code, new development, client installations and updates, managing customer technical support.
  • The Marco Corporation: Senior-level technical recommendations, security reviews & implementations in ColdFusion, Railo and MS SQL Server.
  • Igloo Software: Maintained Dgroups worldwide collaboration site. Management of other in-house projects.
  • Other: Security auditing & consulting, e-commerce consulting, ColdFusion, MySQL, MSSQL, Sybase, Java, development.
  • Senior Software Engineer

    Autobytel.com - Irvine, CA

    February-October 2005

  • Specializing in search engine optimization R&D for Autobytel's sites (autobytel.com, autoweb.com, autosite.com, car.com, carsmart.com, onlyautos.com, etc.)
  • ColdFusion and MSSQL development
  • Independent Consultant (president, clarke.ca inc.)

    Various Projects

    January 2001 - February 2005

  • Visa - Architected and developed powerful form generator using ColdFusion and MySQL, according to specifications. Target audience was Visa member banks.
  • AT&T Wireless Developed intranet applications for their Customer Base Marketing team using ColdFusion 5 and Oracle 8
  • Floorshop.com - Technical management, development & systems architecture. FloorShop is a very successful e-commerce site, using ColdFusion MX and MS SQL Server 2000. I built the site in 1998, and was responsible for most technical aspects until 2004 when the company merged with another.
  • Built interface between T-Online and IP Dynamics' VPN using Java Servlets, JSP, Tomcat & Struts.
  • Various other projects using ColdFusion and MS SQL Server. Includes work with WebObjects, Burlington Containers, SuperWarehouse, Online Building Products, and others.
  • Senior Technical Developer/Architect

    StyleLogic/FirstHost - San Diego, CA

    August 1998 - December 2000

  • Team/Lead Developer/Architect, depending on the project
  • August 1998 - December 2000

  • Developed interactive web sites (e.g. http://www.stlouisrams.com, http://www.bigwords.com, http://store.globalmedia.com, http://www.floorshop.com).
  • Site Architecture & Database design for contract and "proprietary" sites.
  • Performed Sales Prequalification and Support
  • Wrote Proposals and Contracts
  • ColdFusion Experience (3.0 - 4.5 Professional & Enterprise): Full range of Functions & Tags, Server Setup & Maintenance, Custom Tags, ODBC, OLE DB, Internet, e-Commerce, Intranet, B2B, EDI, Front-End, Back-End Development Experience.
  • Microsoft SQL Server (6.5, 7.0, 2000) Experience: Stored Procedures, Database Architecture, Creation, Maintenance, Performance Tuning, ODBC, OLE DB, OLAP, DTS, T-SQL, etc.
  • Experience with Oracle, Microsoft Windows NT Server, Microsoft IIS, Javascript, XML, XSL, DHTML, CSS
  • Web Developer

    Cox Interactive Media - San Diego, CA

    February - July 1998

  • Responsible for local technical aspects of San Diego Insider web site.
  • Experience with Solaris, Red Hat Linux, Perl, Apache
  • Internet Developer

    Nikean - San Diego, CA

    October 1997 - February 1998

  • Created HDML (WAP) version of part of http://www.sixdegrees.com using ColdFusion
  • Designed and built Nikean's corporate web site
  • Experience with HDML (WAP), ColdFusion
  • Implementation Analyst, Web Engineer

    First Virtual Holdings Incorporated - San Diego, CA

    February - December 1997

  • Utilized my extensive understanding of electronic commerce to the First Virtual Internet Payment System into more than 20 merchants' internet commerce sites on a variety of platforms
  • Gained an appreciation for the importance of the Customer Experience,
  • Developed CGI/Perl code, JavaScript, ColdFusion, etc. to facilitate merchants' implementations,
  • Implemented the First Virtual IPS into more than 20 merchants' internet commerce sites on a variety of platforms,
  • Developed policies, procedures, and manuals for Implementation Department,
  • Experience with TCP/IP, HTTP, MIME, SMTP, POP3, SQL, etc.
  • Contract Development

    Various Companies in California, Arkansas, and Canada

    October 1996 - January 1997

  • Developed CGI/Perl code for a variety of web applications (shopping carts, search engines, etc.) running under NT, IIS, Apache, Solaris, etc.,
  • Useful experience in internet site definition and management.
  • Helped clients define their needs and make their internet presence worthwhile
  • Student Engineer

    Various 4-month "Co-operative" Assignments

    January 1993 - August 1995

  • Benefitted from two years of professional work experience in a variety of situations
  • Gained significant MIS, database, internet and other technical experience
  •  

    Selected Education:

    University of Waterloo

    Waterloo, Ontario, Canada

    1991 - 1996

  • Honours Co-operative Bachelor of Applied Science in Civil Engineering,
  • Other Coursework

  • Java 1 - UCSD Extension (July - September 2000)
  • Advanced Perl Programming - (May 1998)