Eddie Magaya

Eddie Magaya

$10/hr
Finance Financial Analyst , Data Analyst Power BI SQL , BI Development
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Kempton Park, Gauteng, South Africa
Experience:
10 years
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
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.