Cristhian is available for hire

Cristhian Castelao

Verified Expert in Engineering

Software Developer

Location

Guadalajara, Mexico

Toptal Member Since

April 10, 2017

Cristhian is a seasoned IT consultant with over fifteen years of professional experience. He's a full-stack web developer and business intelligence consultant. He 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.

Full-stack Development Front-end Back-end Web Development Full-stack Software Development JavaScript CSS PHP Drupal 7 API Development REST APIs AngularJS Bootstrap 3+Laravel

Portfolio

Freelance Clients

Laravel, Tailwind CSS, Svelte, MySQL, Drupal, D3.js, HTML, HTML5, CSS, CSS3...

Intel Corporation

Drupal, Git, HTML5, Sass, MySQL, CSS, HTML, Drupal 7, Bootstrap 3+, Windows...

PepsiCo

Visual Basic, Microsoft SQL Server, QlikView, SQL, Business Intelligence (BI)...

Experience

Drupal - 15 years PHP - 15 years JavaScript - 15 years MySQL - 15 years HTML5 - 10 years Laravel - 5 years Tailwind CSS - 2 years Svelte - 2 years

Availability

Part-time

Preferred Environment

Visual Studio Code (VS Code), LAMP, MacOS, Git, Web MVC

The most amazing...

...project I've done is an online/offline web (desktop and mobile) ERP, fully customizable by users who can create their modules and templates.

Work Experience

IT Consultant

2015 - PRESENT

Freelance Clients

Worked from the very ideation to the wireframes and database structure, developed distributed social networks capable of serving concurrent thousands of users.
Designed and created a customizable ERP for multiple businesses.
Created multiple MVPs for clients quickly to be validated with potential customers.

Technologies: Laravel, Tailwind CSS, Svelte, MySQL, Drupal, D3.js, HTML, HTML5, CSS, CSS3, Amazon S3 (AWS S3), Google Maps API, GeoIP, Firebase, AngularJS, Bootstrap, Front-end, Mobile First, React, Back-end, Chart.js, Agile, Figma, Visualization, APIs, TypeScript, Cloud Firestore, eCommerce APIs, SDKs, Integration, Data Scraping, Docker, Docker Compose, Linux, Web Project Management, Product Design, Chrome Extensions, WebSockets, DevOps, Java, RESTful Services, Google Maps, Web Scraping, Project Management, API Development, Mobile Development, REST APIs, Software Development

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 to make it easier to manage the platform.
Built PHP scripts to repair database records and optimize the website's performance.
Researched and repaired broken features by providing quick fixes to keep the website working nicely.

Technologies: Drupal, Git, HTML5, Sass, MySQL, CSS, HTML, Drupal 7, Bootstrap 3+, Windows, jQuery, Full-stack Development, Optimization, Web Development, Full-stack, API Integration, Front-end Development, Bootstrap, Front-end, Mobile First, Python, Back-end, APIs, SDKs, Integration, Linux, Web Project Management, DevOps, RESTful Services, API Development, REST APIs, Software Development

Business Intelligence Consultant

2010 - 2011

PepsiCo

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.
Dove deeply into the data to find and resolve inconsistencies.

Technologies: Visual Basic, Microsoft SQL Server, QlikView, SQL, Business Intelligence (BI), PHP, HTML, JavaScript, Windows, MySQL, Optimization, Data Visualization, Visualization

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 based on business requirements.
Created statistics dashboards with Visual Basic to get relevant KPIs for the client (PepsiCo).

Technologies: Visual Basic, CSS, JavaScript, MySQL, PHP, MooTools, .NET, C#, jQuery, jQuery UI, CSS2, Windows, Full-stack Development, Web Development, Full-stack, Front-end Development, Front-end, Back-end, Visualization, SDKs, Java, Software Development

Experience

At Leisure License

https://atleisurelicense.com/

At Leisure License is an edtech company that provides courses and many licensing tools for contractors in the USA. The website is built on Drupal, and AngularJS, integrated with third-party APIs like Twilio, SendGrid, and AI-powered Google APIs.

