Ruohan Liu Email & Phone Number

The Hague, Zh, Nl

尼德兰 北荷兰 阿姆斯特丹

Support IT Platform & Security department to build PowerBI Dashboard and give insights to control the budget on Azure.

尼德兰 南荷兰省 海牙

尼德兰 格罗宁根省

-Worked as a data research assistant to assist the research project including Text Analysis, Natural Language Modelling, and Data Analysis. Assisted the researcher in data mining, data processing, and data visualization. -Conducted data preprocessing using Pandas and Python to investigate the correlation between user information and Twitter content; Quantified and visualized the results by making use of Matplotlib to discover the insights for content management.-Spearheaded comment-based "Natural Language Modeling" project to investigate the date trends and correlation between customer profile and sales revenue of the company; Conducted data cleaning, filled in missing values, and removed deactivated words with Python to enhance data quality.-Executed the "Global Steam Platform Weekly Ranking Data Analysis" project to capture dynamic global weekly rankings data for the Steam platform, and investigated the relationship between the downloads and categories by region to provide insights on promotion.

中国 吉林省 长春

-Assisted management team with internal & external data management, including budget control, KPI monitoring, and business reporting. -Managed and ensure the timely update of the talent pool database where recording candidate information and company’s input & feedback.-Liaised with other teams to scientifically coordinate all resources, including venues, equipment, props, etc., to ensure smooth production flow.-Responsible for budgetary control, compared actual expenditures and budgeted expenditures over 30+ projects, analyzed and corrected variations using Excel. -Optimized raw data processing for viewership metrics, categorized and reported data over time to management teams. Enhanced category and timeline management to improve key performance indicators (KPIs).-Developed and continuously improved clear dashboards for budgetary control and KPI monitoring by making use of Tableau/Power BI, as well as resolved incidents around dashboards and reports; -Result: Achieved optimal allocation of resources, and shortened the production cycle from an average of 8 months to 5 months, achieving a 37.5% reduction in production time.-Reported Budget vs. Cost discrepancies to the management team and conducted early studies to identify problems, thereby assisting the management team in making rational decisions regarding the next steps.-Supported advertising, publicity, and promotion departments in crafting a comprehensive promotion strategy aimed at amplifying the project's exposure and appeal.

-Built strong relationships with students and parents. Assisted students in selecting appropriate schools and majors and developed personalized international education plans based on their interests, skills, and future career goals.-Managed multiple international education application programs and assisted students in preparing application materials, including personal statements, letters of recommendation, and application forms. Assisted students in preparing for IELTS, TOEFL, and maintained a high-quality database of school and university information.-Provided advice on the visa process, accommodation arrangements, and living accommodations, and met regularly with students and parents to provide progress updates and answer questions.

-Delivered customized IELTS training utilizing a distinctive teaching methodology that has yielded an average score improvement of 1.5 IELTS band points, with 80% of students achieving the required IELTS scores.-Crafted individualized learning plans for each student, emphasizing oral expression, vocabulary, and grammar proficiency. As a result, 90% of students demonstrated substantial enhancements in their speaking and writing skills.

Master'S Degree, Communication And Information Studies ( Digital Humantities )

-Learned the fundamentals of data processing, data cleansing and datatransformation, and practised core data engineering skills.

Bachelor'S Degree, Film And Television Director

-Proficient in video editing software such as Adobe Premiere Pro, Final Cut Pro, and image processing tools such as Adobe Photoshop.

Exchange Student, Business Communication, 94.3/100

•English lecturer •SWAT analysis model •International Companies Research