Scroll To View More
Abayomi Obawomiye, Multidimensional Expressions (MDX) Developer in Scottsdale, AZ, United States
Abayomi Obawomiye

Multidimensional Expressions (MDX) Developer in Scottsdale, AZ, United States

Member since May 25, 2017
Abayomi is a senior SQL Server/BI developer with over a decade of experience in designing, developing, deployment and maintenance of enterprise business intelligence solutions across multiple industries. He has built small to enterprise-sized data warehouses and business intelligence solutions based on Microsoft Technologies. He joined Toptal to find interesting database and data warehouse projects and to work with talented people.
Abayomi is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 8 years
  • SQL Server Integration Services (SSIS), 7 years
  • Microsoft Team Foundation Server, 5 years
  • SQL Server Reporting Services (SSRS), 5 years
  • SQL Server Analysis Services (SSAS), 5 years
  • Multidimensional Expressions (MDX), 4 years
  • PowerPivot, 4 years
Scottsdale, AZ, United States

Availability

Part-time

Preferred Environment

SQL Server, Visual Studio, Team Foundation Server

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.

Employment

  • Database Developer

    2019 - PRESENT
    Caterpillar, Inc. (via Toptal)
    • Automated and redesigned a massive spreadsheet process which 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.
    • 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 & Web API 2).
    Technologies: SQL, Databases, Data Modeling, Microsoft SQL Server, Data Architecture, Microsoft Access, Microsoft Azure
  • Business Intelligence Consultant

    2018 - PRESENT
    Valore Partners
    • Implemented configuration tables at the reporting end (SQL Database) to support the increasing demand for customized solutions from 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.
    • 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.
    • Ensured that the ETL architecture met best practices and the latest trends.
    • Implemented initial loading using SSIS and growth sizing.
    • Implemented incremental loading using Change Data Capture (CDC) within SSIS.
    • Completed and deployed SSIS master-child ETL package in Azure.
    • Created and deployed SSAS (tabular) model to enhance reporting.
    • Built reports and dashboards using Tableau and Power BI.
    Technologies: C#, SQL Server, PoweShell, SSIS, SSRS, SSAS (Tabular and Multi-dimensional), DAX, Tableau, Power BI, Data Warehousing, ETL
  • Tableau Expert

    2019 - 2019
    Integrated Insight (via Toptal)
    • Built visualization dashboards using Tableau.
    • Extracted, cleansed and transformed data from excel spreadsheet into tableau.
    • Designed and created data visualizations that help to analyze current market trends.
    Technologies: Tableau, Data Visualization, Microsoft Excel, SQL Server
  • MS 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.
    Technologies: MS SQL Server, Node.js, Express.js
  • Power BI Developer

    2019 - 2019
    IQZone (via Toptal)
    • Wrote Power BI reports both at detailed and summary levels.
    • Created custom visualizations using R.
    • Implemented Power BI report versioning.
    Technologies: Power BI, SQL Server, Custom Visuals, R, Azure, BitBucket
  • 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 role.
    • Created .NET based web application with Power BI embedded reports.
    • Set up active directory accounts within Azure.
    • Created Power BI reports and improved the performance of existing reports.
    Technologies: Power BI Embedded, C#, Azure, Azure Active Directory, SQL Server, HTML, CSS, JavaScript, MVC
  • 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 end 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 compared to older static reports.
    Technologies: SQL Server, SSAS, SSIS, SSRS, Microsoft Power BI, Jira, Excel, Tableau, Python
  • Microsoft Power BI Developer

    2019 - 2019
    Linksbridge SPC (via Toptal)
    • Automated data extraction from webpages using Web API calls.
    • Created Power BI reports and dashboards.
    • Implemented row-level security and set up an active directory within Azure.
    • Created and deployed embedded Power BI reports.
    Technologies: Postman, Power BI, SQL, Azure, Web API Calls
  • 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 is then stored in the database for advanced analytics.
    • Cleansed, structured, and standardized the dataset in addition to creating 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 Entity Framework for object-relational mapping to database entities.
    • Utilized Power BI and DevExpress Controls for reporting.
    Technologies: Power BI, SQL, PHP, JavaScript, D3.js, Highcharts, Python, MariaDB, ASP.NET MVC 5, C#, DevExpress, Javascript, Bootstrap, Agile
  • 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: SQL Server, Replication, SSIS, SSAS, SSRS, Power BI, Tableau, C#, TFS
  • Freelance Tableau and Data Expert

    2018 - 2018
    Various Clients (via Toptal)
    • 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 database 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 setup.
    Technologies: SQL, Tableau
  • 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/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/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 (to fit the business need) and loading the transformed data into their final destinations (database, data warehouse, flat files).
    • Optimized the query performance by applying simple tuning techniques like creating indexes and rewriting poor performing queries.
    • Collaborated with 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.
    • Wrote C# and JavaScript code to create data-driven dashboards.
    • Deployed, supported, and monitored with a team some SQL scripts and various applications (SSIS, SSAS, SSRS).
    Technologies: SQL Server, Power BI, .NET, C#, SSIS, SSAS, SSRS, Tableau, T-SQL
  • Senior SQL and 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.
    • 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 requirement.
    • 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 as well as publishing the dashboards onto the web pages.
    • Scheduled the delivery of several reports to multiple users through Subscriptions in different formats like Excel, PDF, and text.
    • Created a simple web application using ASP.NET and C#.NET.
    Technologies: T-SQL, SSIS, SSAS, SSRS, Power BI, Excel, C#, HTML, SQL Server
  • 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: T-SQL, SSIS, SSAS, SSRS, Power BI, Excel, C#, HTML
  • SQL/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 sourced 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/dimensional modeling, expansion, security, and maintenance of a SQL data warehouse.
    • Created dashboards using Power BI and Tableau.
    Technologies: SSIS, SSAS, SSRS, T-SQL, Power BI, Tableau
  • Embedded Software Developer

    2014 - 2014
    Halliburton Energy Services
    • Developed part of LabVIEW software for communicating with 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, with a team, the multilingual user interface (MUI) feature for the CT-DAS Software.
    Technologies: LabVIEW, C#, SQL Server, SSIS, SSRS
  • Founder | Software Developer

    2010 - 2013
    Hookes Electric Limited
    • Gathered system requirements through end-user collaboration.
    • Wrote data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, and so on).
    • 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, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary with profiler and execution plans.
    Technologies: T-SQL, SSIS, SSRS

