César Sanz
Automation and Industrial Engineer
Who am I?
Hello! I'm César Sanz, a passionate Industrial and Automation Engineer specializing in full-stack development, IoT solutions, and industrial applications. Based in Madrid, Spain, I bring 9 years of hands-on experience crafting solutions across industrial automation and complex software systems.
My journey began in the industrial sector, where I developed automation solutions for the food and beverage industry. Fascinated by the wealth of data generated in these complex environments, I naturally evolved into developing analytical tools and optimization solutions. This industrial background, combined with my passion for technology, led me to expand my expertise into web development and IoT, creating innovative solutions that bridge the gap between industrial systems and modern technology.
Beyond the world of code and automation, I'm an avid cyclist who finds inspiration while exploring on two wheels. I thrive on continuous learning and am always excited to collaborate on projects that push technological boundaries and create meaningful impact.
My Projects
Components Finder
Web app to find and manage electronic components stored in several cabinets
Fullstack web application that allows to find, add, remove and manage the electronic components stored in several cabinets. It provides a way to search for components by name, type, value, etc.
Wind Garmin Field
Wind data field for Garmin cycling computers
Widget that shows the perceived wind speed and direction in real-time on Garmin cycling computers. It uses several weather providers to retrieve the wind data from the closest stations and the Garmin Connect IQ SDK to display it on the device.
LlamaTracker
Android APP that tracks your location prioritizing battery life
This app was created to track all the places I visited during a trip to Peru. It's an Android APP that records the location of your phone every 15 minutes and uploads it to a server. It focuses on retrieving the location in the most efficient way, using the latest Android APIs and best practices to save battery life.
GourmetGuide
Telegram bot that helps you pick the best dishes in a restaurant
This bot was created to help you decide what to order in a restaurant. The user first sends the Google Maps link of the restaurant to the bot using Telegram, then it scrapes Google Maps to fetch user reviews in several languages, then using a LLM (GPT 4) it responds to the user with recommendations.
Mercadona Tickets
Web app to analyze purchases in Mercadona
Fullstack web application to analyze the purchases made in Mercadona. It allows you to upload your digital tickets in PDF and then it provides information about the average monthly expense, the most bought products, the evolution of prices, etc.
BiciMAD Tracking
Monitor realtime BiciMAD usage and statistics
Monitoring app using Grafana as a frontend and InfluxDB as a database. It retrieves the data from the BiciMAD public and hidden APIs. It provides a way to see the bikes and docks availability in real-time, and also provides a way to see the usage statistics and the downtimes of the service.
OPC UA Historian
Complete data historization tool
It allows you to connect to any OPC UA server, explore the data available, configure how it's going to be saved and visualize the recorded data with a powerful interface. It provides a web client to configure the platform, everything can be done using an easy interface, additionally it also provides a way to import/export the configuration in CSV. The data is stored in an optimized database for this use case, InfluxDB. Although the web client provides a light way data visualization tool, Grafana is integrated with the project, through a custom datasource plugin, and it allows a highly customizable data analysis. It has been built with Docker to provide a fast deployment. It doesn't have big computing requirements; it can even run in a Raspberry Pi.
Chronos
Time tracker desktop app build with Vue/Electron.
Simple app to track the time spent in the proyects I'm working with.
eMeter
Realtime energy meter
Android app that shows in realtime the electric power consumed in your house. It retrieves the data from the electricity provider meter. Only works for Iberdrola Distribución in Spain
OkMyKey
Macro keyboard
A programmable macro keyboard that enhances workflow by providing quick access to your most-used shortcuts and text.
IotCloud
IoT platform
Open-source home automation platform that allows you to control, program and historize data from devices like lights, RGB leds strips, doors, blinds, thermostats... It also provides Google Home integration. Any device based on the ESP8266 can run the IotCloud firmware. A custom PCB has been developed to upgrade regular devices to smart ones easily