Scroll To View More
Andreas "Rayo" Kniep, SQL Developer in San Francisco, CA, United States
Andreas "Rayo" Kniep

SQL Developer in San Francisco, CA, United States

Member since March 26, 2015
Andreas is now available for hire
Andreas "Rayo" Kniep, SQL Developer in San Francisco, CA, United States
Andreas "Rayo" Kniep

SQL Developer in San Francisco, CA, United States

Member since March 26, 2015
Rayo has worked in the software industry since 1999, but his passion for writing software began when he started developing computer games at age 13. He has taught Theoretical Computer Science at the Technical University of Berlin before successfully co-founding Linklift, a company in the SEO-space. He is a fullstack developer with back-end focus who loves to implement systems and constantly fine-tune his programming and architectural skills.
Andreas is now available for hire

Portfolio

  • Startup Compass
    Ruby, Sinatra, Rails, AngularJS, Rabbit, PostgreSQL, MongoDB, Redis, ResQ...
  • Quan Digital
    LAMP (with MySQL and PHP, Zend), Bash, Lucene, Solr, Java, HBase, Hadoop
  • Linklift
    LAMP (with MySQL and PHP), WordPress, Drupal, Yoomla, Serendipity, other CMS...

Experience

  • SQL, 10 years
  • Regular Expressions, 7 years
  • HTTP, 7 years
  • Bash Script, 5 years
  • Ruby, 2 years
  • Chef, 2 years
  • PostgreSQL, 2 years
  • Sinatra, 1 year
San Francisco, CA, United States

Availability

Part-time

Preferred Environment

Git (or SVN), RubyMine, MacBook

The most amazing...

...thing I've built was an automated data-collection & webscraping infrastructure (in-house server farm, 20+ VDSL-lines, sharded MySQL-setup, 6 HBase clusters).

Employment

  • CTO

    2013 - PRESENT
    Startup Compass
    • Led a team of 4 developers and 2 data-scientists.
    • Designed and developed a software hub to automatically collect data from a wide range of data APIs (e.g., Square, Google Analytics, Paypal, Freshbooks, Xero, Highrise).
    • Introduced server provisioning for AWS OpsWorks with Chef and Berkshelf.
    • Built and administered micro-service infrastructure with independent modules, message queues, and scheduler.
    • Introduced Continuous Integration with Jenkins.
    Technologies: Ruby, Sinatra, Rails, AngularJS, Rabbit, PostgreSQL, MongoDB, Redis, ResQ, AWS OpsWorks, Chef, Berkshelf, Jenkins, RSpec, Logentries, StatsD, Mixpanel
  • CTO

    2012 - 2013
    Quan Digital
    • Managed MySQL-databases with billions of entries (containing qualitative SEM/SEO keyword-lists in 6 languages).
    • Designed and oversaw multiple Hadoop/HBase clusters (3-4 nodes) collecting half a billion new data points per week and running Map/Reduce analyses (containing qualitative search engine visibility data for 6 countries).
    • Realized fast data search with HBase data dumps and Lucene indexes.
    • Led a team of 10+ developers and product manager.
    • Designed and realized product Rankpanel, an open search-visibility analytics tool.
    Technologies: LAMP (with MySQL and PHP, Zend), Bash, Lucene, Solr, Java, HBase, Hadoop
  • CTO

    2006 - 2012
    Linklift
    • Grew company to 60+ employees, 5,000+ webmasters (customers), 4+ million € annual turnover, and profitability.
    • Designed and developed the software back-end of the Linklift technology platform, a software setup which dealt with half a billion data-points per week (LAMP stack with automated payment-system and API for CMS-plugins).
    • Designed, set up, and administrated a webscraping infrastructure, including in-house server-farm and 20+ controllable VDSL-lines with service-API (libraries in PHP and Java), web front-end, and centralized task management.
    • Introduced internationalization for 6 languages and 4 currencies (using i.a. gettext, po/mo).
    • Led a team of 10+ developers and product manager.
    Technologies: LAMP (with MySQL and PHP), WordPress, Drupal, Yoomla, Serendipity, other CMS, Perl, Bash, po/mo i18n
  • PhD Student with Lectureship

    2005 - 2006
    Technical University of Berlin
    • Organized university courses.
    • Lectured 300+ undergraduate students.
    • Conducted written and oral exams.
    • Led a team of 15 tutors, creating seminars and weekly exercises.
    • Researched in modeling object-oriented systems by transformation-systems.
    Technologies: transformation systems, algebraic mathematics, OO modeling, algorithms

Experience

  • Compass Benchmarking (Development)
    https://www.compass.co/

    Compass is a benchmarking tool currently focusing on Google Analytics and payment services such as Stripe or PayPal, that helps decision makers (e.g., CEOs) to bring business data together in an actionable dashboard.

  • Compass Monitor (Development)

    Compass Monitor is a portfolio tracking tool for consultants, advisers, and investors. Directly monitor progress via automatic data connections to your portfolio companies.

  • Linklift (Development)

    Linklift reaches out to bloggers, independent journalists, and webmasters in general. Together with its online marketing agency Quan Digital, it creates a partnership between content creators and advertisers with focused text-link marketing.

  • 2048 with Stats and Sounds (Development)
    http://andirayo.github.io/2048stats/

    Simple JavaScript game spiced up with live statistics and sounds

Skills

  • Languages

    PHP, Ruby, SQL, Bash Script, Bash, JavaScript, Java
  • Tools

    Google Analytics, Subversion (SVN), Trac, RubyMine, Chef, Git, RabbitMQ, Jira, RSpec, CVS, Turbo Pascal, Solr
  • Storage

    MySQL, Memcached, Redis, MongoDB, PostgreSQL, AWS S3, HBase
  • Other

    Scraping, Regular Expressions, Algorithms, Data Structures, HTTP, RHEL, Ubuntu Server
  • Frameworks

    OAuth 2, Zend Framework, Linux OpenSuSe, Hadoop, AngularJS, Sinatra, Ruby on Rails (RoR)
  • Libraries/APIs

    Apache Lucene, Resque, jQuery
  • Paradigms

    Functional Programming, REST, SOLID Principles, Microservices
  • Platforms

    AWS EC2, Linux, WordPress, Drupal, Joomla

Education

  • Master's degree in Computer Science
    2001 - 2005
    Technical University of Berlin - Berlin
I really like this profile
Share it with others