Data Entry Analyst Intern

KE BAI

linkedin.com/in/kebai**** 314-***-**** *********@*******.*** Saint. Louis, MO

EDUCATION

WASHINGTON UNIVERSITY, OLIN BUSINESS SCHOOL, St. Louis, MO December 2022 Master of Science in Business Analytics - Financial Technology Analytics

• Coursework: Prescriptive Analytics (Python), Machine Learning Tools for Prediction of Business Outcomes, Database Design and SQL (Spark, Linux), Fixed Income Securities, Advanced Corporate Finance, A/B Testing in Business and Social Science, Text Mining, Deep Learning for Prediction of Business Outcomes BARUCH COLLEGE, New York, NY June 2021

Bachelor of Business Administration, Accounting

• Coursework: Financial Accounting III, Fundamentals of Business Law, Law of Business Organizations, Elements of Calculus III, Linear Algebra & Matrix Methods, Mathematics of Data Analysis, Quantitative Methods for Acct. SOUTHWESTERN UNIVERSITY OF FINANCE AND ECONOMICS (SWUFE), Chengdu, China June 2020 Bachelor of Business Administration, Accounting

• Coursework: Advanced Algebra, Statistics, Probability Theory, C++ EXPERIENCE

Accenture, Shanghai, China January 2021-February 2021 Business Analyst Intern

• Analyzed gas industry data using SQL and Python. Drew business data visualization about gas industry equipment through Tableau and facilitated ordinary business process and increased management efficiency by 10%.

• Entered the data from handwriting form into the database, collaborated with other project members to double-check data entry, and corrected differences between two databases to ensure data quality.

• Collected the data with Excel and analyzed the graduation data, such as employment direction, industry choice and salary, from thousands of 2020 universities graduates, with SQL and gave proposes about choosing companies and industries. China Galaxy Securities, Wuhan June 2020-July 2020 Assistant Wealth Manager

• Customized financial products (equity, derivatives, fixed income) for 10 clients based on risk tolerance, trading history, and other behavioral data. Leveraged strong face-to-face communication skills by patiently and professionally understanding customers' goals.

PROJECTS

Research on Amazon Product Rate, Saint. Louis, MO November 2021

• Download data from Kaggle about the amazon product rate that more the 1 million rows and upload it to HUE which enable our team members to access this data online and do some data analysis using SQL queries.

• Analyzed the data through HUE and wrote MapReduce function in Linux to make deeper analysis, such as I found the positive relationship between verified rate and average product score and use MapReduce to count the word frequency. Data Analysis on Hotel Selection System, Saint. Louis, MO December 2021

• Led a team to do the data cleaning and business analysis with Python (NumPy, Pandas). Gave suggestions on hotel selection based on the analysis of customers' different preference, such as comfort, noise, and price.

• Used Tableau to draw four sheets, like scatter plot and pareto chart, and one dashboard to do the filter action, and gave insight data visualization of the hotel data.

Prescriptive Analysis on Missouri Shoe Co., Saint. Louis, MO December 2021

• Built prescriptive analysis model with Python to supply suggestions on goods distribution plan and production plan for Missouri Shoe Co, thus minimize their shipping cost and maximize the distribution efficiency.

• Built model to count revenue and cost with Python to supply best solution for different expansion plans under different backgrounds.

Amazon Product Review Analysis, Saint. Louis, MO May 2022

• Used VADER to analyze the review of products and preprocessing more than 50,000 pieces of data.

• Fitted two deep neural network models with LSTM and found that the summary includes the most information of the product’s review. The best test loss is 0.16 and the best mean absolute percent error is 10. PROFESSIONAL SKILLS

• Technical: Python(NumPy, Pandas), R, Linux, SQL, Spark, Hadoop

• Industry: Machine Learning (Random Forest…), Deep Learning(CNN, LSTM…), A/B Testing, Prescriptive Analytics, Data Visualization

Contact this candidate