Social Media Data Analyst

Steven Xu

Irvine, CA ***** 949-***-**** ********@***.*** LinkedIn: www.linkedin.com/in/Steven-Xu-082601193 EDUCATION University of California, Irvine, Paul Merage School of Business, Irvine, CA 06/2020 M.S. Business Analytics (GPA 3.84)

Jilin University, School of Mathematics, Changchun, Jilin 07/2015 B.S. Information and Computing Science

WORK EXPERIENCE __

CA Fantuan Inc., Tustin, California 06/2020-Present Business Analyst

• Analyzed prices, promotions, distances, delivery time and qualities of different restaurants and generated optimized business model. Wrote reports about solutions for customers to refer to.

• Identified and reconciled errors in client data to ensure accurate business requirements.

• Gathered information, developed business plans and determined KPI and 15% increase in sales around the USC area per month by leading a three-person team. Experian, UCI Capstone Project, Irvine, California 01/2020-06/2020 Research Data Analyst

• Developed three machine learning predictive models to rank a consumer’s likelihood of filing bankruptcy that challenges the existing methodologies and increased 6% of the accuracy rate . Holistic Financial Planning, Irvine, California 08/2019-12/2019 Market Analyst

• Assisted the operations department to conduct social media marketing campaigns.

• E-Money Platform and UCI Life-Vest Consultant.

Beijing LCZ Art Creative Co., Ltd, Beijing, China 07/2015-08/2018 CFO & Co-founder

• Established detailed spreadsheets to identify trends and innovative forecasting program for developing budget planning in the future.

• Perform sales revenues analysis to optimize company operations and 20% increase in profits.

• Led an 11-person team to establish and maintain long-term partnerships with companies such as Mars, Lenovo, Volkswagen, Xiaomi Corporation, etc.

Ping An Capital Co., Ltd, Shenzhen, China 01/2015-06/2015 Private Equity Analyst

• Assisted in establishing a Qualified Foreign Limited Partnership (QFLP) fund through the whole process: conducted due diligence, carefully prepared documents, and composed industry-specific analytical reports.

• Visited elderly service providers to gain first-hand materials to compose research reports.

• Sought possible investment cooperation with Shenzhen Investment Holdings by business negotiation. SPD Bank, Changchun, China 04/2014-12/2014

Risk Analyst

• Evaluated the clients’ risk tolerance by communicating, drafted risk evaluation reports and recommended ideal financial products with a completion of >50 Monetary Fund and Equity Fund contracts.

• Provided accurate report with financial insight to allow business partners to improve performance.

• Promoted various financial products and developed strong analytical supports through gathering and analyzing information on financial products such as national debt, pension funds and A-share index fund. RELATED COURSES & SKILLS

• Certification: Passed the CFA Level II Examination.

• Technical Skills: Proficient in Excel, SQL, Python, R, Tableau, ERP, SAP, Hadoop, SAS, C, MATLAB.

• Interests: Choreography; Music Instruments (jazz drum, guitar, piano and bass); Basketball and Ping-Pong.

Contact this candidate