Abayomi Obawomiye, Developer in Chandler, AZ, United States
Abayomi is available for hire
Hire Abayomi

Abayomi Obawomiye

Verified Expert  in Engineering

Data Engineer and BI Developer

Location
Chandler, AZ, United States
Toptal Member Since
June 18, 2020

Abayomi is a senior SQL Server/BI developer with over a decade of experience in designing, developing, deploying, and maintaining enterprise business intelligence solutions across multiple industries. He has built small to enterprise-sized data warehouses and business intelligence solutions based on Microsoft Technologies. Abayomi joined Toptal to find interesting database and data warehouse projects and to work with talented people.

Portfolio

Hookes Electric Limited
SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)...
We the Protestors dba Campaign Zero
SQL, Python, Heroku, JSON, APIs, Airtable, Webhooks, Interactive Dashboards...
Fuji Vegetable Oil, Inc - Main
Data Analysis Consultant, Data Management, Microsoft Power Automate, SQL...

Experience

Availability

Part-time

Preferred Environment

Microsoft Azure, Visual Studio, Microsoft SQL Server, Jupyter Notebook, Databricks, Azure Data Factory

The most amazing...

...project I've worked on is a cloud-based enterprise business intelligence solution used by clients for critical reporting and decision making processes.

Work Experience

Founder | Software Developer

2010 - PRESENT
Hookes Electric Limited
  • Gathered system requirements through end-user collaboration.
  • Wrote data-related documentation such as file descriptions and definitions, entity relationships and attributes, and more.
  • Built new database objects like procedures, functions, triggers, indexes, and views using T-SQL in a development and production environment for SQL Server 2008.
  • Implemented indexes on tables and views for optimum performance tuning.
  • Designed CTEs for code management in complex stored procedures.
  • Contributed to dimensional data modeling and storyboarding ETL processes.
  • Designed the ETL process using SQL Server 2008 SSIS Packages which the data sources include flat files, Access, and Excel.
  • Created SSIS packages for loading the data from various sources involving flat-file and Oracle tables.
  • Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
  • Optimized the performance of queries with modification in T-SQL code, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes wherever necessary with profiler and execution plans.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), SQL Server Analysis Services (SSAS), Microsoft Azure, Microsoft Power BI, Tableau, Database Architecture, Azure Data Factory, SharePoint, Multidimensional Expressions (MDX), Dimensional Modeling, Pivot Tables, Microsoft Team Foundation Server, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Inventory Management, Microsoft Access, Data Management, Data Warehousing, Warehouses, Data Modeling, ELT

Developer

2023 - 2023
We the Protestors dba Campaign Zero
  • Consumed data from APIs and saved them into Airtable.
  • Created a front-end application with a user interface for users to interact with the data.
  • Deployed the application to Heroku and managed user access.
Technologies: SQL, Python, Heroku, JSON, APIs, Airtable, Webhooks, Interactive Dashboards, Reports, Inventory Management, Microsoft Access, Automation, Google Sheets, Data Management, Data Pipelines, Amazon Web Services (AWS), NoSQL

Data & Solution Consultant

2022 - 2023
Fuji Vegetable Oil, Inc - Main
  • Worked on Power Automate flows for extracting and formatting Excel attachments from dedicated emails based on preset rules.
  • Created a SQL Server database for storing extracted data.
  • Automated several manual processes to ease user experience and save time.
Technologies: Data Analysis Consultant, Data Management, Microsoft Power Automate, SQL, Business Intelligence Consultant, Data Warehousing, Reports, MySQL, Inventory Management, Microsoft Access, Automation, Google Sheets, Visual Basic for Applications (VBA)

Data Engineer - ADF

