- Business Intelligence Software: Build native AWS based BI tool that support labor planning process for Data Center Finance team, the tool provides interactive UI for Finance Analysts across the world to collaborate OP and easily consolidate data. Techniques involve Python pandas, numpy and boto3.- ETL Pipeline: Migrated the data source of a Finance report from Excel spreadsheet to AWS Redshift clusters, developed a fully automated ETL pipeline on AWS Lambda, Glue, CloudWatch.

- Design and build BI dashboards with Periscope Data as an individual customer facing product, serving clients include Gap Inc., Lbrands, Geodis.- Design and build ETL pipeline with Python on Azure VM.- Manage product analytics projects, design app-feature success metrics and use Amplitude to collect and analyze user behavioral data.

- Cleaned and organized data files with a combination of SQL and Excel.- Performed machine learning in Python and R: implemented AdaBoost Decision Tree and Random Forest to classify users based on their level of engagement with the audio-book product- Built book recommendation engine: used Market Basket Analysis to explore association rules between users and books, discovered frequent item sets with Apriori, visualized rules with arulesViz, mined clustered rules and books- Analyzed users' attitude towards app's new features by Topic Modeling on their comments: used NLTK to pre-process data, perform Latent Dirichlet Allocation with Scikit-Learn, presented topic clusters with word cloud- Collaborated with the product solution, marketing and customer services teams, translated the analysis results into business recommendations to assist with better implementation of services

- Mined large-scale New Jersey municipality fiscal datasets with SQL- Developed a set of reproducible ETL Pipline with R and Python - Built interactive business dashboards and data reports using R Shiny, flexdashboard, ggplot2 - Delivered product prototype presentation to leadership members from Community Informatics, Inc.