Dan Spohn Email & Phone Number

Birmingham, Alabama, Us

Durham, North Carolina, Us

- Built Analytics Data Warehouse-- Sources: MySQL, Salesforce-- Tools & Systems: Redshift, DBT (data build tool), Python, FlyData, Airflow, Airbyte, Tableau Prep Flows- ETL / ELT-- Wrote custom Airflow Operators and Hooks to pull data, and interact with REST APIs.-- Wrote over 400 DBT models to transform data in the Data Warehouse-- Implemented DBT (cli) as part of a DataOps workflow utilizing CI/CD with integrated Data Testing on Docker.- Visualizations and Dashboards-- Build dashboards to support Executives, Sales Teams, Product Team, and Finance & Accounting-- Tools: Periscope, Tableau- Reporting-- Processes and reports to assist Finance with a variety of tasks such as Client Invoicing, Accounting Reconciliation, Deferred Revenue, and ARR calculations.-- Write and Execute Sales Team Attribution and Commission Models- Analysis-- Product and Customer Analyses using R and Tableau.-- Created B2B (Enterprise) and B2C (Retail) Customer Lifetime Value (CLV) analysis

Morrisville, Nc, Us

Akron, Oh, Us

CompanionLabs was an early-stage start-up.-Built and managed a data pipeline that processes roughly 250,000 incoming files per day.--The Data Pipeline consists of the following tools: Streamsets, Apache Spark, Python, Amazon S3, Amazon Athena, PostgreSQL, Amazon EC2, and Amazon EC2 Container Service (Docker)-Built Amazon S3-based data warehouse that utilizes Parquet files stored on S3 and queried using Amazon Athena (Serverless data warehouse)-Designed and Developed an Ad Grading System that provides statistically significant grades to help customers easily understand which of their Facebook Ads are performing most effectively. Tools used: Python, PySpark, Pandas, SparkSQL, Multiple-Criteria Decision Analysis-Built a Predictive Budget Recommendations System, which provides marketers with recommendations to maximize their marketing budget, while accounting for diminishing returns. Tools used: Python, PySpark, Pandas, scikit-learn-Created Tableau Workbooks and Dashboards to better understand and assist customers in understanding their performance using our product.

San Mateo, Ca, Us

SolarCity was acquired by Tesla in Nov 2016 and is now a part of Tesla Energy.-Managed analysts and served as project lead on key projects.Projects:-A Key Member of the team building an internal Marketing Data Management Platform (DMP)--Connecting numerous data points across the consumer journey such as:----Billions of Website Display Ad Impressions----Millions of Website Page Views----Social Interactions----Press Release & News Interactions----Website Conversions----Sales Funnel Conversion Steps----CRM Data----Search-Facebook Atlas API integration--Ingest Impression, Click, and Display Ad Metadata using REST API and Python.-Facebook Lead Form API integration--Integration with Facebook REST API using Python and SQL Server. Leads from Facebook are then added to Salesforce.-Built a Direct Mail Data Warehouse for reporting and analysis.-Terrestrial Radio and TV Campaign Lift Analysis--Using A/B tests, analyze the effect of Terrestrial Radio and TV campaigns on business generation in metro areas. Ran regression analyses to create baselines to identify the lift created by offline advertising.Online Video A/B test: Measure the effectiveness of Online video channels (YouTube, AOL, etc.) and how they influence consumers' propensity to convert.-Marketing Channel Attribution Models--Last Touch Attribution (View + Click) between numerous Display Advertising Vendors (10+)--Multi-touch Attribution - Implemented Linear and Time Decay Models integrating numerous marketing channels.--Algorithmic Attribution - Built Gradient Boosting Machine (GBM) model to infer marketing touch point influence and allocate attribution weights.Tools Used: Amazon Redshift, Python, R, SSIS, SQL Server, Tableau, REST APIs, Facebook Graph API, Salesforce

As a consultant, I completed the following projects:-Built Predictive Models to optimize Call Center Operations, along with supporting reporting to understand the impact and lift of the models.-Performed Exploratory Data Analyses to understand Business Opportunities for Clients.-Built Database Systems, and ETL processes and loaded data for Data Analyses-Utilized Amazon Web Services (AWS) for computing infrastructure:--Amazon RDS (Relational Database Service): PostgreSQL--Amazon EC2 (Elastic Compute Cloud): SFTP machine, ETL machine, R Data Science Server--Amazon S3: File Storage, Transfer and Archive

Akron, Ohio, Us

Knotice was a startup that was acquired by IgnitionOne in 2014.-Conducted Exploratory Data Analyses on client data to uncover customer-centric marketing opportunities.-Digital Marketing Response Modeling using R, MADlib, and SQL. I created digital marketing engagement models to predict customer response in different marketing channels. These models utilized Logistic Regression.- Built a model for predicting the next product category an individual customer would be interested in purchasing for an e-commerce brand. This utilized Neural Networks for prediction. I wrote R code that translated the Neural Network model scoring into SQL code to complete all scoring within the database.-Used Hadoop, Hive, and Impala on Amazon Elastic MapReduce (EMR). I built a Display Advertising Data Warehouse using Hive to process new data and Impala to allow for quick data access and aggregation.-Building Data Exploration Dashboards using Tableau.-Built ETL to load large database tables and large-scale queries with Greenplum Database and Amazon Redshift.-Utilized many of the MS SQL Server BI tools:--MS SQL Server 2008,2012.--Microsoft SQL Server Integration Services 2008,2012. --Reporting Services 2008 R2 using Report Builder 3.0.-Developed ETL processes to load and process gigabyte-sized files daily.-Query Optimization for SQL Server. Created new database indexes and used query join hints when necessary.-Fuzzy Matching for data reconciliation. Performed fuzzy matching on Street Addresses to consolidate user profiles.-Complex T-SQL and PL/pgSQL to handle large data processing.

Mayfield Village, Oh, Us

Using the following technologies to create dashboards, cubes (OLAP), and reports for analysts and technicians:MS SQL Server 2000, 2005 (Database).MS Integration Services 2005 (ETL).MS Analysis Services 2005 (OLAP).MS Reporting Services 2005 (Reporting).

Develop useful and interesting websites. Some technologies used in development are PHP, MySQL, Linux, Apache, AJAX, javascript, CSS, XML, and APIs.Some of the sites are listed below:http://www.joggermaps.com/http://www.us-city-home.com/http://www.citystatelocal.us/http://www.tsqltutorials.com/http://www.freessisdocumenter.com/http://www.findsomearticles.com/

Poland, Oh, Us

T-SQL programming.SQL Server Reporting Services Development.SQL Server Integration Services Development.Pharmacy Plan and Medicare Part D Reporting.

Linux, Apache, PHP, HTML and MySQL web applications.Contributed to the design and development of applications in areas such as:Shopping Cart Application,Document Management System, Time Management System, and a Content Management System.

Master Of Science - Ms, Bioinformatics

Certificate, Data Science, Data Science

Master Of Science, Computing And Information Systems

Bachelor Of Business Administration, Computer Information Systems

Biology, General

Nanodegree, Data Analyst

High School Diploma