2021 - 2022
Commonwealth Financial Network
  • Created processes to stage JSON formatted API data into Snowflake by flattening the data for other functional services.
  • Created the Snowflake architectural data model and implemented complex stored procedures using data warehouse and ETL best practices. This also involved creating all the required tables, views, and functions.
  • Developed ETL pipelines to extract and ingest data from the data warehouse. Worked with the regulatory team to develop financial reports using advanced SQL queries in Snowflake.
  • Migrated data from files and Microsoft SQL Server into Snowflake using Azure Data Factory pipelines for ETL orchestration and for archiving records from SQL Server into Azure Blob storage.
  • Designed and developed SSIS ETL packages to stage CSV files and load them into different tables on SQL Server.
  • Built a data validation framework that improved overall data quality, focusing on reducing the time to process and analyze real-time data.
Technologies: Azure Data Factory, Snowflake, Microsoft SQL Server, SQL Server Integration Services (SSIS), Azure DevOps, GitHub, Confluence, Python 3, Dimensional Modeling, Microsoft Team Foundation Server, Database Performance, Database Modeling, Data Engineering, ETL, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Architecture, Interactive Dashboards, Reports, MySQL, Inventory Management, Microsoft Access, Automation, Azure Databricks, Data Management, Data Warehousing, Data Pipelines, Warehouses, Data Modeling, ELT, Amazon Web Services (AWS), NoSQL

Data Engineer

2021 - 2022
Chi/Donahoe
  • Developed a script hosted on Heroku that pulls and sanitizes data from Kira and imports that data into the Airtable base.
  • Developed script that pulled only new/updated data on a nightly basis on the command issued.
  • Configured a webhook to trigger events on database updates like rebuilding the website.
Technologies: Python 3, Scripting, APIs, Data Migration, Webhooks, JSON, SQL, Heroku, Airtable, Data Engineering, ETL, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Reports, MySQL, Inventory Management, Microsoft Access, Automation, Data Management, Data Pipelines, Amazon Web Services (AWS), NoSQL

Power BI/Tableau Developer

2021 - 2022
Dentsu U.S.
  • Recreated existing Tableau dashboards in Power BI. This involved understanding the existing reports and data in-depth and then recreating the metrics in Power BI using simple to complex DAX expressions.
  • Helped set up the Power BI infrastructure and administration. Advised client on required licenses to save cost and reduce waste. This was done by giving recommendations on licensing and role-based access.
  • Built highly interactive and performant Power BI dashboards to maintain or improve existing user experience.
  • Designed an automated process to consume monthly datasets. Cleansed and transformed the data to be used on the Power BI dashboards.
Technologies: Microsoft Power BI, Tableau, Microsoft SQL Server, PostgreSQL, Excel 2016, Dimensional Modeling, Database Modeling, Business Intelligence (BI), Dashboards, Interactive Dashboards, Reports, Data Analysis, MySQL, Inventory Management, Microsoft Access, Data Management, Data Warehousing, Data Modeling

Power BI Data Engineer

2020 - 2022
Defy Medical LLC
  • Helped reorganize some data and create some views with information from customers and products.
  • Developed and deployed Power BI reports and dashboards.
  • Implemented row-level security to control users' access.
  • Wrote SQL queries to retrieve data from multiple databases and also improve report performance.
Technologies: Microsoft Power BI, Microsoft SQL Server, Azure, Dimensional Modeling, Database Performance, Database Modeling, Business Intelligence (BI), Data Engineering, Dashboards, Interactive Dashboards, Reports, Data Analysis, MySQL, Inventory Management, Microsoft Access, Data Management, Data Warehousing, Warehouses, Data Modeling

SharePoint Expert

2021 - 2021
A2 Global Risk
  • Helped set up the foundations of a new SharePoint site.
  • Created default pages, set up security, and followed industry best practices.
  • Helped migrate content from the old PHP site to SharePoint.
  • Created Power Automate tasks for email scheduling and reporting purposes.
  • Created reports and dashboards that were embedded on the SharePoint site.
