•Completed back end data pipeline through GCP and python for external client facing data product•Consulted client to determine data architecture and business logic needed to dynamically transform data into condensed and workable format•Expected to create front end interactive Shiny dashboards for insight generation

•Collaborated with account and client teams; determined measurement strategy and success metrics for digital advertising campaigns with annual ~200 MM budget •Partnered with internal teams and 4 external agencies to develop monthly reports that detailed holistic performance, key insights, and action items•Managed over 20 campaigns with the aim to help clients lower costs while increasing brand equity/reach/engagement•Provided overall data strategy and logic to developers in the genesis of a client-oriented SQL database totaling ~350MM & 1 GB in size

•Automated weekly data aggregation through python to merge, manipulate, and cleanse data from 6 sources into one central ad-hoc database•Developed interactive dashboards for internal teams to facilitate optimizations, insight creation, and overall understanding of campaign performance•Conveyed campaign performance & insights to clients on weekly cadence

-Execution of numerous digital advertising campaigns through Google’s DSM & DFP with a high degree of accuracy (97% or higher) -Optimized biweekly and ad hoc to ensure campaign performance and fulfillment goals -Analyzed 1st & 3rd party delivery to troubleshoot and minimize discrepancies -Coordinated with sales team to guide and ensure proper execution of campaigns

-Utilized Google’s DoubleClick to implement and manage 40 digital advertising campaigns for Allstate, DeVry University, Keller Graduate School of Management, and Chamberlain College of Nursing-Effectively communicated with internal and external teams in regards to expectations, quality, and deadlines for various campaigns -Basic analysis through DFA Reporting to ensure proper implementation of tags

-Received an average of 60 customer calls per day while maintaining an above average rating of 94% in terms of call log time management-Assessed and analyzed initial phone calls from clients that pertained to individual claims whilst entering pertinent information into company database -Effectively communicated with concerned clients of varying socioeconomic backgrounds

-Received an average of 60 customer calls per day while maintaining an above average rating of 94% in terms of call log time management-Assessed and analyzed initial phone calls from clients that pertained to individual claims whilst entering pertinent information into company database -Effectively communicated with concerned clients of varying socioeconomic backgrounds