Andrew Clarke

systems architecture, e-commerce & database consultant

Andrew Clarke

What do I do?

I do everything from full technical strategic plans and implementations to simple programming fixes. Depending on the client, my assistance can be as little as a fifteen minute bug fix to a long term partnership managing a multi-million dollar e-commerce site.

With fifteen years of internet e-commerce development experience, I can help you define what exactly you need, and then manage and implement that plan. Ways I have helped other clients include:

  • Solutions and technical architure,
  • Developing full e-commerce sites,
  • Long term technical management and development,
  • Working with graphic design companies to provide technical development for their clients,
  • Fixing bugs in and adding features to existing sites,
  • Providing ongoing technical support to keep sites operational,
  • Credit card processing and shipping implementation for e-commerce,
  • Developing and implementing a strategy for existing companies wanting to take better advantage of the internet,
  • Developing tools for companies to securely share inventory information with suppliers or distributors,
  • Security audits - identify areas of an internet presence that have weak security, and proposing and implementing solutions,
  • Project Management - bringing together a team and getting a project delivered on time,
  • Set up and manage online advertising using Google Adwords or Yahoo Overture.

Programming

Most of my current experience is with ColdFusion. I have been using ColdFusion since 1997 and have developed a wide variety of sites with this technology. I am very comfortable with ColdFusion, having used it to develop a number of sites with high traffic and large databases where uptime is crucial and downtime is expensive.

I also have some experience with Java. I am not a seasoned Java developer to the extent that I am in ColdFusion, but I have written a number of smaller (yet still important!) pieces of code in Java that are in production use. My real-world Java experience has been mostly in writing connectors for secure web services to update data, and this sort of project. I have also done a lot of work with Perl, although it has been several years at this point.

Databases

I have a wide range of experience developing well-architected, fully relational databases using MS SQL Server, MySQL, Sybase, and Oracle (up to v.9). My database designs have successfully run sites serving tens of thousands of hits per day and millions of dollars of revenue per year. I've been developing databases since 1997 and have a very strong grasp on relational database concepts, as well as how to scale a database from its maybe humble beginnings to projected future needs.

My databases are properly built, and designed with future extensibility, data integrity and security in mind.

E-Commerce

Whether you need small bug fixes or an entire site selling millions of products, I have probably done something similar before and can do it for you. I have built and worked on more e-commerce sites than I could remember, building back-end administrative tools, hooking up supplier inventory to web sites, setting up automatic shipping calculations with UPS' and Fedex's online systems, credit card processing, powerful and intuitive search/find functionality through literally millions of items, and so on. If you need it done, chances are I've done it already. Additionally, you can rely on my experience to help you find ways of doing things that you might not have considered or even thought possible.

Technical Strategic Planning

Do you know you're not where you want to be with your online strategy, but you're not sure how to get there? Maybe you don't even know where "there" is? I can help you understand your options, and define a strategy for building your business by taking advantage of those options. I can take the headache and stress away from this process, letting you focus on other aspects of your business.

Project Management

Maybe you know where you want to be, but don't have the time, expertise or personnel to get there. I have experience with assembling team members, bringing a team together, assigning and managing tasks, and getting projects done on time and under budget. I have experience working with people in person and remotely. There are many important aspects to successful project management, but having all parties having a clear understanding of the requirements and constraints ahead of time is crucial. I believe strongly in the team communicating progress regularly, and working as a team to achieve the project goals.

Site Architecture

Site and database architecture is important for a successful internet site as a good foundation and solid engineering are for a building. Spending time up front designing the underlying databases, programs, and hardware based upon current needs and projected usage will pay for it many times over. I have successfully built sites that scaled from a startup idea to millions of dollars per year in sales without needing a system redesign.