Scroll To View More
Ayo Olatunji

Ayo Olatunji

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
  • Concord Servicing
    SQL Server, Intergration Services, ERWin, TFS, PowerBI, DAX
  • Choice Hotels
    Git, SQL Server, Integration Services, C#, Java,
  • Neudesic
    SQL Server, Salesforce, Integration Services, Analysis Services, TFS
  • Microsoft SQL Server, 7 years
  • SQL Server Integration Services (SSIS), 6 years
  • Microsoft Team Foundation Server, 5 years
  • SQL Server Analysis Services (SSAS), 5 years
  • SQL Server Reporting Services (SSRS), 4 years
  • Multidimensional Expressions (MDX), 4 years
  • PowerPivot, 3 years
  • MS 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.
  • Lead Business Intelligence Developer
    Concord Servicing
    2016 - PRESENT
    • 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
  • Senior Data Integration Devloper
    Choice Hotels
    2015 - 2016
    • 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
    Desert Schoold Federal Credit Union
    2013 - 2013
    • 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.

  • Tools
    PowerPivot, MS PowerBI, Microsoft Dynamics CRM, Microsoft Team Foundation Server, Microsoft Flow
  • Platforms
    SharePoint 2013, Azure, SharePoint
  • Storage
    SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), PostgreSQL
  • Misc
    Multidimensional Expressions (MDX), SharePoint Online, DAX, Informatica, Power Apps
  • Languages
    HTML, C#
  • Libraries/APIs
  • Paradigms
  • Master of Science degree in Information Management
    Arizona State University - Tempe Arizona
    2013 - 2013
  • Master's degree in Nanoscience and Nanotechnology
    George Mason University - Virginia
    2007 - 2008
I really like this profile
Share it with others