Lingyi Zhao Email & Phone Number

Boston, Ma, Us

Global, Cn

Boston, Ma, Us

• Independently owned the development of dashboards that enable Product & Operations to monitor trends in OKRs and root cause issues. Partnered with users to develop solutions and drive adoption, leading to identification of 4 major opportunity areas.• Assessed the impact to storefront funnel metrics when Wayfair’s merchants change the primary image for their SKUs. Analyzed clickstream data (Python, SQL) to select appropriate analytics technique and expose insights to Product in self-serve dashboard.• Reduced the time to identifying data quality issues from 1 week to 1 day by implementing data quality monitors for key data sources. Defined data quality checks and designed user-friendly Slack alerts that streamlined resolution.

Greenwich, Ct, Us

• Conducted feature-level analysis on commercial insurance transactions and implemented a 2-layer anomaly detection algorithm to effectively identify potential fraud and reduce false-positive cases.• Reduced the time-to-action for fraud cases from 1 week to near-real time by developing a RESTful Web API using Flask that provided real-time email alerts about anomalous activity.• Enhanced insurance pricing accuracy by 82% by analyzing data from third party vendors and building a GLM model to check and filter outliers.

Champaign, Il, Us

Advisor: Professor Ravi Mehta• Designed and executed experiments for projects about consumer behavior, including consumer well-being, creativity, and luxury consumption• Analyzed participants’ data and assisted projects from a luxury company about how AI affects the consumer’s decision making, providing marketing suggestions based on the analysis result

Champaign, Il, Us

Advisor: Dr. Jessica L. Montag and Dr. Jon A. Willits· Transcribed real-life audio into text and applied machine learning methods to better understand the development of children language · Participated in a National Science Foundation(NSF) project: Picture book reading- Investigating a key source of linguistic input for early language development, advised by Prof.Montag

Worldwide, Oo

• Developed conceptual and logical data models to assist data architecture migration for a bank loan department. Partnered with engineers to deploy and host tutorial sessions to help users smoothly transfer to the new system.• Standardized 2k+ metrics and 3k+ dimensions by defining new naming and mapping conventions. Constructed a relational database using SQL to improve the capacity and efficiency of the new business intelligence system.• Enabled faster decision-making and reduced weekly manual reporting errors for the loan business line by establishing a health-checking dashboard for primary OKRs using Tableau.

Master Of Science - Ms, Master Of Science In Analytics

Bachelor'S Degree, Econometric And Quantitatives