Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Software
Timeline
Generic

Adeleke Adedoyin

Moncton,NB

Summary

Dedicated and results-driven Data Analyst with over 5 years of experience in transforming raw data into actionable insights to drive business decision-making. Proven expertise in data analysis, statistical modeling, and data visualization, with a focus on delivering accurate and impactful reports. Adept at interpreting and analyzing complex datasets to extract meaningful patterns and trends. Demonstrated proficiency in utilizing SQL, Python, and advanced Excel skills to streamline data processes. Strong background in designing and implementing ETL processes for efficient data extraction, transformation, and loading.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Business Intelligence (BI) Developer

TecZila Inc.
06.2023 - Current
  • Analyze and interpret complex data sets, identifying trends, patterns, and insights.
  • Work with stakeholders to understand their data needs and requirements.
  • Design and develop databases or data warehouses for efficient storage and retrieval of information.
  • Write and optimize SQL queries for data extraction and manipulation.
  • Implement and maintain BI tools (e.g., Power BI) for creating dashboards, reports, and visualizations.
  • Develop and customize reports to meet business needs.
  • Develop ETL processes to extract data from various sources, transform it into a usable format, and load it into a data warehouse or BI platform.
  • Create data models to represent and organize information for optimal reporting and analysis.
  • Document data processes, data models, and BI solutions for reference and future maintenance.
  • Collaborate with cross-functional teams, including business analysts, data scientists, and IT professionals, to ensure alignment of BI solutions with business objectives.

BUSINESS DATA ANALYST

Armour Transportation Systems
08.2022 - 05.2023
  • Work with relational databases, including writing queries, validating data, combining data from multiple sources, and writing associated documentation
  • Updated and validated the data on the quotes produced
  • Designed dashboard and custom report using business intelligence visualization software (Microsoft Power BI)
  • Interacted with customers to help guide them and gather requirements
  • Built comprehensive business intelligence & reporting for various stakeholders, keeping in mind the needs of varied audiences and the desire to drive insights & action
  • Prepared monthly reports on operational metrics
  • Leveraged on data expertise to support initiatives through scoping, implementation, impact analysis, and ongoing reporting.

FINANCIAL DATA ANALYST

Bollore Transport & Logistics
09.2016 - 06.2022
  • Work with relational databases, including writing queries, validating data, combining data from multiple sources, and writing associated documentation
  • Communicate orally and in writing, including synthesizing complex quantitative and qualitative information into concise, well-organized narratives or graphical displays for both technical and non-technical audiences
  • Built data visualization dashboards that provide useful insights from complaints data/web data/Finance data/HR data using Power BI
  • Collaborated with Transport Team to understand reporting requirements and derive key metrics that will help in strategic decision-making processes
  • Sort and filter through raw data to create clear and accurate reporting on transport operations
  • Oversee enterprise Transport payment process through automation and templates
  • Built dashboards for tracking payments and expenditures such as purchase orders, invoices, and P&L
  • Create a dashboard and Templates for vendors' performance tracking and payment system.

TRANSPORTATION ACCOUNTANT

DHL Supply Chain
03.2012 - 08.2016
  • Managed monthly close process and reconciliation for dedicated companies (such as Total and SO Energy)
  • Annual budgeting, forecasting, and analysis to provide recommendations to leadership regarding operations effectiveness
  • Performed financial analysis, visualization, and reporting using Microsoft Excel and PowerPoint
  • Oversees duties and performance of accounting personnel including invoicing, accounts payable, and accounts receivables for the department
  • Prepared various types of reports on a monthly, quarterly, and annual basis including, but not limited to, financial statements, cash flow, and tax
  • Performed Journal entries in company accounting systems
  • Managed Inventory allowances and performs adjustment postings and inventory reporting
  • Supported inventory and insurance audits by providing information to auditors
  • Performed audits of customer invoices and month-end closing procedures to ensure adherence to corporate accounting policies and accurate customer billing
  • Monitored and reconciles functional-level balance sheet accounts
  • Controlling risk by constantly monitoring late payments by customers
  • Consolidation of Staff PAYE and Pension Remittance
  • Debt and Payment Collection Management
  • Skilled at working independently and collaboratively in a team environment
  • Proven ability to learn quickly and adapt to new situations
  • Self-motivated, with a strong sense of personal responsibility
  • Worked well in a team setting, providing support and guidance.

Education

Diploma in Software Engineering -

Canadian Business College

Bachelor of Science | Accounting -

Lagos State University, Nigeria
03.2010

Skills

  • Microsoft Office Suite (Word, Excel, PowerPoint)
  • Macros
  • Data Visualization
  • Analyze Data with Microsoft Power BI
  • Data Cleaning
  • Querying and analyzing big data using SQL
  • Create geospatial visualization with Excel
  • Presentation Skills

Accomplishments

  • Determined customer profitability and lifetime value for a manufacturing company using Power BI visualization tool.
  • Built data reporting and infrastructure from the scratch using Power BI to provide real-time insight into business KPI's for investment decisions thus improving organizational portfolio by 22 percent.
  • Created automated reports and dashboards for sales team that helps to monitor leads throughout the customer lifecycle journey, thus improving conversion rate by 40 percent.
  • Created Dashboards for visualizing transportation assets and liabilities thus reducing cost of damages by 28 percent.

Certification

  • Microsoft Certified Azure Database Administrator Associate, 04/2023
  • Microsoft Office Specialist Master Certification (MOS), 06/2022
  • Microsoft Certified: Azure Data Fundamentals, 03/2022
  • Microsoft Certified Data Analyst Associate, 10/2021

Languages

English
Full Professional

Software

SQL (Structured Query Language)

Microsoft Excel

Microsoft Power BI

Amazon Web Services (AWS)

Git/GitHub:

Javascript

React

Python

Timeline

Business Intelligence (BI) Developer

TecZila Inc.
06.2023 - Current

BUSINESS DATA ANALYST

Armour Transportation Systems
08.2022 - 05.2023

FINANCIAL DATA ANALYST

Bollore Transport & Logistics
09.2016 - 06.2022

TRANSPORTATION ACCOUNTANT

DHL Supply Chain
03.2012 - 08.2016

Diploma in Software Engineering -

Canadian Business College

Bachelor of Science | Accounting -

Lagos State University, Nigeria

Similar Profiles

CREATE PROFILE
Adeleke Adedoyin