Department of Bioethics and Humanities EDGE Study | PIs: Deborah Bowen, PhD, Elizabeth Swisher, MD▪️ Designed and managed research database for $5 million U01 EDGE Study▪️ Orchestrated data collection for 50,000+ research participants in 12 primary care clinics.▪️ Created complex REDCap surveys and streamlined data extraction using REDCap's API and Python scripts in Jupyter Notebook.▪️ Identified potential budget shortfall and revised study protocol using budget projections.▪️ Facilitated training in Atlas.ti to support qualitative data analysis▪️ Produced project summary reports, data visualizations, and custom data analysis.

Surgical Outcomes Research Center (SORCE)▪️ Directed ongoing use of, and training in, the DatStat electronic data collection platform for multiple studies and research personnel in 20 different sites across the country.▪️ Reduced time coworkers spent setting up mailing lists by writing macros to manipulate and clean data in Excel.▪️ Established single IRB for 2 large multi-site studies, creating templates and SOPs for navigating the intricacies of this new process.▪️ Managed the DEBUT Study, including budget, staff training, preparing data for analysis, and completing progress reports.

Surgical Outcomes Research Center (SORCE)Studies: CODA, DEBUT, CISTO, COSMID | PIs: David Flum, MD, MPH, John Gore, MD, MPH▪️ Directed use of the DatStat data collection platform for multiple studies: training staff, ensuring proper workflow, implementing adjustments and enhancements to existing programming.▪️ Oversaw Institutional Review Board (IRB) applications and paperwork for multiple studies at more than 20 different sites.▪️ Developed study materials, designing and building REDCap databases and using InDesign for paper surveys.▪️ Produced monthly reports of recruitment and data collection progress using PowerBI and a python script.▪️ Assisted with data preparation, manuscript planning, and grant applications.

Surgical Outcomes Research Center (SORCE)▪️ Mastered the DatStat data collection platform in just over 1 month, to manage 6 projects with 10,000+ records.▪️ Overhauled workflow programming, eliminating dozens of errors, significantly reducing staff burden and patient complaints.▪️ Performed full systems development life cycle for 3 new research projects: obtained user input, designed, tested, implemented, and maintained complex DatStat study workflow architecture, and planned enhancements and approaches for future projects.▪️ Created 20+ custom electronic surveys, incorporating variable piping, calculations, sliders, a print option, and a signature pad, using HTML, CSS, and JavaScript.▪️ Refined reports of aggregate patient data designed for physicians using Jaspersoft business intelligence software, collaborating on a number of aspects: ETL processing, SQL database design and LaTeX customization.▪️ Created reference documents for clinic staff and physicians, explaining access to a patient survey portal and online reporting interface.▪️ Handled invoicing and payments for vendors.

Surgical Outcomes Research Center (SORCE)CINCO Study | PI: David Flum, MD, MPH▪️ Achieved 51% response rate for survey sent to over 500 surgeons.▪️ Worked with surgeons to develop 4 oncology data modules for the Surgical Care and Outcomes Assessment Program (SCOAP); built forms in REDCap.▪️ Navigated 6 different EMR systems, extracting cancer data.▪️ Managed forms, requirements, and deadlines for 5 different IRBs.

▪️ Data manager for National Comprehensive Cancer Network (NCCN) breast cancer database.▪️ Interpreted patient medical records, entered cancer-specific data into Oncolog© following detailed guidelines, and corrected logic errors.▪️ Created reference manual utilized by fellow employees.

Studies: EAT 5 for Life, MOVE ‘M and PACE PI: Shirley Beresford, PhD, MSc, MA