Taiye Olorunfemi

Experience

• 

  National Engineering and Technical Company

  Jan 2002 - Jan 2003

  Trainee Process Engineer/CAD Designer

  National Youth Service Programme

• 

  Standard Trust Bank Plc

  Mar 2004 - Aug 2005

  Team Member, Domestic Operations
• 

  United Bank For Africa Plc

  Aug 2005 - May 2012

  I was involved in the Implementation,Testing and Management of Business Intelligent platform for UBA Group which comprises 19 OLTP installations (Finacle Core, Finacle Treasury and Finone) from 19 African countries, middle ware application and an interactive OLAP front-end for users. My team ensured data integrity, quality, mappings, and the correctness of extractions queries from various legal-entity specific primes systems within the financial group. Served as IT/Business Interface for the Financial Group. Designed and automated reports using Cognos 8BI - Cognos Report Studio, Analysis Studio & Framework Manager and Business Object for Risk Management and other divisions in the group.Designed and developed Universes and Web Reports on Business ObjectCreated Dashboard reports using Cognos cubesPrepared and validated the financials (Bbalance Sheet & Income Statements) for Legal Entities in the OLAP systemPrepared and validated regulatory reportsPrepared ETL scripts for IFRS (International Financial Reporting Standard) integration with the bank's OLAP systemInterfaced between Business users and Vendor on IFRS-related issues Show less  Liaised with Finacle consultants on issues that require urgent attention. Supervised new hires in the core banking application support unit Continuously trained/guided new hires on the job. Carried out EOD – End-of-Day processing, back ups and reports generation both in Finacle and Finacle Treasury. Executed EOM – End-of-Month/ EOY – End-of-Year processing with downloads of all relevant reports for Nigeria and international subsidiaries. Served as the technical expert in the successful roll-out of the core banking application (Finacle) in Chad and Gabon. Finacle (Core Application) service support for over 600 branch networks of the bank including international subsidiaries. Efficiently manages the services of the bank’s e-channel on a daily basis Actively involved in the management of incidents emanating from the users of the core application. Raises and effectively handles changes to be effected in the system with the view of addressing the incident permanently and improving day-to-day operations Constructs queries to retrieve data from the Oracle database using SQL and i-SQL*Plus.  Creates and maintains offices in the core banking application Generates reports for effective IT management and decision making. Assists DBAs in the efficient backup and recovery procedure for the assigned databases. Generates e-Statement for the bank’s customers Daily, Weekly and Monthly. Configures systems or PCs for Finacle users. Spear-headed the Data Validation, Extraction, Transfer and Loading Team of the Actimize Project. Show less

  • Application DBA/BI Analyst

    Jan 2010 - May 2012

  • Team Member, Core Banking Application Support

    Feb 2007 - Jan 2010

  • Team Member, Branch Support (Operations)

    Aug 2005 - Feb 2007
• 

  AxaMansard Insurance ( Formerly Guaranty Trust Assurance plc)

  Jun 2012 - Jan 2013

  Head, Enterprise Application Unit

   Responsible for ensuring availability, security and performance of the databases that support the system  Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance. To proactively monitor the database systems to ensure secure services with minimum downtime  Responsible for problem escalation to system Vendor and other third parties as appropriate Responsible for improvement and maintenance of the databases to include rollout and upgrades Performance monitoring, reporting and tuning of oracle database Creation and maintenance of SQL queries and routines  Writing of ad-hoc queries based on schema knowledge for various reporting  Software analyzing, review and testing People and software Management Show less

• 

  Union Bank of Nigeria

  Feb 2013 - Jul 2016

  Unit Head, BI/Data Warehouse, Project & Solutions Management Dept.

   Design & Development of Cognos Cubes & Framework Manager Model. Supervises the team to perform various maintenances at application and database levels for Cognos. Supervises Cognos Installation & upgrades. Supervises the security/user creation on the bank’s business intelligence platform – Cognos. Writes complex SQL Queries to be used in the delivery of various report requests. Manages the deployment of management and financial reports using report authoring tools – Analysis, Report and Query studios to help drive business processes for optimal result. Liaises with business users on mappings / data validation issues. Supervises the run of various build modules as and when required e.g on a daily and monthly basis. Supervises the team to ensure that the data extractions from different source systems e.g Flexcube, Xceed e.t.c are correct and complete. Manages the data warehouse ETL processes. Provides and supervises the technical support for the IFRS application – Flexfinance. Builds Report prototype based on business requirement and translates it to technical specs. Liaises with the vendors on issues that are beyond resolution in-house. Supervises the preparation and validation of the bank’s financials (Balance Sheet, Income Statement) on Cognos both at application and database levels. Supervises the loading and validation of financial budgets and KPIs into Cognos. Show less

• 

  Tenece Professional Services (Client: United Bank for Africa Plc)

  Aug 2016 - Oct 2019

  Senior BI & Data Warehouse Engineer

  Played leading role in the consolidation of 2 major Data warehouse & Analytics platforms of a leading bank in Nigeria both of which have more than 15 TB of financial dataDeveloped an Income Leakage Tracker that can add about $1 million to the bank’s bottom line per monthPromotes the use of Microsoft Business Intelligence (BI) tools and Self-Serviced capabilities across the organization using SSRS, SSIS, SSAS, and Power BIServes as a Subject Matter Expert in the area of Data Modelling, Data warehousing, and BI in the delivery of key projects for the Executive Management of the bankDevelops robust ETL platform using MS SSIS which pulls financial and static data located in disparate business systems of the organizationProvides technical expertise in the design of interactive visualizations of defined key metrics of the bank using Power BICustomer Segmentation – Segmentation of both Retail and Corporate Customers of the bank. More than 13 million customers were segmented by converting the business rules provided into scripts and later stored procedures Show less

• 

  LigaData

  Nov 2019 - May 2024

  Technical Lead, Data Engineering

  o Implements, deploy and manages different Data-as-a-Service use cases and products forthe client.o Provides mentorship & leadership to a total of 10 data engineers, at different times whoare based in Ireland, Nigeria, South Africa, Dubai, and Jordan.o Manages one of the biggest big data platforms in the country with a size of about 9 PB forthe telecom giant.o Works with the product owner and scrum master to groom the Agile backlogs inpreparation for the sprint.o Led 4 Data Engineers in the major upgrade of the 5 PB size Big Data platform fromHortonworks’ HDP 3.1.0 to Cloudera’s CDP 7.1.6o Spearheaded Apache Kafka project, which streams hundreds of millions of messages perday for driving customer campaign by the downstream consuming system. Show less

• 

  Hampshire Heights Global Company Limited

  Jul 2024 - now

  Lead Data Engineer