Post Job Free

Resume

Sign in

Data Analysis

Location:
Worcester, MA
Posted:
June 15, 2014

Contact this candidate

Resume:

Lijun (Sally) Xie

Tel: 774-***-**** E-mail:acekmh@r.postjobfree.com

Objective: Entry-level Data Analyst Full-time/Intern Position

EDUCATION

**/**** – 05/2014

Worcester Polytechnic Institute (WPI) Worcester, Massachusetts

Master of Science in Operations Design (3.75/4.0)

Courses Related: Business Intelligence Database Applications Development

Modeling & Optimizing Marketing Risk Management

09/2007 – 06/2011

Guangdong University of Foreign Studies (GDUFS) Guangzhou, China

Bachelor of Arts, International Trade Course Related: Statistics, Calculus, Probability

QUALIFICATION SUMMARY

2 years’ progressive experience in data analysis

1 year working experience in supply chain

Able to effectively work in multidisciplinary group s and fast-paced environment

Well versed in improving decision-making by modeling, monitoring, communicating and evaluating business decisions

Languages: R, SQL

Tools: SPSS, Cognos, Crystal Report, Microsoft Office Package, Visio, @Risk, Precision Tree

Database: SQLite, Microsoft Access

PROFESSIONAL EXPERIENCE

Data Analyst (Business Intelligence Course Project in WPI) 01/2014- 05/2014

MGM Data Management

Examined data attributes, identified and cleaned bad data with functions in Excel

Employed Customer Segment Analysis & Frequency Analysis with Pivot Table and functions

Used Pareto principle (80-20 rule) to identify important customers and formulated strategy to retain them

Used SPSS to conduct factor analysis to identify factors that had largest influence on annual profit

Designed dashboard based on business strategy of MGM

Data Analyst (Graduate Assistant of WPI) 01/2013- 05/2013

Online Education Software Marketing Research

Collected data on current online education software from all sources

Used SPSS to deal with missing value, conducted correlation analysis to figure out the relations between attributes

Further analyzed data in SPSS to identify targeted customer and customer preferences

Formulated strategic marketing plan for the new online ed ucation software based on its selling points

Database Designer (Database Course Project in WPI) 09/2013-12/2013

Hospital Search Engine Design

Analyzed the business requirement and feasibility

Designed the ER diagram with Visio, wrote down the SQL queries, and set up the indexes for database

Utilized Android Platform to design the search engine in order to enable search hospitals with different criteria

Data Analyst (Productivity Management Course Project in WPI) 01/2013-05/2013

Data Envelopment Model Application

Built Data Envelopment Analysis Models with VBA in Excel to look for benchmark for convenience stores with

low efficiency and low service quality, and analyzed the factors causing low efficiency

Provided recommendations to improve operation efficiency based on model results

International Business Specialist Eagle Technology Company Limited 01/2011 - 01/2012

Used techniques such as moving average, seasonal index to forecast demand and created dashboards

Managed relationship with clients around the world to improve business processes

Served and negotiated business with hundreds of custo mers at major import and export fairs in various countries

Worked with production department to follow up orders and arranged shipment by using ERP system

CERTIFICATIONS

Candidate of CPIM (Certified in Production & Inventory Management)

Lean Green Belt (02/2014)

EXTRACURRICULAR ACTIVITIES

09/2013 – 05/2014

Event Chair APICS-WPI Chapter

Represented WPI to attend Northeast District Case Competition to improve data analysis skills

Organized activities such as company tours to familiarize members with lean six sigma knowledge



Contact this candidate