Data Analyst Python

Jin Liu

469-***-**** *****@***.*** https://www.linkedin.com/in/ljlmsd/

EDUCATION

Southern Methodist University, Cox School of Business Dallas, TX Master of Science in Business Analytics (authorized to work in US without sponsorship for 3 years) GPA:3.81 May 2020 Coursework: Applied Predictive Analytics, Data Mining, Data Visualization and Communication, Business Forecasting, Decision Models, Business Analytics Consulting & Programming, Business Intelligence, Database Design for Business Central South University Changsha, China

Bachelor of Science in Chemistry Major GPA: 3.8 June 2018 Coursework: Advanced Mathematics, Statistics, Computer Science, SCM Foundation (Online) TECHNICAL SKILLS (*Certified, +In process)

Excel • VBA• SQL • R • Tableau* • PowerBI* • Alteryx* • Python • AWS+ • Azure+ • Data Mining •ML PROFESSIONAL EXPERIENCE

Center Street Finance Irving, TX

Business Strategy Analyst Full-Time August 2020 –Present

• Assessed/validated financials, demographics, contract, and/or collateral data accuracy using Excel conditional functions

• Structured relational database and initiated the ETL automation processes using SQL and Python on Azure

• Priced auto loans from 100+ dealerships using in-house model and modified key indicative parameters to forecast expected cash flow, generating key insights notes to CEO

• Collaborated with analytics team to optimize Due Diligence process to improve data validation efficiency

• Utilized SQL queries to maintain and build Power BI dashboards of exception and cashflow reports Avatar Healthcare Inc. Dallas, TX

Data Analyst Intern May 2020 – August 2020

• Created an automated solution using Power BI to continuously assess, monitor and realign operations and finance data

• Utilized NLP in Python script to do text analysis on over 4000 patients’ healthcare data to find patterns

• Ran machine learning algorithms on Databricks to predict patients’ status generating report with over 80% accuracy

• Generated and optimized visualized financial report using data from QuickBooks to compare annual financial KPIs Shinyway Education Qingdao Branch Qingdao, China

Consultant Full-Time March 2019 – May 2019

• Examined and analyzed institutions’ admission statements across academic metrics to customize study and career plans

• Managed a customized database including age, location, sex, and education information for 200+ clients China Development Bank Securities Hunan Branch Changsha, China Data Analyst Intern July 2018 – Feb 2019

• Evaluated current and historical clients’ financial data and recommended individual investment portfolios to clients

• Led team of two interns to study economic and business trends, and built financial statements SELECTED ACADEMIC AND FIELD PROJECTS

Capstone project with Celanese Jan.2020-May.2020

• Collaborated with Celanese HR and IT departments to analyze the KPIs of the aging workforce and the new hires

• Performed key people analytics and found insights in employee turnover analysis to optimize the hiring process and guide key stakeholders to make retirement and termination predictions

• Created business intelligence dashboards to analyze historical data, understand underlying root causes, generate projections, and extract business insights using Tableau and Alteryx

• Mined, modeled, analyzed and evaluated headcount data in Excel and R to identify potential termination reasons Trammell Crow - Data Visualization August.2019-Oct.2019

• Created an analytic system for Trammel Crow to provide insights on the effectiveness of numerous property management companies using unstructured data collected from rents, financials (actual vs budget), occupancy, and resident satisfaction

• Communicated with the client to analyze current business processes, marketing situation and future requirements to reduce costs, maximize profits and ensure uninterrupted flow of business

• Presented dashboards to clients using Tableau illustrating geospatial, customer, sales, operation and other KPI insights to determine the effectiveness of property management companies and dig out potential driving causes Natural Language Process and Text Mining Project Jan.2020-April.2020

• Utilized R and Python to clean text data and generate sentiment insights from 10k+ hotel customer reviews

• Provided recommendations regarding keywords and business insights generated from text analysis to APP builders

Contact this candidate