Andrew Johnson

  • Lead Web Architect / Server Administrator
  • Dayton, OH
  • Member Since Mar 22, 2023

Candidates About

 

Andrew Johnson

 

PROFILE

 

Case Studies

 

  • See the AMS Construction Parts and ConnXus case studies for a real world look at how I’ve helped startups and small companies grow and flourish through technology and marketing.

 

Professional Qualities

 

  • Self starter with excellent ability to learn new technologies, work in a team or independently.
  • Extensive experience being responsible for all aspects of technology and marketing for small businesses (internet, computer network, printers, end user computers, disaster recovery/backups, phone systems, databases, public websites, in-house websites and apps, online marketing etc).
  • Experience as interface to business owners/leadership, working for an agency, managing projects and small teams and the SDLC in general.
  • Ability to plan and complete large scale projects single-handedly or in a team.

 

Technical Skills

 

  • Mac, Windows 2000, XP, Vista, 7, 8, 10, CentOS, Ubuntu, Debian, Gentoo Linux.
  • Strong understanding of LAMP web server installation/management.
  • Adobe Photoshop and Flash, Microsoft Office, OpenOffice and LibreOffice.
  • Graphic/web design (websites, online/magazine ads, newsletters, magnets, t-shirts, business cards).
  • HTML 4/5, XHTML, CSS 2/3, Responsive/Mobile Design, XML, RSS, JavaScript, JSON, Ajax, jQuery.
  • PHP, SQL, Apache, SSH, NFS, FTP, IPTABLES, Suhosin, Memcached, eAccelorator, GD, ImageMagick etc.
  • Magento eCommerce platform (frontend and backend) and some OpenCart experience.
  • Strong understanding of MVC Design Pattern and Object Oriented programming.
  • Zend Framework and some Laravel experience.
  • Frontend optimization (CSS sprites, deferred JavaScript, HTTP headers/caching).
  • Backend optimization (Apache/MySQL config, SQL queries/testing, some Memcached).
  • Git/Github, Beanstalk, Sifter, Basecamp, WorkFlow, Google Apps, AdWords, Bing Ads, iContact, Constant Contact and many others.
  • Networking fundamentals / CCNA level Cisco router and switch programming.
  • 8x8 VoIP phone system installation and management.
  • QuickBooks server and client management.

 

Accomplishments, Awards and Patents

 

  • Developed 3 fully custom public facing websites integrated into a custom in-house CMS/CRM/marketing tracking system for AMS Construction Parts. The sales team uses the backend system for lead processing, customer management, machine and part information, inventory and much more.
  • Created sophisticated AdWords campaigns integrated into AMS’ public websites/backend CMS/CRM that increased leads from 700 per month to over 6,000 per month.
  • Developed ConnXus v4 Supplier Diversity Portal.
  • Developed TierTracker (named inventor on patent), a Diversity Spend tool used by fortune 500 companies.
  • Received the MAX Award while employed at ConnXus for the development and launch of ConnXus v4.
  • Developed the ITNewb social network, powered by a custom built MVC-based PHP framework.
  • Authored a popular article on two-way encryption with PHP and Mcrypt.
  • Authored a CSS sprites article included in SmashingMagazine's The Mystery Of CSS Sprites.
  • Let’s not forget the “Biggest Coffee Consumer” Dundee award I received from AMS at a company outing or the “Best Dressed” nod at a company dinner with Look-Listen.
  • Patent (inventor): Multi-Tier Diversity Spend Tracking and Reporting (US 61706386).

EXPERIENCE                                                                                                                                              PAGE 2

 

Designer, Developer, Marketer                                                                                              November 2017 – Present

Freelance / Self Employed                                                                                                                                         hireandrew.info

 

I provide various web design, development and marketing services as a sole-proprietor to businesses and individuals. I am currently in the final stages of a website/marketing project for Qualifire Protection Services, Inc.

 

Director of Technology                                                                                                     September 2014 – November 2017

AMS Construction Parts                                                                                                                          amsconstructionparts.com

 

As the Director of Technology my responsibilities included:

 

  • Interfacing directly with the owner on all aspects of technology and marketing.
  • Providing guidance on all aspects of technology down to the office network/server/security/VoIP phone system and disaster recovery.
  • Planning, designing and building new web applications and features.
  • Writing and managing all client/server-side code (HTML 5, CSS 3, jQuery, SQL, PHP, Bash).
  • Writing client-side code that is responsive on all touch points.
  • Writing object-oriented server-side code in Zend Framework (MVC).
  • Utilizing Git and Beanstalk to manage development/production code and deployments.
  • Managing an Ubuntu Linux / LAMP droplet on Digital Ocean.
  • Managing domain names and company email.
  • Creating monthly newsletters, mailers and magazine advertisements.
  • Managing social media accounts (Facebook, Twitter, Google Plus, LinkedIn etc.).
  • Creating and improving Google AdWords advertising campaigns.
  • Tracking and improving organic search (SEO) placement and traffic growth.
  • Locating, hiring and managing other tech/marketing companies as needed.
  • Troubleshooting technical problems that arise on employee computers/email.

 

