Business Intelligence Consultant
2016 - PRESENTAZ 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 WarehousingFull-stack Developer
2015 - PRESENTAcePointe- 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, AgileSoftware Developer
2017 - 2018TX3 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, GitSoftware Developer
2015 - 2016Eklipse 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, ERWINFinancial Data Analyst
2012 - 2015ExxonMobil- 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, PowerPivotTreasury Data Analyst
2009 - 2011ExxonMobil- 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
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
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
Availability
Full-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
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, MDXFrameworks
ASP.NET MVC, Bootstrap, AngularTools
SSRS, SQL Server BI, TableauParadigms
ETL, AgileStorage
SQL Server Integration Services (SSIS), AWS S3, SQL Server Analysis Services (SSAS), U-SQL, MongoDB, NoSQLOther
Data Warehousing, Software Development, Front-End Developer, DAXLibraries/APIs
DevExtreme, jQuery, React, Node.jsPlatforms
Android, Windows, Azure, OS X
Education
- Masters of Business Administration (MBA) degree in Finance2015 - 2016Grand Canyon University - Phoenix, AZ
- Bachelors of Science degree in Economics2005 - 2009Bowen University - Iwo, Nigeria
