Tolu Adepoju, Developer in Scottsdale, AZ, United States
Tolu is available for hire
Hire Tolu

Tolu Adepoju

Verified Expert  in Engineering

Data Warehousing Developer

Location
Scottsdale, AZ, United States
Toptal 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.

Portfolio

Software Management Consults Ltd
SQL Server Integration Services (SSIS), Microsoft Dynamics CRM, IaaS...
Eklipse Consult
Erwin, Tableau, Azure, JavaScript, Java, C#, SQL...
ExxonMobil
Azure Data Factory, Microsoft Parallel Data Warehouse (PDW), Azure, Power Pivot...

Experience

Availability

Part-time

Preferred Environment

Core, Git, SQL, TypeScript, JavaScript, Tableau, Azure DevOps, Snowflake, Data Build Tool (dbt), DevOps

The most amazing...

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

Work Experience

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, Platform as a Service (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, SQL Server Reporting Services (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, SQL Server Reporting Services (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#

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.

Languages

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

Frameworks

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

Tools

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 Synapse, 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

Data Warehouse Design, Data Warehousing, Software Development, Front-end Development, Azure Data Factory, Azure Data Lake, Apps, Platform as a Service (PaaS), Core, IaaS, SAP, DAX, Data Build Tool (dbt)

Libraries/APIs

DevExtreme, jQuery, React, Node.js

2015 - 2016

Masters of Business Administration (MBA) Degree in Finance

Grand Canyon University - Phoenix, AZ

2005 - 2009

Bachelors of Science Degree in Economics

Bowen University - Iwo, Nigeria

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring