Data Analyst

He Liu

** ****** ******· New York, NY***** ç646-***-**** *********@*****.***

SUMMARY

2+ years of experience in data analytics, economic research, real estate services, and business administration. Critical thinker with an ability to interpret and analyze data to draw conclusions and identify patterns through econometric modeling methodologies, develop and implement databases, and prioritized business goals and needs to increase business performance. Adept at creating records management systems, conducting research on business operations to identify areas for improvement, and observing and auditing data quality. Area of Expertise

§ Data Analytics § Market Research and Analysis § Financial Valuation

§ Due Diligence Process § Decision models and analysis § Econometric Modelling

§ Stata, SQL, Excel, Power Point § Long-term Relationship Building § Time Management EDUCATION

New York University New York, US

MA in Economics GPA: 3.83 / 4.00 Expected in May 2021 Coursework: Econometrics, Real Estate Finance, Decision models and analysis, Macroeconomic Theory The Chinese University of Hong Kong Shenzhen, China Bachelor of Business Administration GPA: 3.73 / 4.00 Sept. 2015 – May. 2019 Professional Development: ACCA (Association of Chartered Certified Accountants) Advanced Diploma in Accounting and Business

WORK EXPERIENCE

Research Assistant, Jan. – Mar. 2021 Pennsylvania Office of Attorney General, Philadelphia, US

§ Implemented effective econometric modeling methodologies and utilized STATA software for collecting and processing large datasets

§ Evaluated and cleaned the qualitative and quantitative data, inspected data and quality, and processed data in-line with provided rules

§ Successfully recognized complexity issues, performed in-depth research and analysis of multiple data types, and provided proper recommendations for problem solutions

§ Assessed and predicted relationships between demographic variables and gun recovery through empirical research

§ Communicated data-driven analysis and insights in the form of “data studies”, which enable a nuanced understanding of data

§ Delivered hands-on support in producing economic impact reports and other public-facing analyses Financial Data Analyst Intern, Sept. – Nov. 2020 Empire State Development, New York, US

§ Abetted in preparation of updating PeopleSoft’s ESD vendor database by compiling / analyzing data for vendor data collection project

§ Introduced an online financial system for existing employees by assisting with setting web conferences and preparing PowerPoint

§ Conducted PeopleSoft SharePoint Folder Document analysis through excel and utilized VLOOKUP to assess data in different files

§ Standardized application function, data, and process flows by using provided templates as well as assisted in preparing training materials

Investment Banking Analyst Intern, Jul. – Oct. 2020 Network 1 Financial Securities, Inc., New York, US

§ Scrutinized deep financial and corporate information and performed discounted cash flow models and pro forma merger in Excel

§ Performed due diligence including sector market and company-specific research and created memoranda for internal committees

§ Established statistical exhibits and trend analysis of financial performance for client presentations. Business Analyst Intern, Jul. – Aug. 2018 Credit Card Center, CITIC Bank, Shenzhen, China

§ Effectively utilized SWOT analysis and established business strategies by performing due diligence on an online payment business and completed a 10-page report on competitors’ key products and strategies

§ Functioned VLOOKUP and Pivot table to analyze and visualize the data from on-going promotion activities through Excel

§ Categorized data patterns & trends, provided insights to drive business decision making, and assisted to improve business processes

§ Assessed business processes, detected business issues, prioritized business/data needs by communicating with clients, cross-functional departments and management team

Contact this candidate