RAFIU OLALERE WOLE

Address: C/O Femi Salam, Grofin Nigeria. 9 Abimbola Awoniyi Close Victoria Island, Lagos.

Tel: 070********

E-mail: adnzjl@r.postjobfree.com

Location: Victoria Island, Lagos

Education

University of Ilorin, Ilorin. Kwara State. Nigeria. 2010

B. Eng (Agricultural Engineering)

Professional Qualifications

Revenue Assurance Analyst 28-Dec-2020

Customer Centricity 29-Dec-2020

Artificial Intelligence (AI) and Data Manager 24-Sep-2020

Digital Maturity and Transformation 29-Sep-2020

Business Development Manager 02-Oct-2020

Frameworx Transformation Manager 02-Oct-2020

Platform Development Manager 09-Oct-2020

R programming Language 04-Aug-2017

Data Science 03-Aug-2017

Big Data 03-Aug-2017

Oracle PL/SQL Developer Certified Associate 31-July-2015

Oracle Advanced PL/SQL Developer Certified Professional 31-July-2015

Oracle Certified Associate, Oracle Solaris 11 System

Administrator 06-Dec-2014

Oracle Business Intelligence Certified Implementation Specialist 01-Nov-2014

Oracle Database 11g SQL Fundamentals 1 22-Nov-2014

ITILL Certification In View

Professional Training

TM Forum(Digital Transformation):

Artificial Intelligence (AI) 2020

Open Application Interface (APIs) 2020

Revenue Assurance 2020

Digital Maturity and Transformation 2020

Business process Framework 2020

Information Framework 2020

Application Framework 2020

Customer Centricity 2020

Apache (Hadoop/NIFI):

Nifi (For ETL) 2019

Elastic Stack:

Filebeat (Data Extraction) 2018

Logstash (Data Aggregation and processing(ETL)) 2018

Elasticsearch ( Indexing and Storage) 2018

Kibana (Analysis and Visualization) 2018

Tableau:

Data Transformation 2018

Data Analysis 2018

Data visualization 2018

Bluemix Watson Analytics (IBM):

Data Transformation 2017

Data Analysis 2017

Data visualization 2017

Bluemix Watson Conversation (IBM):

Build and deploy chatbots and virtual agents across a variety of

Channels, including mobile devices, messaging platforms, and

even robots. 2017

Data Science (Python)

Numpy Package for Mathematical Calculation 2015

Pandas Library for Data Manipulation 2015

Matplotlib Library for Data Visualization 2015

Machine Learning

Power BI/Power BI Desktop:

Data Transformation 2015

Data Analysis 2015

Data visualization 2015

SPSS/Excel:

Data Transformation 2014

Data Analysis 2014

Data visualization 2014

Microsoft Business Intelligence:

Implementation of Enterprise Data Warehouse 2014

Extraction, Transformation and load (ETL) into Data Warehouse using T-SQL Procedure 2014

Reporting Data via SSRS Service 2014

ITLL Training

R Programming Language (JOHNS HOPKINS UNIVERSITY) 2014

Data Transformation 2014

Data Analysis 2014

Data visualization 2014

Oracle Business Intelligence:

Implementation of Enterprise Data Warehouse 2012

Extraction, Transformation and load (ETL and ELT) into Data Warehouse

Using SQL statement and PLSQL language 2012

Data Analysis using SQL Statement 2012

Reporting Data via OBIEE 2012

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g:

Data Transformation 2012

Data Analysis 2012

Data visualization 2012

COMPUTER WAREHOUSE GROUP, LAGOS 2012

Course: Introduction to Product Portfolio/ Business Overview

Basic Trouble Shooting of Hardware and software

Finacle Application (7 and 10)

Dell, Emc, Dell Modular Array

Hp-Commercial Desktop, Workstation, Notebooks and Servers

Overview of Enterprise Environment

IBM/IBM AIX

Windows Administration

Service Level Agreement

SUN, SUN Cam, UNIX Admin.

UNIX Shell Scripting

ATM Administration/ ATM H/W

NetApp DATA Ontap/Netapp

I.T Service Desk Software (Manage Engine), Service Desk Operation

Customer Service Training

Virtualization

Information Technology Infrastructure Library (ITIL)

Introduction to Project Management

Sales Overview, Strategies and Processes

End User Support, Scenarios and Case Studies

Cloud Computing/ Management Tech.

OBJECTIVES

