Sales Project
Resume:
Yidan Hu
*** ****** ****** **** **, Vernon, CT, *6066
***********@*****.***
OBJECTIVE Highly motivated and trained analyst seeking a Business Intelligence or Data Analysis position
EDUCATION
University of Connecticut, Hartford, Connecticut Aug 2012 – May 2014
Master of Science in Business Analytics and Project Management, Major GPA: 3.66/4.00
Major courses: Business Process Modeling and Data Management, Predictive Modeling, Data Mining and Business
Intelligence, Business Decision Modeling, Project Risk and Cost Management, Advanced Project Management
Bachelor of Science in Finance Sept 2007 – June 2011
Major courses: Corporate Finance, Financial Market, Marketing Management, Investment and Securities
WORK EXPERIENCE
Business Intelligence, EXL Service, Hartford, CT May 2014 – Current
Work on SQL Queries, Stored Procedures, Packages; debug on account level; generate reports in SSRS and
perform data analysis
Solve production issues
Business Analyst Intern, Crabtree & Evelyn North America Headquarter, Woodstock, CT Jan 2014 – Apr 2014
Successfully and independently executed numerous projects - identified main factors influencing the sales;
chose one of the best store location from several options; figured up a total cost for a certain period
High proficiency in using Excel modeling, VBA, SAS, JMP skills everyday
Trust Commissioner, Ping An of China International Financial Center, Beijing, China Oct 2011 – July 2012
Developed and presented current characteristics and market share of the trust products on sales
Completed a comprehensive research report on the demand for all types of trust products by analyzing the
variation tendency in asset allocations and investment references of the rich
Financial Manager Assistant, China Everbright Bank, Beijing, China Feb 2011 – Apr 2011
Participated in the financial products training course and quickly developed a deep understanding of minimum
sales amount, investment direction, and risk level of financial products
Efficiently provided clients with professional investment advice on financial products
TEAM PROJECTS
Team Leader in an Analysis of Project Workflow at Karen Solutions Company, Hartford, CT March 2013
Helped Karen Solutions identify their most effective outreach activities and most valuable clients by
analyzing the project workflow through Outreach, Project Variables, and Client Organization
Used SAS Enterprise Miner to build decision tree, cluster, and regression models and implemented the
decision tree analysis which produced the best predictive results
Improving Maintenance Resource Tracking at Kimberly-Clark Corporation, Hartford, CT November 2012
Built as-is process flow and identified problem areas and suspicious data entries.
Used SQL to join three data sets with non-unique primary keys, for use in incentive based solution to solve
inefficient tracking of maintenance workflow
Predicting the Drivers of Adolescent Obesity, Hartford, CT October 2012
The first team to examine behavioral risk factors instead of diet and exercise to predict obesity
Utilized JMP® software to build Decision Tree, Regression and Neural Network models, among which
Regression model achieved top behavioral prediction with accuracy of 80.09%
PROFESSIONAL SKILLS Office2013, Excel modeling, Excel VBA, RExcel, SSRS, SAS, R, PL/SQL programming, JMP®,
Data Mining, Access, VF, Crystal ball, MS Project, Outlook
ACTIVITIES/AWARDS
2014 MIT Asian Career Fair Volunteer March 2014
2014 Spring Festival Gala host at University of Connecticut January 2014
20th ING Hartford Marathon Volunteer October 2013
Contact this candidate