Walter Paixão Cortes, Developer in Porto Alegre - State of Rio Grande do Sul, Brazil
Walter is available for hire
Hire Walter

Walter Paixão Cortes

Verified Expert  in Engineering

Database Developer

Location
Porto Alegre - State of Rio Grande do Sul, Brazil
Toptal Member Since
June 18, 2020

Walter is a senior data analyst with 25+ years of experience. He's proactive, focused on results, always has the customer in mind, and is an expert in troubleshooting issues. Walter has worked on a variety of projects ranging from small to large, local or global—using project management techniques like Scrum.

Data ModelingData AnalysisData AnalyticsData VisualizationDatabasesSQLData IntegrationETLMicrosoft SQL ServerOraclePython 3JSONBusiness Intelligence (BI)Microsoft ExcelMicrosoft AccesseBay APISUNSCORM

Portfolio

Brigit
Data Build Tool (dbt), Data Visualization, Snowflake, SQL, BI Reporting
Cosgrove Partnership Inc
Tableau, Dashboards, Data Visualization, Dashboard Design, Google Sheets...
DSA INTERNATIONAL HOLDING COMPANY, LLC
Microsoft Power BI, Microsoft SQL Server, SQL Server BI, Microsoft Excel

Experience

SQL - 20 yearsData Analysis - 10 yearsDashboard Design - 10 yearsPython 3 - 10 yearsData Modeling - 10 yearsAPIs - 6 yearsTableau - 6 yearsMicrosoft Power BI - 3 years

Availability

Part-time

Preferred Environment

Linux, GitHub, Visual Studio Code (VS Code), MacOS, Windows

The most amazing...

...solution I've delivered is a chatbot to be used in a classroom that connects to bioinformatics databases and allows users to query them using natural language.

Work Experience

Data Analytics Practitioner

2024 - PRESENT
Brigit
  • MIgrated multi-purpose dashboards from the Sisense tool to Mode.
  • Reviewed and modified SQL queries to adapt to the new tool and improve performance.
  • Adapted the charts on the new tool to the design requirements established by Brigit.
Technologies: Data Build Tool (dbt), Data Visualization, Snowflake, SQL, BI Reporting

Tableau Dashboard Analyst

2023 - PRESENT
Cosgrove Partnership Inc
  • Created dashboards in Tableau for transition analysis.
  • Made small ETL pipelines using scheduling procedures in BigQuery.
  • Created SQL routines to assess the data quality of the source tables.
Technologies: Tableau, Dashboards, Data Visualization, Dashboard Design, Google Sheets, Google BigQuery, Microsoft Excel

Power BI Expert

2023 - PRESENT
DSA INTERNATIONAL HOLDING COMPANY, LLC
  • Developed and maintained sales dashboards using Power BI.
  • Created a new data analytical model to improve performance, precision, and conformation with the KPIs of the area.
  • Created the data catalog in order to keep track of the data that is being added to the analytical data model.
Technologies: Microsoft Power BI, Microsoft SQL Server, SQL Server BI, Microsoft Excel

Data Engineer

2018 - PRESENT
Future-IQ
  • Created an automated pipeline in Python to retrieve the data from the surveys and transform them into insights.
  • Automated the creation of basic visualizations with Tableau.
  • Created automated network maps using Python and D3.js.
Technologies: Python 3, Tableau, PostgreSQL, Google Sheets, Google Sheets API

Power Platform Consultant

2023 - 2024
Panthera Global Carbon
  • Developed Power App to support engineers to record information related to tests.
  • Modeled the Power App data source using Dataverse.
  • Designed a Microsoft PowerBI dashboard for visualizing insights from the data generated.
Technologies: Microsoft Power Apps, Microsoft Power BI, Microsoft Excel

BI Specialist

2023 - 2023
Flight Level LLC
  • Parsed historical sales data and historical fuel sales data from Excel and PDF files into a database (DuckDB) to gather all the information. After all the data is collected, it is exported to a Parquet file.
  • Created the sales and fuel sales dashboards in Microsoft Power BI. The dashboards use dynamic filters that change the X and Y axis of the main charts, making it possible to see different data views.
  • Conducted performance tuning in refreshing data in Power BI due to the high volume of data.
Technologies: Business Intelligence (BI), Data Analysis, Data Visualization, Dashboards, Microsoft Power BI, Tableau, Google Data Studio

Power BI Expert

2023 - 2023
Marcel Harris
  • Developed a data model from the data provided by the customer, a US-based company.
  • Created several dynamically calculated KPIs for sales.
  • Designed the dashboard based on the Figma prototype.