Technologies: SharePoint 365, Office 365, Microsoft Power Apps, Microsoft Power BI, Excel 2016, SQL Server 2016, Microsoft Power Automate, SharePoint, Business Intelligence (BI), Reports, MySQL, Inventory Management

Tableau Developer

2021 - 2021
BCG
  • Developed Tableau dashboards for analyzing sales data. Also modified existing Tableau dashboards to improve user experience and correct incorrect calculations. This involved meeting with the relevant stakeholders and users to discuss requirements.
  • Worked closely with business users, ETL developers, and solution analysts to understand their needs and represent them as Tableau dashboards.
  • Developed Tableau data visualizations using pie charts, scatter plots, geographic maps, bar charts, and cross tabs. Also created different KPIs using calculated key figures and parameters.
  • Cross-trained internal employees. Wrote custom SQL queries to extract and validate the dashboard data. Performed administrative tasks such as managing ownership, providing user access, group management, and permissions.
Technologies: Tableau, Tableau Server, PostgreSQL, Interactive Dashboards, Reports, Data Analysis, Inventory Management, Data Management

SharePoint and .NET Developer

2020 - 2021
Juno Risk Solutions Inc.
  • Developed, deployed, and sustained a solution in the client’s E3 instance of Microsoft’s Azure and Office 365 cloud services.
  • Provided recommendations on databases, programming languages, and configuration of SharePoint.
  • Performed deployment and configuration of the database, including all required tables and attributes.
  • Developed a user interface and built and configured screens for the internal and external portal in SharePoint.
  • Worked with the client's third-party partner to ensure that the developed RESTful API for exchanging information is functioning as expected.
Technologies: Azure, SharePoint Online, Office 365, .NET, C#, HTML5, CSS, JavaScript, Database Performance, Business Intelligence (BI), Inventory Management, Amazon Web Services (AWS), NoSQL

Database Developer

2019 - 2021
Fortune 100 North American Construction Equipment Manufacturer (via Toptal)
  • Automated and redesigned a massive spreadsheet process that connects with several downstream systems in order to make it more efficient and reduce the amount of manual work involved.
  • Designed and architected the data model. Set up the Azure server and databases and created ETL processes for data migration.
  • Advised on the best database system suited for the front-end application.
  • Created Web APIs to expose service and data endpoints using C# and ASP.NET (MVC 5 and Web API 2).
Technologies: Microsoft Azure, Microsoft Access, Data Architecture, Microsoft SQL Server, Data Modeling, Databases, SQL, Azure Data Factory, Microsoft Team Foundation Server, Database Performance, Database Modeling, Data Engineering, ETL, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Architecture, Sourcing & Procurement, Reports, MySQL, Inventory Management, Google Sheets, Azure Databricks, Data Warehousing, Data Pipelines, Warehouses, ELT

Business Intelligence Consultant

2018 - 2021
Valore Partners
  • Implemented configuration tables at the reporting end with an SQL database to support the increasing demand for customized solutions for the business.
  • Managed and was responsible for multiple business intelligence architectures. Implemented dimensional modeling, developed data warehouses, and created ETL processes.
  • Built tabular cubes using SQL Server Analysis Services (SSAS).
  • Authored reports and dashboards using Excel, Power BI, and Tableau.
  • Mentored and supported junior developers to get them up to speed.
  • Led business intelligence architectural meetings with developers and business owners.
  • Replicated existing OLTP data to Azure Managed Instance using transactional replication.
  • Provided dimensional modeling training to clients. Created and deployed SSAS (tabular) model to enhance reporting.
  • Ensured that the ETL architecture met best practices and the latest trends. Completed and deployed an SSIS master-child ETL package in Azure.
  • Implemented initial loading using SSIS and growth sizing. Implemented incremental loading using change data capture (CDC) within SSIS.
