Jiangchuan Wang
**** ********* ** ** **, Atlanta, GA 30319 Phone:909-***-**** Email:ablhfo@r.postjobfree.com
EDUCATION
MS of Statistics (Data Mining) (GPA:3.95/4.0)
University of Central Florida, Orlando, FL May 2010
MS of Computer Science (GPA:4.0/4.0)
Georgia Southwestern State University, Americus, GA May 2008
BS of Mathematics
Shanghai Ocean University, Shanghai, China Dec 2006
SKILLS
• SAS:SAS BASE,SAS/MACRO,SAS/SQL,SAS/STAT,SAS/GRAPH,SAS/ODS, Enterprise Miner 4.3 and 5.2,
Connect Enterprise Guide, Forecast Studio
• Certificate: SAS Certified Predictive Modeler Using SAS Enterprise Miner 5
• Knowledge in statistic: Linear and Logistic Regression, Tree Based Method (decision tree, Regression
Tree), Boosting, Bagging, Random Forrest, Neural Network, Clustering, Principle Component Analysis
Proficient in SEMMA model building process
• Tools: Microsoft VS.NET 2003, VS.NET 2005, SQL server, Oracle, Jbuilder,Netbean etc
• Programming Language : C# (proficient), VB, C, C++, BPEL, JavaScript, Java, SQL, Cold Fusion, HTML
• Language: fluent oral speaking in English, native in Chinese
WORKING EXPERIENCE
WDW Team Disney, Lake Buena Vista, FL 05/ 2009 – 08/ 2009
Data Mining Specialist
• Obtain, load and cleanse source of 10-years sales data for Disney Broadway Show
• Generate 2D and 3D plot to visualize and identify interested variable relationship
• Assist statistician to develop optimization model to find the best price shifting for Disney Broadway Shows in
order to maximize the expected revenue
• Cleanse and combine 6 month online traffic data for ABC Full Episode Player
• Identify ABC FEP data problem for particular time period using 2D graph
• Examine revenue report of ESPN website of Financial Year 2009
• Locate potential revenue improvement aspects by applying visualized Waterfall analysis on revenue and expense
for each section of ESPN website.
• Assist data analyst to conduct clustering analysis for data of ESPN channel in YouTube
Tools used: SAS BASE, SAS/MACRO,SAS/SQL,SAS/STAT,SAS/GRAPH,SAS Enterprise Guide, SAS Enterprise
Miner, Excel,Excel VBA
ACADEMIC EXPERIENCE
SAS M2009 Data Mining shootout, Orlando, FL 03/ 2009 – 08/ 2009
Team Leader
• Write SAS Macro to automatically generate stat wise and county wise heat map for crop annual yields in HTML
format
• Implement data preparation including data error checking, training dataset partitioning, missing value imputing,
variable transformation and level reduction using SAS macro and SQL procedure.
• Build combined prediction model to estimate annual yields for all US counties based on past ten years data.
Tools used: SAS BASE, SAS/MACRO,SAS/SQL,SAS/STAT,SAS/GRAPH, SAS Enterprise Miner
United States Census Project, Orlando, FL 09/ 2008–12/2008
Team Leader
• Convert and format SAS data set from raw data in FTP server of census website
• Modify and impute census data set using enterprise miner 5.2
• Operate and conduct exploratory data analysis based on polished dataset
Tools used: SAS BASE, SAS/MACRO, SAS/SQL
Student Enrollment online Information System, Americus, GA 01/ 2008–05/2008
Team Leader
• Design and write a Oracle database structure to save student and course information
• Create SQL embedded interface to interact with Oracle database
• Develop a Dynamic course selection web application for student to enroll and select courses(connect with Oracle
database )
Tools used: Oracle 10g, ColdFusion
Robot Soccer Game and Map Explorer Project, Americus, GA 01/ 2007–05/2007
Team Leader
• Design and build a Lego robot which can be remotely controlled for robot soccer game
• Develop remote C# based application to control robot using Bluetooth
• Design and build map explore robot using ultrasound sensor
• Develop software simulator and controller to get the map chart of a unknown room based on the information
collected from remotely controlled robot
• project website link:
http://vlab.gsw.edu/vl- web/Projects/StudentProjects/Spring2007/RobotSoccer07/WebForm1.htm
Tools used: Microsoft Visual Studio 2003, C#
HONORS
• Fourth Place Winner of SAS M2009 Data Mining shootout
• Second place of 2005 China Undergraduate Mathematical Contest in Modeling (2005)
• Third place of 2006 China Undergraduate Mathematical Contest in modeling (2006)
• Second Prize of People's Scholarship, twice (2005, 2006), rank 5 out Of 100;
• Third Place Winner of 2007 GSW Cipher Defense Contest
ACTIVITIES
• Graduate Teaching Assistant, University Of Central Florida,2008-present
• Vice President, Association for Computing Machinery Chapter of GSW, 2006 - 2008
• Vice President, Society of Mathematics of Shanghai Ocean University, 2005 - 2006
• Sports Coordinator, Chinese Students and Scholars Association at UCF,2009-present
• Basketball Box score Recorder: GSW hurricane basketball Team (Jan 2008-May 2008)
• Student member, Association for Computing Machinery, 2007 – present
• Computer Lab Assistant: GSW CIS school lab (Sep 2007-May 2008)
References are available upon request.