Experience

  • Field Analysis and Reporting Application | FARA (Development)

    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 (Development)

    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.

Skills

  • Languages

    HTML5, T-SQL, PHP 7, CSS, ECMAScript (ES6), C#.NET, HTML, C#, JavaScript
  • Frameworks

    CodeIgniter 3, CodeIgniter, Angular, ASP.NET, Laravel
  • Tools

    PowerPivot, Microsoft Team Foundation Server, Microsoft Dynamics CRM, Tableau, Microsoft Power BI, Tableau Desktop Pro, SSAS, Excel 2016, SSRS, Toad, Erwin
  • Paradigms

    Dimensional Modeling
  • Platforms

    Microsoft BI Stack, Azure, SharePoint 2013, SharePoint
  • Storage

    Microsoft SQL Server, Database Performance, Database Modeling, SSAS Tabular, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DataMart, SQL Server Integration Services (SSIS), PostgreSQL, MongoDB
  • Other

    Multidimensional Expressions (MDX), Pivot Tables, Performance Testing, Performance Tuning, Performance Analysis, Software Development, SharePoint Online, Informatica
  • Libraries/APIs

    jQuery, jQuery UI, Node.js

Education

  • Master's degree in Computer Science
    2013 - 2014
    Texas A&M University - Kingsville, TX, USA
  • Bachelor's degree in Electrical and Electronic Engineering
    2005 - 2011
    Obafemi Awolowo University - Ife, Nigeria
Certifications
  • Exam 761: Querying Data with Transact-SQL
    JULY 2018 - PRESENT
    Microsoft
  • Exam 767: Implementing a Data Warehouse
    JULY 2018 - PRESENT
    Microsoft
  • Microsoft Certified Professional
    JULY 2018 - PRESENT
    Microsoft
I really like this profile
Share it with others