Yidan Hu

*** ****** ****** **** **, Vernon, CT, *6066

860-***-****

acfs3n@r.postjobfree.com

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