Yan Pontes Lopes Silva

Yan Pontes Lopes Silva has a diverse work experience spanning different roles and industries. Yan Pontes Lopes started their career as a Jovem Aprendiz in Gestão Financeira at L'Oréal, where they provided assistance in cost control and management, as well as project development for cost reduction. Yan Pontes Lopes then continued as an Administrative Financial Assistant, focusing on cost management and implementation of projects to reduce expenses and improve savings. Following that, they worked as an intern in the area of Financial Planning at L'Oréal, assisting in monthly closing, budget control, and implementation of systems and tools for savings opportunities.

Yan then transitioned to a role as a TI intern at Fundação Getulio Vargas, where they developed websites using the R language for the company's generated indicators and created dashboards for data analysis using Tableau.

After that, they joined qwst. as a Business Intelligence Intern and later as an OPS Tech, where they programmed and implemented questionnaires for surveys, collected and cleaned data, and created SQL views for BI consumption.

Yan's next work experience was as a Business Intelligence Intern at Grupo SOMA, where they created and maintained reports and analyses using SQL and structured dashboards for digital media results and CRM performance. Yan Pontes Lopes also analyzed transaction behavior and website traffic.

Yan Pontes Lopes'smost recent role was as a Data Analyst at BizCapital, where they implemented data processes, segmented databases for marketing campaigns, and supported campaign optimization.

Yan is currently working as a Jr Data Analyst at Gringo.

Yan Pontes Lopes Silva began their education at the Colégio Estadual José Leite Lopes in 2014, where they completed a degree in Técnico em Roteiro para Mídias Digitais between 2014 and 2016. Following this, they pursued a Bachelor's degree in Gestão de Sistemas de Informação at the Federal University of the State of Rio de Janeiro, which they started in 2018 and are expected to complete by 2023. Apart from their formal education, Yan Pontes Lopes Silva has also obtained certifications in SQL - Consultas e Relatórios and Banco de Dados - Modelagem, MYSQL e POSTGRESQL from COTI INFORMATICA in July 2021 and April 2021, respectively.