Hongxia Lu www.linkedin.com/in/hanna-lu

Albany, NY 12148 • (323) 613 – 0149 • ac77nt@r.postjobfree.com

TECHNICAL SKILLS

Data Manipulation: Data Cleaning Data Exploration Feature Engineering Dimension Reduction

Machine Learning: Linear Regression Logistic Regression Support Vector Machine Decision Tree KNN Random Forests Neural Nets Clustering Time Series Text Mining Association Rules Survival Analysis Confusion Matrix and Cost Analysis

Business Decision Modeling: Optimization with Linear Programing Simulation Dynamic Programing Conjoint Analysis Markov Analysis Efficient Frontier Analysis Decision Analysis

Programing Languages: SQL VBA Python (Pandas, Numpy, Matplotlib, Sickit Learn) Big Data with Hadoop (Spark, Hive, Pig) R SAS (SAS Base Programmer Certificate 2018)

Statistical Software: MiniTab SPSS SAS JMP SAS Enterprise Miner

Excel: Spreadsheet Macros Solver What-if Scenario Data Table Data Analysis

Data Visualization: Tableau Visio Excel

Project Management: Risk and Cost Management MS-Project Gantt Chart Root Cause Analysis

Other: MS Access

EDUCATION

University of Connecticut School of Business Hartford, CT

Master of Science in Business Analytics and Project Management, GPA: 4.04/4.30 May 2019

Scholarship: Teaching Assistant for Statistics in Business Analytics with R (for 2 semesters)

Scholarship: Teaching Assistant for Big Data with Hadoop

Michigan State University East Lansing, MI

Master of Science in Statistics, GPA: 3.875/4.00 2005

Scholarship: Teaching Assistant for Business Statistics (for 2 semesters)

Nanjing Normal University Nanjing, China

Master of Science in Geographic Information Systems 2002

Scholarship: Research Assistant (Research Project: Children’s Map Cognition Ability Analysis System)

Thesis: Development of Land Grading and Evaluation Information System for Zhenjiang City Based on Component Technology

Inner Mongolia Normal University Hohhot, China

Bachelor of Engineering in Computer Science 1999

Awards / Prizes:

oStudent Treasurer and Leadership Award

oSecond Prize for Academic Performance

oFirst Prize in English Reading and Listening Contest

oThird Prize in English Speech Contest

Thesis: Development of Hohhot Dialect Translation System

WORK EXPERIENCE

Kunming University of Science and Technology Kunming, China

International Exchange Coordination Officer 2010 – 2017

Responsibilities:

Serve as a liaison between the university and foreign universities

Organize meetings, conferences, and events involving foreign university representatives, and create and publish summaries of these activities

Perform translation services for the Division of International Cooperation

Maintain the Division data and answer university and government information requests

Develop and translate MoUs, agreements, speech scripts, and university promotional materials

Perform risk review of inter-university agreements

Accomplishments:

Consolidated dispersed information to a single location for more efficient and accurate information management

Coordinated major international events and conferences including the 1st, 2nd, and 3rd South and Southeast Asia College Student Culture and Sports Week and the 20th Joint Meeting of the GMSARN (Greater Mekong Subregion Academic and Research Network) Board and Council of Advisors

Promoted twice: first to Deputy Section Chief, then to Section Chief

Quicken Loans Inc. Livonia, MI

Senior Data Analyst 2005 – 2010

Responsibilities:

Conduct statistical analyses to find out patterns and factors that contribute to increase revenue

Build predictive models using Minitab and SPSS

Other ad-hoc analyses to help with business decision making

Accomplishments:

Analyzed customer data to maximize direct marketing success

Built a model to prioritize leads based on the results from a logistic regression model to increase lead to loan conversion rate

Built a model to predict the number of pay units a salesperson may achieve at the end of the current month.

Automated a quarterly report for the legal team to generate a hypothesis testing analysis on Premium Price race bias using VBA programing in Excel which saved 3-5 days of work each quarter for the Business Intelligence team

Performed an analysis by VBA programing in Excel to predict the impact of HR separation on company profitability. Exceeded expectation by providing an additional option to select a specific salesman

Created various macros in Excel to automate regular reports for teammates within and beyond the team

RECENT ACADEMIC PROJECTS

Predictive Modeling: Predicted the final grades of a high school language class in Portugal using JMP, and identified factors that contribute to student performance which may be important to the admissions or academic offices of the school

SQL: Created SQL tables to manage data generated during a real-world business process and improved the efficiency and accuracy in extracting information from the database

Time Series: Built a multivariate Time Series model using SAS to forecast crime counts for the city of Chicago using Chicago crime data and data from the Chicago

Business Process Modeling: Used Optimization by Linear Programing to maximize revenue for online advertising

Loan Default Prediction: Analyzed the Lending Club data and built models using Python to predict loans that are likely to default to help Lending Club make loan approval decisions

Contact this candidate