To develop competence and attain the status of a professional in an organization with opportunities for career advancement, and to provide high quality services towards the achievement of organizational goals in a challenge driven environment

PROFILE:

A result oriented graduate of Agricultural Engineering

A self-motivated, innovative, dynamic, analytical minded person and a team player with good communication and interpersonal skills and abilities to master new technology

SKILLS:

Microsoft Office Suit and Hardware:

oMicrosoft Office Applications –Microsoft Excel, Word, PowerPoint

oBasic Troubleshooting of Hardware Components and Software

Data Science (Python)

Numpy Package for Mathematical Calculation

Pandas Library for Data Manipulation

Matplotlib Library for Data Visualization

Machine Learning

Oracle Business Intelligence:

Implementation of Enterprise Data Warehouse

Extraction, Transformation and load (ETL and ELT) into Data Warehouse

Using SQL statement and PLSQL language

Data Analysis using SQL Statement or OBIEE

Reporting Data via OBIEE

Microsoft Business Intelligence:

Implementation of Enterprise Data Warehouse

Extraction, Transformation and load (ETL) into Data Warehouse using T-SQL Procedure

Data Analysis using

Reporting Data via SSRS Service

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g

Data Transformation

Data Analysis

Data visualization

Power BI/Power BI Desktop:

Data Transformation

Data Analysis

Data visualization

Tableau:

Data Transformation

Data Analysis

Data visualization

Elastic Stack:

Filebeat (Data Extraction)

Logstash (Data Aggregation and processing(ETL))

Elasticsearch ( Indexing and Storage)

Kibana (Analysis and Visualization)

SPSS/IBM Watson Analytics:

Data Transformation

Data Analysis

Data visualization

R Programming Language (JOHNS HOPKINS UNIVERSITY)

Data Transformation

Data Analysis

Data visualization

Bluemix Watson Conversation (IBM):

Build and deploy chatbots and virtual agents across a variety of

channels, including mobile devices, messaging platforms, and

even robots.

Unix/Solaris Operating System:

UNIX Operating System- Manage and View Files and Directories and Change the Directory Contents, Create and Modify files and Use file Permissions, Create ACLs and Control the User Work Environment, Use Commands within the Shell, Perform System Process and Job Control, Archive Files and Create Archive, Compress, View and Uncompress Files, Perform Remote File Transfers, Use Components of the Desktop System, Use Command Lines Features and Help Resources

UNIX Shell Programming/Scripting

Solaris 10 OS System Administration –Installation of Solaris 10 Operating System, Managing Solaris 10 Operation System Local Disk Devices and File System, Performing mount and un-mount of the File System, Managing Software Packages and Patches on Solaris 10 Operating System, Executing BOOT PROM Commands, Performing User Administration, Controlling System Processes, Performing System Security, Configuring and Using Printer Services, Plan and perform System backup and recovery, Backup of a mounted File System with a UFS Snapshot, Configuration of Solaris Volume Manager, Configuration of NFS and AUTOFS, Configuration of Role Based Access Control [RBAC], Configuration of System Messaging, Zone Management; Configuration, Installation, Booting, Administering Packages and upgrading Solaris 10 OS with installed Zone Solaris 10 OS Network Administration.

Configuration and Management of: Network Interface Layer, Internet Protocol (Version 4 and 6) Addresses, IP Network Multi-pathing and Router

Finacle Application:

Writing SQL and MRT scripts, and call them from finacle 10 scripts to generate reports

Using I report tool to run SQL scripts, MRT scripts, PLSQL Packages and procedures

Customizing Finacle 10 Environment based on Business needs

oCommunication Skill

oProblem solving

oCustomer Management

oPresentation Skills

Work History

Tecnotree Corporation, Nigeria 2019 - Till Date

Enterprise Data Warehouse/Business Intelligence Head

Experience;

1.Implementation of Apache Nifi at MTN Nigeria for Data extraction from different sources.

2.Power Bi Implementation.

3.Data Analysis with SSAS/Power Bi

4.Report development with SSRS.

5.Extraction Transformation and Load (ETL) of Data from (NGVS) into Enterprise Data Warehouse (EDW) for Analysis using PLSQL/T-SQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

6.Loading File into Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, spool the output of the analysis into a file and send it to the report user using PLSQL/T-SQL Code and UNIX Scripting. This is an automated process scheduled to run at a specific time depending on the Business rules.

7.Loading File into a Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, then create table for the analysis done and grant access on it to the user that will use the analysis. This is an automated process scheduled to run at a specific time depending on the Business rules.

