Tolu Adepoju
Verified Expert in Engineering
Data Warehouse Design Developer
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
Experience
Availability
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
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.
Data Architect
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.
Sr. Data Analyst
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.
Treasury Data Analyst
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.
Experience
Zion HealthCare CRM
TMS Reporting System
Skills
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 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, Platform as a Service (PaaS), Core, IaaS, SAP, DAX, Data Build Tool (dbt)
Libraries/APIs
DevExtreme, jQuery, React, Node.js
Education
Masters of Business Administration (MBA) Degree in Finance
Grand Canyon University - Phoenix, AZ
Bachelors of Science Degree in Economics
Bowen University - Iwo, Nigeria