Data Analyst/Supply Chain/Program manager

Bei Wang

Boston MA 617-***-**** ****.****@*****.***.***

Professional Experience

TVision Insights(A Tech Start-up), Boston, MA Nov 2015 – Feb 2017 Operations Analyst

§ Extracted and integrated raw second to second data into structured data using SQL/R and encapsulated the program to do automated analysis based on self-defined metrics.

§ Collected viewers’ demographics, emotional reactions, and viewability/engagement by placing a sensor at the base of a television in a household measure and audience behavior in the real TV viewing environment.

§ Maintained and monitored system functionality in 1000+ panel households deployed in Boston and Chicago. Enhanced online system rate from 85% to 95%.

§ Designed and delivered reports of Key Performance Indicators(KPI) by analyzing and summarizing data information. Documented the methods of calculating every indicator and designed the standardized reports template for teams.

§ Manipulated raw data into graphs and tables. Visualized data analysis results using Tableau.

§ Identified potential system issues to provide equipment quality and troubleshooted with third party and Engineer team.

§ Worked independently on multiple projects simultaneously to meet dead lines.

§ Attended/hosted daily stand up meeting for agile team, took/updated status from team.

§ Attended bi-weekly preplanning and planning meeting for agile team.

§ Developed SQL queries to check the database automatically and check the data integrity in according with business standards of the company.

§ Extensively worked on back-end for fixing data and removing unwanted data.

§ Created data marts for the various scenarios to support regulatory requirements.

§ Created new database structure and fed load for new data source.

§ Assisted Business Analysts in data analysis process by fine tuning various queries.

§ Analyzed requirements given by business and created system requirements.

§ Assisted quality assurance in designing, developing and testing the assigned stories for current sprint.

§ Monitored and analyzed the data during executing the tests to find the performance bottlenecks and provide risks and recommendations for possible tuning opportunities.

§ Researched and documented software defects in an issue tracking system. Angstrom Advanced, Boston, MA Jun 2015 – Sep 2015

Business Analyst

§ Created a dataset including 500+ private equity investment companies and maintained customer relationship. Education

Northeastern University, Boston, MA Sep 2013 – May 2015 Master of Science in Engineering Management, GPA: 3.56 Courses: Operation Research, Probability and Statistics, Project Management, Supply Chain, Lean Concept Application Beijing Forestry University, Beijing, China Sep 2009 – June 2013 Bachelor of Science in Electronic Information Science and Technology Courses: Advanced Mathematics, Linear Algebra, Computer Applications, Information Acquisition, C Language Technical Skills

Data analysis, Data Visualization, Project Management, Supply Chain/Operations Management Language: SQL, R, C, Visual Basics

Tools: SQL Server, MySQL, Git, JIRA, Confluence, Tableau, Microsoft Project, Excel (Advanced), Visio Research and Projects

Bike Sharing – Missing data imputation April 2017

§ Compared different methods of imputing missing data like listwise deletion, pairwise deletion, mean imputation, last value carried forward, linear interpolation, polynomial interpolation, deterministic/random regression imputation.

§ Visualized imputation methods listed above and regression predicted values. Lean Applications in Carl Zeiss Case Study Dec 2014

§ Researched a study case of planning labor requirements efficiently problem caused by variety of shipments numbers.

§ Designed the current state using Value Stream Map to evaluate the performance of the process, successfully found out the Non-value added process.

Contact this candidate