- Analyzing and optimizing large-scale data systems, working with petabytes of data and billions of transactions in real-time- Designing, testing, and debugging data workflows and applications in hybrid cloud environments, such as GCP.- Writing and optimizing complex SQL queries to extract meaningful insights.- Improving existing processes to enhance efficiency and reduce costs using Goliath and Magnus workflows.- Collaborating with product owners, engineers, and operations teams to solve complex data challenges.

- Led an initiative to transition Executive Leadership dashboards in Looker from BigQuery data to Spark, resulting in 100% reduction in associated costs.- Collaborated with data engineering to modify various LookML code, reducing querying time by an average of 25 minutes.- Communicated effectively with stakeholders through Jira ticketing system to ensure accuracy of reporting requests, reducing churn by 20%.- Created custom LookML views and models using Spark, BigQuery, and MySQL data to build actionable ad hoc and scheduled reports for clients.

- Noticed inefficiencies in a weekly python ETL process and made modifications to the code to reduce the manual effort from 2 hours per week to 15 minutes per week.- Led projects to resolve a first to third party discrepancies to ensure our company was able to bill in full for the ads we delivered, saving hundreds of thousands in revenue.- Created documentation of new ETL processes, frequently used MySQL, BigQuery, and Spark queries, and language used to communicate resolutions to issues for clients.- Received, reproduced, and prioritized incoming production issues and bug reports from both internal and external Operations and Account Management teams

- Built a fully automated weekly/monthly billing report using Microsoft SQL Server, stored procedures, views, jobs, indexes, SSIS, Microsoft Visual Studio (SSRS), QA steps, and remote desktop, reducing manual time spent from 6 hours per week to 1.5 hours per week.- Created real-time dashboards in Tableau for the yield management team to analyze forecasts for current and future ad inventory needs as data was being provided by the YieldEx team via FTP.- Worked with engineering to transition our SQL Server data from a remote desktop client to Snowflake and ensured data integrity through rigorous QA throughout the process.

- Increased report production efficiencies by 25% through gaining a firm understanding of the process and looking for opportunities for improvement- Led team meetings to discuss end of month ad trafficking progress with account managers to ensure 100% on-time delivery for our clients.- Analyzed and troubleshoot discrepancies while tracking online ad campaigns through manual 1st and 3rd party reporting to guarantee we were able to bill the client in full.

- Led calls with the client to present weekly and quarterly changes to their ad campaigns and address any questions or concerns.- Utilized research tools like Comscore and Nielsen to identify target audience-specific sites, leading to 5%-10% higher conversion rates, and 10%-25% higher ROI for our clients.

- Utilized advanced data analysis techniques in Microsoft Excel, including VLOOKUPs, indexes, pivots, and charts, to deliver comprehensive campaign performance updates to our clients.- Efficiently managed ad trafficking operations using DoubleClick Campaign Manager (DCM), ensuring flawless campaign launches with a perfect 100% success rate and timely delivery.