Scroll To View More
Cristhian Castelao, Software Developer in Zapopan, Mexico
Cristhian Castelao

Software Developer in Zapopan, Mexico

Member since February 15, 2017
Cristhian is a seasoned IT consultant with over nine years of professional experience. He's a full-stack web developer and business intelligence consultant who has worked for clients including Intel and PepsiCo, and has firsthand entrepreneurial experience in addition to extensive knowledge of a variety of languages, frameworks, and other technologies.
Cristhian is now available for hire



  • MySQL, 9 years
  • PHP, 9 years
  • Drupal 7, 6 years
  • Git, 5 years
  • AngularJS, 5 years
  • Yii 2, 3 years
  • QlikView, 2 years
Zapopan, Mexico



Preferred Environment

MVC, Git, Sublime, MacOS, LAMP

The most amazing...

...thing I've built is an Angular/Yii framework for web apps including a code parser to allow non-developers to write custom rules, similar to Excel macros.


  • Senior Web Developer

    2016 - 2017
    Intel Corporation
    • Created new plugins for WYSIWYG integrating with Drupal modules.
    • Integrated Drupal with Git repositories to keep certain contents up to date.
    • Created custom rules to meet content management workflow needs.
    • Provided guidance for less experienced developers.
    • Created new Drush commands.
    • Created PHP scripts to repair database records.
    • Researched and repaired broken features by providing quick fixes to keep the website working nicely.
    Technologies: Drupal, MySQL, Sass, HTML5, Git
  • Business Intelligence Consultant

    2010 - 2011
    • Created complex data extraction routines for millions of records.
    • Designed and developed executive dashboards for different metrics.
    • Analyzed data structure to provide the best performance results.
    • Deeply dived into data to find and resolve inconsistencies.
    Technologies: Qlikview, MS SQL, Visual Basic
  • Software Developer

    2008 - 2009
    Sistemas Avanzados Integrales
    • Created a booking engine for flights, hotels, and cars with C# .NET using SOAP web services.
    • Developed a CRM platform from scratch in PHP.
    • Created some statistics dashboards with Visual Basic.
    Technologies: C# .NET, Mootools, PHP, MySQL, JavaScript, CSS, Visual Basic


  • International Planned Parenthood Federation/Western Hemisphere Region (Development)

    Multi-lingual Drupal 7 website migrated from Drupal 6 with panel integration, custom views, and features for easy content management.

  • Intel Software (Development)

    Created new plugins and provided fixes for both back-end and front-end. Intel Software is one of the most important websites of Intel Corporation.

  • Targeta Rosa (Development)

    Drupal 7 and AngularJS integration with custom benefits search for owners of the "pink card."

  • UREP Maids (Development)

    Website and web application for a cleaning service company in Las Vegas. Handles all the communication between the company and the client through a custom email manager and a SMS platform. Generates repeating events based on customer desires, also generates routes for the employees.

  • Cadastral Modernization Program (Development)

    Web platform for town halls in Mexico. Geolocates and calculates taxes for properties in the whole area. Keeps municipal data up to date based on approved income laws. Generates cartography with street values.

  • Campanya Gironès (Development)

    Web application for the government in Spain that allows employees to gather information in the streets to improve municipal services.


  • Languages

    PHP, Sass, JavaScript, Less, CSS, HTML5, Python, C#, Java
  • Frameworks

    AngularJS, Bootstrap 3+, Yii 1, Yii 2, CodeIgniter, Play Framework
  • Platforms

    Drupal 7, QlikView, Windows, MacOS, Drupal 6, Linux
  • Libraries/APIs

    jQuery, Lodash, Google Maps API, Facebook API
  • Tools

    Git, Bower, Composer, Trello, Gulp.js, 3D Studio Max, Adobe Photoshop
  • Paradigms

    REST, Agile Software Development
  • Storage

    MySQL, IndexedDB, MongoDB
  • Other

    Angular Bootstrap


  • Technologist's degree in Computer Science
    2003 - 2007
    CETI - Guadalajara
I really like this profile
Share it with others