Detail-oriented Data Analyst with a proven track record in data modeling, visualization, and advanced Excel techniques. Skilled in creating customized reports and analyzing large datasets to drive informed decision-making.
Work History
Data Analyst
2 Years 5 Months
Enterprise Trustees - Abelway | 04.2021 - 09.2023
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best decision to make.
Created data models to support decision-making processes and produced monthly reports using advanced Excel spreadsheet functions
Analyzed large datasets using Excel, Power BI and Power Query to identify root causes of problems, variance and recommend corrective actions and report.
Developed customized reports, summarizing and presenting data in storytelling format using SQL server and Power BI.
Improved decision-making processes with accurate data analysis and visualization techniques.
Created and managed large scale databases to ensure timely reporting of critical information.
Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.
Accounting Assistant
2 Years 5 Months
Ledzokuku Municipal Assembly | 09.2018 - 02.2021
Entered and processed over 100 monthly invoices and payments, ensuring accuracy and timely submission.
Reconciled financial statements, identifying discrepancies and resolving issues efficiently to facilitate accurate financial reporting.
Maintained organized financial records, enhancing retrieval processes for audits.
Assisted in budget preparation, contributing to financial planning accuracy.
Monitored account balances and reported variances to management for strategic decision-making.
Improved financial decision-making by providing detailed expense reports and analysis.
Accounting Intern
1 Month
SIC Insurance Company LTD | 08.2015 - 09.2015
Assisted in preparing financial statements and reports, ensuring accuracy and compliance with regulations.
Supported month-end closing processes by reconciling accounts and resolving discrepancies.
Utilized accounting software to maintain accurate records of transactions and ledgers.
Collaborated with team members to streamline data entry processes, enhancing efficiency.
Education
Ontario Graduate Certificate - Data Analytics For Business
St Clair College | Windsor, ON | 07-2026
Bachelor of Science - Accounting And Finance
Central University | Accra, Ghana | 06-2017
Skills
Financial Reporting
Budgeting & Forecasting.
Variance Analysis
Financial Modeling.
KPI Reporting
Reconciliations.
Data analysis
data modeling.
SQL server
MySQL.
Excel (Advanced)
Power BI
Power Query.
Data visualization.
Python (pandas
numpy).
ETL & web scraping.
Microsoft Office Suite.
Certification
Google Data Analytics
Querying Microsoft SQL Server 2022
Timeline
Data Analyst
Enterprise Trustees - Abelway
04.2021 - 09.2023Read More
Accounting Assistant
Ledzokuku Municipal Assembly
09.2018 - 02.2021Read More
Accounting Intern
SIC Insurance Company LTD
08.2015 - 09.2015Read More
St Clair College
Ontario Graduate Certificate from Data Analytics For Business