Jose Maria Scarnatto

Project: CRM specifically for Internet Service Providers. The client management system was created using a microservices architecture using Docker together with Vultr cloud services and load balancer PM2. The front-end rendering was server-side using Codeigniter as PHP framework for the core of the application and Node.js for the realtime features with websockets, such as tracking data traffic, number of connected hosts, cronjobs, notifications of highlighted events via telegram bots, etc. Mysql was used as the database engine for, among other things, customer statistics and company accounting. For this we used write and read replicas, periodic remote backups, triggers and best practices in terms of security and performance. Technologies used: NodeJS, Websockets, Iframes, Apis, microservices, PHP, CodeIgniter, MySQL, Docker, Telegram Bots, Mikronode, PM2.

Plant efficiency review online : This real-time dashboard with complex performance indicators was realized without the help of frameworks. Only PHP and the Jquery library were used to handle DOM and asynchronous calls. Mysql was used for statistical purposes using data coming from various engines such as OPC servers, Ihistorian, Excel sheets (VBA) and a small crawler created in VB6 to collect wheater data in the absence of apis at that time

Plant Modeling : This real-time dashboard with complex performance indicators was realized without the help of frameworks. Only PHP and the Jquery library were used to handle DOM and asynchronous calls. Mysql was used for statistical purposes using data coming from various engines such as OPC servers, Ihistorian, Excel sheets (VBA) and a small crawler created in VB6 to collect wheater data in the absence of apis at that time.

CMS for industrial documents and reports : This project was made from scratch using pure html, css, javascript and php. Mysql as database engine.