Ajiboye Fakunle
Edmonton,AB
Summary
Ajiboye is an experienced professional who specializes in analyzing and interpreting data related to various technology systems and processes, with experience that cuts across data analysis tools, programming languages, and software applications to perform data analysis, data interpretation, and data movement, business Intelligence, data analysis, data modelling, data warehousing, ETL processes, data reporting, and dashboard creation, designing, coding, testing, and implementing code for data collection and utilization. His experience spans over 10 years in the industry. B
Overview
12
12
years of professional experience
Work History
Senior Analyst
Alberta Health Services
Edmonton, AB
02.2022 - Current
- Created SSIS package for integrating data from multiple sources
- Created Control and scheduling processes for the SSIS packages
- Captured need business and technical Metadata
- Built a Datamart for reporting for Supervised Consumption site
- Built a robust Data model for reporting event in Supervised Consumption site
- Created and monitored monthly reports using Power BI /DAX formulas and Power Query for transformation.
Data Analyst
People Tech ON
01.2022 - 03.2022
- Re-created an SQL script using CTE for populating Datamart
- Generated Pdf certificate with Python
- Optimized SQL scripts
- Created documentation for the pdf certificate generation process.
Senior Investigator, Data Analyst & Investigator
Shaw
Edmonton, AB
04.2021 - 11.2021
- Created ETL process using Alteryx for data transformation and loading
- Developed optimized SQL script for data loading to Snowflake
- Collaborated with stakeholders to identify opportunities to apply insights to various areas of the organization
- Created and automated monthly Power BI dashboard for monitoring Shaw TV catalog and Customer Margins
- Designed process documentation for the projects delivered.
Business Intelligence Developer
ARAP Technologies
Edmonton, AB
08.2020 - 03.2021
- Business requirement gathering from stakeholders
- Created documentation like source to targeting mapping, Enterprise Bus Matrix for the development of the Enterprise Data warehouse
- Created ETL process with SSIS for data extraction, loading, and transformation from the source system to staging and Enterprise Data warehouse environments
- Created a control framework to monitor the ETL process to ensure data quality using SQL and SSIS
- Automated the ETL process by scheduling the preferred runtime
- Created Date Dimension using T-SQL
- Created automated Power BI dashboard sent to stakeholders.
Senior Business Intelligence Analyst CVM) Analyst
Mobile Telecommunications Networks (MTN)
Lagos, Nigeria
06.2017 - 06.2020
- Developed business solution for identifying Business opportunities and Business risks from the requirement gathering phase to deployment of the data Marts and the visualization on Power BI
- Project: Development of a BI Solution for creating and monitoring inbound Channel campaigns for the 70 million subscribers
- Participated in Business requirements gathering and brainstorming workshop sessions with business stakeholders and internal stakeholders to understand the business operations
- Designed a campaign recommendation engine for over 60 million customers based on usage and revenue patterns for the previous four weeks using SQL
- Designed process documentation for the projects delivered.
Business Intelligence Analyst
Mobile Telecommunications Networks (MTN)
Lagos, Nigeria
07.2015 - 05.2017
- Designed periodic reports with the use of SQL, SAS, and Power BI
- Collaborated with another team member to deliver lottery projects for the business.
Application Support Engineer
Mobile Telecommunications Networks (MTN)
Lagos, Nigeria
07.2012 - 06.2015
- Supported an Enterprise Application- Virtual Top Up for delivering airtime to pre-paid mobile subscribers
- Generated periodic reports using MS SQL server
- Mined data from the application database to perform trend analysis and pattern recognition
- Pattern recognition in application log files.
Education
Master of Science - Computer science
Edinburgh Napier University – United Kingdom
01.2014
Bachelor of Science - Computer Science
Obafemi Awolowo University – Nigeria
01.2010
Skills
- Experience working with stakeholders in the business and IT to define requirements Requirement
- Experience in Analyzing data and capturing business and technical metadata
- Experience implementing solutions that align with business area goals, and data strategies
- Experience collecting and analyzing data from various sources such as databases, and other data repositories like Datawarehouse and DataMart
- Provide guidance and recommendation in decision making using data as a tool
- Experience building data modeling to identify patterns, trends, and insights
- Experience fostering data-driven decision across the organization
- Experience developing and implementing data processing and analysis procedures to improve data quality and accuracy
- Experience with visualizations tools like Power BI
- Experience in developing Power BI Reports and dashboards using DAX and Power Query
- Experience with creating ETL packages with SSIS
- Experience in building a Data warehouse environment
- Experience in designing and modeling databases and data systems
- Experience with TSQL and python
- Experience with Agile development methodologies
- Experience creating visuals, presenting findings to stakeholders and decision-makers
- Experience and knowledge of ETL and data pipeline tools such as SSIS
- Experience in data modeling, database design, and SQL
- Hands on experience in Data Technology, BI, or related field
- Experienced in troubleshooting and problem-solving to deliver
- Experience Mentoring data analysts
- Power BI/Tableau
- SQL – MSSQL/ORACLE/PRESTO/SNOWFLAKE
- SSIS/SSAS
- DAX
- EXCEL
- PYTHON
- SAS Enterprise Guide
- Performance Monitoring
- Business Intelligence
- Data Analysis
- Business Acumen
- Data Modeling
- Python Programming
Timeline
Senior Analyst
Alberta Health Services
02.2022 - Current
Data Analyst
People Tech ON
01.2022 - 03.2022
Senior Investigator, Data Analyst & Investigator
Shaw
04.2021 - 11.2021
Business Intelligence Developer
ARAP Technologies
08.2020 - 03.2021
Senior Business Intelligence Analyst CVM) Analyst
Mobile Telecommunications Networks (MTN)
06.2017 - 06.2020
Business Intelligence Analyst
Mobile Telecommunications Networks (MTN)
07.2015 - 05.2017
Application Support Engineer
Mobile Telecommunications Networks (MTN)
07.2012 - 06.2015
Master of Science - Computer science
Edinburgh Napier University – United Kingdom
Bachelor of Science - Computer Science
Obafemi Awolowo University – Nigeria
Similar Profiles
Shawna ButlerShawna Butler
Administrative Support Assistant III at Alberta Health Services - Alberta Public Health NGAdministrative Support Assistant III at Alberta Health Services - Alberta Public Health NG
Nerissa DauloNerissa Daulo
Environmental Services II at Alberta Health Services University of AlbertaEnvironmental Services II at Alberta Health Services University of Alberta
Brenda BaltimoreBrenda Baltimore
Temporary Clinical Supervisor at Alberta Health Services / Recovery AlbertaTemporary Clinical Supervisor at Alberta Health Services / Recovery Alberta
FREDERICK PahanonotFREDERICK Pahanonot
Environmental Services II at Alberta Health Services - University of Alberta HospitalEnvironmental Services II at Alberta Health Services - University of Alberta Hospital
Miranda DolphinMiranda Dolphin
Practicum Student Therapist at River's Edge Counselling CentrePracticum Student Therapist at River's Edge Counselling Centre