Yilan Wang Email & Phone Number

California, United States

San Francisco Bay Area

Riverwoods, Illinois

• Constructed multiple monitors to ensure business supervision on account portfolios by capturing exceptions across large-scale databases using SQL and SAS.• Accomplished remediation process of credit card incidents 30 days before deadline by analyzing complex financial components, validating affected population, calculating impacted amounts, and executing restitution strategies.• Provided assistance to 3 teams simultaneously on different priorities focusing on monitoring, reporting, and restitution.

Thornton, Colorado, United States

• Complete automobile sales analysis and statistical modeling projects using SQL with 8% less time• Reduce operational costs by 11% through resource and cost analyzation in SQL, Tableau and vendor negotiation• Analyze Colorado state employment data and recruit 15+ employees to the administrative and engineering department • Create the company's business plans, build up the operation management process and implement operational strategy improvements at a laser technology startup

Los Angeles, California

• Conducted multiple analyses in SPSS and researched previous studies to establish standards for comparing subjective data• Coded 540 video responses and reached 97% consistency and presented the findings to an audience of 60+ people• Created and integrated visualizations of results in Tableau and was chosen as a poster presenter from a 10/80 application pool

Los Angeles, California

• Conducted data analyses using SPSS and SQL to test the effects of practice on motor learning across different age groups • Managed 13 MRI brain imaging data in FMRIB Software Library (FSL) and Statistical Parametric Mapping (SPM)

Los Angeles, California

• Coordinated a field trip to Houston, interviewed 32 families, and analyzed 48 surveys and video interviews • Analyzed participants’ responses and completed the investigation with 8.5% less in costs and 1 week faster • Reviewed 200+ surveys on racial inequality and held a nationwide search for volunteers

Master Of Science - Ms, Applied Analytics, Gpa 4.08/4.00

Dedicated in Business Analysis and corporate operation.

Bachelor Of Arts - Ba, Business Economics And Psychology, Gpa 3.97/4.00

Summa Cum Laude. Outstanding academic achievement--Economic Department. Departmental Honors--Psychology Department. Research assistant.