Diego Lopes Email & Phone Number

São Paulo, Sp, Br

São Paulo, Brazil

This project aims to improve the CulturaEduca platform through the implementation of a naturallanguage interface that allows non-expert users to access geospatial data using Text-to-SQLtechniques. Our focus is to improve translation results in geospatial queries, which is currentlychallenging due to the limited representation of complex queries on the training datasets ofcurrent Text-to-SQL methods. We will conduct this project as a case study, using Generative AIand… Show more This project aims to improve the CulturaEduca platform through the implementation of a naturallanguage interface that allows non-expert users to access geospatial data using Text-to-SQLtechniques. Our focus is to improve translation results in geospatial queries, which is currentlychallenging due to the limited representation of complex queries on the training datasets ofcurrent Text-to-SQL methods. We will conduct this project as a case study, using Generative AIand Processing Natural Language (NLP) to achieve our goals. Show less

Porto Alegre, Rio Grande Do Sul, Brazil

In this role, I am responsible for designing the data architecture to process data in real-time andbatch with an average volume of 10 million 60kb documents daily. My responsibilities alsoinclude understanding the needs and challenges of the business to implement an architecturethat can handle large volumes of data per second, ensuring data quality, security, and availabilitywhile ensuring compliance with data protection regulations.Technologies: Apache Airflow, Apache… Show more In this role, I am responsible for designing the data architecture to process data in real-time andbatch with an average volume of 10 million 60kb documents daily. My responsibilities alsoinclude understanding the needs and challenges of the business to implement an architecturethat can handle large volumes of data per second, ensuring data quality, security, and availabilitywhile ensuring compliance with data protection regulations.Technologies: Apache Airflow, Apache Cassandra, Grafana, MongoDB, Python, SQL, AWS (S3,RDS, EC2, Athena, Glue) e PostgreSQL. Show less

Brazil

In this position, I was responsible for data management and was responsible for creating andoptimizing the data flow responsible for consolidating the user journey between platforms fromGrupo Globo. For this, I was responsible for maintaining the architecture of the databases andpipelines that processed data coming from a graph database and other databases for ananalytical basis.Technologies: AWS (Neptune), GCP (BigQuery e Dataform), JavaScript, Python

Campinas, São Paulo, Brazil

In this project, I was responsible for making the connection between the business teams thatdedicated themselves to implementing the Salesforce interface for Account Managers and thesales team data at Bradesco Bank. My responsibilities were focused on analyzing the prototypesdeveloped and evaluating the feasibility and availability of the data necessary to implement thenew features. Performed data mapping, identification of databases available such as Teradata,SQL Server, or… Show more In this project, I was responsible for making the connection between the business teams thatdedicated themselves to implementing the Salesforce interface for Account Managers and thesales team data at Bradesco Bank. My responsibilities were focused on analyzing the prototypesdeveloped and evaluating the feasibility and availability of the data necessary to implement thenew features. Performed data mapping, identification of databases available such as Teradata,SQL Server, or Hive, as well as column and rule mapping to perform the metrics andnormalizations of the raw layered data lake refined, in addition to data normalization.Technologies: Apache Hive, Erwin, Python, Teradata, SQL Server, SQL Server Integration Service. Show less

Sao Paulo, Sao Paulo, Brazil

In this position, I was responsible for implementing new financial reports for products of creditfor Bradesco Bank, and I was responsible for performance optimization and refactoring of existingHiveQL scripts. My improvements resulted in a 20-minute reduction in the 1-hour run time ofreports. I was responsible for monitoring ELT processes to ensure the execution and delivery ofdata.Technologies: Apache Hive e HiveQL, Shell Scripting, Linux.

Campinas Area, Brazil

In this project, I worked with two distinct segments: applications and messaging, including SMSand WhatsApp Bots. My responsibilities included maintaining data pipelines and dashboardscompany metrics and identifying the needs of the marketing, product, and finance teams. In theapplications area, I consolidated metrics such as DAU, WAU, and MAU to create the user journeyinside the product. Created data flows using Pentaho Data Integration, which ran scripts SQL thatperformed… Show more In this project, I worked with two distinct segments: applications and messaging, including SMSand WhatsApp Bots. My responsibilities included maintaining data pipelines and dashboardscompany metrics and identifying the needs of the marketing, product, and finance teams. In theapplications area, I consolidated metrics such as DAU, WAU, and MAU to create the user journeyinside the product. Created data flows using Pentaho Data Integration, which ran scripts SQL thatperformed all data normalization and metrics calculation steps. In the area of messaging, Iworked on consolidating the data warehouse in Google Big Query and Amazon Redshift inaddition to developing new data flows using Apache Airflow and Python to process orchestration.I was responsible for carrying out data enrichment through Credit information APIs, such asSerasa Score. Additionally, I maintained and created new dashboards in Grafana and Power BIthat consumed data from Elasticsearch and Google BigQuery respectively, to monitor the trafficof messages sent and delivered to users.Technologies: Apache Airflow, AWS (Redshift), GCP (BigQuery), Python, SQL Server, Postgres,Power BI e Pentaho Data Integration. Show less

Master Of Science - Ms, Computer Science

Generative AI & NLP research to improve Text-to-SQL techniques for geospatial queries. Subjects Studied - Artificial intelligence.

Postgraduate Degree, Digital Security, Governance And Data Management

Associate'S Degree, Analysis And Systems Development