Dayo O.

Experience

• 

  GTBank

  Dec 2013 - Jan 2016

  Data Engineer

  ● Designed and developed the bank's data warehouse using On-Premises Oracle Data Warehouse, handling millions of transactions daily and ensuring robust data management and processing capabilities.● Created and optimized data pipelines with SQL, PL/SQL, and Oracle Data Integrator (ODI), achieving 100% data availability and quality for accurate and reliable reporting.● Developed comprehensive reports and dashboards using SSRS and Oracle BI (OBIEE), supporting daily decision-making processes and enhancing organizational insights.● Implemented cross-selling models to analyze customer transaction patterns, leveraging PL/SQL and data warehousing techniques to deliver personalized product recommendations, generating over $10 million in revenue for the bank.● Utilized SSIS and Oracle Data Integrator (ODI) to streamline data integration and transformation processes, ensuring efficient data flow and enhancing overall data warehouse performance. Show less

• 

  University of London

  Jun 2016 - Mar 2017

  Database Assistant

  ● Improved the integrity of the data in the alumni database by regularly cleaning incorrectly entered addresses, emails, phone numbers, educational background and other constituents' information to facilitate effective fund raising by the University's fund-raising team.● Carried out regular deduplication process to merge duplicate copies of the same data.● Migrated all historical alumni hard copy data into Microsoft excel in an organized way for the Database Manager to perform mass uploads into the database. Show less

• 

  Jumia Group

  Apr 2017 - Aug 2018

  Business Intelligence Analyst

  ● Developed and delivered commercial, finance, and marketing reports and dashboards using Power BI and QlikView, providing actionable insights and driving strategic decision-making.● Extracted valuable insights from sales and marketing data warehouses to support major revenue campaigns, leveraging SQL, Python, and Google Analytics for in-depth analysis.● Optimized ETL processes to enhance data processing efficiency, reducing report generation times from days to hours and improving overall workflow productivity.● Utilized BigQuery and SQL Server to design and maintain robust data infrastructure, ensuring seamless integration and accurate reporting across multiple platforms.● Leveraged Power BI and QlikView to create dynamic and interactive dashboards, enabling stakeholders to easily visualize and interpret key performance metrics and trends. Show less

• 

  The Coca-Cola Company

  Aug 2018 - Mar 2021

  Senior Data Engineer

  ● Led the optimization of the sales process using machine learning for outlet segmentation and suggestive ordering, resulting in a 32% uplift in sales performance.● Developed and implemented a single source of truth data lake on Azure, standardizing reporting across 14+ bottling partners and resolving data inconsistency issues within the Coca-Cola ecosystem.● Designed and built data pipelines using Azure Data Factory and Azure Databricks to efficiently process data from the data lake into Azure Synapse Analytics, ensuring seamless data flow and integration.● Drove the adoption of a self-service BI culture by developing automated reports on Power BI, reducing decision-making time from weeks to minutes and enhancing organizational agility.● Utilized SQL, Spark, and Azure technologies to optimize data processes and analytics, leveraging Azure ADLS Gen2, Azure Synapse Analytics, and machine learning models to improve data management and business insights. Show less

• 

  Yellow Card App

  Sept 2021 - May 2022

  DataOps Engineer

  ● Built and maintained batch and real-time data pipelines on AWS using Terraform for Infrastructure as Code, integrating DynamoDB, Kinesis, Kafka, Lambda, Glue, Athena, and Redshift to ensure scalable and reliable data processing.● Developed and optimized Spark applications for processing large datasets on AWS, leveraging cloud-based technologies to enhance data analysis and performance.● Created and managed REST APIs using Python Django Rest Framework, facilitating efficient data upload and processing, and ensuring seamless integration with backend systems.● Established and led a data engineering team, including hiring and managing three data engineers, overseeing team deliverables, and ensuring high-quality project execution.● Developed machine learning models for demand forecasting using Prophet, ARIMA, and RNN, enabling precise demand planning and effectively eliminating out-of-stock issues. Show less

• 

  Sonder Inc.

  May 2022 - Jul 2022

  Business Intelligence Engineer

  ● Developed and maintained data transformation jobs using FiveTran, DBT, and Airflow, ensuring efficient and accurate data processing pipelines.● Refactored DBT models to enhance data security and improve user experience, contributing to more robust and secure data operations.● Empowered end users with self-service business intelligence capabilities by implementing Tableau and Metabase, integrated with Snowflake for improved data accessibility and insights.● Utilized SQL and Python to design and optimize complex data workflows and models, ensuring high performance and scalability in data environments.● Implemented and managed data solutions on AWS, leveraging cloud services to support scalable data infrastructure and seamless integration with Snowflake and other tools. Show less

• 

  DemandScience

  Aug 2022 - Sept 2024

  ● Led a team of data engineers and software engineers to deliver data engineering and artificial intelligence projects from inception to completion, including goal setting, scope definition, and ensuring on-time delivery through cross-team collaboration. ● Define and incorporate data quality strategies into daily work.● Implement data encryption, access controls, and authentication mechanisms to protect sensitive customer information and comply with data privacy regulations.● Evaluate emerging data technologies and select appropriate data engineering tools, platforms, and software solutions to enhance the efficiency of data infrastructure and pipelines. ● Monitor costs associated with data engineering tools and services, adjusting as necessary to optimize budget allocation. Show less ● Developed & maintained scalable data pipelines using Airflow, DBT, SQL, Python and AWS to integrate data from numerous internal and external data sources into Snowflake to power the business’ 200million USD lead generation product. ● Developed data models using a variety of modeling techniques and appropriate technology stacks such as DBT. ● Wrote clean, iterative code based on TDD and leveraged continuous delivery practices to deploy, support, and operate data pipelines.● Trained and deployed company revenue prediction machine learning model using Snowflake’s Snowpark to predict the revenue of over 18 million companies to enrich the organization’s data asset.● Developed a SQL Assistant using Open AI LLM to enable non-technical stakeholders to interact with the Snowflake Data Warehouse to extract business insights using Natural Language.● Collaborated with data scientists, data engineers, machine learning engineers and business stakeholders to implement and operationalize scalable Artificial Intelligence solutions such as an AI Powered Buyer Intelligence product to generate leads for our customers and revenue for the business. ● Evaluate and implement various big-data technologies and solutions to optimize processing of extremely large datasets in an accurate and timely fashion.● Analyze data quality of new external data sources to help the business make informed data buying decisions. This saved the business millions of dollars. ● PostgreSQL database performance optimization for Email Validation Product through query optimization and database parameters tuning which improved application’s performance by over 50% (50 minutes processing time for 500k emails reduced to 20minutes). Show less

  • Data Engineering Manager

    Jan 2024 - Sept 2024

  • Senior Data Engineer

    Aug 2022 - Dec 2023