Scroll To View More
Ayo Olatunji, Multidimensional Expressions (MDX) Developer in Gilbert, AZ, United States
Ayo Olatunji

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

Member since July 10, 2016
Ayo has vast experience in designing, developing, and maintaining business intelligence solutions across multiple industries. He has built small to enterprise-sized data warehouses and business intelligence solutions based on Microsoft technologies. He has also worked on designing and developing transactional databases across multiple industries. Ayo has great communication skills and a very strong passion for teaching.
Ayo is now available for hire



  • Microsoft SQL Server, 7 years
  • SQL Server Integration Services (SSIS), 6 years
  • SQL Server Analysis Services (SSAS), 5 years
  • Microsoft Team Foundation Server, 5 years
  • Multidimensional Expressions (MDX), 4 years
  • SQL Server Reporting Services (SSRS), 4 years
  • PowerPivot, 3 years
  • Microsoft PowerBI, 2 years
Gilbert, AZ, United States



Preferred Environment

SQL Server, Visual Studio, Team Foundation Server,

The most amazing...

...tool I've built is a dynamic and highly flexible data analytics platform used by external clients for critical decision making processes.


  • Business Intelligence Consultant

    2018 - PRESENT
    World Class Industries (via Toptal)
    • Architected and developed a business intelligence platform for a client. This solution involved dimensional modeling, data warehouse development, ETL development, analysis services (tabular cube) development and report/dashboard authoring using PowerBI.
    Technologies: SQL Server, SSIS, SSRS, PowerBI, SSAS
  • Lead Business Intelligence Developer

    2016 - PRESENT
    Concord Servicing
    • Redesigned the enterprise data warehouse to support self-service capabilities and ease of use.
    • Developed robust and scalable Business intelligence solutions (S.S.I.S packages and SSAS Multidimensional/Tabular cubes) for reporting purposes.
    • Demonstrated new functionalities to the IT team in order to improve efficiency in their current processes.
    • Led multiple business intelligence architectural design meetings to provide scalable solutions that support clients' reporting and analytical needs.
    • Participated in multiple strategic objective meetings to discuss scalability and the improved performance of current OLTP and data warehouse platforms.
    • Provided technical support and mentorship to developers.
    Technologies: SQL Server, Intergration Services, ERWin, TFS, PowerBI, DAX
  • SQL Developer / PowerBI Consultant

    2018 - 2018
    IQZone (via Toptal)
    • Refactored current ETL process that migrates data from an on premise data via files to SQL azure database; Extracted and archived files via Azure blob storage, Refactored PowerBI reports.
    Technologies: PowerBI, S.S.I.S , SQL Server, Azure Data Factory Azure Blob storage
  • SharePoint Developer

    2018 - 2018
    Business Builders Inc (Via Toptal)
    • Rebranded customers on premise SharePoint site by developing customized responsive web forms and integrating with SharePoint.
    Technologies: SharePoint, HTML,CSS,JQuery
  • SharePoint Consultant

    2018 - 2018
    Exo Inc (via Toptal)
    • Built complex business processes using Microsoft flow, InfoPath, power Apps, database and SharePoint.
    Technologies: SharePoint, Microsoft Flow, SQL Server, PowerApps,InfoPath
  • SharePoint Consultant

    2017 - 2017
    Exxon Mobil (Via Toptal)
    • Built complex business process using Nintex forms and workflows.
    Technologies: SharePoint, Nintex Workflow, Javascript, HTML, CSS
  • Senior Data Integration Developer

    2015 - 2016
    Choice Hotels
    • Re-architected the data extraction and delivery process for external clients.
    • Provided production support for critical SQL Server transactional databases.
    • Maintained SQL Server service broker processes.
    • Created solutions using SSIS to implement medium to complex business logic.
    • Provided production support for operational and reporting databases, including on-call support as required.
    Technologies: Git, SQL Server, Integration Services, C#, Java,
  • Senior Consultant

    2014 - 2015
    • Designed an architectural roadmap for the OLTP data warehouse and analytical B.I tool implementation.
    • Built multiple multidimensional and tabular cubes to support business data reporting and analytics.
    • Provided production support for transactional databases.
    • Performed query tuning and optimization by applying appropriate indexing strategies and refactoring badly-written queries.
    • Redesigned the Operational data store (ODS) to support new business requirements.
    • Implemented enterprise logging strategies (database) and built dashboards and reports displaying the overall health status of connected applications.
    Technologies: SQL Server, Salesforce, Integration Services, Analysis Services, TFS
  • Senior Business Intelligence Developer

    2013 - 2014
    • Designed a fully-branded business intelligence portal in Microsoft SharePoint 2013 using Visual Studio, Design Manager, and SharePoint Designer.
    • Created custom SQL Server Reporting Services (SSRS) reports displayed in a customized SharePoint 2013 Business Intelligence site.
    • Built and maintained complex client-facing SSRS reports using visual studio and configuration tables in SQL Server.
    • Designed and implemented a tabular SSAS cube model for enterprise reporting and analytics.
    • Built data models using PowerPivot, which is accessed via SharePoint by business users.
    • Developed interactive reports using Power View.
    • Performed query tuning and optimization by applying indexing strategies and table partitioning.
    • Established coding and design standards for the Business Analytics team.
    Technologies: SQL Server, SharePoint, Integration Services, Reporting Services, TFS
  • Database Developer

    2013 - 2013
    Desert Schoold Federal Credit Union
    • Performed data mapping, data validation, and the migration of data from a legacy system to Microsoft Dynamics CRM 2011.
    • Configured and administered Microsoft Dynamics CRM 2011 software for enterprises.
    • Created and maintained various client-facing SSRS reports.
    • Developed and maintained customized ETL processes for the online development team using S.S.I.S.
    • Designed and implemented database architecture and database objects for enterprise projects.
    • Developed coding standards for the database team.
    • Created SSIS package templates with customized logging and error handling options.
    • Participated in database code reviews and database architectural designs with members of the team.
    Technologies: PostgreSQL, DB2, SQL Server, Integration Services, Dynamics CRM


  • Enterprise Data Model for a Financial Institution (Development)

    Re-architected the data warehouse using new and effective concepts and built a data analytics platform.

  • E.T.L Development with SSIS and Azure (Development)

    Refactored current ETL process that migrates data from on-premise data via files to a SQL Azure database; Extracted and archived files via Azure blob storage, Refactored PowerBI reports.

  • SharePoint Development ( InfoPath, Workflows and database) (Development)

    Built complex business processes using Microsoft flow, InfoPath, power apps, database, and SharePoint.

  • Web Development for Home Health Operations Management (Development)

    Built an admin portal for a home health organization using MVC, Entity Framework, Razor, HTML, CSS, and Azure SQL Database.

  • B.I Solution Design/Architecture and Development (Development)

    Architected and developed a business intelligence platform for a client. This solution involved dimensional modeling, data warehouse development, ETL development, analysis services (tabular cube) development, and report/dashboard authoring using PowerBI.


  • Languages

    HTML, C#
  • Tools

    PowerPivot, Microsoft PowerBI, Microsoft Team Foundation Server, Microsoft Dynamics CRM, Microsoft Flow, Microsoft PowerApps
  • Platforms

    SharePoint 2013, Azure, SharePoint
  • Storage

    SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft SQL Server, PostgreSQL
  • Other

    DAX, Multidimensional Expressions (MDX), SharePoint Online, Informatica
  • Paradigms

    Scrum, MVC Design
  • Frameworks

    MVC Razor, Entity 4
  • Libraries/APIs



  • Master of Science degree in Information Management
    2013 - 2013
    Arizona State University - Tempe Arizona
  • Master's degree in Nanoscience and Nanotechnology
    2007 - 2008
    George Mason University - Virginia
I really like this profile
Share it with others