Technologies: Microsoft Power BI

Data Engineer

2023 - 2023
Green-Wood Cemetery
  • Created an automated pipeline to populate Elasticsearch index.
  • Stabilized the process of importing data into Elasticsearch.
  • Created automated GitHub Actions to process the Excel files and activate the Elasticsearch pipeline.
Technologies: Python, Elasticsearch, JSON, JavaScript, Node.js

Data Visualization Expert

2023 - 2023
A-lab
  • Developed a data model for project management analytics, using the output of their CAD and PLM tools as the source. Created a data model capable of showing the trend of problems that may occur in other projects.
  • Created a Power BI dashboard to show the project insights and guide the support team to resolve project issues.
  • Executed performance tuning on the model to ensure the best performance for queries.
Technologies: Microsoft Power BI, MySQL, Data Visualization

Data Engineer

2022 - 2023
R3 Development Group, LLC
  • Developed a pipeline that retrieves information from an EPA government FTP site.
  • Created a data model with the data collected to show the correlation among all the data files and display problems in water supplies. The data model was created with KPIs elaborated by the subject matter experts.
  • Architected two dashboards with information available on the built model.
Technologies: Tableau, Data Analysis, APIs, Data Analytics, Data Science, Data Build Tool (dbt), Apache Airflow, Reporting, Dashboards, Data Structures, Data Integration

Data Engineer

2022 - 2022
Scoutside, LLC
  • Built a data pipeline to migrate data between two marketplace systems.
  • Created a web interface using Vue to manage the execution of the data pipeline.
  • Executed data corrections based on validation from the business.
Technologies: Data Engineering, MongoDB, ETL, Data Migration

Product Designer

2019 - 2022
Dell Technologies
  • Developed two products using a method that combines lean, user-centered design (UCD) and extreme programming (XP) to deliver fast and high-value results to our customers.
  • Assisted the team in finding solutions using design-thinking techniques.
  • Created user interfaces with high usability that are innovative, responsive, and reactive using Angular, Vue, and Bulma.
  • Used the Python asynchronous framework FastAPI to develop the back end, supported by other technologies like Redis, RabbitMQ, and Cloud Foundry.
Technologies: PostgreSQL, MongoDB, Oracle, Bulma, Vue, Angular, Python, Python 3, Tableau, Google Sheets API, Data Modeling, APIs, VMware Tanzu Application Service (TAS) (Pivotal Cloud Foundry (PCF)), Oracle Database, Data Gathering, Data Engineering, Kanban, Scrum, Dashboard Design, Data Analysis, Microsoft Power BI, Flask, SQL, Bootstrap 3, Databases, Flask-RESTful, Data Lakes, Data Analytics, CSV File Processing, Scripting, SQL DML, Business Intelligence (BI), Reporting, Dashboards, Data Structures, Data Integration

Software Development Advisor

2009 - 2019
Dell
  • Developed the human resources data lake using the Hadoop technology stack.
  • Assisted the human resources data warehouse using the OBIEE technology stack.
  • Supported the Oracle Web Center (OWC) technology stack for a document repository.
  • Provided support for the human resources data warehouse using the BusinessObjects (SAP-BO) technology stack.
  • Aided in the development of the portfolio management tools for IT.
Technologies: Python, Teradata, Oracle, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Python 3, Google Sheets API, Web Scraping, Certified ScrumMaster (CSM), Data Modeling, APIs, VMware Tanzu Application Service (TAS) (Pivotal Cloud Foundry (PCF)), Oracle Database, Data Gathering, Data Engineering, Kanban, Scrum, Data Analysis, Flask, ETL, SQL, Databases, Data Lakes, Angular, Cassandra, Azure SQL Databases, Data Analytics, CSV File Processing, Scripting, SQL DML, Reporting, Dashboards, Data Structures, Data Integration, Excel 365

Senior Software Development

2005 - 2008
Dell
  • Maintained multiple .NET applications for the Product Group (PG).
  • Supported the development team as an application DBA on Oracle and SQL Server technologies.
  • Led the team that onboarded IT support for more than 20 applications supported by the business, reaching 100% compliance with IT policies and standards.
Technologies: Microsoft SQL Server, Oracle, .NET, ETL, Certified ScrumMaster (CSM), Data Modeling, Oracle Database, Kanban, Scrum, Flask, SQL, Databases, CSV File Processing, Scripting, T-SQL (Transact-SQL), SQL DML, Data Structures, Data Integration

Senior Software Engineer

