Historique

The State Statistics Committee of Turkmenistan (Turkmenstat) is a key government agency responsible for compilation and reporting on international merchandise trade statistics in Turkmenistan. In Turkmenstat’s structure, foreign trade statistics is a part of the Trade Unit of the Trade, Transport and Communication Department. The foreign trade statistical information is prepared at the centralized level based on the customs data.

Foreign trade statistics of Turkmenistan is poorly presented at international level. Data on trade in goods is mainly available in the form of mirror statistics reported by other countries. No data is available on trade of services.

The current data management system which uses Eurotrace DOS (installed in 1998) does not enable the effective and efficient processing of the data transmitted by the State Customs Committee. This is because the existing Eurotrace DOS system is out of data and does not meet the current needs of Turkmenstat to effectively compile and disseminate IMTS for Turkmenistan.

The failure to regularly disseminate good quality, timely and detailed data on IMTS is caused by the lack of a more robust and modern software to compile and process Customs data. Therefore, there is an urgent need to upgrade the existing Eurotrace DOS version to the latest available Eurotrace Windows version. It will also be important that the historic data going back to at least 10 years is uploaded into the new Eurotrace Windows system. At present, Eurotrace Windows is not available in the Russian or Turkmen languages, so it is essential that the software, documentation and training material is translated before implementing the system in Turkmenstat. Discussion will need to be held with Eurostat as to how the COMEXT software can be translated. Translation of Eurotrace DBMS and Editor seem less problematic as these two modules are freeware.

In 2017, UNDP and Turkmenstat signed a joint project “Support to Improvement of the Foreign Trade Statistics in Turkmenistan” that, among other activities, envisages upgrading the existing Eurotrace DOS version to the latest available Eurotrace Windows version.

Devoirs et responsabilités

Under supervision of the Project Manager, the International Consultant (IC) will have the objective of preparing the Eurotrace software in Russian language. For this, UNDP CO will provide translated Eurotrace terms. To achieve the objective, the International Consultant will carry out the following tasks:

  • Modify the structure table in access and integrate Russian as an additional working language;
  • Based on the translated terminology that will be provided by UNDP, fill in the records with the Russian terms in all the database tables (more or less 10 tables);
  • Test the IT operability of the Eurotrace software;
  • Carry out a linguistic check to ensure full coherence between the English/French versions of Eurotrace and the Russian version;
  • Check the installation set up of the software.

Deliverables and timeframe:

Deliverable prepared through tasks above: 

  • Eurotrace software available in Russian.

Location: Home-based. Number of days: 10 days.

Payment conditions:

This is an installment-based contract that should cover the costs of consultancy required to produce the above deliverables. The final schedule of payments will be agreed upon in the beginning of consultancy.

Compétences

Corporate Competencies:

  • Demonstrates integrity by modeling the UN’s values and ethical standards;
  • Promotes the vision, mission, and strategic goals of UNDP;
  • Displays cultural, gender, religion, race, nationality and age sensitivity and adaptability;
  • Treats all people fairly without favoritism;
  • Fulfills all obligations to gender sensitivity and zero tolerance for sexual harassment.

Qualifications et expériences requises

Education:

  • Bachelor or master's degree in IT field or similar by experience.

Experience:

  • Software application developer with at least 3 years' working experience;
  • At least three years' experience in developing applications on MS-Access, MS SQL Server or other SQL database systems;
  • Command of the IT structural organization of the Eurotrace application.

Language requirements:

  • Knowledge of English language.

Submission of applications:

Interested individual consultants must submit the following documents/information to demonstrate their qualifications:

All experts applying for this position are required to provide:

  • Financial Proposal with the references to (1) the daily rate for the assignment and within the timing scale indicated in the present TOR, and (2) any other expenses (including transportation costs, accommodation costs, the possibility of vaccination and etc.). Template of the form can be found at: http://www.tm.undp.org/content/turkmenistan/en/home/operations/jobs. The UNDP will enter into an Individual Contract based on a lump sum amounts. The financial proposal shall represent a detailed, justified and “all inclusive” amount.  In order to assist UNDP in the comparison of financial proposals, the financial proposal shall include a breakdown of this lump sum amount, including: a daily fee for the tasks and an estimated duration as specified in this announcement, travel (to and from the missions), per diems, any other possible costs (including vaccinations, dwelling, communication etc.);
  • Filled P11 form including past experience in similar projects and contact details of referees (blank form can be downloaded from http://europeandcis.undp.org/files/hrforms/P11_modified_for_SCs_and_ICs.doc.

Evaluation of proposals:

Individual Consultants will be evaluated based on the combined scoring methodology. When using this method, the award of the contract should be made to the individual consultant whose offer has been evaluated and determined as:

  • Responsive/compliant and
  • Having received the highest score – out of 100 points

Out of the maximum score, the score for technical criteria equals 70% - maximum 70 points, and for financial criteria 30% - maximum 30 points.

The technical evaluation will take into account the following as per the scoring provided:

  • IT Education – 20 pts;
  • Working experience in development software applications – 30 pts;
  • Experience in developing applications on MS-Access, MS SQL Server or other SQL database systems – 20 pts;
  • Command of the IT structural organization of the Eurotrace application – 20 pts;
  • Knowledge of English – 10 pts.

Financial proposal – 30% of total evaluation - max 30 pts.

Additional requirements for recommended contractor:

Recommended contractors aged 62 and older, and if the travel is required, shall undergo a full medical examination including x-ray, and obtain medical clearance from the UN-approved doctor prior to taking up their assignment. The medical examination is to be cleared by the UN physicians, and shall be paid by the consultant.