Hi, I’m
Olumide Ibilaiye
Business Intelligence Developer
Aberdeen
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
15
years of professional experience
4
years of post-secondary education
4
Certifications
Work History
Airtel Networks NigeriaLagos
Business Intelligence and Analytics SME
10.2019 - Current
Job overview
- Responsible for the overall Data Management subject areas within Airtel Nigeria
- Translate business requirements to technical specifications.
- Design, build and deploy BI solutions (Tableau and IBM Cognos)
- Maintain and support data analytics platforms (ODS and Data Lake)
- Evaluate and improve existing BI systems
- Develop and execute complex database queries and conduct analyses
- Create visualisations and reports for requested projects
- Conduct unit testing and troubleshooting.
- Develop and update technical documentation
First Bank NigeriaLagos
Team Lead - Performance Reporting
05.2018 - 10.2019
Job overview
- Plan, coordinate and supervise all activities related to the design, development, and implementation of BI/MIS
- Coordinated maintenance, support and upgrade of existing BI/MIS systems and applications
- Ensure accuracy and timeliness in delivery of reports
- Review technical constraints and performance issues of business intelligence and MIS solutions
- Perform and coordinate coding duties in SQL, PL/SQL, PowerShell, Python etc
- Perform and coordinate unit testing, integration and system testing to ensure they meet quality standards
Union Bank NigeriaLagos
Team Lead - Business Intelligence
10.2014 - 05.2018
Job overview
- Managed delivery of BI solutions (portals, dashboards, standard and ad-hoc reporting) with a specific focus on data management/governance, and data warehouse architecture using SAP, Microsoft and IBM BI tools
- Managed through communicating requirements-oriented tasks and architecture, expectation setting for desired outcomes to guide team down a successful execution path
- Project assignments and tracking, as well as individual technical development plans
- Partnered with Business Managers, oversee planning for estimating and project commitment date setting to ensure delivery and appropriate resource allocation
- Managed project expectations, ensuring consistent execution and quality of delivery
- Drove critical project and product trade-off decisions
- Maintained resource forecast and resolved resource conflict and risk
- Ensured utilisation of investment allocated to team through the balance of projects, goals, and training
- Designed, developed, and unit tested standard and ad-hoc reports
- Influenced the direction of BI architecture, platforms, versions, and tool sets
- Worked to enable business partners in the development of their own reports and dashboard (Self-service BI)
Access Bank Nigeria, LagosLagos
ETL Developer
04.2008 - 10.2014
Job overview
- Used different data warehousing concepts to build a data marts for internal departments of the organization.
- Design of logical data models and implementation of the physical database structure
- Constructed and implemented operational data stores and data marts.
- Designed, developed, automated, and supported complex applications to extract, transform, and load data.
- Ensured data quality.
- Translated data access, transformation, and movement requirements into functional requirements and mapping designs.
Education
University of Ibadan
Bachelor of Science from Civil Engineering
06.2002 - 02.2006
Skills
Databases: Oracle (10g/11g/12c), MySQL, PostgreSQL, IBM DB2, MS SQL Server
Data Architecture: SQL Developer Data Modeler, CA ERwin Data Modeler ver 9r
ETL Tools: SSIS, Talend, Cognos Datastage, Apache Airflow
BI Tools: SSIS, SSRS, SSAS, Power BI, OBIEE, Cognos 10, SAP Business Objects
Source Control: MS Team Foundation Server, Git
Data : T-SQL, PL/SQL, PL/pgSQL, DAX
Scripting: Bash, PowerShell, MS Batch scripting, Python
Web: HTML CSS, XML, JSON
Accomplishments
- STAR Award (2016) in the Union Bank Employee Recognition (UBER) scheme for outstanding contributions towards the achievement of the bank’s corporate goals by going the extra mile in automating the entire process of BI DataMart build system.
- Worked in a team to design a loan collection service for salary backed retail loans per business requirements, this was implemented using robust stored procedures, functions, and triggers
- Analysed the business requirements and systematically designed a database of borrowing customers to assist in the timely rendition of Credit Bureau reports and other credit related regulatory reports. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes, and triggers. An event triggered job was used to automate this using a combination of ETL tools and database objects
- Successfully project managed Master Data Management implementation across four different domains i.e. Customer, Product, Finance/Employee and Vendor/Supplier
Certification
The Open Group Certified: TOGAF 9
Timeline
Business Intelligence and Analytics SME
Airtel Networks Nigeria
10.2019 - Current
Microsoft Certified: Azure Fundamentals
09-2019
The Open Group Certified: TOGAF 9
03-2019
Team Lead - Performance Reporting
First Bank Nigeria
05.2018 - 10.2019
IBM Business Intelligence Analyst Mastery
09-2016
COBIT® 5 Foundation
07-2015
Team Lead - Business Intelligence
Union Bank Nigeria
10.2014 - 05.2018
ETL Developer
Access Bank Nigeria, Lagos
04.2008 - 10.2014
University of Ibadan
Bachelor of Science from Civil Engineering
06.2002 - 02.2006