Create a brand-new platform from the ground up, aimed at facilitating the sharing of information among users with various backgrounds, focusing on diverse aspects of chemistry compounds such as plants, their applications, suppliers, concentrations, clinical trials, and more.

The initial release is scheduled for three months from now, followed by ongoing development featuring an array of additional features that will continue until the conclusion of 2023.

This is a 4 different applications joined, I was in charge to add new features to the pre-existing applications and to be responsable of their maintanance and security patches

The goal is to modify the existing application created in an ad-hoc/non-opensource framework created from a 3th party, in order to include a backup schedule options (control, monitoring and restore).

Inside an existing Pipelines created years ago, the client look for an improvement in terms of flexibility and adaptation of their pipelines in order to develop quickly any kind of transformation and ingestion to a database. In this project the algorithms were substituted for an ad-hoc python library that helps to define how to extract semantically information from complex excel files without to define the coordinates of the data, making the process robust in front of addition or substitution of some rows/columns or nomenclatures.

Web Application installed inside the Private Cloud Network of the client to manage their inventory of flavors for laboratories. It has special features like: printing and reading barcode labels from the app, and as well it has the capability to update automatically the quantity of substances used by their balances through MQTT messages or REST Services.

As an Architect, define the whole solution in order to capture data from sensors, calculating new data based on the generated data as streams, and send all data ( raw data and calculated) to the database in real time. It includes a Dashboard visualization based in Grafana in order to offer real time monitoring.

Define and refactorize an existing capture sensor application in .NET, in order to send the data directly to a time-series database (influxdb) in real time.

Inventory Management system for an special laboratory, it has features like uploading data from existing Excel files, reporting, labeling, statistics, etc.

A Validated Application ( GLP ) that control all the inventory and storages from Climatic Chambers, it can monitor the current status of all storages to help users to organize and view how empty are they chambers according to their demands.

A desktop client application that control and visualize data from an aerosol sensor for NH3, and Water.

As well, it contains a module to generate new data in real-time from the signals based in some algorithms delivered from the client.

A command line application that can be scheduled a backup from a database (exporting the data as database agnostic in a tabular format), compressed and uploaded into a AWS S3 bucket.

The same application is used to be able to get the data back into another database from the data stored in AWS S3.

This was useful in some special cases when replication between databases are not possible, changes on the schema must be controlled, and trust between partners can not be established.

Currently, it's used to catch sensor data from external partners every day.

Define and Implement different ETL systems.

Ingest and process data in batch mode every 24 hours from different sources and generating new data output into another database.

For reporting, the client is using MS PowerBI in the cloud and desktop mode in order to visualize all the raw and aggregated data.

As well, I defined the whole CD/CI system in place to manage and update their system in the most automated way.

Development of the required Firmware (based in Arduino) and the Main Controller Application (based in Qt/C++) to manage MicroFluid Pumping device connected by Bluetooth.

Wikipedia Style Platform that centralizes the knowledge search, combining information from different structured and semi-structured resources, and from private (internal) and public databases. All without the use of synchronization or replication of the data, based in microservices and an asynchronous model allows all users to have a full overview about the Entity of the data in search.

A platform that combines inventory, workflows, notifications,
documentation and reporting for biological assays in
laboratories. Like a Electronic Laboratory Notebook system, but it was non GLP certified.

Adaptation and transformation of a pre-existing application based in Groovy and Grails, including the usage of microservices and adapting frontend and backend to new requirements.

Created from scratch and Based on Neo4j (NoSQL-Graph-Database) , OSGi Architecture, Node.js and AngularJS + D3js technologies. It’s a core application that integrates all information data from internal and external resources in order to be used from different areas on PMI/R& generating business reports or analyzing the compounds from different products.

Create a platform based in a distributed architecture that allows to parellelize and orchestrate different types of computing work for chemistry exploratory investigation (for High-Throughput Identification of Small Molecules by Two-Dimensional Gas Chromatography Coupled to Mass Spectrometry).

Frontend was based in a pre-existing Oracle APEX interface.