Created the Risk and Compliance Data Lake Model to house service failure data to enable customers to relate disparate data sources for actionable intelligence. Presented project proposals to key decision makers to help shape their business. Created automated reports in AWS Quicksight for risk reduction programs that reduced their time to analysis from a week to half a day. Built a reference guide for the Data Lake including, example joins, example dashboards, data dictionaries, and a roadmap for future dashboards and data ingestion to empower customers. Provided curated compliance data to beta customers for their ROI business cases to highlight gaps and risks empirically. Identified key missing data that was causing data quality issues when relating various data sources together and resolved it by engaging engineering to gather the missing data. Built pipelines using AWS Glue, Athena, S3, Redshift, and Redshift Spectrum. Setup Version Control for both ETL, analytical queries, and Quicksight dashboards for instant rollback to minimize customers’ loss of service.

Mindstrong | Jan 2022 - Aug 2022

Senior Data Analyst

● Performed exploratory data analysis for various psychology institutions’ submissions. ○ Created data sets and dashboards in Mode for the APS conference looking at patient engagement defined by whether or not patients were completing the clinical assessments. ○ Suggested additional metrics to the clinical psychologists around assessments, therapist sessions, and therapist provided scores (CGI). ● Created custom data sets using mySQL in Mode to help with DSM-5 L2 depression and anxiety assessments metrics (200+ million rows). ○ Designed cohorts for depression L2, Anxiety L2, and all L1 patients then created comparative analyses around therapy session attendance, assessment completion rate, and time-series change of scores. ● Created dashboards in Mode to track clinical OKRs and KPIs. ● Identified key missing data and solved the issue by creating a complex SQL query to cover the hole until engineering instituted a fix. ● Participated in the creation of internal research policies (worked with the clinical operations and data science teams).

AliveCor Inc. | Mar 2020 - Dec 2021

Business Intelligence Analyst

data commercialization. ● Initiated and evangelized data democratization efforts within this growing analytics team by deploying Metabase on Elastic Beanstalk using RDS and migrating all existing reporting. ○ Implementing Metabase along with an AWS Redshift Data Warehouse reduced analytics cost by 10x. ● Streamlined billing reports for the Accounting and Enterprise Sales teams by creating a one-stop shop dashboard in Metabase. ○ Cut time to billing by 60%, allowing teams to spend more time selling than creating reports. ● Created dashboards for Product, Sales (Enterprise, Providers, and Consumer), Marketing, Legal, BioPharma, Manufacturing, and Executives in Metabase using SQL and created dashboards in JIRA for Security. ○ SaaS (# of hospitals/doctors). ○ Various subscriptions ○ In app user tracking for the Product and UX/UI teams. ● Generated potential leads for BioPharma business development team using a custom-created Python based search engine. ● Reviewed and optimized existing SQL queries for accuracy and performance (lightened load on AWS resources). ● Suggested and built additional metrics and reporting to drive actionable change. ● Performed root cause analysis on data sets (50+ million rows); discovered many flaws in user reporting within various product lines, helped engineering to implement the fixes and assisted Marketing in re-engaging affected customers. ● Verified a potential cost-savings cost-benefit analysis from an external consultant for the Chief Clinical Officer. ● Wrote and maintained technical and functional data product specifications, assisted the data team with knowledge sharing and on-boarding practices for new members. ● Created insightful storytelling interactive dashboards on sales and marketing performance for VPs and C-suite level individuals, supporting their strategic initiatives.

Genentech | Apr 2017 - Jan 2020

Senior Data Analyst

● Reduced the cost of several multi-million-dollar clinical trials by improving site selection methodology and operations by leveraging claims data, disease demographics and historical clinical trials data. ○ Accelerated start-up times for clinical studies. ○ Tracked Key Clinical Indicators using Tableau for clinical operations leadership. ○ Created custom analytical tools using Python for fellow analysts to use during clinical operations scenario planning meetings. ■ Allowed for sublinear optimization of analytics resources. ● Developed and delivered business relevant analyses using Python and Tableau dashboards for all levels of the Early Clinical Development (ECD) department (e.g. leadership, support, project team) for data driven decision-making. ● Communicated effectively with multiple stakeholders across therapeutic areas such as Breast Cancer, Gastric Cancer, various Hematological Cancers, and Ophthalmology. ● Discovered data quality issues and performed root cause analysis in the data warehouse using SQL to determine source and potential solutions for the database team. ○ Flagged them to prevent their use by other internal teams. ○ Augmented using proxy data to improve data quality, where appropriate. ○ Data sets ranged from a couple thousand rows to a couple million rows of data.

BioClinica | Nov 2015 - Mar 2017

Clinical Operations Associate

DATA MANAGEMENT ● Performing oversight duties on data: validate and maintain clinical data per Bioclinica standards and GCP-ICH & HIPAA guidelines ● Using StudyDirect (EDC) to review submitted patient data and create and issue queries through edit checks for high data quality ● Generating and verifying Excel and PowerPoint based patient reports prior to distribution to Clients and Sponsors ● Basic understanding of edit check logic OPERATIONS MANAGEMENT ● Following up with outstanding documentations from clinical sites to complete site qualification ● Maintaining operation’s portion of the TMF for 7 studies ● Archiving study documents and reports for future audits STUDY START UP ● Collaborating with Clinical Project Management, Clinical Data Management, Imaging Technologists, Radiologists and Senior Scientists for vendor evaluation per study specific qualifications SUPPORT ● Participating in UAT for communication management on Salesforce ● Training on CRF design using Adobe InDesign with Clinical Data Management ● Performing data analysis using Excel

My Education

Take a look at my formal education

Master’s Degree, BiotechnologySan Jose State University | 2018

Bachelor’s Degree, Biochemistry and Molecular BiologyUC Davis | 2015

About Me

I am experienced in stakeholder management and anticipating what kinds of analysis different departments require. I have setup an entire reporting side of BI infrastructure while delivering actionable insights.

Create Your Data Portfolio for Free