CHEN, PAN (PAMELA)

*** * ********* **, ******* - IL,

Tel: 608-***-****, Email: ac3ecb@r.postjobfree.com

SUMMARY

More than five years of experiences gained through both academic training and industry practices in micro-data analysis and macro-data analysis for various industry businesses with strong background in Economics, Mathematics, and Statistics. Well versed with econometric model such as predicting model, stochastic model, linear and non-linear constrained optimization model, aggregate model, etc. Familiar with empirical pricing modeling and optimization. Knowledgeable in business data collection and mining, financial econometrics, strategic marketing methods analysis. EDUCATION

M.S, Economics, 2013-2015 M.S, Master of Science in Analytics, 2017 - Present Department of Economics, Graham school,

University of Wisconsin, Madison The University of Chicago TECHNICAL SKILLS

Data Mining/Statistics Analysis: R, SQL, Tableau, Excel (Pivot table, VBA), Collaboration Tools

(Google Spreadsheet, Fusion Table, Chart), Hadoop (Spark, Hue) Programming Language: PYTHON, R

EXPERIENCES

Senior Data Analyst 2/2017 - Present

Panduit, Tinley Park, IL

Lead pricing analytics to execute Enterprise and Data Center Business Unit pricing strategies globally targeting at maximize revenue globally including time series, panel data model, linear regression, K-means clustering and decision tree. Effectively seek to obtain market competitive pricing in each country, via developing competitive market scanning tool. Key player to help deploy pricing optimization initiative. Expert in the Data Center team to support Product Managers in building their classification models, including customer segmentation via email campaign. Use classification models to provide product recommendations for consumers. Develop dashboard to measure success of pricing optimization initiative. Responsible for global price strategies analysis for 2017. Measured the pricing impact for over 100,000 items via statistic models. Create the fundamental pricing categories for all the products using machine learning algorithms and increase the efficiency in operation by 66.6%.

Pricing Analyst 8/2015 – 2/2017

Sears Holdings Corporation, Hoffman Estates, IL

Generated and presented weekly reports to VPs about current price position, and gave out suggestions on dynamic pricing based on monitoring over 20 competitors’ price changes. Involved in strategic price modeling, including clearance price model, promotion price model, and regular price model, applying statistical methods such as linear and non-linear regression, decision tree, KNN, K-means and other machine learning models. Cleaned over billions rows of raw data from different database such as SQL, online raw data file, and Hadoop database. Conducted price tests for newly introduced items and provided the pre& post analysis. Maintained weekly price change impact reposts and responsible for online / in store regular and promotion price changes.

1.Clustering Project

Scrapped competitors’ location and price data from their official websites by Rstudio. Created models based on competitors’ in-formation for matched items. Optimized promotion and regular prices for over 80% items under automotive department based on KNN and K-means models. Generated over 2 million revenue from this new model.

2.New price Project

Provided price suggestions for newly-introduced items and aged inventory items based on machine learning models such as decision tree. Tracked historical price change and set pre& post test-analysis on these items and improved the price strategies.

Senior Data Analyst (Intern) 7/2014 – 8/2015

EXPORT ABROAD, Madison, WI

Programmed “do-files” with STATA and SAS to pre-process (cleaning and recoding) raw data. Framed and tested econometric models including linear and non-linear models to predict potential profits. Involved in data collection from open sources such as World Bank, IMF, public statistics departments in UK, Canada, India, and China, and manipulated data through SQL. Specifically, worked for following clients:

1. UPS Project

Data cleaning and model: conducted company-specific analysis, proposed expansion strategies, and provided target markets in the consulting pool based on their products. 2. A Fortune 500 Client

Participated in data-mining and predictive analytics. Provided export-estimation on their current trade flow by manipulating data from different resources and worked on profit prediction on e-commence. 3. Localization Project

Conducted US software localization project with marketing companies in China, including business exploration, product presentation.

Data Analyst (Intern) 7/2012-8/2012

HangSeng Bank, Shanghai, China

Monitored performance on 45 existing portfolios via annual review reports. Reviewed financial institution’s loan documentation to ensure accuracy in reporting credit, income, assets, and liabilities, while complying with all bank policies and lending regulations. ACADEMIC COURSES

JAVA, Data Structure, R Programming, Finance Analysis, Risk Management, TMT Simulation foreign trade operation, Accounting Manual Operation, Export Trade Operations, Micro-Economics (sequence 1, 2), Macro-Economics, Applied Econometrics(sequence1,2,3), Finance Accounting, International Trade, International Finance, Industrial Organization, Linear Optimization, Machine Learning

Contact this candidate