Scroll To View More
Hire the top 3% of freelance developers
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
Portfolio
Experience
  • 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
Availability
Part-time
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.
Employment
  • 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
    Neudesic
    • 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
    Healthways
    • 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
Experience
  • Enterprise Data Model for a Financial Institution (Development)

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

Skills
  • Tools
    PowerPivot, MS PowerBI, Microsoft Dynamics CRM, Microsoft Team Foundation Server, Microsoft PowerApps, Microsoft Flow
  • 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, SharePoint Online, Multidimensional Expressions (MDX), Informatica
  • Languages
    HTML, C#
  • Libraries/APIs
    jQuery
  • Paradigms
    Scrum
Education
  • 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
Hire the top 3% of freelance developers
I really like this profile
Share it with others