Magento eCommerce Developer                                                                                                      March 2014 – June 2014

Look-Listen                                                                                                                                                                     look-listen.com

 

During my stay in Atlanta, GA, I worked for Look-Listen primarily as a Magento/PHP backend developer but also gained experience themeing the platform.  I worked on sites such as Alternative Apparel, Vintage Green Jewelry, Kaldi Coffee, The SparkRun, BRIM and Bella Housewares.

 

Lead Web Architect / Server Administrator                                                                               March 2012 – August 2013

ConnXus, Inc.                                                                                                                                                                     connxus.com

 

Led development efforts of connxus.com. Accomplishments include: 1) installing, deploying and managing three Linux web/database servers; 2) designing and programming ConnXus version 4 (frontend/backend/database); and 3) designing and programming TierTracker, a Tier 2 diversity spend tracking and reporting tool used by fortune 500 companies. Received the MAX Award for hard work and dedication after launching ConnXus v4.

 

Founder                                                                                                                                                             2007 – March 2012

ITNewbie, Inc.                                                                                                                                                                      itnewb.com

 

ITNewb is a decommissioned social network that revolved around teaching, learning and socializing about technology and generated revenue through online advertising. As the founder of ITNewb, my responsibilities included developing and managing every aspect of the website and many aspects of the business (accounting/s-corp record keeping etc.).

 

Work performed included installing, configuring, deploying and managing 3 Gentoo Linux production servers (web app, file and database); managing an online community of writers and users; writing technical articles; and developing a PHP MVCR framework from scratch to power the website.

 

 

 

EXPERIENCE (continued)                                                                                                                        PAGE 3

 

Additional Experience

 

  • Quali-Fire Protection Services, Inc.                                                                                  Custom website / AdWords
  • Ackermann Construction                                                                                                                            Custom website
  • Scentsible Scents, Ltd.                                                                                                                         eCommerce website
  • Beavercreek Dermatology, LLC.                                                                                                                 Custom website
  • Artifex Finishing Solutions, Inc.                                                                                                           Wordpress website
  • Wright Management Company                                                                                                                 Custom website
  • Rocky Ground Ranch                                                                                                                                   Custom website
  • Gamesloth, Inc.                                                                                                                                                Programming
  • Traffic Power, Inc.                                                                                                                                               SEO services
  • Menlo Worldwide, Inc.                                                                                                                   Adobe Flash animation

 

EDUCATION

 

Sinclair Community College                                                                                                                            Dayton, OH (2005)

Network Engineering Associate-STC

 

Designed to prepare students to become a Cisco Certified Networking Associate (CCNA), this Network Engineering Associate Certificate program consisted of 28 credit hours, 48 written exams and 4 practical exams.

 

RECOMMENDATIONS AND REFERENCES

 

Recommendations viewable at https://www.linkedin.com/in/hireandrewjohnson

 

Daniel Million                                                                                                                                               AMS Construction Parts

Andrew has been a great asset to us at AMS. What sets him apart professionally is the quality of work he produces over many platforms. Typically, it’s difficult to find someone who excels in one skill set where Andrew really is elite in many fields. There have also been many tasks we have asked him to take on that he wasn't overly familiar with, but he has taken them on as a challenge. On a personal level he gets along well with everyone and helps to gel the AMS team together as he brings a positive/fun demeanor to work. We are glad to have Andrew on our team!

 

Andrew Stacy                                                                                                                                                                           ConnXus

Andrew is an outstanding back-end web developer and highly proficient at learning and implementing new technologies. He is a very good fit for any team looking to hire someone who is passionate about what they do.

 

Danita Enouen                                                                                                                                                                         ConnXus

Andrew is a dedicated employee who is detail oriented and always focuses on excellence. His drive for producing a superb end product ensures clients receive a quality product. Andrew always shares additional ideas and perspectives on how to accomplish an award-winning product.

 

Michael Harper                                                                                                                                                                   Look-Listen

Andrew is a bright web developer that takes a creative approach to solving daily problems. He is quick to learn a new skill and one of the more passionate developers I've had the opportunity of working with. A real go-getter and destined for greatness!

 

Sunita                                                                                                                                                                                    Look-Listen

Andrew is a very encouraging and friendly person to work with! Always very enthusiastic about what he does and passionate about getting ahead!

 

Ed Baxter                                                                                                                                                                               Web Client

Andrew is an extremely talented and friendly developer capable of building well-structured and efficient sites to satisfy small and large projects. I'd highly recommend working with him.