Technical Lead
2016 - PRESENTSoftware 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, AzureData Architect
2015 - 2016Eklipse 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), AgileSr. Data Analyst
2012 - 2015ExxonMobil- 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, PowerPivot, SQL, Excel, SSRS, SQL Server Integration Services (SSIS), VB, C#Treasury Data Analyst
2009 - 2011ExxonMobil- 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: Excel, Azure, SAP, SQL Server Integration Services (SSIS), Visual Basic for Applications (VBA), C#
Tolu Adepoju
Data Warehousing Developer in Scottsdale, AZ, United States
Member since April 25, 2018
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
Portfolio
- Software Management Consults LtdSQL Server Integration Services (SSIS), Microsoft Dynamics CRM, IaaS, PaaS...
- Eklipse ConsultErwin, Tableau, Azure, JavaScript, Java, C#, SQL, SSRS...
- ExxonMobilAzure Data Factory, Microsoft Parallel Data Warehouse (PDW), Azure...
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
Experience
- Zion HealthCare CRM (Development)
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 (Development)
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, MDXFrameworks
ASP.NET MVC, Bootstrap, ASP.NET, AngularTools
SSRS, SQL Server BI, Tableau, Git, Synapse, Microsoft Power BI, Microsoft Dynamics CRM, Erwin, PowerPivotParadigms
ETL, Agile, Azure DevOps, DevOps, Continuous Integration (CI)Platforms
Azure IaaS, Azure PaaS, Android, Windows, Azure, OS XOther
Azure Synapse (SQL DWH), Data Warehousing, Software Development, Front-End Developer, Azure Data Factory, Azure Data Lake, Apps, PaaS, Core, IaaS, Excel, SAP, DAXLibraries/APIs
DevExtreme, jQuery, React, Node.jsStorage
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Parallel Data Warehouse (PDW), AWS S3, SQL Server Analysis Services (SSAS), U-SQL, MongoDB, NoSQL
Education
- Masters of Business Administration (MBA) degree in Finance2015 - 2016Grand Canyon University - Phoenix, AZ
- Bachelors of Science degree in Economics2005 - 2009Bowen University - Iwo, Nigeria
