g
Personal details
NameEdmond Magaya
GenderMale
Contact number064 --
Microsoft Certification.
MCSA – BI Reporting
Tertiary
3 Year (NQF-7) Financial Accounting Diploma from Institute of Accounting & Commerce(IAC) - Completed in 2009
3 Year (NQF-7) Cost and Management Accounting Diploma from Institute of Accounting & Commerce (IAC) – Completed in 2009
CIMA -Chartered Institute of Management Accounting – Management Level
Educational qualifications:
O Level / Matric Equivalent
Microsoft Certification.
MCSA – BI Reporting
Work experience
Ascendis Health – Data Analyst ( 3 Months contract)
Period 01 Feb to 30 April 2021
BME - division of Omnia Group
Position. Finance Data Analyst
Period March 2018 to March 2020
GLASS SOUTH AFRICA / PG DIVISION
POSITIONCost and Management Accountant
Period. August 2011 – December 2017
SectorManufacturing & Distribution
KIMBERLY CLARK
POSITION HELDCost Accountant
Period. May 2007 – July 2011
SectorManufacturing & Distribution
GSWFeb 2005 to April 2007
POSITION HELDAccountant
SectorEngineering
Ascendis Health – Supply Chain
Performing technical data manipulation and analysis in support of projects, including discovering, structuring, cleaning, enriching, validating, extracting, transferring and loading data; with the end goal of detailed business intelligence reporting
Execute data analysis and interpret data based on business requirements
Perform data quality tests on data sources
Visualize data insights and communicate findings to various teams across the organization
Identify and define the data requirements necessary to support different business requirements / reports
Identify and perform detailed analysis of all data sources for each application and subject area.
Perform data profiling of data contained in source systems.
BME(Bulk Explosives Management) – Division of Omnia Group
Provide input to the BI team with regards to the approach of solving relevant business problems.
Data gathering.
Data cleaning.
Data preparation.
Data analysis. Data interpretation - relevance and analysis (being able to forecast and identify the outcomes)
Report and provide feedback on data analysed
Design and produce reports to internal and external stakeholders on a weekly/monthly/quarterly basis
Assess and identify the client’s needs
Prepare reports on additional information to include the analysis and interpretation of the data
Business Improvement – operation and processes. Increase efficiencies. Taking data received and increasing utilisation. Better utilisation for increased profit
Complete different data analysis projects in order to support various company activities and plans
Identify and define information need requirements for BI projects
PG Glass/Glass South Africa
Compile the final fixed asset tax schedule for year end
Reconcile statutory payments
Management accounts and exco park
Analyse management reports
Inventory management (Ensuring inventory is recorded and valued correctly)
Ensuring the availability and payment of creditors both local and foreign creditors are paid.
Monitor and control manufacturing costs
Variance analysis on Factory performance
Reporting
Standard costing /Product costing
Ensuring the accuracy of Bill of material/BOM
Budgeting and forecasting
Performance analysis - break even analysis , gross profit/margin (ratios and %)
Kimberly Clark (Pty)Ltd
Performance reporting and analytics: Measure, analyse and report business performance for the division, providing key inputs for the monthly reporting pack;
Review performance with management;
Develop action plans, re-allocate resources, & update forecast;
Maintain common performance
Provide on-going/ad-hoc reporting & analytical support.
Planning, Budgeting and Forecasting
Reconciliation of GL Accounts
Fixed assets register – running monthly depreciation. Accounting for newly acquired and disposed assets
GSW – Engineering
Monthly management accounts
Cashbook
Trial balance
VAT
Balance sheet
Skills possessed
Analysing and visualizing data with MS Power BI
Analysing and visualizing data with MS Power BI
Various Business Report writing using BI Tools
SQL
DAX
Administrative
Analytical
Business acumen
Cost & Management
Financial Accounting