International Consultant - Quantitative Analyst
Geneva Area, Switzerland
• collected and processed forward-looking tariff commitments at the tariff item level in 38 bilateral, unilateral and regional trade agreements between 12 Trans-Pacific nations with SAS• collected and processed forward-looking tariff commitments at the tariff item level from the text of the Trans-Pacific Partnership Agreement (TPPA) with SAS• calculated aggregated tariff estimates in line with GTAP 9 methodology and constructed HAR files for GTAP economic modelers• conceptualized and designed online application to visualize TPP tariff reduction schedules (released at http://www.macmap.org/countryanalysis/countrystatistics/GlobalAnalysis.aspx?s=2)• supervised an intern to produce a paper for GTAP annual conference 2016 (https://www.gtap.agecon.purdue.edu/resources/res_display.asp?RecordID=5031)• developed excel template for trade remedies collection (with the use of VBA for automatization and verification purposes)• contributed to collection and processing of customs tariff and non-tariff data by means of: • building SAS datasets from external inputs (pdf, excel, access) • developing SAS macros and procedures for data cleansing, verification, and analysis • processing tariff data by checking its quality and reformatting according to the specified requirements• constructed normalized trade matrix for Market Access Map application based on UN Comtrade and Trade Map trade statistics• redesigned SAS programs, updated methodology, and performed calculations for World Tariff Profiles (joint publication of ITC, WTO, and UNCTAD)• contributed to ITC's Spotting Products With Export Potential publication by improving the methodological part (STATA) and generating fact sheets (QGIS <--Python, Excel <-- VBA) --> http://www.intracen.org/publication/Spotting-Products-with-Export-Potential/• delivered capacity building on ITC Market Analysis tools for various audiences (students, policymakers, and businesses)