SAS(Advanced Certification), R, SQL, Matlab, C++, Python

Fengping(Catherine) Wang

****.****@***.*** * **** Stadium Drive, Apt 1, Columbus, OH, 43210 * 614-***-**** EDUCATION

The Ohio State University Columbus, OH

M.S. Applied Statistics May 2017

North China University of Technology Beijing, China B.S. Information and Computing Science June 2015

DATA ANALYSIS WORK EXPERIENCE

Yi Sheng Yi Shi Jewelry Company Beijing, China

Data Analyst January-July 2015

Analyzed transactional database of 6 sales regions through analytical tools such as SQL, SAS, R and Excel to develop timely, applicable and actionable insights weekly.

Performed data analysis during all phases, such as targeting, monitoring and evaluation and wrote reports monthly.

Led a 3-person team to conduct analysis of crystal necklace, extracting and analyzing data to identify market size, growth, pricing, geographical opportunities, and competitive environment as part of a comprehensive three-year crystal decoration market forecast report.

Acted as part of a 6-person team to do market research for a new product, using 20 days to generate a report including market space, market trends, supply and demand, competitive intelligence, costs and profits and expected problems and solutions for silverwork.

Performed in-depth analysis of ongoing operations for assigned business area, identifying important trends, key risk, and opportunities for cost reduction and process improvement.

Structured findings to effectively communicate data and insights that can be easily understood by non-technical managers and clients.

Completed weekly training seminars that included client consultation skills and use of data analysis applications (SAS, R and SQL). Yue Mu Zhi Yuan Jewelry Company Beijing, China

Financial Analyst Intern June-September 2014

Provided a variety of financial analysis support, including sales, marketing and labor related cost analysis and profitability.

Gathered and Structured data to drive business by defining strategy, developing execution plans and measuring performance.

Supported finance team in month-end closing procedures: reconciliation, journal entries and reporting, including analyzing bank statements and checking 2 kinds of bills.

Collaborated on preparation of reports, presentations and analysis designed to communicate financial insights to managers and clients. DATA ANALYSIS AND CUSTOMER SERVICE WORK EXPERIENCE China Computer World Publishing Service Company Beijing, China Assistant & Translator Intern June-September 2013

Assisted with sales research and data collection for author & agent meetings, sales target preparation and sales analysis.

Performed clerical responsibilities such as answering phones, taking messages, overseeing the inflow and outflow of projects.

Updated and maintained key editorial, executive, production and publishing workflow documents.

Scheduled and took notes at seasonal, monthly and weekly meetings and translated English articles into Chinese. Hong Kong Tea House & Restaurant Company Beijing, China Customer Service Representative February-August 2012

Sold Chinese dishes to diverse customers on a daily basis, and advertised, marketed, recommended menus to customers.

Communicated product knowledge to customers, facilitating decision making.

Provided a pleasurable dining experience to customers, resulting in a 100% customer satisfaction.

Collaborated on daily operation, dealing with customer complaints and creating alternative solutions to solve their needs. ADDITIONAL SKILLS

Computer skills, SAS(Advanced Certification), R, SQL, Matlab, C++, Python, Microsoft Office Software

Financial knowledge, CFA Level II, knowledge of business and finance

Leadership skills, Organized The 12th National College Students Congress in Beijing, China, 2013 Served as a part-time English teacher for high school students in Si Gao Qi Training School HONORS

1st place in Mathematical Modeling Contest of Beijing, China, 2014

2nd place in Statistical Modeling Contest of Beijing, China, 2015

Outstanding Graduate of North China University of Technology

Contact this candidate