Suying L. Email & Phone Number

Jersey City, NJ, US

United States

• Generated reports and visualizations for pitches, including market share analysis, buyers demoprofiling and sales trends across years, providing insights on the current brand situation.
• Delivered audience matchback and syndications for 20+ clients and 50+ ads campaign to partners including LiveRamp, Throtle, etc, utilizing Python and SQL.
• Collaborated with Data Engineering team to update databases and SQL script biannually; held Q&A sessions for agencies and clients to answer questions about the scripts.
• Applied independent critical thinking to analyze vast data sets (sales, search interest, website visits, social media, advertising activity) to uncover insights to support with High Value Audience analysis.
• Managed team to build and deliver 100 lookalike modelled segment audiences within one months.

United States

• Led the creation of analysis and developed SQL scripts independently for reports, including Audience First report, Audience Overlap report, and campaign analysis.
• Performed Premium Video Optimizer using Excel Solver, finding best budget allocations across tactics supporting ~$120M campaign total budget across 7 clients with an average of 10% reach increase.
• Collaborated cross-functionally to gather project requirements and deliver actionable insights.
• Performed Post-Campaign Analysis report, providing clients with campaign performance.
• Maintained documentation for analysis methodologies, scripts, and procedures for future reference.
• Tutored teammates and new hires with company-developed optimization tools we use for client work.

Durham, North Carolina, United States

• Visualized Cargo staffing data to analyze current workforce allocation situations using Tableau
• Developed strategic recommendations based upon divisions, client characteristics, and other features within Cargo to optimize workforce allocation
• Presented insights to Cargo leadership, delivering dashboards to facilitate workforce planning

Seattle, Washington, United States

• DogPaws (Daily Organization Guide Portal for Active Washington Students) is a resourceful all-in-one online platform that helps everyone affiliated with the University of Washington (students, faculty, staff, and.
• Initiated the project from a basic idea: Constructing an all-in-one online platform for students, professors, and alumni to socialize, network, collaborate, and find a sense of belonging
• Developed project plan with Gantt chart; recruited ~30 students, organizing into four functional teams
• Oversaw and collaborated on UI design, backend SQL database development, and user testing by 50+ people
• Presented business ideas and budget plans to potential investors, securing initial partnerships

Beijing, China

• Analyzed trends and patterns in drivers, rides, and customers using MySQL, generating insight for Platform Security to evaluate drivers and manage risk.
• Extracted trip data to support the safety team, maximizing safety and minimizing the impact on business.
• Coordinated with ten smaller-sized ride-share companies to collaborate with DiDi for a new aggregation platform owned by DiDi.

Seattle, Washington, United States

• Delivered lecture about the relational model, SQL, entity-relationship modeling, three-tier architectures, and implementation of database applications with professor
• Held office hours to answer students’ SQL-related questions
• Graded assignments and exams for 50+ students
• Offered guidance on student team data projects

Greater Seattle Area

- Drafted the constitution for registered for the Student Organization through University of Washington- Communicated with professors at school and communicated with the International Student Services office- Shared information about majors and school life with hundreds of parents in China through social media- Attributed works to different members in the.

Beijing

• Researched and examined agriculture, AI, and healthcare sectors in China, authoring investment feasibility report
• Gathered data to analyze Chinese and Israeli high-tech sectors, generating insight for client decisions
• Engaged clients to plan the establishment of Cayman Island-based PE fund

Seattle

• Triaged client inquiries and captured requirements, ensuring event room set-up matched client needs
• Monitored event conditions and handled unexpected situations for 50+ events with catering team

Master Of Quantitative Management, Business Analytics, 3.7/4.0

Bachelor'S Degree, Mathematics, 3.75/4.0

Bachelor Of Science - Bs, Informatics, 3.75/4.0