As the first dedicated data and analytics hire, developed a data roadmap and led the implementation of end to end analytics solutions to support Amaze and Sam’s Club Photo (managed service client). Utilized data ingestion tools, setup a data warehouse, used dbt for data transformations, and built reporting in Tableau. Providing leadership to various teams through migration and consolidation of data tools due to acquisition of Spring (i.e. GA4, dbt, Tableau, Hightouch) to setup scalable data foundation to meet business needs. Leading the migration of Spring’s legacy data transformation code into dbt. Rebuilt 20K lines of SQL to use dependencies, automated testing, and optimize performance while following dbt best practices. Show less

Developed a deal inventory cohort analysis (created in Tableau) to provide visibility into deal churn. With newly provided insights, a focus was placed on reducing churn and various initiatives were implemented. The cohort analysis showed churn improved by 30% on a quarterly basis over a year period. Analyzed deal performance data to identify and create a list of “Top SKU’s”, allowing sales teams to more easily originate best performing deals. Results showed over 25% higher origination of Top SKU deals, which subsequently also improved site conversion metrics. Managed complex, cross functional pilot implementation of intelligent call lists to sales representatives that factored in available offer inventory, seasonality, reviews, grades, and potential revenue generation.

* Created a comprehensive view of all digital marketing channels, including display, paid, affiliate, and social to understand campaign performance, attribution, and site engagement. Determined ROI by utilizing sales data from Google Analytics and Salesforce. * Analyzed goal conversion results and made recommendations on website changes to increase conversions.

* Compared B2C against B2B growth in all markets and their contribution to overall growth to drive more merchant focused marketing, to decrease customer turnover, and increase margins and growth. * Analyzed product sales lift for virtual rail program and created reports using SAS to distribute to brands. * Using the ExactTarget email marketing SaaS tool, prepared various ad-hoc emails to be sent to large distribution lists and analyzed sales lift versus the control group. * Created weekly mobile app performance report (iOS and Android) using Apple and Google website data and web analytics software (Omniture / Visual Sciences) to distribute to management and executive team. * Prepared for and participated in conversion task force meetings, website usability tests, a quarterly marketing meeting, and scrum project management meetings to help team in meeting sprint goals.

On development team that created web based Transaction Risk Identification & Analysis (TRIA) framework to streamline the production of 120 standard and custom reports. Completed report requirements specifications, designed a database model, and wrote code in PL/SQL and VB.NET. Led junior staff during several engagements using the TRIA framework, requesting client data, managing project plans, performing quality assurance functions, and communicating with corporate investigators to identify highest risk transactions for further research. Performed complex data analysis using mostly SQL; investigated financial statement fraud, anti money laundering, stock options backdating, and performed IT compliance testing.

Developed modern data stack from scratch, inspired by ELT data pipeline model. Selected and used tools to extract/load data (Fivetran), transform data (dbt) and create reports and dashboards (Tableau) to support our internal teams to grow revenue. Utilized third party location data (Safegraph) to understand foot traffic and calculate impressions for our host network locations and prospective host networks. Furthermore, determined demographic mix, most popular hours and days, for each location to help build sales and marketing collateral. Built impression inventory reporting to understand fill rate over time, by host network and DMA's, to assist Advertising Operations with building proposals and optimizing yield. Built post advertising campaign reporting to provide advertisers with impressions delivered and lift studies to show proof of performance.

Manage staff and provide roadmap to the types of analyses to create, while offering both technical and business insights. Objective is to develop impactful stories that engage ecommerce business stakeholders to drive positive change. Developed a deal inventory cohort analysis (created in Tableau) to provide visibility into deal churn. With newly provided insights, a focus was placed on reducing churn and various initiatives were implemented. The cohort analysis showed churn improved by 30% on a quarterly basis over a year period. Analyzed deal performance data to identify and create a list of “Top SKU’s”, allowing sales teams to more easily originate best performing deals. Results showed over 25% higher origination of Top SKU deals, which subsequently also improved site conversion metrics. Performed ad-hoc analyses to support ecommerce initiatives. For example: identified deal characteristics that made deals most successful; introduced logic to place more relevant deals on home page; and collaborated with finance to forecast following years ecommerce growth.