Customer Sales

Mengjia(Kira) Wei

585-***-**** • acrmvk@r.postjobfree.com • Linkedin: http://linkedin.com/in/mengjiawei EDUCATION

SIMON BUSINESS SCHOOL, University of Rochester - Rochester, NY June 2015 Master of Science in Business Administration - Marketing Analytics Club memberships: Simon Pricing Club member, Simon Marketing Association member EXPERIENCE

The Formkey, LLC. - Rochester, NY Jun. – Aug. 2015 Pricing and Data Analysis Intern (Tool: SQL, R, Tableau) The Formkey, LLC. is a legal and regulatory services tech company that uses data driven and computer based solutions to help Americans do the regulatory paperwork to update their information after moving across the states.

Developed algorithm for screening target customers on Twitter. Successfully included 3000+ potential customers into our customer database.

Conducted customer segmentation based on demographic, geographic and psychographic information. Created Tableau dashboard to visualize results for the sales team.

Identified new pricing approaches for the service fee. Constructed a dynamic pricing quoting system in collaboration with a computer engineer.

Fillshift, INC. - Rochester, NY Jun. – Aug. 2015

Data Analyst Intern (Part-time)

Fillshift, INC. is a technology company that develops scheduling software for nurses to use that can meet the complex demands of filling shifts in the healthcare industry

Designed survey and analyzed data from customer database and survey results to understand the relationship between nurse retention rate, healthcare quality and the usage of workforce management software. Developed white paper to publicize the findings in the professional media platform.

Conducted statistics on the nurse utilization data that were stored in the software database, and reported to the nurse manager monthly for them to understand how nurses were using this software. Outer Space Online Apparel - Rochester, NY (Project) Mar. – May. 2015 Dynamic Pricing Consultant (Tool: Excel solver)

Outer Space Online Apparel is a private online fashion store based in Taiwan.

Implemented price experiment to provide price optimization recommendations week by week throughout a whole sales season.

Provided recommendations for mark-down strategy, including optimal price-cut timing and depth of the proposed markdown with the goal of maximizing gross margins.

Successfully sold out all the 2000 units inventory by the end of 12 weeks with profit of $116830 Across China, INC – Rochester, NY Oct. – Jan. 2015 Product Marketing Intern (Tool: R, Excel)

Performed as a consultant for the battery department to deploy product and marketing expansion strategy for a quick-charging screwdriver by implementing marketing research and customer data analysis.

Conducted customer segmentation developing different product profiles development and marketing campaigns.

Designed on product menu including service content and price strategy to attract different groups of consumers. Alibaba.com - Beijing, China Feb. – Jul. 2012

Online Marketing Specialist

Performed inventory management; seasonal forecasting; customer relation management and trend analysis. National Institute of Science - Beijing, China Jul. 2012 – Jun. 2014 Data Statistics Researcher, Behavioral Psychology Department (Tool: SPSS, Excel)

Made statistics on the experiment data to draw supportive conclusion for the academic papers hypothesis.

Assisted senior researchers with academic articles search, translation and participated in panel discussions. PROFESSIONAL SKILLS

Analytical Tools: SQL; Tableau; R; Excel; SPSS; Google Analytics; Nvivo Analytics Specialties: Regression; Break-even Analysis; Conjoint Analysis, Customer Segmentation, Predictive Model, Correlative and Causal Relation Analysis; Market Share and Profit Prediction Pricing Strategy: Value-based Pricing; B2B Pricing; Price Elasticity; Price Function Prediction; Group Pricing; Tie- in Strategy; Menu Pricing; Markdown; Price Under Demand Uncertainty; Pricing Under Capacity Constraint Language Proficiency: Mandarin (native); English (proficient)

Contact this candidate