Manager Data

ODOOH, CLEMENT OKWO

DBA Business Intelligence Professional Visualization Expert

Ketu, Lagos, NIGERIA

Cell: +234********** Email: *****.*******@*****.*** LinkedIn: www.linkedin.com/in/clementodooh

Professional Summary

A total of 6 years’ experience in information technology and oil and gas industries spanning through consultancy, application development, database administration, business intelligence, data analytics, data warehousing and wireline(slickline) services. Very detailed oriented with excellent analytical and project-tracking skills; a goal getter, result oriented, a good team player as well as an energetic self-starter. Proven ability to work in a fast-paced environment challenging environment.

Summary of Qualifications

• Oracle (Database 11g) Certified Professional [OCP]

• Oracle (Database 11g) Certified Associate [OCA]

• Oracle Database SQL Certified Expert

• Oracle Certified Business Intelligence Foundation Suites 11g Implementation Specialist

• Oracle Big Data Sales Specialist

• Oracle Big Data Pre-Sales Specialist

• Oracle Certified Business Intelligence Foundation Suite11g Implementation Pre-Sales Specialist

• Google Analytics for Beginner and Advance Users

• Advance Microsoft Excel Training

• Diploma in Computer Engineering

• OPITO Basic Offshore Safety & Induction Emergency Training (BOSIET) with EBS

• 5 years of software Development experience in Analysis, Design, Development, Data Modelling, Performance tuning and implementation of Business Applications using Database Management System (RDBMS) and BI tools

• 5 years of solid experience using Oracle PL/SQL, TSQL, SQL Developer and Toad for Oracle. Expertise in Oracle databases (9i, 10g, 11g, 12c, 18c), MSSQL Server and OBIEE

• 3 years of consistent experience in Azure, SQL Server, OWB (Oracle Warehouse Builder), OBIEE, ODI, Microsoft Power BI, Tableau & Advance Data modelling using Excel.

• 2 years of in-depth experience in ETL (Extract, Transform and Load) Analysis, using SSIS, ODI

• 1 year experience in Help Desk Support (Resolving log issues) and Basic Networking

• 1-year cognate experience in Oil and Gas Wireline Services (Slick-line operations).

• Facilitated and Mentored the Design, Implementation and Administration of Databases and Business Intelligence (BI) Projects

• Programming skills include: Oracle SQL, PL/SQL, Python

• Development tools include: PL/SQL Developer, Oracle Toad, DAX, Tableau, Power BI, SQL*Plus

• Python for data science, Machine Learning and data visualizations Professional Experience

Database Administrator Business Intelligence Professional 2015 – To -Date Digitized Analytics, Lagos, NIGERIA (Power BI, Tableau, PL/SQL, Oracle database11g, 12c, SQL Developer, Toad for Oracle, Spotlight, Excel, ODI, Mapbox)

Report directly to the Executive Director, Line Manager and Project Manager, responsible for all aspects of database and business intelligence systems, and:

• Engaged in data Extraction, Transportation and Loading (ETL) by using SSIS, ODI and Power BI query editor.

• Created various reports by leveraging SSRS, SSAS and SSIS integrated tools

• Designed BI visualization, reports and dashboards

• ensured a comprehensive database system and data management by successfully designing, implementing and Administering Oracle Database

• resolved logs issues and wrote advance SQL queries using SQL Server Management Studio, SQL Developer, Oracle Toad and SQL Plus where I wrote complex SQL scripts.

• eliminated redundancies, downtimes and data losses by ensuring normalisation, daily backup, tuning and high availability, performance monitoring and optimization.

• drove business Intelligence (BI) projects; carried out business requirements, information needs and implementation strategies for the project success.

• Increase the overall business performance by 37% within a year through the data-driven insight gained from my design of automated analytic reports for the organization decision-makers and its clients by using various BI (OBIEE, Power BI and Tableau) integrated tools.

• gave actionable insights, at the speed of thought, to the Decision Managers and enhance informed decision making processes in the organization, by taking advantages of Pivot tables, DAX, query editors, filtering and visualizations, Mapbox and filtering tools, which help me to carry out various data analytics (reporting, analysis, monitoring, forecasting, predictive and prescriptive analysis) processes of both spatial and non- spatial datasets.

• regularly engage in research and analysis of Physics, Mechanics and Thermodynamic as part of the requirement in designing and building space flights for the federal government of Nigeria. EDW Analyst BI Analyst 2014 - 2015

Intelfort Nigeria Limited, Lagos, Nigeria (Oracle PL/SQL, Database, OBIEE, Power BI, MSSQL Server, SQL Plus, Data warehousing)

Reported to Senior Project Manager, ensuring smooth executions of various database and analytics projects through information discovery process, development, implementation and deployment, and:

• met client’s data management needs by majorly involving in database design, implementation and administration.

• Assisted in increasing revenue by 23% in 2015 by assisting Project manager to drive Business Intelligence Projects and technical pre-sales; created dashboards, repositories and analysed various data sources for each project

• Participated fully in the data governance and ETL, ELT development for client’s OBIEE projects by using ODI and SQL Developer to complete the transformation, resulting in the required data structures and models

• Building visualisations, reports, dashboards and data models for clients by using Power BI and Tableau, SSIS, SSRS, SSAS and SQL

• Assisted in the implementation of Data Warehouse Appliance by creating Fact and Dimension tables, mapping and models which are fundamental to data warehousing needs

• Consulted and trained clients and students on Oracle 11g/ 12c, PL/SQL, SQL Server and Power BI

.

Education

Master of Science of Science in Information Technology 216 – 2017 National Open University of Nigeria

Bachelor of Technology in Physics Electronics 2007 - 2012 Federal University of Technology, Akure, Ondo State, Nigeria KINDLY FIND THE FOLLOWING LINKS USEFUL. THEY ARE MY MOST RECENT PROJECT ON DATA ANALYSIS AND VISUALIZATION:

1. FINACIAL ANALYSIS

https://app.powerbi.com/view?r=eyJrIjoiNDM4ZjliNDMtYmJjYS00ZGMzLWJiNGQtNDQ2NTA3NDZkZjA1IiwidCI6ImZj MWU3ZDliLTY1YjMtNDY0Ny04YTQxLTA4ZWExZGU3NjczNSJ9

2. COVID-19 REAL-TIME TRACKING AND ANALYSIS AROUND THE WORLD https://app.powerbi.com/view?r=eyJrIjoiOGUwZjgyNmMtYjg5Yi00OWZhLTk4YmMtODU2ZjM2MzM2OWRhIiwidCI6I mZjMWU3ZDliLTY1YjMtNDY0Ny04YTQxLTA4ZWExZGU3NjczNSJ9 3. MACHINE LEARNING APP THAT PREDICT INSURANCE HEALTH CHARGES; https://digitized-insurance1.herokuapp.com/

4. INTEGRATION OF PYTHON AND POWER BI IN VISUALIZATION https://app.powerbi.com/view?r=eyJrIjoiYjMxY2U3MGQtMWNlOC00ZWFmLThhMDktNGExMjViZjBmY2JmIiwidCI6Im ZjMWU3ZDliLTY1YjMtNDY0Ny04YTQxLTA4ZWExZGU3NjczNSJ9

Contact this candidate