Binbin Xiang

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