Qudus Ayoola Email & Phone Number

Lagos, Nigeria

Seattle, Washington, United States

• Developed a python web scraping script that extract real estate data and properties geographic information.
• Used Azure Data Factory to automate weekly extraction of market price and monthly statistics on for-sale listing from residential database using web API and inserting into Azure SQL database.
• Orchestrate T-SQL stored procedure for data cleaning/transformation into dimensional model and archiving of data in the Data Lake.
• Set up Azure Blob storage(Data Lake) for staging and archiving of data.
• Set up user on Azure Active Directory and granted RBAC to user on different azure resources.
• Configured Azure key vault for managing credentials lifecycle.

Lagos, Nigeria

• Develop and monitor ETL pipelines to extract, transform and load data for analytical purpose using Azure Data Factory, Azure Databricks, Azure Log Analytics.
• Building and maintaining Clients’ Data Warehouses/Lakes both on Azure SQL database and Synapse Analytics Workspace (for data quality checks, data modeling, data standardization).
• Contributes on Data solution design/architecture, business requirement and security requirement documents.
• Collaborate with business analysts to understand client environments, organizational reporting requirements and propose configuration solutions that meet these.
• Data modeling (physical, logical, and conceptual) and designing schemas (star, snowflake) to represent and support business processes.
• Write SQL scripts, stored procedures, functions, and views to build business intelligence solutions

• Supports the facilitation of Data Science community in University of Ilorin.
• Ensuring professional and personal development within the Data science community by providing knowledge support and guidance to other data enthusiasts.

New York, United States

• Data Engineer Volunteer at IDIF (Center of Innovation for DEI in Finance), taking on the challenge of designing and implementing data warehouse for public pension data in order to help quantify public pension fund.
• Data modeling, database design, development, testing and implementation with RDMS.
• Build ETL pipeline with python pyodbc package.
• Write SQL script, stored procedure and views to help implement solution using SQL Server Management Studio (SSMS).
• Contributed as a Database Administrator by setting firewall rules to access to the database.

Lagos, Nigeria

• Computation using geospatial software
• Area computation
• Traverse computation
• Plotting survey data with AUTOCAD