
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
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
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
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
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.
Data Analytics Lead
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.
FP&A Leader
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.
Consultant Analyst II
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.
Experience
XGBoost Feature Importance Pricing Model
https://github.com/paulolaque/randomsearchcv-nlp-improved-rio-airbnb-pricingmodel-xgboostThe 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-sentimentI 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
Education
Master's Degree in Data Science
Pontifical Catholic University of Rio de Janeiro (PUC) - Rio de Janeiro, Brazil
Bachelor's Degree in Economics
Ibmec - Rio de Janeiro, Brazil
Certifications
SQL (Advanced) Certificate
HackerRank
Data Scientist Nanodegree
Udacity
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring