Badges
Certifications
chpiquette1 has not earned any certificates yet.
Work Experience
Manager, Data Operations
Restaurant Brands International• January 2024 - April 2024
Data infrastructure, dashboards and analytics for the Popeye's Louisiana Kitchen brand. - Designed advanced Snowflake SQL analysis showing 3% lift in sales, and visualized in Tableau. - Wrote Terraform task file for SQL scheduling, and committed SQL to Github in analytics repository. - Refactored SQL queries and worked with data engineering and analytics to solve data problems. Tools: Snowflake, Tableau, Terraform, Github
Lead Data Analyst
Google• April 2021 - January 2024• Remote
Business Intelligence Analyst
Druva• April 2020 - April 2021• Santa Clara, CA
Data Analyst - Application Developer (Contract)
accenture• September 2019 - March 2020
I'm working on data architecture projects for the Google Cloud Customer Business Intelligence team at Google: - Developed Lua + SQL fuzzy-match functions that matched external schools to $7M in Google bookings. - Re-factored ETL pipeline for PLX dashboard visualizing $160M of Google’s global education accounts. - Designed core database table with sales metrics combining 11 global sales segments, used in education account forecasting and reporting. - Documented SQL standards for release management, macros, and computing storage statements for the business intelligence workflow. - Transposed data in and out of arrays through SQL cross joins, and optimized Google's ETL process. - Reported on data findings for business intelligence and sales operations teams and delivered datasets to Google Sales and Marketing teams.
Senior Performance Data Analyst
FuelX• October 2018 - August 2019
- Wrote SQL source of truth for internal teams to perform campaign analytics and understand FuelX datasets. - Designed Data Studio ad operations dashboard by writing custom SQL and combining data from 4 MySQL tables, saving ad setup time by 30%. - Performed regular, data-backed analyses for CEO, COO, and CRO using SQL and other tools to troubleshoot company-wide performance. - Automated recurring reporting for clients by modifying SQL-integrated R scripts and collaborated with engineering to setup CRON scheduling. - Built marketing goal calculator using logarithmic regression statistics to predict conversion returns based on ad spend levels. - Documented Google DCM setup steps and project-managed ad-server integration to automate 50% of campaign setup steps. - Designed features, quality assured new One-Portal self-serve advertising platform and conducted product trainings for the whole company.
Campaign Analyst (2 years 4 months) and Support Engineer
Quantcast• September 2015 - March 2018
- Decreased Engineering's system variance tickets by ~50% by analyzing 150+ tickets and determining that 2/3's of tickets needed no action. - Used R for cookie overlap analysis of Quantcast’s brand and full purchase funnel products to help grow Green Chef's revenue by 20%. - Developed qSQL (Java + SQL) by combining unstructured and structured ad auction and pixel data, and interpreted results for account teams. - Co-created viewability product playbook with Analytics and Engineering to educate internal teams and solve under-performance. - Owned pace, performance and internal cost analytics for 68 ad campaigns delivering $10.1 million in revenue and $423k in incremental revenue over two quarters. - Rolled out a step by step process to the global Campaign Analytics team to mass edit their JIRA tickets, which saved our team significant time after our team’s full transition to JIRA. - Led cost per acquisition by tactic analysis for Verizon Communications Inc. to help boost Quantcast’s revenue 8x from averaging $32k/month to $273k/month. - Contributed to our company-wide Relative Performance Project providing weekly statistics and analysis to our Executive Leadership Team for 9 weeks. - Ensured advertisers reach their Marketing goals using statistical analysis and computing tools including R and qSQL. - Completed courses: Quantcast’s Core Product Training and Campaign Analytics Certification Exam.
Data Analyst
Acxiom• September 2014 - September 2015
- Performed A/B z-tests with Facebook and Yahoo data, and interpreted and presented to clients. - Led big data analytics for CUNA Mutual Group, Capital One and Facebook publisher accounts, driving clients’ cost per acquisition as low as $0.29. - Wrote SQL to synthesize over 100 million records of ad publisher, Acxiom and client transaction data for analysis. - Managed space on Acxiom database servers and implemented parallel processing code to increase SQL throughput. - Collaborated with internal product teams to achieve process standardization for efficient data analysis. - Initiated Acxiom-Twitter reporting by facilitating analytics discussions and guiding report setup for client execution. - Assisted in developing Acxiom’s analyst guide for new hires and described details of the analytics team’s role. - Improved technical skill sets in Hadoop, SQL and Management, utilizing Acxiom's on-site and online training. - Completed courses: Hadoop Core Essentials: HDFS + MapReduce, Java Programming with J2SE 5: Basic GUI Development in Java, SQL Programming, Operations Management: Product and Service Management.
Education
Pepperdine University
Economics, Bachelor's Degree• August 2009 - April 2011
Links
Skills
chpiquette1 has not updated skills details yet.