· Designed and implemented complex SQL queries, stored procedures that operates on China Mobile’s data warehouses.

· Integrated data from different databases including Hadoop/Hive, Teradata and Oracle following ETL procedures.

· Optimized data collection procedures using Performance Tuning and generated excel reports on a weekly and monthly bases.

· Created Relational Databases (Oracle and Mysql) for Business Intelligence Application.

Identified three major causes for China mobile marketing team regrading user claims.

· Revamped UI for property management website using HTML5 and CSS3.

· Built bill pay checking functionality based on Spring MVC to support automatic database update.

· Utilized Mybatis to provide better support for JDBC database operations.

· Established Baidu Analytics to monitor web traffic.

· Analyzed market, optimized portfolio, and monitored portfolio performance.

· Presented research to investment managers as part of a team.

· Co-Prepared Pitch Books for manager to meet with HNWI clients.