Binbin Xiang

Binbin Xiang

Software Developer

Followers of Binbin Xiang76 followers
location of Binbin XiangShanghai, China

Connect with Binbin Xiang to Send Message

Connect

Connect with Binbin Xiang to Send Message

Connect
  • Timeline

  • About me

    Data Analyst at UBS Investment Bank

  • Education

    • Renmin University of China

      -
      Master's degree Computer Engineering
    • Southwest Petroleum University

      -
      Bachelor's degree Computer Science and Technology
  • Experience

    • Richfit International

      Mar 2013 - Mar 2015
      Software Developer

      Software development<Web .NET>, involved in the development of software products, including the early stage of the oracle database design and development of front-end display page. The daily maintenance of the oracle database,Data sorting, entry, data model, provide data services for each project, system functional extension development, user routine answering questions and training.1. Using the framework of LigerUI, MVC4.0, Ioc controller, highchat report components;2. Responsible for the business carding, Oracle database design and development;3. The development of data acquisition interface;4. Rights management, the development of data entry functions from different roles;5. The design and coding of BLL layer report display module; Show less

    • ANZ

      Mar 2015 - Jun 2016
      Data Engineer

      Provide data analysis and support services for more than 800 ANZ Branch in Australia. Develop and maintain ETL process (Data extraction, transform and loading from GIW global data warehouse), develop marketing sales reports and relevant dashboard.1. ETL(SSIS Package) develop and maintain (Source: csv, txt,Oracle, DB2; DM:Sql server);2. BI Tool (QlikView Dashboard & SSRS report) and stored procedure develop;3. ETL job Monitor (Control-M) Fail and Fix;4. System support and Data Report analysis;5. Deal with customer query and request; Show less

    • RT MART International Limited

      Jun 2016 - Aug 2017
      Data Warehouse Developer

      The design of Data Warehouse based on HP Vertica, the construction of the off-line data calculation and on-line real-time OLAP query model; Real-time or off-line processing a large number of offline data to construct a reasonable and scalable data warehouse model, the support of statistical analysis and report.1. Development of ODS layer, real-time ETL jobs (Kettle & Zeus);2. The data extract model design from Hadoop(Hive) to Vertica (Kettle,Sqoop & Hue);3. Order reconstruction model design and development(DW and DM layer);4. The development of data validation function (Source: MySQL, Oracle, Mongo);5. The development and maintain of DW's Early warning mechanism, including SMS, e-mail; Show less

    • UBS

      Aug 2017 - now
      • Process Lead & Data Analyst, UBS Evidence Lab

        Jan 2019 - now
      • Data Analyst, UBS Evidence Lab

        Aug 2017 - now
  • Licenses & Certifications

    • College English Test-6 (CET-6)

      The National Ministry of Education
      Dec 2011
    • The National College Mathematical Modeling Competition (CUMCM)

      Chinese society of industrial and applied mathematics (CSIAM)
      Dec 2011
  • Volunteer Experience

    • Volunteer

      Issued by ANZ on Jul 2015
      ANZAssociated with Binbin Xiang