Scroll To View More
Tolu Adepoju, Data Warehousing Developer in Scottsdale, AZ, United States
Tolu Adepoju

Data Warehousing Developer in Scottsdale, AZ, United States

Member since April 25, 2018
Tolu has spent the better part of the last decade architecting, developing, and deploying solutions to create value at all levels of the enterprise. His wealth of experience enables him to serve as a full-stack developer. He has a knack for best practices, data, scalable architecture, and of course, coffee.
Tolu is now available for hire

Portfolio

  • AZ DCS
    C#, SQL, PowerShell, SSIS,SSRS, Tableau, Data Warehousing
  • AcePointe
    ASP.NET MVC 5, C#, DevExpress, Javascript, Bootstrap, Agile
  • TX3 Tech
    Java, Android, HockeyApp, Git

Experience

  • ETL, 8 years
  • SQL, 8 years
  • C#, 8 years
  • ASP.NET MVC, 7 years
  • SQL Server Integration Services (SSIS), 7 years
  • Tableau, 6 years
  • Data Warehousing, 6 years
  • Bootstrap, 5 years
Scottsdale, AZ, United States

Availability

Part-time

Preferred Environment

Visual Studio, Windows, Git, SQL Server, Toad

The most amazing...

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

Employment

  • Business Intelligence Consultant

    2016 - PRESENT
    AZ DCS
    • Re-architected the ETL process to align with best practices and current trends.
    • Wrote custom applications in C# and PowerShell to support automation - specifically for interfacing with external parties.
    • Implemented configuration tables at the reporting end (SQL Database) to support the increasing demand for customized solutions from the business.
    • Automated multiple routine reports via ETL (SSIS and C#) to free up development resources for more value-added work.
    • Supported in the development and publishing of reports via SSRS and Tableau.
    Technologies: C#, SQL, PowerShell, SSIS,SSRS, Tableau, Data Warehousing
  • Full-stack Developer

    2015 - PRESENT
    AcePointe
    • Created Web APIs to expose service and data endpoints using C# and ASP.NET (MVC 5 & Web API 2).
    • Supported client facing interfaces using the DevExpress UI Controls and Bootstrap.
    • Designed and deployed an OLTP database for back-end support.
    • Enforced business rules using C# and SQL.
    • Utilized Entity Framework for object-relational mapping of POCO to database entities.
    • Utilized SSRS, Tableau, and DevExpress Controls for reporting.
    Technologies: ASP.NET MVC 5, C#, DevExpress, Javascript, Bootstrap, Agile
  • Software Developer

    2017 - 2018
    TX3 Tech
    • Inspected and placed all legacy code under source control (Git).
    • Directed and enforced a process flow for all development work.
    • Removed dependency on dated third-party software that caused the gradle build to stall and fail intermittently.
    • Contributed in updating the codebase to take advantage of newer APKs.
    • Worked on a strategy to scale the app and drive growth by building supporting applications.
    Technologies: Java, Android, HockeyApp, Git
  • Software Developer

    2015 - 2016
    Eklipse Consult
    • Developed highly customized ETL solutions using SSIS for data warehouse and Transactional system data loads.
    • Supported the logical and physical database architectural design phases using.
    • Identified and corrected exceptions and inconsistencies in transactional data.
    • Gathered and documented software development requirements and design using system development life cycle (SDLC) methodologies.
    • Supported legacy applications based on the .NET Framework.
    • Proposed and led test-driven development (TDD) for current and subsequent projects.
    • Worked on various data-marts based on different methodologies (Kimball and Inmon).
    Technologies: Agile, SSIS, SSRS, SQL, C#, Java, Javascript, Azure, Tableau, ERWIN
  • Financial Data Analyst

    2012 - 2015
    ExxonMobil
    • Contributed to every stage of the DWH project from staging to BI reporting.
    • Created dashboards (SSRS and Excel) containing affiliate debt profiles, ROI, OPEX and CAPEX amongst other KPIs for senior management reporting purposes.
    • Re-architected the Modified Carry Agreement (MCA) models using ETL, Excel and SSRS to properly reflect Carry-Oil, Shared-Oil ratios and allow for complex scenario simulation – leading to about 30% reduction in reconciliation time, and cost savings of over $100k annually.
    • Created and maintained processes using ETL (SSIS) and T-SQL to validate periodic bank statements and reconciled interest amount data prior to reclassification in the general ledger.
    • Built multiple financial forecasting models to support self-service analysis, reporting and decision making.
    Technologies: C#, VB, SSIS, Excel, SQL, PowerPivot
  • Treasury Data Analyst

    2009 - 2011
    ExxonMobil
    • Stewarded banking reviews and relationships to ensure vendors and financial institutions met minimum expectations.
    • Executed foreign exchange, wire transfers, short-term investments, and cash call payments as needed.
    • Supported development of new applications to meet reporting needs.
    • Worked on the data migration strategy to recreate the operational data store (ODS) and Data warehouse (DWH).
    • Headed the cash management division for an extended period while manager was indisposed and successfully transitioned the division to a new treasury management system (TMS).
    Technologies: C#, VBA, SSIS, SAP, DWH, SQL

Experience

  • Zion HealthCare CRM (Development)

    A Customer Relationship Management System (CRM) for use by healthcare entities in the United States.

  • 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

    Java, SQL, C#, JavaScript, HTML, Python, CSS, MDX
  • Frameworks

    ASP.NET MVC, Bootstrap, Angular
  • Tools

    SSRS, SQL Server BI, Tableau
  • Paradigms

    ETL, Agile
  • Storage

    SQL Server Integration Services (SSIS), AWS S3, SQL Server Analysis Services (SSAS), U-SQL, MongoDB, NoSQL
  • Other

    Data Warehousing, Software Development, DAX
  • Libraries/APIs

    DevExtreme, jQuery, React, Node.js
  • Platforms

    Android, Windows, Azure, OS X

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
I really like this profile
Share it with others