Data Analyst

• Aug 2019 - Present

Data Analyst Intern

• Apr 2019 - Aug 2019

❖ Extracted, collected, and organized financial data from different sources using complex database queries. ❖ Built various financial models by using Python to analyze the trend of stock prices and evaluate financial condition of target companies. ❖ Created dashboards and reports by using Tableau and Power BI to provide meaningful insights about data for managers. ❖ Assisted senior manager in creating a investment portfolios based on different risk and return levels. ❖ Extracted, collected, and organized financial data from different sources using complex database queries. ❖ Built various financial models by using Python to analyze the trend of stock prices and evaluate financial condition of target companies. ❖ Created dashboards and reports by using Tableau and Power BI to provide meaningful insights about data for managers. ❖ Assisted senior manager in creating a investment portfolios based on different risk and return levels.

Data Analyst Intern

• Jun 2018 - Aug 2018

❖ Extracted and analyzed complex data in depth to understand client behavior and share with leadership and stakeholders. ❖ Executed deep-dive analysis addressing key business issues and present findings to stakeholders. ❖ Performed Logistic Regression and Random Forest analysis in Python to identify target companies. ❖ Designed and developed interactive dashboards, data visualizations, and complex reports, based on business requirements, leveraging Tableau based on KPI definitions and dashboard designs. ❖ Conducted searching traffic analysis using Google Analytics to find the trend of specific markets. Show less

Global Finance Intern

• Jun 2016 - Aug 2016

❖ Performed deep dive analysis using SQL, Python and Excel on client activities, revenue, market risks, etc. ❖ Assisted in identifying patterns and relationships in data, pro-actively finding, investigating and providing solutions for problems as well as further increasing efficiency. ❖ Enabled effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format. ❖ Translated complex or ambiguous business problem statements into analysis requirements. Show less

Financial Analyst Intern

• Jun 2015 - Mar 2016

❖ Analyzed time series of stock price and predicted future value of different stocks by using SPSS. ❖ Used data mining, model building, and other analytical techniques to develop and maintain customer segmentation and predictive models to drive the business. ❖ Performed statistical analysis to measure risk level and returns and make recommendations to the business stakeholders on impacts to performance. ❖ Assisted senior manager in creating a investment portfolios based on different risk and return levels. ❖ Achieved a Return-On-Investment (ROI) of 103.2%. Show less