Joel Abrahams Email & Phone Number

Chapel Hill, Nc, Us

Durham, Nc, Us

Worked with campaigns team to deliver reporting and dashboard solutions that meet the needs of the organization.• Coordinated across projects to provide tactical; and strategic decisions regarding BI development• Mentor and provided knowledge transfer to less senior team members to help them achieve their goals and facilitate the development of the team• Designed and architected high performance BI/DW solutions to enable delivery of valued assets and ensure business needs are met and maintained.• Led and facilitated cross-functional problem-solving sessions to create optimal solutions to meet stakeholders needs (i.e. business requirements, delivery dates) to ensure successful product delivery• Provided guidance in the implementation and best practices in using Power BI across the organization• Developed reports, dashboards, and other needs by stakeholders to provide critical insights and information to high priority initiatives• Applied statistical analysis to evaluate campaign performance and effectiveness against outcomes*Started as contractor with NTT DATA

Atlanta, Georgia, Us

Consulted and delivered BI solutions including dashboards, reports, and statistical analysis.• Facilitated meetings and conducted interviews with key stakeholders to gather and document business requirements for analytical reports• Utilized statistical analysis to help management to formulate actions and provide support in the decision making process

Atlanta, Ga, Us

See description above for Business Intelligence Developer with Metas Solutions, LLC.

Austin, Texas, Us

Created and implemented reporting dashboards and data models to analyze, forecast, and report various mobile application trends• Conceptualized, designed and supported the implementation of analytics and reports utilizing a varietyof data warehouse front-end tools, primarily Tableau, Redshift, and Vertica• Leveraged advanced Tableau functionality (parameters, actions, API, complex calculations, etc.) tocreate internal business intelligence dashboards• Analyzed the impact of long tail attribution against client churn and third-party attribution providers• Utilized machine learning models in Python using Scikit-Learn Library to predict customer churn and identify feature importances that contribute to attrition

Latham, New York, Us

Design and build production-ready reporting applications and machine-learning models using CommerceHub’s proprietary data assets. • Developed and maintained automated reporting application with Python ETL scripts for extracting data hourly from Amazon Redshift into Amazon S3 to be ingested into BI tools• Built a product catalog reporting application using Python and a SQL Server database that integrated with a RESTful API asynchronously to enrich partial product records and store the results• Created and deployed SQL Server Analysis Services (“SSAS”) Tabular Models, created perspectives, made extensive use of DAX calculated tables and measures to satisfy business requirements using the Microsoft Business Intelligence (“BI”) Stack• Designed machine learning workflow in Python using Scikit-Learn Library to address the impact of product placement & promotions on performance• Engineered a prototype model to help identify product classification using scikit-learn and improved the quality of labeling using semantic similarity with a Word2Vec model using the Gensim Python library.• Calculated customer, vendor, and product lifetime values in order to improve marketing effectiveness• Predicted future sales through Bayesian structural time series analysis

Seattle, Washington, Us

Omni-channel online advertising strategizing, reporting, and analysis using Mercent technologies to provide value to clients, operations, executives and managers.• Researched and developed strategies of pay-per-click marketing programs (including Google, Bing, eBay Commerce Network, etc.) and marketplaces (Amazon, eBay, etc.) for portfolio of clients, including several Fortune 500 & Internet Retailer Top 500 companies to grow their accounts by as much as 50%+• Created, monitored and tracked daily and monthly ad spend budgets up to 1MM+ to meet client demand and ROI goals• Determined through data analysis and modeling answers to greater BI goals, such as whether to focus on new or existing customers, in stock product data and the relationship to sales, identifying the effectiveness of bidding strategies as they relate to client metrics by category• Identified efficiency trends and opportunities for growth across a client's portfolio of platforms• Designed and developed BI solutions that integrate with OLAP cube to improve client reporting and performance outcomes• Assisted with search specific market/client analysis to power sales pitches, marketing materials and industry thought leadership content• Optimize marketing programs by analyzing performance based on ROAS (Return on Ad Spend), impression share, ad spend, and various metrics• Used of statistical inference to analyze large data (regression, classification, text mining, hypothesis testing, etc.)

Seattle, Washington, Us

Prepared marketing research for managers to distribute. Brainstormed, and drove ideas for online advertising campaigns and improving marketplace data quality with the responsibility to create said ideas thereafter.• Campaign build, optimization, and reporting for 15 client accounts (including enterprise-level) in a variety of industries, with a particular emphasis in eCommerce• Advanced Search Engine Marketing (“SEM”) tools and techniques, such as bidding strategies (automated and manual), campaign types (primarily Product Listing Ads ("PLA"), dynamic search, dynamic remarketing, remarketing lists for search ads (“RLSA”), Google AdWords/Bing Ads editor, etc.), ad copy testing, and data feed quality analysis• Developed insights, guidance and and documentation of company’s SEM/Pay-per-click (“PPC”) best practices