Honghua Tao Email & Phone Number

Princeton, New Jersey, United States

● Extract 4 years sales related data via Cognos software and Alteryx; Summarize the past business performance by visualizing the data and analyzing with various key factors such as RFM, Lifetime Value, New Customer ratio, etc.● Utilize both time series and deep learning models to predict monthly and quarterly sales performance for 2020; Select the best model for predicting monthly franchises revenue, and the predictions for January and February are more than 97% accurate● Perform Market Basket Analysis on annual sales and find possible up-selling and cross-selling solutions to advise the salesforce; Connect with sales manager and filter the useful product combinations from his actual sales feedback; Use Plotly in both Python and Azure Databricks to visualize the analysis outcomes and make them more business friendly● Try various strategies, including reshaping the data frame and redefining parent and foreign keys, to mine the sales data and figure out useful factors influencing pricing change and revenue shape; Perform various classification algorithms to find out how price changing influences sales revenue and define the price elasticity● Assist with multiple groups to build a data analysis problem solving platform within the company● Create Azure dashboard, PowerPoint and Excel report and present them for Director, Senior Director and CIO to visualize the project outcomes, analyze potential improvement, make business strategical suggestions and explain current business performance

New Jersey

● Used Python and Excel to develop prediction models to forecast railroad injury and fatality rate; produced and presented a final report and a poster to faculty and external mentors on the final presentation day ● Employed Random Forest Algorithm to select features with high weight for the chosen class attributes and improved the prediction accuracy● Applied K-modes, K-prototypes clustering algorithms and found hidden relationship among attributes● Applied Word Cloud techniques to process text mining and identified key words of accident description

Shanghai City, China

● Developed a comprehensive understanding of the margin flow and systems, and facilitated the team in setting up the seven scenarios of margin calculation methods; built a dashboard which automatically highlight potential margin calls ● Assisted the team with hedging strategies such as delta and gamma hedge by using Python to process Black-Scholes Merton model for option price● Helped with the automation and enhancement of the Value at Risk (VaR) model using Python: optimize the current VaR model and leveraged cloud computing (AWS) to reduce the calculation time by 95%

● Performed due diligence on five pharmaceutical companies in Israel to determine acquisition potential: researched industry trends, key players, analyzed financials, and investigated market feedback● Researched and identified 15 potential acquirers in Asia and Europe based on business and industry research● Used Python to develop an internal comparison tool to allow customized comparison of companies within the database which boosted search speed by 40% and improved research quality ● Used SQL to help manage and clean up the internal database to enhance accuracy and efficiency

New Jersey

● Conducted industry analysis for the chemical industry by examining environmental issues, supply chain/logistics, economics/commodity markets (supply/demand) ● Performed company analysis for Olin Corporation using the SWOT model and forecasted its 5-year future financial performance including balance sheet, income statement, and cash flow statement ● Identified opportunities and risks; created a final presentation in PowerPoint and presented to industry executives

Master Of Business And Science, Data Analytic, 3.51

• Focused on both science and business field and analysed the observations for hidden information. • Concentrated on machine learning.

Bachelor Of Arts - Ba, Mathematics, 3.2 (Major: 3.75)