Gainesville, Florida, United States
Assay Design & Development | Laboratory Automation | Bioinformatics | Systems Integration. Advanced Microsoft Office/VBA | Power BI | Scripting | SAP | Product Information Management.
• Automate SAP transactions (primarily MM, PP, LO) using VBscript/VBA and Winshuttle. • Develop SAP queries using SQVI/SQ01. Automate SE16n data-extraction processes (RFC). • Design custom VBA-based user-interfaces to facilitate complex interactions with SAP. • Experience using Microsoft Power BI DAX and M query languages to process larger datasets. • Develop interactive dashboards to assess outcomes of digital-marketing campaigns. • Designed custom matching algorithm to associate web server log files with sales and customer master data. Utilized program output to assess adherence to data governance policy. • Administer Microsoft Access relational databases using VBA-embedded SQL. • Developed document and web data-scraping routines using Python, JSON, and VBA. • Experience integrating RFID and barcode scanners/printers to improve efficiency and data quality. • Provide customer consultation and enterprise-wide support for all internally-developed programs.
• Collaborated with the medicinal chemistry team to construct several DNA-encoded libraries (representing 350M molecules). Monitored synthesis with SDS-PAGE, qPCR, and LC/MS. • Created a VBA-based program to generate oligonucleotide sequences used to construct, extend, and amplify seventeen DNA-encoded libraries. • Designed and developed custom biomolecular assays and tools (custom qPCR, target-specific controls, LC/MS controls, oligonucleotide-antibody conjugations, PLA, aptamer design), • Executed post-library construction processing and purification procedures: DNA-encoded library extension, screen recovery quantification, material amplification/quantification for next-generation sequencing (Ion Torrent). • Collaborated with clinical target development teams to create an action plan for each project. • Prepared SOP documentation and trained associates to execute qPCR and amplification procedures. • Lead programmer and operator of the integrated robotics system used to QC the Texas Institute for Genomic Medicine (TIGM) mouse ES cell knockout collection. Automated ES cell-lysis, genomic DNA restriction-enzyme digestion, ligation, inverse-PCR, and Sanger sequencing procedures. • Worked directly with LIMS group to develop sample management database. • Created over 400 expression constructs as a member of the Expression Analysis group. Customized reading frames and generated site-specific mutations using fusion PCR. Developed a VBA tool to assess internal secondary structure to devise more efficient fusion PCR strategies. • Developed a semi-high throughput ES cell knockout QC procedure that significantly improved turnaround time and helped the group win the 2005 Innovation Award. • Utilized a wide array of web-based bioinformatics tools and databases (BLAST, BLAT, SMART, NCBI databases, UCSC GB, Uniprot, etc).