Sql Server Data

SHENGPENG JIN

Address: *** ********* ***** **. *** 4, Louisville KY, 40217

Email : ************@*****.*** Cellphone: 502-***-****

Summary

Operations Research: 5+ years of research experiences in operations research, optimization and industrial Engineering.

Business Analytics: 3+ years of experiences in business system development, process review, support and reporting.

Data Analytics: 4+ years of experiences in data analysis with SAS, database administration with SQL and 2+ years of data mining.

Computer Skills: 10+ years of experiences in programming, including 3+ years in web development.

Skills

Statistics: SAS (with SAS Base Certification), Minitab Programming: Java, C/C++. VBA, SQL, HTML, JavaScript

Database: MS SQL Server, MS Access Social Network Analysis(SNA): Gephi, UCINet

Data Mining: Weka, SAS Enterprise Miner Other Software: Microsoft Office, ArcGIS, Arena

Optimization: MATLAB, CPLEX, LINGO, MS Excel

Work Experience

Aug/09 – present

Research Assistant, Real-time Decision Support System(RTDSS) Lab at University of Louisville

Description: My responsibility is to develop and improve the disease spread model which is part of RTDSS. Different data mining

methodologies, such as decision trees, neural networks and regression, are used to determine the main factors of disease spread.

Skill & Tools: Logistic regression with SAS 9.3, Data mining with SAS enterprise miner, Contact Network with MATLAB &

UCINet, Spatial temporal GIS with ArcGIS

Achievement: The system provides the early detection of infectious diseases and also gives suggestions to the public to prevent

potential pandemics. Also, the strategy of vaccine distribution could be based on the results of risk analysis.

Operations Research Analyst, Research Institute of Automation at Dalian University of Technology Dec/07 – Jun/09

Description: The improvement and the optimization of the vehicle scheduling and routing in Liaohe oil field.

Skills & Tools: Mixed integer programming (MIP), shortest path theory and genetic algorithm with MATLAB and VBA

Achievement: The new strategy optimizes the scheduling of the petroleum transportation by building the statistical optimization

models I introduced which financially reduces the cost of the vehicle routing for petroleum extraction spots by approximately 20%.

Sep/06 – Nov/07

Business Analyst, Liaohe oilfield of China National Petroleum Corporation

Description: As a team leader, I built the management information system (MIS) for the scientific development department of the

Liaohe oil field of China National Petroleum Corporation.

Skills & Tools: Java, JSP, JavaScript and Html with Eclipse, Tomcat and MS SQL server

Achievement: This MIS has access to the input of raw daily data from the oil field wells and also automatically generates the

relevant working spreadsheets and reports for daily production and consumption based on customer demand.

Education

Ph.D. in Operations Research at University of Louisville GPA: 3.9/4.0

Ph.D. Dissertation: Contact Network Based Risk Assessment to Prevent Potential Pandemics

M.S. in Industrial Engineering at University of Louisville GPA: 3.9/4.0

Courses: Operations Research, Data Mining, Mathematical Statistics, Optimization, Simulation, Experimental Design, Intro to GIS,

Advanced Production System Design, Operations Management, Discrete Optimization

Master Thesis: Early Detection and Control of Potential Pandemics

B.S. in Computer Science at Dalian University of Technology GPA: 3.7/4.0

Courses: Principles of Computer, C/C++ Language, Machine Learning, Database Theory & SQL Language, Software Engineering,

Design and Analysis of Computer Algorithm, Data Communication & Computer Network Probability & Statistics.

Honors & Awards

University Fellowship, University of Louisville, 2009-2011

Travel Award of INFORMS Annual Conference, University of Louisville, 2010-2012

Invited Talks

IIE 2011, Reno, NV; IIE 2013, San Juan, Puerto Rico; INFORMS 2010, Austin TX; INFORMS 2011, Charlotte, NC; INFORMS

2012, Phoenix, AZ; INFORMS Midwest 2011, Columbus, OH;

Contact this candidate