top of page
IMG_0010_edited_edited.jpg

Since beginning my journey in this field, my dedication to the work and motivation to grow have led me to exceptional projects and experiences. I’m grateful for a profession I’m passionate about, and am proud to share examples of my greatest work. Take a moment to check out my portfolio, and get in touch with any questions.

Professional History

Past Positions

June 2020- Feb 2022

May 2022 - Aug 2022

Digital Marketing Analyst – Omnicom Media Group- Annalect

  •     Extracted, queried, and analyzed paid search data, social and programmatic campaign data and recommended actionable insights that revealed growth opportunities and improved ROI by 19% in Q3 using excel Pivot table, Google Analytics, and Tableau.

  •   Designed and documented a framework in excel (PIVOT TABLE and VLOOKUP) that reports ad-hoc, monthly, and quarterly campaign evaluation, trends, lift, and potential opportunities in the EMEA market with a compelling dashboard that shows the most effective way of allocating campaign resources in Tableau and PowerPoint 

  •   Implemented appropriate quality control procedures for marketing database, CDP, modeling, data classification, data patterns and harmonization, and naming conventions using SQL and Alteryx and improved data quality to 100% recurrently. 

  • Conducted Market research, A/B testing, competitive analysis and validated business hypotheses while working closely with Marketing teams, and improved lookalike and retargeting campaign performance by 17% in 3Q using SPSS and Excel.

  • ·Collaborated with cross-functional teams to develop campaign strategies and track performance of KPIs to identify underperforming and overperforming goals with optimization opportunities in datorama using Einstein bot and widgets

June 2020- Feb 2022

data scientist Marketing, Obiex Finance

  • Architected relational database with daily ETL processes to support data warehouse, consolidate implementation data, develop report distribution, and improve data quality by 18%.

  • Conducted-detail oriented research in collaboration with the Marketing unit and optimized marketing mix model that increased campaign key drivers by 10%

  • Employed exploratory data analysis using R on structured/unstructured data to uncover market trends and patterns and presented insights to stakeholders.

  • Identified and improved process and system improvement opportunities through monitoring audience metrics using Excel, R, Charts and PowerBI.

  • Employed creative process management and problem-solving skills to successfully define and manage timely ad hoc business decision processes.

Mar 2019- Aug 2021

Marketing Research & Analytics – Nnamdi Azikiwe University

  • Developed analytical approaches to answering business questions while demonstrating resourcefulness in obtaining and cleansing data from SEM, Socials, and display with actionable presentation in PowerPoint. 

  • Analyzed the effectiveness of marketing channels including web, email, advertising, events, PR, social and video coherently and provide insights and actionable recommendations using Excel pivot table, formulas, and Tableau

  • Bridged the gap between IT and the business using data analytics to assess processes, determine requirements, and deliver data-driven recommendations and reports to executives and stakeholders using Tableau and PowerPoint.

Dec 2017- Mar 2019

Digital Insight Analyst – Carefield Medicare

  • Periodically optimized data quality, analyzed, and provided business insight to stakeholders with interactive visualization dashboards; conducted hypothesis testing, correlation, regression, probability, A/B testing, and finalized research findings.

  • Created report that will help the team understand the customer journey and path to next-best actions and conversions in excel and Alteryx.

  • Developed and educated team on adequate process documentation to extract data from SEM, Social and display sources reducing report delivery lag and improved operational efficiency by 80%.

  • Machine Learning(regression model)

  • Microsoft PowerBI

  • Data Visualization Techniques

  • Structure Query Language(SQL)

  • Microsoft Excel(Vlookup, Pivot Tables, Formulas)

  • Google Analytics / Qlik

  • Data analytics/Business Intelligence

  • Oral and Written Communication and Presentation Skills

  • Statistical Analysis, CRM

  • Critical Thinking

  • Leadership

  • Strong Analytics Skills

  • Team player, self-driven

  • Result-oriented, Multitasking Skills

  • Self-motivated

  • attention to detail

  • Self-starter

  • Technical skills

  • Microsoft Office

SKILLS

PROFESSIONAL SKILLS

Projects

PRICE PREDICTION MODEL: CODE>

Firstly, i imported all the libraries that i can use to effortly write the code and model that would solve the problem. At this level, i am trying to clean up th dataset and fill up missing values as they are too many to delete. deletion will affect the outcome of the data and prediction. from the dataset, 'CUT' has over 60% of its data missing, using mode, mean or medium is not a good representation of the missing values thus, it should not be used for the analysis As noticed polish and symmetry are ordinal values with some missing value, i used mode to fill it up because i cant use mean nor medium.

note: from the orginal file, vendor was saved as integer which in think shouldnt be as it just vendors selling the diamond. more so, if i had left it, onehotendcoder will see and read it as an integer.

import pandas as pd

import numpy as np

import seaborn as sns

Publications

  • Ezenwafor, E. C., Olise, C. M., & Ebizie, P. I. (2021). Social Media Influencers, Business Intelligence Software and Purchase Intention amongst Social Media Users in developing African economy. Quest Journal of Computer, Statistics, Management and Social Sciences, 3(2), 217–228. https://doi.org/10.3126/qjmss.v3i2.41571

  • Ezenwafor, E. C., Ayodele, A. A., & Nwaizugbo, C. I. (2021). Social Media Marketing and Brand Loyalty Among Online Shoppers in Anambra State, Nigeria: Mediating Effect of Brand Awareness. Journal of Electronic Commerce in Organizations Team (JECO), 19(3), 16-27.

3099970173

  • Facebook
  • Twitter
  • LinkedIn

©2022 by Ebuka Ezenwafor

bottom of page