Technologies: ETL, Data Warehouse Design, Data Warehousing, Microsoft Power BI, Tableau, DAX, SSAS, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Windows PowerShell, Microsoft SQL Server, C#, Databricks, PySpark, Dimensional Modeling, Pivot Tables, Microsoft Team Foundation Server, Database Performance, Database Modeling, Business Intelligence (BI), Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Dashboards, Interactive Dashboards, Reports, Data Analysis, Data Pipelines, Warehouses, Data Modeling, ELT, Amazon Web Services (AWS)

SharePoint Developer

2019 - 2020
Complete Practice Resource
  • Updated and overhauled an existing SharePoint site from an on-premise solution to SharePoint Online.
  • Maintained Active Directory and Office 365 users within Azure.
  • Migrated users and client data from on-premise to Azure.
Technologies: Office 365, Azure Active Directory, Windows Server 2016, SQL Server 2016, Python 3, SharePoint 2016, SharePoint Online, Microsoft Power Apps, Visual Basic for Applications (VBA)

Power BI Developer and Consultant

2019 - 2019
Data Masons
  • Helped with some EDI integration and compliance management.
  • Developed Power BI reports and dasboards by replicating data from client-server applications, then deployed to a hosted solution offering.
  • Helped implement a robust Power BI architecture. Also helped to set up Power BI infrastructure within the organization.
Technologies: Dynamics CRM 365, Office 365, SQL Server 2016, Microsoft Power BI, Spark SQL, Business Intelligence (BI), Dashboards, Interactive Dashboards, Reports, Automation, Visual Basic for Applications (VBA), Data Warehousing, Data Modeling

Datorama/Tableau Business Analyst and Developer

2019 - 2019
Crossbeat New York
  • Worked on a part-time basis as a marketing data analyst and developer, helping the client continue developing their Datorama and Tableau dashboard.
  • Contributed to the integration and analysis of Google and Facebook ads.
  • Performed data analysis using Excel and built metrics that aided better business decisions.
  • Designed and developed ETL workflows and datasets in Alteryx used by the BI reporting tool.
Technologies: Google Analytics, Tableau, Redshift, Reports, Automation

Tableau Expert

2019 - 2019
Integrated Insight (via Toptal)
  • Built visualization dashboards using Tableau and Alteryx for the ETL workflow.
  • Extracted, cleansed, and transformed data from an Excel spreadsheet into Tableau.
  • Designed and created data visualizations that help to analyze current market trends.
  • Translated business logic from Excel and SQL into Alteryx.
Technologies: Microsoft SQL Server, Microsoft Excel, Data Visualization, Tableau, Database Performance, Interactive Dashboards, Reports, Automation, Data Build Tool (dbt), Data Pipelines, Data Modeling

Microsoft SQL Server and Node.js Senior Developer

2019 - 2019
Yodata (via Toptal)
  • Created an ETL service to extract and transform real estate CRM data into a JSON event-log format.
  • Wrote complex SQL queries to extract data from Microsoft SQL Server.
  • Created Node.js applications using the Express.js framework.
  • Oversaw the performance tuning of the queries and deployment.
  • Ran queries against Amazon Redshift, scheduling queries and managing clusters.
Technologies: Microsoft SQL Server, Database Modeling, Redshift, MySQL, Automation, Warehouses, Data Modeling

Power BI Developer

2019 - 2019
IQZone (via Toptal)
  • Wrote Power BI reports both at detailed and summary levels.
  • Created custom data transformation and visualizations using R.
  • Implemented Power BI report versioning to keep track of changes.
Technologies: Azure, R, Microsoft SQL Server, Microsoft Power BI, Business Intelligence (BI), Interactive Dashboards, Reports

Power BI and Software Developer

2019 - 2019
Triyam, LLC (via Toptal)
  • Created an embedded Power BI architecture such that different users have access to specific reports.
  • Implemented row and role level security to restrict report access based on the role.
  • Created a .NET based web application with Power BI embedded reports.
  • Set up active directory accounts within Azure to manage dozens of users.
  • Created Power BI reports and improved the performance of existing reports.
