Menu

Jing HUANG

Saint-Priest France

En résumé

Mes compétences :
SAS Statistical Package
MS Excel VBA
SQL
Qualitative and quantitative analysis
Dependence analysis
SAS Enterprise
SAP
Microsoft Word
Microsoft PowerPoint
Microsoft Outlook
Microsoft Office
Microsoft Excel
Microsoft Access
Matlab
MS Access VBA
Data Processing
C++
Business Objects
R

Entreprises

  • Renault Trucks - Data analyst

    Saint-Priest France 2012 - 2015 * Establish the common database of the Technical Material Analysis team and the Supplier Warranty Recovery team, and re-establish the data warehouse of the Appraisal Center team ;
    * Extract data by using different tools such as QRAFT Portal (SAS suite) / Microsoft SAS Add-In / WASP (SAP suite) / Harry / etc. ;
    * Calculate monthly / quarterly variations of top warranty costs ;
    * Analyze top warranty costs by various terms and factors, especially by using the rolling average method ;
    * Provide analysis results to team leaders and propose actions to reduce the warranty costs ;
    * Report monthly /quarterly / Year-to-Date information of the Warranty Department (Volvo Group Trucks Technology - France) ;
    * Provide necessary data to the Warranty team, help them to create their portfolio follow ;
    * Create auto-run applications (via Excel VBA) in order to facilitate data processing ;
    * Cooperate with the analysts from other sites of the Volvo Group Trucks Technology ;
    ¤ GTT Data analysts F2F meeting : seminary in Hagerstown, USA ;
    ¤ GTT Data analysts online Network meetings : monthly
  • Groupe Banque Populaire - Back-office assistant & Practical Trainee

    Paris 2012 - 2012 * Extract the company's own data from the whole BPCE Group's data bank (big data) by using SQL queries ;
    * Build the meta-data warehouse (via Access) for the Animation of Trade Flows Department ;
    * Score the corporate customers by analyzing their trade flows (via SAS) ;
    * Assess the corporate customers' potential by analyzing a combination of various scorings ;
    * Establish dashboards (via Access VBA and Excel VBA) for assisting the bank controlling some top grand corporate customers and their groups
  • Xin Suidong Accounting Firm - Assistant accountant & Practical Trainee

    2011 - 2011 * Enter various accounting documents ;
    * Participate in the preparation of periodical reports for the local government ;
    * Calculate and report local or national taxes for small companies ;
    * Help to audit accounts of small companies
  • IRSTEA - Assistant researcher & Practical Trainee

    Antony Cedex 2010 - 2010 * Extract UNESCO statistics of books' selling (main categories) from different countries from the beginning of the 20th century to nowadays ;
    * Realize quantitative and qualitative statistical tests to find out if it exists a relationship among countries, especially between the countries within a same continent (dependence analysis) ;
    * Define the result found out of the research ;
    * Help to establish a statistical model in order to explain international cultural diversities

Formations

Réseau

Annuaire des membres :