Yan L. Email & Phone Number

Ottawa, On, Ca

New York, Ny, Us

• Managed all of Paid Social Evergreen ads for "Meta's Top 5 North America Retail Advertiser in 2023."• Partnered with the data science team to create a new campaign budget setting pipeline. Modeling and human-in-the-loop adjustments improved marketing efficiency by 6%.• Developed and owned strategic marketing structure to drive year-over-year growth and hitting business targets with strong KPIs.• Created 100% of the team’s programmatic bidding tutorials and onboarded every new team member since 2021.

New York, Ny, Us

• Leveraged marketing analytics using SQL, Tableau, and Excel to identify strategic levers to improve audience targeting, bidding strategies, and explore growth opportunities. • Led creative A/B tests on Instagram campaigns to identify user behavior and increased CTR, CVR, and ROI.• Designed optimization tools with Google spreadsheet used across the team for accurate data reporting and timely budget allocations.

New York, Ny, Us

• Conducted extensive market research to ensure legal compliance on competitor listings across Amazon, Walmart, and Ebay.• Minimized trademark infringements on Amazon by 75% with immediate reporting and proper escalations.• Cooperated with external cybersecurity consultants (RiskIQ) to ensure accurate data scraping and effective fraud reporting by keeping extraction logic up to date.• Monitored key KPIs (seller reviews, brand rating, and product listing) to maintain strong impressions across marketplaces and protect brand reputation.

Oakland, California, Us

• Analyzed program data through tracking attendance, test scores, and yearly budget.• Collaborated with city government by acting as the data specialist for the project.• Coordinated team building and training programs for the Youth program and AIWA members through the Leadership Development Program and provided support throughout.

San Francisco, California

• Utilized Google Spreadsheets to enter client price lists used in Tableau to conduct monthly reports;• Analyzed client data with Pivot Tables to pinpoint issues behind client shortages and submitted shortage claims to Amazon Vendor Central.• Consolidated data from Amazon Seller Central order reports.

Oakland, California, Us

• Daily Google spreadsheet management to track author social media activities, pre-orders, and bitly clicks.• Collated data for the Operation Team such as emails for potential endorsers, data entry for sales and search positions for current active titles.• Worked closely with the VP of marketing on various sales promotion projects, book orders, basic data analysis on pattern change in sales performance on discounted titles.• Overlooked copyright infringement violations and responded accordingly.

Weekly reports, accounting, outreach, emails, and various administrative duties.

Davis, Ca, Us

Davis, Ca, Us

Overseeing implementation of the Marketing strategy - including campaigns, events, digital marketing, and PR;Ensuring that the marketing objectives are implemented by the marketing team;Undertake continuous analysis of competitive environment and consumer trends; increased membership by 35% within a month; Outreached and formed partnerships with local startup and organizations.

Oversaw the entire productivity of the store, on duty manager when main manager is unavailable, commercial printers: Xerox 560, Xerox 260, Versant 80, D1120, and HP inkjet printer. Oversized scanning, laminations, book binding, Adobe Acrobat, Adobe Photoshop, InDesign, and Illustrator on a regular basis. Customer service, and receptionist duties.

London, Gb

Customer service, inventory, and merchandising.

Davis, Ca, Us

Worked in Lender Engagement Program, which made over 4000 calls, over 25 appointments, serviced 15 clients, and postponed 2 foreclosures. Executed 5 market research and data analysis projects for 2 companies including Acela Biotek and Gateway Realty Partners, assisting in business case research, stakeholder mapping, and comparative market analyses for commercial real estate & biotechnology industries. Participated in Political Action Committee working to build technical capacity in 14 Congressional Campaigns in California – assisting with data analysis, landscape reports and content writing for the campaign.

Us

Provide guidance and customer services to customers, ensure customer satisfaction, and finalize customer purchases. Trained in cashier registers and key-making machinery

Washington, Dc, Us

Taught and certified students in Pediatric and/or Adult First Aid/CPR/AED.

Washington, Dc, Us

CPR Training, Basic Aid training, Disaster Preparedness training, and volunteer services.

Englewood, Colorado, Us

Record daily environmental data regarding marine life in Oakland Lake Merritt for global engineering company, CH2M HILL.

Experienced with Microsoft programs, fixed printer technical issues, helped prepare meetings, made handouts to the public, familiar with earthquake preparations, and Created databases and spreadsheets to improve inventory management and reporting accuracy. Excelled within deadline-intensive environment, ensuring accurate and on-time completion of all projects. Assisted in some areas of administrative work including data entry, receptionist duties, file organization, research and development.

Undergraduate, Economics

Business, Management, Marketing, And Related Support Services

High School Undergraduate, General Education

General Education