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