2003 - 2005
Accenture
  • Developed multiple web applications for Accenture customers.
  • Acted as an application DBA on Oracle databases for Accenture customers.
  • Built an ASP.NET framework to speed up and standardize the development efforts for all development teams.
Technologies: Microsoft SQL Server, Oracle, C#, ASP.NET, Oracle Database, SQL, Databases, CSV File Processing, Scripting, SQL DML, Microsoft Access, Data Structures, Data Integration

Senior Software Engineer

2001 - 2003
Bankorp Consultores Associados
  • Developed ASP web applications for the state IRS office.
  • Built ASP.NET web applications for the state government.
  • Created an EAD solution in ASP.NET that was capable of importing SCORM content.
  • Constructed a document store web application in ASP.NET for many customers.
Technologies: Microsoft SQL Server, VBScript, Visual Basic, ASP.NET, SQL, Databases, Scripting, SQL DML, Microsoft Access, Data Structures, Data Integration

Bodies of Water Analysis

I created a Tableau dashboard that shows the results of the analysis of bodies of water in the US, based on EPA data. I've also created all the ETL processes to collect, clean, and transform the raw data from EPA in actionable insights using dbt.

Data Migration

I have created a python migration script between two eCommerce solutions, Conjured and OrderGroove. The challenges faced were related to differences in how the two systems deal with subscriptions and payments.

DB-InhA

DB-InhA is a bioinformatics tertiary database which contains all the relevant information to the InhA enzyme. It is divided into two streams: a responsive web application that allows querying of the information and a service that collects information and applies some basic curation techniques.

Technologies: Bootstrap, Python (Flask), MySQL

Tableau Visualizations

https://public.tableau.com/profile/wvcode
I created Tableau visualizations for scientific and commercial purposes, including cities research and development. I developed scripts to gather and format data and a "Design System" to guide the creation of all visualizations. Here I'm making four available that are not under NDA.

Riverlite Dashboard Application

I developed a dashboard application using Bootstrap and Python (Flask) to show incident management metrics and collect the data via an API from their PRTG server. The PRTG API was made available to create ETL scripts that store information in PostgresSQL.

HR Analytics

HR Analytics is a data warehouse built on top of OBIEE (Oracle Business Intelligence Enterprise Edition) and comprises ETL processes developed in Informatica Power Center. Developed the reports and dashboard in OBIEE, and it also has a database modeled on top of Oracle 11g.

wCReF Portal

wCReF is a responsive web portal to support the use of the CReF method for protein 3D structure prediction.

Technologies used: Bootstrap, Python (Flask), MySQL.

This interface was developed for a structure prediction study.

Languages

Python, Python 3, SQL, SQL DML, C#, T-SQL (Transact-SQL), Visual Basic, VBScript, PHP, JavaScript, Snowflake

Libraries/APIs

Google Sheets API, OpenAPI, Zoho API, Flask-RESTful, Beautiful Soup, Vue, eBay API, Paessler PRTG API, Node.js

Tools

Tableau, Microsoft Power BI, Microsoft Access, Google Sheets, Microsoft Excel, GitHub, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Apache Airflow, SQL Server BI, Microsoft Power Apps

Paradigms

ETL, Business Intelligence (BI), Kanban, Scrum, Data Science

Platforms

VMware Tanzu Application Service (TAS) (Pivotal Cloud Foundry (PCF)), Oracle Database, Oracle, Azure, Visual Studio Code (VS Code), Linux, MacOS, Windows

Storage

Microsoft SQL Server, PostgreSQL, Databases, JSON, Data Integration, Cassandra, MySQL, Azure SQL Databases, Data Lakes, Teradata, MongoDB, Elasticsearch

Other

Data Modeling, Data Gathering, APIs, Data Analysis, Dashboard Design, Data Analytics, Scripting, API Integration, Data Visualization, Reporting, Dashboards, Data Structures, Data Engineering, Certified ScrumMaster (CSM), Web Scraping, Data Scraping, CSV File Processing, Excel 365, Windows 10, Screen Scraping, Scrum Master, Data Build Tool (dbt), Google Data Studio, Google BigQuery, Data Migration, BI Reporting

Frameworks

Flask, ASP.NET, .NET, Angular, Bulma, Scrapy, Bootstrap 3

2015 - 2020

Doctorate in Computer Science

Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil

2013 - 2015

Master's Degree in Computer Science

Pontifical Catholic University of Rio Grande do Sul - Porto Alegre, Brazil

OCTOBER 2015 - PRESENT

Certified Scrum Master (CSM)

Scrum Alliance

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring