Ajiboye Fakunle

Data Integration and Ingestion ETL with SSIS Data Analysis with Power-BI , R , SQL Data modelling

Data Analysis Python Scripting with SQL

Dashboard creation with Power BI and Power BI Service ETL /ELT with Alteryx Complex SQL on Snowflake

• Performed requirement Gathering from business owners to fully understand the business need and define project scope based on the available data • Developed conceptual, logical and physical models for the data warehouse/data mart implementation • Analyzed and designed Data Warehouse using Ralph Kimball Star Schema Dimensional Modelling Approach • Created various documentation used in the require gathering phase to the deployment of the DataMart Documents like bubble chart , Bus matrix, Stakeholder matrix, bubble charts , Entity Relations(ER) diagrams • Created source to target mapping document for Extraction Transformation and Loading (ETL) process using Microsoft SQL/T-SQL to create the required Dimension and Fact Tables • Design and Implement Ralph Kimball Methodologies slowly changing dimension (SCD) Type 1 and 2 using SSIS data flow transformation • Created and deployed Multi-dimensional Cubes Tabular models

Project: Development of a BI Solution-Business Opportunity Business Risk (BOBR) Responsibilities •Participated in requirements gathering and brainstorming workshop sessions with business stakeholders •Reviewed the already existing OLTP and the OLAP architecture •Analyzed and designed Data Warehouse using Ralph Kimball Star Schema Dimensional Modelling Approach • Determined the source system and source table required for this solution •Created the bubble chart , logical and physical design model base on dimensional modelling • Designed entity-relationship diagram, data flow diagram, process flow diagram •Created the bus matrix for this business process identifying the degenerate dimension and with provision for the new dimensions to be included

Project: Development of a BI Solution-To analyses Data Users based on flux Responsibilities • Participated in requirements gathering and brainstorming workshop sessions with business stakeholders •Reviewed the already existing OLTP and the OLAP architecture • Determined the source system and source table required to capture all the total data usage of customers •Created the bubble chart , logical and physical design model base on dimensional modelling •Created the bus matrix for this business process identifying the degenerate dimension and with provision for the new dimensions to be included •Created source to target mapping documents for data migration from OLTP environment to OLAP environment •Wrote SSIS packages, SQL scripts to perform Extract, Transform and Load (ETL) data from Excels, OLTP systems into staging database, from staging database into EDW and unto the data mart based on the design approach using SQL Server 2012 Database and Data tools •Designed, developed and deployed Reports and Dashboards, Cube and Measures using SSRS, SSAS, Power BI which showcased the business risk and opportunities on a weekly and monthly basis across multiple revenue streams Other Responsibilities •Developed and automated periodic and ad hoc report for tracking and understanding the business KPIs like Designed, developed and deployed Reports and Dashboards, Cube and Measures using SSRS, SSAS, Power BI which showcased the business risk and opportunities on a weekly and monthly basis across multiple revenue streams subscriber count using Power BI •Developed report specification documents, which captures all necessary business requirement for the technical team. •Effective maintenance of weekly analytical dashboards for all work streams in line with company’s strategy and transformation office objective as well as driving the discipline of performance monitoring and effective execution.

Responsibilities • Extracted data for generating daily, weekly and monthly VTU performance report showing the recharge amount bought by subscribers •Extracted data using SSMS /SQL to investigate transaction errors and complaints •Supported MTN’s Virtual Top up Application (with an average of two Billion Naira turn over per month) by ensuring it was up and running 24hours everyday

Dissertation (MSc): Investigated and analyzed the use of a Security Information and Event Management tool (SPLUNK; a data analytics tool that can aggregate log files from many platforms) and an Intrusion Detection System (SNORT; an IDS) tool in detecting SQL Injection staged in a virtual environment (VSphere) The thesis successfully used the named tools in investigating Tautology SQL injection threat suspected on a vulnerable webpage.

Final year Project Developed a Wireless Security Scheme using MAC Address filtering and a brainchild Algorithm implemented using a Server/Client network model