韩梦茹 Email & Phone Number

中国 上海市

● HR data platform construction (20% of the workload)1.Sort out the underlying data structure and business logic of human resources, establish and manage human resources data system2.Promote HR data platform construction, ensure data quality and stability, standardize data standards, improve data acquisition efficiency3.Unified data caliber, reduce internal communication costs● Set up HR dashboard system (70% of the workload)1.From 0 to 1, set up the human resource data analysis index system, output visual reports of each module, and realize data automation2.According to company's actual business and industry data, establish the data diagnosis model, evaluate the health of the organization, timely capture the abnormal human operation, and provide quantitative reference standards for management decisions3.Regularly write special reports based on company strategy and business needs to drive business growth and improve human efficiency through human resource management● Develop data products (10% of work)1.Data measurement tools (e.g., performance data measurement tools, which measure individual/organizational performance according to the company's performance scoring standards)2.Excel tools (customized tools for table splitting and table merging, etc.)

上海

● Develop the key projects of the company independently, such as Polaris system, Python ETL project, Tableau HR dashboard project, please refer to the project experience for details● Build and maintain HR data center through MYSQL database, integrate data resources from multiple departments, including HR, sales, profit etc.● Set up HR dashboard system to monitor personnel management status and sales performance of the company, and predict personnel development trend and sales performance of 80,000 sales consultants based on historical data● Collaborate with strategic planning department and IT department to establish the intelligent analysis system, and standardize personnel data caliber of relevant departments● Be in charge of the headquarter C&B work, guide and assist the staff of nine subordinate branches to ensure the smooth implementation of C&B work

中国 上海

● Be responsible for the operation of onboarding-transfer-termination end to end, assist business to implement reorganization and deal with employee relations● Monitor the data consistency between Workday and SAP system, output data differentiation reports and ensure the accuracy of personnel data● Cooperate with Alibaba to build Roche Robot platform to realize online self-help Q&A for employees● Build ETL workflow through SQL Server database, use KNIME and Python to optimize HR operation

中国 上海

● Regularly present visual sales reports to general manager and monitor the sales performance of the company ● Provide technical support to the clients of banks and insurers, manage and maintain the Oracle database of the clients● Establish attendance system through SQL Server database and export visual attendance reports regularly ● Excellent Excel skills, provide technical support to non-technical colleagues, such as finance, HR, administration etc.

硕士, Pharmaceutical Engineer

学士, Material Chemistry

学士, Finance（Second Major）