Anqi Wei

Experience

• 

  Michael Bloomberg for New York City Mayor 2009 Campaign

  May 2009 - Sept 2009

  Campaign Volunteer

  • Collected and organized voter data for the campaign phone bank and canvassing • Updated voters’ contact information in database• Communicated with voters and persuaded them to vote in the mayoral election; developed communication and interpersonal skills

• 

  Ford Foundation

  Jun 2012 - Aug 2012

  Information Mangement Intern

  • Upgraded the Foundation’s grants systems by comparing geographic names between the source from the Foundation Center and the location table in grant budgeting system• Assisted the development of the new intranet, FordNet, by testing and providing insights on newly developed search tools • Updated tags in foundation’s digital archive library in order for documents to be found in FordNet search• Participated in weekly meetings for leadership development and networking workshops

• 

  Wesleyan University

  Sept 2012 - May 2015

  Finance Office Intern

  • Created and updated new vendor accounts with PeopleSoft Enterprise • Managed purchasing-cards by reviewing and approving transactions; detailed and reported errors in transaction record to supervisor• Organized vendor accounts by updating and matching vendors’ W-9 forms in internal database• Assisted co-workers with university’s domestic and international billings and payments

• 

  Mayor's Office of Operations

  Jun 2013 - Aug 2013

  Summer Intern

  • Assessed citywide agencies’ policy compliance providing interpretation services to limited English proficiency clients by conducting secret-shopping at almost 200 government sites• Evaluated each agency’s performance, collected and analyzed statistical data, created detailed reports for individual agencies with both quantitative and qualitative ratings through Excel spreadsheet and PowerPoint• Presented policy recommendations to the Commissioner and Director at the Mayor's Office and other agency representatives to increase efficiency and improvement Show less

• 

  U.S. Department of Education

  Jun 2014 - Aug 2014

  Office of Postsecondary Education Summer Intern

  • Extracted and analyzed data from over 700 surveys with Excel to estimate the impact of a federal grant • Conducted quantitative and qualitative analyses on public policy data to revise and substantiate a Congressional tracking report • Monitored and facilitated expert panel discussions for two national foreign area studies competitions • Reviewed applications on meeting national priority standards and created a comprehensive dataset from over 100 applications from prestigious universities throughout the United States Show less

• 

  Epsilon

  Sept 2015 - Apr 2018

  • Led quality assurance in a global email marketing campaign that went to monthly subscribers in over 60 locales with Gamma, Google’s email provider platform• Owned test plan creation and test case execution for various Google product’s campaigns; contributed to reaching 868k+ global users in 9 countries and performance metrics exceeding all targets • Performed functional testing on web application on 30+ devices and web platforms • Served as liaison between QA team members and PMs; collaborated closely with PMs and developers to ensure on-time product delivery and used JIRA to track bugs• Analyzed existing test strategy and provided insights to streamline overall testing process; resulted in reducing project time and cost by 50% • Provide mentorship and QA training to new team members in both the U.S. and abroad Show less • Developed comprehensive back-end and front-end test plans by analyzing business requirements for a highly complex omnichannel database marketing campaign• Utilized SQL to execute data definition language (DDL), data warehouse, and data mart testing to ensure data integrity, segmentation and hygiene for over ten years of consumer data • Used Visual Studio to capture test execution results and overall bug progress tracking• Identified and reported conflicting data logic between our side and client-side to BSAs to get clarifications from clients and prevent dissatisfaction and financial losses• Led testing on major client-facing business intelligence reports and provided testing training to offshore team members • Created a study guide of Epsilon’s in-house marketing platform for the QA team Show less

  • Business Systems/QA Analyst (Digital Marketing for Google)

    Jul 2016 - Apr 2018

  • Associate Business System Analyst (Database)

    Sept 2015 - Jun 2016
• 

  AAA

  Apr 2018 - Aug 2021

  Use data analytics to drive the growth of insurance businesses and develop marketing strategy.Measure campaign performance and quantify success by building Tableau reports to match back customers with multi-channel touch points Launch and manage AAA’s first Life Insurance's omni-channel marketing campaigns from strategy to execution. Some of my key responsibilities:• Customer segmentation and market sizing• Develop marketing strategy/briefs and lead content creation meetings• Design customer journeys and plan A/B testing• Manage multiple projects by leading cross-functional teams and ensure timely campaign execution• Manage monthly marketing budget

  • Product Analyst/Associate Product Marketing Manager

    Jan 2019 - Aug 2021

  • Product Marketing Analyst (Insurance Product Marketing)

    Apr 2018 - Jan 2019
• 

  GIG Car Share

  Aug 2021 - Jan 2024

  • Product Manager

    May 2022 - Jan 2024

  • Associate Product Manager

    Aug 2021 - May 2022
• 

  AAA Northern California, Nevada & Utah

  Jan 2024 - now

  Product Manager