Summary
Overview
Work history
Education
Skills
LANGUAGE
REFERENCES
AWARDS
Timeline
Generic

John Dukhi

Gauteng,South Africa

Summary

Dedicated professional with over 9 years of experience in trade data analysis, specializing in economic and data analysis reporting. Proficient in troubleshooting and developing effective solutions using SQL, Microsoft 365 Office, and various data software tools. Strong report writing skills complemented by excellent verbal and written communication abilities. Proven track record of cultivating positive relationships and consistently exceeding performance goals.

Overview

11
11
years of professional experience

Work history

Operational Specialist Research Trade Ana & Report

South African Revenue Service
Gauteng, South Africa
2023.12 - Current
  • Authored comprehensive bilateral reports with African countries and international countries facilitate informed decision-making to the executive, commissioner's office and international office.
  • Responsible for research and projects involving micro economic socio issues relating and affecting trade and revenue, and macro issues affecting SA on revenue collection and trade.
  • Oversee research economic insights and economic performance with impact to trade including SACU (BELN Countries), SADC other trade relation forums, and make analysis of revenue tax, customs value with trade statistics to look at exports and imports flow trade trend.
  • Oversee new recruits (Graduates), on the daily work done and educate/facilitate them on the work done in the department.
  • Supervised the quality of work of other colleagues and planned and facilitated the delivery of the division-specific outputs as well as optimise and manage trade division resources.
  • Work on publication of Trade Statistics & Revenue Research Articles including data analysis and report writing. Involved in projects of ISIC codes, automation of reports and work process and other ad hoc work required.
  • Worked on regional customs report and analysis, on the flow of goods from air, border and sea modality on the flow of exports and imports from the countries traded with.
  • Provided tariff data in excel format to public South African business and stakeholders on a daily basis.
  • Report on annual and quarterly trade flows and revenue drivers for SARS. and build informed reports for executives and senior managers in the organisation.
  • Used data tools, such as SQL and excel to extract and sort data for any queries rising from management and the organization to answer questions relating to trade.
  • Other functions are ad hoc and including roles that done as a functional specialist and more.
  • Transform and improve on reports and analysis that involves economists and publication documents in trade statistsics.

Functional Specialist Research Trade Analysis Rep

South African Revenue Services
Brooklyn, South Africa
2019.04 - 2023.11
  • Worked on trade data extraction, cleaning and dissemination aligning with UN IMTS manual and guidelines.
  • Provided tariff data in excel format to public South African business and stakeholders on a daily basis.
  • Research economic insights and economic performance with impact to trade including SACU (BELN Countries) & SADC, and make analysis of revenue tax, customs value with trade statistics to look at exports and imports flow trade trend.
  • Collected data from inter-front server, then refresh with SQL/SAS data software, imported to excel to verify the data and clean the data to prepare for use and dissemination.
  • Planned and initiated workflow process improvement on functional reports, including improving data graphs and tables for better trade data representation to better service the public and deliver on operational strategy and objectives.
  • Compiled, analysed and provided reports on the Trade data administration function as well as provide recommendations for process improvement to mitigate data proficiency.
  • Aided in Implementation of moving from using datozean tool to using powerBi tool for compiling reports with Progress of 100% use of powerBI.
  • Supervised the quality of work of other colleagues and planned and facilitated the delivery of the division-specific outputs as well as optimise and manage trade division resources.
  • Work on publication of Trade Statistics & Revenue Research Articles including data analysis and report writing. Involved in projects of ISIC codes, automation of reports and work process and other ad hoc work required.

Graduate Trainee (Trade Statistics)(SIOL) Ops Ochestration Enabling-National Revenue and Management

South African Revenue Services
Brooklyn
2017.04 - 2019.03
  • General training provided by SARS Institute of Learning (SIOL) on Tax Research and policy research.
  • Responding to Trade statistics mailbox queries, Provide Trade Data to the public and stakeholders in Excel format, contact traders to confirm trade statistics, use SQL to run and extract data on exports and imports, Research Writing. Process ad hoc requests. Analysis of month-on-month section variances, conduct trend analysis (section, commodity and trader), preparation of publication pack, save website reports in Word and PowerPoint format. In addition, media release on the website link. Monitor trade statistics mailbox daily.
  • Trained in courses of ( PAYE, VAT, CUSTOMS DUTIES & EXCISE TAX, CIT AND TAX administration.
  • Training on Presentation Skills and Report Writing.
  • Involved in office ad hoc work and training, including Introduction to how work reports are done, and process of work flow in the division.
  • Training in software such as SQL, SAS, & Microsoft office.
  • Working with Publication team and assist in reports and data dissemination and publication.

Supplemental instruction facilitator

University of the North West
Mahikeng
2015.01 - 2016.12
  • Promoted learning with revised course content and structure. Created and updated learning materials with curriculum changes.
  • Acquired new skills via training and development sessions.
  • Facilitated learning in the faculty of commerce for first and second year students in modules: statistics, computers and programming, economics and business management.
  • Conducted extra sessions and classes for students prior to tests and exams for better understanding and assisting the lecturers in ad hoc request work by marking tests and assignments.

Education

BCOM - Economics (with distinction), Commerce

North-West University Mafikeng Campus
Mahikeng, South Africa

HONSBCOM - Economics (with distinction), Commerce

North-West University Mafikeng Campus
Mahikeng, South Africa

Skills

  • Microsoft Technical Certification (Microsoft Office, SQL, html 5, Database development, Software dev
  • Data Extract and Analysis (Excel & SQL), Report Writing (Word & PowerPoint), Economic Analysis(Data)
  • Customs & Excise, Tariff Book Knowledge, UN IMTS Knowledge & Traning
  • Advance Excel , SAS intermediate and PowerBI intermediate, Eviews intermediate
  • Functional Policies and Procedures, Business Writing, Report writing, Presentation skills

LANGUAGE

Setswana Proficient (C2)
English Proficient (C2)
Sesotho Upper Intermediate (B2)
Afrikaans Intermediate (B1)
Sepedi Upper Intermediate (B2)

REFERENCES

  • JT, Tsoku, Lecturer : NWU Mafikeng Department of statistics, 0183892805
  • Tshepo, Makgoro, SARS Specialist: International
  • OOE-NRC:TAR-Trade & Indus, 0124228479, 0715311602
  • Violet, Dukhi, Medical Doctor at Mahikeng Provincial Hospital, 0791755809

AWARDS

Merit award for top best overall academic performance in commerce stream 2012, Academic award for best performance and runner up in subject's math, English, accounting, economics and business studies, best performer and participation in cricket sport 2012.People to people Ambassador programs award., SARS (Trade Statistics Team best performance and recognition award), SARS long-Term service 5 years (2017-2022)

Timeline

Operational Specialist Research Trade Ana & Report

South African Revenue Service
2023.12 - Current

Functional Specialist Research Trade Analysis Rep

South African Revenue Services
2019.04 - 2023.11

Graduate Trainee (Trade Statistics)(SIOL) Ops Ochestration Enabling-National Revenue and Management

South African Revenue Services
2017.04 - 2019.03

Supplemental instruction facilitator

University of the North West
2015.01 - 2016.12

HONSBCOM - Economics (with distinction), Commerce

North-West University Mafikeng Campus

BCOM - Economics (with distinction), Commerce

North-West University Mafikeng Campus
John Dukhi