8.Creating a job that runs at any time to create different data marts in the data warehouse and analyse each of the data mart, grant access to different users on each of them.

9.Creating a procedure that brings real time data into data warehouse.

TAVIA TECHNOLOGY LIMITED, IKEJA, LAGOS 2015 - 2019

Business Intelligence Developer / Support Analyst

Experience;

1.Kibana Implementation at MTN Nigeria for Data Analytics

2.Extraction Transformation and Load (ETL) of Data from different data sources into Enterprise Data Warehouse (EDW) for Analysis using PLSQL/T-SQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

3.Research and Data Analysis (SPSS and Power BI) at Coronation Merchant Bank and MTN Nigeria.

4. Power bi implementation at MTN Cameroon

5. Loading File into Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, spool the output of the analysis into a file and send it to the report user using PLSQL/T-SQL Code and UNIX Scripting. This is an automated process scheduled to run at a specific time depending on the Business rules.

6. Loading File into a Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, then create table for the analysis done and grant access on it to the user that will use the analysis. This is an automated process scheduled to run at a specific time depending on the Business rules.

7. Creating a job that runs at any time to create different data marts in the data warehouse and analyse each of the data mart, grant access to different users on each of them.

8. Creating a procedure that brings real time data into data warehouse.

9. Using R/OBIEE/Power BI/Bluemix Watson Analytics (IBM) /PerformancePoint Services to create analysis, publish it on dashboard and then send the dashboard to the user as an email using agent.

10.Using R/OBIEE/Power BI/Bluemix Watson Analytics (IBM) /PerformancePoint Services to create analysis that shows real time transaction.

11.Transforming, analysing and visualizing data with R/OBIEE/Power BI/ Bluemix Watson Analytics (IBM)/PerformancePoint Services.

12.Building and Deploying Customer Chatbots with Bluemix Watson conversation services (IBM).

13. Database Testing

14. Data mining and Auditing

15.Testing Real-time data Processing Systems

16.Strong experience in Sql, Relational, Big Data and back end testing of Databases.

Projects Worked On:

1.Development of NCC NON RGS 48HRS process at MTN Nigeria to capture all subscribers that have not generated revenue after 48hours of the newly activated sim card and registered on seamfix (An Application) as directed by NCC.

2.Recharge by location at MTN Nigeria.

3.Research and Data Analysis (SPSS and Power BI) at MTN Nigeria for Trade Partner Commission Project.

4.Research and Data Analysis (Excel and Power BI) at Coronation Merchant Bank.

5.Prepaid menu Report at MTN Nigeria.

6.Prepaid activation Report at MTN Nigeria.

7.Prepaid Data bundle Report at MTN Nigeria.

8.RGS Reports at MTN Nigeria.

9.USSD Report at MTN Nigeria.

10.Revenue per Base Station at MTN Nigeria.

11.Development of sim card registration end to end process that runs daily to show the number of subscribers that connected to the MTN network at a particular time after sim card registration. The process connects to three databases to achieve this daily. This is an automated process that runs daily.

12. Development of sim card registration process that shows the number of subscribers that synced into seamfix database at a particular time after sim card registration from the client side. The process is automated to run daily.

13.Development of sim card registration process that shows the number of subscribers that connected to the MTN network at a particular period after it has synced into seamfix database. The process connects to three databases to achieve this daily. This is an automated process that runs daily.

14.Development of All distinct activated subscribers on MTN Network. It captures all sim cards that have been activated and still on the Network till date. The process is automated and runs daily to provide daily report to the Management for decision making.

15.Development of sim card registration process that tracks all the activities done on sim card registration on the MTN network daily. This is an automated process that runs daily.

16.Using OBIEE to design a dashboard that shows simreg process time from the capture time till it gets to network.

17.Trade Partner Commission (TPC) Automation Project; it involves the automation of all commissions to be paid to each MTN Trade Partners weekly and monthly to avoid fraud during manual computation of the commission.

18.Implementation of Enterprise Data warehouse at NINE (9) MOBILE on SQL Server for K2 Workflow Objects.

19.Tavia Recruitment Chatbot using Bluemix Watson Conversation services (IBM).

20.Tavia Customer Chatbot using Bluemix Watson Conversation Services (IBM).

21.NINE (9) MOBILE Business Intelligence Development for all Workflows developed on both K2 and SharePoint.

22.MTN CAMEROUN Business Intelligence Development (SharePoint Business Intelligence).