Technologies: JavaScript, CSS, HTML, Microsoft SQL Server, Azure Active Directory, Azure, C#, Microsoft Power BI, Business Intelligence (BI), Interactive Dashboards

Business Intelligence Consultant

2019 - 2019
Hospice of the Valley
  • Extracted and consolidated real-time and historical data from both legacy and current systems into an operational data store (ODS).
  • Created data marts for different business areas to accelerate business processes. The results were several highly performant SSAS tabular models specific to each subject area which were later used in creating the Power BI reports.
  • Built a well-designed and pilot-tested security model which the organization can use as a framework to build out an overarching security model for controlling access to visualizations and data.
  • Developed several interactive Power BI reports, which provided a better and unlimited experience than older static reports.
Technologies: Python, Tableau, Microsoft Excel, Jira, Microsoft Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSAS, Microsoft SQL Server, Interactive Dashboards, Reports, Data Warehousing, Warehouses, Data Modeling, ELT

Microsoft Power BI Developer

2019 - 2019
Linksbridge SPC (via Toptal)
  • Automated data extraction from web pages using web API calls.
  • Created Power BI reports and dashboards as part of my role.
  • Implemented row-level security and set up an active directory within Azure.
  • Created and deployed embedded Power BI reports and set up permissions to those reports to allow only authorized access.
Technologies: Azure, SQL, Microsoft Power BI, Business Intelligence (BI), Interactive Dashboards, Reports

Power BI and Software Developer

2019 - 2019
Digital Asset Capital (via Toptal)
  • Standardized and normalized datasets, created calculations and KPIs to power the analytics, and created a structured story that provides visibility across the organization.
  • Scraped data from hundreds of web pages and stored the extracted data into a MariaDB database.
  • Developed automated API calls to extract data from charts and webpages, which are then stored in the database for advanced analytics.
  • Cleansed, structured, and standardized the dataset and created relationships and hierarchies to support consistency in analytics and visualizations.
  • Created interactive charts and visualizations using D3.js and Highcharts.
  • Built analytical visuals embedded into web apps using Power BI.
  • Supported client-facing interfaces using the DevExpress UI controls and Bootstrap.
  • Utilized the Entity Framework for object-relational mapping to database entities.
  • Utilized Power BI and DevExpress Controls for reporting.
Technologies: Agile, C#, Python, JavaScript, SQL, Microsoft Power BI, Business Intelligence (BI), Reports, Warehouses, Data Modeling, ELT

Business Intelligence Consultant

2018 - 2018
Harkins Theatres
  • Developed a transactional replication implementation allowing for near real-time data replication and accurate change data capturing.
  • Built an on-demand ETL transforming over a dozen source systems into a data warehouse dimensional model.
  • Delivered a production data warehouse, including an SSAS semantic layer used for Power BI reporting.
Technologies: TFS, C#, Tableau, Microsoft Power BI, SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Warehousing, Warehouses, Data Modeling

Freelance Tableau and Data Expert

2018 - 2018
Toptal Project
  • Worked with an internal Toptal team to build 20+ interactive dashboards in Tableau for key performance indicators; this included working with various data sources.
  • Developed data integrity solutions by investigating existing databases and identifying data integrity issues—both human error and system inadequacies.
  • Executed solutions by working with the team to suggest optimizations to the system as needed. This included suggesting new system processes and set up.
Technologies: Tableau, SQL, Reports

Senior SQL and Business Intelligence Developer

2016 - 2018
CVS Health
  • Developed basic-to-complex SQL queries to extract data from both structured and unstructured sources.
  • Aided in the SQL Server and SSIS migration from 2008 version to 2014.
  • Wrote basic-to-complex queries to create SSRS, Excel, PowerBI and Tableau reports from SSAS cubes.
  • Created data and dimensional models for OLTP and OLAP applications.
  • Wrote different documentation for every project executed.
  • Built SSIS packages for extracting data from multiple databases—Oracle, SQL server—transforming the extracted data by applying relevant business logic and loading the transformed data into their final destinations.
  • Optimized the query performance by applying simple tuning techniques like creating indexes and rewriting poor-performing queries.
  • Collaborated with the QA team to design simple but effective technical specifications and test cases.
  • Worked with the business analysts to adequately understand and implement business requirements.
  • Interacted with end clients to help them understand their requests and meet their expectations.
