* Wrote an Application Entity (AE) using pydicom and pynetdicom to pull DICOM images to de-identified metadata using UC AIR* Develop python/SQL ETL pipelines that push and pull data from REDCap API to Oracle Database* Write reusable python libraries to interface with REST API and databases* Curate data from Identity Access Management (IAM) API, transform and map data to UC Profiles https://profiles.ucdavis.edu/* REDCap Technical Administrator* Velos eResearch Administrator* DocuSign Administrator

[Developer] • Build python/SQL data pipelines, i.e. extract, transform, and load (ETL), from REDCap API to Oracle Database• Maintain existing Pentaho ETL data pipelines• Provide research support for investigators• Automate admin tasks by developing python, bash scripts, and CLI tools[ Applications management ]• Technical administrator for REDCap• Database administrator for the Velos eResearch application• Data manager for Elsevier PURE and UC Profiles[ Front-end app support ]• Admin for clinical trials management systems (CTMS), i.e., Velos eResearch, REDCap, FreezerWorks etc. • Admin for ITHI DocuSign instance & ITHI Part 11 enabled module DocuSign instance[ Other ] • Generate confluence documentation to support internal staff on how-to use git, setting up a python environment, managing SSH keys, Oracle database driver installation etc.

• Extract baseline cancer screening data from HALO Clinic (FQHC look-a-like)’s EHR system using excel formulas and codes• Generate HPV vaccination rates, mammography rates, PAP testing rates, chronic HBV care rates, tobacco screening/cessation rates using ICD-10 codes, CPT codes, etc.• Coordinate training for primary care provider and clinical staff• Verify tables of data from HALO’s EHR custom reports

• Transform, reshape, and merge/join csv files (tables) of HPV immunization and vaccination data with python3.7 using Pandas and NumPy (de-identified data extracted from the EPIC Electronic health record (EHR) database backend by the CTSUβ )• Make data standardized and load output into STATA for statistical analysis, see sample code• Created local libraries of python classes specific to dataset for faster data transformation, see sample code• Collect Pre/Post-test survey data using qualtrics survey; generate plots/visualization with python3.7 using seaborn, matplotlib

• Culture transfected Chinese Hamster Ovary (CHO) cell lines to produce a stable source of the native HIV Env and gp140• Purify proteins by lectin-affinity columns• Characterization Env protein by Cryo-Electron Microscopy (Cryo-EM) using linux-based Boxer program• Biweekly present peer-reviewed articles relevant to my project to laboratory group members.

• Counsel students on the major requirements and provide guidance on course selection• Responsible for determining senior student’s eligibility for graduation

• Translate and assist medical students for screenings such as prostate cancer, breast cancer, cervical cancer and hepatitis B by handling blood draws samples, logistics of laboratory samples, and scheduling of patients• Act as receptionist, back floater, front floater, receptionist, & county referral • Train and tested new interns on vital taking skills, translation, and general knowledge of clinic• Interpret laboratory results; call and inform results to patients, providing doctor’s further instructions if necessary

• Developed linguistic and cultural competency; understand importance of humanism and emotional intelligence• Interacted with Mexican doctors; witnessed medical procedures such as live births (partos), c-sections, orthopedic surgery, emergency care, primary care, and traditional medicine (limpias)• Understand the pros/cons of the delivery and financing systems of the US and Mexican health system

• Teach new interns how to take blood pressure and to act professionally while translating• Assist medical students in translating, taking patient’s history, and procedures such as blood draws, fecal occult blood test, write-up of patient’s chart, etc.• Translate for medical students and doctors; cases include depression, complaints of pain and malaise, and general check-up