toptal.com
Contact us: +1.888.867.7001
Tolu Adepoju, Data Warehouse Design Developer in Scottsdale, AZ, United States
Tolu Adepoju

Data Warehouse Design Developer in Scottsdale, AZ, United States

Member since June 18, 2020
Over the last decade, Tolu has served in just about every role in the data-tier—helping organizations to attain maturity and harness the true potential of their data. From data modeling to physical deployments, leading migration efforts, designing, and implementing data strategy, he brings a diverse yet focused skillset to the table. Tolu has a knack for best practices and scalable architecture which he applies when delivering solutions through mature and well-established design patterns.
Tolu is now available for hire
Hire Tolu

Portfolio

Experience

Location

Scottsdale, AZ, United States

Availability

Part-time

Preferred Environment

Core, SQL Server Reporting Services (SSRS), Microsoft Power BI, PaaS, Apps, Azure Data Lake, Synapse, Git, U-SQL, SQL, ASP.NET, TypeScript, JavaScript, C#, Tableau, Azure DevOps, SQL Server Integration Services (SSIS), Azure Data Factory

The most amazing...

...project I have worked on is a highly customizable CRM for medical entities in the USA.

Employment

  • Technical Lead

    2016 - PRESENT
    Software Management Consults Ltd
    • Re-architected the existing ETL process and developed templates to ensure new designs remained consistent throughout the enterprise.
    • Architected and implemented an end-to-end migration process which included the setup of procedures for staging, cleansing, and de-identifying legacy data prior to moving into the cloud.
    • Designed and implemented (continuous integration and delivery) CI/CD at the data-tier.
    • Stewarded the development of multiple proofs of concepts (POCs) to aid architectural decisions at the program level.
    • Provided guidance on, and implemented several data privacy security provisions including row-level security and data masking rules.
    • Designed and reviewed several TDD (technical design document) and FDD (functional design document) documents, necessitated by new builds.
    Technologies: SQL Server Integration Services (SSIS), Microsoft Dynamics CRM, IaaS, PaaS, Microsoft Power BI, SQL, Continuous Integration (CI), C#, DevOps, Azure

  • Data Architect

    2015 - 2016
    Eklipse Consult
    • Interfaced with clients to identify, design and implement solutions that transform their reporting function to meet demanding requirements while continuing to provide value added insights to the business.
    • Served as an Individual contributor on multiple stages of several data warehousing projects DWH) - from scope to delivery.
    • Provided data governance advisory services which often included navigating clients through the understanding of challenges and approaches: metadata, data quality, and data stewardship.
    • Acted as a SME on several BI subject areas including DWH, ETL and performance tuning.
    • Developed highly customized and extensible ETL solutions where traditional design patterns proved inefficient.
    • Led multiple logical and physical database architectural design by applying data methodologies - Entity Relationship concepts and normalization.
    Technologies: Erwin, Tableau, Azure, JavaScript, Java, C#, SQL, SSRS, SQL Server Integration Services (SSIS), Agile

  • Sr. Data Analyst

    2012 - 2015
    ExxonMobil
    • Provided functional guidance on projects.Contributed to every stage of the DWH project from staging to BI reporting.
    • Communicated leadership goals and vision to direct reports.
    • Architected several tabular models to support self-service analysis, reporting and decision making, leaving the developers with more value-added tasks.
    • Developed data models and established operational metrics and key performance indicators for departmental and business unit reporting.
    Technologies: Azure Data Factory, Microsoft Parallel Data Warehouse (PDW), Azure, Power Pivot, SQL, Microsoft Excel, SSRS, SQL Server Integration Services (SSIS), VB, C#

  • Treasury Data Analyst

    2009 - 2011
    ExxonMobil
    • Worked on process flows and requirements for two major satellite projects and enabled reporting capabilities on different work streams.
    • Tasked with, and successfully re-engineered the cash forecasting process by teaming up with business lines to develop a model that recorded over 90% in time savings and improved forecast accuracy by over 20%.
    • Conducted full life cycle analysis (requirement to design) on an LNG development project that highlighted several risks pertinent to project success.
    • Wrote several algorithms to analyze local and foreign transactions in part compliance of AML (Anti-Money Laundering) statutes.
    • Interfaced extensively with vendors and purchase-to-pay (P2P) teams to automate parts of the account setup process with a view to speeding up the account verification process.
    • Gathered requirements, and served as an Individual Contributor (IC) on a process improvement initiative that was targeted at automatically analyzing periodic bank statements and reconciling interest amounts before reclassifying them.
    Technologies: Microsoft Excel, Azure, SAP, SQL Server Integration Services (SSIS), Visual Basic for Applications (VBA), C#

Experience

  • Zion HealthCare CRM

    Zion HealthCare CRM is a customer relationship management system intended for use by the healthcare industry operating within the United States, with its unique pain points and balance between privacy and automation needs.

  • TMS Reporting System

    An end-to-end solution encompassing a client-facing interface and data-mart, built to meet the needs of the financial function of a fortune 500 Corp.

Skills

  • Languages

    SQL, C#, JavaScript, HTML, Python, TypeScript, Java, VB, Visual Basic for Applications (VBA), CSS, MDX

  • Frameworks

    ASP.NET MVC, Bootstrap, ASP.NET, Angular

  • Tools

    SSRS, SQL Server BI, Tableau, Git, Synapse, Microsoft Power BI, Microsoft Dynamics CRM, Erwin, Microsoft Excel, Power Pivot

  • Paradigms

    ETL, Agile, Azure DevOps, DevOps, Continuous Integration (CI)

  • Platforms

    Azure IaaS, Azure PaaS, Android, Windows, Azure, OS X

  • Storage

    Database Modeling, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Parallel Data Warehouse (PDW), Amazon S3 (AWS S3), SQL Server Analysis Services (SSAS), U-SQL, MongoDB, NoSQL

  • Other

    Azure Synapse, Data Warehouse Design, Data Warehousing, Software Development, Front-end Development, Azure Data Factory, Azure Data Lake, Apps, PaaS, Core, IaaS, SAP, DAX

  • Libraries/APIs

    DevExtreme, jQuery, React, Node.js

Education

  • Masters of Business Administration (MBA) Degree in Finance
    2015 - 2016
    Grand Canyon University - Phoenix, AZ
  • Bachelors of Science Degree in Economics
    2005 - 2009
    Bowen University - Iwo, Nigeria

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM