Marcelo Borges, Ph.D.

Marcelo Borges, Ph.D.

Technical consultant in data analysis and management

Followers of Marcelo Borges, Ph.D.632 followers
location of Marcelo Borges, Ph.D.Florianópolis, Santa Catarina, Brazil

Connect with Marcelo Borges, Ph.D. to Send Message

Connect

Connect with Marcelo Borges, Ph.D. to Send Message

Connect
  • Timeline

  • About me

    Data Scientist | R | SQL | Tableau | PowerBI | Statistics | DATASUS

  • Education

    • Federal University of Paraná

      2010 - 2012
      Master'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 - 2020
      Doctorate degree Ecology and Conservation

      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… 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 - 2009
      Bachelor's Degree Biological Sciences
  • Experience

    • PAHO/WHO

      Aug 2021 - Nov 2021
      Technical consultant in data analysis and management

      Consultant 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 2023
      Associate researcher

      Researcher - 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 2022
      Course developer

      Course 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 2023
      Associate researcher

      Systematic 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 2024
      Data 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

  • Volunteer Experience

    • Secretário

      Issued by Rotaract on Jul 2014
      RotaractAssociated with Marcelo Borges, Ph.D.
    • Sócio

      Issued by Rotaract on Apr 2013
      RotaractAssociated with Marcelo Borges, Ph.D.