Post Job Free

Resume

Sign in

Data Analyst

Location:
Dallas, TX, 75231
Posted:
October 20, 2020

Contact this candidate

Resume:

Zichen (Ho) He

720-***-**** adg5fe@r.postjobfree.com www.linkedin.com/in/zichenhe/

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics May 2020

Cumulative GPA: 3.63/4.00

University of Colorado Boulder Boulder, CO

Bachelor of Arts in Mathematics and Economics, Minor in Business May 2019 TECHNICAL SKILLS

Statistics, Operations Research, Applied Econometrics, Data Visualization, Database Design, Machine Learning, NLP Microsoft Office, R, Python, SQL, STATA, Tableau, Alteryx, PowerBI, KNIME, MATLAB, Visual Studio, Spark PROFESSIONAL EXPERIENCE

DataReady DFW Dallas, TX

IT Automation Intern Jun 2020 – present

• Implemented machine learning chatbot, help customer navigate website by relation, decision diagrams and python

• Developed and utilized centralized area to manage automation processes, dashboards, reporting, by PowerBI

• Measure and analyze KPI performance to maximize search engine returns and refine chatbot interfaces Teknion Data Solutions Irving, TX

Data scientist – Pine Cove Project Jan 2020 - May 2020

• Identified staff vacancies, defined, and chosen “best” applicants from 20k past applicants by R and Tableau

• Made hiring recommendations by different machine learning algorithms and identified 3 third party data sources to help client expand potential future recruiting opportunities

• Examined recruitment criteria to ensure conformance to professional, statistical, or testing standards, and built a meaningful model to help client select future employees more efficiently BOC International (China) Co., Ltd. Beijing, China Finance Analyst Internship - Fixed Income Department Jun 2018 - Aug 2018

• Created and distributed 4 updated customer statements based on relevant data from database

• Drafted prospectuses for 3 real estate companies and helped underwrite securities issues

• Utilized finance database by SQL and excel to manage 3 financial statements and assess overall performance

• Evaluated financial statements and income statements to examine 3 real estate company's financial performance China Railway Nanchang Group Co., Ltd. Nanchang, China Data Analyst Internship - Passenger Transport Department Jun 2017 - Jan 2018

• Led actionable ticket sell recommendations based on data trends by STATA and R, decreased customer complaint rate by building effective model and increased seasonal profits by 3%

• Reviewed business areas to strengthen analytics, enhance strategic planning by analyzing SQL databases

• Collaborated cross-functionally with business analysts and developers to explain new transformations

• Assessed data, addressed issues, and directed concerns to business unit leadership ACADEMIC PROJECT

Database Project – Team leader Oct 2020 - Dec 2020

• Developed database architectural strategies at modeling, design, and implementation stages to build a 1, 000, 000 records database about all flights depart from TX and ensured the CRUD function worked with SQL

• Established web application by R shiny to allow customers and managers check overall performs of every flight

• Found delay reasons, made recommendations to help customer choose flights as needed by R and visualization FlagShip Credit Acceptance - SMU Project Aug 2019 - Oct 2019

• Filtered, aggregated, and blended 70k+ loan application data and founded meaningful relationships by Alteryx

• Used Tableau to identify problems, risk, trends about the loan process and analyzed clients’ challenges

• Presented interactive dashboards with Tableau to provide business insights, solutions, and recommendations



Contact this candidate