Download CV
Menu

Hello, I'm Afeez,
a Business Intelligence Consultant
at TalentNet Inc.
based in Toronto, Canada.

About Me

Afeez

Profile

    My strong background in finance, forecasting, equity research and economics, has led to my obsession with data and analytics at the individual and enterprise levels. I seek to enable change by identifying needs, articulating business requirements, and taking that through a course of scientific inquiry with a view to recommending solutions that will deliver value to stakeholders

    I am passionate about discovering predictive factors that add value and create competitive advantage

Education



University of California, Santa Cruz
 Data Science Program, An Extension of Udacity Nanodegree
2020-2021

University of Saskatchewan
 Master's Degree, Economics | Received Fully Funded Scholarship | Research Assistant
2016 - 2018
University of Lagos
 Bachelor's Degree, Economics
2007 - 2011

Work Experience

TalentNet Inc.
 Business Intelligence Consultant
may 2021 - Present

  • Reduced Power BI report load time and drill-through speed by more than 75 per cent, by conducting performance tuning exercises, such as auto-date/time disabling, refactoring the models etc.
  • Advising senior management on applications-database and Power BI data architectures that are compliant with clients’ service contract stipulations and consistent with the company’s business goals.
  • Completed migration of clients’ database to Azure SQL database and developed all Azure Data Factory resources (Pipelines, Dataflows, Linked Services and Datasets) for ETL operation to storage accounts.
  • Designed several Power BI reports and dashboards for all clients and embedded reports into company’s clients’ applications.
  • Developed and implemented Power BI Version Control solution, using SharePoint, Power App and Power Automate.

Sobeys Capital Inc.
 Data Analyst
August 2018 - Present

  • Data cleaning, exploration and manipulation for insights communication
  • Completed customer cluster analysis using Python KMeans machine learning algorithm in a targeted marketing campaign
  • Leverage SAP Data Services and SAP Information Steward tools to streamline data quality activities and empower key business users
  • Develop VBA macros to use in updating multiple Excel worksheets before mass export to SAP and SQL server data repositories
  • Running exception reports highlighting gaps/incongruent data to ensure standards are being met
  • Collaborate with Logistic Manager t0o regularly update the Distribution Centre, Finance, and store-level volume forecasts via SAP and Excel
  • Deploys SAP-enabled Winshuttle templates that are employed in consummating and pushing order requests from retail outlets.

ARAP Technologies Inc. Business Intelligence Analyst
December 2016 - August 2018

  • Banking: Implemented logistic regression to predict the probability that bankclients will buy investment product in a marketing campaign.
  • Insurance: Completed data analysis using dataset from the Image Review Unit for an insurer. I proposed recommendation to reducing the long wait timesin closing appraisal estimates (Report available in Power BI service)
  • Data Architecting:
    Proposed data architecture and designed warehouse for a client with 10years historical data, 27 million average daily transaction.
    Completed data architecting for a bank with over 50 million average dailytransactions, and HR needing to integrate staff information into SAP with corebanking system.

Legado Capital
 Private Equity Research Associate ( Summer Position )
May 2017 - September 2017
Haskayne School of Business
 Corporate Governance Teaching Assistant (Part-time )
June 2017 - August 2017
Meristem Nigeria
 Equity Research Analyst
January 2016 - May 2016
Stanbic IBTC
 Internal Auditor
January 2015 - December 2015

Investment Research Analyst
January 2014 - December 2014
Kaizen Capital
 Private Equity Business Analyst
January 2012 - September 2013

