Experience

• 

  Cathay life insurance

  Sept 2008 - Apr 2013

  I maintained the ETL flow of the data warehouse in the first year，Besides, integrated various source date, filter and transform them into target table to produce OLAP reports according to the users demand. The greatest achievement was to optimize the data flow 、 SQL Codes and reduce the daily data transformation time for 1.5 hour. Last year, I was a PM in a project to evaluate, plan and migrate old OLAP system (Hyperion 8.5) to new IBM Cognos Business Intelligence Platform. 147 reports was transformed and 4 new dash boards was created to illustrate main KPIs to the General Manager on iPad. 收回

  • Business Intelligence Specialist

    Mar 2011 - Apr 2013

  • Server Administrator

    Sept 2008 - Mar 2011
• 

  Kingwaytek technology

  Oct 2013 - now

  System engineer

  IT Infrastructure Planning, Establishment, Maintenance and Management.