➢ Implemented credit scoring models to evaluate the creditworthiness of loan applicants and predicted loan default possibility based on user demographics with decision tree and random forest, achieving an AUC of ~0.8

➢ Utilized SQL aggregate functions and advanced database querying techniques to extract, manipulate and analyze banking and financial data; visualized the patterns and trends from risk assessment in Excel

➢ Used Tableau Story to tell data narratives on key risk management metrics, such as portfolio diversification

Responsibilities include:

• Decision Trees
• Random Forest
• SQL
• Modelling

➢ Developed a web scraper with Python to extract JSON data; utilized Pandas, Numpy and Matplotlib to perform exploratory data analysis, summarize the data extraction results and clean the stock data for modeling

➢ Built pivot tables and wrote SQL common table expressions to aggregate and analyze stock data efficiently

➢ Perform in-sample and out-of-sample forecasting at different frequencies using linear regression as baseline; evaluated the performance of ARIMA, SVM, and Holt-Winter machine learning models w/ MSE & R-Squared

➢ Built a daily running ETL to integrate new stock data into the time series, clustering & classification models

➢ Coordinated with research and engineering to document machine learning knowledge and use guide

Responsibilities include:

• Python
• Modelling
• Machine Learning

➢ Responsible for data collection, cleaning, preprocessing, exploration and analysis for FMCG industry; used SWOT and Porters’ Five Forces to analyze industry & market conditions

➢ Designed A/B testing by defining a clear hypothesis, selecting a representative sample to randomly divide into control and treatment groups; measured the impact of pricing and promotion on sales and customer behavior

➢ Conducted funnel analysis to identify bottlenecks in customer journey and improve the overall conversion rate

➢ Designed a Tableau dashboard with single metric, bar charts, heat maps and scheduled delivery to stakeholders

➢ Diagnosed sales volume metric drop with SQL to analyze root cause and provide data-driven recommendation

Responsibilities include:

• Analysing
• Modelling
• SWOT analysis
• A/B Testing