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, QuickSight• 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 Testing• 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• Performed end-to-end A/B testing in UI change and Personalization experiments - Experiment design doc review, metrics definition, launch and dial-up criteria selection, statistical analysis on metric sensitivity, and results presentation to PMs and senior leadership on global rollout decision • Improved clickstream data quality by testing customer journey for each category, identifying authoritative data source by devices and setting up data validation methodology• Collaborated with Software Engineers to track MoM high value actions (HVA) clickstream events, identified anomalies, increased HVA source data coverage after root-cause analysis, which improved accuracy in new metrics creation and deep dive analysis related to customer journey or PV website & app traffic drivers

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 ROI dashboard Automation: Built tools to automate manual and repetitive work to improve efficiencyAd-hoc Analysis: Performed Segmentation Analysis, A/B Testing and Trend Analysis on email campaign engagement; Utilized 3rd party data source such as Dun&Bradstreet and Synthio contact data to build profiles for various customer segments

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 metrics to develop model documentation- Created Tableau dashboards to visualize prediction, recognize patterns and monitor model performance

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 record number of funded & unfunded debit cards for each SSN and calculated monthly fraud rate from 1/2015 to 5/2016- Introduced R Programming to Risk Analytics, Revenue Management and Business Intelligence team in a presentation, and wrote step-by-step instructions of Descriptive Statistics, Time Series, CHAID, and Regression techniques- Conducted segmentation analysis using CART Model in Registration Risk Scoring Model to classify customers and estimate the frauds in each customer segment- Ensured accurate tracking of file path, data source and modeling process by creating flow charts in Microsoft Visio

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 air dates, episode number and title, and viewership referring to IMDB and Nielsen ratings- Research fan clubs and blogs for show characters to find out audiences' perception of female scientists

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 The Big Bang Theory- Utilized iTunes, Netflix, Hulu, Amazon Prime and TVeyes to gain access to each episode- Coded and entered categorized data into a detailed questionnaire and an electronic database in Qualtrics to recognize the impact that entertainment media has on individual knowledge and behavior- Tracked work progress on an ongoing basis and attended biweekly meetings with the project manager and other research assistants- Evaluated the effects of the outreach activities conducted by HH&S in providing health information to TV networks, writers, and producers

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 & Sherman, The Monuments Men, The Hundred-Foot Journey, The Fault in Our Stars and other top grossing films in 2014- Assessed conflicts in coding sheets with team members to reach at least 80% unity in categorization- Researched the roles of female and documented employees behind the camera in top grossing films in 1980s and Sundance Film Festival- Designed new variables for more accurate content analysis- Research featured by Forbes, The New York Times, CNN and The Washington Times

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