Supply Chain Management

JIE YAN

**** * ******** **** *** ***, Shaker Heights, OH 44120 216-***-****

******@*****.***

SUMMARY

. Experienced professional adept at influence business strategy through

analysis and creative problem solving

. Team player with hard working attitude and a drive to get solutions

implemented

. Master's degree with strong analytical, quantitative and computing skills

and solid knowledge in marketing, finance and supply chain management

PROFESSIONAL EXPERIENCE

Progressive Insurance

Mayfield Village, OH

Product Analyst II - III

September 2007 - present

. Supported the management of growth and profitability for the auto

insurance product with $200 million annual revenue and grew the business

profitably by 10% in 2009

. Managed the introduction of most innovative products and coordinated with

a cross-functional team

. Analyze data to develop solutions to a variety of product development and

implementation business problem

. Assessed rate adequacy and growth opportunity by analyzing industry and

historic trends and product segmentation

. Researched key competitors to fully understand their pricing elements and

indentify areas of improvement which helped to formulate competitive

strategy in the market place

. Improved a bad debt estimate model to select the appropriate billing

plans which can minimize bad debt exposure while attracting the desired

customers

. Conducted monthly sales and profitability forecast, and improved the

methodology to provide easier and better planning

H. J. Heinz

Pittsburgh, PA

Supply Chain Finance Intern

June 2006 - August 2006

. Developed a quantitative model with streamline process to rationalize 10%

of the underperforming SKUs from Heinz's product portfolio of over 5000

SKUs across 34 product groups

. Communicated and presented the SKU rationalization methodology to higher

management and brand managers

. Led a multi-functional initiative to reengineer capital report process

within 40 manufacturing facilities and headquarter

. Designed an Access database for over $100 million capital to achieve data

synchronization, 60% accuracy improvement, and 50% reduction in labor

requirement

EDUCATION

Case Western Reserve University, Weatherhead School of Management

Cleveland, OH

Master of Science in Management - Supply Chain Management; GPA 3.88/4.0

May 2007

. Merit based tuition scholarship, Community service award and teaching

assistant

South China University of Technology

Guangzhou, China

Bachelor of Economics - International Economics and Trade

June 2005

SKILLS

. Advanced MS Excel, MS Access, and MS Visio

. Proficiency in use of Oracle and Mainframe(DB2)

. Knowledge of SAS and SQL programming and statistical modeling

Contact this candidate