Sandro Fernandes

A website that allows people to read and listen to biblical and Karaites-related books. The books are generally in English and Hebrew. I enabled a search feature to search for books in both English and Hebrew, and liturgy songs can be played in-app.

Some challenges were enabling full-text search in Hebrew and synchronizing Hebrew audio books with text.
I was the developer from the start to the end of the project. I was involved in the back and front ends, server config, and installation.

Stack: Django, Python, Nginx, PostgreSQL, React, TypeScript

This was an open source project.

Ported a very old back-end for the POS, a Swift application running on an iPad, from Python 2.7 to Python 3.
I collaborated with another engineering team member, and I developed the front-end.
The server resources here are optimized, reducing the monthly bill by 60%.
The dead code was removed.
An improved Django admin was developed so that users add more control.
Updated all stacks for the current version.

Stack used: Django, NGINX, Gunicorn, PostgreSQL, Supervisor

The company sells licenses to companies that use a remote inspection system. It allows users to avoid travel and its associated expenses, optimizes survey time, and facilitates meetings between experts without the need for travel.

The system is composed of proprietary hardware, mainly video cameras, and software that runs in a browser.

Stack: Django, Django REST Framework, SQLite/PostgreSQL, React, Twilio API, Shopify API

This is a Chrome extension to search and suggest shows based on the web pages visited.

Stack: Django for the back end, jQuery and vanilla JavaScript for the front end, PostgreSQL as the relational data, Redis as cache, and Heroku as the hosting provider.

Surveys on drivers from Lyft, Uber, and others. The user uploads a picture of the Lyft app screen to the website, on the background Google Vision API is used to read the text in the screen image. Based on that, some checks are made and some statistics are generated.

To incentivize the drivers to post, a fee is paid for each week that the drivers upload images. To upload, the driver must have an account. Payments are made using a PayPal account.

Stack: Flask, React, MongoDB, Heroku, mLab

Acted as a mentor/developer teaching good practices and overall project development.

Stack: Django, REST Framework, Vue, Vuex, SQLite, Heroku

A project dedicated to supporting high-level discussions about any topic.

The user may participate in debates—all are moderated, and each idea can have pro/con responses. It's a meritocracy based on votes.

Stack: Django, Django REST, PostgreSQL, React

Publish/remove content based on time or other criteria.

Supports automatic content cache, without warm-up, optimization of image sizes and minifying of CSS and JavaScript, or page previews.

The content is organized in a tree shape and can be moved around using drag-and-drop. The pages include authentication, and plugins may be inserted in the pages. Any data model may be related with any other model.

The email system is based on templates and integrated with the CMS. The emails sent can collect data such as clicked links and support many other features.

I will be glad to give you a demonstration!

Web applications to deal with financial data from European insurance companies.

Insurance companies provide balances in PDF format. Those are scanned and translated into Excel spreadsheets. And, after human checking, they are imported into a database. From there, many queries are possible in a web UI.

Redis cache for a Python application controlling thousands of ULDs and airplane flights.

Django REST API to allow clients to get data.

A Django REST framework application to tally surveys in a remote PHP client, using AWS Linux and EC2.

Features that are calculated and displayed in this product include given meanings to words, verb conjugation, sound-a-like words, anagrams, syllable division, and plurals. Also, spelling localization is included for Portuguese of Portugal and Brazil.

Stack: Django, Django REST, NGINX, Node.js, React

Tally served banners and ads.

Controlling campaigns, by client, by time, quantity, and user geolocation. Reports are generated by client, ad campaigns, click rate, etc.

Stack: Python, Django, jQuery, MySQL, Ubuntu, Nginx, DigitalOcean

Control pilots’ flight time, certifications, training, etc., in a single-page app able to work offline, syncing data when an internet connection is available. Desktop, iPad, and cell phone compatible.

The goal of the system is to automatically send a series of newsletters.

The system works based on a timeline around a main event. The timeline may precede and/or succeed the event. Each milestone is associated with an email template and a number of days before or after the main event. On the due date, the email is sent.

The email templates are integrated with user profiles so that message can be personalized.

Stack: Python, Django, jQuery, Cron, Bash, MySQL, Nginx

I ported a Python 2.7 application to Python 3.8. This application collects data from several internet resources using APIs, and all the data is organized in a relational database. The goal was to select candidates for school donations.

Various clients, including universities, paid for this information.