Technologies: T-SQL (Transact-SQL), Tableau, SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), C#, .NET, Microsoft Power BI, Microsoft SQL Server, Data Warehousing, Warehouses, Data Modeling

Senior SQL | Business Intelligence Developer

2015 - 2016
MISOM Technologies
  • Interfaced with business analysts and customers to develop business requirements and translate them into functional specifications and design documents.
  • Developed implementation and test plans for ETL solutions/data acquisition strategies to support the data needs of enterprise data warehouses and reporting applications.
  • Performed dimensional modeling for building facts and dimensions for data warehouses.
  • Wrote T-SQL scripts and SSIS packages to load and update data into the data warehouse.
  • Built SSAS cubes. Scheduled the delivery of several reports to multiple users through Subscriptions in different formats like Excel, PDF, and text.
  • Performed database administrative tasks such as backing up databases, maintaining indexes, creating SQL agent jobs, and scheduling such jobs.
  • Wrote unit test cases to test ETL packages as per functional requirements. Created web applications using ASP.NET and C#.NET.
  • Created simple-to-complex stored procedures and functions used on front-end applications.
  • Performed schema comparison between development and test and pre-production servers.
  • Created ad-hoc, parameterized, drill down, and drill-through reports using SQL Server Reporting Services and Report Manager. Developed dashboard solutions for reporting and published the dashboards onto the web pages.
Technologies: Microsoft SQL Server, HTML, C#, Microsoft Excel, Microsoft Power BI, SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), Data Warehousing, Warehouses, Data Modeling, ELT

Senior SQL and Business Intelligence Consultant

2015 - 2015
CVS Health
  • Enhanced the old logical and physical database design to fit a new business requirement and implemented the new design into the SQL Server 2008 R2/2012.
  • Was actively involved in the installation, operational, and performance qualification document design.
  • Wrote TSQL scripts and complex stored procedures to implement the business needs and to support the front-end applications.
  • Created SSIS packages for implementing different types of business logic.
  • Built indexes to reduce data retrieval time and maintained index fragmentation.
  • Worked on database management activities such as data cleansing, indexing, and table creation.
  • Created and deployed SSIS packages using various transformations such as Fuzzy Lookup, Fuzzy Grouping, slowly changing dimension, aggregate, and derived column transformations.
  • Wrote unit test cases to test ETL packages as per functional requirements.
  • Performed schema comparisons between development, test, and preproduction servers.
Technologies: HTML, C#, Microsoft Excel, Microsoft Power BI, SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), Data Modeling

SQL and Business Intelligence Consultant

2014 - 2015
California Creative Solutions
  • Developed and maintained customized ETL processes for the online development team using SSIS.
  • Constructed SSIS package templates with customized logging and error handling options.
  • Wrote simple-to-complex SQL queries to extract data from multiple sources for reporting purposes.
  • Built and maintained various client-facing SSRS reports.
  • Worked with junior database developers on various SQL Server projects with multiple clients.
  • Implemented data and dimensional modeling, expansion, security, and maintenance of a SQL data warehouse.
  • Created and deployed dashboards using Power BI and Tableau.
Technologies: Tableau, Microsoft Power BI, T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), SSAS, SQL Server Integration Services (SSIS), Warehouses, Data Modeling, ELT

Embedded Software Developer

