Paulo Laque, Developer in Rio de Janeiro - State of Rio de Janeiro, Brazil
Paulo is available for hire
Hire Paulo

Paulo Laque

Verified Expert  in Engineering

Data Analyst and Developer

Rio de Janeiro - State of Rio de Janeiro, Brazil

Toptal member since October 4, 2023

Bio

Paulo is a seasoned data analyst and Microsoft Power BI developer with over seven years of experience. His management consulting background brings a strong finance and economics foundation to his robust skill set. Armed with a master's degree in AI and data science, he also excels in Python and SQL. As a financial planning and analysis (FP&A) lead, Paulo played a pivotal role in Vtex's listing on NASDAQ and architected a global BI system, granting access to users across three continents.

Portfolio

Olist
Amazon Athena, Databricks, Azure, Amazon Web Services (AWS), SQL, Python...
Vtex
Microsoft Power BI, Amazon Web Services (AWS), Finance, SQL, Google Data Studio...
Vtex
Microsoft Power BI, Microsoft Excel, Data Modeling, Data Mining...

Experience

  • Finance - 8 years
  • Presentations - 8 years
  • Investor Reporting - 8 years
  • SQL - 7 years
  • Microsoft Power BI - 6 years
  • Python - 5 years
  • Data Science - 5 years
  • Amazon Web Services (AWS) - 5 years

Availability

Part-time

Preferred Environment

Windows, Slack, Microsoft Power BI, SQL, Python, Amazon Web Services (AWS), Azure, Databricks, Amazon Athena, Google Data Studio

The most amazing...

...system I've created with AWS and Microsoft Power BI is an E2E BI architecture that delivers automated personalized data to 70+ users across three continents.

Work Experience

Advanced Analytics Senior Data Analyst

2021 - PRESENT
Olist
  • Handled Microsoft Power BI administration and development tasks.
  • Built Microsoft Power BI dashboards for over 300 internal users, including marketing, operations, finance, and product teams.
  • Embedded dashboards with row-level security (RLS) in the company's product for 10,000 external users.
  • Developed an NLP BERT GPU model for classifying marketplace-prohibited products with 93.50% accuracy and the capacity to label 110,000 products per hour.
  • Led the creation of business intelligence architecture, encompassing silver and gold analytical layers. I defined mission-critical KPIs and orchestrated Microsoft Power BI developments for a newly acquired company.
  • Created AI and machine learning models for classification, clustering, and regression, and an NLP to tackle churn, enhance catalog products, and classify seller tiers.
Technologies: Amazon Athena, Databricks, Azure, Amazon Web Services (AWS), SQL, Python, Microsoft Power BI, Amazon S3 (AWS S3), Artificial Intelligence (AI), Machine Learning, Big Data, Spark SQL, Amazon SageMaker, Azure Virtual Machines, Investor Reporting, Azure Databricks, Business Intelligence (BI), DAX, Data Visualization, Pandas, NumPy, Data Warehousing, ETL, Office 365, Dashboards, Cloud, Data Pipelines, Data Analytics, GitHub, Data Modeling, Microsoft Excel, Microsoft 365, Data Analysis, PL/SQL, Data Engineering, BI Reporting, Data Science, Microsoft Power Apps, Data Quality Analysis, Data Cleansing, Jira, Reporting, Web Dashboards, Data Transformation, CSV File Processing, Automation, Dashboard Development, Excel 365, Power Query, Amazon QuickSight

Data Analytics Lead

2020 - 2021
Vtex
  • Created a business intelligence architecture with Amazon S3 (AWS S3), Amazon Athena, Microsoft Power BI, and Google Data Studio to provide automatically updated data to over 70 users across three continents.
  • Implemented Power BI, serving as the Power BI Admin, and successfully set up Power BI Server and Gateway while managing permissions, user groups, and access.
  • Implemented row-level security (RLS) in Power BI to control access to GMV and order data based on user region, department, and portfolio, ensuring data confidentiality and appropriate segmentation.
Technologies: Microsoft Power BI, Amazon Web Services (AWS), Finance, SQL, Google Data Studio, Machine Learning, Redshift, Amazon S3 (AWS S3), Amazon Athena, Amazon EC2, AWS IAM, Excel VBA, Pitch Presentations, Business Planning, Investor Reporting, Presentations, Business Intelligence (BI), DAX, Data Visualization, Pandas, NumPy, Data Warehousing, ETL, Office 365, Dashboards, Cloud, Data Pipelines, Data Warehouse Design, Data Analytics, Data Modeling, Microsoft Excel, Microsoft 365, Data Analysis, PL/SQL, Amazon QuickSight, Python, Data Engineering, BI Reporting, Microsoft Power Apps, Data Quality Analysis, Data Cleansing, Reporting, Salesforce, Metabase, Web Dashboards, Looker Studio, Data Transformation, CSV File Processing, Tableau, Automation, Dashboard Development, Excel 365, Power Query

FP&A Leader

2018 - 2020
Vtex
  • Led the team that developed the investment pitch deck and business plan, raising $365 million without hiring an advisor.
  • Prepared monthly reports on SaaS economic metrics for the CFO and board.
  • Built a SaaS economics model from scratch using raw data, providing valuable insights into the company's financial performance and informing strategic decision-making.
Technologies: Microsoft Power BI, Microsoft Excel, Data Modeling, Data Mining, Investor Reporting, Amazon Web Services (AWS), Google Apps Script, Google Sheets, Postman, APIs, Python, R, Business Planning, Excel VBA, Visual Basic for Applications (VBA), Excel 2013, Forecasting, Data Quality Analysis, Data Cleansing, Data Science, Reporting, Salesforce, Visual Basic, Looker Studio, Metabase, Data Transformation, CSV File Processing, Automation, Dashboards, Dashboard Development, Excel 365, Business Intelligence (BI), Power Query

Consultant Analyst II

2015 - 2017
A&M
  • Updated two years' operational data from a mid-size bank's credit portfolio with over 14,000 clients in a legacy system using SQL.
  • Developed a Microsoft PowerPoint add-in using Excel VBA, which was then successfully leveraged in various projects in A&M Brazil.
  • Worked on a project that won A&M Brazil's "project of the year 2017" and resulted in the fast data organization of all credit portfolios of a mid-sized national bank.
Technologies: SQL, MySQL, Excel VBA, Excel 365, Finance, Financial Restructuring, Investor Reporting, Microsoft Power BI, Data Visualization, Office 365, Data Analytics, Data Modeling, Microsoft Excel, Microsoft Access, Microsoft 365, Data Analysis, PL/SQL, Excel 2013, Visual Basic for Applications (VBA), Data Quality Analysis, Data Cleansing, Reporting, Visual Basic, Data Transformation, CSV File Processing

Experience

XGBoost Feature Importance Pricing Model

https://github.com/paulolaque/randomsearchcv-nlp-improved-rio-airbnb-pricingmodel-xgboost
I created an XGBoost feature importance pricing model tunned with "RandomizedSearchCV" and an NLP for Airbnb in Rio de Janeiro. The system was built in Python using scikit-learn, Natural Language Toolkit (NLTK), pandas, and NumPy.

The project involved performing feature importance analysis for Airbnb pricing in Rio de Janeiro using data preprocessing techniques, XGBoost models, "RandomizedSearchCV," and GPU acceleration for enhanced performance. Key factors impacting prices included the number of bathrooms, private rooms, specific neighborhoods, and amenities like air conditioning and smart speakers. Thorough data preparation, feature selection, and careful tuning were crucial for maximizing earnings on Airbnb.

Sentiment Analysis on Financial Documents

https://github.com/paulolaque/sp500-mda-finbert-sentiment
I conducted sentiment analysis using the FinBERT model on five years of financial documents from all S&P 500 companies, specifically focusing on comments in the "management discussion and analysis" section of the 10,000 filings submitted to the Securities and Exchange Commission. This project involved developing and automating a sentiment analysis system in Python utilizing scikit-learn, transformers, Natural Language Toolkit (NLTK), pandas, and NumPy.

I used FinBERT, a deep-learning model for financial records, to generate sentiment scores for each document. I then compiled the results into a table, with each row representing an S&P 500 company and a corresponding sentiment score. I discovered that the sentiment expressed in the reports tended to be more optimistic than market sentiment, as reflected by stock prices. I noted that only 2019 showed statistical significance in predicting returns based on the sentiments expressed in the statements.

Top Cartoes Website

I have created a website that calculates the best credit cards available for your profile in Brazil. I developed this website using WiX and Looker (formerly Google Data Studio), which collects user input on investments, annual earnings, and expenses. It uses this information to calculate yearly fees, discounts, cashback, miles, and other rewards for each bank segment and credit card commercial rules. The cards are then ranked based on the expected profit for each one available to your profile. I own this website and earn using ads.

Education

2019 - 2021

Master's Degree in Data Science

Pontifical Catholic University of Rio de Janeiro (PUC) - Rio de Janeiro, Brazil

2013 - 2016

Bachelor's Degree in Economics

Ibmec - Rio de Janeiro, Brazil

Certifications

AUGUST 2023 - PRESENT

SQL (Advanced) Certificate

HackerRank

MAY 2023 - PRESENT

Data Scientist Nanodegree

Udacity

MARCH 2021 - PRESENT

Data Warehousing on AWS

Amazon Web Services

Skills

Libraries/APIs

Pandas, NumPy, XGBoost

Tools

Microsoft Power BI, Google Sheets, Excel 2013, Microsoft Excel, Power Query, Slack, GitHub, Microsoft Access, Wix, Amazon QuickSight, Amazon Athena, AWS Glue, AWS IAM, Spark SQL, Amazon SageMaker, Microsoft Power Apps, Postman, Jira, Tableau

Languages

SQL, Python, Visual Basic, Excel VBA, Google Apps Script, R, Visual Basic for Applications (VBA)

Paradigms

Business Intelligence (BI), ETL, Automation

Storage

PL/SQL, MySQL, Data Pipelines, Redshift, Amazon S3 (AWS S3), Databases, PostgreSQL, Microsoft SQL Server

Platforms

Windows, Amazon Web Services (AWS), Databricks, Salesforce, Azure, Amazon EC2

Other

Google Data Studio, Data Science, Excel 365, Finance, Investor Reporting, Data Visualization, Office 365, Dashboards, Data Analytics, Data Modeling, Microsoft 365, Data Analysis, BI Reporting, Data Quality Analysis, Data Cleansing, Reporting, Looker Studio, CSV File Processing, Dashboard Development, Presentations, Azure Databricks, DAX, Data Warehousing, Cloud, Data Warehouse Design, Data Engineering, Metabase, Web Dashboards, Data Transformation, Economics, Econometrics, Forecasting, Statistics, Machine Learning, Artificial Intelligence (AI), Deep Learning, Neural Networks, Pitch Presentations, Business Planning, Financial Restructuring, Big Data, Azure Virtual Machines, Web Scraping, Data Mining, APIs

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