Guilherme Forton Viotti

Portfolio

image of project 'RAG GPT'

RAG GPT

It's ChatGPT on steroids - You upload a document and instantly augment it with your data!
Python AWS OpenAI Machine learning AI CI/CD LLM REST API AWS CDK AWS Lambda AWS S3 Flask

The application is an advanced version of ChatGPT that allows users to upload a document and augment ChatGPT's responses with data from their uploaded file. It is a prototype designed to showcase CI/CD Github actions pipeline, AWS services (CDK, Lambda running Flask, and S3) and the capabilities of Large Language Models (LLM) using the Retrieval-Augmented Generation (RAG) technique. Github: https://github.com/GuiFV/client_base_rag

Visit the platform open_in_new
image of project 'MIP - Mintec Internal Platform'

MIP - Mintec Internal Platform

Web application to manage entire back office
Python Django Bootstrap Material Design PostgresQL RabbitMQ Celery AWS MongoDB DRF Docker docker-compose REST API EC2

This was an exceptionally challenging project, only matched by its great success. A platform to deal with the data, manipulation and export of multiple team assets, such as weather data ingestion from API endpoints, automation with Celery and RabbitMQ, MongoDB data read, CSV/Excel easy exports, SSO integration integrated with the company's Azure Tenant and a Machine Learning integration that helps the sales team quickly compare all time-series of the company with prospects requirements by context similarity.

image of project 'Compan-AI'

Compan-AI

Your AI companion
Python Django Bootstrap AWS Docker Nginx SSL Cloudflare OpenAI Machine learning AI LLM EC2

While dipping my toes in the new and exciting world of AI / Machine Learning / Large Language Models (LLMs), I developed a platform where you can talk to an AI companion (who is primed with a personality) about anything you want. The AI companions know what you were talking about in the past for maximum context and conversational flow. Try it out by clicking below!

Visit the platform open_in_new
image of project 'NFT investment alert system'

NFT investment alert system

Following big money in the Ethereum network
Python Django Heroku

This project was dubbed 'Remora' (fish who swims with sharks and eat small chunks of their prey) with the idea to constantly check for movements of 'sharks' in the NFT market and replicate long or short positions in NFT collections before they would increase or decrease in value. The system sends email alerts every time conditions set by the analyst are met, showing the collections that might become the 'next big thing'.

Etherscan API documentation open_in_new
image of project 'Multiple Djangos, one AWS EC2'

Multiple Djangos, one AWS EC2

Easily deploy multiple applications under Nginx on different domains (using SSL)
Django AWS Docker docker-compose Nginx SSL Cloudflare

By copying one folder and a Dockerfile on your AWS server, you can deploy multiple Django apps on a free EC2 instance, direct your domains to a free Cloudflare account and have them served behind a Nginx load balancer with the power of docker-compose. This is not an automated solution by default, as it is designed to be built upon. Just follow the instructions and use the suggested 'quick Django deploy' image for a highly effective and lighting quick 'develop and deploy' combo.

Go to Github repo open_in_new
image of project 'Django quick deployment'

Django quick deployment

Run one single command and have an operational Django app locally, ready to be worked on
Django Docker docker-compose

This derivative work from a friend allows you to install a Django app in seconds, with git and docker implemented out-of-the-box, ready for you to develop your application. I aggregated the docker-compose component that allows you to deploy on AWS seamlessly among other details. This is my way to give back to the community that helped me so much over the years.

Go to Github repo open_in_new
image of project 'Sci-hive'

Sci-hive

Your scientific content-sharing platform
Python Django Bootstrap AWS Docker docker-compose Nginx SSL Cloudflare CI/CD EC2

This personal project was born from lessons learned on my other sustainability project, IDETRA. The platform allows you to connect data points (posts) to create a storytelling arch with multiple possibilities or assemble them into a network. The references you give for each data point are identified and get a 'sci' tag if they are from a known scientific publisher. The rating mechanism allows the public to score each data point. Uses the Django deployment on AWS featured in this portfolio.

Visit the platform open_in_new
image of project 'Terra Formus'

Terra Formus

Organizing solutions in an actionable way
Python Django Bootstrap AWS Docker docker-compose Nginx SSL Cloudflare CI/CD REST API EC2

This platform allows people to populate solutions and organize them in strategies that are both actionable and scalable. The proposed informational structure allows solutions to be solid and developed by any willing entities.

Visit the platform open_in_new
image of project 'Twitch Rewards'

Twitch Rewards

Rewards club for twitch.tv streamers
Python Django Heroku

Platform developed to give the company a competitive edge over all players in the twitch streamers market. Simply put, collect points the more you watch a company partner streamer on twitch and later exchange your points for prizes. The biggest advantage was give users the possibility to change their usernames on twitch and not lose acquired points on our platform - which in the competitor platform was impossible to do.

Twitch.tv API documentation open_in_new
image of project 'This portfolio'

This portfolio

A web portfolio build from the ground up
Python Django Bootstrap Material Design AWS Docker docker-compose EC2

To showcase what I can do as a software developer, I build the portfolio web platform that you are navigating right now from scratch. From comments to clean code, tests to quick deployment, it's all here. Click on the button below to see the source code on Github.

Source code - Github open_in_new
image of project 'Saluto'

Saluto

A successful project
PMI Agile

I was hired to work on this project when it was already very problematic and starting to show signs of catastrophic failure. In less than a month of me working on it, the client was happy, features were being developed in time and value was delivered every single sprint. The project consisted of three websites, two chat-bots coded from scratch and a platform for health insurance companies to offer their clients a central hub of information. It was an extremely proud for me as a project manager.

Visit platform open_in_new
image of project 'Project Management upgrade'

Project Management upgrade

When spreadsheets work better than Trello
Google Spreadsheets

I had the opportunity to work in Esens, a book summary app that was very successful abroad and was coming to Brazil. The operation consisted in translators (from english to portuguese), people summarising books, voice actors recording the summaries and uploading all this content properly formatted for the app every day. It was handed to me in a Trello/Kanban operation, and making 14 people move cards back and forth in a no-linear workflow was something I knew was not going to work. So I created 3 spreadsheets connected to each other for inputing books, receive summaries, audio sessions and deliver content to the app and marketing. In less than 2 months we were able to deliver more content than expected without losing product quality.

image of project 'App 'Theatre Brazil''

App 'Theatre Brazil'

Award winning entertainment app
PMI Agile

The theatre sector was suffering from a lack of public communication in Rio de Janeiro, and to make things worst, newspapers and magazines were not listing plays on their publications anymore, so I decided to create an app that producers could publicize their plays for free and users could check plays info and even buy tickets on the app. The business model consisted in advertised premium spaces in the app for plays that would pay for such positions. Unfortunately the sector was not mature enough and we eventually had to shut down operations. In the meantime, the most prestigious theatre event in the state awarded us in the Special Category for the app.

image of project 'IDETRA'

IDETRA

Education and project management platform
Python Django Bootstrap AWS Docker docker-compose EC2

This is a personal project of mine. I created this platform to absorb volunteers willing to work on a humanitarian cause. From the start it was a very complex platform that encompass explaining what the initiative is all about, an education platform and a project management system. Completely build from scratch, I coded all the frontend and most of the core backend, eventually needing help to finish some of the more complex functionalities since it was my first Django project.

Visit platform open_in_new
image of project 'Self-sustainable house'

Self-sustainable house

Research on recyclable materials
Recycling

This was a proof of concept for IDETRA as we wanted to show that is possible to gather wasted materials and use them to produce water, food, fertilizer, electric energy, and heat. The only non-recycled components of the project were the solar panels, but it is know that they are being found intact in recycling centres. Check out the videos showcasing the final products on the link below.

Watch playlist open_in_new
image of project 'APTR award voting system'

APTR award voting system

Voting system for theatre award, 100% made with Google Spreadsheets
Google Spreadsheets Google Forms

This is an old client that every year holds a state award for all theater plays in Rio de Janeiro. And every year I run this system for them since 2016. Although I wanted to develop the solution as an application, the client was adamant on using a Google Spreadsheet and this is something I excel at! (pun totally intended). The voting mechanism starts on Google Forms and I validated all the voting rules in one spreadsheet tab. If you have some time, click below and check for yourself the formulas and solutions I developed.

View Spreadsheet open_in_new
image of project 'eBike battery'

eBike battery

Recycling used notebook batteries
Recycling Li-ion 3D design 3D printing

After consulting a dear physicist friend about the intricacies of li-ion cell recycling, I was able to design and build a new battery for my eBike using notebook batteries that were going to waste, a laser cutting table and 3D printed parts. For my surprise this new battery was more efficient and had better charge than the old one, increasing the mileage I could travel and making the bike much faster.

image of project 'Li-on box'

Li-on box

The 3-in-1 bench tool
Recycling 3D design 3D printing Arduino

This project started as a simple way to reroute a PC ATX power source to a modular bench power source. The idea of using an ATX power source was due to them being discarded while working just a little underperformed. Later I decided to insert a li-ion cell tester and charger, with the case being a modified 3D open source model from Thingverse.

Watch video open_in_new
image of project 'Spreadsheet Project Management'

Spreadsheet Project Management

Multiple projects management using only spreadsheets
Google Spreadsheets

I had a couple of days to create a solution to manage multiple projects for multiple clients. The challenges were: I had different teams working in different projects and the clients could not see specific informations we were sending back and forth. To make things more difficult, I had to make sure the clients could not change sensitive material, but any new team member could. In the end I even made the entire platform bilingual (switching everything to english just requires inputing 'en' on cell A1 in the second tab). The template in the link below can be copied and used with minimum setup - change the setup tab information to the key of each spreadsheet when you make a copy of the template and protect them by only allowing admins to view/edit each one. Enjoy!

Template open_in_new