Awards & Achievements


  • Graduate Teaching and Research Fellowship Awards, Department of Economics, University of Saskatchewan, April 2017 to August 2017
  • Full Graduate Teaching Fellowship and Entrance/Tuition Awards, Department of Economics, University of Saskatchewan 2016-17 Academic Year
  • Offered $5200 Research Award/Grant (with Co-op), MA Business Economics, Wilfrid Laurier University July 2016
  • Offered $5000 Economics Graduate Prize, MA Applied Economics and Policy Analysis, University of Regina April 2016
  • Participated in Manager20 - Youth Reshaping the Future Conference, Zagreb, Croatia, April 2015
  • Olakano Memorial Prize for the Best Graduating Student in Economics, 2012
  • Zenith Bank Plc. for the Best Graduating Student in Economics, 2012
  • Joke Ajaiyi Prize for the Best Graduating Student in Economics 2012
  • Students’ Endowment Scholarship Award, University of Lagos 2008-2011
  • Top Student with a 5.00 CGPA in 100 Level Economics, University of Lagos 2008
  • Best Economics Student, Institute of Chartered Accountants of Nigeria – ATS 1 EXAMS 2007

Skills

I focus on getting the best of the data in an efficient way

Enabling change by identifying needs, articulating business requirements, and taking those through a course of scientific inquiry with a view to recommending effective and relevant solutions that will deliver value to stakeholders

  • Programming Languages
    • Python
    • SQL
    • R
    • MySQL
  • Data Science
    • Data Cleaning
    • Data Manipulation
    • Data Visualization
    • Data Mining
    • Data Analysis/Analytics
    • Data Warehousing
    • Predictive Modelling
  • Business Intelligence
    • Stakeholder's Engagements
    • Relational and Dimensional Modelling
    • ETL Developing
    • Data Warehouse Designing: Star and Snowflake Schemas
    • Data Warehouse Architecting: Kimball and Ilmon
    • Reporting Using SSRS
    • Dashboard Designing and Deployment with Tableau and Power BI
    • ETL and Orchestration in Azure Data Factory (Pipelines, Dataflows, Dataset & Linked Services) and Azure Synapse Analytics
  • Tools
    • SSIS
    • SSAS
    • SSRS
    • Power BI
    • Tableau
    • Azure Data Factory
    • Azure Synapse Analytics
    • Microsoft Power App and Power Automate
Linear-Regression
Machine Learning

Logistic Regression

Project Link

Predictive modelling using Craigslist Vehicles data set from Kaggle

Machine Learning

Customer Cluster Analysis

Project Link

Customer Segmentation Analysis- Using KMeans in Python: I exported the clustered data to a csv file, built data visualization in Tableau desktop, and published report on the web

Data Cleaning

Data Cleaning

Project Link

I cleaned Craigslist Vehicle data set sourced from Kaggle

Data Visualization

Public Insurance Project

Project Link

Using Power BI to analyze a 3-month data set sourced from the Image Review Desk Department for an Insurance Company. I employed Microsoft Power Query and M Language in data exploration, cleaning and profiling. We also used Microsoft Power BI for data visualization and analysis. This allowed me interact with the data set to generate insights intended to address some previously identified operational business problems

Data Manipulation

Value at Risk (VaR) of an Investment Portfolio

Project Link

Variance-Covariance Method to calculate the VaR of a portfolio of equities , relying on Yahoo! Finance historical stock prices API

Data Manipulation

Data Manipulation

Project Link

Data manipulation of Craigslist Vehicles data set from Kaggle

Application for Python
Application

ML & Statistics

Project Link

A-B Testing

Machine Learning

Monte Carlo Simulation of Stock Price of Apple

Project Link

Monte Carlo Simulation of Stock Price of Apple

Survival Analysis: Online Retail Users
Survival Analysis

Survival Analysis: Online Retail Users

Project Link

Survival Analysis: Online Retail Users

Cost Per Acquisition(CPA)

Cost Per Acquisition(CPA) Vs Life Time Value(LTV)

Project Link

Cost Per Acquisition(CPA) Vs Life Time Value(LTV)

Simulating Marketing Campaign
Marketing Campaign

Simulating Marketing Campaign

Project Link

Simulating Marketing Campaign

Simulating Markov Chain Model

Simulating Markov Chain Model

Project Link

Simulating Markov Chain Model