Bernardo Silva

Enhanced UX by reducing data importing errors by 80% through improved error handling and user-friendly messages using Ruby on Rails. Integrated a fleet management system with a mine planning system, automatically importing over 1,000 rows of data weekly using a Ruby script scheduled via cron on Linux. Enhanced mining operations by eliminating dispatcher time spent on truck-to-scale assignments through an optimization algorithm built with Ruby on Rails and Active Record. Reduced backend deployment time by 75% by creating a fully virtualized test and production environment using VirtualBox and Linux, replicating the entire backend stack (PostgreSQL, Ruby on Rails, Objective-C, SQL Server, OpenVPN) across distributed servers and clients. Created and maintained a Git repository for the Support team, containing more than 50 scripts and documentation.

Improved performance of large reports in Metabase and PostgreSQL by 400% through query optimization, data modeling, and data transformation. Deployed a cloud ETL job processing over 500 rows daily using Python, AWS S3, AWS CLI, Shell, and a cron job. Enabled detection of key business issues by producing five reports weekly using PostgreSQL and Metabase. Created high-performance heatmaps by reducing coordinates load time from hours to seconds, utilizing Kepler.gl and Uber H3 in PostgreSQL.

Built an offline response buffer for survey tablets, increasing response capture by 50% across 5,000 devices using JavaScript and Web Storage API. Refined the tablet UI for over 20 HTML quizzes/surveys to ensure responsiveness. Managed Git repositories for Data and Frontend teams using GitLab.