
Marcelo Borges, Ph.D.
Technical consultant in data analysis and management

Connect with Marcelo Borges, Ph.D. to Send Message
Connect
Connect with Marcelo Borges, Ph.D. to Send Message
ConnectTimeline
About me
Data Scientist | R | SQL | Tableau | PowerBI | Statistics | DATASUS
Education

Federal University of Paraná
2010 - 2012Master's Degree Entomology"Research project involving dissertation development focusing on the study of network theory and complex network analysis (social network analysis) for biological data analysis, with the use of R programming."

Federal University of Paraná
2015 - 2020Doctorate degree Ecology and ConservationPh.D. thesis titled "Diversification Models in Antagonistic Interactions via Coevolutionary Processes," using computational modeling to study evolutionary processes.- My academic background included courses in statistical analysis for ecological data, covering various techniques of regression, univariate, and multivariate analysis.- I conducted a sandwich Ph.D. period as a visiting researcher at Stockholm University, Sweden, from September 2018 to March 2019. - I developed and… Show more Ph.D. thesis titled "Diversification Models in Antagonistic Interactions via Coevolutionary Processes," using computational modeling to study evolutionary processes.- My academic background included courses in statistical analysis for ecological data, covering various techniques of regression, univariate, and multivariate analysis.- I conducted a sandwich Ph.D. period as a visiting researcher at Stockholm University, Sweden, from September 2018 to March 2019. - I developed and enhanced my programming skills, including FORTRAN and R, and gained proficiency in tools such as Visual Studio. Show less

Universidade Federal do Paraná
2005 - 2009Bachelor's Degree Biological Sciences
Experience

PAHO/WHO
Aug 2021 - Nov 2021Technical consultant in data analysis and managementConsultant in data analysis and management for the Epidemiological Surveillance Directorate of the Municipal Health Department of Florianópolis.- Developed code and implemented a project to automate epidemiological notification processes, enabling daily database updates and facilitating rapid notification of individuals suspected or confirmed with diseases.- Implemented and enhanced database record linkage processes, allowing managers to assess the effectiveness of vaccination campaigns in reducing hospitalizations and mortality in the municipality.- Produced automated reports and dashboards for data visualization, and trained the team in using the developed tools. This enabled managers to regularly assess the municipality's epidemiological situation and guide evidence-based decision-making. Show less

CNPq - National Council for Scientific and Technological Development
Sept 2021 - Jul 2023Associate researcherResearcher - IDT-A Modality in the Project "Modeling the dynamics of SARS-CoV-2 transmission in Brazil: Real-time science to support evidence-based decision-making for managers."- Conducted extraction, cleaning, manipulation, and analysis of public health data (DATASUS), as well as parameterized and developed epidemiological models. This work resulted in generating evidence and scientific publications to support decision-making in public policies.- Developed data pipelines to analyze the vaccination database of the National Immunization Program Information System (SIPNI). This enabled processing large volumes of data and facilitated the creation of reports and studies to guide public management decisions.- Conducted analyses, wrote, and revised scientific articles, resulting in the publication of eight studies in international journals.Skills: R/RStudio · LaTeX · GitHub · Mathematical Modeling · Epidemiology · Data Analysis · Python · SSH Show less

ABRASCO
Mar 2022 - Oct 2022Course developerCourse developer for the e-learning course on Data Analysis for Epidemiological Surveillance, in partnership with ABRASCO and Instituto Todos pela Saúde (ITpS), with over 17,000 enrolled in Brazil.I was involved in producing the course curriculum and R analysis codes, writing educational materials, creating scripts for the course, and reviewing the produced content.

Consortium for Affirmative Actions Monitoring
Jul 2022 - Feb 2023Associate researcherSystematic analysis on the impact of the quota policy based on qualitative studies of the academic performance of quota students at UFSC (Federal University of Santa Catarina).- Performed data cleaning and standardization in R to analyze patterns of academic performance among university students, enabling the monitoring of policy implementation outcomes by researchers in the field.- Automated the generation of reports and performance analyses for these students, facilitating the analysis of a large number of students with varying levels of granularity by grouping. Show less

IQVIA
Aug 2022 - Feb 2024Data Analyst**Allocated to Roche Pharmaceutical in the Real-World Data (RWD) Team**- Contributed to the development of code and methodology in R for the extraction and analysis of the count of oncology patients treated by the SUS, facilitating scientific studies of real-world data (RWD) with external collaborators.- Developed the automation of reports in R Markdown, describing profiles of patients treated by the Brazilian Public Health System and creating mortality curves, which reduced the time to produce new reports and generated evidence for scientific studies.- Created dashboards in Tableau to map DATASUS patients undergoing treatment in different therapeutic areas, providing support and evidence for decisions on the feasibility of clinical studies and patient recruitment.- Collaborated with global teams to gather public health data from Brazil, supporting the modeling of temporal forecasts of disease incidence and estimating eligible patients for recruitment in clinical studies.**Skills:** R/RStudio · Tableau · GitHub · Hadoop · Amazon Redshift · DBeaver · SQL · Data Analysis Show less
Licenses & Certifications
- View certificate

Introduction to R
DataCampMay 2017
Volunteer Experience
Secretário
Issued by Rotaract on Jul 2014
Associated with Marcelo Borges, Ph.D.Sócio
Issued by Rotaract on Apr 2013
Associated with Marcelo Borges, Ph.D.
Languages
- poPortuguês
- inInglês
Recommendations

Leonardo borges
Desenvolvedor Full-Stack | PHP - Laravel - Symfony - PostgresRibeirão Pires, São Paulo, Brazil
Angga eriansyah setiawan
Code to deliver valueJakarta, Jakarta Raya, Indonesia
Sri krishna
Intermediate Data Analyst| Data Enthusiast (ML, Big Data)| Building Data-Driven Solutions (Python,SQ...Navi Mumbai, Maharashtra, India
Zainal abidin
Mine Plan Engineer | POP CertifiedSumenep, East Java, Indonesia
Leslie small, shrm-cp
Human Resources AdministratorGreater Boston
Eziz garlyyev
-- Sakarya Üniversitesiİzmir, Türkiye
Naila suci widyasari
Quality Assurance | Food Safety and Quality Management SystemIndonesia
Bartłomiej chmiel
Controlling Manager, ACCA StudentWarszawa, Woj. Mazowieckie, Polska
Raj kumar
AZ-500 | Cloud Security | Masters in Cybersecurity | SIEM | SOC | Cybersecurity | VAPT | Information...Chennai, Tamil Nadu, India
Abdulkarim abubakar, chrp
Banker || Accounting professional || Data Science & AIAbuja, Federal Capital Territory, Nigeria
Oksana slyva
Accounting Administrator at Domus Vita DesignToronto, Ontario, Canada
Adrian mutea
Senior Manager, Transfer Pricing at Forvis Mazars in RomaniaBucharest, Bucharest, Romania
Arturo salzano ☁
Vice President & LAC Head of Adoption Services Center SF Services Consulting, helping companies go b...São Paulo, São Paulo, Brazil
Minn paing soe fizel
Founder at Infi Tech Company LimitedMyanmar
Lyden naidoo
Financial Controller at Tsogo SunCity of Johannesburg, Gauteng, South Africa
Nazim hamidouchi
Economics & Business Studies at University of StirlingGreater Edinburgh Area
Dr. nitesh verma
Sports Physical TherapistSolan, Himachal Pradesh, India
Agus fakhru rizal
IT Planning Section HeadWest Java, Indonesia
Mirla lopez
Program Director II, Tilman J. Fertitta Family College of MedicinePasadena, Texas, United States
Benjamin poitou
Analyste/Concepteur/Développeur d'Application WebParis, Île-de-France, France
...