Gabriel Webler

At OLX, we optimized software licensing and enhanced collaboration by strategically migrating s to Google Workspace. Faced with underutilized Microsoft Office 365 licenses (514 business and enterprise), we capitalized on OLX's existing Google Workspace environment and robust security.

Starting May 2024, we streamlined our outreach process by developing a Python script to automate the sending of Slack invitations to employees. These messages prompted them to complete a Google Form… Mostrar más

At OLX, we optimized software licensing and enhanced collaboration by strategically migrating s to Google Workspace. Faced with underutilized Microsoft Office 365 licenses (514 business and enterprise), we capitalized on OLX's existing Google Workspace environment and robust security.

Starting May 2024, we streamlined our outreach process by developing a Python script to automate the sending of Slack invitations to employees. These messages prompted them to complete a Google Form (developed by our Google partner, Gentrop) detailing their software needs. The script also managed the bi-weekly reminders, escalating to managers after four unanswered prompts.

Based on responses, we initiated brief Slack follow-ups. s with standard needs had their Office 365 licenses removed and received Google Workspace training resources. Technical s received personalized 15-minute Google Meet consultations. I focused on creating a collaborative environment, leveraging my MS Office expertise to assess needs and guide s through Google Workspace's features, including Google Drive. Even s retaining their licenses received Google Drive resources and training, with an emphasis on potential future license adjustments.

Prioritizing Finance and the Board of Directors, the project (running until November 2024) resulted in ~290 completed forms, ~220 Google Meets, and numerous Slack conversations. A data-driven approach was central to our success. I leveraged Google Looker Studio to create weekly reports for my managers, visualizing our progress and providing actionable insights into the migration process. We transitioned s to appropriate license tiers, reducing our total to 224 and saving ~$150,000 annually.

A streamlined ServiceNow process now manages new license requests, ensuring ongoing cost optimization. Mostrar menos

DiversiBot is an JavaScript application created by Augusto Pinheiro, is designed to be deployed in a Slack channel. Once added, it monitors message events and analyzes the content. If a term listed in a designated Google Spreadsheet is detected, the bot discreetly sends a notification only to the sender. This notification explains the term's meaning and suggests alternatives. The list in our spreadsheet is regularly updated by the company's affinity groups (LGBTQIAPN+, people with… Mostrar más

DiversiBot is an JavaScript application created by Augusto Pinheiro, is designed to be deployed in a Slack channel. Once added, it monitors message events and analyzes the content. If a term listed in a designated Google Spreadsheet is detected, the bot discreetly sends a notification only to the sender. This notification explains the term's meaning and suggests alternatives. The list in our spreadsheet is regularly updated by the company's affinity groups (LGBTQIAPN+, people with disabilities, Black people, and more). After successful deployment, we identified an opportunity to improve the code. We implemented functionality to capture the used term and the channel where it was sent. This data is stored in Google BigQuery, which feeds a Google Looker dashboard for visualization.

Farejador de Novos Canais Públicos (New Public Channel Sniffer) is a Python application acts as a listener, specifically focusing on the Slack channel_created event (signifying the creation of a public channel). Upon detecting such an event, the DiversiBot automatically s the newly created channel.

Both applications are containerized using Docker for streamlined deployment and management. Mostrar menos

We migrate the Windows Server Hyper-V in the SP HQ datacenter infrastructure to a single Ubuntu Server with container orchestration. This shift to containerized architecture using containerization technology facilitated the management of critical services (Zabbix proxy, NTP, Syslog, and camera FTP). The resulting infrastructure consolidation significantly reduced costs and established a scalable foundation for future service deployments.

The Service Desk team needed to all active corporate mobile numbers using WhatsApp and log the numbers using the app or not. I developed a Python bot to check the list of phone numbers and send a preset message to them. Every action was logged and could be checked in the end.

The teams involved needed to extract test data from the new CSAT platform. However, the available automations didn't work for us due to our database requirements and the quality of the extracted files. As a result, we decided to extract the data using their API and Python.

Every day, the code extracts a JSON file for every survey, removes unnecessary information, generates a PARQUET file, s it to an S3, sends a message to the relevant Slack channels with a quick summary of which… Mostrar más

The teams involved needed to extract test data from the new CSAT platform. However, the available automations didn't work for us due to our database requirements and the quality of the extracted files. As a result, we decided to extract the data using their API and Python.

Every day, the code extracts a JSON file for every survey, removes unnecessary information, generates a PARQUET file, s it to an S3, sends a message to the relevant Slack channels with a quick summary of which files failed and were successfully ed, and then imports the data into our main database. Later, the data is analyzed, imported, and displayed on a Tableau Server.

The development project was included as one of the main goals, and when the development was finished, the CSAT entered the company's profit share Mostrar menos

Two automations were developed to the creation process and the email sent with the new employees' information in the SmartRecruiter portal:

- creation:
A Google Form is used to fill in the new employee's info, and a Google Apps Script creates the in the SmartRecruiter using API.

- New issions Page:
The Human Resources team needed to send emails with the new employee's info filled in the SmartRecruiter portal. A Google Spreadsheet was used before… Mostrar más

Two automations were developed to the creation process and the email sent with the new employees' information in the SmartRecruiter portal:

- creation:
A Google Form is used to fill in the new employee's info, and a Google Apps Script creates the in the SmartRecruiter using API.

- New issions Page:
The Human Resources team needed to send emails with the new employee's info filled in the SmartRecruiter portal. A Google Spreadsheet was used before, but it was too outdated. Due to this situation, I developed a website that uses API to get the required information, build the email, and send it to the responsible teams. This website is only accessible on the company's intranet. Mostrar menos

After the storage units were deployed, it was necessary to create a folder structure to the different departments. Due to constant changes in the structure and permissions, I developed a script in Windows Batch to create these structures. It was ed by basic documentation for usage and modification if necessary.

Three years later, the script was migrated to PowerShell due to the more complex environment, and the documentation was updated with more details age and… Mostrar más

After the storage units were deployed, it was necessary to create a folder structure to the different departments. Due to constant changes in the structure and permissions, I developed a script in Windows Batch to create these structures. It was ed by basic documentation for usage and modification if necessary.

Three years later, the script was migrated to PowerShell due to the more complex environment, and the documentation was updated with more details age and troubleshooting common and simple problems.

Even after changing teams and jobs, I was still asked to help troubleshoot problems with their new deployments and PowerShell errors. Mostrar menos

Cisco UCS infraestructure and Software Defined-Storage ScaleIO

A complete migration from the mixed workflow using tape and files to a full file-based workflow was performed. A new network was developed to this, including storage and servers. Network subnets were changed, two new domains were implemented and adjusted to every scenario, and an old domain was renewed to receive the new features.

Storages were configured to seamlessly share media between Windows and Linux workstations, using a custom set of folders and permissions for every TV… Mostrar más

A complete migration from the mixed workflow using tape and files to a full file-based workflow was performed. A new network was developed to this, including storage and servers. Network subnets were changed, two new domains were implemented and adjusted to every scenario, and an old domain was renewed to receive the new features.

Storages were configured to seamlessly share media between Windows and Linux workstations, using a custom set of folders and permissions for every TV show. Monitoring was detailed and customized for the included applications and servers. Mostrar menos

SolarWinds Orion system istration and maintenance were performed. Dashboards, profiles, alerts, and specific monitoring for network subnets, network devices, servers, applications, and broadcast devices were created. This includes Windows Servers, Linux Servers, and storages from Dell/EMC (EqualLogic, Compellent, and Isilon) and AVID (ISIS), watching health and available shared space.