David Bickham Email & Phone Number

New York, New York, Us

New York, New York, Us

New York, New York, Us

New York, Ny, Us

I teach evening/weekend workshops in Excel and SQL. I also teach a 10-week analytics course geared towards getting working professionals more comfortable making data driven decisions.Focus Areas: - Excel, SQL, and Tableau- Data Visualization- Effective Data Storytelling

New York, Ny, Us

+ 12-week intensive program in Python programming, statistical analysis, linear algebra, machine learning modeling/algorithms, data engineering, and data visualization. The program totals over 500+ hours of in-person, hands-on training. Four projects and a final capstone project are completed and the class workflow utilizes AWS (EC2), Docker, PostgreSQL, and Jupyter NotebooksCurriculum Overview:+ Supervised Learning Techniques: Generalized Linear Models, KNN, Naïve Bayes Classification, Decision Trees (Bagging, Random Forest, Boosting), Support Vector Machines+ Unsupervised Learning Techniques: K-Means | DBSCAN Clustering, Principal Component Analysis, Recommender Systems+ Natural Language Processing: Preprocessing (NLTK, Spacy, Regex, TF-IDF Vectorization), Topic Modeling (Matrix Decomposition)+ Bayesian Statistics: Maximum Likelihood, Markov chain Monte Carlo (MCMC)Ÿ + Deep Learning: Feed Forward, Convolutional, and Recurrent Neural Networks+ Big Data | Data Engineering: SQL, Scala, Spark

Universal City, California, Us

+ Owned ongoing analysis of customer growth/retention trends, market penetration, and sources of site traffic; synthesizing insights for senior leadership in health of the business reviews+ Modeled customer/transaction attributes associated with higher customer LTV and probability of lapsing+ SME on Gift Card analytics; informing decisions based on analysis of consumer redemption behavior, product/retailer profitability, cross-product usage (i.e. Fandango, FNOW), and data integrity issues+ Utilized Adobe Analytics to analyze video consumption on Fandango platforms (Desktop, Mweb, Apps); enabling Product and Content teams to prioritize future work to enhance the video experience+ End-to-End Tableau dashboard development across key business areas such as customer analytics, content performance (i.e. film data), and market penetration. Workflow included requirements gathering, identifying data sources, user testing, and QA+ Analytics lead for Fandango and Rotten Tomatoes social platforms (FB, TW, IG, YouTube); presenting insights on audience growth, engagement trends, and video views in weekly meetings

Hamilton, Nj, Us

+ Leveraged cross-channel customer data (transactional, email, .com, mobile) to optimize email campaign targeting, personalization, and engagement throughout the customer lifecycle for Samsung Mobile division’s CRM programŸ + Analyzed CRM marketing efforts for all major product launches (Galaxy S7/S8, Note5); summarizing learnings and delivering recommendations to improve engagement/ conversion rates to client and project teams+ Developed Test & Learn plans across email campaigns; including A/B test design around personalized messaging and targeting+ Created measurement framework for a newly created email onboarding program; including KPIs, learning agenda, and a phased testing strategy for continuous optimization+ Analysis workflow included accessing and manipulating data via SQL (Redshift), exploratory data analysis in Tableau/Excel, and delivering insights/recommendations in PowerPoint+ Hired and trained two analysts; providing guidance on work prioritization, analytic problem solving, and career development in both structured 1:1’s and day-to-day operations

El Segundo, Ca, Us

+ Tracked the performance of DTV call centers across 4 LOBs by developing a scorecard that measured and compared call centers across KPIs (i.e. conversion, handle time, time in queue, etc.)+ Presented ongoing analysis of call center performance to cross-functional project teams in weekly meetings; identifying opportunities to improve metrics+ Partnered with business owners to execute A/B tests designed to improve customer experience and call center efficiency; including KPIs, test/ control group selection, and interpreting learnings+ Automated the reporting process by utilizing Excel macros, pivot tables, and formulas to create dashboards that enabled the team to quickly identify agent performance issues+ Leveraged SQL and SAS to connect, prepare, and analyze data from a variety of DTV internal systems and 3rd parties

Burbank, Ca, Us

­CRM analytics lead for all WB Digital properties, developing reports in Excel and Tableau; measuring campaign effectiveness across revenue and engagement metrics+ Reviewed insights and optimization recommendations with E-Commerce team in weekly meetings+ Managed performance against forecasted revenue goals and industry benchmarks­Served as email campaign manager for WB Digital e-Commerce websites, providing segmentation strategy and data-driven recommendations to increase email ROI+ Including WBshop.com, HarryPottershop.com, ShopDCentertainment.com, Hobbitshop.com, CartoonNetworkShp.com­+ Designed and executed A/B tests around email segmentation and messaging; identifying success metrics, determining test/ control groups, and interpreting results+ Utilized various campaign automation tools (i.e. ExactTarget, Yesmail, Aprimo), relational data, Google Analytics to analyze campaign performance and consumer behavior on site­Lifecycle Email Strategy & Implementation­+ Developed strategy and segmentation business rules for triggered (automated) email campaigns; increasing incremental revenue­+ Elicited and communicated requirements to technical resources of ESP­+ Designed A/B Testing scenarios

San Francisco, California, Us

Industry- leading cross-media analytics solutions provider and marketing consultancy for more than half of the Fortune 50

Cambridge, Ma, Us

Analyzed trends in cloud technologies being used to enable enterprise business intelligence capabilities

Killeen, Tx, Us

Mba, Marketing & Decision Sciences

Master Of Business Administration (Mba)

Ba, Double Major: Business Economics, Sociology