Financial assistant project: to provide investment team with stock transaction data via daily IM

• Applied data ETL to transfer stock market information from Oracle to MySQL using Pentaho Data Integration.

• Designed and built RESTful web service with Java to facilitate generating dynamic SQL statement for ETL.

• Used Bootstrap and Spring MVC to make dashboard app; applied symmetric encryption for database security.

• Deployed the app on the cloud; used Apache Oozie to schedule Hadoop job like sending daily message.

ERP updating project: to forecast the demand of products based on the historical transactions

• Cleaned the unstructured data with R by dealing with errors and inconsistencies for future analysis.

• Explored several models with different parameters to find out optimal predictive model using SAP HANA

library; triple exponential smoothing was applied to help the user achieving 80% of accuracy.

• Wrote code in Java and SQL to develop the prototype module; cooperated with the development team and UI team to deliver the final product to integrate in Business One.

Data mining project: to develop a classification model to improve the marketing precision

• Cleaned and explored data using Tableau; tested several classification models to build customized model and determined the factors that influence customer behavior in credit-card-installments.