David Qiu Email & Phone Number

New York, NY, US

New York City Metropolitan Area

• Served as one of the primary analytics contacts, internal and external, for all analytics tasks, delegating and training all team members on processes and methodologies all the while creating more streamline workflows.
• Helped develop learning agendas and measurement strategies for media tacticals based on data and client discussions.
• Engaged and worked directly with all senior leadership and clients on resolutions and inquiries as well as partaking in senior leadership meetings as one of the lead analytics contacts.
• Built and delivered over 15 reports biweekly for internal and external needs for a fortune 500 client within the investment banking industry.
• Reinforced client relationships through weekly calls and providing extensive transparent investigations, and reporting and strategic solution needs in an ever-growing business.
• Worked closely with the reporting and engineering team and the client on developing and defining rules and logic for reporting and dashboard needs through Snowflake and Tableau.

New York City Metropolitan Area

• Used Datorama to build data streams, dashboards, and create multiple function-based custom measurements and dimensions for parsing data for internal and external/client.
• Analyzed monthly performance using Datorama dashboards as well as other platforms such as Google Ads, Facebook and Pinterest, etc.
• Wrote and helped teams write monthly story-driven insights for client delivery based on media performance to identify opportunities for optimization by creating and using benchmarks for the client.
• Helped define rules and requirements to ensure data ingestion within Datorama are optimal for measurement usage.
• Worked closely with planning and all investment teams, assuring measurement and KPI alignment across all teams.
• Identified processes to streamline more efficient workflow for analytic needs and lead dashboard meetings.

Greater New York City Area

• Used Tableau and Tableau Prep in order to create dashboards and process reporting for the client and internal planning/investment teams.
• Compiled large dataset deliverables such as MMMs and competitive reporting, using multiple data sources (i.e. DCM, Nielsen, site serve reporting) to gather and deliver data for client reporting.
• Analyzed budget utilizations to determine which media channel is effective based on actualized impressions and spend.
• Met with teams weekly to review and discuss weekly deliverables, and provide reasoning if pacing isn’t consistent for client.
• Met weekly via phone with the client and DS team to discuss agenda and respond to any questions.
• Worked with a subsidiary’s engineering team and client to help identify pipeline processes and develop database for automation for data reporting.

Greater New York City Area

• Oversaw media budgets per clients by running/creating weekly summary and cash flow reports and provide them to UM teams and clients to confirm that both parties are aware of the current spend by campaigns or purchase.
• Analyzed agency summaries per clients by looking through vendors, media types, estimate versus spend and cleared vs uncleared.
• Created internal and external budget trackers for clients to maximize efficiency and tracking.
• Served as the checkpoint for both the investment/planning team and the billing team to ensure that media buys are accurate before invoices are sent to the clients.
• Kept in consistent contact with UM teams to ensure that all media are being reconciled at a timely manner.
• Approved digital campaign buys through Prisma once confirmed that the buy is within the budget of the MA.

Greater New York City Area

• Managed the invoicing process for over 5 Havas agencies including; opening/holding/closing jobs, generating fee and OOP invoicing per client requirements and SOW terms, maintain production invoicing records and.
• Created and led over 20 monthly meetings with each individual account teams to go over estimate versus actuals, overages, and open vendor purchase orders for each of their product(s) and client(s).
• Ran/created monthly reports per client/product per account team meeting as well as ad-hoc reports per request.
• Monitored hundreds of jobs and POs ranging from $500 to over $2 million to ensure that all overages are explained for and resolved, and clients do not receive invoices over the given PO amount.
• Maintained close communications with the business unit teams, accounts payable, and the production teams to ensure timely submissions of deliverables as well as the prevention of any further issues that may occur.
• Worked closely with finance directors and business managers per business units in troubleshooting any finance queries.

Greater New York City Area

• Handled filing of physical and electronic documents with quick precision for the finance department of Havas Health.
• Managed transfers of jobs and approved estimates for internal and external clients using the EAS system.
• Created financial reports per client based on client specialists’ requests.
• Assisted client specialists with job and billing requests.

Greater New York City Area

• Recorded minutes during club meetings and addressed important issues and points with committee leaders.
• Oversaw the club membership and social committee by assisting the development of active members.
• Scheduled appointments, emails and phone calls with other clubs and business vendors for event purposes.

Greater New York City Area

• Captured and developed product photos with the use of studio lighting, backdrops and the Canon 5D MK III.
• Edited existing and new product photos for a complete list of works with the use of Adobe Lightroom and Photoshop.
• Worked on the Parish Scrollathon, an over-1000-kids project showcased in the Parish Art Museum.

Greater New York City Area

• Assisted and shot engagement shoots, weddings, and personal portraits.
• Photographed events for Young Ambassadors for Opportunity and Asian Women in Business.
• Took photos of events holding over 200 students and created promotional videos for campus events at Baruch College.

• Supervised a team of 15 photographers, taught, created schedules and hosted meetings to follow.
• Communicated with over 50 clubs and its leaders and handled photo coverage for the 2015 yearbook.
• Captured and published photos on Lexicon’s Facebook page and incorporated into the yearbook program.

• Create social events outside of campus to foster relationships between club members.
• Contributed and brainstormed ideas to recreate the logo of UCLA.
• Take photographs of club events, and post it through our social media page.

• Allocated club budget of $360 with a private account of $600, and filled related forms to effectively execute events.
• Wrote strategic plan and budget proposal, describing events and allocating money per event for the future school year.
• Doubled budget to $760 for the following school year of 2014 – 2015 by successfully using the budget for each event.
• Planned and helped executed events with over 20-30 students attending.

Greater New York City Area

• Provided customer service to hundreds of customers on a daily basis such as answering catering inquiries.
• Concocted various dairy and caffeine drinks for customers.
• Managed cash transactions of over $1000 on a daily basis.

Front-End Web Development

As a school known for its top tier design, marketing, technology, and data courses, the front-end web development course tackles HTML, CSS.

Bachelor’S Degree, Digital Marketing

Activities and Societies: Lexicon of Baruch College, Advertising Design Society of Baruch College, United Chinese Language Association of.

High School, Electro-Mechanical Engineering

As one of the three original specialized public high schools within New York that requires a student to pass an examination in order to.