Pedro G.

Experience

• 

  Centro de Estudos em Comunicação, Tecnologia e Política (CTPol)

  Mar 2018 - Jul 2018

  Research assistant involved in a research project (*) on the quality of open data publications from the Brazilian Open Data Portal.Responsible for developing a data collection instrument in SPSS and participating in the pre-testing and validation process of the analysis instrument for the research. The pre-test consisted of closed-ended questions on the topic of open data quality.(*) Participation mentioned by name in:Silva, S. P. da, Soares, A. T. N., Cesar, D. J. T., & Rabelo, L. E. M. (2020). Indicadores para avaliação qualitativa de Dados Abertos: Inteligibilidade, operacionalidade e interatividade nos datasets do Governo Federal no Portal Brasileiro de Dados Abertos. Informação & Sociedade: Estudos, 30(3), 1–19. Show less Conducted qualitative analyses of the project (*), contributing to the development of quality indicators considering the normative aspects that underpin the foundations of the open data literature. Supported the translation and adaptation of indicators from existing open data policy indices such as the Open Data Barometer (ODB), Global Open Data Index (GODI), Open Data Inventory (ODIN), and OurData Index (Open-Useful-Reusable Data Index), and developed new indicators.(*) Participation mentioned by name in:Silva, S. P. da, Soares, A. T. N., Cesar, D. J. T., & Rabelo, L. E. M. (2020). Indicadores para avaliação qualitativa de Dados Abertos: Inteligibilidade, operacionalidade e interatividade nos datasets do Governo Federal no Portal Brasileiro de Dados Abertos. Informação &Amp; Sociedade: Estudos, 30(3), 1–19. Show less

  • Open Data Research Validation Analyst

    Mar 2018 - Jul 2018

  • Quality Analyst in Open Data

    Mar 2018 - Jul 2018
• 

  P. I. S. G. LTDA

  Jan 2022 - now

  Work focused on the development, testing, and implementation of generative AI-based solutions.

  • Generative AI Engineer

    Jul 2024 - now

  • Data Developer

    Jan 2022 - now
• 

  Prosas

  Feb 2022 - Sept 2022

  Data Analyst

  Worked on the Data Analysis and Visualization team for the "Central de Editais" platform.Results:• Increased the creation of management dashboards by 350%, consequently expanding data availability for querying.Deliverables:• Defined and qualified business indicators related to investor and social entrepreneur participation in funding calls: 'Geographic distribution and concentration of investments', 'Geographic distribution and concentration of social projects', 'Quantity of investments per SDG', 'Quantity of projects per SDG', 'Investors with the highest application of resources', etc.• Developed data analyses on social entrepreneurs and projects using SQL queries (PostgreSQL) and dashboards (Looker Studio), as requested by external clients (Celesc, Igapó, and others). The development included data on organizations and projects that received investments from sponsors - social investors - in specific calls.• Developed data analyses on the entire Prosas Incentive Bank (BIP) (BIP Cultura, BIP Esporte, BIP FIA, and BIP Fundo do Idoso) for internal company use, conducted through SQL queries (PostgreSQL) and dashboards (Looker Studio).• Refactored SQL scripts in the Prosas BI development environment (Looker Studio), specifically the startup's status report dashboard.• Monitored the daily performance and operation of Prosas BI.• Controlled access to Prosas BI and other dashboards, as well as periodic user licensing.• Developed and graphically reproduced the 'Prosas financial module' in Looker Studio for validation of the design proposed by the UX team. Show less

• 

  Nexo Investimento Social

  Feb 2022 - Sept 2022

  Data Analyst

  The work at Nexo involved automating work processes, developing Python applications, and consuming APIs.Results:• Reduced data processing time from web scraping by 46%.Deliverables:• Refactored and validated Python web crawling for data extraction from the Brazilian government's Cultural Incentive Laws Support System (Salicnet).• Conducted testing of data consumption from the Salic API.

• 

  Juntos Somos Mais

  Nov 2022 - Mar 2024

  Worked on the data team, specifically in the Market Research and Business Intelligence (BI) squad, focusing on developing key performance indicators (KPIs) and analyzing market research and customer satisfaction (CS and CX) data in the construction and real estate sector.Results:• Increased revenue generated from research data analysis by 8.74% in 2023.Deliverables:• Produced the monthly "JS+ Thermometer" report, providing sell-in data on construction materials transacted on Juntos' B2B e-commerce marketplace, including national retail values, positivity rates, index, and price variation.• Produced the monthly "JS+ Market KPIs" report, presenting data on the construction and real estate market, allowing for visualization and historical series reproduction of key industry indicators such as INCC, IPCA (Repairs and Housing), CUB, SNIC, (ICST, ISA, IE, and NUCI), PMC (Construction Materials), PIM, and CAGED (Construction) / ABECIP, IMOB, PMCI, FIPEZAP, and ABRAINC.• Developed data analyses (using SQL, Python, Databricks, and Excel) and produced presentations with quantitative research results related to the industry's customer experience and satisfaction (retailers, counter clerks, construction professionals, and others). Research covered questions about industry products, prices, campaigns, Juntos' loyalty program, and its B2B e-commerce platform, and was requested by major market players (Votorantim, Tigre, Gerdau, etc.). The work considered the entire research flow, from briefing to survey form production in Survey Monkey, mailing generation to scheduling dispatch.• Participated in the development and validation of Juntos' Self-Service Analytics (SSA) platform, produced in Metabase. Show less Led the facilitation of Juntos' data strategy and policy implementation, fostering a data-driven culture, ensuring technical and data quality compliance, legal adherence, and protection of sensitive data.Results:• Increased cataloging and validation of data models (bronze, silver, and gold layers) by approximately 40%.Deliverables:• Supported the entire data lifecycle across the company's tech areas, contributing to the definition and implementation of metadata for Analytics, Data Engineering, and Software Engineering teams.• Cataloged models and data lineage using Microsoft Storage and Power BI.• Validated technical documentation (data dictionary) developed in AWS C4.• Contributed to defining and validating the business metrics dictionary.• Curated data-related content for internal team training. Show less

  • Data Analyst

    Jun 2023 - Mar 2024

  • Data Governance Analyst

    Nov 2022 - May 2023
• 

  Yara International

  Mar 2024 - Apr 2024

  Data Analyst

  Temporary position on the 'Customer & Commercial Excellence (CCE)' team with a mission to develop data solutions to improve the Yara customer experience through commercial excellence.Results:• Increased the creation and availability of technical data collection resources (Excel) for commercial management by 4200%, considering their divisions (CC, DM, and YVT) and coverage by agricultural poles.Deliverables:• Extraction and division of commercial portfolios based on the sales team's areas of operation (CC, DM, and YVT), and segmentation of portfolios by agricultural poles (Excel).• Management of customer satisfaction survey databases, both from the perspective of data ingestion for availability in the CX Dashboard (Power BI) and from the perspective of consolidating and controlling response databases (Excel).• Weekly extraction of data from the Salesforce CRM related to sales and delivery transactions and fertilizer application, to feed and manage the survey mailing databases.• Manipulation, production, and weekly delivery of the Yara loyalty database to a third-party company.• Execution of survey sending (email and blip/WhatsApp), ensuring the effectiveness and reach of the defined audience and sample. Show less