About Rogerio
Portuguese
Native or bilingual
Spanish
Fluent
English
Fluent
Experience
- Prodesp/DIPOLData Engineer / Data ScientistFebruary 2022 - Today (4 years and 5 months)
- Developed routines in Databricks (PySpark) for processing and analyzing datasets related to Missing Persons and Death Records.
- Built routines in Databricks (PySpark) to profile kidnappers.
- Created web crawlers to find images of criminals online and compare them with a local database.
- Established Data Factory pipelines to execute Databricks notebooks.
- Designed routines for cross-referencing local data (SQL Server and Data Lake) with Public Safety Department APIs.
- Developed Heat Maps for robbery and theft crimes using BigQuery and Looker.
- Created scripts in PySpark (Dataproc) and Apache Beam (Dataflow) for migrating crime data from IBM DB2 to BigQuery for a heat map project.
- Migrated data project from GCP to Snowflake
- Created databases, schemas, and stages
- Copied data from a Google Cloud Storage stage
- Bulk loading from Google Cloud Storage
- Created jobs in Snowpark
- Developed dashboards using Streamlit
- SmartfitData EngineerMay 2021 - February 2022 (9 months)
- Developed routines to monitor Alteryx ETL jobs
- Created migration tasks using DMS
- Configured Kinesis Data Streams as a target for DMS
- Restructured Data Lake Zones
- Migrated legacy jobs in Glue to Spark (PySpark) running on EKS
- Migrated routines from EMR to Spark on EKS (Fargate)
- Implemented pipelines using Airflow (MWAA)
- Developed ETL routines with Spark (PySpark) on EKS for loading into parquet (S3/Athena) and Redshift
- Conducted a PoC for migrating Tableau to Elasticsearch/Kibana
- Migrated data project from AWS to Snowflake
- Created databases, schemas, and stages
- Copied data from S3 into staging table
- Loaded data from staging table to target table
- Created jobs in Snowpark
- Developed dashboards using Streamlit
- JBS/Seara (Project-Based)Data EngineerFebruary 2021 - May 2021 (3 months)
- Implemented data pipelines with Composer (Airflow).
- Developed ETL routines with PySpark (Dataproc) for loading datasets into BigQuery.
- Migrated Oracle databases to BigQuery.
- Developed web crawlers (Web scraping) for extracting data from government portals.
Recommendations
Be the first to recommend Rogerio
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Data Center Technical SpecialistNovell PartnerNetData Center Technical Specialist
- Computer NetworksUNIP2006Technology Degree