Aurelia Ayala Usma Email & Phone Number

Bogotá, Bogota, CO

Bogota, D.C., Capital District, Colombia

Colombia

- Developed a bilingual Q&A chatbot app in Databricks to answer questions about procedures and functions of the Colombian Institute of Family Welfare (ICBF in Spanish). Web scraping and data pre-processing was carried out using Selenium, BeautifulSoup, Spark, Pandas, and Delta Lake. The chat model was built using LangChain implementing FAISS Vector Store.

Colombia

- Established and implemented Data Stewardship policies for Salesforce CRM with the data Governance Committee aiming to avoid introducing data gaps and inaccuracies in the creation of potential new customer records, and to solve existing data issues in existing records using BigQuery and Python.- Solved 1298 data quality issues in Salesforce accounts.

Colombia

- Created an automated strategy for the data enrichment of >6K Salesforce account records using BigQuery, Python scripts, and Clearbit data provider to bridge data gaps found in the CRM database that hindered financial reporting and marketing efforts.- Provided ad-hoc analyses to Sales Operations team on customer data distributed across CRM, subscriptions.

Colombia

- Lecturer for the "Data Analysis and Big Data: Analytics for Business Solutions" Diploma course- Topics covered: Python Programming, Neural Networks, Support Vector Machines, Databases, SQL, Big Data Environments.

Colombia

- Redesigned and maintained pricing algorithms for the voice and video products that drive ~90% of the revenue of the company. This involved data modeling, A/B testing, and back-end development in Python. This resulted in a 45% YoY increase in revenue for emerging non-English Voice projects and the launching of the Video product line in Q1 2021..

Colombia

- Led a team of 3 people in the creation and maintenance of the entire Business Analytics infrastructure of the company. This included the entire data cycle from Data Capturing (Segment, Snowplow), ETL (AWS DMS Lambda), Warehousing (Redshift, AWS Postgres RDS), (K)PI standardization and logic development, to Visualization/Dashboarding (AWS EC2, Metabase)..

Bogotá D.C. Area, Colombia

- Reconstructed the whole genome of two plant pathogens species of the genus Phytophthora using 16.7 GB of PacBio SMRT and Illumina whole-genome DNA sequencing datasets. This work resulted in two publications reporting the open-source genomic and computational resources produced for these two important agricultural pests. The project was done in.

Bogotá

- Scientific translator for Biomedical Industry. - Specialty areas: Pharmaceutical Documentation, Medical Devices, and Regulatory Affairs.

Bogotá, Colombia

- Performed anatomical identification of 4 tropical subfossil and modern woods from Colombia, and 10 modern woods from Chinchero Archaeological Center, Perú.- Analyzed δ13C isotopic data derived from a subfossil wood sample for paleoclimatic and biogeochemical inference.- Designed PCR primers targeting common chloroplast markers (trnL, matK, etc.) for.

Bogotá, Colombia

- Isolation of microorganisms resistant to pollutants in soils and wastewaters from oil-exploitation activities.- Perform functional experiments of biorremediation of petroleum pollutants and heavy metals upon the previously mentioned isolates.- Standardization and implementation of a spectrophotometric method for barium quantification.

Bogotá, Colombia

- Lecturer of Biology and Biochemistry for Health Sciences and Environmental Engineering students.- Curriculum evaluation and test design of Biology and Biochemistry courses.

Bogotá, Colombia

Molecular biology wet-lab contestant. Team Colombia at the International Genetically Engineered Machine Competition (iGEM 2012). http://2012.igem.org/Team:Colombia- Primer design, gene amplification, and molecular cloning of genes from Aliivibrio fischeri.- Synthetic DNA construct evaluation and design.

Bogotá, Colombia

Molecular biology wet-lab contestant. Team Colombia at the International Genetically Engineered Machine Competition (iGEM 2012). http://2012.igem.org/Team:Colombia- Gene amplification, and molecular cloning of genes from Aliivibrio fischeri.- Semi-quantitative RT-PCR gene induction assays.- Scanning Electronic Microscopy of leaf tissue colonized by.

Master’S Degree, Computational Biology

Graduate program with emphasis in Bioinformatics, Scientific Programming, and Data Analytics.

Data Science

Fellow of the Data Science for All (DS4A) / Colombia 6.0 Program

Bachelor Of Science (B.Sc.), Biology, General

Bachelor Of Science (B.Sc.), Microbiology, General