Gcobani Xhego

Data Analyst with six years of experience working with financial and operational data across BDO UK, EY and Grant Thornton. My work has mainly involved getting data from client systems, checking that it is complete and reliable, analysing it with SQL, Alteryx and Python, and turning the results into reports and Power BI dashboards. I have worked with revenue, loans, payroll, insurance, retail, real estate and manufacturing data, and regularly work directly with clients to investigate data issues.

Data Analyst (Assistant Manager) - BDO LLP - Manchester, United Kingdom

(2024-02)

• Lead IPE testing and system walkthroughs, extracting data from ERP and database systems such as D365, SAP and Salesforce and checking completeness, accuracy and data lineage.
• Build Databricks notebooks or Alteryx workflows to reconcile and analyse client data across revenue, retail, real estate and manufacturing projects and investigate exceptions.
• For a recruitment services company, reconcile employee master data, placement information, timesheets, billing records and invoices to the underlying General Ledger (GL) and Trial Balance (TB), including transactions across different currencies.
• For a manufacturing company, reconcile sales orders, dispatches and invoices to the underlying GL/TB, checking that transactions flowed correctly between the different stages of the revenue process and investigating differences.
• Perform data profiling and revenue analytics on the datasets used in these engagements. For recruitment data, analyse timesheet submissions for backdated entries, timing differences between submission, invoicing and GL posting, minimum wage checks, transaction value distributions, averages and ranges.
• For manufacturing revenue data, analyse monthly distributions, top customers, duplicate transactions, transaction values and differences between sales orders, dispatches, invoices and GL/TB records.
• Produce data analytics reports and Power BI dashboards, investigate exceptions with client teams, and explain findings to non-technical stakeholders.
• Supervise junior team members on SQL, Alteryx logic and script development, including understanding and delivering project requirements.

Associate Data Analyst - Ernst & Young (EY) - Johannesburg, South Africa

(2023-03 - 2024-01)

• Participated in client system walkthroughs and prepared data requests for ERP systems including SAP, Dynamics and SAGE.
• Performed IPE testing by setting baseline control totals, collecting evidence and checking data for completeness and accuracy.
• Built Alteryx workflows and SQL routines in SQL Server Management Studio (SSMS) to analyse financial datasets.
• Worked across revenue, loans, payroll, insurance, reinsurance, retail and manufacturing data, performing calculations and reconciling underlying transactions and balances to source records, master files, bank statements and financial records such as General Ledger (GL) and Trial Balance (TB) balances. This included analysing premiums, claims made, claims paid and reinsurance transactions and investigating differences back to source.
• Created analytics reports and Power BI dashboards and worked with clients to resolve data issues.
• Coached junior team members on SQL, Alteryx logic and workflow development.

Data Analyst - SNG Grant Thornton - Johannesburg, South Africa

(2020-02 - 2023-02)

• Performed data extraction, reconciliation and analytics across financial datasets, using SQL, Alteryx and Excel to analyse and investigate client data.
• Worked on payroll, inventory, revenue and other financial analytics projects, profiling transactions, reconciling data between source systems and financial records, and investigating differences and exceptions.
• Performed forensic data analysis for financial crime investigations, tracing financial transactions and movements through underlying financial records to support investigative work and identify relevant transactions and relationships.
• Produced analysis and supporting reports, communicating findings and data issues to audit and client teams.

BCom - Accounting - University of Johannesburg (2016 - 2018)