Marcelo Carvalho Email and Phone Number
Profissional com perfil analítico, orientado a dados e resolução de problemas, ajudando na geração de valor e receita através de análises de negócio voltadas para estratégias digitais. Tenho experiência nos ramos de Marketing, Saúde e Logística/Gerenciamento de Risco, principalmente focado em análises de métricas e KPIs de Mídia (no contexto de Marketing Digital) de plataformas como Google Analytics, Google Ads e Facebook Ads para monitoramento da performance de campanhas de marketing digital em todas as etapas do funil da jornada de clientes. Atuo hoje como Coordenador de Business Intelligence no ramo de Marketing Digital (segmento hospitalar), na fronteira entre o BI e o CRM; sou ponto focal de contato entre 10 times de Marketing e mais de 5 times de TI diferentes, sendo responsável nacional pelo projeto de CRM e responsável por dois projetos de integração de dados, focados principalmente em aumentar rentabilidade da base instalada de pacientes e, também, ativar novos leads coletados via campanhas de mídia paga automaticamente. Atuo também na extração e segmentação da audiência, alinhamento e validação de querys e regras de negócio de múltiplos bancos de dados, além de atuar na mensuração de resultados e elaboração de apresentações executivas e painéis em PowerBI, bem como auxiliando em análises críticas de performance de campanhas, audiências e criativos.Tenho sólidos conhecimentos na construção de dashboards para mensuração de métricas de negócio e de mídia utilizando as plataformas PowerBI e Google DataStudio.Tenho também conhecimento na extração de dados via consultas a bancos de dados transacionais utilizando SQL, trabalhando cominformações hospitalares e tendo atuado também no ramo farmacêutico. Por fim, além de SQL, sou proficiente em Excel e tenho também sólidos conhecimentos de programação em Python - linguagem que uso diariamente - (com ênfase nas bibliotecas Pandas, Numpy, Matplotlib e Scikitlearn) e Matlab, além de conhecimentos de integração entre SQL-PowerBI, PowerBI-Python e SQL-Python. Atualmente estou expandindo meus conhecimentos em programação em Python, com ênfase em Machine Learning e Ciência de Dados, com foco em clusterização.
Vision One
View-
Business Intelligence Coordinator - MarketingVision One Apr 2024 - PresentAs Vision One's Marketing Data Coordinator, my responsibilities include:- Audience scope definition and discussion involving multiple marketing, business and IT stakeholders across 10+ different hospitals, including creative performance, business logic, code and SQL queries reviews. - Results and impact mensuration of national CRM campaigns, reporting more than USD500k incremental revenue vs randomized control groups since January 2024 and reporting almost 16% growth QoQ.- CRM platform operation training for new Marketing members. - Automation of national CRM campaigns:CRM data integration project lead, responsible for allignment and follow-up with IT national team and external partners for technical business rules implementation and data transfer from external sources to CRM platform's databases via API.Construction of data suitable for automatic API transfer in allignment with IT teams.Construction, testing, validation and activation of automated CRM journeys.- Data extraction, manipulation, analysis and all Data Analyst's responsibilities.- National responsible for Marketing KPI's and metrics.- Construction of a patient clusterization machine learning model to fuel new CRM campaigns and increase revenue (in early stages).- Team and project mangement in several different data-related projects (CRM, Data Integration, Patient Support), focusing on new patient activation and LTV increasce of acquired patients.
-
Business Intelligence AnalystVision One Apr 2023 - Mar 2024São Paulo, São Paulo, BrazilDesign of automated ETL process between Power BI and Google Sheets (extracting data from Google and Facebook Ads accounts via Adveronix connector) with daily updated data from all hospitals in the group.Consolidation of digital media data, CRM data and hospital business info.Construction of executive automated PowerBI dashboards for daily follow-up of paid media (Google Ads and FB Ads) and CRM marketing campaign performance, patient support metrics and medical-related hospital data. Extraction, consolidation, cleansing and manipulation of historical patient data from ophtalmologic hospitals.Full-funnel marketing campaign audience analysis according to business strategy through segmented extraction and manipulation of data using Pandas (Python) and SQL (Oracle SQL Developer, SQL Server, MySQL, Firebird).Preparation, upload and maintenance of data in CRM platform Insider. Email and SMS audience preparation and messaging according to creative directives and follow-up of CRM campaign performance.Analysis of hospital business results aiming audience impact mensuration of all CRM campaigns, measuring appointments and medical procedures and result comparisons with control groups.Elaboration of executive Power Point presentations and PowerBI dashboards to divulge CRM and business results.Construction of complex ad hoc analysis and dashboards supporting other company areas, such as Strategic Planning and Pricing.Internship candidate screening, selection, interview and test case elaboration for Vision One's Marketing team.First Data Analyst of the team, I was responsible for the training, development and support of an intern, as well as interface with internal IT teams and external partners. Co-responsible for the automation of CRM campaigns, including allignment with IT team, design, preparation and testing of communication journeys.
-
Business Intelligence AnalystBrk Tecnologia Nov 2022 - Apr 2023São Paulo, São Paulo, BrasilIntegration of all the company's business data related to risk managent. Construction of PowerBI dashboards to monitor trips, vehicles, drivers and accidents for all of the company's operations.Implementation of Python algorithm to automate email communication and dashboard link sharing to insurance companies and insurance brokers. -
Data Analyst InternZmes Jan 2022 - Sep 2022São Paulo, São Paulo, BrazilData extraction, manipulation and analysis (via Amazon Redshift and using SQL).Creation of Dashboards and Reports containing both business and digital media metrics (Facebook Ads, Google Ads, Google Analytics etc) and KPIs using Google DataStudio.Support in executive PowerPoint presentations to clients. -
Project Management InternFramför Sep 2021 - Dec 2021Development of preliminary budget analysis for small scale airports. Contact with prospect partners to map business opportunities.
Marcelo Carvalho Education Details
-
Data Science -
Mechanical Engineering
Frequently Asked Questions about Marcelo Carvalho
What company does Marcelo Carvalho work for?
Marcelo Carvalho works for Vision One
What is Marcelo Carvalho's role at the current company?
Marcelo Carvalho's current role is Business Intelligence Coordinator @ Vision OneData Analytics | Business Intelligence CRM | SQL | Python | PowerBI.
What schools did Marcelo Carvalho attend?
Marcelo Carvalho attended Universidade De São Paulo, Universidade Estadual De Campinas.
Not the Marcelo Carvalho you were looking for?
-
Marcelo Castro
São Paulo, Sp -
Marcelo Carvalho
São Paulo, Sp1sap.com3 +551155XXXXXX
-
2gmail.com, bmfbovespa.com.br -
Marcelo Carvalho
It Senior Manager - It Pmo Leader Latam & Portfolio Manager Intercontinental At Ge HealthcareSão Paulo, Sp
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial