Thiago Pinto's Portfolio

About Me

Experienced professional in the financial sector, working for 20 years at Banco do Brasil, having worked in business, support, and strategic areas.

In the 2000s, before BB, he graduated as a Webmaster and participated in website creation and maintenance projects. In his career, he has always sought to associate his technical knowledge with the company's strategy and the objectives of his unit.

For the past 5 years, he has resumed studies in areas related to Data Science and Analysis, aiming to bring qualified business information to support decision-making through interactive dashboards developed on platforms such as Power BI, and more recently using the Python programming language.

This language is the basis for his main delivered applications involving extraction, processing, and loading of data from DBMSs such as DB2, MySQL, Postgres, and SQL Server; in addition to process automations, previously done manually, bringing greater reliability, agility, and minimizing the risk of human error.

As a cloud computing enthusiast, he has been exploring the capabilities of AWS, Microsoft Azure, and Databricks services.

My Portfolio

GOB Data - Flask App

Web application running on Flask/Python, charts using Plotly, and frontend in HTML/Javascript/CSS (Bootstrap).

The app presents business indicators of the company Game of Boards, with filters by date, product, and payment method.

Loyalty Plan management tools with API integration to Pag Seguro.

Customer relationship management page presenting registration data, consumption history, and recommended products according to the profile (machine learning).

GOB Data - Power BI

Current version of the company's first dashboard, which receives permanent automatic updates through a gateway configured to the database. In addition to direct data, measures were created using DAX for better utilization.

The referred dashboard presents many filtering options such as: by date (year, quarter, month, weekday or weekend); by product type (category, subcategory) and by payment method. In addition to special cuts to better identify customer profiles, in order to provide subsidies for targeted strategies.

TinyERP - Update DB via API

Project updates Database, in this case Postgresql, through daily cronjobs written in Python that capture data from an online ERP (tiny.com.br) through requests to its API, correcting service limitations, processing and updating the data.

In addition to the chosen programming language, the request tests were done using Postman.

GOB Data - Streamlit Version

Decision support page containing the business data of the company Game of Boards, built purely in the Python language using the libraries:

streamlit => to generate the visual content

plotly express => for the charts

pandas => for reading the database through SQL queries and post-processing (ETL)

psycopg2 => for connecting to the database hosted on an AWS EC2

GOB Data - Streamlit Version

Decision support page containing the business data of the company Game of Boards, built purely in the Python language using the libraries:

streamlit => to generate the visual content

plotly express => for the charts

pandas => for reading the database through SQL queries and post-processing (ETL)

psycopg2 => for connecting to the database hosted on an AWS EC2

GOB Data - Streamlit Version

Decision support page containing the business data of the company Game of Boards, built purely in the Python language using the libraries:

streamlit => to generate the visual content

plotly express => for the charts

pandas => for reading the database through SQL queries and post-processing (ETL)

psycopg2 => for connecting to the database hosted on an AWS EC2

My Certifications

CPA-20 - Professional Certification Series 20

Issuer: ANBIMA - Brazilian Association of Financial and Capital Market Entities

The CPA-20 is intended for professionals who work in the distribution of investment products to clients in the high-income retail, private, corporate, and institutional investor segments in bank branches or service platforms.

PCEP-30-02 - Certified Entry-Level Python Programmer

Issuer: Python Institute

It is a professional credential that measures the candidate's ability to perform coding tasks related to the fundamentals of programming in the Python language.

The PCEP™ certification shows that the individual is familiar with the following concepts: fundamental terms and definitions, Python logic and structure, literals, variables, and number systems, operators and data types, I/O operations, control flow mechanisms, data collections, functions, exceptions, as well as the basics of syntax, semantics, and runtime environment of the Python programming language.

Microsoft Power BI for Data Science

Issuer: Data Science Academy
Duration: 72 hours

Python Fundamentals for Data Analysis 3.0

Issuer: Data Science Academy
Duration: 60 hours

Excel VBA

Issuer: Alura
Duration: 80 hours

Starting with Flask: Web Framework with Python

Issuer: Alura
Duration: 21 hours

Data Mesh

Issuer: Alura
Duration: 31 hours

Statistics with Python

Issuer: Alura
Duration: 71 hours

Data Modeling

Issuer: Alura
Duration: 43 hours

SQL with PostgreSQL

Issuer: Alura
Duration: 50 hours

Python for Data Science

Issuer: Alura
Duration: 69 hours

Web Administrator

Issuer: People Computação
Duration: 73 hours

Web Developer

Issuer: People Computação
Duration: 92 hours

Web Designer

Issuer: Alura
Duration: 80 hours

About Me

My Portfolio

GOB Data - Flask App

GOB Data - Power BI

TinyERP - Update DB via API

GOB Data - Streamlit Version

GOB Data - Streamlit Version

GOB Data - Streamlit Version

Top Skills

Certifications:

Certification 1

Certification 2

My Certifications

CPA-20 - Professional Certification Series 20

PCEP-30-02 - Certified Entry-Level Python Programmer

Microsoft Power BI for Data Science

Python Fundamentals for Data Analysis 3.0

Excel VBA

Starting with Flask: Web Framework with Python

Data Mesh

Statistics with Python

Data Modeling

SQL with PostgreSQL

Python for Data Science

Web Administrator

Web Developer

Web Designer

Contact