23.NINE (9) MOBILE Business Intelligence Development for Products Implementation Processes

24.MTN Cameroon Business Intelligence Development (Powerbi Implementation).

25.WAPIC Business Intelligence Development (Powerbi Implementation).

26.MTN Nigeria Business Intelligence Development (SSRS Implementation on workflows).

COMPUTER WAREHOUSE GROUP, LEKKI, LAGOS 2015

Project Engineer (Business Intelligence Developer / Support Analyst).

Experience;

Extraction Transformation and Loading (ETL) of Data from different data sources into Enterprise Data Warehouse (EDW) for Analysis using PLSQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

Loading File into Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, spool the output of the analysis into a file and send it to the report user using PLSQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

Creating a job that runs at any time to create different data marts in the data warehouse and analyse each of the data mart, grant access to different users on each of them.

Creating a procedure that brings real time data into data warehouse.

Supporting Finacle Application (7 and 10) Environments at United Bank of Africa (UBA),

Customizing Finacle 10 Environment based on Business needs

Writing SQL and MRT scripts, and call them from finacle 10 scripts to generate reports

Using I report tool to run SQL scripts, MRT scripts, PLSQL Packages, procedures and functions

ASCENTIAL CONSULTING LIMITED, 9 OLU-IROLU SURULERE, LAGOS 2012

Business Intelligence Developer / Support Analyst

Experience;

Extraction Transformation and Loading (ETL) of Data from different data sources into Enterprise Data Warehouse (EDW) for Analysis using PLSQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

Loading File into Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, spool the output of the analysis into a file and send it to the report user using PLSQL Code and UNIX Scripting. The process is an automated process scheduled to run at a specific time depending on the Business rules.

Loading File into a Table in an Enterprise Data Warehouse, Analyse the data in the file loaded into a table, then create table for the analysis done and grant access on it to the user that will use the analysis. The process is an automated process scheduled to run at a specific time depending on the Business rules.

Using OBIEE (Oracle Business Intelligences Enterprise Edition) to create analysis, publish it on dashboard and then send the dashboard to the user as an email using agent.

Using OBIEE (Oracle Business Intelligences Enterprise Edition) to create analysis and publish it on dashboard for the user to do further analysis or view.

UNIX Operating System - Manage and View Files and Directories and Change the Directory Contents, Create and Modify files and Use file Permissions, Create ACLs and Control the User Work Environment, Use Commands within the Shell, Perform System Process and Job Control, Archive Files and Create Archive, Compress, View and Uncompress Files, Perform Remote File Transfers, Use Components of the Desktop System

Solaris 10 OS System Administration: Managing Solaris 10 Operation System Local Disk Devices and File System, Performing mount and un-mount of the File System, Managing Software Packages and Patches on Solaris 10 Operating System, Executing BOOT PROM Commands, Performing User Administration, Controlling System Processes, Performing System Security, Configuring and Using Printer Services, Plan and perform System backup and recovery, Backup of a mounted File System with a UFS Snapshot, Configuration of Solaris Volume Manager, Configuration of NFS and AUTOFS, Configuration of Role Based Access Control [RBAC], Configuration of System Messaging

Zone Management: Configuration, Installation, Booting, Administering Packages and upgrading Solaris 10 OS with installed Zone Solaris 10 OS

Network Administration Configuration and Management of: Network Interface Layer, Internet Protocol (Version 4 and 6) Addresses, IP Network Multipathing and Router

Nigeria National Youth Service Corps, NYSC. Mar 2011- Feb 2012

Ikpalegwa Community Secondary, Ikpalegwa, Cross River

Class Teacher

Teaching Mathematics

Debate and assembly coordinator

Independent National Electoral Commission, INEC. April 9th - 26th 2011

Presiding Officer

Instructor

Accreditation of the voters

Handling of the ballot papers to the voters

Sorting and Announcement of votes casted

Industrial Attachment, IT. June – Sept. 2009

Ganex Engineering Ventures, Ketu, Lagos

Fabricator

Manufacturing of machines

Making of bolts and nuts

Student Industrial Working Experience Scheme, SIWES. Aug 2008-Feb. 2009

Guarantee Trust Bank, Victoria Island, Lagos

Bulk Receiver

Cash Receiver

Sorting of Automated Teller Machine cash

Transfer of cheques to the headquarters

Vault management

Hobbies:

Reading, Meeting People and Music

References:

References are available on request.

Contact this candidate