Open to opportunities

Aubrey Zhang

@aubreyzhang

Message

Data-driven AdOps Analyst skilled in SQL and campaign optimization.

United States

Message

What I'm looking for

I seek a dynamic role that fosters growth, innovation, and collaboration.

As a dedicated AdOps Investment Analyst at Group M, I have successfully optimized over 50 digital streaming campaigns across more than 10 partners. My expertise in SQL has enabled me to extract and analyze performance data, ensuring seamless execution of campaigns through tools like Prisma, Double Verify, and Campaign Manager 360. I thrive in collaborative environments, working cross-functionally with paid social, paid search, and analytics teams to drive data-informed decisions and successful campaign launches.

My analytical skills extend to budget allocation analysis, where I utilize SQL to identify lead generation trends and maximize ROI through strategic fund reallocation. I have managed over 100 paid search campaigns, employing SQL to segment and analyze data effectively. Additionally, I have automated the generation of monthly reports, enhancing efficiency in campaign performance tracking and invoice reconciliation. My commitment to data accuracy and actionable insights has significantly scaled campaign oversight, demonstrating my ability to enhance lead generation strategies.

Experience

Work history, roles, and key accomplishments

Current

AdOps Investment Analyst

Current

GROUP M

Jul 2022 - Present (2 years 10 months)

As an AdOps Investment Analyst, I optimized over 50 digital streaming campaigns using SQL for data analysis and performance monitoring. Collaborated with cross-functional teams to drive successful campaign launches and provided actionable insights on KPIs. Managed 100+ paid search campaigns and automated reporting processes to enhance campaign performance tracking.

SQL Excel Tableau Double Verify Data Analysis Campaign Management Performance Monitoring Cross Functional Team Management Automation

Data Analytics Apprentice

COOP Careers

Feb 2022 - Jul 2021 (-1 years 5 months)

During my internship at COOP Careers, I worked on a customer segmentation analysis project for Ihsasnishan Clothing. Collaborated with a team to refine unstructured data and enhance the client's social media presence and website UI/UX. Utilized Google Trends and Tableau to analyze market trends and demographics, providing strategic recommendations.

Data Analysis Google Trends Tableau Microsoft Excel Team Collaboration Market Research Customer Segmentation Survey Analysis

Education

Degrees, certifications, and relevant coursework

KURA Labs

Fellowship, Data Engineering

2023 - 2023

Completed a Data Engineering Fellowship, focusing on data engineering principles and practices.

COOP Careers

Apprenticeship, Data Analytics

2022 - 2022

Participated in a Data Analytics Apprenticeship, gaining hands-on experience in data analytics and related technologies.

CUNY, Queens College

Bachelor of Arts, Computer Sciences

2017 - 2021

Activities and societies: Volleyball Club & Entrepreneurs’ Club

Graduated with a Bachelor of Arts in Computer Sciences. Relevant coursework included Software Engineering, Database Systems, Internet and Web Technologies, Computational Finance, and Computer Organization & Assembly Language. Participated in extracurricular activities such as the Volleyball Club and Entrepreneurs’ Club.