Acquired Apptness Media Group

(Acquired by Zeta Global)• Designed a data lake on AWS S3 and AWS Athena (Presto).• Built data pipelines with Prefect to automate and monitor data ingestion from internal and external data sources.• Data lake ingested structured tabular data, columnar, and unstructured JSON.• Designed a data monitoring and data lineage to build trust in data accuracy.• Generate daily performance reports from multiple data sources for multiple departments.• Wrote complex multi-table join SQL queries for tableau visualizations.

• Used Python Pandas, Microsoft Server SQL, and AWS Sagemaker to automate create daily sales reports and domain performance reports.• Created a custom real time alert system to notify the operations team when offers were broken using the MSSQL, AWS Lambda and Slack API.• Worked with the development team to create a data lake using S3.• Used AWS Athena and AWS Glue to create tables on top of the data lake to run ad hoc reports on hundreds of gigabits of data in seconds.

• Wrote scripts to automate data collection from 3rd party vendors like Yelp, ReachLocal, Google AdWords and MailChimp using their APIs.• Created demographic reports for internal ad campaign optimization.• Used Google BigQuery to as a data warehouse and Data Studio that allowed users to build their own reports.

• Create database schemas and restructure data in existing applications.• Automate data processing using Python Pandas, AWS lambda and AWS SQS.• Created strategy, managed production and implemented email marketing automation.• Data visualization with Domo, Exploratory, and Tableau.• Created websites using Node.js, React, Gatsby.js, and app with React Native.• Built custom inventory management tools, listing website and search (elasticsearch). • Built custom drag and drop tool for internal use.

• Created marketing automation funnels to increase KPI through the customer journey.• Create and manage PPC campaigns on Facebook and Google AdWords.• Conducted deep data analysis on users and funnels. • Calculated Cost Per Acquisition and Lifetime Value by channel and customer type.• Helped develop KPI’s for marketing and other departments.• Coordinated with the creative director to create engaging emails and PPC campaigns.• Created custom landing pages and HTML emails.• Worked with the development team to integrate mobile data analytic solutions.

• Programmed iOS and Android app using Cordova and meteor.js.• Over 19,000 users from $8,000 in marketing.• Designed and developed the user interface• Raised Angel capital from high net worth individuals.• Implemented and tracked analytics by channel and actions are taken for highest ROI.• Designed marketing automation to increase engagement and increase KPI’s• Hired and managed remote developers from around the world on a bootstrapped budget.Pickk is a mobile application that lets football fans guess what the upcoming play will be. Each play has multiple options with real time multipliers that change based on the situation. Fans play with fake coins that lets them compare their score to friends, co-workers, and the world.

• Researched and developed KPIs for marketing.• Calculated Cost Per Aquisition for each channel. Allowing advertising dollars to be used most effectively.• Designed and coded WordPress web pages.• Identified and segmented customer by buying profiles.• Designed an email automation funnel based on action or inaction. • Assisted with graphic design and photography.

Worked independently and effectively with no direct management oversight.Built strong relationships with management and employees to increase sales and brand support. Conducted seminars of 15+ employees on new products.

Educated customers on different forms of credit we offered allowing them purchase more and to build a complete solution.Presented an award from CEO for promoting a local electronic recycling program at Best Buy. The event filled 30 Gaylord boxes with recycled electronics.