2014 - 2014
Halliburton Energy Services
  • Developed part of LabVIEW software for communicating with the Coiled Tubing Data Acquisition System.
  • Contributed to the development of the Hydraulic Work Over Unit Data Acquisition System.
  • Wrote a program to decode Manchester encoded fiber optic signals.
  • Interfaced between different field equipment using some specialized communication protocols.
  • Gained experience in selecting industrial controls, sensors, actuators, and monitors.
  • Developed, together with a team, the multilingual user interface (MUI) feature for the CT-DAS software.
Technologies: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server, C#, LabVIEW

Field Analysis and Reporting Application | FARA

FARA is a fleet and personnel management system designed specifically for mines, quarries, and construction sites. It is incredibly affordable and simple to use and set up while being deeply configurable and packed with features.

CVS Caremark Web Portal

This is a web portal to make it easy to order prescription refills, check drug prices and coverage, and find ways to save on medications. Users can also keep track of their medication and when they are eligible for a refill.

Azure Data Warehouse

Implemented a cloud-based data warehouse solution for a company that has mostly worked with on-premises solutions. Migrated data and infrastructure from on-premises to Microsoft Azure cloud.

Created backup and restore strategies for disaster recovery.

Languages

SQL, T-SQL (Transact-SQL), C#, JavaScript, Visual Basic for Applications (VBA), Python 3, Python, R, HTML5, CSS, Snowflake, HTML

Tools

Microsoft Access, Power Pivot, Microsoft Team Foundation Server, Tableau, Microsoft Power BI, Tableau Desktop Pro, SSAS, Excel 2016, Google Sheets, Azure Logic Apps, Visual Studio, Google Analytics, LabVIEW, Jira, TFS, Microsoft Excel, Microsoft Power Apps, Spark SQL, GitHub, Confluence, MATLAB

Paradigms

ETL, Dimensional Modeling, Business Intelligence (BI), Automation, Agile, Azure DevOps

Platforms

Azure SQL Data Warehouse, Microsoft BI Stack, Databricks, Dedicated SQL Pool (formerly SQL DW), Azure, SharePoint 2013, SharePoint, Amazon Web Services (AWS), SharePoint 2016, Windows Server 2016, Jupyter Notebook, SharePoint 365, Microsoft Power Automate, Heroku

Storage

Microsoft SQL Server, Database Performance, Database Modeling, SSAS Tabular, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), MySQL, Data Pipelines, PostgreSQL, SQL Server 2016, Azure Active Directory, Databases, MongoDB, Redshift, JSON, Database Architecture, NoSQL

Other

Microsoft Azure, Data Warehousing, Data Modeling, Data Architecture, Data Visualization, Multidimensional Expressions (MDX), Pivot Tables, Performance Testing, Performance Tuning, Performance Analysis, Data Marts, Software Development, Data Management, Data Engineering, Dashboards, Interactive Dashboards, Reports, Data Analysis, Azure Databricks, Warehouses, ELT, SharePoint Online, Azure Data Factory, Architecture, Business Logic, Office 365, Dynamics CRM 365, DAX, Data Warehouse Design, Tableau Server, Scripting, APIs, Data Migration, Webhooks, Airtable, Data Analysis Consultant, Business Intelligence Consultant, Argo CD, CI/CD Pipelines, Sourcing & Procurement, Inventory Management, Data Build Tool (dbt)

Frameworks

Windows PowerShell, .NET

Libraries/APIs

PySpark

2013 - 2014

Master's Degree in Computer Science

Texas A&M University - Kingsville, TX, USA

2005 - 2011

Bachelor's Degree in Electrical and Electronic Engineering

Obafemi Awolowo University - Ife, Nigeria

JULY 2018 - PRESENT

Microsoft Certified Solution Expert (MCSE)

Microsoft

JULY 2018 - PRESENT

Exam 761: Querying Data with Transact-SQL

Microsoft

JULY 2018 - PRESENT

Exam 767: Implementing a Data Warehouse

Microsoft

JULY 2018 - PRESENT

Microsoft Certified Professional

Microsoft

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring