toptal.com
Contact us: +1.888.604.3188
Victor Eduardo Pato Paulillo, Data Engineering Developer in São Paulo - State of São Paulo, Brazil
Victor Eduardo Pato Paulillo

Data Engineering Developer in São Paulo - State of São Paulo, Brazil

Member since September 6, 2020
Victor is a data engineer with five years of experience in the fintech market, building data warehouses, data pipelines, data modeling, data analysis, dashboards, and marketing campaigns. He is an expert in Python and Big Data Hadoop-based analytics and has recently gained experience as a product owner to implement and sustain a CRM platform.
Victor is now available for hire
Hire Victor

Portfolio

  • StoneCo
    Apache Airflow, Apache Kafka, AWS Athena, Hadoop, Apache Hive, ETL, Python...
  • Banco Original
    Apache Airflow, Agile, Google Cloud Platform (GCP), ETL, Google Pub/Sub...
  • Banco Original
    HDFS, Hadoop, Zeppelin, Apache Hive, ETL, Chatbots, Data Analytics...

Experience

Location

São Paulo - State of São Paulo, Brazil

Availability

Part-time

Preferred Environment

Apache Airflow, Jupyter Notebook, Apache Hive, Google Cloud Platform (GCP), Google BigQuery, Microsoft Power BI, SQL, Python, Business Intelligence (BI), ETL

The most amazing...

...thing I've created was a system and a dashboard, which automatically obtains the conversion rate of marketing campaigns, for more than 20 financial products.

Employment

  • Data Engineer

    2021 - PRESENT
    StoneCo
    • Created batch and streaming data pipelines for business teams.
    • Loaded data from external data providers on Data Lake.
    • Created data quality system for data processing jobs.
    Technologies: Apache Airflow, Apache Kafka, AWS Athena, Hadoop, Apache Hive, ETL, Python, AWS S3, Redshift, SQL, ELT, Data Quality, Data Processing, Jupyter Notebook, Pandas, NumPy, Data Engineering, Data Modeling, Data Architecture, Data Warehouse Design, Data Warehousing, Financial Data, Data Pipelines, Data Marts, Banking & Finance, Amazon Web Services (AWS), Amazon Athena, AWS, Data, ETL Development, Data Science

  • Data Engineer

    2019 - 2021
    Banco Original
    • Migrated ten on-premises ETL processes to Google Cloud Platform using Google Cloud Storage, Cloud Functions, Google Pub/Sub, and Google BigQuery.
    • Developed a system with Hive and Power BI to automatically get the conversion rate of marketing campaigns (email, push, and ads), for more than twenty financial products and around one hundred campaigns monthly.
    • Created an API integration with BigQuery data to post on Facebook Marketing API and Google Ads using the Google Cloud Platform tools: BigQuery, Cloud Function, and Pub/Sub.
    • Worked as a product owner and developer to create data pipelines and data modeling to support a newly acquired marketing platform (Oracle Responsys) and adapt it to the company.
    • Worked with product managers to get the correct information on the transactional database then develop ETL to a data warehouse.
    Technologies: Apache Airflow, Agile, Google Cloud Platform (GCP), ETL, Google Pub/Sub, Google Cloud Functions, Google BigQuery, Facebook Marketing API, Google Ads API, ELT, Data Warehouse Design, Data Warehousing, Data Lakes, Financial Products, Financial Data, Product Owner, Oracle Responsys, Jupyter Notebook, Cloud Computing, Google Cloud Composer, Data Pipelines, Apache Hive, HDFS, Hadoop, Zeppelin, Python, SQL, Pandas, NumPy, Data Quality, Data Processing, PyCharm, Functional Programming, Data Engineering, Data Modeling, Data Architecture, Apache Spark, Google Cloud Storage, Data Marts, Banking & Finance, Looker, Data, ETL Development, Data Science

  • Business Intelligence Analyst Jr

    2017 - 2019
    Banco Original
    • Supported the development and structure of data lake environment on HDFS.
    • Developed fifteen ETL processes at data sources located on Data Lake (HDFS) and delivered them on Hive for analytics purposes to business users.
    • Worked with marketing managers to develop data-driven sales strategies through in-depth analysis of customers' behavior.
    • Developed product performance dashboards to be accessed by the sales and product teams.
    • Created more than 20 customer audiences for marketing campaign journeys according to product analytics rules.
    • Worked to improve the performance of a customer service chatbot through analytics on JSON files.
    • Worked with business and product teams to disseminate analytics best practices, improve their query performances, and get the correct rules to achieve their analysis goals.
    Technologies: HDFS, Hadoop, Zeppelin, Apache Hive, ETL, Chatbots, Data Analytics, Business Intelligence (BI), ELT, Financial Data Analytics, Financial Data, Financial Products, Marketing Automation, Jupyter Notebook, Microsoft Power BI, Marketing Campaign Design, Data Auditing, Sales Strategy, Data Lakes, Data Warehouse Design, SQL, Python, Data Quality, Data Processing, Data Engineering, Data Modeling, Data Warehousing, Data Marts, Banking & Finance, Data, ETL Development, Data Science

  • Business Intelligence Intern

    2016 - 2017
    Banco Original
    • Created reports to analyze the rentability and acquisition of customers.
    • Worked with product managers to audit ten financial products on the analytics databases and compare them with the transactional system.
    • Developed around twenty ad-hoc queries with SQL and SAS using the SAS Guide software.
    • Created around 25 top campaigns through several fonts of data (e.g., customers that delay the credit card bill).
    • Developed the data dictionary for the databases of ten financial products.
    • Supporting the survey and control of informational data gaps.
    • Strong knowledge of flux, rules, and specifications of bank products, like credit cards, loans, and overdraft to audit the bases and create campaigns and reports.
    Technologies: SQL, SAS Enterprise Guide, Dashboards, Excel 365, Marketing Automation, Financial Products, Data Analytics, Business Intelligence (BI), Financial Data, Financial Data Analytics, Banking & Finance, Data

Experience

  • Post BigQuery Data on Facebook Marketing API
    https://victor-paulillo.medium.com/post-bigquery-data-on-facebook-marketing-api-276516566bbe

    This project connects BigQuery with Facebook Marketing API.

    The article shows a simplified version of the project and shows how to post data on Facebook Ads that can be used to build audiences for ad targeting or to set as an offline conversion.

    Upon completion of the project, it was possible to dive deep into customer analytics and machine learning models to improve advertisement performances and new marketing strategies involving Facebook Ads.

    Offline conversions enable Facebook machine learning to better understand who is the best customer of your company, especially when you have products and services that aren’t distributed online.

Skills

  • Languages

    SQL, Python

  • Other

    Data Engineering, Google BigQuery, Google Data Studio, Data Analysis, Google Pub/Sub, Google Cloud Functions, Dashboards, Marketing Automation, Financial Products, Data Analytics, ELT, Data Warehousing, Agile Sprints, Financial Data, Financial Data Analytics, Marketing Campaign Design, Data Auditing, Data Quality, Data Warehouse Design, Data, ETL Development, Statistics, Economics, Engineering, APIs, Excel 365, Chatbots, Cloud Computing, Sales Strategy, Product Owner, Data Marts, Data Processing, Data Modeling, Data Architecture, AWS

  • Libraries/APIs

    Pandas, Google Ads API, Facebook Marketing API, TensorFlow, NumPy

  • Tools

    Apache Airflow, Microsoft Power BI, PyCharm, SAS Enterprise Guide, AWS Athena, Google Cloud Composer, Amazon Athena

  • Paradigms

    Agile, Business Intelligence (BI), ETL, Management, Functional Programming, Data Science

  • Platforms

    Jupyter Notebook, Google Cloud Platform (GCP), Oracle Responsys, Zeppelin, Apache Kafka, Amazon Web Services (AWS)

  • Storage

    Apache Hive, HDFS, Data Lakes, Google Cloud Storage, Data Pipelines, AWS S3, Redshift, PostgreSQL, Google Cloud SQL

  • Industry Expertise

    Banking & Finance

  • Frameworks

    Hadoop, Apache Spark

Education

  • Bachelor’s Degree in Production Engineering
    2014 - 2019
    Federal Institute of São Paulo (IFSP-SPO) - São Paulo, Brazil

Certifications

  • Modernizing Data Lakes and Data Warehouses with GCP
    OCTOBER 2020 - PRESENT
    Coursera
  • Google Cloud Platform Big Data and Machine Learning Fundamentals
    SEPTEMBER 2020 - PRESENT
    Coursera

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM