Data Project

Sherry Li

607-***-**** Jersey City, NJ *****@*******.***

LinkedIn: https://www.linkedin.com/in/xiaowei-li-04936966?trk=hp-identity-photo Education

Cornell University, Ithaca, New York MPS, Applied Statistics (Accomplished) Aug 2015-Jun 2016 GPA:3.74, Big Data Management and Analysis, Python Programming and Application, Database and SAS HPC with DBMS, Linear Models with Matrices, Applied Stat Comp with SAS, Statistical Computing University of Cincinnati, Cincinnati, Ohio BS, Mathematics Aug 2012-Jan 2014 GPA: 3.98 (Dean’s honor list), Time Series, Math & Statistics, Probability & Statistics, Applied Statistics Capital Normal University, Beijing, China BS, Applied Mathematics Sept 2010-Jul 2012 A-level Scholarship winner of Government Funded Overseas Students Skills Highlighted

Proficient in R, SAS (Certification: SAS Base and Advanced Certification, CFA level I(Candidate)), SQL, Python, Excel (Vlookup, Pivot table), Word, PowerPoint, familiar with Hadoop (Hive, Pig)

Solid Background with 2+ year experience and strong interests in Statistics and Risk Analysis Work Experience

NYCMaster LLC, Jersey City, NJ Marketing Analyst Intern Jul 2016-Present

Predicted the future profit and performance by building Monte-Carlo and extreme-value theory model

Increased corporate’s monthly revenue from $60000 to $66000 by adjusting pricing strategy in July

Constructed and maintained ideal relationships with existing and potential customers with integrity TripleMint Company, Ithaca, NY Data Analyst, Project Intern Dec 2015-Jun 2016

Established models to interpret the apartments’ close prices in the New York City

Collected the historical records and the news of the real estate market trending in the New York City

Took advantage of SQL, python (with matplotlib packages) to visualize the relationships between data

Reduced the 16 dimensional variables to 5 dimensional components with methodology including: factor analysis method, stepwise selection, best subsets regression and Principal Components Analysis

Utilized LASSO and Monte Carlo Cross-Validation methodology to generate model coefficients

Assigned and distributed the tasks to team members and initiated the plan to complete the project

Wrote a 30-page report, presented and interpreted it to the clients with positive feedback China Pine Capital, Beijing, China Intern Dec 2015-Jan 2016

Utilized Python to carry out data analysis among the National Electronic Injury Surveillance System

Conducted industrial research upon e-commerce, luxury vehicles and mobile advertising

Analyzed public data from proxies and 10-Q forms to evaluate companies’ financial well-beings

Wrote reports and presented it with Power Point to the supervisor weekly Bank of China, Beijing, China Intern Apr-Sept 2014

Participated in valuing loan loss reserves by classifying the degrees into 0%, 2%, 25%, 50% and 100%

Qualified corporates’ credit history by collecting raw data and conducting implement credit model

Applied conditional probability function to generate loan risk degree based on corporates’ credit history

Segmented loan forms into 4 levels and applied loan asset degree equation to measure loan risk amount

Presented and interpreted the outcome to loan risk department director in every Wednesday conference PriceWaterhouseCoopers Advisory, Beijing, China Risk and Control Assurance Intern Jan-Apr 2014

Initiated the project to determine the risk points of ‘HUA NENG’ company based on historical reports

Led the other interns in the team to go through the client’s documents and define the risk levels

Trained the fresh interns with Excel skills to assist the senior associate to build questionnaires efficiently

Ability to manage multiple tight deadlines by prioritizing urgent tasks and working over time

Contact this candidate