1 Personal Data

Name: Fernando Roa
E-mail: froao at unal.edu.co
Skype: ferroao


2 Summary

I have worked as freelance (B2B) building Shiny Apps, including making reports (from SQL data)

I have experience working with and developing databases (mongo, SQL), scientometrics (https://cyto.shinyapps.io/cerrado/) and programming including the R language, R-shiny, excel VBA, bash, python. I also have experience in downloading databases with scripts (R, python).

I took the data science course from CorrelationOne, including Jupyter notebooks, SQL and mongo databases, Python libraries to generate data visualizations, perform exploratory data analysis, and analyze data using Pandas. Also included use of different Data Science and AI techniques, such as Decision Trees and the use of kNNs, CNNs, NLP.

I speak English (see TOEFL), Portuguese (lived > 10 y. in Brazil), spanish (Native - Colombia) and some German (german highschool).


4 Professional experience

4.1 Freelance Shiny Developer2022-present

Main activity: Shiny Interfaces and Backend
Projects: - Modify Shiny Apps to use Shiny modules - Backend and Frontend for Production of .pdf .docx reports, from SQL queries
Institution: Home Office B2B
Begin: feb-2022    End: present

4.2 Post-doc2014-2019

Main activity: Research in Plant molecular cytogenetics; Teaching in undergraduate and post-graduateScholarship: CAPES
Projects: - Plant cytogenetics database of Cerrado
- Reconstruction of ancestral characters in the phylogeny of Fabaceae
- Reconstruction of ancestral characters in the phylogenetic context of genus Callisia
- Genome size of plants of Cerrado
Institution: Universidade Federal de Goiás, Goiânia, Brazil. PPGMP Agronomia
Inst. contact: +55-62-3521-1688
Begin: feb-2014    End: jan-2019

4.3 School teacher2013

Main activity: Sciences
Institution: INEM Francisco de Paula Santander, Bogotá - SED
Inst. contact: +57-1-3241000
Begin: mai-2013    End: jan-2014


5 Main Degrees

5.1 Doctorate2007-2011

Title: Plant BiologySistematics
Diploma date: jul-02-2012Scholarship: CNPq – Research funding agency - Brazil
Universidade Federal de Pernambuco, Recife, Brazil
Thesis: Analysis of the distribution of 5S and 45S rDNA sites in plant karyotypesSupervisor: Marcelo Guerra
Keywords: database, ribosomal DNA, FISH, molecular cytogenetics. language: portuguese
link: https://repositorio.ufpe.br/handle/123456789/747
Other projects: - Citotaxonomy of Aristolochia
- Citotaxonomy of Tripogandra
- Citrus Heterocromatin
Grade average: 4.3 (from 0.0 to 5.0)

5.2 Master2006-2007

Title: Plant BiologySistematics
Diploma date: jul-05-2010Scholarship: CAPES – Education funding agency - Brazil
Universidade Federal de Pernambuco, Recife, Brazil
Thesis: Molecular citotaxonomy of genus Callisia (Commelinaceae)Supervisor: Marcelo Guerra
Keywords: Molecular cytogenetics, FISH. language: portuguese
link: https://repositorio.ufpe.br/handle/123456789/966
Grade average: 4.0 (from 0.0 to 5.0)Theses - aproved with disctinction

5.3 College

Title: BiologyGenetics
Diploma date: sept-15-2005
Universidad Nacional de Colombia
Thesis: Cytogenetic analysis with 4MV X-radiation of cells of early onset Alzheimer patients and controls (Instituto de Genética Humana, PUJ)Supervisor: Gloria Osorio, Marta Lucía Bueno
Keywords: cytogenetics, Alzheimer. language: spanish
link: http://www.bdigital.unal.edu.co/8057/
Grade average: 4.0 (from 0.0 to 5.0)with honors, tuition payment exemption

5.4 High-School

Title: High school graduateSciences
Diploma date: jul-15-1995
German School, Bogota. language: spanish-german
Grade average: 8.1 (from 0.0 to 10.0)


6 Language proficiency

6.1 English

TOEFL-ITP; TOEFL657/677; 103/120
C1; C12018; 2012

6.2 Portuguese

CELPE-BRASHigher intermediate
B22011

6.3 German

Sprachdiplom IIPassed
B2-C11995


7 Articles

7.1 The Cerrado (Brazil) plant cytogenetics database2017

Roa, Fernando; Telles, Mariana Pires de Campos.  Comparative Cytogenetics.  11.  285–297
https://compcytogen.pensoft.net/article/11395/
Repo.: https://gitlab.com/ferroao/cerradocytopu
Web-page: https://cyto.shinyapps.io/cerrado/

7.2 Non-Random Distribution of 5S rDNA Sites and Its Association with 45S rDNA in Plant Chromosomes2015

Roa, Fernando; Guerra, Marcelo.  Cytogenetic and Genome Research.  146.  243–249
https://www.karger.com/Article/FullText/440930

7.3 Distribution of 45S rDNA sites in chromosomes of plants: structural and evolutionary implications.2012

Roa, Fernando; Guerra, Marcelo.  BMC Evolutionary Biology.  12.  225
http://www.biomedcentral.com/1471-2148/12/225

7.4 Karyotype differentiation in three species of Tripogandra Raf. (Commelinaceae) with different ploidy levels2010

Marques, Andre; Roa, Fernando; Guerra, Marcelo.  Genetics and Molecular Biology.  33.  731–738
http://dx.doi.org/10.1590/S1415-47572010005000085

7.5 Cytotaxonomy of diploid and polyploid Aristolochia (Aristolochiaceae) species based on the distribution of CMA/DAPI bands and 5S and 45S rDNA sites2009

Berjano, Regina; Roa, Fernando; Talavera, Salvador; Guerra, Marcelo.  Plant Systematics and Evolution.  280.  219–227
http://link.springer.com/10.1007/s00606-009-0184-6


8 Software: packages, scripts, pages

8.1 Python/R code; Shiny-App: NLP for community feedback

Repo.: https://gitlab.com/ferroao/nlpfeedback


8.3 Python/R scripts: linkScraping: Creating a .bib library from journal html pages

Repo.: https://gitlab.com/ferroao/linkscraping


8.4 Shiny-App: Cytogenetics characteristic evo modeling

Repo.: https://gitlab.com/ferroao/cytoevopri
Web-page: https://cyto.shinyapps.io/cytoevo/

8.5 R Scripts: Reading databases

Repo.: https://gitlab.com/ferroao/getdatabase


9 Lectures

9.1 Cytogenetics40h

Graduate2015.I
Universidade Federal de Goiás

9.2 Cytogenetics64h

College2014.I
Universidade Federal de Goiás


10 Mentoring

10.1 Undergraduate research

Student: Daniella Rezende
Institution: Universidade Federal de Goiás01-08-2014 - 31-07-2015


11 Courses taught

11.1 Evolution of cytogenetic characters in the phylogenetic context 5h

VI Reunião Brasileira de Citogenética e Citogenômica, Goiânia21 05/2019

11.2 Molecular and classic Citogenenetics in plants6h

XXV Semana do ICB, Universidade Federal de Goiás18-20 11/2014


12 Talks in Events

12.1 Poliploidy and genome duplication Brazilian legumes

70 Congresso Nacional de Botânica.  portuguese25-10-2019
Maceió, Alagoas, Brazil

12.2 Cytogenetics for resolving evolutionary questions

Encontro da liga acadêmica de genética.  portuguese27-04-2018
UFG. Goiânia, Brasil

12.3 Reconstruction of ancestral states of cytogenetic characters in Leguminosae

Reunião de citogenética do Brasil Central.  portuguese20-10-2017
UCG. Goiânia, Brasil

12.4 Database of Plant Cytogenetics. Current situation of the field

Reunião de citogenética do Brasil Central.  portuguese08-12-2016
UCG. Goiânia, Brasil

12.5 Distribution of 5S and 45S rDNA sites and implications

II Simposio de Genética.  spanish28-05-2012
Universidad del Quindío. Armenia, Colombia

12.7 Cytogenetics and Molecular cytotaxonomy of species of genus Callisia Loefl. (Commelinaceae)

II simposio Latinoamericano de citogenética y evolución.  spanish17-08-2007
UN, Palmira, Colombia


13 Congress presentations and abstracts

13.1 Splitting is the answer. Cytogenetics and systematics analyses of Callisia Loefl. (Commelinaceae)Poster

Roa F, Pellegrini MOO, Vaio M, Guerra M21-24 05/2019
VI Reunião Brasileira de Citogenética e Citogenômica.  Goiânia

13.2 The Cerrado Plant cytogenetics databasePoster

ROA, F; Telles, MPC08-11 11/2016
IV Congresso Brasileiro de Recursos Genéticos.  Curitiba
Anais do IV Congresso Brasileiro de Recursos Genéticos.  portuguese

13.3 Genome size and chromosome counts in Brazilian Cerrado spermatophytesPoster

ROA, F; Antunes, AM ; Souza, LGR ; Telles, MPC26-29 05/2015
4 Reunião Brasileira de Citogenética.  Atibaia
Trabalhos da 4ta RBC.  portuguese

13.4 Distribution of 5S and 45S rDNA sites in plant chromosomesTalk

Guerra M, Roa F23-25 04/2012
Gatersleben Research Conference.  IPK Gatersleben, Germany
Annals of the Gatersleben Research Conference.  53

13.6 Preferential position of 5S ribosomal RNA genes in plant genomesPoster

Roa F, Guerra M31-03 04/2009
II Brazilian Symposium of Molecular genetics.  Búzios, Brasil
Annals of the II Brazilian Symposium of Molecular genetics.  180.  portuguese

13.7 Chromosomal variation of heterochromatin and 5S and 45S rDNA in species of AristolochiaPoster

Roa F, Berjano R, Guerra M02-05 09/2007
53 Brazilian congress of genetics.  Aguas de Lindóia, Brasil
Annals of the 53 Brazilian congress of genetics.  56.  portuguese

13.8 Cytogenetics and molecular cytotaxonomy of species of genus Callisia Loefl. (Commelinaceae)Talk

Roa F, Guerra M15-18 08/2007
II Latin-American symposium of cytogenetics and evolution.  Palmira, Colombia
Annals of the II Latin-American symposium of cytogenetics and evolution.  217.  portuguese

13.9 Cytogenetics of a spontaneous tetraploid of Nothoscordum pulchellum Kunth (Alliaceae)Poster

Roa F, Guerra M06-10 11/2006
57 National congress of Botany.  Gramado, Brasil.  portuguese

13.10 Contrasting chromosome patterns in three species of genus CallisiaPoster

Roa F, Guerra M03-09 09/2006
52 Brazilian congress of genetics.  Foz do Iguaçú, Brasil
Annals of the 52 Brazilian congress of genetics.  1107.  portuguese

13.11 Transport of biomass by Atta laevigata Smith (Formicidae) in the eastern plainsPoster

Velasco P, Roa F06-10 10/2003
III Scientific meeting of biology students.  Bogotá, Colombia
Acta Biológica Colombiana, Vol. 8 No. 2.  117.  spanish


14 Taken Courses and Workshops

14.1 Data Science for All (ds4a)Theoretical and Practical Course

Correlation One375h
20/05-10/09 2021

14.2 Linux CourseTheoretical Course

Geek University https://geek-university.comterm
23/01-24/02 2020

14.3 Introducing pythonTheoretical and Practical Course

Universidade Federal de Goiás, Goiânia, Brasil80h
Portuguese28/07-09/08 2019

14.4 Flow cytometryTheoretical and Practical Course

Universidade Federal de Pernambuco, Recife, Brasil15h
30/11-02/12 2015

14.5 Isolation of cells by Splitt and acoustofluidicsTheoretical Course

Universidad Nacional de Colombia. Centro Internacional de Física32h
Spanish28/01-08/02 2013

14.6 Engativa Wetlands 2013Course

Jardín Botánico de Bogotá60h
Spanish30/09-30/11 2013

14.7 2nd Biological evolution workshopWorkshop

Universidade Federal de Rio Grande do Sul, Porto Alegre, Brasil24h
16/11-18/11 2009

14.8 Identification and characterization of gene function in plants and microorganismsTheoretical Course

Universidade Federal Rural de Pernambuco, Recife, Brasil20h
Portuguese28/07-01/08 2008

14.9 Stem cells, facts, fiction and futureCongress Course

53 Brazilian congress of genetics, Águas de Lindóia, Brasil3h
Portuguese02/09-05/09 2007

14.10 Cytogenetics in the diagnosis and genetic counseling of recurrent abortionCongress Course

II Latin-American symposium of cytogenetics and evolution, Palmira, Colombia4h
Spanish15/08-18/08 2007

14.11 Chromosomes and phylogeny: The use of cladistics in cytogeneticsCongress Course

52 Brazilian congress of genetics, Foz de Iguaçú, Brasil3h
Portuguese03/09-09/09 2006

14.12 Physical mapping and positional cloning in plantsCongress Course

52 Brazilian congress of genetics, Foz de Iguaçú, Brasil3h
Portuguese03-09-09/09 2006

14.13 Basic and molecular cytogenetics Training

Instituto de Genética Humana, Bogotá, Colombia2520h
Spanish15/09-15/12 2002

14.14 Animal cell cultureTheoretical and Practical Course

Instituto Nacional de Salud, Bogotá, Colombia84h
Spanish04/06-14/07 2001

14.15 Transgenic plantsTheoretical Course

Universidad Nacional de Colombia, Bogotá, Colombia19h
Spanish23/06-24/06 2000


15 Military service

Escuela de Ingenieros Militares, Bogotá, Colombia15-07-1995 - 21-07-1996