Zimeng (Lexi) Wang

530-***-**** ada7ay@r.postjobfree.com www.linkedin.com/in/zimeng-wang

EDUCATION

Brandeis University International Business School Waltham, MA Candidate for Master of Science in Business Analytics (STEM-Designated) 08/2018 – 12/2019 Honor: Regional Merit Scholarships (16% tuition)

Activity: Data Analytics Club (President)

Related Coursework: Marketing Analytics, Digital Marketing, Information Visualization, Econometrics, Analyzing Big Data, Healthcare Data Analytics

University of California, Davis Davis, CA

Bachelor of Science, double major in Managerial Economics and Statistics 09/2014 – 06/2018 Honor: Dean’s Honor in 6 out of 12 quarters Overall GPA: 3.5/ 4.0 PROFESSIONAL EXPERIENCE

ABclonal Technology Woburn, MA

Business Analyst Intern 09/2019 – present

• Work with the sales operation team to manage the customized opportunity fields and workflows on Salesforce CRM; Upload price book and product information for over 20,000 items via Dataloader

• Develop and maintain Salesforce Reports and Dashboards for analyzing the performance of business development representatives

• Evaluate assumptions and data on shipping, labor and product cost for fitting a better ROI model

• Improve the email campaign by using A/B testing on the Salesloft email cadence response rate data

• Introduce multi-criteria decision-making model to identify University Research labs (B2C) and biotech companies (B2B) that have the greatest partnership potential by performing quantitative data analysis Micromeritics Instrument Corporation Norcross, GA

Forecasting Analyst Intern 06/2019 – 08/2019

• Performed time series analysis and fit forecasting models based on 4 different methods (ARIMA, Holt/Winter Filter, VAR and Prophet) to predict quarterly sales revenue of popular products in R, which controls inaccuracy rate from 15% to 10% range

• Wrote queries to organize the internal database for ERP department and customize data reports to meet customers’ needs by implementing SQL and Syteline

Ironsides Technology Westford, MA

Business Analyst Intern 07/2018 – 09/2018

• Developed ETL processes and generated data analytics reports through Tableau dashboard to assist customers in visualizing sales results of a major Automated Production Tracking (APT) ™ software product

• Played an internal role in building a new business partnership by assembling sales materials for marketing executives and promoting brand awareness at major Tech Expo ACADEMIC RESEARCH PROJECTS

Brandeis University International Business School Waltham, MA Healthcare Insurance Claim Data Analysis 01/2019 – 03/2019

• Conducted clustering analysis on DRG (diagnosis-related groups) based on the associated charges of PCCR

(primary cost center) using the k-means method through R; Detected the relationship between the cost level of diseases and treatment means by achieving data visualization in Tableau

• Applied data wrangling process on drug overdose data with over 1GB size in order to evaluate the performance of Medicare’s benefits package based on Use of Opioids at High Dosage rate SKILLS & LEADERSHIP ACTIVITIES

Computer Skills R (ggplot2, dplyr, plotly, shiny, ggvis, tidyverse, rmarkdown), Python (NumPy, Pandas, Scikit-learn), SQL, Salesforce CRM, Tableau, SalesLoft, Teradata, JIRA, Microsoft Office Suite Languages Mandarin (Native), English (Fluent) and Korean (Beginner)

Contact this candidate