Yiqing Z. Email and Phone Number

- Publication: Song, J., Zou, Y., Wu, Y., Miao, J., Yu, Z., Fletcher, J. M., & Lu, Q. (2023). Decomposing heritability and genetic covariance by direct and indirect effect paths. PLoS genetics, 19(1), e1010620. https://doi.org/10.1371/journal.pgen.1010620- Constructed a novel statistical framework to estimate genetic correlation between traits based on 10k+ sibling data from UK Biobank, enabling distinction of different pathways that contribute to genetic correlations- Estimated 14 factors of interest in parallel with high-throughput computing by implementing a linear mixed effects model in Python & applying method of moments on both simulated & empirical genetics data- Established statistical power of the method by applying resampling-based block jackknife to compute parameter estimates variance.- Optimized cost of genetic matrices computation by 7X by incorporating random vectors in the computation logic

- Spearheaded the improvement of internal company-wide satisfaction for internal procurement process by ~20%, through analyzing 300k+ procurement order feedback using Excel & SQL and offering case-by-case suggestions on optimizing vendor selections.- Delivered analysis of the procurement database, identified data anomalies and categorical errors with SQL & Python, and recommended data quality improvement suggestions to reduce data discrepancies by ~18%.- Achieved automation of data integration, growth analysis, and periodic procurement growth reports generation in Python on weekly procurement orders in support of performance analysis and strategic planning, saving 90% excel workloads.