Data Analyst Financial

RACHEL (RUIJIA) YANG

Fairfax, VA 571-***-**** ********@*****.*** https://www.linkedin.com/in/ruijia-yang9/ SUMMARY

A versatile, dedicated, and analytical individual with growing expertise in ETL for unstructured and structured data. Demonstrated expertise in developing and implementing innovative data-driven solutions and creating optimization algorithms and predictive analytical models using relevant techniques and tools. CORE COMPETENCIES & SKILLS

Programming: Python, R, Java(Basic)

Database: MySQL, Oracle SQL*Plus, Postgres, MongoDB Business Intelligence & Visualization Tool: Tableau, PowerBI, IBM Cognos Analytics, MicroStrategy, Qlik Others: Amazon Web Services (AWS), Azure Cloud, Hadoop, Spark, Advanced Excel, Predictive Modeling, NLP/ Text Analytics, Computer Vision, Financial Engineering

EDUCATION

Master of Science in Data Analytics Engineering August 2019 – December 2020 George Mason University, Fairfax, VA

Bachelor of Science in Finance August 2015 – May 2019 George Mason University, Fairfax, VA

PROFESSIONAL EXPERIENCES

American Financial Services Association, Washington, D.C. February 2021 – Present Financial Data Analyst Internship

• Manage existing databases and handle concurrent data collection to analyze AFSA’s premier business partnership and membership distribution

• Interpretate financial transaction data, provide analytical support through Excel and PowerBI to the operation strategy and financial management team

• Identify and define key performance indicators, create, and maintain dashboard to assist management in exploring future potential opportunities

• Develop new Employee Timesheet System and set up the database schemas with complex entity relationships by using PHP script and MySQL to enhance the efficiency of employee record tracking Industrial and Commercial Bank of China., Lanzhou, China June 2019 – August 2019 Financial Data Analyst Internship

• Boosted productivity and operational efficiency of asset management team to realize financials of comparable companies and assets by utilizing Excel and Tableau strategically and technically

• Facilitated and updated clients in tailoring investment equities and services to their risk tolerance and objective based on analysis of volumetric data and consumer-feedback through monthly reports

• Organized online consulting event which maximized customer engagement by 20% and provided subject matter expertise and effective recommendations during investment portfolio and account acquisitions SELECTED ANALYTICS PROJECTS

Geographical Location Prediction of Twitter Account

• Supported development of automated streaming function to collect 8GB raw metadata from Twitter APIs to feed into MongoDB using Python programming

• Coordinated multilingual NLP analysis with most five recent tweets of each account as team developer to extracted text embeddings that are used to assist in examining the predictive power of images in the geographic location

• Collaborated with team members to construct a fully connected Neural Network model of dense layers, a mean pooling layers and dropout with SoftMax activation as the baseline architecture

• Utilized Keras Tuner hyperband tuning algorithm to assess feature importance corporately and achieved 68% accuracy Portfolio Returns Optimization

• Conducted a diversified portfolio by using historical time-series stock data in recent 5 years from Yahoo Finance, FRED Economic Data, and S&P 500 through fbasics and quantmod packages within R

• Maximized clients’ portfolio returns by researching the weights of securities to invest in, analyzing trade-off and risk and utilizing the time-series model to obtain an optimal result using R programming and PowerBI visualizations

• Developed an interactive Efficient Frontier to quickly identify the portfolio which matched risk and return requirements for both current and prospective clients, and conducted a Monte Carlo simulation model to predict return on the portfolio

Contact this candidate