João Victor Andrade
Analista de Dados Pleno at Bravium- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Espanhol Professional working proficiency
Topline Score
Bio
Experience
-
Bravium
-
Brazil
-
IT Services and IT Consulting
-
100 - 200 Employee
-
Analista de Dados Pleno
-
Aug 2023 - Present
Com sede no Brasil e operação em outros sete países da América Latina, a Bravium surgiu em 2007 para potencializar o relacionamento entre diferentes indústrias, canais de distribuição e consumidores. A Bravium começou no mercado de Loyalty, fazendo fulfillment para os principais programas de fidelidade do país e, ao longo dos anos, expandiu seu portfólio de serviços para outras tecnologias e soluções de go to market digital, incluindo full commerce, plataformas de loyalty e marketplace B2B e B2C, incentivos, e business analytics. • Elaboração das metas de performance de um programa de fidelidade da Ambev, resultando no aumento da taxa de engajamento dos clientes. • Experiência com extração, tratamento e elaboração de visualização de dados estratégicos que geram insights diretamente relacionados à estratégia de negócios. • Habilidade de elaborar relatórios gerenciais detalhados, com foco em storytelling e visualização de dados, utilizando ferramentas como SQL Server e Power BI, além de aprimorar o dashboard utilizado por gerentes e diretores da Ambev em um dos seus programas de pontos. Show less
-
-
-
americanas s.a.
-
Brazil
-
Retail
-
700 & Above Employee
-
Business Intelligence Analyst
-
Oct 2022 - Aug 2023
• Experience with extraction, processing, and visualization of relevant data to support business strategy.• Ability to create detailed management reports, focusing on storytelling and data visualization, using tools such as Power BI and DataStudio, having created over 10 dashboards for different areas of the company.• Automation of activities that were previously performed manually, using tools such as SQL, BigQuery, Power BI, and Google Sheets, resulting in a 30% time savings for certain activities.• Responsible for creating a ranking based on strategic indicators using BigQuery, with the aim of better organizing stores in the marketplace of the market vertical.• Build and lead processes and tools that aid in the definition of goals and objectives.• Calculation of order forecasts using data extraction and manipulation solutions from SQL and programming languages, generating accuracy of over 60%. Show less
-
-
Strategic Planning and Data Intern
-
Jun 2022 - Oct 2022
• Monitor key performance indicators (KPIs) and create and maintain operational dashboards.• Develop a PDCA cycle aimed at building an action plan for one of the company's main KPIs, resulting in actions that led to a 50% decrease in canceled orders due to stockouts.
-
-
Commercial Intern
-
Apr 2021 - May 2022
• Analyze and track KPIs using tools such as MySQL and Excel.• Participate in strategic discussions with other business areas based on data analysis.• Discuss action plans and design future plans based on data analysis.• Lead the project to update the dashboards used by the sales team, identifying needs, improvement points, and ideas for new visualizations.• Responsible for conducting weekly, biweekly, and monthly closings for the department.
-
-
-
TutorMundi
-
Brazil
-
E-Learning Providers
-
1 - 100 Employee
-
Tutor
-
Apr 2019 - Apr 2021
• Conducted over 1100 hours of classes, distributed across nearly 3000 tutoring sessions in 10 different subjects. • Conducted over 1100 hours of classes, distributed across nearly 3000 tutoring sessions in 10 different subjects.
-
-
-
UFSCar - Alumni
-
Brazil
-
Higher Education
-
700 & Above Employee
-
Bolsista de iniciação cientifica - PIBIC/CNPq
-
Mar 2020 - Aug 2020
• As a PIBIC/CNPq scholarship recipient, I was responsible for conducting both experimental investigation and modeling of the temperature effect on the production of lipolytic enzymes by the fungus Aspergillus niger C cultivated in agro-industrial waste. The goal was to obtain reliable kinetic parameters for future studies on heat transfer simulation in the bioprocess of lipase production for biodiesel in solid-state fermentation bioreactors. • As a PIBIC/CNPq scholarship recipient, I was responsible for conducting both experimental investigation and modeling of the temperature effect on the production of lipolytic enzymes by the fungus Aspergillus niger C cultivated in agro-industrial waste. The goal was to obtain reliable kinetic parameters for future studies on heat transfer simulation in the bioprocess of lipase production for biodiesel in solid-state fermentation bioreactors.
-
-
-
Semana de Engenharia Química - UFSCar
-
Brazil
-
Professional Training and Coaching
-
1 - 100 Employee
-
Vice-president
-
Aug 2018 - Sep 2019
• Developed a new scope for the vice presidency position, as it had been vacant for several administrations.• Created a plan to reach a wider audience for the chemical engineering week.• Managed the financial resources.
-
-
Marketing analyst
-
Oct 2017 - Sep 2018
• Developed a new visual identity for the Chemical Engineering Week at UFSCar, including logo, t-shirts for the organizing committee, and creative materials used during the management.• Responsible for leveraging the Instagram profile of the Chemical Engineering Week at UFSCar using digital marketing concepts.• Created campaigns on Facebook with the goal of spreading the brand to students in the same course at other universities.
-
-
-
Municipal City Hall of São José da Bela Vista
-
São José da Bela Vista, São Paulo, Brasil
-
Administrative assistant
-
Jan 2014 - Jan 2016
• Responsible for assisting with the administrative department's routine tasks, such as customer service, report tracking, spreadsheet development, and file control. • Focal point in developing specific projects within the department and also in collaboration with other departments in the city. • Responsible for assisting with the administrative department's routine tasks, such as customer service, report tracking, spreadsheet development, and file control. • Focal point in developing specific projects within the department and also in collaboration with other departments in the city.
-
-
Education
-
Universidade Federal de São Carlos - UFSCar Oficial
Engenheira Química