Data Analyst

Cheng (Luphia) Li

Edison, NJ • 732-***-**** • *****.******.**@*****.***

Summary

• Highly proficiency in working with advanced Excel: vlookups, Pivot Tables, Formulas and Functions

• Experience in working with relational database, SQL, R, Power BI, and data visualization(ggplot2)

• A proactive, passionate, driven and fast learning individual working as a dynamic data analyst utilizing analytical and methodical skills and relevant expertise to help the company achieve business goals Work Experience

Technomax LLC May. 2016 – Aug. 2017

UI Developer – HTML, CSS, JavaScript Princeton, New Jersey Working on in-house projects for Technomax as a UI developer for various clients. Work mainly focus on the use of HTML, CSS, JavaScript, AngularJS, Bootstrap and other front-end technologies to achieve client specifications.

• Used AngularJS MVC Frameworks in the development of the web applications.

• Used JavaScript based server for persistent server connection to the application.

• Made use of UI-Bootstrap that is built on Angular framework to add attractive UI interactions.

• Produced content pages with CSS3 and SASS layout and style markup presentations.

• Used NPM and Bower package managers to install and manage all the required packages. The Arc Mercer Oct. 2015 – May. 2016

Data Analyst – Excel Ewing, New Jersey

• Created database of hundreds of records for the purpose of tracking and maintaining ARCTRANS department.

• Facilitated financial department gathering employees’ financial information to produce reusable Excel tables.

• Maintained and updated hundreds of staffs, volunteers and members portfolio after each activity.

• Entered hundreds invoice data every day to determine trends, outliers, or significant issues, in order to prevent future problems and translated the data to readable document.

• Analyzed and determined budget shortfalls within the ARCTRANS department and the Healthcare center. Chinese-American Family Coalition Jul. 2014 – Aug. 2014 Analyst – Excel, Word Englewood Cliffs, New Jersey

• Cleaned, aggregated, filtered and sorted 5,000 out of over 10,000 relevant residents’ information by required criteria using Excel, then formatted the layout to print using Word.

• Organized, updated and maintained students’ and teachers’ lessons and activities schedule. Project

Customized Weather Display Rutgers University

Database Design and Management MySQL, Excel Jan. 2015 – May. 2015

• Grabbed real data online into Excel to produce reusable, clean and completed records and tables.

• Imported data to construct relational database of hundreds of records using MySQL.

• self-designed web page utilizing programming skills to visualize the customized selections and results. Stock Price Prediction Rutgers University

Fundamental Analytics MatLab, R Sep. 2013 – Dec. 2013

• collected three-years 50 stock daily returns from Bloomberg to create history price dataset.

• Performed PCA on training set and used KNN classification to identify the subject for each testing observation. Crime Analysis: Rutgers University

Regression Analysis SPSS, R Sep. 2011 – Dec. 2011

• used 16 variables to explain the effect of punishment regimes on crime rates. Explored and analyzed data with R and SPSS using linear regression.

Education

Master of Business and Science in Analytics Sep. 2013 – May. 2015 Rutgers University, New Brunswick, NJ

Relevant courses: Fundamental Analytics, Regression Analysis, Advanced Statistics for Economics, Database Design and Management, Into to Cloud Computing and Big Data, Software Engineering Development Master of Science in Mathematical Finance Sep. 2011 – May. 2013 Rutgers University, New Brunswick, NJ

Relevant courses: Mathematical Finance, Econometrics, Numerical Analysis, Interest Rate Derivative Modeling Bachelor of Science in Mathematics-Economics Aug. 2007 – May. 2011 University of Pittsburgh, Pittsburgh, PA

Contact this candidate