Intel Software

I created new modules, changes, improvements, and bug fixes for both the back-end and front-end of the website. Also, mentored less experienced developers. Intel Software is one of the most important websites of the Intel Corporation.

Witches and Cowboys

https://witchesandcowboys.com/

A website and web application for a cleaning service company in Las Vegas, Nevada, USA. The product handles all the communication between the company and the client through a custom email manager and an SMS platform. It generates repeating events based on customer desires and georeferenced routes for the employees.

International Planned Parenthood Federation | Western Hemisphere Region

https://www.ippf.org/

Multi-lingual Drupal 7 website migrated from Drupal 6 with panel integration, custom views, and features for easy content management. I added new features and created a clean theme and documentation for the next developers.

Targeta Rosa

http://ajuntament.barcelona.cat/targetarosa/

Drupal 7 and AngularJS integration with custom benefits search for owners of the "pink card." I created a custom Google Maps with searches tailored for specific segments and implemented the material design on new features to give it a lovely appearance.

Cadastral Modernization Program

A web platform for town halls in Mexico that geolocates and calculates taxes for properties in the whole area. It keeps the municipal data up to date based on approved income laws. Also, it generates cartography with street values.

Campanya Gironès

A web application for the government in Spain that allows employees to gather information in the streets to improve municipal services. I designed and implemented a solution using the technologies desired by the client and created proper documentation for future developers.

At Leisure License

https://atleisurelicense.com

At Leisure License is a web-based platform designed to simplify and expedite the certification and licensing process for contractors. It offers a course list, license management, state compliance assistance, and document storage, all aimed at providing a seamless experience for users.

Ambulancias Privadas

https://ambulanciasprivadas.mx

Efficiently quote and book ambulance services in Guadalajara through our lightning-fast website, built with the modern technologies Svelte and Tailwind CSS, ensuring seamless and rapid access to life-saving assistance.

Skills

Languages

JavaScript, CSS, PHP, HTML, Sass, Less, Java, HTML5, TypeScript, Visual Basic, Python, C#, SQL, CSS2, CSS3

Frameworks

Bootstrap 3+, Yii 2, AngularJS, Laravel, CodeIgniter, Flutter, Bootstrap, Svelte, Tailwind CSS, Twig, .NET, Play Framework

Libraries/APIs

API Development, REST APIs, jQuery, Lodash, Google Maps API, D3.js, Google APIs, Twilio API, Chart.js, Google Maps, MooTools, Facebook API, WordPress API, jQuery UI, React, GeoIP, Google API

Platforms

Drupal, Drupal 7, Linux, QlikView, Windows, MacOS, Twilio, Drupal 8, LAMP, Visual Studio Code (VS Code), WordPress, Amazon Web Services (AWS), Firebase, Docker

Other

Full-stack Development, Front-end, Back-end, Web Development, Full-stack, API Integration, Front-end Development, RESTful Services, Software Development, Angular Bootstrap, Data, APIs, OCR, Optimization, Mobile First, Data Visualization, Visualization, eCommerce APIs, SDKs, Integration, Data Scraping, Web Project Management, Chrome Extensions, Web Scraping, Web MVC, Machine Learning, Web Extensions, Google Analytics 4, Design, Product Design, WebSockets

Tools

Git, Postman, Slack, SendGrid, Sublime Text, Bower, Composer, Trello, Gulp, 3D Studio Max, Adobe Photoshop, Google Analytics, Figma, Docker Compose

Paradigms

Responsive Coding, REST, Agile Software Development, Agile, DevOps, Mobile Development, Business Intelligence (BI)

Storage

MySQL, IndexedDB, MongoDB, Amazon S3 (AWS S3), Microsoft SQL Server, Cloud Firestore

Industry Expertise

Project Management

Education

2003 - 2007

Technologist's Degree in Computer Science

CETI - Guadalajara

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring