Tyler C. Email & Phone Number

Irvine, California, Us

- 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.

New York, Us

- 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.

New York, Us

- 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

Irvine, Ca, Us

- 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.

Irvine, Ca, Us

- 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.

Huntington Beach, California, Us

- 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.

Huntington Beach, California, Us

- 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.

Master Of Science - Ms, Data Analytics

Bachelor Of Business Administration - Bba, Marketing

Bachelor Of Business Administration - Bba, Marketing