Yuling Wang Email & Phone Number

Kirkland, WA, US

Seattle, WA, US

• Current Team: Amazon Shipping (2023/5~)Prime Video Product Analytics (2019-2021)XCM (Cross-Channel Marketing Measurement) Engineering Science (2021-2023)Reporting Dashboards, Data Pipelines and Automation
• Led the analytics initiatives to build marketing campaign configuration database and established data ingestion SoP as the single source of truth for reporting cross-channel Ad effectiveness without manual touch
• Built data models and ETL pipelines for scalable analytical products to automate customer sampling, benchmark metrics validation and visualization using Tableau and AWS services including Redshift, S3, Glue, Athena.
• Automated survey weighting in R using Random Iterative Method (RIM) to power Economists’ Double Machine Learning (DML) models
• Optimized query efficiency by creating speed layers using Spark SQL - reduced the cost of scanning large tables, accelerated job execution time and enabled the auto-resolution of error ticketsMetrics Creation and A/B.
• Owned the proxy creation, calculation and roadmap planning for non-guardrail metrics that measure customers’ content discovery intent and success on Mobile, Web and Living Room devices

Irvine, CA, US

Enablement, Automation, Quality Assurance, Segmentation, Reporting, Analytical Tools Development, Web ScrapingWeb Scraping: Used ElasticSearch to analyze and classify website content for 4 Million global reseller and end-user websitesCampaign Management & Reporting: Provided back end data support for BI program recommendation and self-service MicroStrategy.

Burbank, CA, US

Warner Bros. Consumer ProductsProject Management, Systems Documentation, MS Visio, SAP Ariba

Culver City, CA, US

- Data cleansing, exploratory analysis and statistical modeling techniques including Decision Tree, Random Forests, Clustering and Linear Regression in Alteryx and R- Forecasted Live+7 Days viewers with Audience Demographics, Network, Weekday and Seasonality based on historical data from 2013 to 2016- Presented models and summarized model evaluation.

Austin, Texas, US

- Predicted cash transfer fee revenue using Time Series in R and compared with the forecast provided by FP&A- Pulled data, detected anomalies, cleaned unstructured data and calculated amortization using SQL (AWS Redshift)- Created frequency tables in SAS to calculate credit card fraud rate for 6 product segments- Created preliminary stats in Excel to.

Los Angeles, CA, US

Geek Girls 2.0: Transforming Female Gender Roles in Television- Explore contemporary television in relation to changing constructions of identity of female scientists using narrative theory and discourse analysis- Analyze selected episodes from 6 television programs spanning a range of genres from the 1900s to 2015- Write appendix for all programs, TV show.

Los Angeles, CA, US

Hollywood, Health & Society (HH&S) is a program at the USC Annenberg Norman Lear Center that provides entertainment industry professionals with accurate and timely information for health storylines. - Conducted systematic analysis of healthcare content in 3-5 prime time entertainment TV shows each week such as Grey's Anatomy, Modern Family, Blue Bloods and.

Los Angeles, CA, US

Content Analysis of Popular Films in 2014: Examining Character Portrayals- Quantified 300 speaking characters’ demographic and occupational data in over 10 films to investigate the disparities in media representation of females and other underrepresented groups- Successfully coded films including Transformers: Age of Extinction, Let's be Cops, Mr. Peabody.

Toronto, ON, CA

Master Of Science In Business Analytics

Bachelor Of Science In Business Administration, Data Science; East Asian Studies

Summer Session, Chemistry; Creative Writing